Item Tracking Code

Dynamics 365 BC Table ReferenceTablesCompany TablesIItem Tracking Code

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

Table Type: Company

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

Table Number: 6502

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Code]
   ,[Description]
   ,[Warranty Date Formula]
   ,[Man_ Warranty Date Entry Reqd_]
   ,[Man_ Expir_ Date Entry Reqd_]
   ,[Strict Expiration Posting]
   ,[Use Expiration Dates]
   ,[SN Specific Tracking]
   ,[SN Info_ Inbound Must Exist]
   ,[SN Info_ Outbound Must Exist]
   ,[SN Warehouse Tracking]
   ,[SN Purchase Inbound Tracking]
   ,[SN Purchase Outbound Tracking]
   ,[SN Sales Inbound Tracking]
   ,[SN Sales Outbound Tracking]
   ,[SN Pos_ Adjmt_ Inb_ Tracking]
   ,[SN Pos_ Adjmt_ Outb_ Tracking]
   ,[SN Neg_ Adjmt_ Inb_ Tracking]
   ,[SN Neg_ Adjmt_ Outb_ Tracking]
   ,[SN Transfer Tracking]
   ,[SN Manuf_ Inbound Tracking]
   ,[SN Manuf_ Outbound Tracking]
   ,[SN Assembly Inbound Tracking]
   ,[SN Assembly Outbound Tracking]
   ,[Create SN Info on Posting]
   ,[Lot Specific Tracking]
   ,[Lot Info_ Inbound Must Exist]
   ,[Lot Info_ Outbound Must Exist]
   ,[Lot Warehouse Tracking]
   ,[Lot Purchase Inbound Tracking]
   ,[Lot Purchase Outbound Tracking]
   ,[Lot Sales Inbound Tracking]
   ,[Lot Sales Outbound Tracking]
   ,[Lot Pos_ Adjmt_ Inb_ Tracking]
   ,[Lot Pos_ Adjmt_ Outb_ Tracking]
   ,[Lot Neg_ Adjmt_ Inb_ Tracking]
   ,[Lot Neg_ Adjmt_ Outb_ Tracking]
   ,[Lot Transfer Tracking]
   ,[Lot Manuf_ Inbound Tracking]
   ,[Lot Manuf_ Outbound Tracking]
   ,[Lot Assembly Inbound Tracking]
   ,[Lot Assembly Outbound Tracking]
   ,[Create Lot No_ Info on posting]
   ,[Package Specific Tracking]
   ,[Package Warehouse Tracking]
   ,[Package Info_ Inb_ Must Exist]
   ,[Package Info_ Outb_ Must Exist]
   ,[Package Purchase Inb_ Tracking]
   ,[Package Purch_ Outb_ Tracking]
   ,[Package Sales Inbound Tracking]
   ,[Package Sales Outb_ Tracking]
   ,[Package Pos_ Inb_ Tracking]
   ,[Package Pos_ Outb_ Tracking]
   ,[Package Neg_ Inb_ Tracking]
   ,[Package Neg_ Outb_ Tracking]
   ,[Package Transfer Tracking]
   ,[Package Manuf_ Inb_ Tracking]
   ,[Package Manuf_ Outb_ Tracking]
   ,[Package Assembly Inb_ Tracking]
   ,[Package Assembly Out_ Tracking]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Item Tracking Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Tracking Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Item Tracking Code].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Item Tracking Code].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Item Tracking Code table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code Primary Key SearchCodeNormalCode10Codenvarchar(20)
