Item Differentiator Location History Mth

In Scope

Technical: ITEM_DIFF_LOC_HIST_MTH | ID: OR-ITM-ITEM_DIFF_LOC_HIST_MTH-ITEM_DIFFERENTIATOR_LOCATION_HISTORY_MTH

This table will hold the rolled up sales history for items with a diff_id by month.

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: ITEM_DIFF_LOC_HIST_MTH

Field Definitions(5)

Rules & Considerations(21)

constraint

validation

Sample Load Data(4)

_scenario	ITEMR	DIFF_IDR	EOM_DATER	LOCATIONR	LOC_TYPER	GP	SALES	STOCK	VALUE	RETAIL	AV_COST	YEAR_454	MONTH_454	SALES_TYPE
Example values from field definitions	SAMPLE	SAMPLE	2026-01-01	1	S	1.0000	1.0000	1.0000	1.0000	1.0000	1.0000	1	1	S
default	Item Diff Loc Hist Mth-00	ALT-ITEM_D	2026-01-03	3	W	12.5000	12.5000	12.5000	12.5000	12.5000	12.5000	3	3	P
default	Item Diff Loc Hist Mth-00	EDGE-ITEM_	2026-01-05	5	S	14.0000	14.0000	14.0000	14.0000	14.0000	14.0000	5	5	C

Example values from field definitions

ITEMR: SAMPLE
DIFF_IDR: SAMPLE
EOM_DATER: 2026-01-01
LOCATIONR: 1
LOC_TYPER: S
GP: 1.0000
SALES: 1.0000
STOCK: 1.0000
VALUE: 1.0000
RETAIL: 1.0000
AV_COST: 1.0000
YEAR_454: 1
MONTH_454: 1
SALES_TYPE: S

default

ITEMR: Item Diff Loc Hist Mth-00
DIFF_IDR: ALT-ITEM_D
EOM_DATER: 2026-01-03
LOCATIONR: 3
LOC_TYPER: W
GP: 12.5000
SALES: 12.5000
STOCK: 12.5000
VALUE: 12.5000
RETAIL: 12.5000
AV_COST: 12.5000
YEAR_454: 3
MONTH_454: 3
SALES_TYPE: P

default

ITEMR: Item Diff Loc Hist Mth-00
DIFF_IDR: EDGE-ITEM_
EOM_DATER: 2026-01-05
LOCATIONR: 5
LOC_TYPER: S
GP: 14.0000
SALES: 14.0000
STOCK: 14.0000
VALUE: 14.0000
RETAIL: 14.0000
AV_COST: 14.0000
YEAR_454: 5
MONTH_454: 5
SALES_TYPE: C

Rule Validation Summary

Source Rule Count: 47
Governed Rule Count: 21