Purch_ Cr_ Memo Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables PPurch_ Cr_ Memo Line

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

Table Type: Company

Table Name: Purch_ Cr_ Memo Line
Database Table Name: CRONUS UK Ltd_$Purch_ Cr_ Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 125

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_ Cr_ Memo Line can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Purch_ Cr_ Memo 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 _]
   ,[Line Discount Amount]
   ,[Amount]
   ,[Amount Including VAT]
   ,[Unit Price (LCY)]
   ,[Allow Invoice Disc_]
   ,[Gross Weight]
   ,[Net Weight]
   ,[Units per Parcel]
   ,[Unit Volume]
   ,[Appl_-to Item Entry]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Job No_]
   ,[Indirect Cost _]
   ,[Order No_]
   ,[Order Line No_]
   ,[Pay-to Vendor No_]
   ,[Inv_ Discount Amount]
   ,[Vendor Item 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]
   ,[System-Created Entry]
   ,[Line Amount]
   ,[VAT Difference]
   ,[VAT Identifier]
   ,[IC Partner Ref_ Type]
   ,[IC Partner Reference]
   ,[Prepayment Line]
   ,[IC Partner Code]
   ,[Posting Date]
   ,[IC Item Reference No_]
   ,[Pmt_ Discount Amount]
   ,[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]
   ,[Deferral Code]
   ,[Prod_ Order No_]
   ,[Variant Code]
   ,[Bin Code]
   ,[Qty_ per Unit of Measure]
   ,[Unit of Measure Code]
   ,[Quantity (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 Category Code]
   ,[Nonstock]
   ,[Purchasing Code]
   ,[Product Group Code]
   ,[Item Reference No_]
   ,[Item Reference Unit of Measure]
   ,[Item Reference Type]
   ,[Item Reference Type No_]
   ,[Return Shipment No_]
   ,[Return Shipment Line No_]
   ,[Return Reason Code]
   ,[Price Calculation Method]
   ,[Reverse Charge Item]
   ,[Reverse Charge]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide columns in Purch_ Cr_ Memo 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_ Cr_ Memo Line].[Buy-from Vendor No_] ,[Vendor].[No_] FROM [CRONUS UK Ltd_$Purch_ Cr_ Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Cr_ Memo Line] LEFT JOIN [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor] ON [Purch_ Cr_ Memo 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_ Cr_ Memo Line].[Location Code] ,[Location].[Code] FROM [CRONUS UK Ltd_$Purch_ Cr_ Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Cr_ Memo Line] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Purch_ Cr_ Memo 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	Line Discount Amount	decimal(38,38)
19	Amount	decimal(38,38)
20	Amount Including VAT	decimal(38,38)
21	Unit Price (LCY)	decimal(38,38)
22	Allow Invoice Disc_	tinyint
23	Gross Weight	decimal(38,38)
24	Net Weight	decimal(38,38)
25	Units per Parcel	decimal(38,38)
26	Unit Volume	decimal(38,38)
27	Appl_-to Item Entry	int
28	Shortcut Dimension 1 Code	nvarchar(40)
29	Shortcut Dimension 2 Code	nvarchar(40)
30	Job No_	nvarchar(40)
	Key to join to the Job table. Show/hide example query SELECT [Purch_ Cr_ Memo Line].[Job No_] ,[Job].[Job No_] FROM [CRONUS UK Ltd_$Purch_ Cr_ Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Cr_ Memo Line] LEFT JOIN [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job] ON [Purch_ Cr_ Memo Line].[Job No_] = [Job].[Job No_]
31	Indirect Cost _	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_ Cr_ Memo Line].[Pay-to Vendor No_] ,[Vendor].[No_] FROM [CRONUS UK Ltd_$Purch_ Cr_ Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Cr_ Memo Line] LEFT JOIN [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor] ON [Purch_ Cr_ Memo Line].[Pay-to Vendor No_] = [Vendor].[No_]
35	Inv_ Discount Amount	decimal(38,38)
36	Vendor Item No_	nvarchar(100)
37	Gen_ Bus_ Posting Group	nvarchar(40)
38	Gen_ Prod_ Posting Group	nvarchar(40)
39	VAT Calculation Type	int
40	Transaction Type	nvarchar(20)
41	Transport Method	nvarchar(20)
42	Attached to Line No_	int
43	Entry Point	nvarchar(20)
44	Area	nvarchar(20)
45	Transaction Specification	nvarchar(20)
46	Tax Area Code	nvarchar(40)
	Key to join to the Tax Area table. Show/hide example query SELECT [Purch_ Cr_ Memo Line].[Tax Area Code] ,[Tax Area].[Code] FROM [CRONUS UK Ltd_$Purch_ Cr_ Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Cr_ Memo Line] LEFT JOIN [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area] ON [Purch_ Cr_ Memo Line].[Tax Area Code] = [Tax Area].[Code]
47	Tax Liable	tinyint
48	Tax Group Code	nvarchar(40)
	Key to join to the Tax Group table. Show/hide example query SELECT [Purch_ Cr_ Memo Line].[Tax Group Code] ,[Tax Group].[Code] FROM [CRONUS UK Ltd_$Purch_ Cr_ Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Cr_ Memo Line] LEFT JOIN [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group] ON [Purch_ Cr_ Memo Line].[Tax Group Code] = [Tax Group].[Code]
