RMS Oi Shrinkage Variance
In ScopeTechnical: RMS_OI_SHRINKAGE_VARIANCE | ID: OR-ITM-RMS_OI_SHRINKAGE_VARIANCE-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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- RMS_OI_SHRINKAGE_VARIANCE
Field Definitions(22)
Rules & Considerations(22)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 1 | 1 | SAMPLE | S | 1 | SAMPLE | SAMPLE | 1 | SAMPLE | 1.0000 | 1.0000 | SAM | SAMPLE | SAMPLE | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 |
Example values from field definitions
- LOC
- 1
- DEPT
- 1
- CLASS
- 1
- REGION
- 1
- DISTRICT
- 1
- LOC_NAME
- SAMPLE
- LOC_TYPE
- S
- SUBCLASS
- 1
- DEPT_NAME
- SAMPLE
- CLASS_NAME
- SAMPLE
- SESSION_ID
- 1
- REGION_NAME
- SAMPLE
- TOTAL_SALES
- 1.0000
- VARIANCE_PCT
- 1.0000
- CURRENCY_CODE
- SAM
- DISTRICT_NAME
- SAMPLE
- SUBCLASS_NAME
- SAMPLE
- ACTUAL_SHRINKAGE
- 1.0000
- BUDGETED_SHRINKAGE
- 1.0000
- UNIT_AND_VALUE_COUNT
- 1.0000
- ACTUAL_SHRINKAGE_RATE
- 1.0000
- BUDGETED_SHRINKAGE_RATE
- 1.0000
Rule Validation Summary
- Source Rule Count
- 28
- Governed Rule Count
- 22