Purch_ Rcpt_ Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables PPurch_ Rcpt_ Line

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

Table Type: Company

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Purch_ Rcpt_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Document No_]
   ,[Line No_]
   ,[Buy-from Vendor No_]
   ,[Type]
   ,[No_]
   ,[Location Code]
   ,[Posting Group]
   ,[Expected Receipt Date]
   ,[Description]
   ,[Description 2]
   ,[Unit of Measure]
   ,[Quantity]
   ,[Direct Unit Cost]
   ,[Unit Cost (LCY)]
   ,[VAT _]
   ,[Line Discount _]
   ,[Unit Price (LCY)]
   ,[Allow Invoice Disc_]
   ,[Gross Weight]
   ,[Net Weight]
   ,[Units per Parcel]
   ,[Unit Volume]
   ,[Appl_-to Item Entry]
   ,[Item Rcpt_ Entry No_]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Job No_]
   ,[Indirect Cost _]
   ,[Qty_ Rcd_ Not Invoiced]
   ,[Quantity Invoiced]
   ,[Order No_]
   ,[Order Line No_]
   ,[Pay-to Vendor No_]
   ,[Vendor Item No_]
   ,[Sales Order No_]
   ,[Sales Order Line No_]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[VAT Calculation Type]
   ,[Transaction Type]
   ,[Transport Method]
   ,[Attached to Line No_]
   ,[Entry Point]
   ,[Area]
   ,[Transaction Specification]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[Tax Group Code]
   ,[Use Tax]
   ,[VAT Bus_ Posting Group]
   ,[VAT Prod_ Posting Group]
   ,[Blanket Order No_]
   ,[Blanket Order Line No_]
   ,[VAT Base Amount]
   ,[Unit Cost]
   ,[IC Partner Ref_ Type]
   ,[IC Partner Reference]
   ,[Posting Date]
   ,[IC Item Reference No_]
   ,[Dimension Set ID]
   ,[Job Task No_]
   ,[Job Line Type]
   ,[Job Unit Price]
   ,[Job Total Price]
   ,[Job Line Amount]
   ,[Job Line Discount Amount]
   ,[Job Line Discount _]
   ,[Job Unit Price (LCY)]
   ,[Job Total Price (LCY)]
   ,[Job Line Amount (LCY)]
   ,[Job Line Disc_ Amount (LCY)]
   ,[Job Currency Factor]
   ,[Job Currency Code]
   ,[Prod_ Order No_]
   ,[Variant Code]
   ,[Bin Code]
   ,[Qty_ per Unit of Measure]
   ,[Unit of Measure Code]
   ,[Quantity (Base)]
   ,[Qty_ Invoiced (Base)]
   ,[FA Posting Date]
   ,[FA Posting Type]
   ,[Depreciation Book Code]
   ,[Salvage Value]
   ,[Depr_ until FA Posting Date]
   ,[Depr_ Acquisition Cost]
   ,[Maintenance Code]
   ,[Insurance No_]
   ,[Budgeted FA No_]
   ,[Duplicate in Depreciation Book]
   ,[Use Duplication List]
   ,[Responsibility Center]
   ,[Cross-Reference No_]
   ,[Unit of Measure (Cross Ref_)]
   ,[Cross-Reference Type]
   ,[Cross-Reference Type No_]
   ,[Item Reference No_]
   ,[Item Reference Unit of Measure]
   ,[Item Reference Type]
   ,[Item Reference Type No_]
   ,[Item Category Code]
   ,[Nonstock]
   ,[Purchasing Code]
   ,[Product Group Code]
   ,[Special Order Sales No_]
   ,[Special Order Sales Line No_]
   ,[Requested Receipt Date]
   ,[Promised Receipt Date]
   ,[Lead Time Calculation]
   ,[Inbound Whse_ Handling Time]
   ,[Planned Receipt Date]
   ,[Order Date]
   ,[Item Charge Base Amount]
   ,[Correction]
   ,[Return Reason Code]
   ,[Price Calculation Method]
   ,[Document Id]
   ,[Over-Receipt Quantity]
   ,[Over-Receipt Code]
   ,[Over-Receipt Code 2]
   ,[Routing No_]
   ,[Operation No_]
   ,[Work Center No_]
   ,[Prod_ Order Line No_]
   ,[Overhead Rate]
   ,[Routing Reference No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Purch_ Rcpt_ Line$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_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Line]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purch_ Rcpt_ Line].[Buy-from Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Purch_ Rcpt_ Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [Purch_ Rcpt_ Line].[Job No_] = [Job].[Job No_]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purch_ Rcpt_ Line].[Pay-to Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Purch_ Rcpt_ Line].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Purch_ Rcpt_ Line].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
      ON
         [Purch_ Rcpt_ Line].[Job Task No_] = [Job Task].[Job Task No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Purch_ Rcpt_ Line].[Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
      ON
         [Purch_ Rcpt_ Line].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
      ON
         [Purch_ Rcpt_ Line].[Product Group Code] = [Product Group].[Code]

Show/hide columns in Purch_ Rcpt_ Line table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Document No_	nvarchar(40)
3	Line No_	int
4	Buy-from Vendor No_	nvarchar(40)
	Key to join to the Vendor table. Show/hide example query SELECT [Purch_ Rcpt_ Line].[Buy-from Vendor No_] ,[Vendor].[No_] FROM [CRONUS UK Ltd_$Purch_ Rcpt_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Line] LEFT JOIN [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor] ON [Purch_ Rcpt_ Line].[Buy-from Vendor No_] = [Vendor].[No_]
5	Type	int
6	No_	nvarchar(40)
7	Location Code	nvarchar(20)
	Key to join to the Location table. Show/hide example query SELECT [Purch_ Rcpt_ Line].[Location Code] ,[Location].[Code] FROM [CRONUS UK Ltd_$Purch_ Rcpt_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Line] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Purch_ Rcpt_ Line].[Location Code] = [Location].[Code]
