forecast
Primary key (PK)
The table below lists the colum names that are uniquely identified in the data entity.
| Name | Column |
|---|---|
| forecast | snapshot_date, product_id, site_id, region_id, product_group_id, forecast_start_dttm, forecast_end_dttm |
The table below lists the column names supported by the data entity:
| Column | Data type | Required | Description |
|---|---|---|---|
|
snapshot_date |
timestamp |
Yes |
Date up to when data was captured to generate forecasts. |
|
creation_date |
timestamp |
No |
Date when a forecast was created. |
|
company_id2 |
string |
No |
Company ID. |
|
product_id2 |
string |
Yes1 |
Product or product group level for the forecast. |
|
site_id2 |
string |
Yes1 |
Site ID that the forecast is generated for . |
|
source |
string |
No |
Source of the data. |
|
region_id2 |
string |
Yes1 |
Geographical region ID. |
|
product_group_id2 |
string |
Yes1 |
Product group ID. |
|
reg_agg_type |
string |
No |
Type of regional aggregation. |
|
mean |
double |
No |
Mean value of forecast. |
|
p10 |
double |
No |
P10 quantile of forecast. |
|
p20 |
double |
No |
P20 quantile of forecast. |
|
p30 |
double |
No |
P30 quantile of forecast. |
|
p40 |
double |
No |
P40 quantile of forecast. |
|
p50 |
double |
No |
P50 quantile of forecast. |
|
p60 |
double |
No |
P60 quantile of forecast. |
|
p70 |
double |
No |
P70 quantile of forecast. |
|
p80 |
double |
No |
P80 quantile of forecast. |
|
p90 |
double |
No |
P90 quantile of forecast. |
|
forecast_start_dttm |
timestamp |
Yes |
Forecast start date and time. |
|
forecast_end_dttm |
timestamp |
Yes |
Forecast end date and time. |
|
default_price |
double |
No |
Default MSRP of the product that is forecast. |
|
forecast_price |
double |
No |
Price at which the ASIN was forecast to be sold. |
|
num_causals |
int |
No |
Number of casuals applied to forecast. |
|
causal_start |
timestamp |
No |
Start date of causal. |
|
causal_end |
timestamp |
No |
End date of causal. |
|
user_override |
double |
No |
User override of forecast quantity. |
|
user_id |
string |
No |
ID of the user that overrode the forecast. |
|
act_qty |
double |
No |
Actual order quantity sold in the forecast period. |
|
channel_id |
string |
No |
Unique identifier for a specific channel. Corresponds to channel_id in the outbound_order_line dataset. |
|
tpartner_id 2 |
string |
No |
Tpartner ID. |
|
user_override_p10 |
double |
No |
Override value for the P10 quantile of forecast. |
|
user_override_p20 |
double |
No |
Override value for the P20 quantile of forecast. |
|
user_override_p30 |
double |
No |
Override value for the P30 quantile of forecast. |
|
user_override_p40 |
double |
No |
Override value for the P40 quantile of forecast. |
|
user_override_p50 |
double |
No |
Override value for the P50 quantile of forecast. |
|
user_override_p60 |
double |
No |
Override value for the P60 quantile of forecast. |
|
user_override_p70 |
double |
No |
Override value for the P70 quantile of forecast. |
|
user_override_p80 |
double |
No |
Override value for the P80 quantile of forecast. |
|
user_override_p90 |
double |
No |
Override value for the P90 quantile of forecast. |
|
postal_code |
string |
No |
Trading partner's postal code. |
|
tpartner_type |
string |
No |
Trading partner type. |
|
quantity_uom |
string |
No |
Quantity unit of measure. |
|
demand_plan_id |
string |
No |
Demand plan ID. |
|
plan_sequence_id |
string |
No |
Unique identifier or sequence number assigned to each individual demand plan or demand plan version. |
|
plan_type |
string |
No |
Type of forecast or plan. |
|
plan_window_start |
timestamp |
No |
If plan corresponds to a planning bucket or window in application, this field stores the start of the planning window. |
|
plan_window_end |
timestamp |
No |
If plan corresponds to a planning bucket or window in application, this field stores the end of the planning window. |
|
ship_to_site_id |
string |
No |
Site to which an order is shipped. |
|
source_event_id |
string |
No |
ID of the event created in the source system. |
|
source_update_dttm |
timestamp |
No |
Date time stamp of the update made in the source system. |
|
status |
string |
No |
Status defining whether the plan generated in demand planning was created, saved, or published. |
1You must enter a value. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED.
2Foreign key
Foreign key (FK)
The table below lists the columns with the associated foreign key.
| Column | Category | FK/Data entity | FK/Column |
|---|---|---|---|
| company_id | Organization | company | id |
| product_id | Product | product | id |
| region_id | Organization | geography | id |
| product_group_id | Product | product_hierarchy | id |
| site_id | Network | site | id |
| tpartner_id | Organization | trading_partner | id |
| ship_to_site_id | Outbound | outbound_order_line | ship_to_site_id |
