Transfer Shipment Line

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

Table Type: Company

Table Name: Transfer Shipment Line
Database Table Name: CRONUS UK Ltd_$Transfer Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5745

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 Shipment Line can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Transfer Shipment 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_]
   ,[Shipment Date]
   ,[Shipping Agent Code]
   ,[Shipping Agent Service Code]
   ,[In-Transit Code]
   ,[Transfer-from Code]
   ,[Transfer-to Code]
   ,[Item Shpt_ Entry No_]
   ,[Shipping Time]
   ,[Trans_ Order Line No_]
   ,[Derived Trans_ Order Line No_]
   ,[Dimension Set ID]
   ,[Item Category Code]
   ,[Product Group Code]
   ,[Correction Line]
   ,[Transfer-from Bin Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Transfer Shipment 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 Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Line]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Transfer Shipment Line].[Unit of Measure] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Transfer Shipment Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Transfer Shipment 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 Shipment 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 Shipment Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Shipping Agent]
      ON
         [Transfer Shipment Line].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Transfer Shipment Line].[Transfer-from Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Transfer Shipment 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 Shipment 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 Shipment Line].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Transfer Shipment Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Transfer Shipment Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Transfer Shipment Line table

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

Show/hide example query

SELECT
	       [Transfer Shipment Line].[Item No_]
	       ,[Item].[No_]
	FROM
	       [CRONUS UK Ltd_$Transfer Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
	              ON
	                     [Transfer Shipment 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 Shipment Line].[Unit of Measure]
	       ,[Unit of Measure].[Code]
	FROM
	       [CRONUS UK Ltd_$Transfer Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
	              ON
	                     [Transfer Shipment 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 Shipment Line].[Shortcut Dimension 1 Code]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$Transfer Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [Transfer Shipment 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 Shipment Line].[Shortcut Dimension 2 Code]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$Transfer Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [Transfer Shipment 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 Shipment Line].[Gen_ Prod_ Posting Group]
	       ,[Gen. Product Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Transfer Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
	              ON
	                     [Transfer Shipment 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 Shipment Line].[Inventory Posting Group]
	       ,[Inventory Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Transfer Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
	              ON
	                     [Transfer Shipment 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 Shipment Line].[Variant Code]
	       ,[Item Variant].[Code]
	FROM
	       [CRONUS UK Ltd_$Transfer Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
	              ON
	                     [Transfer Shipment 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 Shipment Line].[Transfer Order No_]
	       ,[Transfer Header].[No_]
	FROM
	       [CRONUS UK Ltd_$Transfer Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Transfer Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Header]
	              ON
	                     [Transfer Shipment Line].[Transfer Order No_] = [Transfer Header].[No_]
25Shipment Date SearchShipment DateNormalDate4Shipment Datedatetime
26Shipping Agent Code SearchShipping Agent CodeNormalCode10Shipping Agent Codenvarchar(20)
Key to join to the Shipping Agent table.

Show/hide example query

SELECT
	       [Transfer Shipment Line].[Shipping Agent Code]
	       ,[Shipping Agent].[Code]
	FROM
	       [CRONUS UK Ltd_$Transfer Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Shipping Agent]
	              ON
	                     [Transfer Shipment 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 Shipment Line].[Transfer-from Code]
	       ,[Location].[Code]
	FROM
	       [CRONUS UK Ltd_$Transfer Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
	              ON
	                     [Transfer Shipment 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 Shipment Line].[Transfer-to Code]
	       ,[Location].[Code]
	FROM
	       [CRONUS UK Ltd_$Transfer Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
	              ON
	                     [Transfer Shipment Line].[Transfer-to Code] = [Location].[Code]
31Item Shpt. Entry No. SearchItem Shpt. Entry No.NormalInteger4Item Shpt_ Entry No_int
32Shipping Time SearchShipping TimeNormalDateFormula32Shipping Timevarchar(32)
33Trans. Order Line No. SearchTransfer Order Line No.NormalInteger4Trans_ Order Line No_int
34Derived Trans. Order Line No. SearchDerived Transfer Order Line No.NormalInteger4Derived Trans_ Order Line No_int
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
	       [Transfer Shipment Line].[Dimension Set ID]
	       ,[Dimension Set Entry].[Dimension Set ID]
	FROM
	       [CRONUS UK Ltd_$Transfer Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
	              ON
	                     [Transfer Shipment 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 Shipment Line].[Item Category Code]
	       ,[Item Category].[Code]
	FROM
	       [CRONUS UK Ltd_$Transfer Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
	              ON
	                     [Transfer Shipment Line].[Item Category Code] = [Item Category].[Code]
5707Product Group Code SearchProduct Group CodeNormalCode10Product Group Codenvarchar(20)
5817Correction Line SearchCorrectionNormalBoolean4Correction Linetinyint
7300Transfer-from Bin Code SearchTransfer-from Bin CodeNormalCode20Transfer-from Bin Codenvarchar(40)
10003Custom Transit Number SearchCustom Transit NumberNormalText30
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 Shipment Line].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Transfer Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Line]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Transfer Shipment Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Transfer Shipment Line table

Leave a Reply

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