RMS Oi Stk Cnt Value Variance
In ScopeTechnical: RMS_OI_STK_CNT_VALUE_VARIANCE | ID: OR-MFCS-RMS_OI_STK_CNT_VALUE_VARIANCE
Stores the information about Stock Count unit and value variances for the Stock Count Value Variance 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_STK_CNT_VALUE_VARIANCE
Field Definitions(20)
Rules & Considerations(3)
Sequencing
Reconciliation
Sample Load Data(4)
| _scenario | LOC | DEPT | CLASS | LOC_NAME | LOC_TYPE | SUBCLASS | DEPT_NAME | CLASS_NAME | SESSION_ID | CYCLE_COUNT | ACTUAL_VALUE | SUBCLASS_NAME | SNAPSHOT_VALUE | STOCKTAKE_DATE | STOCKTAKE_TYPE | CYCLE_COUNT_DESC | TOTAL_VARIANCE_PCT | OVER_UNIT_VARIANCE_PCT | SHORT_UNIT_VARIANCE_PCT | TOTAL_UNIT_VARIANCE_PCT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | 1001 | 1101 | RMS Oi Stk Cnt Value Variance Primary | RMS Oi Stk Cnt Value Variance-001 | 1111 | Apparel | Menswear | 1000000001 | 1 | 11.0000 | Core Range | 11.0000 | 2026-01-01 | RMS Oi Stk Cnt Value Variance-001 | RMS Oi Stk Cnt Value Variance-001 | 11.0000 | 11.0000 | 11.0000 | 11.0000 |
default
- LOC
- 1
- DEPT
- 1001
- CLASS
- 1101
- LOC_NAME
- RMS Oi Stk Cnt Value Variance Primary
- LOC_TYPE
- RMS Oi Stk Cnt Value Variance-001
- SUBCLASS
- 1111
- DEPT_NAME
- Apparel
- CLASS_NAME
- Menswear
- SESSION_ID
- 1000000001
- CYCLE_COUNT
- 1
- ACTUAL_VALUE
- 11.0000
- SUBCLASS_NAME
- Core Range
- SNAPSHOT_VALUE
- 11.0000
- STOCKTAKE_DATE
- 2026-01-01
- STOCKTAKE_TYPE
- RMS Oi Stk Cnt Value Variance-001
- CYCLE_COUNT_DESC
- RMS Oi Stk Cnt Value Variance-001
- TOTAL_VARIANCE_PCT
- 11.0000
- OVER_UNIT_VARIANCE_PCT
- 11.0000
- SHORT_UNIT_VARIANCE_PCT
- 11.0000
- TOTAL_UNIT_VARIANCE_PCT
- 11.0000