Purchase Order Entity Buffer

Dynamics 365 BC Table ReferenceTablesCompany TablesPPurchase Order Entity Buffer

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

Table Type: Company

Table Name: Purchase Order Entity Buffer
Database Table Name: CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5496

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 Purchase Order Entity Buffer can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [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]
   ,[Ship-to Code]
   ,[Ship-to Name]
   ,[Ship-to Address]
   ,[Ship-to Address 2]
   ,[Ship-to City]
   ,[Ship-to Contact]
   ,[Posting Date]
   ,[Payment Terms Code]
   ,[Shipment Method Code]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Vendor Posting Group]
   ,[Currency Code]
   ,[Prices Including VAT]
   ,[Purchaser Code]
   ,[Amount]
   ,[Amount Including VAT]
   ,[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_]
   ,[Completely Received]
   ,[Requested Receipt Date]
   ,[Id]
   ,[Total Tax Amount]
   ,[Status]
   ,[Discount Applied Before Tax]
   ,[Vendor Id]
   ,[Contact Graph Id]
   ,[Currency Id]
   ,[Payment Terms Id]
   ,[Shipment Method Id]
   ,[Pay-to Vendor Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purchase Order Entity Buffer].[Pay-to Name] = [Vendor].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Purchase Order Entity Buffer].[Pay-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
      ON
         [Purchase Order Entity Buffer].[Ship-to Code] = [Ship-to Address].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Purchase Order Entity Buffer].[Ship-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Purchase Order Entity Buffer].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Purchase Order Entity Buffer].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Purchase Order Entity Buffer].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Purchase Order Entity Buffer].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group]
      ON
         [Purchase Order Entity Buffer].[Vendor Posting Group] = [Vendor Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Purchase Order Entity Buffer].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [Purchase Order Entity Buffer].[Purchaser Code] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purchase Order Entity Buffer].[Buy-from Vendor Name] = [Vendor].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Purchase Order Entity Buffer].[Buy-from City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Purchase Order Entity Buffer].[Pay-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Purchase Order Entity Buffer].[Buy-from Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Purchase Order Entity Buffer].[Ship-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purchase Order Entity Buffer].[Vendor Id] = [Vendor].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Purchase Order Entity Buffer].[Currency Id] = [Currency].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Purchase Order Entity Buffer].[Payment Terms Id] = [Payment Terms].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Purchase Order Entity Buffer].[Shipment Method Id] = [Shipment Method].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purchase Order Entity Buffer].[Pay-to Vendor Id] = [Vendor].[$systemId]
