Objects/Tables/Table 112 Sales Invoice Header

Table 112 Sales Invoice Header in 23

Jonas Paprotka, Base Application 23.5.16502.31399, checked 2026-09-20

App: Base Application
Namespace: Microsoft.Sales.History

Fields, 133 Keys, 13 Procedures, 32 Events, 15

Versions17 18 19 20 21 222324 25 26 27 28 latest

Source29

Fields, 133

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

Keys, 13

Name	Fields	Obsolete
Key1, clustered	No.	-
Key2	Order No.	-
Key3	Pre-Assigned No.	-
Key4	Sell-to Customer No., External Document No.	-
Key5	Sell-to Customer No., Order Date	-
Key6	Sell-to Customer No.	-
Key7	Prepayment Order No., Prepayment Invoice	-
Key8	Bill-to Customer No.	-
Key9	Posting Date	-
Key10	Document Exchange Status	-
Key11	Due Date	-
Key12	Salesperson Code	-
Key13	SystemModifiedAt	-

Procedures, 32

Name	Parameters	Returns	Access	Obsolete
IsFullyOpen	()	Boolean	public	-
SendRecords	()		public	-
SendProfile	(var Record Document Sending Profile)		public	-
PrintRecords	(Boolean)		public	-
PrintToDocumentAttachment	(var Record Sales Invoice Header)		public	-
EmailRecords	(Boolean)		public	-
GetDocTypeTxt	()	Text[50]	public	-
Navigate	()		public	-
LookupAdjmtValueEntries	()		public	-
GetCustomerVATRegistrationNumber	()	Text	public	-
GetCustomerVATRegistrationNumberLbl	()	Text	public	-
GetCustomerGlobalLocationNumber	()	Text	public	-
GetCustomerGlobalLocationNumberLbl	()	Text	public	-
GetSellToCustomerFaxNo	()	Text	public	-
GetPaymentReference	()	Text	public	-
GetPaymentReferenceLbl	()	Text	public	-
GetLegalStatement	()	Text	public	-
GetRemainingAmount	()	Decimal	public	-
ShowDimensions	()		public	-
SetSecurityFilterOnRespCenter	()		public	-
GetDocExchStatusStyle	()	Text	public	-
ShowActivityLog	()		public	-
StartTrackingSite	()		public	-
GetSelectedPaymentsText	()	Text	public	-
GetWorkDescription	()	Text	public	-
GetCurrencySymbol	()	Text[10]	public	-
DocExchangeStatusIsSent	()	Boolean	public	-
ShowCanceledOrCorrCrMemo	()		public	-
ShowCorrectiveCreditMemo	()		public	-
ShowCancelledCreditMemo	()		public	-
GetDefaultEmailDocumentName	()	Text[150]	public	-
CheckNoPrinted	()		public	-

Events, 15

Kind	Name	Parameters	Obsolete
Integration event	OnBeforePrintRecords	(var Record Report Selections, var Record Sales Invoice Header, Boolean, var Boolean)	-
Integration event	OnBeforeSendProfile	(var Record Report Selections, var Record Sales Invoice Header, Text, var Boolean, var Record Document Sending Profile)	-
Integration event	OnBeforeSendRecords	(var Record Report Selections, var Record Sales Invoice Header, Text, var Boolean)	-
Integration event	OnBeforeShowCanceledOrCorrCrMemo	(var Record Sales Invoice Header, var Boolean)	-
Integration event	OnBeforeShowCorrectiveCreditMemo	(var Record Sales Invoice Header, var Boolean)	-
Integration event	OnBeforeShowCancelledCreditMemo	(var Record Sales Invoice Header, var Boolean)	-
Integration event	OnGetPaymentReference	(var Text)	-
Integration event	OnGetPaymentReferenceLbl	(var Text)	-
Integration event	OnLookupAppliesToDocNoOnAfterSetFilters	(var Record Cust. Ledger Entry, Record Sales Invoice Header)	-
Integration event	OnBeforeDoPrintToDocumentAttachment	(var Record Sales Invoice Header, var Boolean, var Boolean)	-
Integration event	OnBeforeSetSecurityFilterOnRespCenter	(var Record Sales Invoice Header, var Boolean)	-
Integration event	OnBeforeCheckNoPrinted	(var Record Sales Invoice Header, var Boolean)	-
Integration event	OnBeforeEmailRecords	(var Record Report Selections, var Record Sales Invoice Header, Text, var Boolean, var Boolean)	-
Integration event	OnPostedSalesInvoiceFullyOpen	(var Record Sales Invoice Header, var Boolean, var Boolean)	-
Integration event	OnBeforeGetWorkDescription	(var Record Sales Invoice Header)	-