Order Tracking Entry

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

Table Type: Company

Table Name: Order Tracking Entry
Database Table Name: CRONUS UK Ltd_$Order Tracking Entry$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 99000799

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 Order Tracking Entry can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Order Tracking Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [Entry No_]
   ,[Supplied by]
   ,[Demanded by]
   ,[Shipment Date]
   ,[Expected Receipt Date]
   ,[Item No_]
   ,[Quantity]
   ,[Level]
   ,[For Type]
   ,[For Subtype]
   ,[For ID]
   ,[For Batch Name]
   ,[For Prod_ Order Line]
   ,[For Ref_ No_]
   ,[From Type]
   ,[From Subtype]
   ,[From ID]
   ,[From Batch Name]
   ,[From Prod_ Order Line]
   ,[From Ref_ No_]
   ,[Starting Date]
   ,[Ending Date]
   ,[Name]
   ,[Warning]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Order Tracking Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Order Tracking Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Order Tracking Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
      ON
         [Order Tracking Entry].[Ending Date] = [Inventory Period].[Ending Date]
LEFT JOIN
   [User] AS [User]
      ON
         [Order Tracking Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Order Tracking Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Order Tracking Entry table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
2Supplied by SearchSupplied byNormalText80Supplied bynvarchar(160)
3Demanded by SearchDemanded byNormalText80Demanded bynvarchar(160)
8Shipment Date SearchShipment DateNormalDate4Shipment Datedatetime
9Expected Receipt Date SearchExpected Receipt DateNormalDate4Expected Receipt Datedatetime
11Item No. SearchItem No.NormalCode20Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Order Tracking Entry].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Order Tracking Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Order Tracking Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Order Tracking Entry].[Item No_] = [Item].[No_]
13Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
14Level SearchLevelNormalInteger4Levelint
20For Type SearchFor TypeNormalInteger4For Typeint
21For Subtype SearchFor SubtypeNormalInteger4For Subtypeint
22For ID SearchFor IDNormalCode20For IDnvarchar(40)
23For Batch Name SearchFor Batch NameNormalCode10For Batch Namenvarchar(20)
24For Prod. Order Line SearchFor Prod. Order LineNormalInteger4For Prod_ Order Lineint
25For Ref. No. SearchFor Ref. No.NormalInteger4For Ref_ No_int
26From Type SearchFrom TypeNormalInteger4From Typeint
27From Subtype SearchFrom SubtypeNormalInteger4From Subtypeint
28From ID SearchFrom IDNormalCode20From IDnvarchar(40)
29From Batch Name SearchFrom Batch NameNormalCode10From Batch Namenvarchar(20)
30From Prod. Order Line SearchFrom Prod. Order LineNormalInteger4From Prod_ Order Lineint
31From Ref. No. SearchFrom Ref. No.NormalInteger4From Ref_ No_int
40Starting Date SearchStarting DateNormalDate4Starting Datedatetime
41Ending Date SearchEnding DateNormalDate4Ending Datedatetime
Key to join to the Inventory Period table.

Show/hide example query

SELECT
       [Order Tracking Entry].[Ending Date]
       ,[Inventory Period].[Ending Date]
FROM
       [CRONUS UK Ltd_$Order Tracking Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Order Tracking Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
              ON
                     [Order Tracking Entry].[Ending Date] = [Inventory Period].[Ending Date]
42Name SearchNameNormalText80Namenvarchar(160)
43Warning SearchWarningNormalBoolean4Warningtinyint
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
       [Order Tracking Entry].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Order Tracking Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Order Tracking Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Order Tracking Entry].[$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
       [Order Tracking Entry].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Order Tracking Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Order Tracking Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Order Tracking Entry].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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