Vendor Payment Buffer #475

Other table in Microsoft Dynamics 365 Business Central. 24 fields, 0 records in Cronus demo.

24
Fields
0
Records
5
Primary key
0
FlowFields
12
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Vendor No., Currency Code, Vendor Ledg. Entry No., Dimension Entry No., Remit-to Code.

All fields (24)

Vendor Payment Buffer — FIELDS
NO.FIELDTYPECLASSRELATION
1 Vendor No. PK Code Normal → Vendor #23
2 Currency Code PK Code Normal → Currency #4
3 Vendor Ledg. Entry No. PK Integer Normal → Vendor Ledger Entry #25
4 Dimension Entry No. PK Integer Normal
5 Global Dimension 1 Code Code Normal → Dimension Value #349
6 Global Dimension 2 Code Code Normal → Dimension Value #349
7 Document No. Code Normal
8 Amount Decimal Normal
9 Vendor Ledg. Entry Doc. Type Option Normal
10 Vendor Ledg. Entry Doc. No. Code Normal
11 Vendor Posting Group Code Normal
20 Ledg. Entry System Id GUID Normal
170 Creditor No. Code Normal → Vendor Ledger Entry #25
171 Payment Reference Code Normal → Vendor Ledger Entry #25
172 Payment Method Code Code Normal → Vendor Ledger Entry #25
173 Applies-to Ext. Doc. No. Code Normal
290 Exported to Payment File Boolean Normal
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
1000 Remit-to Code PK Code Normal → Remit Address #2224
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

Related tables (7)

Tables referenced by fields on the Vendor Payment Buffer table through TableRelation properties.

Vendor
#23 · Purchasing · via Vendor No.
Currency
#4 · General Ledger · via Currency Code
Vendor Ledger Entry
#25 · Purchasing · via Vendor Ledg. Entry No., Creditor No., Payment Reference, Payment Method Code
Dimension Value
#349 · Dimensions · via Global Dimension 1 Code, Global Dimension 2 Code
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID
Remit Address
#2224 · Other · via Remit-to Code