Return Receipt Line

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

Table Type: Company

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

Table Number: 6661

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 Return Receipt Line can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Return Receipt 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 _]
   ,[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]
   ,[Customer Price Group]
   ,[Job No_]
   ,[Work Type Code]
   ,[Quantity Invoiced]
   ,[Bill-to Customer No_]
   ,[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 Bus_ Posting Group]
   ,[VAT Prod_ Posting Group]
   ,[Blanket Order No_]
   ,[Blanket Order Line No_]
   ,[VAT Base Amount]
   ,[Unit Cost]
   ,[Posting Date]
   ,[IC Item Reference No_]
   ,[Dimension Set ID]
   ,[Variant Code]
   ,[Bin Code]
   ,[Qty_ per Unit of Measure]
   ,[Unit of Measure Code]
   ,[Quantity (Base)]
   ,[Qty_ Invoiced (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_]
   ,[Return Qty_ Rcd_ Not Invd_]
   ,[Appl_-from Item Entry]
   ,[Item Charge Base Amount]
   ,[Correction]
   ,[Return Order No_]
   ,[Return Order Line No_]
   ,[Return Reason Code]
   ,[Price Calculation Method]
   ,[Allow Line Disc_]
   ,[Customer Disc_ Group]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Return Receipt 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_$Return Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Receipt Line]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Return Receipt Line].[Sell-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Return Receipt Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
      ON
         [Return Receipt Line].[Customer Price Group] = [Customer Price Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [Return Receipt Line].[Job No_] = [Job].[Job No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Return Receipt Line].[Bill-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Return Receipt Line].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Return Receipt 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
         [Return Receipt 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
         [Return Receipt Line].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
      ON
         [Return Receipt 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
         [Return Receipt Line].[Customer Disc_ Group] = [Customer Discount Group].[No_]

Show/hide columns in Return Receipt 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
       [Return Receipt Line].[Sell-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Return Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Return Receipt 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
       [Return Receipt Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Return Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Return Receipt 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)
18Allow Invoice Disc_ Searchtinyint
19Gross Weight Searchdecimal(38,38)
20Net Weight Searchdecimal(38,38)
21Units per Parcel Searchdecimal(38,38)
22Unit Volume Searchdecimal(38,38)
23Appl_-to Item Entry Searchint
24Item Rcpt_ Entry No_ Searchint
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
       [Return Receipt Line].[Customer Price Group]
       ,[Customer Price Group].[Code]
FROM
       [CRONUS UK Ltd_$Return Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
              ON
                     [Return Receipt Line].[Customer Price Group] = [Customer Price Group].[Code]
28Job No_ Searchnvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Return Receipt Line].[Job No_]
       ,[Job].[Job No_]
FROM
       [CRONUS UK Ltd_$Return Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
              ON
                     [Return Receipt Line].[Job No_] = [Job].[Job No_]
29Work Type Code Searchnvarchar(20)
30Quantity Invoiced Searchdecimal(38,38)
31Bill-to Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Return Receipt Line].[Bill-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Return Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Return Receipt Line].[Bill-to Customer No_] = [Customer].[No_]
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
       [Return Receipt Line].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Return Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Return Receipt 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
       [Return Receipt Line].[Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$Return Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [Return Receipt Line].[Tax Group Code] = [Tax Group].[Code]
44VAT Bus_ Posting Group Searchnvarchar(40)
45VAT Prod_ Posting Group Searchnvarchar(40)
46Blanket Order No_ Searchnvarchar(40)
47Blanket Order Line No_ Searchint
48VAT Base Amount Searchdecimal(38,38)
49Unit Cost Searchdecimal(38,38)
50Posting Date Searchdatetime
51IC Item Reference No_ Searchnvarchar(100)
52Dimension Set ID Searchint
53Variant Code Searchnvarchar(20)
54Bin Code Searchnvarchar(40)
55Qty_ per Unit of Measure Searchdecimal(38,38)
56Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Return Receipt Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Return Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Return Receipt Line].[Unit of Measure Code] = [Unit of Measure].[Code]
57Quantity (Base) Searchdecimal(38,38)
58Qty_ Invoiced (Base) Searchdecimal(38,38)
59FA Posting Date Searchdatetime
60Depreciation Book Code Searchnvarchar(20)
61Depr_ until FA Posting Date Searchtinyint
62Duplicate in Depreciation Book Searchnvarchar(20)
63Use Duplication List Searchtinyint
64Responsibility Center Searchnvarchar(20)
65Cross-Reference No_ Searchnvarchar(40)
66Unit of Measure (Cross Ref_) Searchnvarchar(20)
67Cross-Reference Type Searchint
68Cross-Reference Type No_ Searchnvarchar(60)
69Item Category Code Searchnvarchar(40)
Key to join to the Item Category table.

Show/hide example query

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

Show/hide example query

SELECT
       [Return Receipt Line].[Product Group Code]
       ,[Product Group].[Code]
FROM
       [CRONUS UK Ltd_$Return Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
              ON
                     [Return Receipt Line].[Product Group Code] = [Product Group].[Code]
73Item Reference No_ Searchnvarchar(100)
74Item Reference Unit of Measure Searchnvarchar(20)
75Item Reference Type Searchint
76Item Reference Type No_ Searchnvarchar(60)
77Return Qty_ Rcd_ Not Invd_ Searchdecimal(38,38)
78Appl_-from Item Entry Searchint
79Item Charge Base Amount Searchdecimal(38,38)
80Correction Searchtinyint
81Return Order No_ Searchnvarchar(40)
82Return Order Line No_ Searchint
83Return Reason Code Searchnvarchar(20)
84Price Calculation Method Searchint
85Allow Line Disc_ Searchtinyint
86Customer Disc_ Group Searchnvarchar(40)
Key to join to the Customer Discount Group table.

Show/hide example query

SELECT
       [Return Receipt Line].[Customer Disc_ Group]
       ,[Customer Discount Group].[No_]
FROM
       [CRONUS UK Ltd_$Return Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
              ON
                     [Return Receipt Line].[Customer Disc_ Group] = [Customer Discount Group].[No_]
87$systemId Searchuniqueidentifier
88$systemCreatedAt Searchdatetime
89$systemCreatedBy Searchuniqueidentifier
90$systemModifiedAt Searchdatetime
91$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Return Receipt Line table

Leave a Reply

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