Table 21 Cust. Ledger Entry

Base Application, Microsoft.Sales.Receivables

91 fields

IdNameTypeVersions
1Entry No.Integer17-29
3Customer No.Code[20]17-29
4Posting DateDate17-29
5Document TypeEnum "Gen. Journal Document Type"17-29
6Document No.Code[20]17-29
7DescriptionText[100]17-29
8Customer NameText[100]17-29
10Your ReferenceText[35]new in 22
11Currency CodeCode[10]17-29
13AmountDecimal17-29
14Remaining AmountDecimal17-29
15Original Amt. (LCY)Decimal17-29
16Remaining Amt. (LCY)Decimal17-29
17Amount (LCY)Decimal17-29
18Sales (LCY)Decimal17-29
19Profit (LCY)Decimal17-29
20Inv. Discount (LCY)Decimal17-29
21Sell-to Customer No.Code[20]17-29
22Customer Posting GroupCode[20]17-29
23Global Dimension 1 CodeCode[20]17-29
24Global Dimension 2 CodeCode[20]17-29
25Salesperson CodeCode[20]17-29
27User IDCode[50]17-29
28Source CodeCode[10]17-29
33On HoldCode[3]17-29
34Applies-to Doc. TypeEnum "Gen. Journal Document Type"17-29
35Applies-to Doc. No.Code[20]17-29
36OpenBoolean17-29
37Due DateDate17-29
38Pmt. Discount DateDate17-29
39Original Pmt. Disc. PossibleDecimal17-29
40Pmt. Disc. Given (LCY)Decimal17-29
42Orig. Pmt. Disc. Possible(LCY)Decimalnew in 20
43PositiveBoolean17-29
44Closed by Entry No.Integer17-29
45Closed at DateDate17-29
46Closed by AmountDecimal17-29
47Applies-to IDCode[50]17-29
48Journal Templ. NameCode[10]new in 20
49Journal Batch NameCode[10]17-29
50Reason CodeCode[10]17-29
51Bal. Account TypeEnum "Gen. Journal Account Type"17-29
52Bal. Account No.Code[20]17-29
53Transaction No.Integer17-29
54Closed by Amount (LCY)Decimal17-29
58Debit AmountDecimal17-29
59Credit AmountDecimal17-29
60Debit Amount (LCY)Decimal17-29
61Credit Amount (LCY)Decimal17-29
62Document DateDate17-29
63External Document No.Code[35]17-29
64Calculate InterestBoolean17-29
65Closing Interest CalculatedBoolean17-29
66No. SeriesCode[20]17-29
67Closed by Currency CodeCode[10]17-29
68Closed by Currency AmountDecimal17-29
73Adjusted Currency FactorDecimal17-29
74Original Currency FactorDecimal17-29
75Original AmountDecimal17-29
76Date FilterDate17-29
77Remaining Pmt. Disc. PossibleDecimal17-29
78Pmt. Disc. Tolerance DateDate17-29
79Max. Payment ToleranceDecimal17-29
80Last Issued Reminder LevelInteger17-29
81Accepted Payment ToleranceDecimal17-29
82Accepted Pmt. Disc. ToleranceBoolean17-29
83Pmt. Tolerance (LCY)Decimal17-29
84Amount to ApplyDecimal17-29
85IC Partner CodeCode[20]17-29
86Applying EntryBoolean17-29
87ReversedBoolean17-29
88Reversed by Entry No.Integer17-29
89Reversed Entry No.Integer17-29
90PrepaymentBoolean17-29
95G/L Register No.Integernew in 29
171Payment ReferenceCode[50]17-29
172Payment Method CodeCode[10]17-29
173Applies-to Ext. Doc. No.Code[35]17-29
288Recipient Bank AccountCode[20]17-29
289Message to RecipientText[140]17-29
290Exported to Payment FileBoolean17-29
480Dimension Set IDInteger17-29
481Shortcut Dimension 3 CodeCode[20]17-29
482Shortcut Dimension 4 CodeCode[20]17-29
483Shortcut Dimension 5 CodeCode[20]17-29
484Shortcut Dimension 6 CodeCode[20]17-29
485Shortcut Dimension 7 CodeCode[20]17-29
486Shortcut Dimension 8 CodeCode[20]17-29
1200Direct Debit Mandate IDCode[35]17-29
1340Dispute StatusCode[10]new in 24
1341Promised Pay DateDatenew in 24