Unplanned Demand

Dynamics 365 BC Table ReferenceTablesCompany TablesUUnplanned 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

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

Show/hide columns in Unplanned Demand table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Demand Type Primary Key SearchDemand TypeNormalOption4Demand Typeint
Available options are:
  • ” “
  • “Production”
  • “Sales”
  • “Service”
  • “Job”
  • “Assembly”
2Demand SubType Primary Key SearchDemand SubTypeNormalOption4Demand SubTypeint
Available options are:
  • “0”
  • “1”
  • “2”
  • “3”
  • “4”
  • “5”
  • “6”
  • “7”
  • “8”
  • “9”
4Demand Order No. Primary Key SearchDemand Order No.NormalCode20Demand Order No_nvarchar(40)
5Demand Line No. Primary Key SearchDemand Line No.NormalInteger4Demand Line No_int
6Demand Ref. No. Primary Key SearchDemand Ref. No.NormalInteger4Demand Ref_ No_int
7Sell-to Customer No. SearchSell-to Customer No.NormalCode20Sell-to Customer No_nvarchar(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 SearchDescriptionNormalText100Descriptionnvarchar(200)
9Demand Date SearchDemand DateNormalDate4Demand Datedatetime
10Status SearchStatusNormalOption4Statusint
Available options are:
  • “0”
  • “1”
  • “2”
  • “3”
  • “4”
  • “5”
  • “6”
  • “7”
  • “8”
  • “9”
  • “10”
13Item No. SearchItem No.NormalCode20Item No_nvarchar(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$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Unplanned Demand].[Item No_] = [Item].[No_]
14Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Unplanned Demand].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Unplanned Demand$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unplanned Demand]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Unplanned Demand].[Variant Code] = [Item Variant].[Code]
15Location Code SearchLocation CodeNormalCode10Location Codenvarchar(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]
16Quantity (Base) SearchQuantity (Base)NormalDecimal12Quantity (Base)decimal(38,38)
17Level SearchLevelNormalInteger4Levelint
18Bin Code SearchBin CodeNormalCode20Bin Codenvarchar(40)
Key to join to the Bin table.

Show/hide example query

SELECT
       [Unplanned Demand].[Bin Code]
       ,[Bin].[Code]
FROM
       [CRONUS UK Ltd_$Unplanned Demand$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unplanned Demand]
LEFT JOIN
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
              ON
                     [Unplanned Demand].[Bin Code] = [Bin].[Code]
19Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
20Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
21Reserve SearchReserveNormalBoolean4Reservetinyint
22Needed Qty. (Base) SearchNeeded Qty. (Base)NormalDecimal12Needed Qty_ (Base)decimal(38,38)
23Special Order SearchSpecial OrderNormalBoolean4Special Ordertinyint
24Purchasing Code SearchPurchasing CodeNormalCode10Purchasing Codenvarchar(20)
Key to join to the Purchasing table.

Show/hide example query

SELECT
       [Unplanned Demand].[Purchasing Code]
       ,[Purchasing].[Code]
FROM
       [CRONUS UK Ltd_$Unplanned Demand$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unplanned Demand]
LEFT JOIN
       [CRONUS UK Ltd_$Purchasing$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchasing]
              ON
                     [Unplanned Demand].[Purchasing Code] = [Purchasing].[Code]
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
       [Unplanned Demand].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Unplanned Demand$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unplanned Demand]
LEFT JOIN
       [User] AS [User]
              ON
                     [Unplanned Demand].[$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
       [Unplanned Demand].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Unplanned Demand$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unplanned Demand]
LEFT JOIN
       [User] AS [User]
              ON
                     [Unplanned Demand].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Unplanned Demand table

LocationUnit of Measure
Dynamics 365 BC Table ReferenceTablesCompany TablesUUnplanned Demand

Leave a Reply

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