Item Forecast History
In ScopeTechnical: ITEM_FORECAST_HIST | ID: OR-ITM-ITEM_FORECAST_HIST-ITEM_FORECAST_HISTORY
Stores 4 weeks of history of the item level forecasted sales information from the RDF extractions. It is used to support the Inventory Variance to Forecast dashboard report.
See how this object fits into Item Management
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- ITEM_FORECAST_HIST
Field Definitions(5)
Rules & Considerations(12)
constraint
validation
Sample Load Data(4)
| _scenario | LOCRPK | ITEMRPK | EOW_DATERPK | FORECAST_SALESR | FORECAST_STD_DEVR |
|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 2026-01-01 | 1.0000 | 1.0000 |
| default | 3 | Item Forecast Hist-002-AL | 2026-01-03 | 12.5000 | 12.5000 |
| default | 5 | Item Forecast Hist-003-ED | 2026-01-05 | 14.0000 | 14.0000 |
Example values from field definitions
- LOCRPK
- 1
- ITEMRPK
- SAMPLE
- EOW_DATERPK
- 2026-01-01
- FORECAST_SALESR
- 1.0000
- FORECAST_STD_DEVR
- 1.0000
default
- LOCRPK
- 3
- ITEMRPK
- Item Forecast Hist-002-AL
- EOW_DATERPK
- 2026-01-03
- FORECAST_SALESR
- 12.5000
- FORECAST_STD_DEVR
- 12.5000
default
- LOCRPK
- 5
- ITEMRPK
- Item Forecast Hist-003-ED
- EOW_DATERPK
- 2026-01-05
- FORECAST_SALESR
- 14.0000
- FORECAST_STD_DEVR
- 14.0000
Rule Validation Summary
- Source Rule Count
- 26
- Governed Rule Count
- 12