Direct Trans. Line

Dynamics 365 BC Table ReferenceTablesCompany TablesDDirect Trans. Line

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

Table Type: Company

Table Name: Direct Trans. Line
Database Table Name: CRONUS UK Ltd_$Direct Trans_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5857

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Direct Trans_ 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_]
   ,[Posting Date]
   ,[Transfer-from Code]
   ,[Transfer-to Code]
   ,[Item Shpt_ Entry No_]
   ,[Item Rcpt_ Entry No_]
   ,[Dimension Set ID]
   ,[Item Category Code]
   ,[Transfer-from Bin Code]
   ,[Transfer-To Bin Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide columns in Direct Trans. 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
	       [Direct Trans. Line].[Item No_]
	       ,[Item].[No_]
	FROM
	       [CRONUS UK Ltd_$Direct Trans_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Trans. Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
	              ON
	                     [Direct Trans. 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
	       [Direct Trans. Line].[Unit of Measure]
	       ,[Unit of Measure].[Code]
	FROM
	       [CRONUS UK Ltd_$Direct Trans_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Trans. Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
	              ON
	                     [Direct Trans. 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
	       [Direct Trans. Line].[Shortcut Dimension 1 Code]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$Direct Trans_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Trans. Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [Direct Trans. 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
	       [Direct Trans. Line].[Shortcut Dimension 2 Code]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$Direct Trans_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Trans. Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [Direct Trans. 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
	       [Direct Trans. Line].[Gen_ Prod_ Posting Group]
	       ,[Gen. Product Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Direct Trans_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Trans. Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
	              ON
	                     [Direct Trans. 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
	       [Direct Trans. Line].[Inventory Posting Group]
	       ,[Inventory Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Direct Trans_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Trans. Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
	              ON
	                     [Direct Trans. 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
	       [Direct Trans. Line].[Variant Code]
	       ,[Item Variant].[Code]
	FROM
	       [CRONUS UK Ltd_$Direct Trans_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Trans. Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
	              ON
	                     [Direct Trans. 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
	       [Direct Trans. Line].[Transfer Order No_]
	       ,[Transfer Header].[No_]
	FROM
	       [CRONUS UK Ltd_$Direct Trans_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Trans. Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Transfer Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Header]
	              ON
	                     [Direct Trans. Line].[Transfer Order No_] = [Transfer Header].[No_]
25Posting Date SearchPosting DateNormalDate4Posting Datedatetime
29Transfer-from Code SearchTransfer-from CodeNormalCode10Transfer-from Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
	       [Direct Trans. Line].[Transfer-from Code]
	       ,[Location].[Code]
	FROM
	       [CRONUS UK Ltd_$Direct Trans_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Trans. Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
	              ON
	                     [Direct Trans. 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
	       [Direct Trans. Line].[Transfer-to Code]
	       ,[Location].[Code]
	FROM
	       [CRONUS UK Ltd_$Direct Trans_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Trans. Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
	              ON
	                     [Direct Trans. Line].[Transfer-to Code] = [Location].[Code]
31Item Shpt. Entry No. SearchItem Shpt. Entry No.NormalInteger4Item Shpt_ Entry No_int
33Item Rcpt. Entry No. SearchItem Rcpt. Entry No.NormalInteger4Item Rcpt_ Entry No_int
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
	       [Direct Trans. Line].[Dimension Set ID]
	       ,[Dimension Set Entry].[Dimension Set ID]
	FROM
	       [CRONUS UK Ltd_$Direct Trans_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Trans. Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
	              ON
	                     [Direct Trans. 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
	       [Direct Trans. Line].[Item Category Code]
	       ,[Item Category].[Code]
	FROM
	       [CRONUS UK Ltd_$Direct Trans_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Trans. Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
	              ON
	                     [Direct Trans. Line].[Item Category Code] = [Item Category].[Code]
7300Transfer-from Bin Code SearchTransfer-from Bin CodeNormalCode20Transfer-from Bin Codenvarchar(40)
7301Transfer-To Bin Code SearchTransfer-To Bin CodeNormalCode20Transfer-To Bin Codenvarchar(40)
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
	       [Direct Trans. Line].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Direct Trans_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Direct Trans. Line]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Direct Trans. Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Direct Trans. Line table

Item CategoryUnit of Measure
Dynamics 365 BC Table ReferenceTablesCompany TablesDDirect Trans. Line

Leave a Reply

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