Forecast
This table specifies the lowest level item/location/customer combinations for which forecast data is maintained and/or a statistical forecast is to be computed.
Note that higher levels in the hierarchy don’t need to be inserted in this table.
Field | Type | Description |
---|---|---|
name | non-empty string | A unique name for this forecast record. We recommend “Item - Location - Customer” E.g : “keyboard - factory1 - Google” |
item | non-empty string | The item to which the forecast applies. |
location | non-empty string | The location to which the forecast applies. |
customer | non-empty string | The customer to which the forecast applies. |
description | string | A description for this forecast record. |
category | string | A category for this forecast record. |
subcategory | string | A subcategory for this forecast record. |
method | string | The forecast method to be used among following possibilities
|
priority | integer | The priority for this forecast record.
Used only if this forecast is planned.
|
minshipment | number | The minimum shipment for this forecast record.
Used only if this forecast is planned.
|
maxlateness | number | The maximum allowed delivery delay for this forecast record.
Used only if this forecast is planned.
The default value allows a delay of 5 years.
|
discrete | boolean | Indicates whether the forecast quantity should be discrete
(integer values only).
Possible values are : “TRUE” (default) or “FALSE”.
|
planned | boolean | Indicates whether the forecasted quantity should be planned.
Possible values are : “TRUE” (default) or “FALSE”.
|
operation | string | Operation to be used to satisfy the forecast.
When left unspecified, frePPLe will automatically create
a delivery operation for the item and location combination.
|