Sales Cr_Memo Line

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

Table Type: Company

Table Name: Sales Cr_Memo Line
Database Table Name: CRONUS UK Ltd_$Sales Cr_Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 115

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 Sales Cr_Memo Line can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Sales Cr_Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Document No_]
   ,[Line No_]
   ,[Sell-to Customer No_]
   ,[Type]
   ,[No_]
   ,[Location Code]
   ,[Posting Group]
   ,[Shipment Date]
   ,[Description]
   ,[Description 2]
   ,[Unit of Measure]
   ,[Quantity]
   ,[Unit Price]
   ,[Unit Cost (LCY)]
   ,[VAT _]
   ,[Line Discount _]
   ,[Line Discount Amount]
   ,[Amount]
   ,[Amount Including VAT]
   ,[Allow Invoice Disc_]
   ,[Gross Weight]
   ,[Net Weight]
   ,[Units per Parcel]
   ,[Unit Volume]
   ,[Appl_-to Item Entry]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Customer Price Group]
   ,[Job No_]
   ,[Work Type Code]
   ,[Order No_]
   ,[Order Line No_]
   ,[Bill-to Customer No_]
   ,[Inv_ Discount Amount]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[VAT Calculation Type]
   ,[Transaction Type]
   ,[Transport Method]
   ,[Attached to Line No_]
   ,[Exit Point]
   ,[Area]
   ,[Transaction Specification]
   ,[Tax Category]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[Tax Group Code]
   ,[VAT Clause Code]
   ,[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]
   ,[Line Discount Calculation]
   ,[Dimension Set ID]
   ,[Job Task No_]
   ,[Job Contract Entry No_]
   ,[Deferral Code]
   ,[Variant Code]
   ,[Bin Code]
   ,[Qty_ per Unit of Measure]
   ,[Unit of Measure Code]
   ,[Quantity (Base)]
   ,[FA Posting Date]
   ,[Depreciation Book Code]
   ,[Depr_ until FA Posting Date]
   ,[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_]
   ,[Appl_-from Item Entry]
   ,[Return Receipt No_]
   ,[Return Receipt Line No_]
   ,[Return Reason Code]
   ,[Price Calculation Method]
   ,[Allow Line Disc_]
   ,[Customer Disc_ Group]
   ,[Reverse Charge Item]
   ,[Reverse Charge]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Sales 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_$Sales Cr_Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Line]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Cr_Memo Line].[Sell-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Sales Cr_Memo Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
      ON
         [Sales Cr_Memo Line].[Customer Price Group] = [Customer Price Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [Sales Cr_Memo Line].[Job No_] = [Job].[Job No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Cr_Memo Line].[Bill-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Sales 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
         [Sales 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
         [Sales 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
         [Sales 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
         [Sales 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
         [Sales 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
         [Sales Cr_Memo Line].[Product Group Code] = [Product Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
      ON
         [Sales Cr_Memo Line].[Customer Disc_ Group] = [Customer Discount Group].[No_]

Show/hide columns in Sales Cr_Memo Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Document No_ Primary Key Searchnvarchar(40)
3Line No_ Primary Key Searchint
4Sell-to Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Sales Cr_Memo Line].[Sell-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Sales Cr_Memo Line].[Sell-to Customer No_] = [Customer].[No_]
5Type Searchint
6No_ Searchnvarchar(40)
7Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Sales Cr_Memo Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Sales Cr_Memo Line].[Location Code] = [Location].[Code]
8Posting Group Searchnvarchar(40)
9Shipment Date Searchdatetime
10Description Searchnvarchar(200)
11Description 2 Searchnvarchar(100)
12Unit of Measure Searchnvarchar(100)
13Quantity Searchdecimal(38,38)
14Unit Price 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)
21Allow Invoice Disc_ Searchtinyint
22Gross Weight Searchdecimal(38,38)
23Net Weight Searchdecimal(38,38)
24Units per Parcel Searchdecimal(38,38)
25Unit Volume Searchdecimal(38,38)
26Appl_-to Item Entry Searchint
27Shortcut Dimension 1 Code Searchnvarchar(40)
28Shortcut Dimension 2 Code Searchnvarchar(40)
29Customer Price Group Searchnvarchar(20)
Key to join to the Customer Price Group table.

Show/hide example query

SELECT
       [Sales Cr_Memo Line].[Customer Price Group]
       ,[Customer Price Group].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
              ON
                     [Sales Cr_Memo Line].[Customer Price Group] = [Customer Price Group].[Code]
30Job No_ Searchnvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Sales Cr_Memo Line].[Job No_]
       ,[Job].[Job No_]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Line]
LEFT JOIN
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
              ON
                     [Sales Cr_Memo Line].[Job No_] = [Job].[Job No_]
31Work Type Code Searchnvarchar(20)
32Order No_ Searchnvarchar(40)
33Order Line No_ Searchint
34Bill-to Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Sales Cr_Memo Line].[Bill-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Sales Cr_Memo Line].[Bill-to Customer No_] = [Customer].[No_]
35Inv_ Discount Amount Searchdecimal(38,38)
36Gen_ Bus_ Posting Group Searchnvarchar(40)
37Gen_ Prod_ Posting Group Searchnvarchar(40)
38VAT Calculation Type Searchint
39Transaction Type Searchnvarchar(20)
40Transport Method Searchnvarchar(20)
41Attached to Line No_ Searchint
42Exit Point Searchnvarchar(20)
43Area Searchnvarchar(20)
44Transaction Specification Searchnvarchar(20)
45Tax Category Searchnvarchar(20)
46Tax Area Code Searchnvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [Sales Cr_Memo Line].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Sales 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
       [Sales Cr_Memo Line].[Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [Sales Cr_Memo Line].[Tax Group Code] = [Tax Group].[Code]
49VAT Clause Code Searchnvarchar(40)
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
       [Sales Cr_Memo Line].[IC Partner Code]
       ,[IC Partner].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Line]
LEFT JOIN
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
              ON
                     [Sales Cr_Memo Line].[IC Partner Code] = [IC Partner].[Code]
64Posting Date Searchdatetime
65IC Item Reference No_ Searchnvarchar(100)
66Pmt_ Discount Amount Searchdecimal(38,38)
67Line Discount Calculation Searchint
68Dimension Set ID Searchint
69Job Task No_ Searchnvarchar(40)
Key to join to the Job Task table.

Show/hide example query

SELECT
       [Sales Cr_Memo Line].[Job Task No_]
       ,[Job Task].[Job Task No_]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Line]
LEFT JOIN
       [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
              ON
                     [Sales Cr_Memo Line].[Job Task No_] = [Job Task].[Job Task No_]
70Job Contract Entry No_ Searchint
71Deferral Code Searchnvarchar(20)
72Variant Code Searchnvarchar(20)
73Bin Code Searchnvarchar(40)
74Qty_ per Unit of Measure Searchdecimal(38,38)
75Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Sales Cr_Memo Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Sales Cr_Memo Line].[Unit of Measure Code] = [Unit of Measure].[Code]
76Quantity (Base) Searchdecimal(38,38)
77FA Posting Date Searchdatetime
78Depreciation Book Code Searchnvarchar(20)
79Depr_ until FA Posting Date Searchtinyint
80Duplicate in Depreciation Book Searchnvarchar(20)
81Use Duplication List Searchtinyint
82Responsibility Center Searchnvarchar(20)
83Cross-Reference No_ Searchnvarchar(40)
84Unit of Measure (Cross Ref_) Searchnvarchar(20)
85Cross-Reference Type Searchint
86Cross-Reference Type No_ Searchnvarchar(60)
87Item Category Code Searchnvarchar(40)
Key to join to the Item Category table.

Show/hide example query

SELECT
       [Sales Cr_Memo Line].[Item Category Code]
       ,[Item Category].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
              ON
                     [Sales Cr_Memo Line].[Item Category Code] = [Item Category].[Code]
88Nonstock Searchtinyint
89Purchasing Code Searchnvarchar(20)
90Product Group Code Searchnvarchar(20)
Key to join to the Product Group table.

Show/hide example query

SELECT
       [Sales Cr_Memo Line].[Product Group Code]
       ,[Product Group].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Line]
LEFT JOIN
       [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
              ON
                     [Sales Cr_Memo Line].[Product Group Code] = [Product Group].[Code]
91Item Reference No_ Searchnvarchar(100)
92Item Reference Unit of Measure Searchnvarchar(20)
93Item Reference Type Searchint
94Item Reference Type No_ Searchnvarchar(60)
95Appl_-from Item Entry Searchint
96Return Receipt No_ Searchnvarchar(40)
97Return Receipt Line No_ Searchint
98Return Reason Code Searchnvarchar(20)
99Price Calculation Method Searchint
100Allow Line Disc_ Searchtinyint
101Customer Disc_ Group Searchnvarchar(40)
Key to join to the Customer Discount Group table.

Show/hide example query

SELECT
       [Sales Cr_Memo Line].[Customer Disc_ Group]
       ,[Customer Discount Group].[No_]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
              ON
                     [Sales Cr_Memo Line].[Customer Disc_ Group] = [Customer Discount Group].[No_]
102Reverse Charge Item Searchtinyint
103Reverse Charge Searchdecimal(38,38)
104$systemId Searchuniqueidentifier
105$systemCreatedAt Searchdatetime
106$systemCreatedBy Searchuniqueidentifier
107$systemModifiedAt Searchdatetime
108$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Sales Cr_Memo Line table

Leave a Reply

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