Objects/Tables/Table 5475 Sales Invoice Entity Aggregate

Table 5475 Sales Invoice Entity Aggregate in 20

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

App: Base Application

Versions17 18 192021 22 23 24 25 26 27 28 latest

Source29

Fields, 74

Id	Name	Type	Obsolete
1	Document Type	Enum Sales Document Type	-
2	Sell-to Customer No.	Code[20]	-
3	No.	Code[20]	-
4	Bill-to Customer No.	Code[20]	-
5	Bill-to Name	Text[100]	-
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]	-
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]	-
20	Posting Date	Date	-
23	Payment Terms Code	Code[10]	-
24	Due Date	Date	-
27	Shipment Method 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]	-
35	Prices Including VAT	Boolean	-
43	Salesperson Code	Code[20]	-
44	Order No.	Code[20]	-
56	Recalculate Invoice Disc.	Boolean	-
60	Amount	Decimal	-
61	Amount Including VAT	Decimal	-
70	VAT Registration No.	Text[20]	-
79	Sell-to Customer Name	Text[100]	-
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]	-
99	Document Date	Date	-
100	External Document No.	Code[35]	-
114	Tax Area Code	Code[20]	-
115	Tax Liable	Boolean	-
116	VAT Bus. Posting Group	Code[20]	-
121	Invoice Discount Calculation	Option	-
122	Invoice Discount Value	Decimal	-
167	Last Email Sent Status	Option	Removed 15.0
Do not store the sent status in the entity but calculate it on a fly to avoid etag change after invoice sending.
170	IsTest	Boolean	-
171	Sell-to Phone No.	Text[30]	-
172	Sell-to E-Mail	Text[80]	-
1304	Cust. Ledger Entry No.	Integer	-
1305	Invoice Discount Amount	Decimal	-
5052	Sell-to Contact No.	Code[20]	-
8000	Id	Guid	-
9600	Total Tax Amount	Decimal	-
9601	Status	Enum Invoice Entity Aggregate Status	-
9602	Posted	Boolean	-
9603	Subtotal Amount	Decimal	-
9624	Discount Applied Before Tax	Boolean	-
9630	Last Modified Date Time	DateTime	-
9631	Customer Id	Guid	-
9632	Order Id	Guid	-
9633	Contact Graph Id	Text[250]	-
9634	Currency Id	Guid	-
9635	Payment Terms Id	Guid	-
9636	Shipment Method Id	Guid	-
9637	Tax Area ID	Guid	-
9638	Bill-to Customer Id	Guid	-

Keys, 4

Name	Fields	Obsolete
Key1	No., Posted	-
Key2, clustered	Id	-
Key3	Cust. Ledger Entry No.	-
Key4	Document Date, Status	-

Procedures, 9

Name	Parameters	Returns	Access	Obsolete
UpdateCurrencyId	()		public	-
UpdatePaymentTermsId	()		public	-
UpdateShipmentMethodId	()		public	-
UpdateReferencedRecordIds	()		public	-
UpdateGraphContactId	()		public	Pending 20.0
The functionality that uses this was removed
IsUsingVAT	()	Boolean	public	-
GetIsRenameAllowed	()	Boolean	public	-
SetIsRenameAllowed	(Boolean)		public	-
GetParentRecordNativeInvoicing	(var Record Sales Header, var Record Sales Invoice Header)	Boolean	public	-