Table 5476 Sales Invoice Line Aggregate in 24

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

Source29

Fields, 45

Id	Name	Type	Obsolete
4	Line No.	Integer	-
5	Type	Enum Sales Line Type	-
6	No.	Code[20]	-
7	Location Code	Code[10]	-
10	Shipment Date	Date	-
11	Description	Text[100]	-
12	Description 2	Text[50]	-
15	Quantity	Decimal	-
17	Qty. to Invoice	Decimal	-
18	Qty. to Ship	Decimal	-
22	Unit Price	Decimal	-
25	VAT %	Decimal	-
27	Line Discount %	Decimal	-
28	Line Discount Amount	Decimal	-
29	Amount	Decimal	-
30	Amount Including VAT	Decimal	-
60	Quantity Shipped	Decimal	-
61	Quantity Invoiced	Decimal	-
69	Inv. Discount Amount	Decimal	-
87	Tax Group Code	Code[20]	-
90	VAT Prod. Posting Group	Code[20]	-
91	Currency Code	Code[10]	-
99	VAT Base Amount	Decimal	-
103	Line Amount	Decimal	-
180	Line Discount Calculation	Option	-
5402	Variant Code	Code[10]	-
5407	Unit of Measure Code	Code[10]	-
8000	Document Id	Guid	-
8001	Id	Text[50]	-
8002	Variant Id	Guid	-
9020	Tax Code	Code[50]	-
9021	Tax Amount	Decimal	-
9022	Discount Applied Before Tax	Boolean	-
9029	API Type	Enum Invoice Line Agg. Line Type	-
9030	Item Id	Guid	-
9031	Account Id	Guid	-
9032	Unit of Measure Id	Guid	-
9039	Line Tax Amount	Decimal	-
9040	Line Amount Including Tax	Decimal	-
9041	Line Amount Excluding Tax	Decimal	-
9042	Prices Including Tax	Boolean	-
9043	Inv. Discount Amount Excl. VAT	Decimal	-
9044	Tax Id	Guid	-
9050	Line Discount Value	Decimal	-
9070	Location Id	Guid	-

Name	Fields	Obsolete
Key1, clustered	Document Id, Line No.	-
Key2	Id	-

Name	Parameters	Access	Obsolete
UpdateItemId	()	public	-
UpdateAccountId	()	public	-
UpdateNo	()	public	-
UpdateReferencedRecordIds	()	public	-
UpdateLineDiscounts	()	public	-
SetDiscountValue	()	public	-