Tracking 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 IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Item No_ Searchnvarchar(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_]
4Location Code Searchnvarchar(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]
5Quantity (Base) Searchdecimal(38,38)
6Description Searchnvarchar(200)
7Creation Date Searchdatetime
8Source Type Searchint
9Source Subtype Searchint
10Source ID Searchnvarchar(40)
11Source Batch Name Searchnvarchar(20)
12Source Prod_ Order Line Searchint
13Source Ref_ No_ Searchint
14Item Ledger Entry No_ Searchint
15Transfer Item Entry No_ Searchint
16Serial No_ Searchnvarchar(100)
17Positive Searchtinyint
18Qty_ per Unit of Measure Searchdecimal(38,38)
19Qty_ Rounding Precision (Base) Searchdecimal(38,38)
20Appl_-to Item Entry Searchint
21Warranty Date Searchdatetime
22Expiration Date Searchdatetime
23Qty_ to Handle (Base) Searchdecimal(38,38)
24Qty_ to Invoice (Base) Searchdecimal(38,38)
25Quantity Handled (Base) Searchdecimal(38,38)
26Quantity Invoiced (Base) Searchdecimal(38,38)
27Qty_ to Handle Searchdecimal(38,38)
28Qty_ to Invoice Searchdecimal(38,38)
29Buffer Status Searchint
30Buffer Status2 Searchint
31Buffer Value1 Searchdecimal(38,38)
32Buffer Value2 Searchdecimal(38,38)
33Buffer Value3 Searchdecimal(38,38)
34Buffer Value4 Searchdecimal(38,38)
35Buffer Value5 Searchdecimal(38,38)
36New Serial No_ Searchnvarchar(100)
37New Lot No_ Searchnvarchar(100)
38Prohibit Cancellation Searchtinyint
39Lot No_ Searchnvarchar(100)
40Variant Code Searchnvarchar(20)
41Bin Code Searchnvarchar(40)
42Appl_-from Item Entry Searchint
43Correction Searchtinyint
44New Expiration Date Searchdatetime
45Package No_ Searchnvarchar(100)
46New Package No_ Searchnvarchar(100)
47Quantity actual Handled (Base) Searchdecimal(38,38)
48$systemId Searchuniqueidentifier
49$systemCreatedAt Searchdatetime
50$systemCreatedBy Searchuniqueidentifier
51$systemModifiedAt Searchdatetime
52$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Tracking Specification table

Leave a Reply

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