Item Price History
In ScopeTechnical: ITEM_PRICE_HISTORY | ID: OR-STO-ITEM_PRICE_HISTORY-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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- ITEM_PRICE_HISTORY
Field Definitions(31)
Rules & Considerations(31)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | 2026-01-01 | 1 | 1.0000 | 1.0000 | 2026-01-01 | 1 | 1 | 1 | 2026-01-01 | SAMP | SAM | SAMPLE | 2026-01-01 | 1 | 1 | 1 | 1.0000 | 1 | 1 | 1 | 1 | SAMPLE | 1 | 1 | SAMP | SAMPLE | 1 | SAM |
Example values from field definitions
- IDRPK
- 1
- ITEM_IDR
- SAMPLE
- STORE_IDR
- 1
- END_DATE
- 2026-01-01
- PRICE_TYPE
- 1
- MULTI_UNITS
- 1.0000
- PRICE_VALUE
- 1.0000
- UPDATE_DATE
- 2026-01-01
- CLEARANCE_ID
- 1
- PROMOTION_ID
- 1
- ITEM_PRICE_ID
- 1
- EFFECTIVE_DATE
- 2026-01-01
- MULTI_UNIT_UOM
- SAMP
- PRICE_CURRENCY
- SAM
- PROMOTION_NAME
- SAMPLE
- PRICE_POST_DATE
- 2026-01-01
- PROMO_COMP_TYPE
- 1
- STORE_REQUESTED
- 1
- MULTI_UNIT_CHANGE
- 1
- MULTI_UNIT_RETAIL
- 1.0000
- PROMOTION_COMP_ID
- 1
- PROMO_COMP_DTL_ID
- 1
- EXT_PRICE_EVENT_ID
- 1
- RESET_CLEARANCE_ID
- 1
- PROMOTION_COMP_NAME
- SAMPLE
- PROMO_DURATION_TYPE
- 1
- SELLING_UNIT_CHANGE
- 1
- PRICE_UNIT_OF_MEASURE
- SAMP
- PROMOTION_DESCRIPTION
- SAMPLE
- REGULAR_PRICE_CHANGE_ID
- 1
- MULTI_UNIT_RETAIL_CURRENCY
- SAM
Rule Validation Summary
- Source Rule Count
- 40
- Governed Rule Count
- 31