Purch. Inv. Entity Aggregate

Dynamics 365 BC Table ReferenceTablesCompany TablesPPurch. 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$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_$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_$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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Document Type SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • “Quote”
  • “Order”
  • “Invoice”
  • “Credit Memo”
  • “Blanket Order”
  • “Return Order”
2Buy-from Vendor No. SearchBuy-from Vendor No.NormalCode20Buy-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_]
3No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
4Pay-to Vendor No. SearchPay-to Vendor No.NormalCode20Pay-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_]
5Pay-to Name SearchPay-to NameNormalText100Pay-to Namenvarchar(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]
7Pay-to Address SearchPay-to AddressNormalText100Pay-to Addressnvarchar(200)
8Pay-to Address 2 SearchPay-to Address 2NormalText50Pay-to Address 2nvarchar(100)
9Pay-to City SearchPay-to CityNormalText30Pay-to Citynvarchar(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]
10Pay-to Contact SearchPay-to ContactNormalText100Pay-to Contactnvarchar(200)
11Your Reference SearchYour ReferenceNormalText35Your Referencenvarchar(70)
12Ship-to Code SearchShip-to CodeNormalCode10Ship-to Codenvarchar(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]
13Ship-to Name SearchShip-to NameNormalText100Ship-to Namenvarchar(200)
15Ship-to Address SearchShip-to AddressNormalText100Ship-to Addressnvarchar(200)
16Ship-to Address 2 SearchShip-to Address 2NormalText50Ship-to Address 2nvarchar(100)
17Ship-to City SearchShip-to CityNormalText30Ship-to Citynvarchar(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]
18Ship-to Contact SearchShip-to ContactNormalText100Ship-to Contactnvarchar(200)
20Posting Date SearchPosting DateNormalDate4Posting Datedatetime
23Payment Terms Code SearchPayment Terms CodeNormalCode10Payment Terms Codenvarchar(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]
24Due Date SearchDue DateNormalDate4Due Datedatetime
27Shipment Method Code SearchShipment Method CodeNormalCode10Shipment Method Codenvarchar(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]
29Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(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]
30Shortcut Dimension 2 Code SearchShortcut Dimension 2 CodeNormalCode20Shortcut Dimension 2 Codenvarchar(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]
31Vendor Posting Group SearchVendor Posting GroupNormalCode20Vendor Posting Groupnvarchar(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]
32Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(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]
35Prices Including VAT SearchPrices Including TaxNormalBoolean4Prices Including VATtinyint
43Purchaser Code SearchPurchaser CodeNormalCode20Purchaser Codenvarchar(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]
44Order No. SearchOrder No.NormalCode20Order No_nvarchar(40)
56Recalculate Invoice Disc. SearchRecalculate Invoice Disc.FlowFieldBoolean4
60Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
61Amount Including VAT SearchAmount Including TaxNormalDecimal12Amount Including VATdecimal(38,38)
68Vendor Invoice No. SearchVendor Invoice No.NormalCode35Vendor Invoice No_nvarchar(70)
79Buy-from Vendor Name SearchBuy-from Vendor NameNormalText100Buy-from Vendor Namenvarchar(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]
81Buy-from Address SearchBuy-from AddressNormalText100Buy-from Addressnvarchar(200)
82Buy-from Address 2 SearchBuy-from Address 2NormalText50Buy-from Address 2nvarchar(100)
83Buy-from City SearchBuy-from CityNormalText30Buy-from Citynvarchar(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]
84Buy-from Contact SearchBuy-from ContactNormalText100Buy-from Contactnvarchar(200)
85Pay-to Post Code SearchPay-to ZIP CodeNormalCode20Pay-to Post Codenvarchar(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]
86Pay-to County SearchPay-to StateNormalText30Pay-to Countynvarchar(60)
87Pay-to Country/Region Code SearchPay-to Country/Region CodeNormalCode10Pay-to Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Purch. Inv. Entity Aggregate].[Pay-to Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Purch. Inv. Entity Aggregate].[Pay-to Country_Region Code] = [Country/Region].[Code]
88Buy-from Post Code SearchBuy-from ZIP CodeNormalCode20Buy-from Post Codenvarchar(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]
89Buy-from County SearchBuy-from StateNormalText30Buy-from Countynvarchar(60)
90Buy-from Country/Region Code SearchBuy-from Country/Region CodeNormalCode10Buy-from Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Purch. Inv. Entity Aggregate].[Buy-from Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Purch. Inv. Entity Aggregate].[Buy-from Country_Region Code] = [Country/Region].[Code]
91Ship-to Post Code SearchShip-to ZIP CodeNormalCode20Ship-to Post Codenvarchar(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]
92Ship-to County SearchShip-to StateNormalText30Ship-to Countynvarchar(60)
93Ship-to Country/Region Code SearchShip-to Country/Region CodeNormalCode10Ship-to Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Purch. Inv. Entity Aggregate].[Ship-to Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Inv_ Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Purch. Inv. Entity Aggregate].[Ship-to Country_Region Code] = [Country/Region].[Code]
99Document Date SearchDocument DateNormalDate4Document Datedatetime
1304Vendor Ledger Entry No. SearchVendor Ledger Entry No.NormalInteger4Vendor 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_]
1305Invoice Discount Amount SearchInvoice Discount AmountNormalDecimal12Invoice Discount Amountdecimal(38,38)
5052Buy-from Contact No. SearchBuy-from Contact No.NormalCode20Buy-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_]
8000Id SearchIdNormalGUID16Iduniqueidentifier
9600Total Tax Amount SearchTotal Tax AmountNormalDecimal12Total Tax Amountdecimal(38,38)
9601Status SearchStatusNormalOption4Statusint
Available options are:
  • ” “
  • “Draft”
  • “In Review”
  • “Open”
  • “Paid”
  • “Canceled”
  • “Corrective”
9602Posted Primary Key SearchPostedNormalBoolean4Postedtinyint
9624Discount Applied Before Tax SearchDiscount Applied Before TaxNormalBoolean4Discount Applied Before Taxtinyint
9630Last Modified Date Time SearchLast Modified Date TimeNormalDateTime8Last Modified Date Timedatetime
9631Vendor Id SearchVendor IdNormalGUID16Vendor Iduniqueidentifier
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]
9632Order Id SearchOrder IdNormalGUID16Order Iduniqueidentifier
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]
9634Currency Id SearchCurrency IdNormalGUID16Currency Iduniqueidentifier
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]
9638Pay-to Vendor Id SearchPay-to Vendor IdNormalGUID16Pay-to Vendor Iduniqueidentifier
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 SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Purch. Inv. Entity Aggregate].[$systemModifiedBy]
       ,[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].[$systemModifiedBy] = [User].[User Security ID]

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

CurrencyPayment TermsSales HeaderSales Header ArchiveSalesperson/PurchaserSalesperson/PurchaserShip-to AddressShipment MethodVendor Posting Group
Dynamics 365 BC Table ReferenceTablesCompany TablesPPurch. Inv. Entity Aggregate

Leave a Reply

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