RMS Oi Stock Cnt Value Variance
In ScopeTechnical: RMS_OI_STK_CNT_VALUE_VARIANCE | ID: OR-FND-RMS_OI_STK_CNT_VALUE_VARIANCE-RMS_OI_STOCK_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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- RMS_OI_STK_CNT_VALUE_VARIANCE
Field Definitions(5)
Rules & Considerations(19)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | SAMPLE | S | 1 | SAMPLE | SAMPLE | 1 | 1 | 1.0000 | SAMPLE | 1.0000 | 2026-01-01 | S | SAMPLE | 1.0000000000 | 1.0000000000 | 1.0000000000 | 1.0000000000 |
| default | 3 | 1003 | 1103 | RMS Oi Stk Cnt Value Variance Secondary | R | 1113 | Footwear | Womenswear | 1000000003 | 3 | 12.5000 | Fashion Range | 12.5000 | 2026-01-03 | R | RMS Oi Stk Cnt Value Variance-002-ALT | 12.5000000000 | 12.5000000000 | 12.5000000000 | 12.5000000000 |
| default | 5 | 1005 | 1105 | RMS Oi Stk Cnt Value Variance Core | R | 1115 | Beauty | Kidswear | 1000000005 | 5 | 14.0000 | Value Range | 14.0000 | 2026-01-05 | R | RMS Oi Stk Cnt Value Variance-003-EDGE | 14.0000000000 | 14.0000000000 | 14.0000000000 | 14.0000000000 |
Example values from field definitions
- LOC
- 1
- DEPT
- 1
- CLASS
- 1
- LOC_NAME
- SAMPLE
- LOC_TYPE
- S
- SUBCLASS
- 1
- DEPT_NAME
- SAMPLE
- CLASS_NAME
- SAMPLE
- SESSION_ID
- 1
- CYCLE_COUNT
- 1
- ACTUAL_VALUE
- 1.0000
- SUBCLASS_NAME
- SAMPLE
- SNAPSHOT_VALUE
- 1.0000
- STOCKTAKE_DATE
- 2026-01-01
- STOCKTAKE_TYPE
- S
- CYCLE_COUNT_DESC
- SAMPLE
- TOTAL_VARIANCE_PCT
- 1.0000000000
- OVER_UNIT_VARIANCE_PCT
- 1.0000000000
- SHORT_UNIT_VARIANCE_PCT
- 1.0000000000
- TOTAL_UNIT_VARIANCE_PCT
- 1.0000000000
default
- LOC
- 3
- DEPT
- 1003
- CLASS
- 1103
- LOC_NAME
- RMS Oi Stk Cnt Value Variance Secondary
- LOC_TYPE
- R
- SUBCLASS
- 1113
- DEPT_NAME
- Footwear
- CLASS_NAME
- Womenswear
- SESSION_ID
- 1000000003
- CYCLE_COUNT
- 3
- ACTUAL_VALUE
- 12.5000
- SUBCLASS_NAME
- Fashion Range
- SNAPSHOT_VALUE
- 12.5000
- STOCKTAKE_DATE
- 2026-01-03
- STOCKTAKE_TYPE
- R
- CYCLE_COUNT_DESC
- RMS Oi Stk Cnt Value Variance-002-ALT
- TOTAL_VARIANCE_PCT
- 12.5000000000
- OVER_UNIT_VARIANCE_PCT
- 12.5000000000
- SHORT_UNIT_VARIANCE_PCT
- 12.5000000000
- TOTAL_UNIT_VARIANCE_PCT
- 12.5000000000
default
- LOC
- 5
- DEPT
- 1005
- CLASS
- 1105
- LOC_NAME
- RMS Oi Stk Cnt Value Variance Core
- LOC_TYPE
- R
- SUBCLASS
- 1115
- DEPT_NAME
- Beauty
- CLASS_NAME
- Kidswear
- SESSION_ID
- 1000000005
- CYCLE_COUNT
- 5
- ACTUAL_VALUE
- 14.0000
- SUBCLASS_NAME
- Value Range
- SNAPSHOT_VALUE
- 14.0000
- STOCKTAKE_DATE
- 2026-01-05
- STOCKTAKE_TYPE
- R
- CYCLE_COUNT_DESC
- RMS Oi Stk Cnt Value Variance-003-EDGE
- TOTAL_VARIANCE_PCT
- 14.0000000000
- OVER_UNIT_VARIANCE_PCT
- 14.0000000000
- SHORT_UNIT_VARIANCE_PCT
- 14.0000000000
- TOTAL_UNIT_VARIANCE_PCT
- 14.0000000000
Rule Validation Summary
- Source Rule Count
- 22
- Governed Rule Count
- 19