Order Tracking Entry – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables OOrder 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 ID	Column Name	Data Type
1	timestamp	timestamp
2	Entry No_	int
3	Supplied by	nvarchar(160)
4	Demanded by	nvarchar(160)
5	Shipment Date	datetime
6	Expected Receipt Date	datetime
7	Item 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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item] ON [Order Tracking Entry].[Item No_] = [Item].[No_]
8	Quantity	decimal(38,38)
9	Level	int
10	For Type	int
11	For Subtype	int
12	For ID	nvarchar(40)
13	For Batch Name	nvarchar(20)
14	For Prod_ Order Line	int
15	For Ref_ No_	int
16	From Type	int
17	From Subtype	int
18	From ID	nvarchar(40)
19	From Batch Name	nvarchar(20)
20	From Prod_ Order Line	int
21	From Ref_ No_	int
22	Starting Date	datetime
23	Ending Date	datetime
24	Name	nvarchar(160)
25	Warning	tinyint
26	$systemId	uniqueidentifier
27	$systemCreatedAt	datetime
28	$systemCreatedBy	uniqueidentifier
29	$systemModifiedAt	datetime
30	$systemModifiedBy	uniqueidentifier