MS – 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 columns in MS – Sales Forecast Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Primary Key Primary Key Searchnvarchar(20)
3Period Type Searchint
4Show Setup Notification Searchtinyint
5Stockout Warning Horizon Searchint
6Horizon Searchint
7API URI Searchnvarchar(500)
8API Key ID Searchuniqueidentifier
9Timeout (seconds) Searchint
10Variance _ Searchdecimal(38,38)
11Expiration Period (Days) Searchint
12Historical Periods Searchint
13Last Run Completed Searchdatetime
14Limit Searchdecimal(38,38)
15Processing Time Searchdecimal(38,38)
16API Cache Minutes Searchint
17API Cache Expiry Searchdatetime
18Service Pass API Uri ID Searchuniqueidentifier
19Service Pass API Key ID Searchuniqueidentifier
20Timeseries Model Searchint
21$systemId Searchuniqueidentifier
22$systemCreatedAt Searchdatetime
23$systemCreatedBy Searchuniqueidentifier
24$systemModifiedAt Searchdatetime
25$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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