Transfer Receipt Line

Dynamics 365 BC Table ReferenceTablesCompany TablesTTransfer Receipt Line

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

Table Number: 5747

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

   [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_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Transfer Receipt Line].[Unit of Measure] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Transfer Receipt Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Transfer Receipt Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
      ON
         [Transfer Receipt Line].[Inventory Posting Group] = [Inventory Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Transfer Receipt Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Shipping Agent]
      ON
         [Transfer Receipt Line].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Transfer Receipt Line].[Transfer-from Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Transfer Receipt Line].[Transfer-to Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Transfer Receipt Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
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
   [User] AS [User]
      ON
         [Transfer Receipt Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Transfer Receipt Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Transfer Receipt Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Document No. Primary Key SearchDocument No.NormalCode20Document No_nvarchar(40)
2Line No. Primary Key SearchLine No.NormalInteger4Line No_int
3Item No. SearchItem No.NormalCode20Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [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$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Transfer Receipt Line].[Item No_] = [Item].[No_]
4Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
5Unit of Measure SearchUnit of MeasureNormalText50Unit of Measurenvarchar(100)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Transfer Receipt Line].[Unit of Measure]
       ,[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] = [Unit of Measure].[Code]
7Description SearchDescriptionNormalText100Descriptionnvarchar(200)
8Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Transfer Receipt Line].[Shortcut Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Transfer Receipt Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
9Shortcut Dimension 2 Code SearchShortcut Dimension 2 CodeNormalCode20Shortcut Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Transfer Receipt Line].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Transfer Receipt Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
10Gen. Prod. Posting Group SearchGen. Prod. Posting GroupNormalCode20Gen_ Prod_ Posting Groupnvarchar(40)
Key to join to the Gen. Product Posting Group table.

Show/hide example query

SELECT
       [Transfer Receipt Line].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Transfer Receipt Line].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
11Inventory Posting Group SearchInventory Posting GroupNormalCode20Inventory Posting Groupnvarchar(40)
Key to join to the Inventory Posting Group table.

Show/hide example query

SELECT
       [Transfer Receipt Line].[Inventory Posting Group]
       ,[Inventory Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
              ON
                     [Transfer Receipt Line].[Inventory Posting Group] = [Inventory Posting Group].[Code]
12Quantity (Base) SearchQuantity (Base)NormalDecimal12Quantity (Base)decimal(38,38)
14Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
15Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
16Gross Weight SearchGross WeightNormalDecimal12Gross Weightdecimal(38,38)
17Net Weight SearchNet WeightNormalDecimal12Net Weightdecimal(38,38)
18Unit Volume SearchUnit VolumeNormalDecimal12Unit Volumedecimal(38,38)
21Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Transfer Receipt Line].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Transfer Receipt Line].[Variant Code] = [Item Variant].[Code]
22Units per Parcel SearchUnits per ParcelNormalDecimal12Units per Parceldecimal(38,38)
23Description 2 SearchDescription 2NormalText50Description 2nvarchar(100)
24Transfer Order No. SearchTransfer Order No.NormalCode20Transfer Order No_nvarchar(40)
Key to join to the Transfer Header table.

Show/hide example query

SELECT
       [Transfer Receipt Line].[Transfer Order No_]
       ,[Transfer Header].[No_]
FROM
       [CRONUS UK Ltd_$Transfer Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Transfer Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Header]
              ON
                     [Transfer Receipt Line].[Transfer Order No_] = [Transfer Header].[No_]
25Receipt Date SearchReceipt DateNormalDate4Receipt Datedatetime
26Shipping Agent Code SearchShipping Agent CodeNormalCode10Shipping Agent Codenvarchar(20)
Key to join to the Shipping Agent table.

Show/hide example query

SELECT
       [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$ext] AS [Shipping Agent]
              ON
                     [Transfer Receipt Line].[Shipping Agent Code] = [Shipping Agent].[Code]
27Shipping Agent Service Code SearchShipping Agent Service CodeNormalCode10Shipping Agent Service Codenvarchar(20)
28In-Transit Code SearchIn-Transit CodeNormalCode10In-Transit Codenvarchar(20)
29Transfer-from Code SearchTransfer-from CodeNormalCode10Transfer-from Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Transfer Receipt Line].[Transfer-from Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Transfer Receipt Line].[Transfer-from Code] = [Location].[Code]
30Transfer-to Code SearchTransfer-to CodeNormalCode10Transfer-to Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Transfer Receipt Line].[Transfer-to Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Transfer Receipt Line].[Transfer-to Code] = [Location].[Code]
31Item Rcpt. Entry No. SearchItem Rcpt. Entry No.NormalInteger4Item Rcpt_ Entry No_int
32Shipping Time SearchShipping TimeNormalDateFormula32Shipping Timevarchar(32)
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Transfer Receipt Line].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Transfer Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Transfer Receipt Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
5704Item Category Code SearchItem Category CodeNormalCode20Item Category Codenvarchar(40)
Key to join to the Item Category table.

Show/hide example query

SELECT
       [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]
5707Product Group Code SearchProduct Group CodeNormalCode10Product Group Codenvarchar(20)
7301Transfer-To Bin Code SearchTransfer-To Bin CodeNormalCode20Transfer-To Bin Codenvarchar(40)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Transfer Receipt Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Transfer Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Receipt Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Transfer Receipt Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Transfer Receipt Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Transfer Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Receipt Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Transfer Receipt Line].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Transfer Receipt Line table

Item CategoryProduct GroupShipping AgentShipping Agent ServicesUnit of Measure
Dynamics 365 BC Table ReferenceTablesCompany TablesTTransfer Receipt Line

Leave a Reply

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