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

   [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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Entry No.	Entry No.	Normal	Integer	4	Entry No_	int
2	Supplied by	Supplied by	Normal	Text	80	Supplied by	nvarchar(160)
3	Demanded by	Demanded by	Normal	Text	80	Demanded by	nvarchar(160)
8	Shipment Date	Shipment Date	Normal	Date	4	Shipment Date	datetime
9	Expected Receipt Date	Expected Receipt Date	Normal	Date	4	Expected Receipt Date	datetime
11	Item No.	Item No.	Normal	Code	20	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$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] ON [Order Tracking Entry].[Item No_] = [Item].[No_]
13	Quantity	Quantity	Normal	Decimal	12	Quantity	decimal(38,38)
14	Level	Level	Normal	Integer	4	Level	int
20	For Type	For Type	Normal	Integer	4	For Type	int
21	For Subtype	For Subtype	Normal	Integer	4	For Subtype	int
22	For ID	For ID	Normal	Code	20	For ID	nvarchar(40)
23	For Batch Name	For Batch Name	Normal	Code	10	For Batch Name	nvarchar(20)
24	For Prod. Order Line	For Prod. Order Line	Normal	Integer	4	For Prod_ Order Line	int
25	For Ref. No.	For Ref. No.	Normal	Integer	4	For Ref_ No_	int
26	From Type	From Type	Normal	Integer	4	From Type	int
27	From Subtype	From Subtype	Normal	Integer	4	From Subtype	int
28	From ID	From ID	Normal	Code	20	From ID	nvarchar(40)
29	From Batch Name	From Batch Name	Normal	Code	10	From Batch Name	nvarchar(20)
30	From Prod. Order Line	From Prod. Order Line	Normal	Integer	4	From Prod_ Order Line	int
31	From Ref. No.	From Ref. No.	Normal	Integer	4	From Ref_ No_	int
40	Starting Date	Starting Date	Normal	Date	4	Starting Date	datetime
41	Ending Date	Ending Date	Normal	Date	4	Ending Date	datetime
	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]
42	Name	Name	Normal	Text	80	Name	nvarchar(160)
43	Warning	Warning	Normal	Boolean	4	Warning	tinyint
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier