Purchase Order Entity Buffer – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables PPurchase Order Entity Buffer

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

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

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

Show/hide columns in Purchase Order Entity Buffer table

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

Show/hide tables related from Purchase Order Entity Buffer table

Currency Payment Terms Shipment Method Vendor

Dynamics 365 BC Table Reference Tables Company Tables PPurchase Order Entity Buffer

Leave a Reply Cancel reply