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
   [timestamp]
   ,[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_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Order Tracking Entry].[Item No_] = [Item].[No_]

Show/hide columns in Order Tracking Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Supplied by Searchnvarchar(160)
4Demanded by Searchnvarchar(160)
5Shipment Date Searchdatetime
6Expected Receipt Date Searchdatetime
7Item No_ Searchnvarchar(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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Order Tracking Entry].[Item No_] = [Item].[No_]
8Quantity Searchdecimal(38,38)
9Level Searchint
10For Type Searchint
11For Subtype Searchint
12For ID Searchnvarchar(40)
13For Batch Name Searchnvarchar(20)
14For Prod_ Order Line Searchint
15For Ref_ No_ Searchint
16From Type Searchint
17From Subtype Searchint
18From ID Searchnvarchar(40)
19From Batch Name Searchnvarchar(20)
20From Prod_ Order Line Searchint
21From Ref_ No_ Searchint
22Starting Date Searchdatetime
23Ending Date Searchdatetime
24Name Searchnvarchar(160)
25Warning Searchtinyint
26$systemId Searchuniqueidentifier
27$systemCreatedAt Searchdatetime
28$systemCreatedBy Searchuniqueidentifier
29$systemModifiedAt Searchdatetime
30$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Order Tracking Entry table

Leave a Reply

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