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(20)
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 |
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
Rule Validation Summary
- Source Rule Count
- 22
- Governed Rule Count
- 19