Purch_ Rcpt_ Header – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables PPurch_ Rcpt_ Header

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

Table Type: Company

Table Name: Purch_ Rcpt_ Header
Database Table Name: CRONUS UK Ltd_$Purch_ Rcpt_ Header$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_ Rcpt_ Header can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Purch_ Rcpt_ Header$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 Name 2]
   ,[Pay-to Address]
   ,[Pay-to Address 2]
   ,[Pay-to City]
   ,[Pay-to Contact]
   ,[Your Reference]
   ,[Ship-to Code]
   ,[Ship-to Name]
   ,[Ship-to Name 2]
   ,[Ship-to Address]
   ,[Ship-to Address 2]
   ,[Ship-to City]
   ,[Ship-to Contact]
   ,[Order Date]
   ,[Posting Date]
   ,[Expected Receipt Date]
   ,[Posting Description]
   ,[Payment Terms Code]
   ,[Due Date]
   ,[Payment Discount _]
   ,[Pmt_ Discount Date]
   ,[Shipment Method Code]
   ,[Location Code]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Vendor Posting Group]
   ,[Currency Code]
   ,[Currency Factor]
   ,[Invoice Disc_ Code]
   ,[Language Code]
   ,[Purchaser Code]
   ,[Order No_]
   ,[No_ Printed]
   ,[On Hold]
   ,[Applies-to Doc_ Type]
   ,[Applies-to Doc_ No_]
   ,[Bal_ Account No_]
   ,[Vendor Order No_]
   ,[Vendor Shipment No_]
   ,[VAT Registration No_]
   ,[Sell-to Customer No_]
   ,[Reason Code]
   ,[Gen_ Bus_ Posting Group]
   ,[Transaction Type]
   ,[Transport Method]
   ,[VAT Country_Region Code]
   ,[Buy-from Vendor Name]
   ,[Buy-from Vendor Name 2]
   ,[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]
   ,[Bal_ Account Type]
   ,[Order Address Code]
   ,[Entry Point]
   ,[Correction]
   ,[Document Date]
   ,[Area]
   ,[Transaction Specification]
   ,[Payment Method Code]
   ,[No_ Series]
   ,[Order No_ Series]
   ,[User ID]
   ,[Source Code]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[VAT Bus_ Posting Group]
   ,[VAT Base Discount _]
   ,[Quote No_]
   ,[Dimension Set ID]
   ,[Campaign No_]
   ,[Buy-from Contact No_]
   ,[Pay-to Contact no_]
   ,[Responsibility Center]
   ,[Requested Receipt Date]
   ,[Promised Receipt Date]
   ,[Lead Time Calculation]
   ,[Inbound Whse_ Handling Time]
   ,[Price Calculation Method]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Purch_ Rcpt_ Header$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_ Rcpt_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Header]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purch_ Rcpt_ Header].[Buy-from Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purch_ Rcpt_ Header].[Pay-to Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Purch_ Rcpt_ Header].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Purch_ Rcpt_ Header].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Purch_ Rcpt_ Header].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Purch_ Rcpt_ Header].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Purch_ Rcpt_ Header].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Purch_ Rcpt_ Header].[Sell-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
      ON
         [Purch_ Rcpt_ Header].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Purch_ Rcpt_ Header].[Tax Area Code] = [Tax Area].[Code]

Show/hide columns in Purch_ Rcpt_ Header 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 [Purch_ Rcpt_ Header].[Buy-from Vendor No_] ,[Vendor].[No_] FROM [CRONUS UK Ltd_$Purch_ Rcpt_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Header] LEFT JOIN [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor] ON [Purch_ Rcpt_ Header].[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 [Purch_ Rcpt_ Header].[Pay-to Vendor No_] ,[Vendor].[No_] FROM [CRONUS UK Ltd_$Purch_ Rcpt_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Header] LEFT JOIN [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor] ON [Purch_ Rcpt_ Header].[Pay-to Vendor No_] = [Vendor].[No_]
5	Pay-to Name	nvarchar(200)
6	Pay-to Name 2	nvarchar(100)
7	Pay-to Address	nvarchar(200)
8	Pay-to Address 2	nvarchar(100)
9	Pay-to City	nvarchar(60)
10	Pay-to Contact	nvarchar(200)
11	Your Reference	nvarchar(70)
12	Ship-to Code	nvarchar(20)
13	Ship-to Name	nvarchar(200)
14	Ship-to Name 2	nvarchar(100)
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	Order Date	datetime
20	Posting Date	datetime
21	Expected Receipt Date	datetime
22	Posting Description	nvarchar(200)
23	Payment Terms Code	nvarchar(20)
	Key to join to the Payment Terms table. Show/hide example query SELECT [Purch_ Rcpt_ Header].[Payment Terms Code] ,[Payment Terms].[Code] FROM [CRONUS UK Ltd_$Purch_ Rcpt_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Header] LEFT JOIN [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms] ON [Purch_ Rcpt_ Header].[Payment Terms Code] = [Payment Terms].[Code]
24	Due Date	datetime
25	Payment Discount _	decimal(38,38)
26	Pmt_ Discount Date	datetime
27	Shipment Method Code	nvarchar(20)
	Key to join to the Shipment Method table. Show/hide example query SELECT [Purch_ Rcpt_ Header].[Shipment Method Code] ,[Shipment Method].[Code] FROM [CRONUS UK Ltd_$Purch_ Rcpt_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Header] LEFT JOIN [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method] ON [Purch_ Rcpt_ Header].[Shipment Method Code] = [Shipment Method].[Code]
28	Location Code	nvarchar(20)
	Key to join to the Location table. Show/hide example query SELECT [Purch_ Rcpt_ Header].[Location Code] ,[Location].[Code] FROM [CRONUS UK Ltd_$Purch_ Rcpt_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Header] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Purch_ Rcpt_ Header].[Location Code] = [Location].[Code]
