Production Forecast Entry – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables PProduction 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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Production Forecast Name	Demand Forecast Name	Normal	Code	10	Production Forecast Name	nvarchar(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]
2	Entry No.	Entry No.	Normal	Integer	4	Entry No_	int
3	Item No.	Item No.	Normal	Code	20	Item 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_]
4	Forecast Date	Forecast Date	Normal	Date	4	Forecast Date	datetime
5	Forecast Quantity	Forecast Quantity	Normal	Decimal	12	Forecast Quantity	decimal(38,38)
6	Unit of Measure Code	Unit of Measure Code	Normal	Code	10	Unit of Measure Code	nvarchar(20)
7	Qty. per Unit of Measure	Qty. per Unit of Measure	Normal	Decimal	12	Qty_ per Unit of Measure	decimal(38,38)
8	Forecast Quantity (Base)	Forecast Quantity (Base)	Normal	Decimal	12	Forecast Quantity (Base)	decimal(38,38)
10	Location Code	Location Code	Normal	Code	10	Location Code	nvarchar(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]
11	Variant Code	Variant Code	Normal	Code	10	Variant Code	nvarchar(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]
12	Component Forecast	Component Forecast	Normal	Boolean	4	Component Forecast	tinyint
13	Description	Description	Normal	Text	100	Description	nvarchar(200)
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Production Forecast Entry table

Location Unit of Measure

Dynamics 365 BC Table Reference Tables Company Tables PProduction Forecast Entry

Leave a Reply Cancel reply