Item Location History By Month
In ScopeTechnical: ITEM_LOC_HIST_MTH | ID: OR-ITM-ITEM_LOC_HIST_MTH-ITEM_LOCATION_HISTORY_MTH
Stores item location history 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_LOC_HIST_MTH
Field Definitions(5)
Rules & Considerations(23)
constraint
validation
Sample Load Data(4)
| _scenario | LOCR | ITEMR | LAST_UPDATE_IDR | CREATE_DATETIMER | LAST_UPDATE_DATETIMER | GP | STOCK | VALUE | RETAIL | AV_COST | EOM_DATE | LOC_TYPE | YEAR_454 | MONTH_454 | SALES_TYPE | SALES_ISSUES |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | SAMPLE | 2026-01-01 | 2026-01-01 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 2026-01-01 | S | 1 | 1 | S | 1.0000 |
| default | 3 | Item Loc Hist Mth-002-ALT | MDM_USER | 2026-01-03 | 2026-01-03 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 2026-01-03 | S | 3 | 3 | R | 12.5000 |
| default | 5 | Item Loc Hist Mth-003-EDG | BATCH_USER | 2026-01-05 | 2026-01-05 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 2026-01-05 | S | 5 | 5 | R | 14.0000 |
Example values from field definitions
- LOCR
- 1
- ITEMR
- SAMPLE
- LAST_UPDATE_IDR
- SAMPLE
- CREATE_DATETIMER
- 2026-01-01
- LAST_UPDATE_DATETIMER
- 2026-01-01
- GP
- 1.0000
- STOCK
- 1.0000
- VALUE
- 1.0000
- RETAIL
- 1.0000
- AV_COST
- 1.0000
- EOM_DATE
- 2026-01-01
- LOC_TYPE
- S
- YEAR_454
- 1
- MONTH_454
- 1
- SALES_TYPE
- S
- SALES_ISSUES
- 1.0000
default
- LOCR
- 3
- ITEMR
- Item Loc Hist Mth-002-ALT
- LAST_UPDATE_IDR
- MDM_USER
- CREATE_DATETIMER
- 2026-01-03
- LAST_UPDATE_DATETIMER
- 2026-01-03
- GP
- 12.5000
- STOCK
- 12.5000
- VALUE
- 12.5000
- RETAIL
- 12.5000
- AV_COST
- 12.5000
- EOM_DATE
- 2026-01-03
- LOC_TYPE
- S
- YEAR_454
- 3
- MONTH_454
- 3
- SALES_TYPE
- R
- SALES_ISSUES
- 12.5000
default
- LOCR
- 5
- ITEMR
- Item Loc Hist Mth-003-EDG
- LAST_UPDATE_IDR
- BATCH_USER
- CREATE_DATETIMER
- 2026-01-05
- LAST_UPDATE_DATETIMER
- 2026-01-05
- GP
- 14.0000
- STOCK
- 14.0000
- VALUE
- 14.0000
- RETAIL
- 14.0000
- AV_COST
- 14.0000
- EOM_DATE
- 2026-01-05
- LOC_TYPE
- S
- YEAR_454
- 5
- MONTH_454
- 5
- SALES_TYPE
- R
- SALES_ISSUES
- 14.0000
Rule Validation Summary
- Source Rule Count
- 53
- Governed Rule Count
- 23