RMS Oi Shrinkage Variance
In ScopeTechnical: RMS_OI_SHRINKAGE_VARIANCE | ID: OR-MFCS-RMS_OI_SHRINKAGE_VARIANCE
Stores the information about shrinkage differences between the actual and budgeted shrinkage rate falling outside the defined tolerence for the Shrinkage Variance Report.
See how this object fits into Item Management
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_SHRINKAGE_VARIANCE
Field Definitions(22)
Rules & Considerations(6)
Sequencing
Reconciliation
Sample Load Data(4)
| _scenario | LOC | DEPT | CLASS | REGION | DISTRICT | LOC_NAME | LOC_TYPE | SUBCLASS | DEPT_NAME | CLASS_NAME | SESSION_ID | REGION_NAME | TOTAL_SALES | VARIANCE_PCT | CURRENCY_CODE | DISTRICT_NAME | SUBCLASS_NAME | ACTUAL_SHRINKAGE | BUDGETED_SHRINKAGE | UNIT_AND_VALUE_COUNT | ACTUAL_SHRINKAGE_RATE | BUDGETED_SHRINKAGE_RATE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | 1001 | 1101 | 201 | 301 | RMS Oi Shrinkage Variance Primary | RMS Oi Shrinkage Variance-001 | 1111 | Apparel | Menswear | 1000000001 | RMS Oi Shrinkage Variance Primary | 11.0000 | 11.0000 | STD-RMS_OI-001 | RMS Oi Shrinkage Variance Primary | Core Range | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 |
default
- LOC
- 1
- DEPT
- 1001
- CLASS
- 1101
- REGION
- 201
- DISTRICT
- 301
- LOC_NAME
- RMS Oi Shrinkage Variance Primary
- LOC_TYPE
- RMS Oi Shrinkage Variance-001
- SUBCLASS
- 1111
- DEPT_NAME
- Apparel
- CLASS_NAME
- Menswear
- SESSION_ID
- 1000000001
- REGION_NAME
- RMS Oi Shrinkage Variance Primary
- TOTAL_SALES
- 11.0000
- VARIANCE_PCT
- 11.0000
- CURRENCY_CODE
- STD-RMS_OI-001
- DISTRICT_NAME
- RMS Oi Shrinkage Variance Primary
- SUBCLASS_NAME
- Core Range
- ACTUAL_SHRINKAGE
- 11.0000
- BUDGETED_SHRINKAGE
- 11.0000
- UNIT_AND_VALUE_COUNT
- 11.0000
- ACTUAL_SHRINKAGE_RATE
- 11.0000
- BUDGETED_SHRINKAGE_RATE
- 11.0000