Purch_ 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 IDColumn NameData Type
1timestamp Searchtimestamp
2Document No_ Primary Key Searchnvarchar(40)
3Line No_ Primary Key Searchint
4Buy-from Vendor No_ Searchnvarchar(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_]
5Type Searchint
6No_ Searchnvarchar(40)
7Location Code Searchnvarchar(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]
8Posting Group Searchnvarchar(40)
9Expected Receipt Date Searchdatetime
10Description Searchnvarchar(200)
11Description 2 Searchnvarchar(100)
12Unit of Measure Searchnvarchar(100)
13Quantity Searchdecimal(38,38)
14Direct Unit Cost Searchdecimal(38,38)
15Unit Cost (LCY) Searchdecimal(38,38)
16VAT _ Searchdecimal(38,38)
17Line Discount _ Searchdecimal(38,38)
18Line Discount Amount Searchdecimal(38,38)
19Amount Searchdecimal(38,38)
20Amount Including VAT Searchdecimal(38,38)
21Unit Price (LCY) Searchdecimal(38,38)
22Allow Invoice Disc_ Searchtinyint
23Gross Weight Searchdecimal(38,38)
24Net Weight Searchdecimal(38,38)
25Units per Parcel Searchdecimal(38,38)
26Unit Volume Searchdecimal(38,38)
27Appl_-to Item Entry Searchint
28Shortcut Dimension 1 Code Searchnvarchar(40)
29Shortcut Dimension 2 Code Searchnvarchar(40)
30Job No_ Searchnvarchar(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_]
31Indirect Cost _ Searchdecimal(38,38)
32Order No_ Searchnvarchar(40)
33Order Line No_ Searchint
34Pay-to Vendor No_ Searchnvarchar(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_]
35Inv_ Discount Amount Searchdecimal(38,38)
36Vendor Item No_ Searchnvarchar(100)
37Gen_ Bus_ Posting Group Searchnvarchar(40)
38Gen_ Prod_ Posting Group Searchnvarchar(40)
39VAT Calculation Type Searchint
40Transaction Type Searchnvarchar(20)
41Transport Method Searchnvarchar(20)
42Attached to Line No_ Searchint
43Entry Point Searchnvarchar(20)
44Area Searchnvarchar(20)
45Transaction Specification Searchnvarchar(20)
46Tax Area Code Searchnvarchar(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]
47Tax Liable Searchtinyint
48Tax Group Code Searchnvarchar(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]
49Use Tax Searchtinyint
50VAT Bus_ Posting Group Searchnvarchar(40)
51VAT Prod_ Posting Group Searchnvarchar(40)
52Blanket Order No_ Searchnvarchar(40)
53Blanket Order Line No_ Searchint
54VAT Base Amount Searchdecimal(38,38)
55Unit Cost Searchdecimal(38,38)
56System-Created Entry Searchtinyint
57Line Amount Searchdecimal(38,38)
58VAT Difference Searchdecimal(38,38)
59VAT Identifier Searchnvarchar(40)
60IC Partner Ref_ Type Searchint
61IC Partner Reference Searchnvarchar(40)
62Prepayment Line Searchtinyint
63IC Partner Code Searchnvarchar(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]
64Posting Date Searchdatetime
65IC Item Reference No_ Searchnvarchar(100)
66Pmt_ Discount Amount Searchdecimal(38,38)
67Dimension Set ID Searchint
68Job Task No_ Searchnvarchar(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_]
69Job Line Type Searchint
70Job Unit Price Searchdecimal(38,38)
71Job Total Price Searchdecimal(38,38)
72Job Line Amount Searchdecimal(38,38)
73Job Line Discount Amount Searchdecimal(38,38)
74Job Line Discount _ Searchdecimal(38,38)
75Job Unit Price (LCY) Searchdecimal(38,38)
76Job Total Price (LCY) Searchdecimal(38,38)
77Job Line Amount (LCY) Searchdecimal(38,38)
78Job Line Disc_ Amount (LCY) Searchdecimal(38,38)
79Job Currency Factor Searchdecimal(38,38)
80Job Currency Code Searchnvarchar(40)
81Deferral Code Searchnvarchar(20)
82Prod_ Order No_ Searchnvarchar(40)
83Variant Code Searchnvarchar(20)
84Bin Code Searchnvarchar(40)
85Qty_ per Unit of Measure Searchdecimal(38,38)
86Unit of Measure Code Searchnvarchar(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]
87Quantity (Base) Searchdecimal(38,38)
88FA Posting Date Searchdatetime
89FA Posting Type Searchint
90Depreciation Book Code Searchnvarchar(20)
91Salvage Value Searchdecimal(38,38)
92Depr_ until FA Posting Date Searchtinyint
93Depr_ Acquisition Cost Searchtinyint
94Maintenance Code Searchnvarchar(20)
95Insurance No_ Searchnvarchar(40)
96Budgeted FA No_ Searchnvarchar(40)
97Duplicate in Depreciation Book Searchnvarchar(20)
98Use Duplication List Searchtinyint
99Responsibility Center Searchnvarchar(20)
100Cross-Reference No_ Searchnvarchar(40)
101Unit of Measure (Cross Ref_) Searchnvarchar(20)
102Cross-Reference Type Searchint
103Cross-Reference Type No_ Searchnvarchar(60)
104Item Category Code Searchnvarchar(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]
105Nonstock Searchtinyint
106Purchasing Code Searchnvarchar(20)
107Product Group Code Searchnvarchar(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]
108Item Reference No_ Searchnvarchar(100)
109Item Reference Unit of Measure Searchnvarchar(20)
110Item Reference Type Searchint
111Item Reference Type No_ Searchnvarchar(60)
112Return Shipment No_ Searchnvarchar(40)
113Return Shipment Line No_ Searchint
114Return Reason Code Searchnvarchar(20)
115Price Calculation Method Searchint
116Reverse Charge Item Searchtinyint
117Reverse Charge Searchdecimal(38,38)
118$systemId Searchuniqueidentifier
119$systemCreatedAt Searchdatetime
120$systemCreatedBy Searchuniqueidentifier
121$systemModifiedAt Searchdatetime
122$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Purch_ Cr_ Memo Line table

Leave a Reply

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