Site Forecasts

A new home for the Coupa Supply Chain documentation

Starting with Supply Chain 42, our documentation will be located on Coupa Compass. The help here will continue to be accessible for the foreseeable future, but will no longer be updated. If you need a Compass user account, contact your company’s Designated Support Contact (DSC).

You can access new and updated Supply Chain documentation in the following location on Compass:

https://compass.coupa.com/en-us/products/supply-chain-design-and-planning

Site Forecasts

Internal Table Name: FacilityHistoricalForecast

Use this table to populate forecast demand data for products at site locations.

Period

Technology: S

Table: FacilityHistoricalForecast

Internal Name: PeriodName

Type: Short Text (100)

Select the period or period group to which the forecast applies.

Site

Technology: S

Table: FacilityHistoricalForecast

Internal Name: SiteName

Type: Short Text (100)

Select the site or site group to which the forecast applies.

Product

Technology: IO S

Table: FacilityHistoricalForecast

Internal Name: ProductName

Type: Short Text (100)

Select the product or product group to which the forecast applies.

Order Date

Technology: IO S

Table: FacilityHistoricalForecast

Internal Name: OrderTime

Type: Date/Time

Select the date on which the historical demand occurred.

Quantity

Technology: IO S

Table: FacilityHistoricalForecast

Internal Name: Quantity

Type: Short Text (100)

Enter the amount of product demand for the customer that occurred. Enter a value, then optionally select a quantity, weight or volume unit of measure. If you do not select a unit of measure, the default Quantity Unit Of Measure from Model Settings is used.

Snapshot Date

Technology: S

Table: FacilityHistoricalForecast

Internal Name: SnapshotDate

Type: Datetime

Select the date that the Site Forecast is based on. You can create different snapshots of forecast data and use the Snapshot Date to determine which forecasts are captured when solving with the "Simulation" problem type.

For example, given a site-product combination, assume the following Site Forecasts records where the DOS Planning Lead Time is 5 DAY and we are considering forecasts starting on 1/3/2021:

Status

Technology: IO S

Table: FacilityHistoricalForecast

Internal Name: Status

Type: Short Text (25)

One of Include, Exclude.

Choose the forecast status:

Include – This forecast will be included in a simulation run.
Exclude – This forecast will be excluded from a simulation run.

Default: Include

Notes

Technology: IO S

Table: FacilityHistoricalForecast

Internal Name: Notes

Type: Memo

Enter optional descriptive notes about the forecast.

Last modified: Wednesday May 15, 2024

Is this useful?

Yes No