Inventory Page Data – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables IInventory 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

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

Show/hide columns in Inventory Page Data table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Line No_	int
3	Code	nvarchar(40)
4	Period Type	int
5	Period Start	datetime
6	Period End	datetime
7	Period No_	int
8	Level	int
9	Source Line ID	varbinary(448)
10	Item 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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item] ON [Inventory Page Data].[Item No_] = [Item].[No_]
11	Variant Code	nvarchar(20)
12	Location Code	nvarchar(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]
13	Description	nvarchar(200)
14	Availability Date	datetime
15	Type	int
16	Document No_	nvarchar(40)
17	Source	nvarchar(200)
18	Remaining Quantity (Base)	decimal(38,38)
19	Positive	tinyint
20	Gross Requirement	decimal(38,38)
21	Scheduled Receipt	decimal(38,38)
22	Forecast	decimal(38,38)
23	Remaining Forecast	decimal(38,38)
24	Action Message Qty_	decimal(38,38)
25	Action Message	int
26	Source Document ID	varbinary(448)
27	Attached to Line No_	int
28	Ref_ Order No_	nvarchar(40)
29	Projected Inventory	decimal(38,38)
30	Forecasted Projected Inventory	decimal(38,38)
31	Suggested Projected Inventory	decimal(38,38)
32	Reserved Requirement	decimal(38,38)
33	Reserved Receipt	decimal(38,38)
34	$systemId	uniqueidentifier
35	$systemCreatedAt	datetime
36	$systemCreatedBy	uniqueidentifier
37	$systemModifiedAt	datetime
38	$systemModifiedBy	uniqueidentifier