Production Forecast Name

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

Table Type: Company

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

Table Number: 99000851

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 Production Forecast Name can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Production Forecast Name$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [Name]
   ,[Description]
   ,[View By]
   ,[Forecast Type]
   ,[Location Filter]
   ,[Variant Filter]
   ,[Item Filter]
   ,[Forecast By Locations]
   ,[Forecast By Variants]
   ,[Quantity Type]
   ,[Date Filter]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Production Forecast Name$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Production Forecast Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Forecast Name]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Production Forecast Name].[Location Filter] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Production Forecast Name].[Variant Filter] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
      ON
         [Production Forecast Name].[Item Filter] = [Item].[No_]
LEFT JOIN
   [User] AS [User]
      ON
         [Production Forecast Name].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Production Forecast Name].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Production Forecast Name table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Name Primary Key SearchNameNormalCode10Namenvarchar(20)
2Description SearchDescriptionNormalText100Descriptionnvarchar(200)
3View By SearchView ByNormalOption4View Byint
Available options are:
  • “Day”
  • “Week”
  • “Month”
  • “Quarter”
  • “Year”
  • “Accounting Period”
4Forecast Type SearchForecast TypeNormalOption4Forecast Typeint
Available options are:
  • “Sales Item”
  • “Component”
  • “Both”
5Location Filter SearchLocation FilterNormalBLOB8Location Filterimage
Key to join to the Location table.

Show/hide example query

SELECT
       [Production Forecast Name].[Location Filter]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Production Forecast Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Forecast Name]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Production Forecast Name].[Location Filter] = [Location].[Code]
6Variant Filter SearchVariant FilterNormalBLOB8Variant Filterimage
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Production Forecast Name].[Variant Filter]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Production Forecast Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Forecast Name]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Production Forecast Name].[Variant Filter] = [Item Variant].[Code]
7Item Filter SearchItem FilterNormalBLOB8Item Filterimage
Key to join to the Item table.

Show/hide example query

SELECT
       [Production Forecast Name].[Item Filter]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Production Forecast Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Forecast Name]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Production Forecast Name].[Item Filter] = [Item].[No_]
8Forecast By Locations SearchForecast by LocationsNormalBoolean4Forecast By Locationstinyint
9Forecast By Variants SearchForecast by VariantsNormalBoolean4Forecast By Variantstinyint
10Quantity Type SearchQuantity TypeNormalOption4Quantity Typeint
Available options are:
  • “Net Change”
  • “Balance at Date”
11Date Filter SearchDate FilterNormalText1024Date Filternvarchar(2048)
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
       [Production Forecast Name].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Production Forecast Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Forecast Name]
LEFT JOIN
       [User] AS [User]
              ON
                     [Production Forecast Name].[$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
       [Production Forecast Name].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Production Forecast Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Forecast Name]
LEFT JOIN
       [User] AS [User]
              ON
                     [Production Forecast Name].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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