Transfer 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: 0

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 IDColumn NameData Type
1timestamp Searchtimestamp
2Document No_ Primary Key Searchnvarchar(40)
3Line No_ Primary Key Searchint
4Item No_ Searchnvarchar(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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Transfer Receipt Line].[Item No_] = [Item].[No_]
5Quantity Searchdecimal(38,38)
6Unit of Measure Searchnvarchar(100)
7Description Searchnvarchar(200)
8Shortcut Dimension 1 Code Searchnvarchar(40)
9Shortcut Dimension 2 Code Searchnvarchar(40)
10Gen_ Prod_ Posting Group Searchnvarchar(40)
11Inventory Posting Group Searchnvarchar(40)
12Quantity (Base) Searchdecimal(38,38)
13Qty_ per Unit of Measure Searchdecimal(38,38)
14Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [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]
15Gross Weight Searchdecimal(38,38)
16Net Weight Searchdecimal(38,38)
17Unit Volume Searchdecimal(38,38)
18Variant Code Searchnvarchar(20)
19Units per Parcel Searchdecimal(38,38)
20Description 2 Searchnvarchar(100)
21Transfer Order No_ Searchnvarchar(40)
22Receipt Date Searchdatetime
23Shipping Agent Code Searchnvarchar(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] AS [Shipping Agent]
              ON
                     [Transfer Receipt Line].[Shipping Agent Code] = [Shipping Agent].[Code]
24Shipping Agent Service Code Searchnvarchar(20)
Key to join to the Shipping Agent Services table.

Show/hide example query

SELECT
       [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]
25In-Transit Code Searchnvarchar(20)
26Transfer-from Code Searchnvarchar(20)
27Transfer-to Code Searchnvarchar(20)
28Item Rcpt_ Entry No_ Searchint
29Shipping Time Searchvarchar(32)
30Dimension Set ID Searchint
31Item Category Code Searchnvarchar(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]
32Product Group Code Searchnvarchar(20)
Key to join to the Product Group table.

Show/hide example query

SELECT
       [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]
33Transfer-To Bin Code Searchnvarchar(40)
34$systemId Searchuniqueidentifier
35$systemCreatedAt Searchdatetime
36$systemCreatedBy Searchuniqueidentifier
37$systemModifiedAt Searchdatetime
38$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Transfer Receipt Line table

Leave a Reply

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