Diagrams

Table

Detailed Cust. Ledg. Entry

DynamicsDocs.comDetailed Cust. Ledg. Entry«Table 379»Detailed Cust. Ledg. EntryEntry No. [PK]Cust. Ledger Entry No.Entry Type; [,Initial Entry,Applicatio...Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.AmountAmount [LCY]Customer No.Currency CodeUser IDSource CodeTransaction No.Journal Batch NameReason CodeDebit AmountCredit AmountDebit Amount [LCY]Credit Amount [LCY]Initial Entry Due DateInitial Entry Global Dim. 1Initial Entry Global Dim. 2Gen. Bus. Posting GroupGen. Prod. Posting GroupUse TaxVAT Bus. Posting GroupVAT Prod. Posting GroupInitial Document Type; [,Payment,Invoi...Applied Cust. Ledger Entry No.UnappliedUnapplied by Entry No....«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 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 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 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«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 250»Gen. Business Posting GroupCode [PK,NN]DescriptionDef. VAT Bus. Posting GroupAuto Insert Default«Table 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«Table 323»VAT Business Posting GroupCode [PK,NN]Description«Table 324»VAT Product Posting GroupCode [PK,NN]Description«Table 320»Tax JurisdictionCode [PK,NN]DescriptionTax Account [Sales]Tax Account [Purchases]Report-to JurisdictionDate FilterTax Group FilterUnreal. Tax Acc. [Sales]Unreal. Tax Acc. [Purchases]Reverse Charge [Purchases]Unreal. Rev. Charge [Purch.]Unrealized VAT Type; [,Percentage,Firs...Calculate Tax on TaxAdjust for Payment Discount<Cust. Ledger Entry No.><Customer No.><Currency Code><User ID><Source Code><Reason Code><Initial Entry Global Dim. 1><Initial Entry Global Dim. 2><Gen. Bus. Posting Group><Gen. Prod. Posting Group><VAT Bus. Posting Group><VAT Prod. Posting Group><Unapplied by Entry No.><Tax Jurisdiction Code><Customer No.><Sell-to Customer No.><Bal. Account No.><Currency Code><Closed by Currency Code><Global Dimension 1 Code><Global Dimension 2 Code><Source Code><Closed by Entry No.><Reversed by Entry No.><Reversed Entry No.><Reason Code><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Currency Code><Currency Filter><Customer Filter><Bill-to Customer No.><Gen. Bus. Posting Group><VAT Bus. Posting Group><Global Dimension 1 Filter><Global Dimension 2 Filter><Def. VAT Bus. Posting Group><Def. VAT Prod. Posting Group><Report-to Jurisdiction>

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
2 Cust. Ledger Entry No. (Cust. Ledger Entry No.) Integer
3 Entry Type (Entry Type) Option
4 Posting Date (Posting Date) Date
5 Document Type (Document Type) Option
6 Document No. (Document No.) Code20
7 Amount (Amount) Decimal
8 Amount (LCY) (Amount (LCY)) Decimal
9 Customer No. (Customer No.) Code20
10 Currency Code (Currency Code) Code10
11 User ID (User ID) Code50
12 Source Code (Source Code) Code10
13 Transaction No. (Transaction No.) Integer
14 Journal Batch Name (Journal Batch Name) Code10
15 Reason Code (Reason Code) Code10
16 Debit Amount (Debit Amount) Decimal BlankZero: Yes
17 Credit Amount (Credit Amount) Decimal BlankZero: Yes
18 Debit Amount (LCY) (Debit Amount (LCY)) Decimal BlankZero: Yes
19 Credit Amount (LCY) (Credit Amount (LCY)) Decimal BlankZero: Yes
20 Initial Entry Due Date (Initial Entry Due Date) Date
21 Initial Entry Global Dim. 1 (Initial Entry Global Dim. 1) Code20
22 Initial Entry Global Dim. 2 (Initial Entry Global Dim. 2) Code20
24 Gen. Bus. Posting Group (Gen. Bus. Posting Group) Code10
25 Gen. Prod. Posting Group (Gen. Prod. Posting Group) Code10
29 Use Tax (Use Tax) Boolean
30 VAT Bus. Posting Group (VAT Bus. Posting Group) Code10
31 VAT Prod. Posting Group (VAT Prod. Posting Group) Code10
35 Initial Document Type (Initial Document Type) Option
36 Applied Cust. Ledger Entry No. (Applied Cust. Ledger Entry No.) Integer
37 Unapplied (Unapplied) Boolean
38 Unapplied by Entry No. (Unapplied by Entry No.) Integer
39 Remaining Pmt. Disc. Possible (Remaining Pmt. Disc. Possible) Decimal
40 Max. Payment Tolerance (Max. Payment Tolerance) Decimal
41 Tax Jurisdiction Code (Tax Jurisdiction Code) Code10 Editable: No
42 Application No. (Application No.) Integer Editable: No
43 Ledger Entry Amount (Ledger Entry Amount) Boolean Editable: No

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Cust. Ledger Entry No.,Posting Date (Cust. Ledger Entry No.,Posting Date)
2 Cust. Ledger Entry No.,Entry Type,Posting Date (Cust. Ledger Entry No.,Entry Type,Posting Date) MaintainSQLIndex: No
3 Ledger Entry Amount,Cust. Ledger Entry No.,Posting Date (Ledger Entry Amount,Cust. Ledger Entry No.,Posting Date) MaintainSQLIndex: No
MaintainSIFTIndex: No
4 Initial Document Type,Entry Type,Customer No.,Currency Code,Initial Entry Global Dim. 1,Initial Entry Global Dim. 2,Posting Date (Initial Document Type,Entry Type,Customer No.,Currency Code,Initial Entry Global Dim. 1,Initial Entry Global Dim. 2,Posting Date) MaintainSIFTIndex: No
5 Customer No.,Currency Code,Initial Entry Global Dim. 1,Initial Entry Global Dim. 2,Initial Entry Due Date,Posting Date (Customer No.,Currency Code,Initial Entry Global Dim. 1,Initial Entry Global Dim. 2,Initial Entry Due Date,Posting Date)
6 Document No.,Document Type,Posting Date (Document No.,Document Type,Posting Date)
7 Applied Cust. Ledger Entry No.,Entry Type (Applied Cust. Ledger Entry No.,Entry Type)
8 Transaction No.,Customer No.,Entry Type (Transaction No.,Customer No.,Entry Type)
9 Application No.,Customer No.,Entry Type (Application No.,Customer No.,Entry Type)

Table Relations To Other Tables

Field Related Table Related Field
Currency Code (Currency Code) Currency Code (Code) 1..n
Cust. Ledger Entry No. (Cust. Ledger Entry No.) Cust. Ledger Entry Entry No. (Entry No.) 1..n
Customer No. (Customer No.) Customer No. (No.) 1..n
Unapplied by Entry No. (Unapplied by Entry No.) Detailed Cust. Ledg. Entry Entry No. (Entry No.) 1..n
Initial Entry Global Dim. 2 (Initial Entry Global Dim. 2) Dimension Value Code (Code) 1..n
Gen. Bus. Posting Group (Gen. Bus. Posting Group) Gen. Business Posting Group Code (Code) 1..n
Gen. Prod. Posting Group (Gen. Prod. Posting Group) Gen. Product Posting Group Code (Code) 1..n
Reason Code (Reason Code) Reason Code Code (Code) 1..n
Source Code (Source Code) Source Code Code (Code) 1..n
Tax Jurisdiction Code (Tax Jurisdiction Code) Tax Jurisdiction Code (Code) 1..n
User ID (User ID) User User Name (User Name) 1..n
VAT Bus. Posting Group (VAT Bus. Posting Group) VAT Business Posting Group Code (Code) 1..n
VAT Prod. Posting Group (VAT Prod. Posting Group) VAT Product Posting Group Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Detailed Cust. Ledg. Entry Unapplied by Entry No. (Unapplied by Entry No.) 1..n