Direct 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
   [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_]
   ,[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_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Direct Trans_ Line].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Direct Trans_ Line].[Unit of Measure Code] = [Unit of Measure].[Code]
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]

Show/hide columns in Direct Trans_ 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
       [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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Direct Trans_ 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
       [Direct Trans_ Line].[Unit of Measure Code]
       ,[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 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)
22Posting Date Searchdatetime
23Transfer-from Code Searchnvarchar(20)
24Transfer-to Code Searchnvarchar(20)
25Item Shpt_ Entry No_ Searchint
26Item Rcpt_ Entry No_ Searchint
27Dimension Set ID Searchint
28Item Category Code Searchnvarchar(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]
29Transfer-from Bin Code Searchnvarchar(40)
30Transfer-To Bin Code Searchnvarchar(40)
31$systemId Searchuniqueidentifier
32$systemCreatedAt Searchdatetime
33$systemCreatedBy Searchuniqueidentifier
34$systemModifiedAt Searchdatetime
35$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Direct Trans_ Line table

Leave a Reply

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