Item 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
   [timestamp]
   ,[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_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Item Tracing Buffer].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Item Tracing Buffer].[Location Code] = [Location].[Code]

Show/hide columns in Item Tracing Buffer table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Line No_ Primary Key Searchint
3Parent Item Ledger Entry No_ Searchint
4Level Searchint
5Item No_ Searchnvarchar(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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Item Tracing Buffer].[Item No_] = [Item].[No_]
6Posting Date Searchdatetime
7Entry Type Searchint
8Source Type Searchint
9Source No_ Searchnvarchar(40)
10Source Name Searchnvarchar(200)
11Document No_ Searchnvarchar(40)
12Description Searchnvarchar(200)
13Location Code Searchnvarchar(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]
14Quantity Searchdecimal(38,38)
15Remaining Quantity Searchdecimal(38,38)
16Open Searchtinyint
17Positive Searchtinyint
18Variant Code Searchnvarchar(20)
19Serial No_ Searchnvarchar(100)
20Lot No_ Searchnvarchar(100)
21Item Ledger Entry No_ Searchint
22Created by Searchnvarchar(100)
23Created on Searchdatetime
24Record Identifier Searchvarbinary(448)
25Item Description Searchnvarchar(200)
26Already Traced Searchtinyint
27Package No_ Searchnvarchar(100)
28$systemId Searchuniqueidentifier
29$systemCreatedAt Searchdatetime
30$systemCreatedBy Searchuniqueidentifier
31$systemModifiedAt Searchdatetime
32$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Item Tracing Buffer table

Leave a Reply

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