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
   [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 an example select of all columns including those from all joined tables

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

Show/hide columns in Item Tracing History Buffer table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
2Level Primary Key SearchLevelNormalInteger4Levelint
10Serial No. Filter SearchSerial No. FilterNormalCode250Serial No_ Filternvarchar(500)
11Lot No. Filter SearchLot No. FilterNormalCode250Lot No_ Filternvarchar(500)
12Item No. Filter SearchItem No. FilterNormalCode250Item No_ Filternvarchar(500)
Key to join to the Item table.

Show/hide example query

SELECT
       [Item Tracing History Buffer].[Item No_ Filter]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Item Tracing History Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Tracing History Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Item Tracing History Buffer].[Item No_ Filter] = [Item].[No_]
13Variant Filter SearchVariant FilterNormalCode250Variant Filternvarchar(500)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Item Tracing History Buffer].[Variant Filter]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Item Tracing History Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Tracing History Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Item Tracing History Buffer].[Variant Filter] = [Item Variant].[Code]
14Trace Method SearchTrace MethodNormalOption4Trace Methodint
Available options are:
  • “Origin->Usage”
  • “Usage->Origin”
15Show Components SearchShow ComponentsNormalOption4Show Componentsint
Available options are:
  • “No”
  • “Item-tracked only”
  • “All”
16Package No. Filter SearchPackage No. FilterNormalCode250Package No_ Filternvarchar(500)
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 Tracing History Buffer].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Item Tracing History Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Tracing History Buffer]
LEFT JOIN
       [User] AS [User]
              ON
                     [Item Tracing History Buffer].[$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 Tracing History Buffer].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Item Tracing History Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Tracing History Buffer]
LEFT JOIN
       [User] AS [User]
              ON
                     [Item Tracing History Buffer].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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