LEFT JOIN
   [User] AS [User]
      ON
         [Purchase Order Entity Buffer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Purchase Order Entity Buffer].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Purchase Order Entity Buffer table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
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
       [Purchase Order Entity Buffer].[Buy-from Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Purchase Order Entity Buffer].[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
       [Purchase Order Entity Buffer].[Pay-to Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Purchase Order Entity Buffer].[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
       [Purchase Order Entity Buffer].[Pay-to Name]
       ,[Vendor].[Name]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Purchase Order Entity Buffer].[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
       [Purchase Order Entity Buffer].[Pay-to City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Purchase Order Entity Buffer].[Pay-to City] = [Post Code].[City]
10Pay-to Contact SearchPay-to ContactNormalText100Pay-to Contactnvarchar(200)
12Ship-to Code SearchShip-to CodeNormalCode10Ship-to Codenvarchar(20)
Key to join to the Ship-to Address table.

Show/hide example query

SELECT
       [Purchase Order Entity Buffer].[Ship-to Code]
       ,[Ship-to Address].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
              ON
                     [Purchase Order Entity Buffer].[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
       [Purchase Order Entity Buffer].[Ship-to City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Purchase Order Entity Buffer].[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
       [Purchase Order Entity Buffer].[Payment Terms Code]
       ,[Payment Terms].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
              ON
                     [Purchase Order Entity Buffer].[Payment Terms Code] = [Payment Terms].[Code]
27Shipment Method Code SearchShipment Method CodeNormalCode10Shipment Method Codenvarchar(20)
Key to join to the Shipment Method table.

Show/hide example query

SELECT
       [Purchase Order Entity Buffer].[Shipment Method Code]
       ,[Shipment Method].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
              ON
                     [Purchase Order Entity Buffer].[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
       [Purchase Order Entity Buffer].[Shortcut Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Purchase Order Entity Buffer].[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
       [Purchase Order Entity Buffer].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Purchase Order Entity Buffer].[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
       [Purchase Order Entity Buffer].[Vendor Posting Group]
       ,[Vendor Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group]
              ON
                     [Purchase Order Entity Buffer].[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
       [Purchase Order Entity Buffer].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Purchase Order Entity Buffer].[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
       [Purchase Order Entity Buffer].[Purchaser Code]
       ,[Salesperson/Purchaser].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
              ON
                     [Purchase Order Entity Buffer].[Purchaser Code] = [Salesperson/Purchaser].[Code]
56Recalculate Invoice Disc. SearchRecalculate Invoice Disc.FlowFieldBoolean4
60Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
61Amount Including VAT SearchAmount Including TaxNormalDecimal12Amount Including VATdecimal(38,38)
79Buy-from Vendor Name SearchBuy-from Vendor NameNormalText100Buy-from Vendor Namenvarchar(200)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Purchase Order Entity Buffer].[Buy-from Vendor Name]
       ,[Vendor].[Name]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Purchase Order Entity Buffer].[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
       [Purchase Order Entity Buffer].[Buy-from City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Purchase Order Entity Buffer].[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
       [Purchase Order Entity Buffer].[Pay-to Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Purchase Order Entity Buffer].[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
       [Purchase Order Entity Buffer].[Pay-to Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Purchase Order Entity Buffer].[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
       [Purchase Order Entity Buffer].[Buy-from Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Purchase Order Entity Buffer].[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
       [Purchase Order Entity Buffer].[Buy-from Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Purchase Order Entity Buffer].[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
       [Purchase Order Entity Buffer].[Ship-to Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Purchase Order Entity Buffer].[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
       [Purchase Order Entity Buffer].[Ship-to Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Purchase Order Entity Buffer].[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
       [Purchase Order Entity Buffer].[Vendor Ledger Entry No_]
       ,[Vendor Ledger Entry].[Entry No_]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Ledger Entry]
              ON
                     [Purchase Order Entity Buffer].[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
       [Purchase Order Entity Buffer].[Buy-from Contact No_]
       ,[Contact].[No_]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
              ON
                     [Purchase Order Entity Buffer].[Buy-from Contact No_] = [Contact].[No_]
5752Completely Received SearchCompletely ReceivedNormalBoolean4Completely Receivedtinyint
5790Requested Receipt Date SearchRequested Receipt DateNormalDate4Requested Receipt Datedatetime
8000Id SearchIdNormalGUID16Iduniqueidentifier
9600Total Tax Amount SearchTotal Tax AmountNormalDecimal12Total Tax Amountdecimal(38,38)
9601Status SearchStatusNormalOption4Statusint
Available options are:
  • “Draft”
  • “In Review”
  • “Open”
9624Discount Applied Before Tax SearchDiscount Applied Before TaxNormalBoolean4Discount Applied Before Taxtinyint
9631Vendor Id SearchVendor IdNormalGUID16Vendor Iduniqueidentifier
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Purchase Order Entity Buffer].[Vendor Id]
       ,[Vendor].[$systemId]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Purchase Order Entity Buffer].[Vendor Id] = [Vendor].[$systemId]
9633Contact Graph Id SearchContact Graph IdNormalText250Contact Graph Idnvarchar(500)
9634Currency Id SearchCurrency IdNormalGUID16Currency Iduniqueidentifier
Key to join to the Currency table.

Show/hide example query

SELECT
       [Purchase Order Entity Buffer].[Currency Id]
       ,[Currency].[$systemId]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Purchase Order Entity Buffer].[Currency Id] = [Currency].[$systemId]
9635Payment Terms Id SearchPayment Terms IdNormalGUID16Payment Terms Iduniqueidentifier
Key to join to the Payment Terms table.

Show/hide example query

SELECT
       [Purchase Order Entity Buffer].[Payment Terms Id]
       ,[Payment Terms].[$systemId]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
              ON
                     [Purchase Order Entity Buffer].[Payment Terms Id] = [Payment Terms].[$systemId]
9636Shipment Method Id SearchShipment Method IdNormalGUID16Shipment Method Iduniqueidentifier
Key to join to the Shipment Method table.

Show/hide example query

SELECT
       [Purchase Order Entity Buffer].[Shipment Method Id]
       ,[Shipment Method].[$systemId]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
              ON
                     [Purchase Order Entity Buffer].[Shipment Method Id] = [Shipment Method].[$systemId]
9638Pay-to Vendor Id SearchPay-to Vendor IdNormalGUID16Pay-to Vendor Iduniqueidentifier
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Purchase Order Entity Buffer].[Pay-to Vendor Id]
       ,[Vendor].[$systemId]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Purchase Order Entity Buffer].[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
       [Purchase Order Entity Buffer].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [User] AS [User]
              ON
                     [Purchase Order Entity Buffer].[$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
       [Purchase Order Entity Buffer].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Purchase Order Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Order Entity Buffer]
LEFT JOIN
       [User] AS [User]
              ON
                     [Purchase Order Entity Buffer].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Purchase Order Entity Buffer table

CurrencyPayment TermsSalesperson/PurchaserSalesperson/PurchaserShip-to AddressShipment MethodVendor Posting Group
Dynamics 365 BC Table ReferenceTablesCompany TablesPPurchase Order Entity Buffer

Leave a Reply

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