Item 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
   [timestamp]
   ,[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 columns in Item Tracking Code table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(20)
3Description Searchnvarchar(200)
4Warranty Date Formula Searchvarchar(32)
5Man_ Warranty Date Entry Reqd_ Searchtinyint
6Man_ Expir_ Date Entry Reqd_ Searchtinyint
7Strict Expiration Posting Searchtinyint
8Use Expiration Dates Searchtinyint
9SN Specific Tracking Searchtinyint
10SN Info_ Inbound Must Exist Searchtinyint
11SN Info_ Outbound Must Exist Searchtinyint
12SN Warehouse Tracking Searchtinyint
13SN Purchase Inbound Tracking Searchtinyint
14SN Purchase Outbound Tracking Searchtinyint
15SN Sales Inbound Tracking Searchtinyint
16SN Sales Outbound Tracking Searchtinyint
17SN Pos_ Adjmt_ Inb_ Tracking Searchtinyint
18SN Pos_ Adjmt_ Outb_ Tracking Searchtinyint
19SN Neg_ Adjmt_ Inb_ Tracking Searchtinyint
20SN Neg_ Adjmt_ Outb_ Tracking Searchtinyint
21SN Transfer Tracking Searchtinyint
22SN Manuf_ Inbound Tracking Searchtinyint
23SN Manuf_ Outbound Tracking Searchtinyint
24SN Assembly Inbound Tracking Searchtinyint
25SN Assembly Outbound Tracking Searchtinyint
26Create SN Info on Posting Searchtinyint
27Lot Specific Tracking Searchtinyint
28Lot Info_ Inbound Must Exist Searchtinyint
29Lot Info_ Outbound Must Exist Searchtinyint
30Lot Warehouse Tracking Searchtinyint
31Lot Purchase Inbound Tracking Searchtinyint
32Lot Purchase Outbound Tracking Searchtinyint
33Lot Sales Inbound Tracking Searchtinyint
34Lot Sales Outbound Tracking Searchtinyint
35Lot Pos_ Adjmt_ Inb_ Tracking Searchtinyint
36Lot Pos_ Adjmt_ Outb_ Tracking Searchtinyint
37Lot Neg_ Adjmt_ Inb_ Tracking Searchtinyint
38Lot Neg_ Adjmt_ Outb_ Tracking Searchtinyint
39Lot Transfer Tracking Searchtinyint
40Lot Manuf_ Inbound Tracking Searchtinyint
41Lot Manuf_ Outbound Tracking Searchtinyint
42Lot Assembly Inbound Tracking Searchtinyint
43Lot Assembly Outbound Tracking Searchtinyint
44Create Lot No_ Info on posting Searchtinyint
45Package Specific Tracking Searchtinyint
46Package Warehouse Tracking Searchtinyint
47Package Info_ Inb_ Must Exist Searchtinyint
48Package Info_ Outb_ Must Exist Searchtinyint
49Package Purchase Inb_ Tracking Searchtinyint
50Package Purch_ Outb_ Tracking Searchtinyint
51Package Sales Inbound Tracking Searchtinyint
52Package Sales Outb_ Tracking Searchtinyint
53Package Pos_ Inb_ Tracking Searchtinyint
54Package Pos_ Outb_ Tracking Searchtinyint
55Package Neg_ Inb_ Tracking Searchtinyint
56Package Neg_ Outb_ Tracking Searchtinyint
57Package Transfer Tracking Searchtinyint
58Package Manuf_ Inb_ Tracking Searchtinyint
59Package Manuf_ Outb_ Tracking Searchtinyint
60Package Assembly Inb_ Tracking Searchtinyint
61Package Assembly Out_ Tracking Searchtinyint
62$systemId Searchuniqueidentifier
63$systemCreatedAt Searchdatetime
64$systemCreatedBy Searchuniqueidentifier
65$systemModifiedAt Searchdatetime
66$systemModifiedBy Searchuniqueidentifier

Show/hide tables related to Item Tracking Code table

Leave a Reply

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