Item Tracing History Buffer

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

Table Type: Company

Table Name: Item Tracing History Buffer
Database Table Name: CRONUS UK Ltd_$Item Tracing History Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 6521

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 Tracing History Buffer can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Item Tracing History Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[Level]
   ,[Serial No_ Filter]
   ,[Lot No_ Filter]
   ,[Item No_ Filter]
   ,[Variant Filter]
   ,[Trace Method]
   ,[Show Components]
   ,[Package No_ Filter]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Item Tracing History Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Item Tracing History Buffer table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Level Primary Key Searchint
4Serial No_ Filter Searchnvarchar(500)
5Lot No_ Filter Searchnvarchar(500)
6Item No_ Filter Searchnvarchar(500)
7Variant Filter Searchnvarchar(500)
8Trace Method Searchint
9Show Components Searchint
10Package No_ Filter Searchnvarchar(500)
11$systemId Searchuniqueidentifier
12$systemCreatedAt Searchdatetime
13$systemCreatedBy Searchuniqueidentifier
14$systemModifiedAt Searchdatetime
15$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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