RMS Oi Shrinkage Variance

In Scope

Technical: 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(5)

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
default	3	1003	1103	203	303	RMS Oi Shrinkage Variance Secondary	R	1113	Footwear	Womenswear	1000000003	RMS Oi Shrinkage Variance Secondary	12.5000	12.5000	ALT	RMS Oi Shrinkage Variance Secondary	Fashion Range	12.5000	12.5000	12.5000	12.5000	12.5000
default	5	1005	1105	205	305	RMS Oi Shrinkage Variance Core	R	1115	Beauty	Kidswear	1000000005	RMS Oi Shrinkage Variance Core	14.0000	14.0000	EDG	RMS Oi Shrinkage Variance Core	Value Range	14.0000	14.0000	14.0000	14.0000	14.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

default

LOC: 3
DEPT: 1003
CLASS: 1103
REGION: 203
DISTRICT: 303
LOC_NAME: RMS Oi Shrinkage Variance Secondary
LOC_TYPE: R
SUBCLASS: 1113
DEPT_NAME: Footwear
CLASS_NAME: Womenswear
SESSION_ID: 1000000003
REGION_NAME: RMS Oi Shrinkage Variance Secondary
TOTAL_SALES: 12.5000
VARIANCE_PCT: 12.5000
CURRENCY_CODE: ALT
DISTRICT_NAME: RMS Oi Shrinkage Variance Secondary
SUBCLASS_NAME: Fashion Range
ACTUAL_SHRINKAGE: 12.5000
BUDGETED_SHRINKAGE: 12.5000
UNIT_AND_VALUE_COUNT: 12.5000
ACTUAL_SHRINKAGE_RATE: 12.5000
BUDGETED_SHRINKAGE_RATE: 12.5000

default

LOC: 5
DEPT: 1005
CLASS: 1105
REGION: 205
DISTRICT: 305
LOC_NAME: RMS Oi Shrinkage Variance Core
LOC_TYPE: R
SUBCLASS: 1115
DEPT_NAME: Beauty
CLASS_NAME: Kidswear
SESSION_ID: 1000000005
REGION_NAME: RMS Oi Shrinkage Variance Core
TOTAL_SALES: 14.0000
VARIANCE_PCT: 14.0000
CURRENCY_CODE: EDG
DISTRICT_NAME: RMS Oi Shrinkage Variance Core
SUBCLASS_NAME: Value Range
ACTUAL_SHRINKAGE: 14.0000
BUDGETED_SHRINKAGE: 14.0000
UNIT_AND_VALUE_COUNT: 14.0000
ACTUAL_SHRINKAGE_RATE: 14.0000
BUDGETED_SHRINKAGE_RATE: 14.0000

Rule Validation Summary

Source Rule Count: 28
Governed Rule Count: 22

All objects