Inventory Profile Track Buffer

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

Table Type: Company

Table Name: Inventory Profile Track Buffer
Database Table Name: CRONUS UK Ltd_$Inventory Profile Track Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 99000854

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Inventory Profile Track Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Line No_]
   ,[Priority]
   ,[Demand Line No_]
   ,[Sequence No_]
   ,[Source Type]
   ,[Source ID]
   ,[Quantity Tracked]
   ,[Surplus Type]
   ,[Warning Level]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Inventory Profile Track Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Inventory Profile Track Buffer table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Line No_ Primary Key Searchint
3Priority Primary Key Searchint
4Demand Line No_ Primary Key Searchint
5Sequence No_ Primary Key Searchint
6Source Type Searchint
7Source ID Searchnvarchar(40)
8Quantity Tracked Searchdecimal(38,38)
9Surplus Type Searchint
10Warning Level Searchint
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 *