XPT / Schema / Sales Header

Sales Header #36

Sales Documents table in Microsoft Dynamics 365 Business Central. 199 fields, 47 records in Cronus demo.

199
Fields
47
Records
2
Primary key
22
FlowFields
64
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 (199)

Sales Header — FIELDS
NO.FIELDTYPECLASSRELATION
1 Document Type PK Option Normal
2 Sell-to Customer No. Code Normal → Customer #18
3 No. PK Code Normal
4 Bill-to Customer No. Code Normal → Customer #18
5 Bill-to Name Text Normal → Customer #18
6 Bill-to Name 2 Text Normal
7 Bill-to Address Text Normal
8 Bill-to Address 2 Text Normal
9 Bill-to City Text Normal
10 Bill-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 Shipment 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 Customer Posting Group Code Normal → Customer Posting Group #92
32 Currency Code Code Normal → Currency #4
33 Currency Factor Decimal Normal
34 Customer Price Group Code Normal → Customer Price Group #6
35 Prices Including VAT Boolean Normal
37 Invoice Disc. Code Code Normal
40 Customer Disc. Group Code Normal → Customer Discount Group #340
41 Language Code Code Normal → Language #8
42 Format Region Text Normal
43 Salesperson 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 Ship 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 Shipping No. Code Normal
63 Posting No. Code Normal
64 Last Shipping No. Code Normal → Sales Shipment Header #110
65 Last Posting No. Code Normal → Sales Invoice Header #112
66 Prepayment No. Code Normal
67 Last Prepayment No. Code Normal → Sales Invoice Header #112
68 Prepmt. Cr. Memo No. Code Normal
69 Last Prepmt. Cr. Memo No. Code Normal → Sales Cr.Memo Header #114
70 VAT Registration No. Text Normal
71 Combine Shipments Boolean Normal
72 Registration No. Text Normal
73 Reason Code Code Normal → Reason Code #231
74 Gen. Bus. Posting Group Code Normal → Gen. Business Posting Group #250
75 EU 3-Party Trade Boolean Normal
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 Sell-to Customer Name Text Normal → Customer #18
80 Sell-to Customer Name 2 Text Normal
81 Sell-to Address Text Normal
82 Sell-to Address 2 Text Normal
83 Sell-to City Text Normal
84 Sell-to Contact Text Normal
85 Bill-to Post Code Code Normal → Post Code #225
86 Bill-to County Text Normal
87 Bill-to Country/Region Code Code Normal → Country/Region #9
88 Sell-to Post Code Code Normal
89 Sell-to County Text Normal
90 Sell-to 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
97 Exit Point Code Normal → Entry/Exit Point #282
98 Correction Boolean Normal
99 Document Date Date Normal
100 External Document No. Code Normal
101 Area Code Normal → Area #284
102 Transaction Specification Code Normal → Transaction Specification #285
104 Payment Method Code Code Normal → Payment Method #289
105 Shipping Agent Code Code Normal → Shipping Agent #291
106 Package Tracking No. Text Normal
107 No. Series Code Normal → No. Series #308
108 Posting No. Series Code Normal → No. Series #308
109 Shipping 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
117 Reserve Option Normal
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 Sell-to IC Partner Code Code Normal → IC Partner #413
126 Bill-to IC Partner Code Code Normal → IC Partner #413
127 IC Reference Document No. Code Normal
129 IC Direction Option Normal
130 Prepayment % Decimal Normal
131 Prepayment No. Series Code Normal → No. Series #308
132 Compress Prepayment Boolean Normal
133 Prepayment Due Date Date Normal
134 Prepmt. Cr. Memo No. Series Code Normal → No. Series #308
135 Prepmt. Posting Description Text Normal
138 Prepmt. Pmt. Discount Date Date Normal
139 Prepmt. Payment Terms Code Code Normal → Payment Terms #3
140 Prepmt. Payment Discount % Decimal Normal
151 Quote No. Code Normal
152 Quote Valid To Date Date Normal
153 Quote Sent to Customer DateTime Normal
154 Quote Accepted Boolean Normal
155 Quote Accepted Date Date Normal
160 Job Queue Status Option Normal
161 Job Queue Entry ID GUID Normal
163 Company Bank Account Code Code Normal → Bank Account #270
165 Incoming Document Entry No. Integer Normal → Incoming Document #130
166 Alternative VAT Registration No. Boolean Normal
167 Alternative Gen. Bus. Posting Group Boolean Normal
168 Alternative VAT Bus. Posting Group Boolean Normal
170 IsTest Boolean Normal
171 Sell-to Phone No. Text Normal
172 Email Text Normal
178 Journal Template Name Code Normal → Gen. Journal Template #80
179 VAT Date Date Normal
181 Received-from Country/Region Code Code Normal → Country/Region #9
185 Last Email Sent Time ⚡ FLOW DateTime FlowField
186 Last Email Sent Message Id ⚡ FLOW GUID FlowField
200 Work Description BLOB Normal
210 Ship-to Phone No. Text Normal
300 Amount Shipped Not Invoiced (LCY) Incl. VAT ⚡ FLOW Decimal FlowField
301 Amount Shipped Not Invoiced (LCY) ⚡ FLOW Decimal FlowField
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
600 Payment Service Set ID Integer Normal
721 Coupled to Dynamics 365 Sales ⚡ FLOW Boolean FlowField
1200 Direct Debit Mandate ID Code Normal → SEPA Direct Debit Mandate #1230
1305 Invoice Discount Amount ⚡ FLOW Decimal FlowField
5043 No. of Archived Versions ⚡ FLOW Integer FlowField
5048 Doc. No. Occurrence Integer Normal
5050 Campaign No. Code Normal → Campaign #5071
5052 Sell-to Contact No. Code Normal → Contact #5050
5053 Bill-to Contact No. Code Normal → Contact #5050
5055 Opportunity No. Code Normal
5056 Sell-to Customer Template Code Code Normal → Customer Templ. #1381
5057 Bill-to Customer Template Code Code Normal → Customer Templ. #1381
5700 Responsibility Center Code Normal → Responsibility Center #5714
5750 Shipping Advice Option Normal
5751 Shipped Not Invoiced ⚡ FLOW Boolean FlowField
5752 Completely Shipped ⚡ FLOW Boolean FlowField
5753 Posting from Whse. Ref. Integer Normal
5754 Location Filter Code FlowFilter → Location #14
5755 Shipped ⚡ FLOW Boolean FlowField
5756 Last Shipment Date ⚡ FLOW Date FlowField
5790 Requested Delivery Date Date Normal
5791 Promised Delivery Date Date Normal
5792 Shipping Time DateFormula Normal
5793 Outbound Whse. Handling Time DateFormula Normal
5794 Shipping Agent Service Code Code Normal → Shipping Agent Services #5790
5795 Late Order Shipping ⚡ FLOW Boolean FlowField
5796 Date Filter Date FlowFilter
5800 Receive Boolean Normal
5801 Return Receipt No. Code Normal
5802 Return Receipt No. Series Code Normal → No. Series #308
5803 Last Return Receipt No. Code Normal → Return Receipt Header #6660
6210 Sustainability Lines Exist ⚡ FLOW Boolean FlowField
6211 Total CO2e ⚡ FLOW Decimal FlowField
6212 Posted Total CO2e ⚡ FLOW Decimal FlowField
6213 Total EPR Fee ⚡ FLOW Decimal FlowField
6214 Posted Total EPR Fee ⚡ FLOW Decimal FlowField
7000 Price Calculation Method Option Normal
7001 Allow Line Disc. Boolean Normal
7200 Get Shipment Used Boolean Normal
8051 Recurring Billing Boolean Normal
8052 Subscription Contract Detail Overview Option Normal
8053 Auto Contract Billing Boolean Normal
9000 Assigned User ID Code Normal → User Setup #91
30100 Shopify Order Id BigInteger Normal
30101 Shopify Order No. Code Normal
30102 Risk Level ⚡ FLOW Option FlowField
30103 Shopify Refund Id BigInteger 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 (44)

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

Customer
#18 · Sales · via Sell-to Customer No., Bill-to Customer No., Bill-to Name, Sell-to Customer 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
Customer Posting Group
#92 · Other · via Customer Posting Group
Currency
#4 · General Ledger · via Currency Code
Customer Price Group
#6 · General Ledger · via Customer Price Group
Customer Discount Group
#340 · Other · via Customer Disc. Group
Language
#8 · General Ledger · via Language Code
Salesperson/Purchaser
#13 · General Ledger · via Salesperson Code
Sales Shipment Header
#110 · Other · via Last Shipping No.
Sales Invoice Header
#112 · Posted Sales · via Last Posting No., Last Prepayment No.
Sales Cr.Memo Header
#114 · Posted Sales · via Last Prepmt. Cr. Memo 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, Bill-to Country/Region Code, Sell-to Country/Region Code, Ship-to Country/Region Code, Received-from Country/Region Code
Post Code
#225 · Other · via Bill-to Post Code
Entry/Exit Point
#282 · Other · via Exit Point
Area
#284 · Other · via Area
Transaction Specification
#285 · Other · via Transaction Specification
Payment Method
#289 · Other · via Payment Method Code
Shipping Agent
#291 · Other · via Shipping Agent Code
No. Series
#308 · Other · via No. Series, Posting No. Series, Shipping No. Series, Prepayment No. Series, Prepmt. Cr. Memo No. Series, Return Receipt 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 Sell-to IC Partner Code, Bill-to IC Partner Code
Bank Account
#270 · Other · via Company Bank Account Code
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
SEPA Direct Debit Mandate
#1230 · Other · via Direct Debit Mandate ID
Campaign
#5071 · Other · via Campaign No.
Contact
#5050 · Other · via Sell-to Contact No., Bill-to Contact No.
Customer Templ.
#1381 · Other · via Sell-to Customer Template Code, Bill-to Customer Template Code
Responsibility Center
#5714 · Other · via Responsibility Center
Shipping Agent Services
#5790 · Other · via Shipping Agent Service Code
Return Receipt Header
#6660 · Other · via Last Return Receipt No.
User Setup
#91 · Other · via Assigned User ID

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

HomeData ExplorerPricingPrivacyTerms