RMS Oi Inventory Ana Variance
In ScopeTechnical: RMS_OI_INV_ANA_VARIANCE | ID: OR-FND-RMS_OI_INV_ANA_VARIANCE-RMS_OI_INVENTORY_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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- RMS_OI_INV_ANA_VARIANCE
Field Definitions(5)
Rules & Considerations(14)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1.0000 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | 1.0000 | SAMPLE | SAM | 1.0000 | 1.0000 | 1.0000 |
| default | RMS Oi Inv Ana Variance-0 | 12.5000 | RMS Oi Inv Ana Variance-002-ALT | RMS Oi Inv | RMS Oi Inv | RMS Oi Inv | RMS Oi Inv | 1000000003 | 12.5000 | RMS Oi Inv Ana | ALT | 12.5000 | 12.5000 | 12.5000 |
| default | RMS Oi Inv Ana Variance-0 | 14.0000 | RMS Oi Inv Ana Variance-003-EDGE | RMS Oi Inv | RMS Oi Inv | RMS Oi Inv | RMS Oi Inv | 1000000005 | 14.0000 | RMS Oi Inv Ana | EDG | 14.0000 | 14.0000 | 14.0000 |
Example values from field definitions
- ITEM
- SAMPLE
- INV_UNITS
- 1.0000
- ITEM_DESC
- SAMPLE
- AGG_DIFF_1
- SAMPLE
- AGG_DIFF_2
- SAMPLE
- AGG_DIFF_3
- SAMPLE
- AGG_DIFF_4
- SAMPLE
- SESSION_ID
- 1
- SALES_UNITS
- 1.0000
- ALC_ITEM_TYPE
- SAMPLE
- CURRENCY_CODE
- SAM
- INV_VAR_VALUE
- 1.0000
- INV_VAR_TO_FORECAST_PCT
- 1.0000
- SALES_VAR_TO_FORECAST_PCT
- 1.0000
default
- ITEM
- RMS Oi Inv Ana Variance-0
- INV_UNITS
- 12.5000
- ITEM_DESC
- RMS Oi Inv Ana Variance-002-ALT
- AGG_DIFF_1
- RMS Oi Inv
- AGG_DIFF_2
- RMS Oi Inv
- AGG_DIFF_3
- RMS Oi Inv
- AGG_DIFF_4
- RMS Oi Inv
- SESSION_ID
- 1000000003
- SALES_UNITS
- 12.5000
- ALC_ITEM_TYPE
- RMS Oi Inv Ana
- CURRENCY_CODE
- ALT
- INV_VAR_VALUE
- 12.5000
- INV_VAR_TO_FORECAST_PCT
- 12.5000
- SALES_VAR_TO_FORECAST_PCT
- 12.5000
default
- ITEM
- RMS Oi Inv Ana Variance-0
- INV_UNITS
- 14.0000
- ITEM_DESC
- RMS Oi Inv Ana Variance-003-EDGE
- AGG_DIFF_1
- RMS Oi Inv
- AGG_DIFF_2
- RMS Oi Inv
- AGG_DIFF_3
- RMS Oi Inv
- AGG_DIFF_4
- RMS Oi Inv
- SESSION_ID
- 1000000005
- SALES_UNITS
- 14.0000
- ALC_ITEM_TYPE
- RMS Oi Inv Ana
- CURRENCY_CODE
- EDG
- INV_VAR_VALUE
- 14.0000
- INV_VAR_TO_FORECAST_PCT
- 14.0000
- SALES_VAR_TO_FORECAST_PCT
- 14.0000
Rule Validation Summary
- Source Rule Count
- 17
- Governed Rule Count
- 14