XPT / Schema / Purchase Header

Purchase Header #38

Sales Documents table in Microsoft Dynamics 365 Business Central. 180 fields, 32 records in Cronus demo.

The Purchase Header table (ID 38) is part of the Sales Documents area in Microsoft Dynamics 365 Business Central. It contains 180 fields, with a primary key of Document Type, No., and includes 24 calculated FlowFields. Use the reference below to explore every field, data type, and table relation.

180
Fields
32
Records
2
Primary key
24
FlowFields
57
Relations
Open in Data Explorer →

Primary key

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

All fields (180)

Purchase Header — FIELDS
NO.FIELDTYPECLASSRELATION
1 Document Type PK Option Normal
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
6 Pay-to Name 2 Text Normal
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
11 Your Reference Text Normal
12 Ship-to Code Code Normal → Ship-to Address #222
13 Ship-to Name Text Normal
14 Ship-to Name 2 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
19 Order Date Date Normal
20 Posting Date Date Normal
21 Expected Receipt Date Date Normal
22 Posting Description Text Normal
23 Payment Terms Code Code Normal → Payment Terms #3
24 Due Date Date Normal
25 Payment Discount % Decimal Normal
26 Pmt. Discount Date Date Normal
27 Shipment Method Code Code Normal → Shipment Method #10
28 Location Code Code Normal → Location #14
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
33 Currency Factor Decimal Normal
35 Prices Including VAT Boolean Normal
37 Invoice Disc. Code Code Normal
41 Language Code Code Normal → Language #8
42 Format Region Text Normal
43 Purchaser Code Code Normal → Salesperson/Purchaser #13
45 Order Class Code Normal
46 Comment ⚡ FLOW Boolean FlowField
47 No. Printed Integer Normal
51 On Hold Code Normal
52 Applies-to Doc. Type Option Normal
53 Applies-to Doc. No. Code Normal
55 Bal. Account No. Code Normal
56 Recalculate Invoice Disc. ⚡ FLOW Boolean FlowField
57 Receive Boolean Normal
58 Invoice Boolean Normal
59 Print Posted Documents Boolean Normal
60 Amount ⚡ FLOW Decimal FlowField
61 Amount Including VAT ⚡ FLOW Decimal FlowField
62 Receiving No. Code Normal
63 Posting No. Code Normal
64 Last Receiving No. Code Normal → Purch. Rcpt. Header #120
65 Last Posting No. Code Normal → Purch. Inv. Header #122
66 Vendor Order No. Code Normal
67 Vendor Shipment No. Code Normal
68 Vendor Invoice No. Code Normal
69 Vendor Cr. Memo No. Code Normal
70 VAT Registration No. Text Normal
72 Sell-to Customer No. Code Normal → Customer #18
73 Reason Code Code Normal → Reason Code #231
74 Gen. Bus. Posting Group Code Normal → Gen. Business Posting Group #250
76 Transaction Type Code Normal → Transaction Type #258
77 Transport Method Code Normal → Transport Method #259
78 VAT Country/Region Code Code Normal → Country/Region #9
79 Buy-from Vendor Name Text Normal → Vendor #23
80 Buy-from Vendor Name 2 Text Normal
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
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
94 Bal. Account Type Option Normal
95 Order Address Code Code Normal → Order Address #224
97 Entry Point Code Normal → Entry/Exit Point #282
98 Correction Boolean Normal
99 Document Date Date Normal
101 Area Code Normal → Area #284
102 Transaction Specification Code Normal → Transaction Specification #285
104 Payment Method Code Code Normal → Payment Method #289
107 No. Series Code Normal → No. Series #308
108 Posting No. Series Code Normal → No. Series #308
109 Receiving No. Series Code Normal → No. Series #308
114 Tax Area Code Code Normal → Tax Area #318
115 Tax Liable Boolean Normal
116 VAT Bus. Posting Group Code Normal → VAT Business Posting Group #323
118 Applies-to ID Code Normal
119 VAT Base Discount % Decimal Normal
120 Status Option Normal
121 Invoice Discount Calculation Option Normal
122 Invoice Discount Value Decimal Normal
123 Send IC Document Boolean Normal
124 IC Status Option Normal
125 Buy-from IC Partner Code Code Normal → IC Partner #413
126 Pay-to IC Partner Code Code Normal → IC Partner #413
127 IC Reference Document No. Code Normal
129 IC Direction Option Normal
130 Prepayment No. Code Normal
131 Last Prepayment No. Code Normal → Purch. Inv. Header #122
132 Prepmt. Cr. Memo No. Code Normal
133 Last Prepmt. Cr. Memo No. Code Normal → Purch. Cr. Memo Hdr. #124
134 Prepayment % Decimal Normal
135 Prepayment No. Series Code Normal → No. Series #308
136 Compress Prepayment Boolean Normal
137 Prepayment Due Date Date Normal
138 Prepmt. Cr. Memo No. Series Code Normal → No. Series #308
139 Prepmt. Posting Description Text Normal
142 Prepmt. Pmt. Discount Date Date Normal
143 Prepmt. Payment Terms Code Code Normal → Payment Terms #3
144 Prepmt. Payment Discount % Decimal Normal
151 Quote No. Code Normal
160 Job Queue Status Option Normal
161 Job Queue Entry ID GUID Normal
165 Incoming Document Entry No. Integer Normal → Incoming Document #130
170 Creditor No. Code Normal
171 Payment Reference Code Normal
175 Invoice Received Date Date Normal
178 Journal Template Name Code Normal → Gen. Journal Template #80
179 VAT Date Date Normal
210 Ship-to Phone No. Text Normal
300 Amount Received Not Invoiced (LCY) ⚡ FLOW Decimal FlowField
301 Amount Received Not Invoiced (LCY) Incl. VAT ⚡ FLOW Decimal FlowField
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
1000 Remit-to Code Code Normal → Remit Address #2224
1305 Invoice Discount Amount ⚡ FLOW Decimal FlowField
4881 EU 3-Party Trade Boolean Normal
5043 No. of Archived Versions ⚡ FLOW Integer FlowField
5048 Doc. No. Occurrence Integer Normal
5050 Campaign No. Code Normal → Campaign #5071
5052 Buy-from Contact No. Code Normal → Contact #5050
5053 Pay-to Contact No. Code Normal → Contact #5050
5700 Responsibility Center Code Normal → Responsibility Center #5714
5751 Partially Invoiced ⚡ FLOW Boolean FlowField
5752 Completely Received ⚡ FLOW Boolean FlowField
5753 Posting from Whse. Ref. Integer Normal
5754 Location Filter Code FlowFilter → Location #14
5755 Received Not Invoiced ⚡ FLOW Boolean FlowField
5790 Requested Receipt Date Date Normal
5791 Promised Receipt Date Date Normal
5792 Lead Time Calculation DateFormula Normal
5793 Inbound Whse. Handling Time DateFormula Normal
5796 Date Filter Date FlowFilter
5800 Vendor Authorization No. Code Normal
5801 Return Shipment No. Code Normal
5802 Return Shipment No. Series Code Normal → No. Series #308
5803 Ship Boolean Normal
5804 Last Return Shipment No. Code Normal → Return Shipment Header #6650
6100 E-Document Link GUID Normal
6101 Amount Incl. Tax To Inv. ⚡ FLOW Decimal FlowField
6210 Sustainability Lines Exist ⚡ FLOW Boolean FlowField
6211 Emission CO2 ⚡ FLOW Decimal FlowField
6212 Emission CH4 ⚡ FLOW Decimal FlowField
6213 Emission N2O ⚡ FLOW Decimal FlowField
6214 Posted Emission CO2 ⚡ FLOW Decimal FlowField
6215 Posted Emission CH4 ⚡ FLOW Decimal FlowField
6216 Posted Emission N2O ⚡ FLOW Decimal FlowField
6217 Energy Consumption ⚡ FLOW Decimal FlowField
6218 Posted Energy Consumption ⚡ FLOW Decimal FlowField
6219 Total Emission Cost ⚡ FLOW Decimal FlowField
6220 Posted Total Emission Cost ⚡ FLOW Decimal FlowField
7000 Price Calculation Method Option Normal
8051 Recurring Billing Boolean Normal
9000 Assigned User ID Code Normal → User Setup #91
9001 Pending Approvals ⚡ FLOW Integer FlowField
11301 Doc. Amount Incl. VAT Decimal Normal
11302 Doc. Amount VAT Decimal 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

