MS – Sales Forecast Setup – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables MMS – Sales Forecast Setup

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

Table Type: Company

Table Name: MS – Sales Forecast Setup
Database Table Name: CRONUS UK Ltd_$MS – Sales Forecast Setup$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a

Table Number: 1853

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 MS – Sales Forecast Setup can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$MS - Sales Forecast Setup$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a]

Show/hide an example select of all columns by name

SELECT



FROM

   [CRONUS UK Ltd_$MS - Sales Forecast Setup$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$MS - Sales Forecast Setup$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [MS - Sales Forecast Setup]
LEFT JOIN
   [User] AS [User]
      ON
         [MS - Sales Forecast Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [MS - Sales Forecast Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in MS – Sales Forecast Setup table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Primary Key	Primary Key	Normal	Code	10	Primary Key	nvarchar(20)
2	Period Type	Period Type	Normal	Option	4	Period Type	int
	Available options are: “Day” “Week” “Month” “Quarter” “Year”
3	Show Setup Notification	Show Setup Notification	Normal	Boolean	4	Show Setup Notification	tinyint
4	Stockout Warning Horizon	Stockout Warning Horizon	Normal	Integer	4	Stockout Warning Horizon	int
5	Horizon	Horizon	Normal	Integer	4	Horizon	int
6	API URI	API URI	Normal	Text	250	API URI	nvarchar(500)
7	API Key ID	API Key ID	Normal	GUID	16	API Key ID	uniqueidentifier
8	Timeout (seconds)	Timeout (seconds)	Normal	Integer	4	Timeout (seconds)	int
9	Variance %	Variance %	Normal	Decimal	12	Variance _	decimal(38,38)
10	Expiration Period (Days)	Expiration Period (Days)	Normal	Integer	4	Expiration Period (Days)	int
11	Historical Periods	Historical Periods	Normal	Integer	4	Historical Periods	int
12	Last Run Completed	Last Run Completed	Normal	DateTime	8	Last Run Completed	datetime
13	Limit	Limit	Normal	Decimal	12	Limit	decimal(38,38)
14	Processing Time	Processing Time	Normal	Decimal	12	Processing Time	decimal(38,38)
15	API Cache Minutes	API Cache Minutes	Normal	Integer	4	API Cache Minutes	int
16	API Cache Expiry	API Cache Expiry	Normal	DateTime	8	API Cache Expiry	datetime
17	Service Pass API Uri ID	Service Pass API Uri ID	Normal	GUID	16	Service Pass API Uri ID	uniqueidentifier
18	Service Pass API Key ID	Service Pass API Key ID	Normal	GUID	16	Service Pass API Key ID	uniqueidentifier
19	Timeseries Model	Timeseries Model	Normal	Option	4	Timeseries Model	int
	Available options are: “ARIMA” “ETS” “STL” “ETS+ARIMA” “ETS+STL” “ALL” “TBATS”
20	Enabled	Enabled	Normal	Boolean	4	Enabled	tinyint
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 [MS - Sales Forecast Setup].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$MS - Sales Forecast Setup$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [MS - Sales Forecast Setup] LEFT JOIN [User] AS [User] ON [MS - Sales Forecast Setup].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [MS - Sales Forecast Setup].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$MS - Sales Forecast Setup$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [MS - Sales Forecast Setup] LEFT JOIN [User] AS [User] ON [MS - Sales Forecast Setup].[$systemModifiedBy] = [User].[User Security ID]