Diagrams

Table

CV Ledger Entry Buffer

DynamicsDocs.comCV Ledger Entry Buffer«Table 382»CV Ledger Entry BufferEntry No. [PK]CV No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeAmountRemaining AmountOriginal Amt. [LCY]Remaining Amt. [LCY]Amount [LCY]Sales/Purchase [LCY]Profit [LCY]Inv. Discount [LCY]Bill-to/Pay-to CV No.CV Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodeSalesperson CodeUser IDSource CodeOn HoldApplies-to Doc. Type; [,Payment,Invoic...Applies-to Doc. No.OpenDue DatePmt. Discount DateOriginal Pmt. Disc. PossiblePmt. Disc. Given [LCY]Positive...«Table 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 4»CurrencyCode [PK,NN]Last Date ModifiedLast Date AdjustedUnrealized Gains Acc.Realized Gains Acc.Unrealized Losses Acc.Realized Losses Acc.Invoice Rounding PrecisionInvoice Rounding Type; [Nearest,Up,Dow...Amount Rounding PrecisionUnit-Amount Rounding PrecisionDescriptionAmount Decimal Places [NN]Unit-Amount Decimal Places [NN]Customer FilterVendor FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterDate FilterCust. Ledg. Entries in FilterCustomer BalanceCustomer Outstanding OrdersCustomer Shipped Not InvoicedCustomer Balance DueVendor Ledg. Entries in FilterVendor BalanceVendor Outstanding OrdersVendor Amt. Rcd. Not InvoicedVendor Balance DueCustomer Balance [LCY]Vendor Balance [LCY]...«Table 92»Customer Posting GroupCode [PK,NN]Receivables AccountService Charge Acc.Payment Disc. Debit Acc.Invoice Rounding AccountAdditional Fee AccountInterest AccountDebit Curr. Appln. Rndg. Acc.Credit Curr. Appln. Rndg. Acc.Debit Rounding AccountCredit Rounding AccountPayment Disc. Credit Acc.Payment Tolerance Debit Acc.Payment Tolerance Credit Acc.Add. Fee per Line Account«Table 349»Dimension ValueDimension Code [PK,NN]Code [PK,NN]NameDimension Value Type; [Standard,Headin...TotalingBlockedConsolidation CodeIndentationGlobal Dimension No.Map-to IC Dimension CodeMap-to IC Dimension Value CodeDimension Value ID«Table 13»Salesperson/PurchaserCode [PK,NN]NameCommission %ImageGlobal Dimension 1 CodeGlobal Dimension 2 CodeE-MailPhone No.Next To-do DateNo. of OpportunitiesEstimated Value [LCY]Calcd. Current Value [LCY]Date FilterNo. of InteractionsCost [LCY]Duration [Min.]Job TitleAction Taken Filter; [,Next,Previous,U...Sales Cycle FilterSales Cycle Stage FilterProbability % FilterCompleted % FilterAvg. Estimated Value [LCY]Avg.Calcd. Current Value [LCY]Contact FilterContact Company FilterCampaign FilterEstimated Value FilterCalcd. Current Value FilterChances of Success % FilterTo-do Status Filter; [Not Started,In P......«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact EmailExchange IdentifierApplication ID«Table 230»Source CodeCode [PK,NN]Description«Table 21»Cust. Ledger EntryEntry No. [PK]Customer No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeAmountRemaining AmountOriginal Amt. [LCY]Remaining Amt. [LCY]Amount [LCY]Sales [LCY]Profit [LCY]Inv. Discount [LCY]Sell-to Customer No.Customer Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodeSalesperson CodeUser IDSource CodeOn HoldApplies-to Doc. Type; [,Payment,Invoic...Applies-to Doc. No.OpenDue DatePmt. Discount DateOriginal Pmt. Disc. PossiblePmt. Disc. Given [LCY]Positive...«Table 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«Table 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeAccount Category; [,Assets,Liabilities...Income/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc.Consol. Credit Acc....«Table 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«Table 270»Bank AccountNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Bank Account No.Transit No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameMin. BalanceBank Acc. Posting GroupCurrency CodeLanguage CodeStatistics GroupOur Contact CodeCountry/Region CodeAmountCommentBlockedLast Statement No.Last Payment Statement No.Last Date ModifiedDate FilterGlobal Dimension 1 Filter...«Table 5600»Fixed AssetNo. [PK]DescriptionSearch DescriptionDescription 2FA Class CodeFA Subclass CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeFA Location CodeVendor No.Main Asset/Component; [,Main Asset,Com...Component of Main AssetBudgeted AssetWarranty DateResponsible EmployeeSerial No.Last Date ModifiedInsuredCommentBlockedPictureMaintenance Vendor No.Under MaintenanceNext Service DateInactiveFA Posting Date FilterNo. SeriesFA Posting GroupAcquiredImage...«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name<CV No.><Bill-to/Pay-to CV No.><Bal. Account No.><Currency Code><Closed by Currency Code><CV Posting Group><Global Dimension 1 Code><Global Dimension 2 Code><Salesperson Code><User ID><Source Code><Closed by Entry No.><Reason Code><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><No. Series><Dimension Set ID><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Customer Posting Group><Currency Code><Currency Filter><Customer Filter><Salesperson Code><Bill-to Customer No.><No. Series><Customer No.><Sell-to Customer No.><Bal. Account No.><Unrealized Gains Acc.><Realized Gains Acc.><Unrealized Losses Acc.><Realized Losses Acc.><Realized G/L Gains Account><Realized G/L Losses Account><Residual Gains Account><Residual Losses Account><Conv. LCY Rndg. Debit Acc.><Conv. LCY Rndg. Credit Acc.><Vendor Filter><Currency Code><Currency Filter><Global Dimension 1 Filter><Global Dimension 2 Filter><Currency Code><Closed by Currency Code><Currency Code><Receivables Account><Service Charge Acc.><Payment Disc. Debit Acc.><Invoice Rounding Account><Additional Fee Account><Interest Account><Debit Curr. Appln. Rndg. Acc.><Credit Curr. Appln. Rndg. Acc.><Debit Rounding Account><Credit Rounding Account><Payment Disc. Credit Acc.><Payment Tolerance Debit Acc.><Payment Tolerance Credit Acc.><Add. Fee per Line Account><Customer Posting Group><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Dimension Value Code><Global Dimension 1 Code><Global Dimension 2 Code><Salesperson Code><Purchaser Code><Our Contact Code><Source Code><Closed by Entry No.><Reversed by Entry No.><Reversed Entry No.><Reason Code><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><No. Series><Dimension Set ID><Pay-to Vendor No.><No. Series><Vendor No.><Maintenance Vendor No.><No. Series><Credit Transfer Msg. Nos.><Direct Debit Msg. Nos.><Component of Main Asset><No. Series>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Entry No. (Entry No.) Integer
3 CV No. (CV No.) Code20
4 Posting Date (Posting Date) Date
5 Document Type (Document Type) Option
6 Document No. (Document No.) Code20
7 Description (Description) Text50
11 Currency Code (Currency Code) Code10
13 Amount (Amount) Decimal
14 Remaining Amount (Remaining Amount) Decimal
15 Original Amt. (LCY) (Original Amt. (LCY)) Decimal
16 Remaining Amt. (LCY) (Remaining Amt. (LCY)) Decimal
17 Amount (LCY) (Amount (LCY)) Decimal
18 Sales/Purchase (LCY) (Sales/Purchase (LCY)) Decimal
19 Profit (LCY) (Profit (LCY)) Decimal
20 Inv. Discount (LCY) (Inv. Discount (LCY)) Decimal
21 Bill-to/Pay-to CV No. (Bill-to/Pay-to CV No.) Code20
22 CV Posting Group (CV Posting Group) Code10
23 Global Dimension 1 Code (Global Dimension 1 Code) Code20
24 Global Dimension 2 Code (Global Dimension 2 Code) Code20
25 Salesperson Code (Salesperson Code) Code10
27 User ID (User ID) Code50
28 Source Code (Source Code) Code10
33 On Hold (On Hold) Code3
34 Applies-to Doc. Type (Applies-to Doc. Type) Option
35 Applies-to Doc. No. (Applies-to Doc. No.) Code20
36 Open (Open) Boolean
37 Due Date (Due Date) Date
38 Pmt. Discount Date (Pmt. Discount Date) Date
39 Original Pmt. Disc. Possible (Original Pmt. Disc. Possible) Decimal
40 Pmt. Disc. Given (LCY) (Pmt. Disc. Given (LCY)) Decimal
43 Positive (Positive) Boolean
44 Closed by Entry No. (Closed by Entry No.) Integer
45 Closed at Date (Closed at Date) Date
46 Closed by Amount (Closed by Amount) Decimal
47 Applies-to ID (Applies-to ID) Code50
49 Journal Batch Name (Journal Batch Name) Code10
50 Reason Code (Reason Code) Code10
51 Bal. Account Type (Bal. Account Type) Option
52 Bal. Account No. (Bal. Account No.) Code20
53 Transaction No. (Transaction No.) Integer
54 Closed by Amount (LCY) (Closed by Amount (LCY)) Decimal
58 Debit Amount (Debit Amount) Decimal BlankZero: Yes
59 Credit Amount (Credit Amount) Decimal BlankZero: Yes
60 Debit Amount (LCY) (Debit Amount (LCY)) Decimal BlankZero: Yes
61 Credit Amount (LCY) (Credit Amount (LCY)) Decimal BlankZero: Yes
62 Document Date (Document Date) Date
63 External Document No. (External Document No.) Code35
64 Calculate Interest (Calculate Interest) Boolean
65 Closing Interest Calculated (Closing Interest Calculated) Boolean
66 No. Series (No. Series) Code10
67 Closed by Currency Code (Closed by Currency Code) Code10
68 Closed by Currency Amount (Closed by Currency Amount) Decimal
70 Rounding Currency (Rounding Currency) Code10
71 Rounding Amount (Rounding Amount) Decimal
72 Rounding Amount (LCY) (Rounding Amount (LCY)) Decimal
73 Adjusted Currency Factor (Adjusted Currency Factor) Decimal
74 Original Currency Factor (Original Currency Factor) Decimal
75 Original Amount (Original Amount) Decimal
77 Remaining Pmt. Disc. Possible (Remaining Pmt. Disc. Possible) Decimal
78 Pmt. Disc. Tolerance Date (Pmt. Disc. Tolerance Date) Date
79 Max. Payment Tolerance (Max. Payment Tolerance) Decimal
81 Accepted Payment Tolerance (Accepted Payment Tolerance) Decimal
82 Accepted Pmt. Disc. Tolerance (Accepted Pmt. Disc. Tolerance) Boolean
83 Pmt. Tolerance (LCY) (Pmt. Tolerance (LCY)) Decimal
84 Amount to Apply (Amount to Apply) Decimal
90 Prepayment (Prepayment) Boolean
480 Dimension Set ID (Dimension Set ID) Integer Editable: No

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Bal. Account No. (Bal. Account No.) Bank Account No. (No.) 1..n
Closed by Currency Code (Closed by Currency Code) Currency Code (Code) 1..n
Closed by Entry No. (Closed by Entry No.) Cust. Ledger Entry Entry No. (Entry No.) 1..n
Bal. Account No. (Bal. Account No.) Customer No. (No.) 1..n
CV Posting Group (CV Posting Group) Customer Posting Group Code (Code) 1..n
Dimension Set ID (Dimension Set ID) Dimension Set Entry () 1..n
Global Dimension 2 Code (Global Dimension 2 Code) Dimension Value Code (Code) 1..n
Bal. Account No. (Bal. Account No.) Fixed Asset No. (No.) 1..n
Bal. Account No. (Bal. Account No.) G/L Account No. (No.) 1..n
No. Series (No. Series) No. Series Code (Code) 1..n
Reason Code (Reason Code) Reason Code Code (Code) 1..n
Salesperson Code (Salesperson Code) Salesperson/Purchaser Code (Code) 1..n
Source Code (Source Code) Source Code Code (Code) 1..n
User ID (User ID) User User Name (User Name) 1..n
Bal. Account No. (Bal. Account No.) Vendor No. (No.) 1..n

Table Relations From Other Tables

From Table From Field