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(14)
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 |
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
Rule Validation Summary
- Source Rule Count
- 16
- Governed Rule Count
- 13