RMS Oi Stock Count Variance
In ScopeTechnical: RMS_OI_STOCK_COUNT_VARIANCE | ID: OR-FND-RMS_OI_STOCK_COUNT_VARIANCE-RMS_OI_STOCK_COUNT_VARIANCE
Stores the information for the Stock Count Variance Inventory Control 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_STOCK_COUNT_VARIANCE
Field Definitions(5)
Rules & Considerations(13)
Sample Load Data(4)
| _scenario | LOC | LOC_NAME | LOC_TYPE | SESSION_ID | CYCLE_COUNT | STOCKTAKE_DATE | STOCKTAKE_TYPE | CYCLE_COUNT_DESC | OVER_VARIANCE_PCT | PHYSICAL_COUNT_QTY | SHORT_VARIANCE_PCT | TOTAL_VARIANCE_PCT | SNAPSHOT_ON_HAND_QTY | SNAPSHOT_IN_TRANSIT_QTY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | S | 1 | 1 | 2026-01-01 | S | SAMPLE | 1.0000000000 | 1.0000 | 1.0000000000 | 1.0000000000 | 1.0000 | 1.0000 |
| default | 3 | RMS Oi Stock Count Variance Secondary | R | 1000000003 | 3 | 2026-01-03 | R | RMS Oi Stock Count Variance-002-ALT | 12.5000000000 | 12.5000 | 12.5000000000 | 12.5000000000 | 12.5000 | 12.5000 |
| default | 5 | RMS Oi Stock Count Variance Core | R | 1000000005 | 5 | 2026-01-05 | R | RMS Oi Stock Count Variance-003-EDGE | 14.0000000000 | 14.0000 | 14.0000000000 | 14.0000000000 | 14.0000 | 14.0000 |
Example values from field definitions
- LOC
- 1
- LOC_NAME
- SAMPLE
- LOC_TYPE
- S
- SESSION_ID
- 1
- CYCLE_COUNT
- 1
- STOCKTAKE_DATE
- 2026-01-01
- STOCKTAKE_TYPE
- S
- CYCLE_COUNT_DESC
- SAMPLE
- OVER_VARIANCE_PCT
- 1.0000000000
- PHYSICAL_COUNT_QTY
- 1.0000
- SHORT_VARIANCE_PCT
- 1.0000000000
- TOTAL_VARIANCE_PCT
- 1.0000000000
- SNAPSHOT_ON_HAND_QTY
- 1.0000
- SNAPSHOT_IN_TRANSIT_QTY
- 1.0000
default
- LOC
- 3
- LOC_NAME
- RMS Oi Stock Count Variance Secondary
- LOC_TYPE
- R
- SESSION_ID
- 1000000003
- CYCLE_COUNT
- 3
- STOCKTAKE_DATE
- 2026-01-03
- STOCKTAKE_TYPE
- R
- CYCLE_COUNT_DESC
- RMS Oi Stock Count Variance-002-ALT
- OVER_VARIANCE_PCT
- 12.5000000000
- PHYSICAL_COUNT_QTY
- 12.5000
- SHORT_VARIANCE_PCT
- 12.5000000000
- TOTAL_VARIANCE_PCT
- 12.5000000000
- SNAPSHOT_ON_HAND_QTY
- 12.5000
- SNAPSHOT_IN_TRANSIT_QTY
- 12.5000
default
- LOC
- 5
- LOC_NAME
- RMS Oi Stock Count Variance Core
- LOC_TYPE
- R
- SESSION_ID
- 1000000005
- CYCLE_COUNT
- 5
- STOCKTAKE_DATE
- 2026-01-05
- STOCKTAKE_TYPE
- R
- CYCLE_COUNT_DESC
- RMS Oi Stock Count Variance-003-EDGE
- OVER_VARIANCE_PCT
- 14.0000000000
- PHYSICAL_COUNT_QTY
- 14.0000
- SHORT_VARIANCE_PCT
- 14.0000000000
- TOTAL_VARIANCE_PCT
- 14.0000000000
- SNAPSHOT_ON_HAND_QTY
- 14.0000
- SNAPSHOT_IN_TRANSIT_QTY
- 14.0000
Rule Validation Summary
- Source Rule Count
- 16
- Governed Rule Count
- 13