Unplanned Demand

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

Table Type: Company

Table Name: Unplanned Demand
Database Table Name: CRONUS UK Ltd_$Unplanned Demand$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5520

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 Unplanned Demand can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Unplanned Demand$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Demand Type]
   ,[Demand SubType]
   ,[Demand Order No_]
   ,[Demand Line No_]
   ,[Demand Ref_ No_]
   ,[Sell-to Customer No_]
   ,[Description]
   ,[Demand Date]
   ,[Status]
   ,[Item No_]
   ,[Variant Code]
   ,[Location Code]
   ,[Quantity (Base)]
   ,[Level]
   ,[Bin Code]
   ,[Qty_ per Unit of Measure]
   ,[Unit of Measure Code]
   ,[Reserve]
   ,[Needed Qty_ (Base)]
   ,[Special Order]
   ,[Purchasing Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Unplanned Demand$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Unplanned Demand$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unplanned Demand]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Unplanned Demand].[Sell-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Unplanned Demand].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Unplanned Demand].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Unplanned Demand].[Unit of Measure Code] = [Unit of Measure].[Code]

Show/hide columns in Unplanned Demand table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Demand Type Primary Key Searchint
3Demand SubType Primary Key Searchint
4Demand Order No_ Primary Key Searchnvarchar(40)
5Demand Line No_ Primary Key Searchint
6Demand Ref_ No_ Primary Key Searchint
7Sell-to Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Unplanned Demand].[Sell-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Unplanned Demand$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unplanned Demand]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Unplanned Demand].[Sell-to Customer No_] = [Customer].[No_]
8Description Searchnvarchar(200)
9Demand Date Searchdatetime
10Status Searchint
11Item No_ Searchnvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Unplanned Demand].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Unplanned Demand$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unplanned Demand]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Unplanned Demand].[Item No_] = [Item].[No_]
12Variant Code Searchnvarchar(20)
13Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Unplanned Demand].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Unplanned Demand$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unplanned Demand]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Unplanned Demand].[Location Code] = [Location].[Code]
14Quantity (Base) Searchdecimal(38,38)
15Level Searchint
16Bin Code Searchnvarchar(40)
17Qty_ per Unit of Measure Searchdecimal(38,38)
18Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Unplanned Demand].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Unplanned Demand$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unplanned Demand]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Unplanned Demand].[Unit of Measure Code] = [Unit of Measure].[Code]
19Reserve Searchtinyint
20Needed Qty_ (Base) Searchdecimal(38,38)
21Special Order Searchtinyint
22Purchasing Code Searchnvarchar(20)
23$systemId Searchuniqueidentifier
24$systemCreatedAt Searchdatetime
25$systemCreatedBy Searchuniqueidentifier
26$systemModifiedAt Searchdatetime
27$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Unplanned Demand table

Leave a Reply

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