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: 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 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
   [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_]
   ,[Shipment Date]
   ,[Shipping Agent Code]
   ,[Shipping Agent Service Code]
   ,[In-Transit Code]
   ,[Transfer-from Code]
   ,[Transfer-to Code]
   ,[Item Shpt_ Entry No_]
   ,[Shipping Time]
   ,[Dimension Set ID]
   ,[Item Category Code]
   ,[Product Group Code]
   ,[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_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Transfer Shipment Line].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Transfer Shipment 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 Shipment 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 Shipment 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 Shipment Line].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
      ON
         [Transfer Shipment Line].[Product Group Code] = [Product Group].[Code]

Show/hide columns in Transfer Shipment 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 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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Transfer Shipment 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 Shipment Line].[Unit of Measure Code]
       ,[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 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)
22Shipment Date Searchdatetime
23Shipping Agent Code Searchnvarchar(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] AS [Shipping Agent]
              ON
                     [Transfer Shipment 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 Shipment Line].[Shipping Agent Service Code]
       ,[Shipping Agent Services].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
              ON
                     [Transfer Shipment 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 Shpt_ 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 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]
32Product Group Code Searchnvarchar(20)
Key to join to the Product Group table.

Show/hide example query

SELECT
       [Transfer Shipment Line].[Product Group Code]
       ,[Product Group].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
              ON
                     [Transfer Shipment Line].[Product Group Code] = [Product Group].[Code]
33Transfer-from 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 Shipment Line table

Leave a Reply

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