Table 5478 Purch. Inv. Line Aggregate in 22

App
Base Application

Fields, 43Keys, 2Procedures, 4

Versions171819202122232425262728latest

Source29

Fields, 43

IdNameTypeObsolete
4Line No.Integer-
5TypeEnum Purchase Line Type-
6No.Code[20]-
7Location CodeCode[10]-
10Expected Receipt DateDate-
11DescriptionText[100]-
12Description 2Text[50]-
15QuantityDecimal-
17Qty. to InvoiceDecimal-
18Qty. to ReceiveDecimal-
22Direct Unit CostDecimal-
25VAT %Decimal-
27Line Discount %Decimal-
28Line Discount AmountDecimal-
29AmountDecimal-
30Amount Including VATDecimal-
60Quantity ReceivedDecimal-
61Quantity InvoicedDecimal-
69Inv. Discount AmountDecimal-
87Tax Group CodeCode[20]-
90VAT Prod. Posting GroupCode[20]-
91Currency CodeCode[10]-
99VAT Base AmountDecimal-
103Line AmountDecimal-
5402Variant CodeCode[10]-
5407Unit of Measure CodeCode[10]-
8000Document IdGuid-
8001IdText[50]-
8002Variant IdGuid-
9020Tax CodeCode[50]-
9021Tax AmountDecimal-
9022Discount Applied Before TaxBoolean-
9029API TypeEnum Invoice Line Agg. Line Type-
9030Item IdGuid-
9031Account IdGuid-
9032Unit of Measure IdGuid-
9039Line Tax AmountDecimal-
9040Line Amount Including TaxDecimal-
9041Line Amount Excluding TaxDecimal-
9042Prices Including TaxBoolean-
9043Inv. Discount Amount Excl. VATDecimal-
9044Tax IdGuid-
9070Location IdGuid-

Keys, 2

NameFieldsObsolete
Key1, clusteredDocument Id, Line No.-
Key2Id-

Procedures, 4

NameParametersReturnsAccessObsolete
UpdateItemId()public-
UpdateAccountId()public-
UpdateNo()public-
UpdateReferencedRecordIds()public-