Production Forecast Entry

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

Table Type: Company

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

Table Number: 99000852

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [Production Forecast Name]
   ,[Entry No_]
   ,[Item No_]
   ,[Forecast Date]
   ,[Forecast Quantity]
   ,[Unit of Measure Code]
   ,[Qty_ per Unit of Measure]
   ,[Forecast Quantity (Base)]
   ,[Location Code]
   ,[Variant Code]
   ,[Component Forecast]
   ,[Description]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Production Forecast Entry$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 Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Forecast Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Production Forecast Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Forecast Name]
      ON
         [Production Forecast Entry].[Production Forecast Name] = [Production Forecast Name].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Production Forecast Entry].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Production Forecast Entry].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Production Forecast Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Production Forecast Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Production Forecast Entry table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Production Forecast Name SearchDemand Forecast NameNormalCode10Production Forecast Namenvarchar(20)
Key to join to the Production Forecast Name table.

Show/hide example query

SELECT
	       [Production Forecast Entry].[Production Forecast Name]
	       ,[Production Forecast Name].[Name]
	FROM
	       [CRONUS UK Ltd_$Production Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Forecast Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Production Forecast Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Forecast Name]
	              ON
	                     [Production Forecast Entry].[Production Forecast Name] = [Production Forecast Name].[Name]
2Entry No. SearchEntry No.NormalInteger4Entry No_int
3Item No. Primary Key SearchItem No.NormalCode20Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
	       [Production Forecast Entry].[Item No_]
	       ,[Item].[No_]
	FROM
	       [CRONUS UK Ltd_$Production Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Forecast Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
	              ON
	                     [Production Forecast Entry].[Item No_] = [Item].[No_]
4Forecast Date SearchForecast DateNormalDate4Forecast Datedatetime
5Forecast Quantity SearchForecast QuantityNormalDecimal12Forecast Quantitydecimal(38,38)
6Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
7Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
8Forecast Quantity (Base) SearchForecast Quantity (Base)NormalDecimal12Forecast Quantity (Base)decimal(38,38)
10Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
	       [Production Forecast Entry].[Location Code]
	       ,[Location].[Code]
	FROM
	       [CRONUS UK Ltd_$Production Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Forecast Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
	              ON
	                     [Production Forecast Entry].[Location Code] = [Location].[Code]
11Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
	       [Production Forecast Entry].[Variant Code]
	       ,[Item Variant].[Code]
	FROM
	       [CRONUS UK Ltd_$Production Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Forecast Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
	              ON
	                     [Production Forecast Entry].[Variant Code] = [Item Variant].[Code]
12Component Forecast SearchComponent ForecastNormalBoolean4Component Forecasttinyint
13Description SearchDescriptionNormalText100Descriptionnvarchar(200)
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 Entry].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Production Forecast Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Forecast Entry]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Production Forecast Entry].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Production Forecast Entry table

Leave a Reply

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