Purch. Inv. Entity Aggregate #5477

Other table in Microsoft Dynamics 365 Business Central. 65 fields, 221 records in Cronus demo.

The Purch. Inv. Entity Aggregate table (ID 5477) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 65 fields, with a primary key of No., Posted, and includes 1 calculated FlowField. Use the reference below to explore every field, data type, and table relation.

Fields

221

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

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

All fields (65)

Purch. Inv. Entity Aggregate — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Document Type	Option	Normal
2	Buy-from Vendor No.	Code	Normal	→ Vendor #23
3	No. PK	Code	Normal
4	Pay-to Vendor No.	Code	Normal	→ Vendor #23
5	Pay-to Name	Text	Normal	→ Vendor #23
7	Pay-to Address	Text	Normal
8	Pay-to Address 2	Text	Normal
9	Pay-to City	Text	Normal
10	Pay-to Contact	Text	Normal
11	Your Reference	Text	Normal
12	Ship-to Code	Code	Normal
13	Ship-to Name	Text	Normal
15	Ship-to Address	Text	Normal
16	Ship-to Address 2	Text	Normal
17	Ship-to City	Text	Normal
18	Ship-to Contact	Text	Normal
20	Posting Date	Date	Normal
23	Payment Terms Code	Code	Normal	→ Payment Terms #3
24	Due Date	Date	Normal
27	Shipment Method Code	Code	Normal	→ Shipment Method #10
29	Shortcut Dimension 1 Code	Code	Normal	→ Dimension Value #349
30	Shortcut Dimension 2 Code	Code	Normal	→ Dimension Value #349
31	Vendor Posting Group	Code	Normal	→ Vendor Posting Group #93
32	Currency Code	Code	Normal	→ Currency #4
35	Prices Including VAT	Boolean	Normal
43	Purchaser Code	Code	Normal	→ Salesperson/Purchaser #13
44	Order No.	Code	Normal
56	Recalculate Invoice Disc. ⚡ FLOW	Boolean	FlowField
60	Amount	Decimal	Normal
61	Amount Including VAT	Decimal	Normal
68	Vendor Invoice No.	Code	Normal
79	Buy-from Vendor Name	Text	Normal	→ Vendor #23
81	Buy-from Address	Text	Normal
82	Buy-from Address 2	Text	Normal
83	Buy-from City	Text	Normal
84	Buy-from Contact	Text	Normal
85	Pay-to Post Code	Code	Normal
86	Pay-to County	Text	Normal
87	Pay-to Country/Region Code	Code	Normal	→ Country/Region #9
88	Buy-from Post Code	Code	Normal
89	Buy-from County	Text	Normal
90	Buy-from Country/Region Code	Code	Normal	→ Country/Region #9
91	Ship-to Post Code	Code	Normal
92	Ship-to County	Text	Normal
93	Ship-to Country/Region Code	Code	Normal	→ Country/Region #9
99	Document Date	Date	Normal
210	Ship-to Phone No.	Text	Normal
1304	Vendor Ledger Entry No.	Integer	Normal	→ Vendor Ledger Entry #25
1305	Invoice Discount Amount	Decimal	Normal
5052	Buy-from Contact No.	Code	Normal	→ Contact #5050
8000	Id	GUID	Normal
9600	Total Tax Amount	Decimal	Normal
9601	Status	Option	Normal
9602	Posted PK	Boolean	Normal
9624	Discount Applied Before Tax	Boolean	Normal
9630	Last Modified Date Time	DateTime	Normal
9631	Vendor Id	GUID	Normal	→ Vendor #23
9632	Order Id	GUID	Normal
9634	Currency Id	GUID	Normal	→ Currency #4
9638	Pay-to Vendor Id	GUID	Normal	→ Vendor #23
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