RMS Oi Inv Ana Variance
In ScopeTechnical: RMS_OI_INV_ANA_VARIANCE | ID: OR-MFCS-RMS_OI_INV_ANA_VARIANCE
Stores data for the Inventory Analyst Inventory Variance to Forecast Report.
See how this object fits into Foundation Data
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Target Structure
- Load Approach
- Table
- Target Objects
- RMS_OI_INV_ANA_VARIANCE
Field Definitions(14)
Rules & Considerations(3)
Sequencing
Reconciliation
Sample Load Data(4)
| _scenario | ITEM | INV_UNITS | ITEM_DESC | AGG_DIFF_1 | AGG_DIFF_2 | AGG_DIFF_3 | AGG_DIFF_4 | SESSION_ID | SALES_UNITS | ALC_ITEM_TYPE | CURRENCY_CODE | INV_VAR_VALUE | INV_VAR_TO_FORECAST_PCT | SALES_VAR_TO_FORECAST_PCT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | RMS Oi Inv Ana Variance-001 | 11.0000 | RMS Oi Inv Ana Variance-001 | RMS Oi Inv Ana Variance-001 | RMS Oi Inv Ana Variance-001 | RMS Oi Inv Ana Variance-001 | RMS Oi Inv Ana Variance-001 | 1000000001 | 11.0000 | RMS Oi Inv Ana Variance-001 | STD-RMS_OI-001 | 11.0000 | 11.0000 | 11.0000 |
default
- ITEM
- RMS Oi Inv Ana Variance-001
- INV_UNITS
- 11.0000
- ITEM_DESC
- RMS Oi Inv Ana Variance-001
- AGG_DIFF_1
- RMS Oi Inv Ana Variance-001
- AGG_DIFF_2
- RMS Oi Inv Ana Variance-001
- AGG_DIFF_3
- RMS Oi Inv Ana Variance-001
- AGG_DIFF_4
- RMS Oi Inv Ana Variance-001
- SESSION_ID
- 1000000001
- SALES_UNITS
- 11.0000
- ALC_ITEM_TYPE
- RMS Oi Inv Ana Variance-001
- CURRENCY_CODE
- STD-RMS_OI-001
- INV_VAR_VALUE
- 11.0000
- INV_VAR_TO_FORECAST_PCT
- 11.0000
- SALES_VAR_TO_FORECAST_PCT
- 11.0000
