RMS Oi Wac Variance
In ScopeTechnical: 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(28)
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 |
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
Rule Validation Summary
- Source Rule Count
- 34
- Governed Rule Count
- 28