Objects/Tables/Table 112 Sales Invoice Header

Fields, 141

Jonas Paprotka, Base Application 28.5.54151.54365, versions 17-28, checked 2026-09-20

Id	Name	Type	Versions	Obsolete
2	Sell-to Customer No.	Code[20]	17-28	-
3	No.	Code[20]	17-28	-
4	Bill-to Customer No.	Code[20]	17-28	-
5	Bill-to Name	Text[100]	17-28	-
6	Bill-to Name 2	Text[50]	17-28	-
7	Bill-to Address	Text[100]	17-28	-
8	Bill-to Address 2	Text[50]	17-28	-
9	Bill-to City	Text[30]	17-28	-
10	Bill-to Contact	Text[100]	17-28	-
11	Your Reference	Text[35]	17-28	-
12	Ship-to Code	Code[10]	17-28	-
13	Ship-to Name	Text[100]	17-28	-
14	Ship-to Name 2	Text[50]	17-28	-
15	Ship-to Address	Text[100]	17-28	-
16	Ship-to Address 2	Text[50]	17-28	-
17	Ship-to City	Text[30]	17-28	-
18	Ship-to Contact	Text[100]	17-28	-
19	Order Date	Date	17-28	-
20	Posting Date	Date	17-28	-
21	Shipment Date	Date	17-28	-
22	Posting Description	Text[100]	17-28	-
23	Payment Terms Code	Code[10]	17-28	-
24	Due Date	Date	17-28	-
25	Payment Discount %	Decimal	17-28	-
26	Pmt. Discount Date	Date	17-28	-
27	Shipment Method Code	Code[10]	17-28	-
28	Location Code	Code[10]	17-28	-
29	Shortcut Dimension 1 Code	Code[20]	17-28	-
30	Shortcut Dimension 2 Code	Code[20]	17-28	-
31	Customer Posting Group	Code[20]	17-28	-
32	Currency Code	Code[10]	17-28	-
33	Currency Factor	Decimal	17-28	-
34	Customer Price Group	Code[10]	17-28	-
35	Prices Including VAT	Boolean	17-28	-
37	Invoice Disc. Code	Code[20]	17-28	-
40	Customer Disc. Group	Code[20]	17-28	-
41	Language Code	Code[10]	17-28	-
42	Format Region	Text[80]	23-28	-
43	Salesperson Code	Code[20]	17-28	-
44	Order No.	Code[20]	17-28	-
46	Comment	Boolean	17-28	-
47	No. Printed	Integer	17-28	-
51	On Hold	Code[3]	17-28	-
52	Applies-to Doc. Type	Enum Gen. Journal Document Type	17-28	-
53	Applies-to Doc. No.	Code[20]	17-28	-
55	Bal. Account No.	Code[20]	17-28	-
60	Amount	Decimal	17-28	-
61	Amount Including VAT	Decimal	17-28	-
70	VAT Registration No.	Text[20]	17-28	-
72	Registration Number	Text[50]	24-28	-
73	Reason Code	Code[10]	17-28	-
74	Gen. Bus. Posting Group	Code[20]	17-28	-
75	EU 3-Party Trade	Boolean	17-28	-
76	Transaction Type	Code[10]	17-28	-
77	Transport Method	Code[10]	17-28	-
78	VAT Country/Region Code	Code[10]	17-28	-
79	Sell-to Customer Name	Text[100]	17-28	-
80	Sell-to Customer Name 2	Text[50]	17-28	-
81	Sell-to Address	Text[100]	17-28	-
82	Sell-to Address 2	Text[50]	17-28	-
83	Sell-to City	Text[30]	17-28	-
84	Sell-to Contact	Text[100]	17-28	-
85	Bill-to Post Code	Code[20]	17-28	-
86	Bill-to County	Text[30]	17-28	-
87	Bill-to Country/Region Code	Code[10]	17-28	-
88	Sell-to Post Code	Code[20]	17-28	-
89	Sell-to County	Text[30]	17-28	-
90	Sell-to Country/Region Code	Code[10]	17-28	-
91	Ship-to Post Code	Code[20]	17-28	-
92	Ship-to County	Text[30]	17-28	-
93	Ship-to Country/Region Code	Code[10]	17-28	-
94	Bal. Account Type	Enum Payment Balance Account Type	17-28	-
97	Exit Point	Code[10]	17-28	-
98	Correction	Boolean	17-28	-
99	Document Date	Date	17-28	-
100	External Document No.	Code[35]	17-28	-
101	Area	Code[10]	17-28	-
102	Transaction Specification	Code[10]	17-28	-
104	Payment Method Code	Code[10]	17-28	-
105	Shipping Agent Code	Code[10]	17-28	-
106	Package Tracking No.	Text[50]	17-28	-
107	Pre-Assigned No. Series	Code[20]	17-28	-
108	No. Series	Code[20]	17-28	-
110	Order No. Series	Code[20]	17-28	-
111	Pre-Assigned No.	Code[20]	17-28	-
112	User ID	Code[50]	17-28	-
113	Source Code	Code[10]	17-28	-
114	Tax Area Code	Code[20]	17-28	-
115	Tax Liable	Boolean	17-28	-
116	VAT Bus. Posting Group	Code[20]	17-28	-
119	VAT Base Discount %	Decimal	17-28	-
121	Invoice Discount Calculation	Option	17-28	-
122	Invoice Discount Value	Decimal	17-28	-
131	Prepayment No. Series	Code[20]	17-28	-
136	Prepayment Invoice	Boolean	17-28	-
137	Prepayment Order No.	Code[20]	17-28	-
151	Quote No.	Code[20]	17-28	-
163	Company Bank Account Code	Code[20]	20-28	-
166	Alt. VAT Registration No.	Boolean	17-23, 25-28	-
167	Alt. Gen. Bus Posting Group	Boolean	17-23, 25-28	-
168	Alt. VAT Bus Posting Group	Boolean	17-23, 25-28	-
169	Last Email Notif Cleared	Boolean	17-23, gone	Pending 21.0
Microsoft Invoicing has been discontinued.
171	Sell-to Phone No.	Text[30]	17-28	-
172	Sell-to E-Mail	Text[80]	17-28	-
176	Payment Instructions	Blob	17-25, gone	Removed 22.0
Microsoft Invoicing is not supported in Business Central
177	Payment Instructions Name	Text[20]	17-25, gone	Removed 22.0
Microsoft Invoicing is not supported in Business Central
179	VAT Reporting Date	Date	21-28	-
180	Payment Reference	Code[50]	17-28	-
185	Last Email Sent Time	DateTime	25-28	-
186	Last Email Sent Message Id	Guid	25-28	-
200	Work Description	Blob	17-28	-
210	Ship-to Phone No.	Text[30]	25-28	-
480	Dimension Set ID	Integer	17-28	-
600	Payment Service Set ID	Integer	17-28	-
710	Document Exchange Identifier	Text[50]	17-28	-
711	Document Exchange Status	Enum Sales Document Exchange Status	17-28	-
712	Doc. Exch. Original Identifier	Text[50]	17-28	-
720	Coupled to CRM	Boolean	17-28	Removed 26.0
Replaced by flow field Coupled to Dataverse
721	Coupled to Dataverse	Boolean	22-28	-
1200	Direct Debit Mandate ID	Code[35]	17-28	-
1302	Closed	Boolean	17-28	-
1303	Remaining Amount	Decimal	17-28	-
1304	Cust. Ledger Entry No.	Integer	17-28	-
1305	Invoice Discount Amount	Decimal	17-28	-
1310	Cancelled	Boolean	17-28	-
1311	Corrective	Boolean	17-28	-
1312	Reversed	Boolean	17-28	-
1340	Dispute Status	Code[10]	24-28	-
1341	Promised Pay Date	Date	24-28	-
5050	Campaign No.	Code[20]	17-28	-
5052	Sell-to Contact No.	Code[20]	17-28	-
5053	Bill-to Contact No.	Code[20]	17-28	-
5055	Opportunity No.	Code[20]	17-28	-
5700	Responsibility Center	Code[10]	17-28	-
5794	Shipping Agent Service Code	Code[10]	25-28	-
7000	Price Calculation Method	Enum Price Calculation Method	17-28	-
7001	Allow Line Disc.	Boolean	17-28	-
7200	Get Shipment Used	Boolean	17-28	-
8000	Id	Guid	17-25, gone	Removed 22.0
This functionality will be replaced by the systemID field
8001	Draft Invoice SystemId	Guid	17-28	-
8010	Dispute Status Id	Guid	24-28	-