Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5747
Table Type: Company
Table Name: Transfer Receipt Line
Database Table Name: CRONUS UK Ltd_$Transfer 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 Transfer Receipt Line can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Transfer Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[Document No_]
,[Line No_]
,[Item No_]
,[Quantity]
,[Unit of Measure]
,[Description]
,[Shortcut Dimension 1 Code]
,[Shortcut Dimension 2 Code]
,[Gen_ Prod_ Posting Group]
,[Inventory Posting Group]
,[Quantity (Base)]
,[Qty_ per Unit of Measure]
,[Unit of Measure Code]
,[Gross Weight]
,[Net Weight]
,[Unit Volume]
,[Variant Code]
,[Units per Parcel]
,[Description 2]
,[Transfer Order No_]
,[Receipt Date]
,[Shipping Agent Code]
,[Shipping Agent Service Code]
,[In-Transit Code]
,[Transfer-from Code]
,[Transfer-to Code]
,[Item Rcpt_ Entry No_]
,[Shipping Time]
,[Dimension Set ID]
,[Item Category Code]
,[Product Group Code]
,[Transfer-To Bin Code]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Transfer 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_$Transfer Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Receipt Line]
LEFT JOIN
[CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
ON
[Transfer Receipt Line].[Item No_] = [Item].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
ON
[Transfer Receipt Line].[Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
ON
[Transfer Receipt Line].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
ON
[Transfer Receipt Line].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
ON
[Transfer Receipt Line].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
ON
[Transfer Receipt Line].[Product Group Code] = [Product Group].[Code]Show/hide columns in Transfer Receipt Line table
| Column ID | Column Name | Data Type | ||||
|---|---|---|---|---|---|---|
| 1 | timestamp  | timestamp | ||||
| 2 | Document No_  | nvarchar(40) | ||||
| 3 | Line No_ | int | ||||
| 4 | Item No_ | nvarchar(40) | ||||
Key to join to the Item table.Show/hide example querySELECT
[Transfer Receipt Line].[Item No_]
,[Item].[No_]
FROM
[CRONUS UK Ltd_$Transfer Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Receipt Line]
LEFT JOIN
[CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
ON
[Transfer Receipt Line].[Item No_] = [Item].[No_] | ||||||
| 5 | Quantity | decimal(38,38) | ||||
| 6 | Unit of Measure | nvarchar(100) | ||||
| 7 | Description | nvarchar(200) | ||||
| 8 | Shortcut Dimension 1 Code | nvarchar(40) | ||||
| 9 | Shortcut Dimension 2 Code | nvarchar(40) | ||||
| 10 | Gen_ Prod_ Posting Group | nvarchar(40) | ||||
| 11 | Inventory Posting Group | nvarchar(40) | ||||
| 12 | Quantity (Base) | decimal(38,38) | ||||
| 13 | Qty_ per Unit of Measure | decimal(38,38) | ||||
| 14 | Unit of Measure Code | nvarchar(20) | ||||
Key to join to the Unit of Measure table.Show/hide example querySELECT
[Transfer Receipt Line].[Unit of Measure Code]
,[Unit of Measure].[Code]
FROM
[CRONUS UK Ltd_$Transfer Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Receipt Line]
LEFT JOIN
[CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
ON
[Transfer Receipt Line].[Unit of Measure Code] = [Unit of Measure].[Code] | ||||||
| 15 | Gross Weight | decimal(38,38) | ||||
| 16 | Net Weight | decimal(38,38) | ||||
| 17 | Unit Volume | decimal(38,38) | ||||
| 18 | Variant Code | nvarchar(20) | ||||
| 19 | Units per Parcel | decimal(38,38) | ||||
| 20 | Description 2 | nvarchar(100) | ||||
| 21 | Transfer Order No_ | nvarchar(40) | ||||
| 22 | Receipt Date | datetime | ||||
| 23 | Shipping Agent Code | nvarchar(20) | ||||
Key to join to the Shipping Agent table.Show/hide example querySELECT
[Transfer Receipt Line].[Shipping Agent Code]
,[Shipping Agent].[Code]
FROM
[CRONUS UK Ltd_$Transfer Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Receipt Line]
LEFT JOIN
[CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
ON
[Transfer Receipt Line].[Shipping Agent Code] = [Shipping Agent].[Code] | ||||||
| 24 | Shipping Agent Service Code | nvarchar(20) | ||||
Key to join to the Shipping Agent Services table.Show/hide example querySELECT
[Transfer Receipt Line].[Shipping Agent Service Code]
,[Shipping Agent Services].[Code]
FROM
[CRONUS UK Ltd_$Transfer Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Receipt Line]
LEFT JOIN
[CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
ON
[Transfer Receipt Line].[Shipping Agent Service Code] = [Shipping Agent Services].[Code] | ||||||
| 25 | In-Transit Code | nvarchar(20) | ||||
| 26 | Transfer-from Code | nvarchar(20) | ||||
| 27 | Transfer-to Code | nvarchar(20) | ||||
| 28 | Item Rcpt_ Entry No_ | int | ||||
| 29 | Shipping Time | varchar(32) | ||||
| 30 | Dimension Set ID | int | ||||
| 31 | Item Category Code | nvarchar(40) | ||||
Key to join to the Item Category table.Show/hide example querySELECT
[Transfer Receipt Line].[Item Category Code]
,[Item Category].[Code]
FROM
[CRONUS UK Ltd_$Transfer Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Receipt Line]
LEFT JOIN
[CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
ON
[Transfer Receipt Line].[Item Category Code] = [Item Category].[Code] | ||||||
| 32 | Product Group Code | nvarchar(20) | ||||
Key to join to the Product Group table.Show/hide example querySELECT
[Transfer Receipt Line].[Product Group Code]
,[Product Group].[Code]
FROM
[CRONUS UK Ltd_$Transfer Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Receipt Line]
LEFT JOIN
[CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
ON
[Transfer Receipt Line].[Product Group Code] = [Product Group].[Code] | ||||||
| 33 | Transfer-To Bin Code | nvarchar(40) | ||||
| 34 | $systemId | uniqueidentifier | ||||
| 35 | $systemCreatedAt | datetime | ||||
| 36 | $systemCreatedBy | uniqueidentifier | ||||
| 37 | $systemModifiedAt | datetime | ||||
| 38 | $systemModifiedBy | uniqueidentifier | ||||