# forecast


**Primary key (PK)**

The table below lists the colum names that are uniquely identified in the data entity.


| Name | Column | 
| --- | --- | 
| forecast | snapshot\$1date, product\$1id, site\$1id, region\$1id, product\$1group\$1id, forecast\$1start\$1dttm, forecast\$1end\$1dttm | 

The table below lists the column names supported by the data entity:


| Column | Data type | Required | Description | 
| --- | --- | --- | --- | 
|  snapshot\$1date  |  timestamp  |  Yes  |  Date up to when data was captured to generate forecasts.  | 
|  creation\$1date  |  timestamp  |  No  |  Date when a forecast was created.  | 
|  company\$1id2  |  string  |  No  |  Company ID.  | 
|  product\$1id2  |  string  |  Yes1  |  Product or product group level for the forecast.  | 
|  site\$1id2  |  string  |  Yes1  |  Site ID that the forecast is generated for .  | 
|  source  |  string  |  No  |  Source of the data.  | 
|  region\$1id2  |  string  |  Yes1  |  Geographical region ID.  | 
|  product\$1group\$1id2  |  string  |  Yes1  |  Product group ID.  | 
|  reg\$1agg\$1type  |  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\$1start\$1dttm  |  timestamp  |  Yes  |  Forecast start date and time.  | 
|  forecast\$1end\$1dttm  |  timestamp  |  Yes  |  Forecast end date and time.  | 
|  default\$1price  |  double  |  No  |  Default MSRP of the product that is forecast.  | 
|  forecast\$1price  |  double  |  No  |  Price at which the ASIN was forecast to be sold.  | 
|  num\$1causals  |  int  |  No  |  Number of casuals applied to forecast.  | 
|  causal\$1start  |  timestamp  |  No  |  Start date of causal.  | 
|  causal\$1end  |  timestamp  |  No  |  End date of causal.  | 
|  user\$1override  |  double  |  No  |  User override of forecast quantity.  | 
|  user\$1id  |  string  |  No  |  ID of the user that overrode the forecast.  | 
|  act\$1qty  |  double  |  No  |  Actual order quantity sold in the forecast period.  | 
|  channel\$1id  |  string  |  No  |  Unique identifier for a specific channel. Corresponds to channel\$1id in the outbound\$1order\$1line dataset.  | 
|  tpartner\$1id 2  |  string  |  No  |  Tpartner ID.  | 
|  user\$1override\$1p10  |  double  |  No  |  Override value for the P10 quantile of forecast.  | 
|  user\$1override\$1p20  |  double  |  No  |  Override value for the P20 quantile of forecast.  | 
|  user\$1override\$1p30  |  double  |  No  |  Override value for the P30 quantile of forecast.  | 
|  user\$1override\$1p40  |  double  |  No  |  Override value for the P40 quantile of forecast.  | 
|  user\$1override\$1p50  |  double  |  No  |  Override value for the P50 quantile of forecast.  | 
|  user\$1override\$1p60  |  double  |  No  |  Override value for the P60 quantile of forecast.  | 
|  user\$1override\$1p70  |  double  |  No  |  Override value for the P70 quantile of forecast.  | 
|  user\$1override\$1p80  |  double  |  No  |  Override value for the P80 quantile of forecast.  | 
|  user\$1override\$1p90  |  double  |  No  |  Override value for the P90 quantile of forecast.  | 
|  postal\$1code  |  string  |  No  |  Trading partner's postal code.  | 
|  tpartner\$1type  |  string  |  No  |  Trading partner type.  | 
|  quantity\$1uom  |  string  |  No  |  Quantity unit of measure.  | 
|  demand\$1plan\$1id  |  string  | No |  Demand plan ID.  | 
|  plan\$1sequence\$1id  |  string  | No |  Unique identifier or sequence number assigned to each individual demand plan or demand plan version.  | 
|  plan\$1type  |  string  | No |  Type of forecast or plan.  | 
|  plan\$1window\$1start  |  timestamp  | No |  If plan corresponds to a planning bucket or window in application, this field stores the start of the planning window.  | 
|  plan\$1window\$1end  |  timestamp  | No |  If plan corresponds to a planning bucket or window in application, this field stores the end of the planning window.   | 
|  ship\$1to\$1site\$1id  |  string  | No |  Site to which an order is shipped.  | 
|  source\$1event\$1id  |  string  | No |  ID of the event created in the source system.  | 
|  source\$1update\$1dttm  |  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.   | 
|  plan\$1name  |  string  | No |  Represents the name of the demand plan associated with the forecast  | 

1You must enter a value. When you ingest data from SAP or EDI, the default value for *string* is SCN\$1RESERVED\$1NO\$1VALUE\$1PROVIDED.

2Foreign key

**Foreign key (FK)**

The table below lists the columns with the associated foreign key.


| Column | Category | FK/Data entity | FK/Column | 
| --- | --- | --- | --- | 
| company\$1id | Organization | company | id | 
| product\$1id | Product | product | id | 
| region\$1id | Organization | geography | id | 
| product\$1group\$1id | Product | product\$1hierarchy | id | 
| site\$1id | Network | site | id | 
| tpartner\$1id | Organization | trading\$1partner | id | 
| ship\$1to\$1site\$1id | Outbound | outbound\$1order\$1line | ship\$1to\$1site\$1id |