Item Price History
In ScopeTechnical: ITEM_PRICE_HISTORY | ID: OR-SIOCS-ITEM_PRICE_HISTORY
Stores historical archive of the retail-selling unit price at which a given item is being sold.
See how this object fits into Store Operations
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
- ITEM_PRICE_HISTORY
Field Definitions(31)
Rules & Considerations(73)
Sample Load Data(4)
| _scenario | IDRPK | ITEM_IDR | STORE_IDR | END_DATE | PRICE_TYPE | MULTI_UNITS | PRICE_VALUE | UPDATE_DATE | CLEARANCE_ID | PROMOTION_ID | ITEM_PRICE_ID | EFFECTIVE_DATE | MULTI_UNIT_UOM | PRICE_CURRENCY | PROMOTION_NAME | PRICE_POST_DATE | PROMO_COMP_TYPE | STORE_REQUESTED | MULTI_UNIT_CHANGE | MULTI_UNIT_RETAIL | PROMOTION_COMP_ID | PROMO_COMP_DTL_ID | EXT_PRICE_EVENT_ID | RESET_CLEARANCE_ID | PROMOTION_COMP_NAME | PROMO_DURATION_TYPE | SELLING_UNIT_CHANGE | PRICE_UNIT_OF_MEASURE | PROMOTION_DESCRIPTION | REGULAR_PRICE_CHANGE_ID | MULTI_UNIT_RETAIL_CURRENCY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | STD-ITEM_PRICE-001 | 1000000001 | 2026-01-01 | 200 | 11.0000 | 11.0000 | 2026-01-01 | 1000000001 | 1000000001 | 1000000001 | 2026-01-01 | Item Price History-001 | Item Price History-001 | Item Price History Primary | 2026-01-01 | 0 | 0 | 0 | 11.0000 | 1000000001 | 1000000001 | 1000000001 | 1000000001 | Item Price History Primary | 01 | 1 | Item Price History-001 | Item Price History: Baseline migration row | 1000000001 | Item Price History-001 |
default
- IDRPK
- 1
- ITEM_IDR
- STD-ITEM_PRICE-001
- STORE_IDR
- 1000000001
- END_DATE
- 2026-01-01
- PRICE_TYPE
- 200
- MULTI_UNITS
- 11.0000
- PRICE_VALUE
- 11.0000
- UPDATE_DATE
- 2026-01-01
- CLEARANCE_ID
- 1000000001
- PROMOTION_ID
- 1000000001
- ITEM_PRICE_ID
- 1000000001
- EFFECTIVE_DATE
- 2026-01-01
- MULTI_UNIT_UOM
- Item Price History-001
- PRICE_CURRENCY
- Item Price History-001
- PROMOTION_NAME
- Item Price History Primary
- PRICE_POST_DATE
- 2026-01-01
- PROMO_COMP_TYPE
- 0
- STORE_REQUESTED
- 0
- MULTI_UNIT_CHANGE
- 0
- MULTI_UNIT_RETAIL
- 11.0000
- PROMOTION_COMP_ID
- 1000000001
- PROMO_COMP_DTL_ID
- 1000000001
- EXT_PRICE_EVENT_ID
- 1000000001
- RESET_CLEARANCE_ID
- 1000000001
- PROMOTION_COMP_NAME
- Item Price History Primary
- PROMO_DURATION_TYPE
- 01
- SELLING_UNIT_CHANGE
- 1
- PRICE_UNIT_OF_MEASURE
- Item Price History-001
- PROMOTION_DESCRIPTION
- Item Price History: Baseline migration row
- REGULAR_PRICE_CHANGE_ID
- 1000000001
- MULTI_UNIT_RETAIL_CURRENCY
- Item Price History-001