Related tables (39)

Tables referenced by fields on the Purchase Header table through TableRelation properties.

Vendor
#23 · Purchasing · via Buy-from Vendor No., Pay-to Vendor No., Pay-to Name, Buy-from Vendor Name
Ship-to Address
#222 · Other · via Ship-to Code
Payment Terms
#3 · General Ledger · via Payment Terms Code, Prepmt. Payment Terms Code
Shipment Method
#10 · General Ledger · via Shipment Method Code
Location
#14 · General Ledger · via Location Code, Location Filter
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
Language
#8 · General Ledger · via Language Code
Salesperson/Purchaser
#13 · General Ledger · via Purchaser Code
Purch. Rcpt. Header
#120 · Posted Purchases · via Last Receiving No.
Purch. Inv. Header
#122 · Posted Purchases · via Last Posting No., Last Prepayment No.
Customer
#18 · Sales · via Sell-to Customer No.
Reason Code
#231 · Other · via Reason Code
Gen. Business Posting Group
#250 · Other · via Gen. Bus. Posting Group
Transaction Type
#258 · Other · via Transaction Type
Transport Method
#259 · Other · via Transport Method
Country/Region
#9 · General Ledger · via VAT Country/Region Code, Pay-to Country/Region Code, Buy-from Country/Region Code, Ship-to Country/Region Code
Order Address
#224 · Other · via Order Address Code
Entry/Exit Point
#282 · Other · via Entry Point
Area
#284 · Other · via Area
Transaction Specification
#285 · Other · via Transaction Specification
Payment Method
#289 · Other · via Payment Method Code
No. Series
#308 · Other · via No. Series, Posting No. Series, Receiving No. Series, Prepayment No. Series, Prepmt. Cr. Memo No. Series, Return Shipment No. Series
Tax Area
#318 · Other · via Tax Area Code
VAT Business Posting Group
#323 · Other · via VAT Bus. Posting Group
IC Partner
#413 · Other · via Buy-from IC Partner Code, Pay-to IC Partner Code
Purch. Cr. Memo Hdr.
#124 · Posted Purchases · via Last Prepmt. Cr. Memo No.
Incoming Document
#130 · Other · via Incoming Document Entry No.
Gen. Journal Template
#80 · Other · via Journal Template Name
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID
Remit Address
#2224 · Other · via Remit-to Code
Campaign
#5071 · Other · via Campaign No.
Contact
#5050 · Other · via Buy-from Contact No., Pay-to Contact No.
Responsibility Center
#5714 · Other · via Responsibility Center
Return Shipment Header
#6650 · Other · via Last Return Shipment No.
User Setup
#91 · Other · via Assigned User ID

© 2026 Xpertly Ltd · Company No. 14753894 · VAT No. 452840787

HomeData ExplorerPricingPrivacyTerms