Purch. Inv. Entity Aggregate – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables PPurch. Inv. Entity Aggregate

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5477

Table Type: Company

Table Name: Purch. Inv. Entity Aggregate
Database Table Name: CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5477

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Purch. Inv. Entity Aggregate can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Document Type]
   ,[Buy-from Vendor No_]
   ,[No_]
   ,[Pay-to Vendor No_]
   ,[Pay-to Name]
   ,[Pay-to Address]
   ,[Pay-to Address 2]
   ,[Pay-to City]
   ,[Pay-to Contact]
   ,[Your Reference]
   ,[Ship-to Code]
   ,[Ship-to Name]
   ,[Ship-to Address]
   ,[Ship-to Address 2]
   ,[Ship-to City]
   ,[Ship-to Contact]
   ,[Posting Date]
   ,[Payment Terms Code]
   ,[Due Date]
   ,[Shipment Method Code]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Vendor Posting Group]
   ,[Currency Code]
   ,[Prices Including VAT]
   ,[Purchaser Code]
   ,[Order No_]
   ,[Amount]
   ,[Amount Including VAT]
   ,[Vendor Invoice No_]
   ,[Buy-from Vendor Name]
   ,[Buy-from Address]
   ,[Buy-from Address 2]
   ,[Buy-from City]
   ,[Buy-from Contact]
   ,[Pay-to Post Code]
   ,[Pay-to County]
   ,[Pay-to Country_Region Code]
   ,[Buy-from Post Code]
   ,[Buy-from County]
   ,[Buy-from Country_Region Code]
   ,[Ship-to Post Code]
   ,[Ship-to County]
   ,[Ship-to Country_Region Code]
   ,[Document Date]
   ,[Vendor Ledger Entry No_]
   ,[Invoice Discount Amount]
   ,[Buy-from Contact No_]
   ,[Id]
   ,[Total Tax Amount]
   ,[Status]
   ,[Posted]
   ,[Discount Applied Before Tax]
   ,[Last Modified Date Time]
   ,[Vendor Id]
   ,[Order Id]
   ,[Currency Id]
   ,[Pay-to Vendor Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Entity Aggregate]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Purch. Inv. Entity Aggregate].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Purch. Inv. Entity Aggregate].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Purch. Inv. Entity Aggregate].[Document Type] = [Sales Header].[Document Type]
      AND
         [Purch. Inv. Entity Aggregate].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purch. Inv. Entity Aggregate].[Pay-to Name] = [Vendor].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Purch. Inv. Entity Aggregate].[Pay-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
      ON
         [Purch. Inv. Entity Aggregate].[Ship-to Code] = [Ship-to Address].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Purch. Inv. Entity Aggregate].[Ship-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Purch. Inv. Entity Aggregate].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Purch. Inv. Entity Aggregate].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Purch. Inv. Entity Aggregate].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Purch. Inv. Entity Aggregate].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group]
      ON
         [Purch. Inv. Entity Aggregate].[Vendor Posting Group] = [Vendor Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Purch. Inv. Entity Aggregate].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [Purch. Inv. Entity Aggregate].[Purchaser Code] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purch. Inv. Entity Aggregate].[Buy-from Vendor Name] = [Vendor].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Purch. Inv. Entity Aggregate].[Buy-from City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Purch. Inv. Entity Aggregate].[Pay-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Purch. Inv. Entity Aggregate].[Buy-from Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Purch. Inv. Entity Aggregate].[Ship-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purch. Inv. Entity Aggregate].[Vendor Id] = [Vendor].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
      ON
         [Purch. Inv. Entity Aggregate].[Order Id] = [Shpfy Order Header].[Shopify Order Id]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Purch. Inv. Entity Aggregate].[Currency Id] = [Currency].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purch. Inv. Entity Aggregate].[Pay-to Vendor Id] = [Vendor].[$systemId]
LEFT JOIN
   [User] AS [User]
      ON
         [Purch. Inv. Entity Aggregate].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Purch. Inv. Entity Aggregate].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Purch. Inv. Entity Aggregate table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Document Type	Document Type	Normal	Option	4	Document Type	int
	Available options are: “Quote” “Order” “Invoice” “Credit Memo” “Blanket Order” “Return Order”
2	Buy-from Vendor No.	Buy-from Vendor No.	Normal	Code	20	Buy-from Vendor No_	nvarchar(40)
	Key to join to the Vendor table. Show/hide example query SELECT [Purch. Inv. Entity Aggregate].[Buy-from Vendor No_] ,[Vendor].[No_] FROM [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Entity Aggregate] LEFT JOIN [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor] ON [Purch. Inv. Entity Aggregate].[Buy-from Vendor No_] = [Vendor].[No_]
