Service Cr_Memo Line

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

Table Type: Company

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

Table Number: 5995

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Document No_]
   ,[Line No_]
   ,[Customer No_]
   ,[Type]
   ,[No_]
   ,[Location Code]
   ,[Posting Group]
   ,[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]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Customer Price Group]
   ,[Work Type Code]
   ,[Shipment 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 Area Code]
   ,[Tax Liable]
   ,[Tax Group Code]
   ,[VAT Clause Code]
   ,[VAT Bus_ Posting Group]
   ,[VAT Prod_ Posting Group]
   ,[VAT Base Amount]
   ,[Unit Cost]
   ,[System-Created Entry]
   ,[Line Amount]
   ,[VAT Difference]
   ,[VAT Identifier]
   ,[Pmt_ Discount Amount]
   ,[Dimension Set ID]
   ,[Variant Code]
   ,[Bin Code]
   ,[Qty_ per Unit of Measure]
   ,[Unit of Measure Code]
   ,[Quantity (Base)]
   ,[Responsibility Center]
   ,[Item Category Code]
   ,[Nonstock]
   ,[Product Group Code]
   ,[Appl_-from Item Entry]
   ,[Service Item No_]
   ,[Appl_-to Service Entry]
   ,[Service Item Serial No_]
   ,[Service Item Line Description]
   ,[Posting Date]
   ,[Needed by Date]
   ,[Ship-to Code]
   ,[Service Price Group Code]
   ,[Fault Area Code]
   ,[Symptom Code]
   ,[Fault Code]
   ,[Resolution Code]
   ,[Exclude Warranty]
   ,[Warranty]
   ,[Contract No_]
   ,[Contract Disc_ _]
   ,[Warranty Disc_ _]
   ,[Component Line No_]
   ,[Spare Part Action]
   ,[Fault Reason Code]
   ,[Replaced Item No_]
   ,[Exclude Contract Discount]
   ,[Price Adjmt_ Status]
   ,[Line Discount Type]
   ,[Copy Components From]
   ,[Return Reason Code]
   ,[Price Calculation Method]
   ,[Allow Line Disc_]
   ,[Customer Disc_ Group]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Service 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_$Service Cr_Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Cr_Memo Line]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Service Cr_Memo Line].[Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Service 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
         [Service Cr_Memo Line].[Customer Price Group] = [Customer Price Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Service 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
         [Service 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
         [Service Cr_Memo Line].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Service 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
         [Service 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
         [Service 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
         [Service Cr_Memo Line].[Customer Disc_ Group] = [Customer Discount Group].[No_]

Show/hide columns in Service Cr_Memo Line table

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

Show/hide example query

SELECT
       [Service Cr_Memo Line].[Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Service Cr_Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Cr_Memo Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Service Cr_Memo Line].[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
       [Service Cr_Memo Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Service Cr_Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Cr_Memo Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Service Cr_Memo Line].[Location Code] = [Location].[Code]
8Posting Group Searchnvarchar(40)
9Description Searchnvarchar(200)
10Description 2 Searchnvarchar(100)
11Unit of Measure Searchnvarchar(100)
12Quantity Searchdecimal(38,38)
13Unit Price Searchdecimal(38,38)
14Unit Cost (LCY) Searchdecimal(38,38)
15VAT _ Searchdecimal(38,38)
16Line Discount _ Searchdecimal(38,38)
17Line Discount Amount Searchdecimal(38,38)
18Amount Searchdecimal(38,38)
19Amount Including VAT Searchdecimal(38,38)
20Allow Invoice Disc_ Searchtinyint
21Gross Weight Searchdecimal(38,38)
22Net Weight Searchdecimal(38,38)
23Units per Parcel Searchdecimal(38,38)
24Unit Volume Searchdecimal(38,38)
25Shortcut Dimension 1 Code Searchnvarchar(40)
26Shortcut Dimension 2 Code Searchnvarchar(40)
27Customer Price Group Searchnvarchar(20)
Key to join to the Customer Price Group table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
       [Service Cr_Memo Line].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Service Cr_Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Cr_Memo Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Service Cr_Memo Line].[Tax Area Code] = [Tax Area].[Code]
42Tax Liable Searchtinyint
43Tax Group Code Searchnvarchar(40)
Key to join to the Tax Group table.

Show/hide example query

SELECT
       [Service Cr_Memo Line].[Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Cr_Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Cr_Memo Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [Service Cr_Memo Line].[Tax Group Code] = [Tax Group].[Code]
44VAT Clause Code Searchnvarchar(40)
45VAT Bus_ Posting Group Searchnvarchar(40)
46VAT Prod_ Posting Group Searchnvarchar(40)
47VAT Base Amount Searchdecimal(38,38)
48Unit Cost Searchdecimal(38,38)
49System-Created Entry Searchtinyint
50Line Amount Searchdecimal(38,38)
51VAT Difference Searchdecimal(38,38)
52VAT Identifier Searchnvarchar(40)
53Pmt_ Discount Amount Searchdecimal(38,38)
54Dimension Set ID Searchint
55Variant Code Searchnvarchar(20)
56Bin Code Searchnvarchar(40)
57Qty_ per Unit of Measure Searchdecimal(38,38)
58Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Service Cr_Memo Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Service Cr_Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Cr_Memo Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Service Cr_Memo Line].[Unit of Measure Code] = [Unit of Measure].[Code]
59Quantity (Base) Searchdecimal(38,38)
60Responsibility Center Searchnvarchar(20)
61Item Category Code Searchnvarchar(40)
Key to join to the Item Category table.

Show/hide example query

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

Show/hide example query

SELECT
       [Service Cr_Memo Line].[Product Group Code]
       ,[Product Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Cr_Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Cr_Memo Line]
LEFT JOIN
       [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
              ON
                     [Service Cr_Memo Line].[Product Group Code] = [Product Group].[Code]
64Appl_-from Item Entry Searchint
65Service Item No_ Searchnvarchar(40)
66Appl_-to Service Entry Searchint
67Service Item Serial No_ Searchnvarchar(100)
68Service Item Line Description Searchnvarchar(200)
69Posting Date Searchdatetime
70Needed by Date Searchdatetime
71Ship-to Code Searchnvarchar(20)
72Service Price Group Code Searchnvarchar(20)
73Fault Area Code Searchnvarchar(20)
74Symptom Code Searchnvarchar(20)
75Fault Code Searchnvarchar(20)
76Resolution Code Searchnvarchar(20)
77Exclude Warranty Searchtinyint
78Warranty Searchtinyint
79Contract No_ Searchnvarchar(40)
80Contract Disc_ _ Searchdecimal(38,38)
81Warranty Disc_ _ Searchdecimal(38,38)
82Component Line No_ Searchint
83Spare Part Action Searchint
84Fault Reason Code Searchnvarchar(20)
85Replaced Item No_ Searchnvarchar(40)
86Exclude Contract Discount Searchtinyint
87Price Adjmt_ Status Searchint
88Line Discount Type Searchint
89Copy Components From Searchint
90Return Reason Code Searchnvarchar(20)
91Price Calculation Method Searchint
92Allow Line Disc_ Searchtinyint
93Customer Disc_ Group Searchnvarchar(40)
Key to join to the Customer Discount Group table.

Show/hide example query

SELECT
       [Service Cr_Memo Line].[Customer Disc_ Group]
       ,[Customer Discount Group].[No_]
FROM
       [CRONUS UK Ltd_$Service Cr_Memo Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Cr_Memo Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
              ON
                     [Service Cr_Memo Line].[Customer Disc_ Group] = [Customer Discount Group].[No_]
94$systemId Searchuniqueidentifier
95$systemCreatedAt Searchdatetime
96$systemCreatedBy Searchuniqueidentifier
97$systemModifiedAt Searchdatetime
98$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Service Cr_Memo Line table

Leave a Reply

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