Purch. Inv. Line Aggregate #5478

Other table in Microsoft Dynamics 365 Business Central. 48 fields, 0 records in Cronus demo.

The Purch. Inv. Line Aggregate table (ID 5478) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 48 fields, with a primary key of Line No., Document Id. Use the reference below to explore every field, data type, and table relation.

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Line No., Document Id.

All fields (48)

Purch. Inv. Line Aggregate — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
4	Line No. PK	Integer	Normal
5	Type	Option	Normal
6	No.	Code	Normal
7	Location Code	Code	Normal	→ Location #14
10	Expected Receipt Date	Date	Normal
11	Description	Text	Normal
12	Description 2	Text	Normal
15	Quantity	Decimal	Normal
17	Qty. to Invoice	Decimal	Normal
18	Qty. to Receive	Decimal	Normal
22	Direct Unit Cost	Decimal	Normal
25	VAT %	Decimal	Normal
27	Line Discount %	Decimal	Normal
28	Line Discount Amount	Decimal	Normal
29	Amount	Decimal	Normal
30	Amount Including VAT	Decimal	Normal
60	Quantity Received	Decimal	Normal
61	Quantity Invoiced	Decimal	Normal
69	Inv. Discount Amount	Decimal	Normal
87	Tax Group Code	Code	Normal	→ Tax Group #321
90	VAT Prod. Posting Group	Code	Normal	→ VAT Product Posting Group #324
91	Currency Code	Code	Normal	→ Currency #4
99	VAT Base Amount	Decimal	Normal
103	Line Amount	Decimal	Normal
5402	Variant Code	Code	Normal
5407	Unit of Measure Code	Code	Normal
8000	Document Id PK	GUID	Normal
8001	Id	Text	Normal
8002	Variant Id	GUID	Normal
9020	Tax Code	Code	Normal
9021	Tax Amount	Decimal	Normal
9022	Discount Applied Before Tax	Boolean	Normal
9029	API Type	Option	Normal
9030	Item Id	GUID	Normal	→ Item #27
9031	Account Id	GUID	Normal	→ G/L Account #15
9032	Unit of Measure Id	GUID	Normal	→ Unit of Measure #204
9039	Line Tax Amount	Decimal	Normal
9040	Line Amount Including Tax	Decimal	Normal
9041	Line Amount Excluding Tax	Decimal	Normal
9042	Prices Including Tax	Boolean	Normal
9043	Inv. Discount Amount Excl. VAT	Decimal	Normal
9044	Tax Id	GUID	Normal
9070	Location Id	GUID	Normal	→ Location #14
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal

Related tables (8)

Tables referenced by fields on the Purch. Inv. Line Aggregate table through TableRelation properties.

Location

#14 · General Ledger · via Location Code, Location Id

Tax Group

#321 · Other · via Tax Group Code

VAT Product Posting Group

#324 · Other · via VAT Prod. Posting Group

Currency

#4 · General Ledger · via Currency Code

Item

#27 · Inventory · via Item Id

G/L Account

#15 · General Ledger · via Account Id

Unit of Measure

#204 · Other · via Unit of Measure Id