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: 5741

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

Show/hide columns in Transfer 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 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$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Transfer 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 Line].[Unit of Measure]
       ,[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] = [Unit of Measure].[Code]
6Qty. to Ship SearchQty. to ShipNormalDecimal12Qty_ to Shipdecimal(38,38)
7Qty. to Receive SearchQty. to ReceiveNormalDecimal12Qty_ to Receivedecimal(38,38)
8Quantity Shipped SearchQuantity ShippedNormalDecimal12Quantity Shippeddecimal(38,38)
9Quantity Received SearchQuantity ReceivedNormalDecimal12Quantity Receiveddecimal(38,38)
10Status SearchStatusNormalOption4Statusint
Available options are:
  • “Open”
  • “Released”
11Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

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

Show/hide example query

SELECT
       [Transfer Line].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Transfer Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
13Description SearchDescriptionNormalText100Descriptionnvarchar(200)
14Gen. 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 Line].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Line]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Transfer Line].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
15Inventory Posting Group SearchInventory Posting GroupNormalCode20Inventory Posting Groupnvarchar(40)
Key to join to the Inventory Posting Group table.

Show/hide example query

SELECT
       [Transfer Line].[Inventory Posting Group]
       ,[Inventory Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Line]
LEFT JOIN
       [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
              ON
                     [Transfer Line].[Inventory Posting Group] = [Inventory Posting Group].[Code]
16Quantity (Base) SearchQuantity (Base)NormalDecimal12Quantity (Base)decimal(38,38)
17Outstanding Qty. (Base) SearchOutstanding Qty. (Base)NormalDecimal12Outstanding Qty_ (Base)decimal(38,38)
18Qty. to Ship (Base) SearchQty. to Ship (Base)NormalDecimal12Qty_ to Ship (Base)decimal(38,38)
19Qty. Shipped (Base) SearchQty. Shipped (Base)NormalDecimal12Qty_ Shipped (Base)decimal(38,38)
20Qty. to Receive (Base) SearchQty. to Receive (Base)NormalDecimal12Qty_ to Receive (Base)decimal(38,38)
21Qty. Received (Base) SearchQty. Received (Base)NormalDecimal12Qty_ Received (Base)decimal(38,38)
22Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
23Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
24Outstanding Quantity SearchOutstanding QuantityNormalDecimal12Outstanding Quantitydecimal(38,38)
25Gross Weight SearchGross WeightNormalDecimal12Gross Weightdecimal(38,38)
26Net Weight SearchNet WeightNormalDecimal12Net Weightdecimal(38,38)
27Unit Volume SearchUnit VolumeNormalDecimal12Unit Volumedecimal(38,38)
28Qty. Rounding Precision SearchQty. Rounding PrecisionNormalDecimal12Qty_ Rounding Precisiondecimal(38,38)
29Qty. Rounding Precision (Base) SearchQty. Rounding Precision (Base)NormalDecimal12Qty_ Rounding Precision (Base)decimal(38,38)
30Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Transfer Line].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Transfer Line].[Variant Code] = [Item Variant].[Code]
31Units per Parcel SearchUnits per ParcelNormalDecimal12Units per Parceldecimal(38,38)
32Description 2 SearchDescription 2NormalText50Description 2nvarchar(100)
33In-Transit Code SearchIn-Transit CodeNormalCode10In-Transit Codenvarchar(20)
34Qty. in Transit SearchQty. in TransitNormalDecimal12Qty_ in Transitdecimal(38,38)
35Qty. in Transit (Base) SearchQty. in Transit (Base)NormalDecimal12Qty_ in Transit (Base)decimal(38,38)
36Transfer-from Code SearchTransfer-from CodeNormalCode10Transfer-from Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

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

Show/hide example query

SELECT
       [Transfer Line].[Transfer-to Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Transfer Line].[Transfer-to Code] = [Location].[Code]
38Shipment Date SearchShipment DateNormalDate4Shipment Datedatetime
39Receipt Date SearchReceipt DateNormalDate4Receipt Datedatetime
40Derived From Line No. SearchDerived From Line No.NormalInteger4Derived From Line No_int
41Shipping Agent Code SearchShipping Agent CodeNormalCode10Shipping Agent Codenvarchar(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$ext] AS [Shipping Agent]
              ON
                     [Transfer Line].[Shipping Agent Code] = [Shipping Agent].[Code]
42Shipping Agent Service Code SearchShipping Agent Service CodeNormalCode10Shipping Agent Service Codenvarchar(20)
43Appl.-to Item Entry SearchAppl.-to Item EntryNormalInteger4Appl_-to Item Entryint
50Reserved Quantity Inbnd. SearchReserved Quantity Inbnd.FlowFieldDecimal12
51Reserved Quantity Outbnd. SearchReserved Quantity Outbnd.FlowFieldDecimal12
52Reserved Qty. Inbnd. (Base) SearchReserved Qty. Inbnd. (Base)FlowFieldDecimal12
53Reserved Qty. Outbnd. (Base) SearchReserved Qty. Outbnd. (Base)FlowFieldDecimal12
54Shipping Time SearchShipping TimeNormalDateFormula32Shipping Timevarchar(32)
55Reserved Quantity Shipped SearchReserved Quantity ShippedFlowFieldDecimal12
56Reserved Qty. Shipped (Base) SearchReserved Qty. Shipped (Base)FlowFieldDecimal12
70Direct Transfer SearchDirect TransferNormalBoolean4Direct Transfertinyint
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Transfer Line].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Transfer Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Transfer 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 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]
5707Product Group Code SearchProduct Group CodeNormalCode10Product Group Codenvarchar(20)
5750Whse. Inbnd. Otsdg. Qty (Base) SearchWhse. Inbnd. Otsdg. Qty (Base)FlowFieldDecimal12
5751Whse Outbnd. Otsdg. Qty (Base) SearchWhse Outbnd. Otsdg. Qty (Base)FlowFieldDecimal12
5752Completely Shipped SearchCompletely ShippedNormalBoolean4Completely Shippedtinyint
5753Completely Received SearchCompletely ReceivedNormalBoolean4Completely Receivedtinyint
5793Outbound Whse. Handling Time SearchOutbound Whse. Handling TimeNormalDateFormula32Outbound Whse_ Handling Timevarchar(32)
5794Inbound Whse. Handling Time SearchInbound Whse. Handling TimeNormalDateFormula32Inbound Whse_ Handling Timevarchar(32)
7300Transfer-from Bin Code SearchTransfer-from Bin CodeNormalCode20Transfer-from Bin Codenvarchar(40)
7301Transfer-To Bin Code SearchTransfer-To Bin CodeNormalCode20Transfer-To Bin Codenvarchar(40)
10003Custom Transit Number SearchCustom Transit NumberNormalText30
99000755Planning Flexibility SearchPlanning FlexibilityNormalOption4Planning Flexibilityint
Available options are:
  • “Unlimited”
  • “None”
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 Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Transfer Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Transfer 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 Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Transfer Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Transfer Line].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Transfer Line table

Leave a Reply

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