Transfer Line

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

Table Type: Company

Table Name: Transfer Line
Database Table Name: CRONUS UK Ltd_$Transfer 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 Line can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Transfer 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]
   ,[Qty_ to Ship]
   ,[Qty_ to Receive]
   ,[Quantity Shipped]
   ,[Quantity Received]
   ,[Status]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Description]
   ,[Gen_ Prod_ Posting Group]
   ,[Inventory Posting Group]
   ,[Quantity (Base)]
   ,[Outstanding Qty_ (Base)]
   ,[Qty_ to Ship (Base)]
   ,[Qty_ Shipped (Base)]
   ,[Qty_ to Receive (Base)]
   ,[Qty_ Received (Base)]
   ,[Qty_ per Unit of Measure]
   ,[Unit of Measure Code]
   ,[Outstanding Quantity]
   ,[Gross Weight]
   ,[Net Weight]
   ,[Unit Volume]
   ,[Qty_ Rounding Precision]
   ,[Qty_ Rounding Precision (Base)]
   ,[Variant Code]
   ,[Units per Parcel]
   ,[Description 2]
   ,[In-Transit Code]
   ,[Qty_ in Transit]
   ,[Qty_ in Transit (Base)]
   ,[Transfer-from Code]
   ,[Transfer-to Code]
   ,[Shipment Date]
   ,[Receipt Date]
   ,[Derived From Line No_]
   ,[Shipping Agent Code]
   ,[Shipping Agent Service Code]
   ,[Appl_-to Item Entry]
   ,[Shipping Time]
   ,[Direct Transfer]
   ,[Dimension Set ID]
   ,[Item Category Code]
   ,[Product Group Code]
   ,[Completely Shipped]
   ,[Completely Received]
   ,[Outbound Whse_ Handling Time]
   ,[Inbound Whse_ Handling Time]
   ,[Transfer-from Bin Code]
   ,[Transfer-To Bin Code]
   ,[Planning Flexibility]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Transfer 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 Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Line]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Transfer Line].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Transfer 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 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 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 Line].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
      ON
         [Transfer Line].[Product Group Code] = [Product Group].[Code]

Show/hide columns in Transfer 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 Line].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Transfer Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Transfer Line].[Item No_] = [Item].[No_]
5Quantity Searchdecimal(38,38)
6Unit of Measure Searchnvarchar(100)
7Qty_ to Ship Searchdecimal(38,38)
8Qty_ to Receive Searchdecimal(38,38)
9Quantity Shipped Searchdecimal(38,38)
10Quantity Received Searchdecimal(38,38)
11Status Searchint
12Shortcut Dimension 1 Code Searchnvarchar(40)
13Shortcut Dimension 2 Code Searchnvarchar(40)
14Description Searchnvarchar(200)
15Gen_ Prod_ Posting Group Searchnvarchar(40)
16Inventory Posting Group Searchnvarchar(40)
17Quantity (Base) Searchdecimal(38,38)
18Outstanding Qty_ (Base) Searchdecimal(38,38)
19Qty_ to Ship (Base) Searchdecimal(38,38)
20Qty_ Shipped (Base) Searchdecimal(38,38)
21Qty_ to Receive (Base) Searchdecimal(38,38)
22Qty_ Received (Base) Searchdecimal(38,38)
23Qty_ per Unit of Measure Searchdecimal(38,38)
24Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Transfer Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Transfer Line].[Unit of Measure Code] = [Unit of Measure].[Code]
25Outstanding Quantity Searchdecimal(38,38)
26Gross Weight Searchdecimal(38,38)
27Net Weight Searchdecimal(38,38)
28Unit Volume Searchdecimal(38,38)
29Qty_ Rounding Precision Searchdecimal(38,38)
30Qty_ Rounding Precision (Base) Searchdecimal(38,38)
31Variant Code Searchnvarchar(20)
32Units per Parcel Searchdecimal(38,38)
33Description 2 Searchnvarchar(100)
34In-Transit Code Searchnvarchar(20)
35Qty_ in Transit Searchdecimal(38,38)
36Qty_ in Transit (Base) Searchdecimal(38,38)
37Transfer-from Code Searchnvarchar(20)
38Transfer-to Code Searchnvarchar(20)
39Shipment Date Searchdatetime
40Receipt Date Searchdatetime
41Derived From Line No_ Searchint
42Shipping Agent Code Searchnvarchar(20)
Key to join to the Shipping Agent table.

Show/hide example query

SELECT
       [Transfer Line].[Shipping Agent Code]
       ,[Shipping Agent].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Line]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
              ON
                     [Transfer Line].[Shipping Agent Code] = [Shipping Agent].[Code]
43Shipping Agent Service Code Searchnvarchar(20)
Key to join to the Shipping Agent Services table.

Show/hide example query

SELECT
       [Transfer Line].[Shipping Agent Service Code]
       ,[Shipping Agent Services].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Line]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
              ON
                     [Transfer Line].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]
44Appl_-to Item Entry Searchint
45Shipping Time Searchvarchar(32)
46Direct Transfer Searchtinyint
47Dimension Set ID Searchint
48Item Category Code Searchnvarchar(40)
Key to join to the Item Category table.

Show/hide example query

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

Show/hide example query

SELECT
       [Transfer Line].[Product Group Code]
       ,[Product Group].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Line]
LEFT JOIN
       [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
              ON
                     [Transfer Line].[Product Group Code] = [Product Group].[Code]
50Completely Shipped Searchtinyint
51Completely Received Searchtinyint
52Outbound Whse_ Handling Time Searchvarchar(32)
53Inbound Whse_ Handling Time Searchvarchar(32)
54Transfer-from Bin Code Searchnvarchar(40)
55Transfer-To Bin Code Searchnvarchar(40)
56Planning Flexibility Searchint
57$systemId Searchuniqueidentifier
58$systemCreatedAt Searchdatetime
59$systemCreatedBy Searchuniqueidentifier
60$systemModifiedAt Searchdatetime
61$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Transfer Line table

Leave a Reply

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