RMS Oi Stock Count Variance
In ScopeTechnical: RMS_OI_STOCK_COUNT_VARIANCE | ID: OR-MFCS-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
Target Structure
- Load Approach
- Table
- Target Objects
- RMS_OI_STOCK_COUNT_VARIANCE
Field Definitions(14)
Rules & Considerations(3)
Sequencing
Reconciliation
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | RMS Oi Stock Count Variance Primary | RMS Oi Stock Count Variance-001 | 1000000001 | 1 | 2026-01-01 | RMS Oi Stock Count Variance-001 | RMS Oi Stock Count Variance-001 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 |
default
- LOC
- 1
- LOC_NAME
- RMS Oi Stock Count Variance Primary
- LOC_TYPE
- RMS Oi Stock Count Variance-001
- SESSION_ID
- 1000000001
- CYCLE_COUNT
- 1
- STOCKTAKE_DATE
- 2026-01-01
- STOCKTAKE_TYPE
- RMS Oi Stock Count Variance-001
- CYCLE_COUNT_DESC
- RMS Oi Stock Count Variance-001
- OVER_VARIANCE_PCT
- 11.0000
- PHYSICAL_COUNT_QTY
- 11.0000
- SHORT_VARIANCE_PCT
- 11.0000
- TOTAL_VARIANCE_PCT
- 11.0000
- SNAPSHOT_ON_HAND_QTY
- 11.0000
- SNAPSHOT_IN_TRANSIT_QTY
- 11.0000