Objects/Tables/Table 25 Vendor Ledger Entry

Table 25 Vendor Ledger Entry in 20

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

App: Base Application

Fields, 83 Keys, 19 Procedures, 13 Events, 11

Versions17 18 192021 22 23 24 25 26 27 28 latest

Source29

Fields, 83

Id	Name	Type	Obsolete
1	Entry No.	Integer	-
3	Vendor 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	Vendor 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	Purchase (LCY)	Decimal	-
20	Inv. Discount (LCY)	Decimal	-
21	Buy-from Vendor No.	Code[20]	-
22	Vendor Posting Group	Code[20]	-
23	Global Dimension 1 Code	Code[20]	-
24	Global Dimension 2 Code	Code[20]	-
25	Purchaser 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. Rcd.(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	No. Series	Code[20]	-
65	Closed by Currency Code	Code[10]	-
66	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	-
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	-
170	Creditor No.	Code[20]	-
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]	-

Keys, 19

Name	Fields	Obsolete
Key1, clustered	Entry No.	-
Key2	Vendor No., Posting Date, Currency Code	-
Key3	Vendor No., Currency Code, Posting Date	-
Key4	Document No.	-
Key5	External Document No.	-
Key6	Vendor No., Open, Positive, Due Date, Currency Code	-
Key7	Open, Due Date	-
Key8	Document Type, Vendor No., Posting Date, Currency Code	-
Key9	Closed by Entry No.	-
Key10	Transaction No.	-
Key11	Vendor No., Global Dimension 1 Code, Global Dimension 2 Code, Posting Date, Currency Code	-
Key12	Vendor No., Open, Global Dimension 1 Code, Global Dimension 2 Code, Positive, Due Date, Currency Code	-
Key13	Open, Global Dimension 1 Code, Global Dimension 2 Code, Due Date	-
Key14	Document Type, Vendor No., Global Dimension 1 Code, Global Dimension 2 Code, Posting Date, Currency Code	-
Key15	Vendor No., Applies-to ID, Open, Positive, Due Date	-
Key16	Vendor Posting Group	-
Key17	Pmt. Discount Date	-
Key18	Document Type, Due Date, Open	-
Key25	Vendor No., Posting Date, Applies-to ID	-

Procedures, 13

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

Events, 11

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