RMS Oi Wac Variance

In Scope

Technical: RMS_OI_WAC_VARIANCE | ID: OR-ITM-RMS_OI_WAC_VARIANCE-RMS_OI_WAC_VARIANCE

Stores the information about item/locations having a variance between the unit cost and weighted average cost (WAC) that falls outside of a defined tolerance for the WAC 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_WAC_VARIANCE

Field Definitions(5)

Rules & Considerations(28)

Sample Load Data(4)

_scenario	WH	LOC	DEPT	ITEM	CLASS	WH_NAME	AVG_COST	LOC_NAME	LOC_TYPE	SUBCLASS	SUPPLIER	UNIT_ELC	INVENTORY	ITEM_DESC	ITEM_IMAGE	SESSION_ID	UNIT_RETAIL	CHAIN_AVERGE	VARIANCE_PCT	CURRENCY_CODE	SUBCLASS_NAME	SUPPLIER_NAME	WH_AVERAGE_COST	UNIT_ELC_PRIMARY	INVENTORY_PRIMARY	AVERAGE_COST_PRIMARY	NUM_ITEMS_WAC_ISSUE_LOC	NUM_LOCS_WAC_ISSUE_ITEM
Example values from field definitions	1	1	1	SAMPLE	1	SAMPLE	1.0000	SAMPLE	S	1	1	1.0000	1.0000	SAMPLE	SAMPLE	1	1.0000	1.0000	1.0000000000	SAM	SAMPLE	SAMPLE	1.0000	1.0000	1.0000	1.0000	1	1
default	9003	3	1003	RMS Oi Wac Variance-002-A	1103	RMS Oi Wac Variance Secondary	12.5000	RMS Oi Wac Variance Secondary	R	1113	3	12.5000	12.5000	RMS Oi Wac Variance-002-ALT	RMS Oi Wac Variance-002-ALT	1000000003	12.5000	12.5000	12.5000000000	ALT	Fashion Range	RMS Oi Wac Variance Secondary	12.5000	12.5000	12.5000	12.5000	3	3
default	9005	5	1005	RMS Oi Wac Variance-003-E	1105	RMS Oi Wac Variance Core	14.0000	RMS Oi Wac Variance Core	R	1115	5	14.0000	14.0000	RMS Oi Wac Variance-003-EDGE	RMS Oi Wac Variance-003-EDGE	1000000005	14.0000	14.0000	14.0000000000	EDG	Value Range	RMS Oi Wac Variance Core	14.0000	14.0000	14.0000	14.0000	5	5

Example values from field definitions

WH: 1
LOC: 1
DEPT: 1
ITEM: SAMPLE
CLASS: 1
WH_NAME: SAMPLE
AVG_COST: 1.0000
LOC_NAME: SAMPLE
LOC_TYPE: S
SUBCLASS: 1
SUPPLIER: 1
UNIT_ELC: 1.0000
INVENTORY: 1.0000
ITEM_DESC: SAMPLE
ITEM_IMAGE: SAMPLE
SESSION_ID: 1
UNIT_RETAIL: 1.0000
CHAIN_AVERGE: 1.0000
VARIANCE_PCT: 1.0000000000
CURRENCY_CODE: SAM
SUBCLASS_NAME: SAMPLE
SUPPLIER_NAME: SAMPLE
WH_AVERAGE_COST: 1.0000
UNIT_ELC_PRIMARY: 1.0000
INVENTORY_PRIMARY: 1.0000
AVERAGE_COST_PRIMARY: 1.0000
NUM_ITEMS_WAC_ISSUE_LOC: 1
NUM_LOCS_WAC_ISSUE_ITEM: 1

default

WH: 9003
LOC: 3
DEPT: 1003
ITEM: RMS Oi Wac Variance-002-A
CLASS: 1103
WH_NAME: RMS Oi Wac Variance Secondary
AVG_COST: 12.5000
LOC_NAME: RMS Oi Wac Variance Secondary
LOC_TYPE: R
SUBCLASS: 1113
SUPPLIER: 3
UNIT_ELC: 12.5000
INVENTORY: 12.5000
ITEM_DESC: RMS Oi Wac Variance-002-ALT
ITEM_IMAGE: RMS Oi Wac Variance-002-ALT
SESSION_ID: 1000000003
UNIT_RETAIL: 12.5000
CHAIN_AVERGE: 12.5000
VARIANCE_PCT: 12.5000000000
CURRENCY_CODE: ALT
SUBCLASS_NAME: Fashion Range
SUPPLIER_NAME: RMS Oi Wac Variance Secondary
WH_AVERAGE_COST: 12.5000
UNIT_ELC_PRIMARY: 12.5000
INVENTORY_PRIMARY: 12.5000
AVERAGE_COST_PRIMARY: 12.5000
NUM_ITEMS_WAC_ISSUE_LOC: 3
NUM_LOCS_WAC_ISSUE_ITEM: 3

default

WH: 9005
LOC: 5
DEPT: 1005
ITEM: RMS Oi Wac Variance-003-E
CLASS: 1105
WH_NAME: RMS Oi Wac Variance Core
AVG_COST: 14.0000
LOC_NAME: RMS Oi Wac Variance Core
LOC_TYPE: R
SUBCLASS: 1115
SUPPLIER: 5
UNIT_ELC: 14.0000
INVENTORY: 14.0000
ITEM_DESC: RMS Oi Wac Variance-003-EDGE
ITEM_IMAGE: RMS Oi Wac Variance-003-EDGE
SESSION_ID: 1000000005
UNIT_RETAIL: 14.0000
CHAIN_AVERGE: 14.0000
VARIANCE_PCT: 14.0000000000
CURRENCY_CODE: EDG
SUBCLASS_NAME: Value Range
SUPPLIER_NAME: RMS Oi Wac Variance Core
WH_AVERAGE_COST: 14.0000
UNIT_ELC_PRIMARY: 14.0000
INVENTORY_PRIMARY: 14.0000
AVERAGE_COST_PRIMARY: 14.0000
NUM_ITEMS_WAC_ISSUE_LOC: 5
NUM_LOCS_WAC_ISSUE_ITEM: 5

Rule Validation Summary

Source Rule Count: 34
Governed Rule Count: 28

All objects