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. Integer
3 Customer No. Code20
4 Posting Date Date
5 Document Type Option
6 Document No. Code20
7 Description Text50
11 Currency Code Code10
13 Amount Decimal Editable: No
FlowField
14 Remaining Amount Decimal Editable: No
FlowField
15 Original Amt. (LCY) Decimal Editable: No
FlowField
16 Remaining Amt. (LCY) Decimal Editable: No
FlowField
17 Amount (LCY) Decimal Editable: No
FlowField
18 Sales (LCY) Decimal
19 Profit (LCY) Decimal
20 Inv. Discount (LCY) Decimal
21 Sell-to Customer No. Code20
22 Customer Posting Group Code20
23 Global Dimension 1 Code Code20
24 Global Dimension 2 Code Code20
25 Salesperson Code Code20
27 User ID Code50
28 Source Code Code10
33 On Hold Code3
34 Applies-to Doc. Type Option
35 Applies-to Doc. No. Code20
36 Open Boolean
37 Due Date Date
38 Pmt. Discount Date Date
39 Original Pmt. Disc. Possible Decimal Editable: No
40 Pmt. Disc. Given (LCY) Decimal
43 Positive Boolean
44 Closed by Entry No. Integer
45 Closed at Date Date
46 Closed by Amount Decimal
47 Applies-to ID Code50
49 Journal Batch Name Code10
50 Reason Code Code10
51 Bal. Account Type Option
52 Bal. Account No. Code20
53 Transaction No. Integer
54 Closed by Amount (LCY) Decimal
58 Debit Amount Decimal BlankZero: Yes
Editable: No
FlowField
59 Credit Amount Decimal BlankZero: Yes
Editable: No
FlowField
60 Debit Amount (LCY) Decimal BlankZero: Yes
Editable: No
FlowField
61 Credit Amount (LCY) Decimal BlankZero: Yes
Editable: No
FlowField
62 Document Date Date
63 External Document No. Code35
64 Calculate Interest Boolean
65 Closing Interest Calculated Boolean
66 No. Series Code20
67 Closed by Currency Code Code10
68 Closed by Currency Amount Decimal
73 Adjusted Currency Factor Decimal (0:15)
74 Original Currency Factor Decimal (0:15)
75 Original Amount Decimal Editable: No
FlowField
76 Date Filter Date FlowFilter
77 Remaining Pmt. Disc. Possible Decimal
78 Pmt. Disc. Tolerance Date Date
79 Max. Payment Tolerance Decimal
80 Last Issued Reminder Level Integer
81 Accepted Payment Tolerance Decimal
82 Accepted Pmt. Disc. Tolerance Boolean
83 Pmt. Tolerance (LCY) Decimal
84 Amount to Apply Decimal
85 IC Partner Code Code20
86 Applying Entry Boolean
87 Reversed Boolean BlankZero: Yes
88 Reversed by Entry No. Integer BlankZero: Yes
89 Reversed Entry No. Integer BlankZero: Yes
90 Prepayment Boolean
172 Payment Method Code Code10
173 Applies-to Ext. Doc. No. Code35
288 Recipient Bank Account Code20
289 Message to Recipient Text140
290 Exported to Payment File Boolean Editable: No
480 Dimension Set ID Integer Editable: No
1200 Direct Debit Mandate ID Code35

Keys

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

Table Relations To Other Tables

Field Related Table Related Field
Bal. Account No. Bank Account No. 1..n
Closed by Currency Code Currency Code 1..n
Reversed Entry No. Cust. Ledger Entry Entry No. 1..n
Bal. Account No. Customer No. 1..n
Recipient Bank Account Customer Bank Account Code 1..n
Customer Posting Group Customer Posting Group Code 1..n
Dimension Set ID Dimension Set Entry 1..n
Global Dimension 2 Code Dimension Value Code 1..n
Bal. Account No. Fixed Asset No. 1..n
Bal. Account No. G/L Account No. 1..n
IC Partner Code IC Partner Code 1..n
No. Series No. Series Code 1..n
Payment Method Code Payment Method Code 1..n
Reason Code Reason Code Code 1..n
Direct Debit Mandate ID SEPA Direct Debit Mandate ID 1..n
Salesperson Code Salesperson/Purchaser Code 1..n
Source Code Source Code Code 1..n
Bal. Account No. Vendor No. 1..n

Table Relations From Other Tables

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