49	Use Tax	tinyint
50	VAT Bus_ Posting Group	nvarchar(40)
51	VAT Prod_ Posting Group	nvarchar(40)
52	Blanket Order No_	nvarchar(40)
53	Blanket Order Line No_	int
54	VAT Base Amount	decimal(38,38)
55	Unit Cost	decimal(38,38)
56	System-Created Entry	tinyint
57	Line Amount	decimal(38,38)
58	VAT Difference	decimal(38,38)
59	VAT Identifier	nvarchar(40)
60	IC Partner Ref_ Type	int
61	IC Partner Reference	nvarchar(40)
62	Prepayment Line	tinyint
63	IC Partner Code	nvarchar(40)
	Key to join to the IC Partner table. Show/hide example query SELECT [Purch_ Cr_ Memo Line].[IC Partner Code] ,[IC Partner].[Code] FROM [CRONUS UK Ltd_$Purch_ Cr_ Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Cr_ Memo Line] LEFT JOIN [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner] ON [Purch_ Cr_ Memo Line].[IC Partner Code] = [IC Partner].[Code]
64	Posting Date	datetime
65	IC Item Reference No_	nvarchar(100)
66	Pmt_ Discount Amount	decimal(38,38)
67	Dimension Set ID	int
68	Job Task No_	nvarchar(40)
	Key to join to the Job Task table. Show/hide example query SELECT [Purch_ Cr_ Memo Line].[Job Task No_] ,[Job Task].[Job Task No_] FROM [CRONUS UK Ltd_$Purch_ Cr_ Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Cr_ Memo Line] LEFT JOIN [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task] ON [Purch_ Cr_ Memo Line].[Job Task No_] = [Job Task].[Job Task No_]
69	Job Line Type	int
70	Job Unit Price	decimal(38,38)
71	Job Total Price	decimal(38,38)
72	Job Line Amount	decimal(38,38)
73	Job Line Discount Amount	decimal(38,38)
74	Job Line Discount _	decimal(38,38)
75	Job Unit Price (LCY)	decimal(38,38)
76	Job Total Price (LCY)	decimal(38,38)
77	Job Line Amount (LCY)	decimal(38,38)
78	Job Line Disc_ Amount (LCY)	decimal(38,38)
79	Job Currency Factor	decimal(38,38)
80	Job Currency Code	nvarchar(40)
81	Deferral Code	nvarchar(20)
82	Prod_ Order No_	nvarchar(40)
83	Variant Code	nvarchar(20)
84	Bin Code	nvarchar(40)
85	Qty_ per Unit of Measure	decimal(38,38)
86	Unit of Measure Code	nvarchar(20)
	Key to join to the Unit of Measure table. Show/hide example query SELECT [Purch_ Cr_ Memo Line].[Unit of Measure Code] ,[Unit of Measure].[Code] FROM [CRONUS UK Ltd_$Purch_ Cr_ Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Cr_ Memo Line] LEFT JOIN [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure] ON [Purch_ Cr_ Memo Line].[Unit of Measure Code] = [Unit of Measure].[Code]
87	Quantity (Base)	decimal(38,38)
88	FA Posting Date	datetime
89	FA Posting Type	int
90	Depreciation Book Code	nvarchar(20)
91	Salvage Value	decimal(38,38)
92	Depr_ until FA Posting Date	tinyint
93	Depr_ Acquisition Cost	tinyint
94	Maintenance Code	nvarchar(20)
95	Insurance No_	nvarchar(40)
96	Budgeted FA No_	nvarchar(40)
97	Duplicate in Depreciation Book	nvarchar(20)
98	Use Duplication List	tinyint
99	Responsibility Center	nvarchar(20)
100	Cross-Reference No_	nvarchar(40)
101	Unit of Measure (Cross Ref_)	nvarchar(20)
102	Cross-Reference Type	int
103	Cross-Reference Type No_	nvarchar(60)
104	Item Category Code	nvarchar(40)
	Key to join to the Item Category table. Show/hide example query SELECT [Purch_ Cr_ Memo Line].[Item Category Code] ,[Item Category].[Code] FROM [CRONUS UK Ltd_$Purch_ Cr_ Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Cr_ Memo Line] LEFT JOIN [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category] ON [Purch_ Cr_ Memo Line].[Item Category Code] = [Item Category].[Code]
105	Nonstock	tinyint
106	Purchasing Code	nvarchar(20)
107	Product Group Code	nvarchar(20)
	Key to join to the Product Group table. Show/hide example query SELECT [Purch_ Cr_ Memo Line].[Product Group Code] ,[Product Group].[Code] FROM [CRONUS UK Ltd_$Purch_ Cr_ Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Cr_ Memo Line] LEFT JOIN [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group] ON [Purch_ Cr_ Memo Line].[Product Group Code] = [Product Group].[Code]
108	Item Reference No_	nvarchar(100)
109	Item Reference Unit of Measure	nvarchar(20)
110	Item Reference Type	int
111	Item Reference Type No_	nvarchar(60)
112	Return Shipment No_	nvarchar(40)
113	Return Shipment Line No_	int
114	Return Reason Code	nvarchar(20)
115	Price Calculation Method	int
116	Reverse Charge Item	tinyint
117	Reverse Charge	decimal(38,38)
118	$systemId	uniqueidentifier
119	$systemCreatedAt	datetime
120	$systemCreatedBy	uniqueidentifier
121	$systemModifiedAt	datetime
122	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Purch_ Cr_ Memo Line table

IC Partner 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_ Cr_ Memo Line

Leave a Reply Cancel reply