8	Posting Group	nvarchar(40)
9	Expected Receipt Date	datetime
10	Description	nvarchar(200)
11	Description 2	nvarchar(100)
12	Unit of Measure	nvarchar(100)
13	Quantity	decimal(38,38)
14	Direct Unit Cost	decimal(38,38)
15	Unit Cost (LCY)	decimal(38,38)
16	VAT _	decimal(38,38)
17	Line Discount _	decimal(38,38)
18	Unit Price (LCY)	decimal(38,38)
19	Allow Invoice Disc_	tinyint
20	Gross Weight	decimal(38,38)
21	Net Weight	decimal(38,38)
22	Units per Parcel	decimal(38,38)
23	Unit Volume	decimal(38,38)
24	Appl_-to Item Entry	int
25	Item Rcpt_ Entry No_	int
26	Shortcut Dimension 1 Code	nvarchar(40)
27	Shortcut Dimension 2 Code	nvarchar(40)
28	Job No_	nvarchar(40)
	Key to join to the Job table. Show/hide example query SELECT [Purch_ Rcpt_ Line].[Job No_] ,[Job].[Job No_] FROM [CRONUS UK Ltd_$Purch_ Rcpt_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Line] LEFT JOIN [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job] ON [Purch_ Rcpt_ Line].[Job No_] = [Job].[Job No_]
29	Indirect Cost _	decimal(38,38)
30	Qty_ Rcd_ Not Invoiced	decimal(38,38)
31	Quantity Invoiced	decimal(38,38)
32	Order No_	nvarchar(40)
33	Order Line No_	int
34	Pay-to Vendor No_	nvarchar(40)
	Key to join to the Vendor table. Show/hide example query SELECT [Purch_ Rcpt_ Line].[Pay-to Vendor No_] ,[Vendor].[No_] FROM [CRONUS UK Ltd_$Purch_ Rcpt_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Line] LEFT JOIN [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor] ON [Purch_ Rcpt_ Line].[Pay-to Vendor No_] = [Vendor].[No_]
35	Vendor Item No_	nvarchar(100)
36	Sales Order No_	nvarchar(40)
37	Sales Order Line No_	int
38	Gen_ Bus_ Posting Group	nvarchar(40)
39	Gen_ Prod_ Posting Group	nvarchar(40)
40	VAT Calculation Type	int
41	Transaction Type	nvarchar(20)
42	Transport Method	nvarchar(20)
43	Attached to Line No_	int
44	Entry Point	nvarchar(20)
45	Area	nvarchar(20)
46	Transaction Specification	nvarchar(20)
47	Tax Area Code	nvarchar(40)
	Key to join to the Tax Area table. Show/hide example query SELECT [Purch_ Rcpt_ Line].[Tax Area Code] ,[Tax Area].[Code] FROM [CRONUS UK Ltd_$Purch_ Rcpt_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Line] LEFT JOIN [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area] ON [Purch_ Rcpt_ Line].[Tax Area Code] = [Tax Area].[Code]
48	Tax Liable	tinyint
49	Tax Group Code	nvarchar(40)
	Key to join to the Tax Group table. Show/hide example query SELECT [Purch_ Rcpt_ Line].[Tax Group Code] ,[Tax Group].[Code] FROM [CRONUS UK Ltd_$Purch_ Rcpt_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Line] LEFT JOIN [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group] ON [Purch_ Rcpt_ Line].[Tax Group Code] = [Tax Group].[Code]
50	Use Tax	tinyint
51	VAT Bus_ Posting Group	nvarchar(40)
52	VAT Prod_ Posting Group	nvarchar(40)
53	Blanket Order No_	nvarchar(40)
54	Blanket Order Line No_	int
55	VAT Base Amount	decimal(38,38)
56	Unit Cost	decimal(38,38)
57	IC Partner Ref_ Type	int
58	IC Partner Reference	nvarchar(40)
59	Posting Date	datetime
60	IC Item Reference No_	nvarchar(100)
61	Dimension Set ID	int
62	Job Task No_	nvarchar(40)
	Key to join to the Job Task table. Show/hide example query SELECT [Purch_ Rcpt_ Line].[Job Task No_] ,[Job Task].[Job Task No_] FROM [CRONUS UK Ltd_$Purch_ Rcpt_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Line] LEFT JOIN [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task] ON [Purch_ Rcpt_ Line].[Job Task No_] = [Job Task].[Job Task No_]