3	No.	No.	Normal	Code	20	No_	nvarchar(40)
4	Pay-to Vendor No.	Pay-to Vendor No.	Normal	Code	20	Pay-to Vendor No_	nvarchar(40)
	Key to join to the Vendor table. Show/hide example query SELECT [Purch. Inv. Entity Aggregate].[Pay-to Vendor No_] ,[Vendor].[No_] FROM [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Entity Aggregate] LEFT JOIN [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor] ON [Purch. Inv. Entity Aggregate].[Pay-to Vendor No_] = [Vendor].[No_]
5	Pay-to Name	Pay-to Name	Normal	Text	100	Pay-to Name	nvarchar(200)
	Key to join to the Vendor table. Show/hide example query SELECT [Purch. Inv. Entity Aggregate].[Pay-to Name] ,[Vendor].[Name] FROM [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Entity Aggregate] LEFT JOIN [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor] ON [Purch. Inv. Entity Aggregate].[Pay-to Name] = [Vendor].[Name]
7	Pay-to Address	Pay-to Address	Normal	Text	100	Pay-to Address	nvarchar(200)
8	Pay-to Address 2	Pay-to Address 2	Normal	Text	50	Pay-to Address 2	nvarchar(100)
9	Pay-to City	Pay-to City	Normal	Text	30	Pay-to City	nvarchar(60)
	Key to join to the Post Code table. Show/hide example query SELECT [Purch. Inv. Entity Aggregate].[Pay-to City] ,[Post Code].[City] FROM [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Entity Aggregate] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Purch. Inv. Entity Aggregate].[Pay-to City] = [Post Code].[City]
10	Pay-to Contact	Pay-to Contact	Normal	Text	100	Pay-to Contact	nvarchar(200)
11	Your Reference	Your Reference	Normal	Text	35	Your Reference	nvarchar(70)
12	Ship-to Code	Ship-to Code	Normal	Code	10	Ship-to Code	nvarchar(20)
	Key to join to the Ship-to Address table. Show/hide example query SELECT [Purch. Inv. Entity Aggregate].[Ship-to Code] ,[Ship-to Address].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Entity Aggregate] LEFT JOIN [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address] ON [Purch. Inv. Entity Aggregate].[Ship-to Code] = [Ship-to Address].[Code]
13	Ship-to Name	Ship-to Name	Normal	Text	100	Ship-to Name	nvarchar(200)
15	Ship-to Address	Ship-to Address	Normal	Text	100	Ship-to Address	nvarchar(200)
16	Ship-to Address 2	Ship-to Address 2	Normal	Text	50	Ship-to Address 2	nvarchar(100)
17	Ship-to City	Ship-to City	Normal	Text	30	Ship-to City	nvarchar(60)
	Key to join to the Post Code table. Show/hide example query SELECT [Purch. Inv. Entity Aggregate].[Ship-to City] ,[Post Code].[City] FROM [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Entity Aggregate] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Purch. Inv. Entity Aggregate].[Ship-to City] = [Post Code].[City]
18	Ship-to Contact	Ship-to Contact	Normal	Text	100	Ship-to Contact	nvarchar(200)
20	Posting Date	Posting Date	Normal	Date	4	Posting Date	datetime
23	Payment Terms Code	Payment Terms Code	Normal	Code	10	Payment Terms Code	nvarchar(20)
	Key to join to the Payment Terms table. Show/hide example query SELECT [Purch. Inv. Entity Aggregate].[Payment Terms Code] ,[Payment Terms].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Entity Aggregate] LEFT JOIN [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms] ON [Purch. Inv. Entity Aggregate].[Payment Terms Code] = [Payment Terms].[Code]
24	Due Date	Due Date	Normal	Date	4	Due Date	datetime
27	Shipment Method Code	Shipment Method Code	Normal	Code	10	Shipment Method Code	nvarchar(20)
	Key to join to the Shipment Method table. Show/hide example query SELECT [Purch. Inv. Entity Aggregate].[Shipment Method Code] ,[Shipment Method].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Entity Aggregate] LEFT JOIN [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method] ON [Purch. Inv. Entity Aggregate].[Shipment Method Code] = [Shipment Method].[Code]
29	Shortcut Dimension 1 Code	Shortcut Dimension 1 Code	Normal	Code	20	Shortcut Dimension 1 Code	nvarchar(40)
	Key to join to the Dimension table. Show/hide example query SELECT [Purch. Inv. Entity Aggregate].[Shortcut Dimension 1 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Entity Aggregate] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Purch. Inv. Entity Aggregate].[Shortcut Dimension 1 Code] = [Dimension].[Code]
30	Shortcut Dimension 2 Code	Shortcut Dimension 2 Code	Normal	Code	20	Shortcut Dimension 2 Code	nvarchar(40)
	Key to join to the Dimension table. Show/hide example query SELECT [Purch. Inv. Entity Aggregate].[Shortcut Dimension 2 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Entity Aggregate] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Purch. Inv. Entity Aggregate].[Shortcut Dimension 2 Code] = [Dimension].[Code]
31	Vendor Posting Group	Vendor Posting Group	Normal	Code	20	Vendor Posting Group	nvarchar(40)
	Key to join to the Vendor Posting Group table. Show/hide example query SELECT [Purch. Inv. Entity Aggregate].[Vendor Posting Group] ,[Vendor Posting Group].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Entity Aggregate] LEFT JOIN [CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group] ON [Purch. Inv. Entity Aggregate].[Vendor Posting Group] = [Vendor Posting Group].[Code]
32	Currency Code	Currency Code	Normal	Code	10	Currency Code	nvarchar(20)
	Key to join to the Currency table. Show/hide example query SELECT [Purch. Inv. Entity Aggregate].[Currency Code] ,[Currency].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Entity Aggregate] LEFT JOIN [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency] ON [Purch. Inv. Entity Aggregate].[Currency Code] = [Currency].[Code]
35	Prices Including VAT	Prices Including Tax	Normal	Boolean	4	Prices Including VAT	tinyint
43	Purchaser Code	Purchaser Code	Normal	Code	20	Purchaser Code	nvarchar(40)
	Key to join to the Salesperson/Purchaser table. Show/hide example query SELECT [Purch. Inv. Entity Aggregate].[Purchaser Code] ,[Salesperson/Purchaser].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Entity Aggregate] LEFT JOIN [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser] ON [Purch. Inv. Entity Aggregate].[Purchaser Code] = [Salesperson/Purchaser].[Code]
44	Order No.	Order No.	Normal	Code	20	Order No_	nvarchar(40)
56	Recalculate Invoice Disc.	Recalculate Invoice Disc.	FlowField	Boolean	4
60	Amount	Amount	Normal	Decimal	12	Amount	decimal(38,38)
61	Amount Including VAT	Amount Including Tax	Normal	Decimal	12	Amount Including VAT	decimal(38,38)
68	Vendor Invoice No.	Vendor Invoice No.	Normal	Code	35	Vendor Invoice No_	nvarchar(70)
79	Buy-from Vendor Name	Buy-from Vendor Name	Normal	Text	100	Buy-from Vendor Name	nvarchar(200)
	Key to join to the Vendor table. Show/hide example query SELECT [Purch. Inv. Entity Aggregate].[Buy-from Vendor Name] ,[Vendor].[Name] FROM [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Entity Aggregate] LEFT JOIN [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor] ON [Purch. Inv. Entity Aggregate].[Buy-from Vendor Name] = [Vendor].[Name]
81	Buy-from Address	Buy-from Address	Normal	Text	100	Buy-from Address	nvarchar(200)
82	Buy-from Address 2	Buy-from Address 2	Normal	Text	50	Buy-from Address 2	nvarchar(100)
83	Buy-from City	Buy-from City	Normal	Text	30	Buy-from City	nvarchar(60)
	Key to join to the Post Code table. Show/hide example query SELECT [Purch. Inv. Entity Aggregate].[Buy-from City] ,[Post Code].[City] FROM [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Entity Aggregate] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Purch. Inv. Entity Aggregate].[Buy-from City] = [Post Code].[City]
84	Buy-from Contact	Buy-from Contact	Normal	Text	100	Buy-from Contact	nvarchar(200)
85	Pay-to Post Code	Pay-to ZIP Code	Normal	Code	20	Pay-to Post Code	nvarchar(40)
	Key to join to the Post Code table. Show/hide example query SELECT [Purch. Inv. Entity Aggregate].[Pay-to Post Code] ,[Post Code].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Entity Aggregate] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Purch. Inv. Entity Aggregate].[Pay-to Post Code] = [Post Code].[Code]
86	Pay-to County	Pay-to State	Normal	Text	30	Pay-to County	nvarchar(60)
87	Pay-to Country/Region Code	Pay-to Country/Region Code	Normal	Code	10	Pay-to Country_Region Code	nvarchar(20)
88	Buy-from Post Code	Buy-from ZIP Code	Normal	Code	20	Buy-from Post Code	nvarchar(40)
	Key to join to the Post Code table. Show/hide example query SELECT [Purch. Inv. Entity Aggregate].[Buy-from Post Code] ,[Post Code].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Entity Aggregate] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Purch. Inv. Entity Aggregate].[Buy-from Post Code] = [Post Code].[Code]
