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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Inventory Profile Track Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Profile Track Buffer]
LEFT JOIN
   [User] AS [User]
      ON
         [Inventory Profile Track Buffer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Inventory Profile Track Buffer].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Inventory Profile Track Buffer table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Line No. Primary Key SearchLine No.NormalInteger4Line No_int
2Priority Primary Key SearchPriorityNormalInteger4Priorityint
3Demand Line No. Primary Key SearchDemand Line No.NormalInteger4Demand Line No_int
4Sequence No. Primary Key SearchSequence No.NormalInteger4Sequence No_int
21Source Type SearchSource TypeNormalInteger4Source Typeint
23Source ID SearchSource IDNormalCode20Source IDnvarchar(40)
72Quantity Tracked SearchQuantity TrackedNormalDecimal12Quantity Trackeddecimal(38,38)
73Surplus Type SearchSurplus TypeNormalOption4Surplus Typeint
Available options are:
  • “None”
  • “Forecast”
  • “BlanketOrder”
  • “SafetyStock”
  • “ReorderPoint”
  • “MaxInventory”
  • “FixedOrderQty”
  • “MaxOrder”
  • “MinOrder”
  • “OrderMultiple”
  • “DampenerQty”
  • “PlanningFlexibility”
  • “Undefined”
  • “EmergencyOrder”
75Warning Level SearchWarning LevelNormalOption4Warning Levelint
Available options are:
  • “”
  • “Emergency”
  • “Exception”
  • “Attention”
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
       [Inventory Profile Track Buffer].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Inventory Profile Track Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Profile Track Buffer]
LEFT JOIN
       [User] AS [User]
              ON
                     [Inventory Profile Track 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
       [Inventory Profile Track Buffer].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Inventory Profile Track Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Profile Track Buffer]
LEFT JOIN
       [User] AS [User]
              ON
                     [Inventory Profile Track Buffer].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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