Objects/Tables/Table 21 Cust. Ledger Entry

Table 21 Cust. Ledger Entry in 21

Jonas Paprotka, Base Application 21.5.53619.63803, checked 2026-09-20

App: Base Application

Fields, 87 Keys, 24 Procedures, 15 Events, 12

Versions17 18 19 202122 23 24 25 26 27 28 latest

Source29

Fields, 87

Id	Name	Type	Obsolete
1	Entry No.	Integer	-
3	Customer No.	Code[20]	-
4	Posting Date	Date	-
5	Document Type	Enum Gen. Journal Document Type	-
6	Document No.	Code[20]	-
7	Description	Text[100]	-
8	Customer Name	Text[100]	-
11	Currency Code	Code[10]	-
13	Amount	Decimal	-
14	Remaining Amount	Decimal	-
15	Original Amt. (LCY)	Decimal	-
16	Remaining Amt. (LCY)	Decimal	-
17	Amount (LCY)	Decimal	-
18	Sales (LCY)	Decimal	-
19	Profit (LCY)	Decimal	-
20	Inv. Discount (LCY)	Decimal	-
21	Sell-to Customer No.	Code[20]	-
22	Customer Posting Group	Code[20]	-
23	Global Dimension 1 Code	Code[20]	-
24	Global Dimension 2 Code	Code[20]	-
25	Salesperson Code	Code[20]	-
27	User ID	Code[50]	-
28	Source Code	Code[10]	-
33	On Hold	Code[3]	-
34	Applies-to Doc. Type	Enum Gen. Journal Document Type	-
35	Applies-to Doc. No.	Code[20]	-
36	Open	Boolean	-
37	Due Date	Date	-
38	Pmt. Discount Date	Date	-
39	Original Pmt. Disc. Possible	Decimal	-
40	Pmt. Disc. Given (LCY)	Decimal	-
42	Orig. Pmt. Disc. Possible(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	Code[50]	-
48	Journal Templ. Name	Code[10]	-
49	Journal Batch Name	Code[10]	-
50	Reason Code	Code[10]	-
51	Bal. Account Type	Enum Gen. Journal Account Type	-
52	Bal. Account No.	Code[20]	-
53	Transaction No.	Integer	-
54	Closed by Amount (LCY)	Decimal	-
58	Debit Amount	Decimal	-
59	Credit Amount	Decimal	-
60	Debit Amount (LCY)	Decimal	-
61	Credit Amount (LCY)	Decimal	-
62	Document Date	Date	-
63	External Document No.	Code[35]	-
64	Calculate Interest	Boolean	-
65	Closing Interest Calculated	Boolean	-
66	No. Series	Code[20]	-
67	Closed by Currency Code	Code[10]	-
68	Closed by Currency Amount	Decimal	-
73	Adjusted Currency Factor	Decimal	-
74	Original Currency Factor	Decimal	-
75	Original Amount	Decimal	-
76	Date Filter	Date	-
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	Code[20]	-
86	Applying Entry	Boolean	-
87	Reversed	Boolean	-
88	Reversed by Entry No.	Integer	-
89	Reversed Entry No.	Integer	-
90	Prepayment	Boolean	-
171	Payment Reference	Code[50]	-
172	Payment Method Code	Code[10]	-
173	Applies-to Ext. Doc. No.	Code[35]	-
288	Recipient Bank Account	Code[20]	-
289	Message to Recipient	Text[140]	-
290	Exported to Payment File	Boolean	-
480	Dimension Set ID	Integer	-
481	Shortcut Dimension 3 Code	Code[20]	-
482	Shortcut Dimension 4 Code	Code[20]	-
483	Shortcut Dimension 5 Code	Code[20]	-
484	Shortcut Dimension 6 Code	Code[20]	-
485	Shortcut Dimension 7 Code	Code[20]	-
486	Shortcut Dimension 8 Code	Code[20]	-
1200	Direct Debit Mandate ID	Code[35]	-

Keys, 24

Name	Fields	Obsolete
Key1, clustered	Entry No.	-
Key2	Customer No., Posting Date, Currency Code	-
Key3	Customer No., Currency Code, Posting Date	-
Key4	Document No.	-
Key5	External Document No.	-
Key6	Customer No., Open, Positive, Due Date, Currency Code	-
Key7	Open, Due Date	-
Key8	Document Type, Customer No., Posting Date, Currency Code	-
Key9	Salesperson Code, Posting Date	-
Key10	Closed by Entry No.	-
Key11	Transaction No.	-
Key12	Customer No., Open, Positive, Calculate Interest, Due Date	-
Key13	Customer No., Global Dimension 1 Code, Global Dimension 2 Code, Posting Date, Currency Code	-
Key14	Customer No., Open, Global Dimension 1 Code, Global Dimension 2 Code, Positive, Due Date, Currency Code	-
Key15	Open, Global Dimension 1 Code, Global Dimension 2 Code, Due Date	-
Key16	Document Type, Customer No., Global Dimension 1 Code, Global Dimension 2 Code, Posting Date, Currency Code	-
Key17	Customer No., Applies-to ID, Open, Positive, Due Date	-
Key18	Document Type, Posting Date	-
Key19	Document Type, Customer No., Open, Due Date	-
Key20	Customer Posting Group	-
Key21	Document Type, Open, Posting Date, Closed at Date	-
Key22	Salesperson Code	-
Key23	SystemModifiedAt	-
Key35	Customer No., Posting Date, Applies-to ID	-

Procedures, 15

Name	Parameters	Returns	Access	Obsolete
GetLastEntryNo	()	Integer	public	-
ShowDoc	()	Boolean	public	-
ShowPostedDocAttachment	()		public	-
HasPostedDocAttachment	()	Boolean	public	-
DrillDownOnEntries	(var Record Detailed Cust. Ledg. Entry)		public	-
DrillDownOnOverdueEntries	(var Record Detailed Cust. Ledg. Entry)		public	-
GetOriginalCurrencyFactor	()	Decimal	public	-
GetAdjustedCurrencyFactor	()	Decimal	public	-
ShowDimensions	()		public	-
SetStyle	()	Text	public	-
SetApplyToFilters	(Code[20], Option, Code[20], Decimal)		public	-
SetAmountToApply	(Code[20], Code[20])		public	-
CopyFromGenJnlLine	(Record Gen. Journal Line)		public	-
CopyFromCVLedgEntryBuffer	(var Record CV Ledger Entry Buffer)		public	-
RecalculateAmounts	(Code[10], Code[10], Date)		public	-

Events, 12

Kind	Name	Parameters	Obsolete
Integration event	OnAfterCopyCustLedgerEntryFromGenJnlLine	(var Record Cust. Ledger Entry, Record Gen. Journal Line)	-
Integration event	OnAfterCopyCustLedgerEntryFromCVLedgEntryBuffer	(var Record Cust. Ledger Entry, Record CV Ledger Entry Buffer)	-
Integration event	OnAfterRecalculateAmounts	(var Record Cust. Ledger Entry, Code[10], Code[10], Date)	-
Integration event	OnBeforeDrillDownEntries	(var Record Cust. Ledger Entry, var Record Detailed Cust. Ledg. Entry, var Integer)	-
Integration event	OnBeforeDrillDownOnOverdueEntries	(var Record Cust. Ledger Entry, var Record Detailed Cust. Ledg. Entry, var Integer)	-
Integration event	OnBeforeSetStyle	(var Text, var Boolean)	-
Integration event	OnBeforeShowDoc	(Record Cust. Ledger Entry, var Boolean, var Boolean)	-
Integration event	OnAfterShowDoc	(var Record Cust. Ledger Entry)	-
Integration event	OnAfterShowPostedDocAttachment	(var Record Cust. Ledger Entry)	-
Integration event	OnAfterHasPostedDocAttachment	(var Record Cust. Ledger Entry, var Boolean)	-
Integration event	OnBeforeSetAmountToApply	(var Record Cust. Ledger Entry, Code[20], Code[20])	-
Integration event	OnBeforeValidateMessagetoRecipient	(var Record Cust. Ledger Entry, var Boolean)	-