Tracking Specification

Dynamics 365 BC Table ReferenceTablesCompany TablesTTracking 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

   [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_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Tracking Specification].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Tracking Specification].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Tracking Specification].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Tracking Specification].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Tracking Specification].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Tracking Specification table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. SearchEntry No.NormalInteger4Entry No_int
2Item No. Primary Key SearchItem No.NormalCode20Item 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$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
	              ON
	                     [Tracking Specification].[Item No_] = [Item].[No_]
3Location Code SearchLocation CodeNormalCode10Location Codenvarchar(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]
4Quantity (Base) SearchQuantity (Base)NormalDecimal12Quantity (Base)decimal(38,38)
7Description SearchDescriptionNormalText100Descriptionnvarchar(200)
8Creation Date SearchCreation DateNormalDate4Creation Datedatetime
10Source Type SearchSource TypeNormalInteger4Source Typeint
11Source Subtype SearchSource SubtypeNormalOption4Source Subtypeint
Available options are:
  • “0”
  • “1”
  • “2”
  • “3”
  • “4”
  • “5”
  • “6”
  • “7”
  • “8”
  • “9”
  • “10”
12Source ID SearchSource IDNormalCode20Source IDnvarchar(40)
13Source Batch Name SearchSource Batch NameNormalCode10Source Batch Namenvarchar(20)
14Source Prod. Order Line SearchSource Prod. Order LineNormalInteger4Source Prod_ Order Lineint
15Source Ref. No. SearchSource Ref. No.NormalInteger4Source Ref_ No_int
16Item Ledger Entry No. SearchItem Ledger Entry No.NormalInteger4Item Ledger Entry No_int
Key to join to the Item Ledger Entry table.

Show/hide example query

SELECT
	       [Tracking Specification].[Item Ledger Entry No_]
	       ,[Item Ledger Entry].[Entry No_]
	FROM
	       [CRONUS UK Ltd_$Tracking Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tracking Specification]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
	              ON
	                     [Tracking Specification].[Item Ledger Entry No_] = [Item Ledger Entry].[Entry No_]
17Transfer Item Entry No. SearchTransfer Item Entry No.NormalInteger4Transfer Item Entry No_int
Key to join to the Item Ledger Entry table.

Show/hide example query

SELECT
	       [Tracking Specification].[Transfer Item Entry No_]
	       ,[Item Ledger Entry].[Entry No_]
	FROM
	       [CRONUS UK Ltd_$Tracking Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tracking Specification]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
	              ON
	                     [Tracking Specification].[Transfer Item Entry No_] = [Item Ledger Entry].[Entry No_]
24Serial No. SearchSerial No.NormalCode50Serial No_nvarchar(100)
28Positive SearchPositiveNormalBoolean4Positivetinyint
29Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
31Qty. Rounding Precision (Base) SearchQty. Rounding Precision (Base)NormalDecimal12Qty_ Rounding Precision (Base)decimal(38,38)
38Appl.-to Item Entry SearchAppl.-to Item EntryNormalInteger4Appl_-to Item Entryint
40Warranty Date SearchWarranty DateNormalDate4Warranty Datedatetime
41Expiration Date SearchExpiration DateNormalDate4Expiration Datedatetime
50Qty. to Handle (Base) SearchQty. to Handle (Base)NormalDecimal12Qty_ to Handle (Base)decimal(38,38)
51Qty. to Invoice (Base) SearchQty. to Invoice (Base)NormalDecimal12Qty_ to Invoice (Base)decimal(38,38)
52Quantity Handled (Base) SearchQuantity Handled (Base)NormalDecimal12Quantity Handled (Base)decimal(38,38)
53Quantity Invoiced (Base) SearchQuantity Invoiced (Base)NormalDecimal12Quantity Invoiced (Base)decimal(38,38)
60Qty. to Handle SearchQty. to HandleNormalDecimal12Qty_ to Handledecimal(38,38)
61Qty. to Invoice SearchQty. to InvoiceNormalDecimal12Qty_ to Invoicedecimal(38,38)
70Buffer Status SearchBuffer StatusNormalOption4Buffer Statusint
Available options are:
  • ” “
  • “MODIFY”
  • “INSERT”
71Buffer Status2 SearchBuffer Status2NormalOption4Buffer Status2int
Available options are:
  • “”
  • “ExpDate blocked”
72Buffer Value1 SearchBuffer Value1NormalDecimal12Buffer Value1decimal(38,38)
73Buffer Value2 SearchBuffer Value2NormalDecimal12Buffer Value2decimal(38,38)
74Buffer Value3 SearchBuffer Value3NormalDecimal12Buffer Value3decimal(38,38)
75Buffer Value4 SearchBuffer Value4NormalDecimal12Buffer Value4decimal(38,38)
76Buffer Value5 SearchBuffer Value5NormalDecimal12Buffer Value5decimal(38,38)
80New Serial No. SearchNew Serial No.NormalCode50New Serial No_nvarchar(100)
81New Lot No. SearchNew Lot No.NormalCode50New Lot No_nvarchar(100)
900Prohibit Cancellation SearchProhibit CancelationNormalBoolean4Prohibit Cancellationtinyint
5400Lot No. SearchLot No.NormalCode50Lot No_nvarchar(100)
5401Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
	       [Tracking Specification].[Variant Code]
	       ,[Item Variant].[Code]
	FROM
	       [CRONUS UK Ltd_$Tracking Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tracking Specification]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
	              ON
	                     [Tracking Specification].[Variant Code] = [Item Variant].[Code]
5402Bin Code SearchBin CodeNormalCode20Bin Codenvarchar(40)
Key to join to the Bin table.

Show/hide example query

SELECT
	       [Tracking Specification].[Bin Code]
	       ,[Bin].[Code]
	FROM
	       [CRONUS UK Ltd_$Tracking Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tracking Specification]
	LEFT JOIN
	       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
	              ON
	                     [Tracking Specification].[Bin Code] = [Bin].[Code]
5811Appl.-from Item Entry SearchAppl.-from Item EntryNormalInteger4Appl_-from Item Entryint
5817Correction SearchCorrectionNormalBoolean4Correctiontinyint
6505New Expiration Date SearchNew Expiration DateNormalDate4New Expiration Datedatetime
6515Package No. SearchPackage No.NormalCode50Package No_nvarchar(100)
6516New Package No. SearchNew Package No.NormalCode50New Package No_nvarchar(100)
7300Quantity actual Handled (Base) SearchQuantity actual Handled (Base)NormalDecimal12Quantity actual Handled (Base)decimal(38,38)
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
	       [Tracking Specification].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Tracking Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tracking Specification]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Tracking Specification].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Tracking Specification table

Location
Dynamics 365 BC Table ReferenceTablesCompany TablesTTracking Specification

Leave a Reply

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