Table 36 Sales Header

Base Application, Microsoft.Sales.Document

189 fields

IdNameTypeVersions
1Document TypeEnum "Sales Document Type"17-29
2Sell-to Customer No.Code[20]17-29
3No.Code[20]17-29
4Bill-to Customer No.Code[20]17-29
5Bill-to NameText[100]17-29
6Bill-to Name 2Text[50]17-29
7Bill-to AddressText[100]17-29
8Bill-to Address 2Text[50]17-29
9Bill-to CityText[30]17-29
10Bill-to ContactText[100]17-29
11Your ReferenceText[35]17-29
12Ship-to CodeCode[10]17-29
13Ship-to NameText[100]17-29
14Ship-to Name 2Text[50]17-29
15Ship-to AddressText[100]17-29
16Ship-to Address 2Text[50]17-29
17Ship-to CityText[30]17-29
18Ship-to ContactText[100]17-29
19Order DateDate17-29
20Posting DateDate17-29
21Shipment DateDate17-29
22Posting DescriptionText[100]17-29
23Payment Terms CodeCode[10]17-29
24Due DateDate17-29
25Payment Discount %Decimal17-29
26Pmt. Discount DateDate17-29
27Shipment Method CodeCode[10]17-29
28Location CodeCode[10]17-29
29Shortcut Dimension 1 CodeCode[20]17-29
30Shortcut Dimension 2 CodeCode[20]17-29
31Customer Posting GroupCode[20]17-29
32Currency CodeCode[10]17-29
33Currency FactorDecimal17-29
34Customer Price GroupCode[10]17-29
35Prices Including VATBoolean17-29
37Invoice Disc. CodeCode[20]17-29
40Customer Disc. GroupCode[20]17-29
41Language CodeCode[10]17-29
42Format RegionText[80]new in 23
43Salesperson CodeCode[20]17-29
45Order ClassCode[10]17-29
46CommentBoolean17-29
47No. PrintedInteger17-29
51On HoldCode[3]17-29
52Applies-to Doc. TypeEnum "Gen. Journal Document Type"17-29
53Applies-to Doc. No.Code[20]17-29
55Bal. Account No.Code[20]17-29
56Recalculate Invoice Disc.Boolean17-29
57ShipBoolean17-29
58InvoiceBoolean17-29
59Print Posted DocumentsBoolean17-29
60AmountDecimal17-29
61Amount Including VATDecimal17-29
62Shipping No.Code[20]17-29
63Posting No.Code[20]17-29
64Last Shipping No.Code[20]17-29
65Last Posting No.Code[20]17-29
66Prepayment No.Code[20]17-29
67Last Prepayment No.Code[20]17-29
68Prepmt. Cr. Memo No.Code[20]17-29
69Last Prepmt. Cr. Memo No.Code[20]17-29
70VAT Registration No.Text[20]17-29
71Combine ShipmentsBoolean17-29
72Registration NumberText[50]new in 24
73Reason CodeCode[10]17-29
74Gen. Bus. Posting GroupCode[20]17-29
75EU 3-Party TradeBoolean17-29
76Transaction TypeCode[10]17-29
77Transport MethodCode[10]17-29
78VAT Country/Region CodeCode[10]17-29
79Sell-to Customer NameText[100]17-29
80Sell-to Customer Name 2Text[50]17-29
81Sell-to AddressText[100]17-29
82Sell-to Address 2Text[50]17-29
83Sell-to CityText[30]17-29
84Sell-to ContactText[100]17-29
85Bill-to Post CodeCode[20]17-29
86Bill-to CountyText[30]17-29
87Bill-to Country/Region CodeCode[10]17-29
88Sell-to Post CodeCode[20]17-29
89Sell-to CountyText[30]17-29
90Sell-to Country/Region CodeCode[10]17-29
91Ship-to Post CodeCode[20]17-29
92Ship-to CountyText[30]17-29
93Ship-to Country/Region CodeCode[10]17-29
94Bal. Account TypeEnum "Payment Balance Account Type"17-29
97Exit PointCode[10]17-29
98CorrectionBoolean17-29
99Document DateDate17-29
100External Document No.Code[35]17-29
101AreaCode[10]17-29
102Transaction SpecificationCode[10]17-29
104Payment Method CodeCode[10]17-29
105Shipping Agent CodeCode[10]17-29
106Package Tracking No.Text[50]17-29changed in 27
107No. SeriesCode[20]17-29
108Posting No. SeriesCode[20]17-29
109Shipping No. SeriesCode[20]17-29
114Tax Area CodeCode[20]17-29
115Tax LiableBoolean17-29
116VAT Bus. Posting GroupCode[20]17-29
117ReserveEnum "Reserve Method"17-29
118Applies-to IDCode[50]17-29
119VAT Base Discount %Decimal17-29
120StatusEnum "Sales Document Status"17-29
121Invoice Discount CalculationOption17-29
122Invoice Discount ValueDecimal17-29
123Send IC DocumentBoolean17-29
124IC StatusEnum "Sales Document IC Status"17-29changed in 18
125Sell-to IC Partner CodeCode[20]17-29
126Bill-to IC Partner CodeCode[20]17-29
127IC Reference Document No.Code[20]new in 21
129IC DirectionEnum "IC Direction Type"17-29changed in 21
130Prepayment %Decimal17-29
131Prepayment No. SeriesCode[20]17-29
132Compress PrepaymentBoolean17-29
133Prepayment Due DateDate17-29
134Prepmt. Cr. Memo No. SeriesCode[20]17-29
135Prepmt. Posting DescriptionText[100]17-29
138Prepmt. Pmt. Discount DateDate17-29
139Prepmt. Payment Terms CodeCode[10]17-29
140Prepmt. Payment Discount %Decimal17-29
151Quote No.Code[20]17-29
152Quote Valid Until DateDate17-29
153Quote Sent to CustomerDateTime17-29
154Quote AcceptedBoolean17-29
155Quote Accepted DateDate17-29
160Job Queue StatusEnum "Document Job Queue Status"17-29changed in 24
161Job Queue Entry IDGuid17-29
163Company Bank Account CodeCode[20]new in 20
165Incoming Document Entry No.Integer17-29
166Alt. VAT Registration No.Boolean17-23, 25-29
167Alt. Gen. Bus Posting GroupBoolean17-23, 25-29
168Alt. VAT Bus Posting GroupBoolean17-23, 25-29
169Last Email Notif ClearedBooleangone after 23
Pending, tag 21.0, obsolete since 21: Microsoft Invoicing has been discontinued.
170IsTestBoolean17-29
171Sell-to Phone No.Text[30]17-29
172Sell-to E-MailText[80]17-29
175Payment Instructions IdIntegergone after 25
Removed, tag 21.0, obsolete since 18: Microsoft Invoicing is not supported in Business Central
178Journal Templ. NameCode[10]new in 20
179VAT Reporting DateDatenew in 21
180Rcvd-from Country/Region CodeCode[10]22 to 25
Removed, tag 23.0, obsolete since 22: Use new field on range 181
181Rcvd.-from Count./Region CodeCode[10]new in 22
185Last Email Sent TimeDateTimenew in 25
186Last Email Sent Message IdGuidnew in 25
200Work DescriptionBlob17-29
210Ship-to Phone No.Text[30]new in 25
300Amt. Ship. Not Inv. (LCY)Decimal17-29
301Amt. Ship. Not Inv. (LCY) BaseDecimal17-29
480Dimension Set IDInteger17-29
600Payment Service Set IDInteger17-29
720Coupled to CRMBooleannew in 21
Removed, tag 26.0, obsolete since 22: Replaced by flow field Coupled to Dataverse
721Coupled to DataverseBooleannew in 22
1200Direct Debit Mandate IDCode[35]17-29
1305Invoice Discount AmountDecimal17-29
5043No. of Archived VersionsInteger17-29
5048Doc. No. OccurrenceInteger17-29
5050Campaign No.Code[20]17-29
5051Sell-to Customer Template CodeCode[10]gone after 25
Removed, tag 21.0, obsolete since 18: Will be removed with other functionality related to "old" templates. Replaced by "Sell-to Customer Templ. Code".
5052Sell-to Contact No.Code[20]17-29
5053Bill-to Contact No.Code[20]17-29
5054Bill-to Customer Template CodeCode[10]gone after 25
Removed, tag 21.0, obsolete since 18: Will be removed with other functionality related to "old" templates. Replaced by "Bill-to Customer Templ. Code".
5055Opportunity No.Code[20]17-29
5056Sell-to Customer Templ. CodeCode[20]new in 18
5057Bill-to Customer Templ. CodeCode[20]new in 18
5700Responsibility CenterCode[10]17-29
5750Shipping AdviceEnum "Sales Header Shipping Advice"17-29
5751Shipped Not InvoicedBoolean17-29
5752Completely ShippedBoolean17-29
5753Posting from Whse. Ref.Integer17-29
5754Location FilterCode[10]17-29
5755ShippedBoolean17-29
5756Last Shipment DateDate17-29
5790Requested Delivery DateDate17-29
5791Promised Delivery DateDate17-29
5792Shipping TimeDateFormula17-29
5793Outbound Whse. Handling TimeDateFormula17-29
5794Shipping Agent Service CodeCode[10]17-29
5795Late Order ShippingBoolean17-29
5796Date FilterDate17-29
5800ReceiveBoolean17-29
5801Return Receipt No.Code[20]17-29
5802Return Receipt No. SeriesCode[20]17-29
5803Last Return Receipt No.Code[20]17-29
7000Price Calculation MethodEnum "Price Calculation Method"17-29
7001Allow Line Disc.Boolean17-29
7200Get Shipment UsedBoolean17-29
8000IdGuidgone after 25
Removed, tag 22.0, obsolete since 17: This functionality will be replaced by the systemID field
9000Assigned User IDCode[50]17-29