29	Shortcut Dimension 1 Code	nvarchar(40)
30	Shortcut Dimension 2 Code	nvarchar(40)
31	Vendor Posting Group	nvarchar(40)
32	Currency Code	nvarchar(20)
	Key to join to the Currency table. Show/hide example query SELECT [Purch_ Rcpt_ Header].[Currency Code] ,[Currency].[Code] FROM [CRONUS UK Ltd_$Purch_ Rcpt_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Header] LEFT JOIN [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency] ON [Purch_ Rcpt_ Header].[Currency Code] = [Currency].[Code]
33	Currency Factor	decimal(38,38)
34	Invoice Disc_ Code	nvarchar(40)
35	Language Code	nvarchar(20)
	Key to join to the Language table. Show/hide example query SELECT [Purch_ Rcpt_ Header].[Language Code] ,[Language].[Code] FROM [CRONUS UK Ltd_$Purch_ Rcpt_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Header] LEFT JOIN [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language] ON [Purch_ Rcpt_ Header].[Language Code] = [Language].[Code]
36	Purchaser Code	nvarchar(40)
37	Order No_	nvarchar(40)
38	No_ Printed	int
39	On Hold	nvarchar(6)
40	Applies-to Doc_ Type	int
41	Applies-to Doc_ No_	nvarchar(40)
42	Bal_ Account No_	nvarchar(40)
43	Vendor Order No_	nvarchar(70)
44	Vendor Shipment No_	nvarchar(70)
45	VAT Registration No_	nvarchar(40)
46	Sell-to Customer No_	nvarchar(40)
	Key to join to the Customer table. Show/hide example query SELECT [Purch_ Rcpt_ Header].[Sell-to Customer No_] ,[Customer].[No_] FROM [CRONUS UK Ltd_$Purch_ Rcpt_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Header] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [Purch_ Rcpt_ Header].[Sell-to Customer No_] = [Customer].[No_]
47	Reason Code	nvarchar(20)
48	Gen_ Bus_ Posting Group	nvarchar(40)
49	Transaction Type	nvarchar(20)
50	Transport Method	nvarchar(20)
51	VAT Country_Region Code	nvarchar(20)
52	Buy-from Vendor Name	nvarchar(200)
53	Buy-from Vendor Name 2	nvarchar(100)
54	Buy-from Address	nvarchar(200)
55	Buy-from Address 2	nvarchar(100)
56	Buy-from City	nvarchar(60)
57	Buy-from Contact	nvarchar(200)
58	Pay-to Post Code	nvarchar(40)
59	Pay-to County	nvarchar(60)
60	Pay-to Country_Region Code	nvarchar(20)
61	Buy-from Post Code	nvarchar(40)
62	Buy-from County	nvarchar(60)
63	Buy-from Country_Region Code	nvarchar(20)
64	Ship-to Post Code	nvarchar(40)
65	Ship-to County	nvarchar(60)
66	Ship-to Country_Region Code	nvarchar(20)
67	Bal_ Account Type	int
68	Order Address Code	nvarchar(20)
69	Entry Point	nvarchar(20)
70	Correction	tinyint
71	Document Date	datetime
72	Area	nvarchar(20)
73	Transaction Specification	nvarchar(20)
74	Payment Method Code	nvarchar(20)
	Key to join to the Payment Method table. Show/hide example query SELECT [Purch_ Rcpt_ Header].[Payment Method Code] ,[Payment Method].[Code] FROM [CRONUS UK Ltd_$Purch_ Rcpt_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Header] LEFT JOIN [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method] ON [Purch_ Rcpt_ Header].[Payment Method Code] = [Payment Method].[Code]
75	No_ Series	nvarchar(40)
76	Order No_ Series	nvarchar(40)
77	User ID	nvarchar(100)
78	Source Code	nvarchar(20)
79	Tax Area Code	nvarchar(40)
	Key to join to the Tax Area table. Show/hide example query SELECT [Purch_ Rcpt_ Header].[Tax Area Code] ,[Tax Area].[Code] FROM [CRONUS UK Ltd_$Purch_ Rcpt_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Header] LEFT JOIN [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area] ON [Purch_ Rcpt_ Header].[Tax Area Code] = [Tax Area].[Code]
80	Tax Liable	tinyint
81	VAT Bus_ Posting Group	nvarchar(40)
82	VAT Base Discount _	decimal(38,38)
83	Quote No_	nvarchar(40)
84	Dimension Set ID	int
85	Campaign No_	nvarchar(40)
86	Buy-from Contact No_	nvarchar(40)
87	Pay-to Contact no_	nvarchar(40)
88	Responsibility Center	nvarchar(20)
89	Requested Receipt Date	datetime
90	Promised Receipt Date	datetime
91	Lead Time Calculation	varchar(32)
92	Inbound Whse_ Handling Time	varchar(32)
93	Price Calculation Method	int
94	$systemId	uniqueidentifier
95	$systemCreatedAt	datetime
96	$systemCreatedBy	uniqueidentifier
97	$systemModifiedAt	datetime
98	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Purch_ Rcpt_ Header table

Currency Customer Language Location Payment Method Payment Terms Shipment Method Tax Area Vendor

Dynamics 365 BC Table Reference Tables Company Tables PPurch_ Rcpt_ Header

Leave a Reply Cancel reply