Objects/Tables/Table 5475 Sales Invoice Entity Aggregate

Fields, 78

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

Id	Name	Type	Versions	Obsolete
1	Document Type	Enum Sales Document Type	17-28	-
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	-
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	-
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	-
20	Posting Date	Date	17-28	-
23	Payment Terms Code	Code[10]	17-28	-
24	Due Date	Date	17-28	-
27	Shipment Method Code	Code[10]	17-28	-
29	Shortcut Dimension 1 Code	Code[20]	19-28	-
30	Shortcut Dimension 2 Code	Code[20]	19-28	-
31	Customer Posting Group	Code[20]	17-28	-
32	Currency Code	Code[10]	17-28	-
35	Prices Including VAT	Boolean	17-28	-
43	Salesperson Code	Code[20]	17-28	-
44	Order No.	Code[20]	17-28	-
56	Recalculate Invoice Disc.	Boolean	17-28	-
60	Amount	Decimal	17-28	-
61	Amount Including VAT	Decimal	17-28	-
70	VAT Registration No.	Text[20]	17-28	-
79	Sell-to Customer Name	Text[100]	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	-
99	Document Date	Date	17-28	-
100	External Document No.	Code[35]	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	-
121	Invoice Discount Calculation	Option	17-28	-
122	Invoice Discount Value	Decimal	17-28	-
167	Last Email Sent Status	Option	17-25, gone	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	17-28	-
171	Sell-to Phone No.	Text[30]	17-28	-
172	Sell-to E-Mail	Text[80]	17-28	-
210	Ship-to Phone No.	Text[30]	25-28	-
1304	Cust. Ledger Entry No.	Integer	17-28	-
1305	Invoice Discount Amount	Decimal	17-28	-
1340	Dispute Status	Code[10]	24-28	-
1341	Promised Pay Date	Date	24-28	-
5052	Sell-to Contact No.	Code[20]	17-28	-
8000	Id	Guid	17-28	-
8010	Dispute Status Id	Guid	24-28	-
9600	Total Tax Amount	Decimal	17-28	-
9601	Status	Enum Invoice Entity Aggregate Status	17-28	-
9602	Posted	Boolean	17-28	-
9603	Subtotal Amount	Decimal	17-28	-
9624	Discount Applied Before Tax	Boolean	17-28	-
9630	Last Modified Date Time	DateTime	17-28	-
9631	Customer Id	Guid	17-28	-
9632	Order Id	Guid	17-28	-
9633	Contact Graph Id	Text[250]	17-28	-
9634	Currency Id	Guid	17-28	-
9635	Payment Terms Id	Guid	17-28	-
9636	Shipment Method Id	Guid	17-28	-
9637	Tax Area ID	Guid	17-28	-
9638	Bill-to Customer Id	Guid	17-28	-