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

Show/hide tables related from Purch_ Inv_ Entity Aggregate table

Leave a Reply

Your email address will not be published. Required fields are marked *