Tracking Specification – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables TTracking Specification

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

Table Type: Company

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

Table Number: 336

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Tracking Specification$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Entry No_]
   ,[Item No_]
   ,[Location Code]
   ,[Quantity (Base)]
   ,[Description]
   ,[Creation Date]
   ,[Source Type]
   ,[Source Subtype]
   ,[Source ID]
   ,[Source Batch Name]
   ,[Source Prod_ Order Line]
   ,[Source Ref_ No_]
   ,[Item Ledger Entry No_]
   ,[Transfer Item Entry No_]
   ,[Serial No_]
   ,[Positive]
   ,[Qty_ per Unit of Measure]
   ,[Qty_ Rounding Precision (Base)]
   ,[Appl_-to Item Entry]
   ,[Warranty Date]
   ,[Expiration Date]
   ,[Qty_ to Handle (Base)]
   ,[Qty_ to Invoice (Base)]
   ,[Quantity Handled (Base)]
   ,[Quantity Invoiced (Base)]
   ,[Qty_ to Handle]
   ,[Qty_ to Invoice]
   ,[Buffer Status]
   ,[Buffer Status2]
   ,[Buffer Value1]
   ,[Buffer Value2]
   ,[Buffer Value3]
   ,[Buffer Value4]
   ,[Buffer Value5]
   ,[New Serial No_]
   ,[New Lot No_]
   ,[Prohibit Cancellation]
   ,[Lot No_]
   ,[Variant Code]
   ,[Bin Code]
   ,[Appl_-from Item Entry]
   ,[Correction]
   ,[New Expiration Date]
   ,[Package No_]
   ,[New Package No_]
   ,[Quantity actual Handled (Base)]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Tracking Specification$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Tracking Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tracking Specification]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Tracking Specification].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Tracking Specification].[Location Code] = [Location].[Code]

Show/hide columns in Tracking Specification table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Entry No_	int
3	Item No_	nvarchar(40)
	Key to join to the Item table. Show/hide example query SELECT [Tracking Specification].[Item No_] ,[Item].[No_] FROM [CRONUS UK Ltd_$Tracking Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tracking Specification] LEFT JOIN [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item] ON [Tracking Specification].[Item No_] = [Item].[No_]
4	Location Code	nvarchar(20)
	Key to join to the Location table. Show/hide example query SELECT [Tracking Specification].[Location Code] ,[Location].[Code] FROM [CRONUS UK Ltd_$Tracking Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tracking Specification] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Tracking Specification].[Location Code] = [Location].[Code]
5	Quantity (Base)	decimal(38,38)
6	Description	nvarchar(200)
7	Creation Date	datetime
8	Source Type	int
9	Source Subtype	int
10	Source ID	nvarchar(40)
11	Source Batch Name	nvarchar(20)
12	Source Prod_ Order Line	int
13	Source Ref_ No_	int
14	Item Ledger Entry No_	int
15	Transfer Item Entry No_	int
16	Serial No_	nvarchar(100)
17	Positive	tinyint
18	Qty_ per Unit of Measure	decimal(38,38)
19	Qty_ Rounding Precision (Base)	decimal(38,38)
20	Appl_-to Item Entry	int
21	Warranty Date	datetime
22	Expiration Date	datetime
23	Qty_ to Handle (Base)	decimal(38,38)
24	Qty_ to Invoice (Base)	decimal(38,38)
25	Quantity Handled (Base)	decimal(38,38)
26	Quantity Invoiced (Base)	decimal(38,38)
27	Qty_ to Handle	decimal(38,38)
28	Qty_ to Invoice	decimal(38,38)
29	Buffer Status	int
30	Buffer Status2	int
31	Buffer Value1	decimal(38,38)
32	Buffer Value2	decimal(38,38)
33	Buffer Value3	decimal(38,38)
34	Buffer Value4	decimal(38,38)
35	Buffer Value5	decimal(38,38)
36	New Serial No_	nvarchar(100)
37	New Lot No_	nvarchar(100)
38	Prohibit Cancellation	tinyint
39	Lot No_	nvarchar(100)
40	Variant Code	nvarchar(20)
41	Bin Code	nvarchar(40)
42	Appl_-from Item Entry	int
43	Correction	tinyint
44	New Expiration Date	datetime
45	Package No_	nvarchar(100)
46	New Package No_	nvarchar(100)
47	Quantity actual Handled (Base)	decimal(38,38)
48	$systemId	uniqueidentifier
49	$systemCreatedAt	datetime
50	$systemCreatedBy	uniqueidentifier
51	$systemModifiedAt	datetime
52	$systemModifiedBy	uniqueidentifier