RMS Oi Wac Variance

In Scope

Technical: RMS_OI_WAC_VARIANCE | ID: OR-MFCS-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

Target Structure

Load Approach: Table
Target Objects: RMS_OI_WAC_VARIANCE

Field Definitions(28)

Rules & Considerations(6)

Sequencing

Reconciliation

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
default	9001	1	1001	RMS Oi Wac Variance-001	1101	RMS Oi Wac Variance Primary	11.0000	RMS Oi Wac Variance Primary	RMS Oi Wac Variance-001	1111	1	11.0000	11.0000	RMS Oi Wac Variance-001	RMS Oi Wac Variance-001	1000000001	11.0000	11.0000	11.0000	STD-RMS_OI-001	Core Range	RMS Oi Wac Variance Primary	11.0000	11.0000	11.0000	11.0000	1	1

default

WH: 9001
LOC: 1
DEPT: 1001
ITEM: RMS Oi Wac Variance-001
CLASS: 1101
WH_NAME: RMS Oi Wac Variance Primary
AVG_COST: 11.0000
LOC_NAME: RMS Oi Wac Variance Primary
LOC_TYPE: RMS Oi Wac Variance-001
SUBCLASS: 1111
SUPPLIER: 1
UNIT_ELC: 11.0000
INVENTORY: 11.0000
ITEM_DESC: RMS Oi Wac Variance-001
ITEM_IMAGE: RMS Oi Wac Variance-001
SESSION_ID: 1000000001
UNIT_RETAIL: 11.0000
CHAIN_AVERGE: 11.0000
VARIANCE_PCT: 11.0000
CURRENCY_CODE: STD-RMS_OI-001
SUBCLASS_NAME: Core Range
SUPPLIER_NAME: RMS Oi Wac Variance Primary
WH_AVERAGE_COST: 11.0000
UNIT_ELC_PRIMARY: 11.0000
INVENTORY_PRIMARY: 11.0000
AVERAGE_COST_PRIMARY: 11.0000
NUM_ITEMS_WAC_ISSUE_LOC: 1
NUM_LOCS_WAC_ISSUE_ITEM: 1

All objects