63	Job Line Type	int
64	Job Unit Price	decimal(38,38)
65	Job Total Price	decimal(38,38)
66	Job Line Amount	decimal(38,38)
67	Job Line Discount Amount	decimal(38,38)
68	Job Line Discount _	decimal(38,38)
69	Job Unit Price (LCY)	decimal(38,38)
70	Job Total Price (LCY)	decimal(38,38)
71	Job Line Amount (LCY)	decimal(38,38)
72	Job Line Disc_ Amount (LCY)	decimal(38,38)
73	Job Currency Factor	decimal(38,38)
74	Job Currency Code	nvarchar(40)
75	Prod_ Order No_	nvarchar(40)
76	Variant Code	nvarchar(20)
77	Bin Code	nvarchar(40)
78	Qty_ per Unit of Measure	decimal(38,38)
79	Unit of Measure Code	nvarchar(20)
	Key to join to the Unit of Measure table. Show/hide example query SELECT [Purch_ Rcpt_ Line].[Unit of Measure Code] ,[Unit of Measure].[Code] FROM [CRONUS UK Ltd_$Purch_ Rcpt_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Line] LEFT JOIN [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure] ON [Purch_ Rcpt_ Line].[Unit of Measure Code] = [Unit of Measure].[Code]
80	Quantity (Base)	decimal(38,38)
81	Qty_ Invoiced (Base)	decimal(38,38)
82	FA Posting Date	datetime
83	FA Posting Type	int
84	Depreciation Book Code	nvarchar(20)
85	Salvage Value	decimal(38,38)
86	Depr_ until FA Posting Date	tinyint
87	Depr_ Acquisition Cost	tinyint
88	Maintenance Code	nvarchar(20)
89	Insurance No_	nvarchar(40)
90	Budgeted FA No_	nvarchar(40)
91	Duplicate in Depreciation Book	nvarchar(20)
92	Use Duplication List	tinyint
93	Responsibility Center	nvarchar(20)
94	Cross-Reference No_	nvarchar(40)
95	Unit of Measure (Cross Ref_)	nvarchar(20)
96	Cross-Reference Type	int
97	Cross-Reference Type No_	nvarchar(60)
98	Item Reference No_	nvarchar(100)
99	Item Reference Unit of Measure	nvarchar(20)
100	Item Reference Type	int
101	Item Reference Type No_	nvarchar(60)
102	Item Category Code	nvarchar(40)
	Key to join to the Item Category table. Show/hide example query SELECT [Purch_ Rcpt_ Line].[Item Category Code] ,[Item Category].[Code] FROM [CRONUS UK Ltd_$Purch_ Rcpt_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Line] LEFT JOIN [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category] ON [Purch_ Rcpt_ Line].[Item Category Code] = [Item Category].[Code]
103	Nonstock	tinyint
104	Purchasing Code	nvarchar(20)
105	Product Group Code	nvarchar(20)
	Key to join to the Product Group table. Show/hide example query SELECT [Purch_ Rcpt_ Line].[Product Group Code] ,[Product Group].[Code] FROM [CRONUS UK Ltd_$Purch_ Rcpt_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Line] LEFT JOIN [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group] ON [Purch_ Rcpt_ Line].[Product Group Code] = [Product Group].[Code]
106	Special Order Sales No_	nvarchar(40)
107	Special Order Sales Line No_	int
108	Requested Receipt Date	datetime
109	Promised Receipt Date	datetime
110	Lead Time Calculation	varchar(32)
111	Inbound Whse_ Handling Time	varchar(32)
112	Planned Receipt Date	datetime
113	Order Date	datetime
114	Item Charge Base Amount	decimal(38,38)
115	Correction	tinyint
116	Return Reason Code	nvarchar(20)
117	Price Calculation Method	int
118	Document Id	uniqueidentifier
119	Over-Receipt Quantity	decimal(38,38)
120	Over-Receipt Code	nvarchar(20)
121	Over-Receipt Code 2	nvarchar(40)
122	Routing No_	nvarchar(40)
123	Operation No_	nvarchar(20)
124	Work Center No_	nvarchar(40)
125	Prod_ Order Line No_	int
126	Overhead Rate	decimal(38,38)
127	Routing Reference No_	int
128	$systemId	uniqueidentifier
129	$systemCreatedAt	datetime
130	$systemCreatedBy	uniqueidentifier
131	$systemModifiedAt	datetime
132	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Purch_ Rcpt_ Line table

Item Category Job Job Task Location Product Group Tax Area Tax Group Unit of Measure Vendor

Dynamics 365 BC Table Reference Tables Company Tables PPurch_ Rcpt_ Line

Leave a Reply Cancel reply