Daily Item Forecast

In Scope

Technical: DAILY_ITEM_FORECAST | ID: OR-ITM-DAILY_ITEM_FORECAST-DAILY_ITEM_FORECAST

Stores THE DAY/ITEM LEVEL FORECASTED INFORMATION FROM THE RDF EXTRACTIONS.THIS TABLE WILL HOLD ALL ITEM TYPES.THIS TABLE SHOULD BE PARTITIONED ACCORDING TO THE ITEM/LOC. WHILE THE DEVELOPMENT ENVIRONMENT WILL CREATE...

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: DAILY_ITEM_FORECAST

Field Definitions(5)

Rules & Considerations(14)

constraint

validation

Sample Load Data(4)

_scenario	LOCRPK	ITEMRPK	DATA_DATERPK	DOMAIN_IDRPK	FORECAST_SALESR	FORECAST_STD_DEV
Example values from field definitions	1	SAMPLE	2026-01-01	1	1.0000	1.0000
default	3	Daily Item Forecast-002-A	2026-01-03	100003	12.5000	12.5000
default	5	Daily Item Forecast-003-E	2026-01-05	100005	14.0000	14.0000

Example values from field definitions

LOCRPK: 1
ITEMRPK: SAMPLE
DATA_DATERPK: 2026-01-01
DOMAIN_IDRPK: 1
FORECAST_SALESR: 1.0000
FORECAST_STD_DEV: 1.0000

default

LOCRPK: 3
ITEMRPK: Daily Item Forecast-002-A
DATA_DATERPK: 2026-01-03
DOMAIN_IDRPK: 100003
FORECAST_SALESR: 12.5000
FORECAST_STD_DEV: 12.5000