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
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 ID | Column Name | Data Type | ||||
|---|---|---|---|---|---|---|
| 1 | timestamp  | timestamp | ||||
| 2 | Document No_  | nvarchar(40) | ||||
| 3 | Line No_ | int | ||||
| 4 | Sell-to Customer No_ | nvarchar(40) | ||||
Key to join to the Customer table.Show/hide example querySELECT
[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_] | ||||||
| 5 | Type | int | ||||
| 6 | No_ | nvarchar(40) | ||||
| 7 | Location Code | nvarchar(20) | ||||
Key to join to the Location table.Show/hide example querySELECT
[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] | ||||||
| 8 | Posting Group | nvarchar(40) | ||||
| 9 | Shipment Date | datetime | ||||
| 10 | Description | nvarchar(200) | ||||
| 11 | Description 2 | nvarchar(100) | ||||
| 12 | Unit of Measure | nvarchar(100) | ||||
| 13 | Quantity | decimal(38,38) | ||||
| 14 | Unit Price | decimal(38,38) | ||||
| 15 | Unit Cost (LCY) | decimal(38,38) | ||||
| 16 | VAT _ | decimal(38,38) | ||||
| 17 | Line Discount _ | decimal(38,38) | ||||
| 18 | Allow Invoice Disc_ | tinyint | ||||
| 19 | Gross Weight | decimal(38,38) | ||||
| 20 | Net Weight | decimal(38,38) | ||||
| 21 | Units per Parcel | decimal(38,38) | ||||
| 22 | Unit Volume | decimal(38,38) | ||||
| 23 | Appl_-to Item Entry | int | ||||
| 24 | Item Rcpt_ Entry No_ | int | ||||
| 25 | Shortcut Dimension 1 Code | nvarchar(40) | ||||
| 26 | Shortcut Dimension 2 Code | nvarchar(40) | ||||
| 27 | Customer Price Group | nvarchar(20) | ||||
Key to join to the Customer Price Group table.Show/hide example querySELECT
[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] | ||||||
| 28 | Job No_ | nvarchar(40) | ||||
Key to join to the Job table.Show/hide example querySELECT
[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_] | ||||||
| 29 | Work Type Code | nvarchar(20) | ||||
| 30 | Quantity Invoiced | decimal(38,38) | ||||
| 31 | Bill-to Customer No_ | nvarchar(40) | ||||
Key to join to the Customer table.Show/hide example querySELECT
[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_] | ||||||
| 32 | Gen_ Bus_ Posting Group | nvarchar(40) | ||||
| 33 | Gen_ Prod_ Posting Group | nvarchar(40) | ||||
| 34 | VAT Calculation Type | int | ||||
| 35 | Transaction Type | nvarchar(20) | ||||
| 36 | Transport Method | nvarchar(20) | ||||
| 37 | Attached to Line No_ | int | ||||
| 38 | Exit Point | nvarchar(20) | ||||
| 39 | Area | nvarchar(20) | ||||
| 40 | Transaction Specification | nvarchar(20) | ||||
| 41 | Tax Area Code | nvarchar(40) | ||||
Key to join to the Tax Area table.Show/hide example querySELECT
[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] | ||||||
| 42 | Tax Liable | tinyint | ||||
| 43 | Tax Group Code | nvarchar(40) | ||||
Key to join to the Tax Group table.Show/hide example querySELECT
[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] | ||||||
| 44 | VAT Bus_ Posting Group | nvarchar(40) | ||||
| 45 | VAT Prod_ Posting Group | nvarchar(40) | ||||
| 46 | Blanket Order No_ | nvarchar(40) | ||||
| 47 | Blanket Order Line No_ | int | ||||
| 48 | VAT Base Amount | decimal(38,38) | ||||
| 49 | Unit Cost | decimal(38,38) | ||||
| 50 | Posting Date | datetime | ||||
| 51 | IC Item Reference No_ | nvarchar(100) | ||||
| 52 | Dimension Set ID | int | ||||
| 53 | Variant Code | nvarchar(20) | ||||
| 54 | Bin Code | nvarchar(40) | ||||
| 55 | Qty_ per Unit of Measure | decimal(38,38) | ||||
| 56 | Unit of Measure Code | nvarchar(20) | ||||
Key to join to the Unit of Measure table.Show/hide example querySELECT
[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] | ||||||
| 57 | Quantity (Base) | decimal(38,38) | ||||
| 58 | Qty_ Invoiced (Base) | decimal(38,38) | ||||
| 59 | FA Posting Date | datetime | ||||
| 60 | Depreciation Book Code | nvarchar(20) | ||||
| 61 | Depr_ until FA Posting Date | tinyint | ||||
| 62 | Duplicate in Depreciation Book | nvarchar(20) | ||||
| 63 | Use Duplication List | tinyint | ||||
| 64 | Responsibility Center | nvarchar(20) | ||||
| 65 | Cross-Reference No_ | nvarchar(40) | ||||
| 66 | Unit of Measure (Cross Ref_) | nvarchar(20) | ||||
| 67 | Cross-Reference Type | int | ||||
| 68 | Cross-Reference Type No_ | nvarchar(60) | ||||
| 69 | Item Category Code | nvarchar(40) | ||||
Key to join to the Item Category table.Show/hide example querySELECT
[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] | ||||||
| 70 | Nonstock | tinyint | ||||
| 71 | Purchasing Code | nvarchar(20) | ||||
| 72 | Product Group Code | nvarchar(20) | ||||
Key to join to the Product Group table.Show/hide example querySELECT
[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] | ||||||
| 73 | Item Reference No_ | nvarchar(100) | ||||
| 74 | Item Reference Unit of Measure | nvarchar(20) | ||||
| 75 | Item Reference Type | int | ||||
| 76 | Item Reference Type No_ | nvarchar(60) | ||||
| 77 | Return Qty_ Rcd_ Not Invd_ | decimal(38,38) | ||||
| 78 | Appl_-from Item Entry | int | ||||
| 79 | Item Charge Base Amount | decimal(38,38) | ||||
| 80 | Correction | tinyint | ||||
| 81 | Return Order No_ | nvarchar(40) | ||||
| 82 | Return Order Line No_ | int | ||||
| 83 | Return Reason Code | nvarchar(20) | ||||
| 84 | Price Calculation Method | int | ||||
| 85 | Allow Line Disc_ | tinyint | ||||
| 86 | Customer Disc_ Group | nvarchar(40) | ||||
Key to join to the Customer Discount Group table.Show/hide example querySELECT
[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 | uniqueidentifier | ||||
| 88 | $systemCreatedAt | datetime | ||||
| 89 | $systemCreatedBy | uniqueidentifier | ||||
| 90 | $systemModifiedAt | datetime | ||||
| 91 | $systemModifiedBy | uniqueidentifier | ||||