Purchase Order Entity Buffer #5496

Other table in Microsoft Dynamics 365 Business Central. 62 fields, 29 records in Cronus demo.

62
Fields
29
Records
1
Primary key
1
FlowFields
24
Relations
Open in Data Explorer →

Primary key

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

All fields (62)

Purchase Order Entity Buffer — FIELDS
NO.FIELDTYPECLASSRELATION
2 Buy-from Vendor No. Code Normal → Vendor #23
3 No. PK Code Normal
4 Pay-to Vendor No. Code Normal → Vendor #23
5 Pay-to Name Text Normal → Vendor #23
7 Pay-to Address Text Normal
8 Pay-to Address 2 Text Normal
9 Pay-to City Text Normal
10 Pay-to Contact Text Normal
12 Ship-to Code Code Normal
13 Ship-to Name Text Normal
15 Ship-to Address Text Normal
16 Ship-to Address 2 Text Normal
17 Ship-to City Text Normal
18 Ship-to Contact Text Normal
20 Posting Date Date Normal
23 Payment Terms Code Code Normal → Payment Terms #3
27 Shipment Method Code Code Normal → Shipment Method #10
29 Shortcut Dimension 1 Code Code Normal → Dimension Value #349
30 Shortcut Dimension 2 Code Code Normal → Dimension Value #349
31 Vendor Posting Group Code Normal → Vendor Posting Group #93
32 Currency Code Code Normal → Currency #4
35 Prices Including VAT Boolean Normal
43 Purchaser Code Code Normal → Salesperson/Purchaser #13
56 Recalculate Invoice Disc. ⚡ FLOW Boolean FlowField
60 Amount Decimal Normal
61 Amount Including VAT Decimal Normal
79 Buy-from Vendor Name Text Normal → Vendor #23
81 Buy-from Address Text Normal
82 Buy-from Address 2 Text Normal
83 Buy-from City Text Normal
84 Buy-from Contact Text Normal
85 Pay-to Post Code Code Normal → Post Code #225
86 Pay-to County Text Normal
87 Pay-to Country/Region Code Code Normal → Country/Region #9
88 Buy-from Post Code Code Normal
89 Buy-from County Text Normal
90 Buy-from Country/Region Code Code Normal → Country/Region #9
91 Ship-to Post Code Code Normal
92 Ship-to County Text Normal
93 Ship-to Country/Region Code Code Normal → Country/Region #9
99 Document Date Date Normal
210 Ship-to Phone No. Text Normal
1304 Vendor Ledger Entry No. Integer Normal → Vendor Ledger Entry #25
1305 Invoice Discount Amount Decimal Normal
5052 Buy-from Contact No. Code Normal → Contact #5050
5752 Completely Received Boolean Normal
5790 Requested Receipt Date Date Normal
8000 Id GUID Normal
9600 Total Tax Amount Decimal Normal
9601 Status Option Normal
9624 Discount Applied Before Tax Boolean Normal
9631 Vendor Id GUID Normal → Vendor #23
9633 Contact Graph Id Text Normal
9634 Currency Id GUID Normal → Currency #4
9635 Payment Terms Id GUID Normal → Payment Terms #3
9636 Shipment Method Id GUID Normal → Shipment Method #10
9638 Pay-to Vendor Id GUID Normal → Vendor #23
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 (12)

Tables referenced by fields on the Purchase Order Entity Buffer table through TableRelation properties.

Vendor
#23 · Purchasing · via Buy-from Vendor No., Pay-to Vendor No., Pay-to Name, Buy-from Vendor Name, Vendor Id, Pay-to Vendor Id
Payment Terms
#3 · General Ledger · via Payment Terms Code, Payment Terms Id
Shipment Method
#10 · General Ledger · via Shipment Method Code, Shipment Method Id
Dimension Value
#349 · Dimensions · via Shortcut Dimension 1 Code, Shortcut Dimension 2 Code
Vendor Posting Group
#93 · Other · via Vendor Posting Group
Currency
#4 · General Ledger · via Currency Code, Currency Id
Salesperson/Purchaser
#13 · General Ledger · via Purchaser Code
Post Code
#225 · Other · via Pay-to Post Code
Country/Region
#9 · General Ledger · via Pay-to Country/Region Code, Buy-from Country/Region Code, Ship-to Country/Region Code
Vendor Ledger Entry
#25 · Purchasing · via Vendor Ledger Entry No.
Contact
#5050 · Other · via Buy-from Contact No.