Objects/Tables/Table 112 Sales Invoice Header

Table 112 Sales Invoice Header in 20

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

App: Base Application

Fields, 130 Keys, 13 Procedures, 31 Events, 12

Versions17 18 192021 22 23 24 25 26 27 28 latest

Source29

Fields, 130

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]	-
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	-
167	Last Email Sent Status	Option	-
168	Sent as Email	Boolean	-
169	Last Email Notif Cleared	Boolean	-
171	Sell-to Phone No.	Text[30]	-
172	Sell-to E-Mail	Text[80]	-
176	Payment Instructions	Blob	Pending 19.0
Microsoft Invoicing is not supported in Business Central
177	Payment Instructions Name	Text[20]	Pending 19.0
Microsoft Invoicing is not supported in Business Central
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	-
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	Pending 15.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, 31

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	-

Events, 12

Kind	Name	Parameters	Obsolete
Integration event	OnBeforeEmailRecords	(var Record Report Selections, var Record Sales Invoice Header, Text, Boolean, var Boolean)	-
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)	-