Inventory 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 IDColumn NameData Type
1timestamp Searchtimestamp
2Line No_ Primary Key Searchint
3Code Searchnvarchar(40)
4Period Type Searchint
5Period Start Searchdatetime
6Period End Searchdatetime
7Period No_ Searchint
8Level Searchint
9Source Line ID Searchvarbinary(448)
10Item No_ Searchnvarchar(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_]
11Variant Code Searchnvarchar(20)
12Location Code Searchnvarchar(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 Searchnvarchar(200)
14Availability Date Searchdatetime
15Type Searchint
16Document No_ Searchnvarchar(40)
17Source Searchnvarchar(200)
18Remaining Quantity (Base) Searchdecimal(38,38)
19Positive Searchtinyint
20Gross Requirement Searchdecimal(38,38)
21Scheduled Receipt Searchdecimal(38,38)
22Forecast Searchdecimal(38,38)
23Remaining Forecast Searchdecimal(38,38)
24Action Message Qty_ Searchdecimal(38,38)
25Action Message Searchint
26Source Document ID Searchvarbinary(448)
27Attached to Line No_ Searchint
28Ref_ Order No_ Searchnvarchar(40)
29Projected Inventory Searchdecimal(38,38)
30Forecasted Projected Inventory Searchdecimal(38,38)
31Suggested Projected Inventory Searchdecimal(38,38)
32Reserved Requirement Searchdecimal(38,38)
33Reserved Receipt Searchdecimal(38,38)
34$systemId Searchuniqueidentifier
35$systemCreatedAt Searchdatetime
36$systemCreatedBy Searchuniqueidentifier
37$systemModifiedAt Searchdatetime
38$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Inventory Page Data table

Leave a Reply

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