Vendor Ledger Entry #25

Purchasing table in Microsoft Dynamics 365 Business Central. 91 fields, 415 records in Cronus demo.

Fields

415

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Entry No..

All fields (91)

Vendor Ledger Entry — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Entry No. PK	Integer	Normal
3	Vendor No.	Code	Normal	→ Vendor #23
4	Posting Date	Date	Normal
5	Document Type	Option	Normal
6	Document No.	Code	Normal
7	Description	Text	Normal
8	Vendor Name	Text	Normal
11	Currency Code	Code	Normal	→ Currency #4
13	Amount ⚡ FLOW	Decimal	FlowField
14	Remaining Amount ⚡ FLOW	Decimal	FlowField
15	Original Amt. (LCY) ⚡ FLOW	Decimal	FlowField
16	Remaining Amt. (LCY) ⚡ FLOW	Decimal	FlowField
17	Amount (LCY) ⚡ FLOW	Decimal	FlowField
18	Purchase (LCY)	Decimal	Normal
20	Inv. Discount (LCY)	Decimal	Normal
21	Buy-from Vendor No.	Code	Normal	→ Vendor #23
22	Vendor Posting Group	Code	Normal	→ Vendor Posting Group #93
23	Global Dimension 1 Code	Code	Normal	→ Dimension Value #349
24	Global Dimension 2 Code	Code	Normal	→ Dimension Value #349
25	Purchaser Code	Code	Normal	→ Salesperson/Purchaser #13
27	User ID	Code	Normal
28	Source Code	Code	Normal	→ Source Code #230
33	On Hold	Code	Normal
34	Applies-to Doc. Type	Option	Normal
35	Applies-to Doc. No.	Code	Normal
36	Open	Boolean	Normal
37	Due Date	Date	Normal
38	Pmt. Discount Date	Date	Normal
39	Original Pmt. Disc. Possible	Decimal	Normal
40	Pmt. Disc. Rcd.(LCY)	Decimal	Normal
42	Org. Pmt. Disc. Possible (LCY)	Decimal	Normal
43	Positive	Boolean	Normal
44	Closed by Entry No.	Integer	Normal	→ Vendor Ledger Entry #25
45	Closed at Date	Date	Normal
46	Closed by Amount	Decimal	Normal
47	Applies-to ID	Code	Normal
48	Journal Template Name	Code	Normal
49	Journal Batch Name	Code	Normal
50	Reason Code	Code	Normal	→ Reason Code #231
51	Bal. Account Type	Option	Normal
52	Bal. Account No.	Code	Normal
53	Transaction No.	Integer	Normal
54	Closed by Amount (LCY)	Decimal	Normal
58	Debit Amount ⚡ FLOW	Decimal	FlowField
59	Credit Amount ⚡ FLOW	Decimal	FlowField
60	Debit Amount (LCY) ⚡ FLOW	Decimal	FlowField
61	Credit Amount (LCY) ⚡ FLOW	Decimal	FlowField
62	Document Date	Date	Normal
63	External Document No.	Code	Normal
64	No. Series	Code	Normal	→ No. Series #308
65	Closed by Currency Code	Code	Normal	→ Currency #4
66	Closed by Currency Amount	Decimal	Normal
73	Adjusted Currency Factor	Decimal	Normal
74	Original Currency Factor	Decimal	Normal
75	Original Amount ⚡ FLOW	Decimal	FlowField
76	Date Filter	Date	FlowFilter
77	Remaining Pmt. Disc. Possible	Decimal	Normal
78	Pmt. Disc. Tolerance Date	Date	Normal
79	Max. Payment Tolerance	Decimal	Normal
81	Accepted Payment Tolerance	Decimal	Normal
82	Accepted Pmt. Disc. Tolerance	Boolean	Normal
83	Pmt. Tolerance (LCY)	Decimal	Normal
84	Amount to Apply	Decimal	Normal
85	IC Partner Code	Code	Normal	→ IC Partner #413
86	Applying Entry	Boolean	Normal
87	Reversed	Boolean	Normal
88	Reversed by Entry No.	Integer	Normal	→ Vendor Ledger Entry #25
89	Reversed Entry No.	Integer	Normal	→ Vendor Ledger Entry #25
90	Prepayment	Boolean	Normal
170	Creditor No.	Code	Normal
171	Payment Reference	Code	Normal
172	Payment Method Code	Code	Normal	→ Payment Method #289
173	Applies-to Ext. Doc. No.	Code	Normal
175	Invoice Received Date	Date	Normal
288	Recipient Bank Account	Code	Normal	→ Vendor Bank Account #288
289	Message to Recipient	Text	Normal
290	Exported to Payment File	Boolean	Normal
480	Dimension Set ID	Integer	Normal	→ Dimension Set Entry #480
481	Shortcut Dimension 3 Code ⚡ FLOW	Code	FlowField
482	Shortcut Dimension 4 Code ⚡ FLOW	Code	FlowField
483	Shortcut Dimension 5 Code ⚡ FLOW	Code	FlowField
484	Shortcut Dimension 6 Code ⚡ FLOW	Code	FlowField
485	Shortcut Dimension 7 Code ⚡ FLOW	Code	FlowField
486	Shortcut Dimension 8 Code ⚡ FLOW	Code	FlowField
1000	Remit-to Code	Code	Normal	→ Remit Address #2224
8000	Recurring Billing	Boolean	Normal
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal