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: 0

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

   [timestamp]
   ,[No_]
   ,[Posted]
   ,[Document Type]
   ,[Buy-from Vendor 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]
   ,[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_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purch_ Inv_ Entity Aggregate].[Buy-from Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purch_ Inv_ Entity Aggregate].[Pay-to Vendor No_] = [Vendor].[No_]
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_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Purch_ Inv_ Entity Aggregate].[Currency Code] = [Currency].[Code]

Show/hide columns in Purch_ Inv_ Entity Aggregate table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	No_	nvarchar(40)
3	Posted	tinyint
4	Document Type	int
5	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_]
6	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_]
7	Pay-to Name	nvarchar(200)
8	Pay-to Address	nvarchar(200)
9	Pay-to Address 2	nvarchar(100)
10	Pay-to City	nvarchar(60)
11	Pay-to Contact	nvarchar(200)
12	Your Reference	nvarchar(70)
13	Ship-to Code	nvarchar(20)
14	Ship-to Name	nvarchar(200)
15	Ship-to Address	nvarchar(200)
16	Ship-to Address 2	nvarchar(100)
17	Ship-to City	nvarchar(60)
18	Ship-to Contact	nvarchar(200)
19	Posting Date	datetime
20	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]
21	Due Date	datetime
22	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]
23	Shortcut Dimension 1 Code	nvarchar(40)
24	Shortcut Dimension 2 Code	nvarchar(40)
25	Vendor Posting Group	nvarchar(40)
26	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]
27	Prices Including VAT	tinyint
28	Purchaser Code	nvarchar(40)
29	Order No_	nvarchar(40)
30	Amount	decimal(38,38)
31	Amount Including VAT	decimal(38,38)
32	Vendor Invoice No_	nvarchar(70)
33	Buy-from Vendor Name	nvarchar(200)
34	Buy-from Address	nvarchar(200)
35	Buy-from Address 2	nvarchar(100)
36	Buy-from City	nvarchar(60)
37	Buy-from Contact	nvarchar(200)
38	Pay-to Post Code	nvarchar(40)
39	Pay-to County	nvarchar(60)
40	Pay-to Country_Region Code	nvarchar(20)
41	Buy-from Post Code	nvarchar(40)
42	Buy-from County	nvarchar(60)
43	Buy-from Country_Region Code	nvarchar(20)
44	Ship-to Post Code	nvarchar(40)
45	Ship-to County	nvarchar(60)
46	Ship-to Country_Region Code	nvarchar(20)
47	Document Date	datetime
48	Vendor Ledger Entry No_	int
49	Invoice Discount Amount	decimal(38,38)
50	Buy-from Contact No_	nvarchar(40)
51	Id	uniqueidentifier
52	Total Tax Amount	decimal(38,38)
53	Status	int
54	Discount Applied Before Tax	tinyint
55	Last Modified Date Time	datetime
56	Vendor Id	uniqueidentifier
57	Order Id	uniqueidentifier
58	Currency Id	uniqueidentifier
59	Pay-to Vendor Id	uniqueidentifier
60	$systemId	uniqueidentifier
61	$systemCreatedAt	datetime
62	$systemCreatedBy	uniqueidentifier
63	$systemModifiedAt	datetime
64	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Purch_ Inv_ Entity Aggregate table

Currency Payment Terms Shipment Method Vendor

Dynamics 365 BC Table Reference Tables Company Tables PPurch_ Inv_ Entity Aggregate

Leave a Reply Cancel reply