Inventory Page Data

Dynamics 365 BC Table ReferenceTablesCompany TablesIInventory Page Data

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

Table Type: Company

Table Name: Inventory Page Data
Database Table Name: CRONUS UK Ltd_$Inventory Page Data$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5531

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Inventory Page Data$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Code]
   ,[Line No_]
   ,[Period Type]
   ,[Period Start]
   ,[Period End]
   ,[Period No_]
   ,[Level]
   ,[Source Line ID]
   ,[Item No_]
   ,[Variant Code]
   ,[Location Code]
   ,[Description]
   ,[Availability Date]
   ,[Type]
   ,[Document No_]
   ,[Source]
   ,[Remaining Quantity (Base)]
   ,[Positive]
   ,[Gross Requirement]
   ,[Scheduled Receipt]
   ,[Forecast]
   ,[Remaining Forecast]
   ,[Action Message Qty_]
   ,[Action Message]
   ,[Source Document ID]
   ,[Attached to Line No_]
   ,[Ref_ Order No_]
   ,[Projected Inventory]
   ,[Forecasted Projected Inventory]
   ,[Suggested Projected Inventory]
   ,[Reserved Requirement]
   ,[Reserved Receipt]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide columns in Inventory Page Data table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code SearchCodeNormalCode20Codenvarchar(40)
2Line No. SearchLine No.NormalInteger4Line No_int
3Period Type Primary Key SearchPeriod TypeNormalOption4Period Typeint
Available options are:
  • “Day”
  • “Week”
  • “Month”
  • “Quarter”
  • “Year”
4Period Start SearchPeriod StartNormalDate4Period Startdatetime
5Period End SearchPeriod EndNormalDate4Period Enddatetime
6Period No. SearchPeriod No.NormalInteger4Period No_int
7Level SearchLevelNormalInteger4Levelint
9Source Line ID SearchSource Line IDNormalRecordID448Source Line IDvarbinary(448)
10Item No. SearchItem No.NormalCode20Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
	       [Inventory Page Data].[Item No_]
	       ,[Item].[No_]
	FROM
	       [CRONUS UK Ltd_$Inventory Page Data$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Page Data]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
	              ON
	                     [Inventory Page Data].[Item No_] = [Item].[No_]
11Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
	       [Inventory Page Data].[Variant Code]
	       ,[Item Variant].[Code]
	FROM
	       [CRONUS UK Ltd_$Inventory Page Data$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Page Data]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
	              ON
	                     [Inventory Page Data].[Variant Code] = [Item Variant].[Code]
12Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
	       [Inventory Page Data].[Location Code]
	       ,[Location].[Code]
	FROM
	       [CRONUS UK Ltd_$Inventory Page Data$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Page Data]
	LEFT JOIN
	       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
	              ON
	                     [Inventory Page Data].[Location Code] = [Location].[Code]
13Description SearchDescriptionNormalText100Descriptionnvarchar(200)
14Availability Date SearchAvailability DateNormalDate4Availability Datedatetime
15Type SearchTypeNormalOption4Typeint
Available options are:
  • ” “
  • “Purchase”
  • “Sale”
  • “Purch. Return”
  • “Sales Return”
  • “Transfer”
  • “Component”
  • “Production”
  • “Service”
  • “Job”
  • “Forecast”
  • “Blanket Sales Order”
  • “Plan”
  • “Plan Revert”
  • “Assembly Order”
  • “Assembly Component”
16Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
19Source SearchSourceNormalText100Sourcenvarchar(200)
20Remaining Quantity (Base) SearchRemaining Quantity (Base)NormalDecimal12Remaining Quantity (Base)decimal(38,38)
21Positive SearchPositiveNormalBoolean4Positivetinyint
22Gross Requirement SearchGross RequirementNormalDecimal12Gross Requirementdecimal(38,38)
23Scheduled Receipt SearchScheduled ReceiptNormalDecimal12Scheduled Receiptdecimal(38,38)
24Forecast SearchForecastNormalDecimal12Forecastdecimal(38,38)
25Remaining Forecast SearchRemaining ForecastNormalDecimal12Remaining Forecastdecimal(38,38)
26Action Message Qty. SearchAction Message Qty.NormalDecimal12Action Message Qty_decimal(38,38)
29Action Message SearchAction MessageNormalOption4Action Messageint
Available options are:
  • ” “
  • “New”
  • “Change Qty.”
  • “Reschedule”
  • “Resched. & Chg. Qty.”
  • “Cancel”
30Source Document ID SearchSource Document IDNormalRecordID448Source Document IDvarbinary(448)
31Attached to Line No. SearchAttached to Line No.NormalInteger4Attached to Line No_int
34Ref. Order No. SearchRef. Order No.NormalCode20Ref_ Order No_nvarchar(40)
36Projected Inventory SearchProjected InventoryNormalDecimal12Projected Inventorydecimal(38,38)
37Forecasted Projected Inventory SearchForecasted Projected InventoryNormalDecimal12Forecasted Projected Inventorydecimal(38,38)
38Suggested Projected Inventory SearchSuggested Projected InventoryNormalDecimal12Suggested Projected Inventorydecimal(38,38)
39Reserved Requirement SearchReserved RequirementNormalDecimal12Reserved Requirementdecimal(38,38)
40Reserved Receipt SearchReserved ReceiptNormalDecimal12Reserved Receiptdecimal(38,38)
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 Page Data].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Inventory Page Data$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Page Data]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Inventory Page Data].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Inventory Page Data table

Location
Dynamics 365 BC Table ReferenceTablesCompany TablesIInventory Page Data

Leave a Reply

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