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
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:
| |||||||
| 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:
| |||||||
| 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 querySELECT [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 |