Item Tracing Buffer

Dynamics 365 BC Table ReferenceTablesCompany TablesIItem Tracing Buffer

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

Table Type: Company

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

Table Number: 6520

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Line No_]
   ,[Parent Item Ledger Entry No_]
   ,[Level]
   ,[Item No_]
   ,[Posting Date]
   ,[Entry Type]
   ,[Source Type]
   ,[Source No_]
   ,[Source Name]
   ,[Document No_]
   ,[Description]
   ,[Location Code]
   ,[Quantity]
   ,[Remaining Quantity]
   ,[Open]
   ,[Positive]
   ,[Variant Code]
   ,[Serial No_]
   ,[Lot No_]
   ,[Item Ledger Entry No_]
   ,[Created by]
   ,[Created on]
   ,[Record Identifier]
   ,[Item Description]
   ,[Already Traced]
   ,[Package No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Item Tracing 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 Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Tracing Buffer]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Item Tracing Buffer].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Item Tracing Buffer].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Item Tracing Buffer].[Created By] = [User].[User Name]
LEFT JOIN
   [User] AS [User]
      ON
         [Item Tracing Buffer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Item Tracing Buffer].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Item Tracing Buffer table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Line No. Primary Key SearchLine No.NormalInteger4Line No_int
2Parent Item Ledger Entry No. SearchParent Item Ledger Entry No.NormalInteger4Parent Item Ledger Entry No_int
3Level SearchLevelNormalInteger4Levelint
4Item No. SearchItem No.NormalCode20Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Item Tracing Buffer].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Item Tracing Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Tracing Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Item Tracing Buffer].[Item No_] = [Item].[No_]
5Posting Date SearchPosting DateNormalDate4Posting Datedatetime
6Entry Type SearchEntry TypeNormalOption4Entry Typeint
Available options are:
  • “Purchase”
  • “Sale”
  • “Positive Adjmt.”
  • “Negative Adjmt.”
  • “Transfer”
  • “Consumption”
  • “Output”
  • ” “
  • “Assembly Consumption”
  • “Assembly Output”
7Source Type SearchSource TypeNormalOption4Source Typeint
Available options are:
  • ” “
  • “Customer”
  • “Vendor”
  • “Item”
8Source No. SearchSource No.NormalCode20Source No_nvarchar(40)
9Source Name SearchSource NameNormalText100Source Namenvarchar(200)
10Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
11Description SearchDescriptionNormalText100Descriptionnvarchar(200)
12Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Item Tracing Buffer].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Item Tracing Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Tracing Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Item Tracing Buffer].[Location Code] = [Location].[Code]
13Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
14Remaining Quantity SearchRemaining QuantityNormalDecimal12Remaining Quantitydecimal(38,38)
16Open SearchOpenNormalBoolean4Opentinyint
17Positive SearchPositiveNormalBoolean4Positivetinyint
18Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Item Tracing Buffer].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Item Tracing Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Tracing Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Item Tracing Buffer].[Variant Code] = [Item Variant].[Code]
19Serial No. SearchSerial No.NormalCode50Serial No_nvarchar(100)
20Lot No. SearchLot No.NormalCode50Lot No_nvarchar(100)
21Item Ledger Entry No. SearchItem Ledger Entry No.NormalInteger4Item Ledger Entry No_int
Key to join to the Item Ledger Entry table.

Show/hide example query

SELECT
       [Item Tracing Buffer].[Item Ledger Entry No_]
       ,[Item Ledger Entry].[Entry No_]
FROM
       [CRONUS UK Ltd_$Item Tracing Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Tracing Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
              ON
                     [Item Tracing Buffer].[Item Ledger Entry No_] = [Item Ledger Entry].[Entry No_]
22Created by SearchCreated byNormalCode50Created bynvarchar(100)
Key to join to the User table.

Show/hide example query

SELECT
       [Item Tracing Buffer].[Created by]
       ,[User].[User Name]
FROM
       [CRONUS UK Ltd_$Item Tracing Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Tracing Buffer]
LEFT JOIN
       [User] AS [User]
              ON
                     [Item Tracing Buffer].[Created by] = [User].[User Name]
23Created on SearchCreated onNormalDate4Created ondatetime
24Record Identifier SearchRecord IdentifierNormalRecordID448Record Identifiervarbinary(448)
25Item Description SearchItem DescriptionNormalText100Item Descriptionnvarchar(200)
26Already Traced SearchAlready TracedNormalBoolean4Already Tracedtinyint
6515Package No. SearchPackage No.NormalCode50Package No_nvarchar(100)
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 Buffer].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Item Tracing Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Tracing Buffer]
LEFT JOIN
       [User] AS [User]
              ON
                     [Item Tracing 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 Buffer].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Item Tracing Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Tracing Buffer]
LEFT JOIN
       [User] AS [User]
              ON
                     [Item Tracing Buffer].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Item Tracing Buffer table

Location
Dynamics 365 BC Table ReferenceTablesCompany TablesIItem Tracing Buffer

Leave a Reply

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