2Description SearchDescriptionNormalText100Descriptionnvarchar(200)
3Warranty Date Formula SearchWarranty Date FormulaNormalDateFormula32Warranty Date Formulavarchar(32)
5Man. Warranty Date Entry Reqd. SearchMan. Warranty Date Entry Reqd.NormalBoolean4Man_ Warranty Date Entry Reqd_tinyint
6Man. Expir. Date Entry Reqd. SearchMan. Expir. Date Entry Reqd.NormalBoolean4Man_ Expir_ Date Entry Reqd_tinyint
8Strict Expiration Posting SearchStrict Expiration PostingNormalBoolean4Strict Expiration Postingtinyint
9Use Expiration Dates SearchUse Expiration DatesNormalBoolean4Use Expiration Datestinyint
11SN Specific Tracking SearchSN Specific TrackingNormalBoolean4SN Specific Trackingtinyint
13SN Info. Inbound Must Exist SearchSN Info. Inbound Must ExistNormalBoolean4SN Info_ Inbound Must Existtinyint
14SN Info. Outbound Must Exist SearchSN Info. Outbound Must ExistNormalBoolean4SN Info_ Outbound Must Existtinyint
15SN Warehouse Tracking SearchSN Warehouse TrackingNormalBoolean4SN Warehouse Trackingtinyint
21SN Purchase Inbound Tracking SearchSN Purchase Inbound TrackingNormalBoolean4SN Purchase Inbound Trackingtinyint
22SN Purchase Outbound Tracking SearchSN Purchase Outbound TrackingNormalBoolean4SN Purchase Outbound Trackingtinyint
23SN Sales Inbound Tracking SearchSN Sales Inbound TrackingNormalBoolean4SN Sales Inbound Trackingtinyint
24SN Sales Outbound Tracking SearchSN Sales Outbound TrackingNormalBoolean4SN Sales Outbound Trackingtinyint
25SN Pos. Adjmt. Inb. Tracking SearchSN Pos. Adjmt. Inb. TrackingNormalBoolean4SN Pos_ Adjmt_ Inb_ Trackingtinyint
26SN Pos. Adjmt. Outb. Tracking SearchSN Pos. Adjmt. Outb. TrackingNormalBoolean4SN Pos_ Adjmt_ Outb_ Trackingtinyint
27SN Neg. Adjmt. Inb. Tracking SearchSN Neg. Adjmt. Inb. TrackingNormalBoolean4SN Neg_ Adjmt_ Inb_ Trackingtinyint
28SN Neg. Adjmt. Outb. Tracking SearchSN Neg. Adjmt. Outb. TrackingNormalBoolean4SN Neg_ Adjmt_ Outb_ Trackingtinyint
29SN Transfer Tracking SearchSN Transfer TrackingNormalBoolean4SN Transfer Trackingtinyint
30SN Manuf. Inbound Tracking SearchSN Manuf. Inbound TrackingNormalBoolean4SN Manuf_ Inbound Trackingtinyint
31SN Manuf. Outbound Tracking SearchSN Manuf. Outbound TrackingNormalBoolean4SN Manuf_ Outbound Trackingtinyint
32SN Assembly Inbound Tracking SearchSN Assembly Inbound TrackingNormalBoolean4SN Assembly Inbound Trackingtinyint
33SN Assembly Outbound Tracking SearchSN Assembly Outbound TrackingNormalBoolean4SN Assembly Outbound Trackingtinyint
34Create SN Info on Posting SearchCreate SN Info. on postingNormalBoolean4Create SN Info on Postingtinyint
41Lot Specific Tracking SearchLot Specific TrackingNormalBoolean4Lot Specific Trackingtinyint
43Lot Info. Inbound Must Exist SearchLot Info. Inbound Must ExistNormalBoolean4Lot Info_ Inbound Must Existtinyint
44Lot Info. Outbound Must Exist SearchLot Info. Outbound Must ExistNormalBoolean4Lot Info_ Outbound Must Existtinyint
45Lot Warehouse Tracking SearchLot Warehouse TrackingNormalBoolean4Lot Warehouse Trackingtinyint
51Lot Purchase Inbound Tracking SearchLot Purchase Inbound TrackingNormalBoolean4Lot Purchase Inbound Trackingtinyint
52Lot Purchase Outbound Tracking SearchLot Purchase Outbound TrackingNormalBoolean4Lot Purchase Outbound Trackingtinyint
53Lot Sales Inbound Tracking SearchLot Sales Inbound TrackingNormalBoolean4Lot Sales Inbound Trackingtinyint
54Lot Sales Outbound Tracking SearchLot Sales Outbound TrackingNormalBoolean4Lot Sales Outbound Trackingtinyint
55Lot Pos. Adjmt. Inb. Tracking SearchLot Pos. Adjmt. Inb. TrackingNormalBoolean4Lot Pos_ Adjmt_ Inb_ Trackingtinyint
56Lot Pos. Adjmt. Outb. Tracking SearchLot Pos. Adjmt. Outb. TrackingNormalBoolean4Lot Pos_ Adjmt_ Outb_ Trackingtinyint
57Lot Neg. Adjmt. Inb. Tracking SearchLot Neg. Adjmt. Inb. TrackingNormalBoolean4Lot Neg_ Adjmt_ Inb_ Trackingtinyint
58Lot Neg. Adjmt. Outb. Tracking SearchLot Neg. Adjmt. Outb. TrackingNormalBoolean4Lot Neg_ Adjmt_ Outb_ Trackingtinyint
59Lot Transfer Tracking SearchLot Transfer TrackingNormalBoolean4Lot Transfer Trackingtinyint
60Lot Manuf. Inbound Tracking SearchLot Manuf. Inbound TrackingNormalBoolean4Lot Manuf_ Inbound Trackingtinyint
61Lot Manuf. Outbound Tracking SearchLot Manuf. Outbound TrackingNormalBoolean4Lot Manuf_ Outbound Trackingtinyint
62Lot Assembly Inbound Tracking SearchLot Assembly Inbound TrackingNormalBoolean4Lot Assembly Inbound Trackingtinyint
63Lot Assembly Outbound Tracking SearchLot Assembly Outbound TrackingNormalBoolean4Lot Assembly Outbound Trackingtinyint
64Create Lot No. Info on posting SearchCreate Lot No. Info. on postingNormalBoolean4Create Lot No_ Info on postingtinyint
70Package Specific Tracking SearchPackage Specific TrackingNormalBoolean4Package Specific Trackingtinyint
71Package Warehouse Tracking SearchPackage Warehouse TrackingNormalBoolean4Package Warehouse Trackingtinyint
73Package Info. Inb. Must Exist SearchPackage Info. Inb. Must ExistNormalBoolean4Package Info_ Inb_ Must Existtinyint
74Package Info. Outb. Must Exist SearchLot Info. Outb. Must ExistNormalBoolean4Package Info_ Outb_ Must Existtinyint
75Package Purchase Inb. Tracking SearchPackage Purchase Inb. TrackingNormalBoolean4Package Purchase Inb_ Trackingtinyint
76Package Purch. Outb. Tracking SearchPackage Purch. Outb. TrackingNormalBoolean4Package Purch_ Outb_ Trackingtinyint
77Package Sales Inbound Tracking SearchPackage Sales Inbound TrackingNormalBoolean4Package Sales Inbound Trackingtinyint
78Package Sales Outb. Tracking SearchPackage Sales Outb. TrackingNormalBoolean4Package Sales Outb_ Trackingtinyint
79Package Pos. Inb. Tracking SearchPackage Pos. Inb. TrackingNormalBoolean4Package Pos_ Inb_ Trackingtinyint
80Package Pos. Outb. Tracking SearchPackage Pos. Outb. TrackingNormalBoolean4Package Pos_ Outb_ Trackingtinyint
81Package Neg. Inb. Tracking SearchPackage Neg. Inb. TrackingNormalBoolean4Package Neg_ Inb_ Trackingtinyint
82Package Neg. Outb. Tracking SearchPackage Neg. Outb. TrackingNormalBoolean4Package Neg_ Outb_ Trackingtinyint
83Package Transfer Tracking SearchPackage Transfer TrackingNormalBoolean4Package Transfer Trackingtinyint
84Package Manuf. Inb. Tracking SearchPackage Manuf. Inbound TrackingNormalBoolean4Package Manuf_ Inb_ Trackingtinyint
85Package Manuf. Outb. Tracking SearchPackage Manuf. Outbound TrackingNormalBoolean4Package Manuf_ Outb_ Trackingtinyint
86Package Assembly Inb. Tracking SearchPackage Assembly Inbound TrackingNormalBoolean4Package Assembly Inb_ Trackingtinyint
87Package Assembly Out. Tracking SearchPackage Assembly Outbound TrackingNormalBoolean4Package Assembly Out_ Trackingtinyint
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
       [Item Tracking Code].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Item Tracking Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Tracking Code]
LEFT JOIN
       [User] AS [User]
              ON
                     [Item Tracking Code].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Item Tracking Code].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Item Tracking Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Tracking Code]
LEFT JOIN
       [User] AS [User]
              ON
                     [Item Tracking Code].[$systemModifiedBy] = [User].[User Security ID]
Dynamics 365 BC Table ReferenceTablesCompany TablesIItem Tracking Code

Leave a Reply

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