89	Buy-from County	Buy-from State	Normal	Text	30	Buy-from County	nvarchar(60)
90	Buy-from Country/Region Code	Buy-from Country/Region Code	Normal	Code	10	Buy-from Country_Region Code	nvarchar(20)
91	Ship-to Post Code	Ship-to ZIP Code	Normal	Code	20	Ship-to Post Code	nvarchar(40)
	Key to join to the Post Code table. Show/hide example query SELECT [Purch. Inv. Entity Aggregate].[Ship-to Post Code] ,[Post Code].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Entity Aggregate] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Purch. Inv. Entity Aggregate].[Ship-to Post Code] = [Post Code].[Code]
92	Ship-to County	Ship-to State	Normal	Text	30	Ship-to County	nvarchar(60)
93	Ship-to Country/Region Code	Ship-to Country/Region Code	Normal	Code	10	Ship-to Country_Region Code	nvarchar(20)
99	Document Date	Document Date	Normal	Date	4	Document Date	datetime
1304	Vendor Ledger Entry No.	Vendor Ledger Entry No.	Normal	Integer	4	Vendor Ledger Entry No_	int
	Key to join to the Vendor Ledger Entry table. Show/hide example query SELECT [Purch. Inv. Entity Aggregate].[Vendor Ledger Entry No_] ,[Vendor Ledger Entry].[Entry No_] FROM [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Entity Aggregate] LEFT JOIN [CRONUS UK Ltd_$Vendor Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Ledger Entry] ON [Purch. Inv. Entity Aggregate].[Vendor Ledger Entry No_] = [Vendor Ledger Entry].[Entry No_]
1305	Invoice Discount Amount	Invoice Discount Amount	Normal	Decimal	12	Invoice Discount Amount	decimal(38,38)
5052	Buy-from Contact No.	Buy-from Contact No.	Normal	Code	20	Buy-from Contact No_	nvarchar(40)
	Key to join to the Contact table. Show/hide example query SELECT [Purch. Inv. Entity Aggregate].[Buy-from Contact No_] ,[Contact].[No_] FROM [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Entity Aggregate] LEFT JOIN [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact] ON [Purch. Inv. Entity Aggregate].[Buy-from Contact No_] = [Contact].[No_]
8000	Id	Id	Normal	GUID	16	Id	uniqueidentifier
9600	Total Tax Amount	Total Tax Amount	Normal	Decimal	12	Total Tax Amount	decimal(38,38)
9601	Status	Status	Normal	Option	4	Status	int
	Available options are: ” “ “Draft” “In Review” “Open” “Paid” “Canceled” “Corrective”
9602	Posted	Posted	Normal	Boolean	4	Posted	tinyint
9624	Discount Applied Before Tax	Discount Applied Before Tax	Normal	Boolean	4	Discount Applied Before Tax	tinyint
9630	Last Modified Date Time	Last Modified Date Time	Normal	DateTime	8	Last Modified Date Time	datetime
9631	Vendor Id	Vendor Id	Normal	GUID	16	Vendor Id	uniqueidentifier
	Key to join to the Vendor table. Show/hide example query SELECT [Purch. Inv. Entity Aggregate].[Vendor Id] ,[Vendor].[$systemId] FROM [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Entity Aggregate] LEFT JOIN [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor] ON [Purch. Inv. Entity Aggregate].[Vendor Id] = [Vendor].[$systemId]
9632	Order Id	Order Id	Normal	GUID	16	Order Id	uniqueidentifier
	Key to join to the Shpfy Order Header table. Show/hide example query SELECT [Purch. Inv. Entity Aggregate].[Order Id] ,[Shpfy Order Header].[Shopify Order Id] FROM [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Entity Aggregate] LEFT JOIN [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header] ON [Purch. Inv. Entity Aggregate].[Order Id] = [Shpfy Order Header].[Shopify Order Id]
9634	Currency Id	Currency Id	Normal	GUID	16	Currency Id	uniqueidentifier
	Key to join to the Currency table. Show/hide example query SELECT [Purch. Inv. Entity Aggregate].[Currency Id] ,[Currency].[$systemId] FROM [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Entity Aggregate] LEFT JOIN [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency] ON [Purch. Inv. Entity Aggregate].[Currency Id] = [Currency].[$systemId]
9638	Pay-to Vendor Id	Pay-to Vendor Id	Normal	GUID	16	Pay-to Vendor Id	uniqueidentifier
	Key to join to the Vendor table. Show/hide example query SELECT [Purch. Inv. Entity Aggregate].[Pay-to Vendor Id] ,[Vendor].[$systemId] FROM [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Entity Aggregate] LEFT JOIN [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor] ON [Purch. Inv. Entity Aggregate].[Pay-to Vendor Id] = [Vendor].[$systemId]
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Purch. Inv. Entity Aggregate].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Entity Aggregate] LEFT JOIN [User] AS [User] ON [Purch. Inv. Entity Aggregate].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Purch. Inv. Entity Aggregate table

Dynamics 365 BC Table Reference Tables Company Tables PPurch. Inv. Entity Aggregate

Leave a Reply Cancel reply