Diagrams


Table

Cust. Ledger Entry

DynamicsDocs.comCust. Ledger Entry«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 1053»Line Fee Note on Report Hist.Cust. Ledger Entry No [PK]Due Date [PK]Language Code [PK,NN]Reminder Terms Code [PK]Reminder Level No [PK]ReportText [NN]«Table 1293»Payment Application ProposalBank Account No. [PK]Statement No. [PK]Statement Line No. [PK]Statement Type; [Bank Reconciliation,P...Account Type; [G/L Account,Customer,Ve...Account No. [PK]Applies-to Entry No. [PK]Applied AmountAppliedApplied Pmt. DiscountQualityPosting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeDue DateExternal Document No.Match Confidence; [None,Low,Medium,Hig...Pmt. Disc. Due DateRemaining Pmt. Disc. PossiblePmt. Disc. Tolerance DateApplied Amt. Incl. DiscountRemaining AmountRemaining Amt. Incl. DiscountType; [Bank Account Ledger Entry,Check...Sorting OrderStmt To Rem. Amount Difference«Table 5475»Sales Invoice Entity AggregateDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No. [NN]No. [PK]Your ReferencePosting DatePayment Terms CodeDue DateShipment Method CodeCustomer Posting GroupCurrency CodePrices Including VATSalesperson CodeOrder No.Recalculate Invoice Disc.AmountAmount Including VATVAT Registration No.Sell-to Customer NameSell-to AddressSell-to Address 2Sell-to CitySell-to ContactSell-to Post CodeSell-to CountySell-to Country/Region CodeDocument DateExternal Document No.Tax Area CodeTax LiableVAT Bus. Posting GroupInvoice Discount Calculation; [None,%,......«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 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 AccountDescriptionUsed in CustomersUsed in Ledger Entries«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 Modified Date TimeLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit 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 413»IC PartnerCode [PK,NN]NameCurrency CodeInbox Type; [File Location,Database,Em...Inbox DetailsReceivables AccountPayables AccountBlockedCommentCustomer No.Vendor No.Outbound Sales Item No. Type; [Interna...Outbound Purch. Item No. Type; [Intern...Cost Distribution in LCYAuto. Accept Transactions«Table 289»Payment MethodCode [PK,NN]DescriptionBal. Account Type; [G/L Account,Bank A...Bal. Account No.Direct DebitDirect Debit Pmt. Terms CodePmt. Export Line DefinitionBank Data Conversion Pmt. TypeUse for InvoicingLast Modified Date TimeId«Table 287»Customer Bank AccountCustomer No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityPost CodeContactPhone No.Telex No.Bank Branch No.Bank Account No.Transit No.Currency CodeCountry/Region CodeCountyFax No.Telex Answer BackLanguage CodeE-MailHome PageIBANSWIFT CodeBank Clearing CodeBank Clearing Standard«Table 1230»SEPA Direct Debit MandateID [PK]Customer No. [NN]Customer Bank Account Code [NN]Valid FromValid ToDate of Signature [NN]Type of Payment; [OneOff,Recurrent]BlockedExpected Number of DebitsDebit CounterNo. SeriesClosed<Customer No.><Sell-to Customer No.><Bal. Account No.><Customer Posting Group><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.><IC Partner Code><Payment Method Code><Recipient Bank Account><Direct Debit Mandate ID><Cust. Ledger Entry No><Applies-to Entry No.><Cust. Ledger Entry No.><Bank Account No.><Account No.><Account No.><Account No.><Account No.><Account No.><Account No.><Sell-to Customer No.><Customer Id><Customer Posting Group><Customer Posting Group><Bill-to Customer No.><Payment Method Code><Payment Method Id><IC Partner Code><Customer No.><Preferred Bank Account Code><Customer No.><Customer No.><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><Bal. Account No.><Receivables Account><Payables Account><Pay-to Vendor No.><Payment Method Code><Payment Method Id><IC Partner Code><Vendor No.><Vendor No.><Maintenance Vendor No.><Bal. Account No.><Component of Main Asset><Customer Bank Account Code>

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 Customer No. (Customer 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 Editable: No
FlowField
14 Remaining Amount (Remaining Amount) Decimal Editable: No
FlowField
15 Original Amt. (LCY) (Original Amt. (LCY)) Decimal Editable: No
FlowField
16 Remaining Amt. (LCY) (Remaining Amt. (LCY)) Decimal Editable: No
FlowField
17 Amount (LCY) (Amount (LCY)) Decimal Editable: No
FlowField
18 Sales (LCY) (Sales (LCY)) Decimal
19 Profit (LCY) (Profit (LCY)) Decimal
20 Inv. Discount (LCY) (Inv. Discount (LCY)) Decimal
21 Sell-to Customer No. (Sell-to Customer No.) Code20
22 Customer Posting Group (Customer Posting Group) Code20
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) Code20
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 Editable: No
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
Editable: No
FlowField
59 Credit Amount (Credit Amount) Decimal BlankZero: Yes
Editable: No
FlowField
60 Debit Amount (LCY) (Debit Amount (LCY)) Decimal BlankZero: Yes
Editable: No
FlowField
61 Credit Amount (LCY) (Credit Amount (LCY)) Decimal BlankZero: Yes
Editable: No
FlowField
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) Code20
67 Closed by Currency Code (Closed by Currency Code) Code10
68 Closed by Currency Amount (Closed by Currency Amount) Decimal
73 Adjusted Currency Factor (Adjusted Currency Factor) Decimal (0:15)
74 Original Currency Factor (Original Currency Factor) Decimal (0:15)
75 Original Amount (Original Amount) Decimal Editable: No
FlowField
76 Date Filter (Date Filter) Date FlowFilter
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
80 Last Issued Reminder Level (Last Issued Reminder Level) Integer
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
85 IC Partner Code (IC Partner Code) Code20
86 Applying Entry (Applying Entry) Boolean
87 Reversed (Reversed) Boolean BlankZero: Yes
88 Reversed by Entry No. (Reversed by Entry No.) Integer BlankZero: Yes
89 Reversed Entry No. (Reversed Entry No.) Integer BlankZero: Yes
90 Prepayment (Prepayment) Boolean
172 Payment Method Code (Payment Method Code) Code10
173 Applies-to Ext. Doc. No. (Applies-to Ext. Doc. No.) Code35
288 Recipient Bank Account (Recipient Bank Account) Code20
289 Message to Recipient (Message to Recipient) Text140
290 Exported to Payment File (Exported to Payment File) Boolean Editable: No
480 Dimension Set ID (Dimension Set ID) Integer Editable: No
1200 Direct Debit Mandate ID (Direct Debit Mandate ID) Code35

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Customer No.,Posting Date,Currency Code (Customer No.,Posting Date,Currency Code)
2 Customer No.,Currency Code,Posting Date (Customer No.,Currency Code,Posting Date)
3 Document No. (Document No.)
4 External Document No. (External Document No.)
5 Customer No.,Open,Positive,Due Date,Currency Code (Customer No.,Open,Positive,Due Date,Currency Code)
6 Open,Due Date (Open,Due Date)
7 Document Type,Customer No.,Posting Date,Currency Code (Document Type,Customer No.,Posting Date,Currency Code) MaintainSQLIndex: No
MaintainSIFTIndex: No
8 Salesperson Code,Posting Date (Salesperson Code,Posting Date)
9 Closed by Entry No. (Closed by Entry No.)
10 Transaction No. (Transaction No.)
11 Customer No.,Open,Positive,Calculate Interest,Due Date (Customer No.,Open,Positive,Calculate Interest,Due Date)
12 Customer No.,Global Dimension 1 Code,Global Dimension 2 Code,Posting Date,Currency Code (Customer No.,Global Dimension 1 Code,Global Dimension 2 Code,Posting Date,Currency Code)
13 Customer No.,Open,Global Dimension 1 Code,Global Dimension 2 Code,Positive,Due Date,Currency Code (Customer No.,Open,Global Dimension 1 Code,Global Dimension 2 Code,Positive,Due Date,Currency Code)
14 Open,Global Dimension 1 Code,Global Dimension 2 Code,Due Date (Open,Global Dimension 1 Code,Global Dimension 2 Code,Due Date)
15 Document Type,Customer No.,Global Dimension 1 Code,Global Dimension 2 Code,Posting Date,Currency Code (Document Type,Customer No.,Global Dimension 1 Code,Global Dimension 2 Code,Posting Date,Currency Code)
16 Customer No.,Applies-to ID,Open,Positive,Due Date (Customer No.,Applies-to ID,Open,Positive,Due Date)
17 Document Type,Posting Date (Document Type,Posting Date)

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
Reversed Entry No. (Reversed Entry No.) Cust. Ledger Entry Entry No. (Entry No.) 1..n
Bal. Account No. (Bal. Account No.) Customer No. (No.) 1..n
Recipient Bank Account (Recipient Bank Account) Customer Bank Account Code (Code) 1..n
Customer Posting Group (Customer 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
IC Partner Code (IC Partner Code) IC Partner Code (Code) 1..n
No. Series (No. Series) No. Series Code (Code) 1..n
Payment Method Code (Payment Method Code) Payment Method Code (Code) 1..n
Reason Code (Reason Code) Reason Code Code (Code) 1..n
Direct Debit Mandate ID (Direct Debit Mandate ID) SEPA Direct Debit Mandate ID (ID) 1..n
Salesperson Code (Salesperson Code) Salesperson/Purchaser Code (Code) 1..n
Source Code (Source Code) Source Code Code (Code) 1..n
Bal. Account No. (Bal. Account No.) Vendor No. (No.) 1..n

Table Relations From Other Tables

From Table From Field
Applied Payment Entry Applies-to Entry No. (Applies-to Entry No.) 1..n
CV Ledger Entry Buffer Closed by Entry No. (Closed by Entry No.) 1..n
Cash Flow Forecast Entry Source No. (Source No.) 1..n
Credit Transfer Entry Applies-to Entry No. (Applies-to Entry No.) 1..n
Cust. Ledger Entry Reversed Entry No. (Reversed Entry No.) 1..n
Detailed Cust. Ledg. Entry Cust. Ledger Entry No. (Cust. Ledger Entry No.) 1..n
Direct Debit Collection Entry Applies-to Entry No. (Applies-to Entry No.) 1..n
Finance Charge Memo Line Entry No. (Entry No.) 1..n
Issued Fin. Charge Memo Line Entry No. (Entry No.) 1..n
Issued Reminder Line Entry No. (Entry No.) 1..n
Line Fee Note on Report Hist. Cust. Ledger Entry No (Cust. Ledger Entry No) 1..n
Payment Application Proposal Applies-to Entry No. (Applies-to Entry No.) 1..n
Reminder Line Entry No. (Entry No.) 1..n
Reminder/Fin. Charge Entry Customer Entry No. (Customer Entry No.) 1..n
Reversal Entry Entry No. (Entry No.) 1..n
Sales Cr. Memo Entity Buffer Cust. Ledger Entry No. (Cust. Ledger Entry No.) 1..n
Sales Cr.Memo Header Cust. Ledger Entry No. (Cust. Ledger Entry No.) 1..n
Sales Invoice Entity Aggregate Cust. Ledger Entry No. (Cust. Ledger Entry No.) 1..n
Sales Invoice Header Cust. Ledger Entry No. (Cust. Ledger Entry No.) 1..n
Sales Order Entity Buffer Cust. Ledger Entry No. (Cust. Ledger Entry No.) 1..n
Sales Quote Entity Buffer Cust. Ledger Entry No. (Cust. Ledger Entry No.) 1..n