Item Price History Arv

In Scope

Technical: ITEM_PRICE_HISTORY_ARV | ID: OR-STO-ITEM_PRICE_HISTORY_ARV-ITEM_PRICE_HISTORY_ARV

Provides historical Item Price History Arv records used for Oracle Retail reporting, reconciliation, and downstream processing in ITEM_PRICE_HISTORY_ARV.

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_ARV

Field Definitions(5)

Rules & Considerations(31)

constraint

validation

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
default	3	ALT-ITEM_PRICE-002	1000000003	2026-01-03	3	12.5000	12.5000	2026-01-03	1000000003	1000000003	1000000003	2026-01-03	Item	Ite	Item Price History Arv Secondary	2026-01-03	3	3	3	12.5000	1000000003	1000000003	1000000003	1000000003	Item Price History Arv Secondary	3	3	Item	Item Price History Arv: Alternate source profile	1000000003	Ite
default	5	EDGE-ITEM_PRICE-003	1000000005	2026-01-05	5	14.0000	14.0000	2026-01-05	1000000005	1000000005	1000000005	2026-01-05	Item	Ite	Item Price History Arv Core	2026-01-05	5	5	5	14.0000	1000000005	1000000005	1000000005	1000000005	Item Price History Arv Core	5	5	Item	—	1000000005	Ite

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

default

IDRPK: 3
ITEM_IDR: ALT-ITEM_PRICE-002
STORE_IDR: 1000000003
END_DATE: 2026-01-03
PRICE_TYPE: 3
MULTI_UNITS: 12.5000
PRICE_VALUE: 12.5000
UPDATE_DATE: 2026-01-03
CLEARANCE_ID: 1000000003
PROMOTION_ID: 1000000003
ITEM_PRICE_ID: 1000000003
EFFECTIVE_DATE: 2026-01-03
MULTI_UNIT_UOM: Item
PRICE_CURRENCY: Ite
PROMOTION_NAME: Item Price History Arv Secondary
PRICE_POST_DATE: 2026-01-03
PROMO_COMP_TYPE: 3
STORE_REQUESTED: 3
MULTI_UNIT_CHANGE: 3
MULTI_UNIT_RETAIL: 12.5000
PROMOTION_COMP_ID: 1000000003
PROMO_COMP_DTL_ID: 1000000003
EXT_PRICE_EVENT_ID: 1000000003
RESET_CLEARANCE_ID: 1000000003
PROMOTION_COMP_NAME: Item Price History Arv Secondary
PROMO_DURATION_TYPE: 3
SELLING_UNIT_CHANGE: 3
PRICE_UNIT_OF_MEASURE: Item
PROMOTION_DESCRIPTION: Item Price History Arv: Alternate source profile
REGULAR_PRICE_CHANGE_ID: 1000000003
MULTI_UNIT_RETAIL_CURRENCY: Ite