Store Item Price Snapshot

In Scope

Technical: STORE_ITEM_PRICE_SNAPSHOT | ID: OR-STO-STORE_ITEM_PRICE_SNAPSHOT-STORE_ITEM_PRICE_SNAPSHOT

Provides historical Store Item Price Snapshot records used for Oracle Retail reporting, reconciliation, and downstream processing in STORE_ITEM_PRICE_SNAPSHOT.

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

Field Definitions(5)

Rules & Considerations(21)

validation

constraint

Sample Load Data(4)

_scenario	ITEM_IDRPK	STORE_IDRPK	SELLING_UOMR	PRICE_CURRENCYR	SELLING_UNIT_RETAILR	CLEAR_IND	MULTI_UNITS	SNAPSHOT_DATE	MULTI_SELLING_UOM	MULTI_UNIT_RETAIL	PROMO_SELLING_UOM	REGULAR_UNIT_RETAIL	PROMO_SELLING_RETAIL
Example values from field definitions	SAMPLE	1	SAMP	SAM	1.0000	S	1.0000	2026-01-01	SAMP	1.0000	SAMP	1.0000	1.0000
default	ALT-STORE_ITEM-002	1000000003	Stor	Sto	12.5000	N	12.5000	2026-01-03	Stor	12.5000	Stor	12.5000	12.5000
default	EDGE-STORE_ITEM-003	1000000005	Stor	Sto	14.0000	N	14.0000	2026-01-05	Stor	14.0000	Stor	14.0000	14.0000

Example values from field definitions

ITEM_IDRPK: SAMPLE
STORE_IDRPK: 1
SELLING_UOMR: SAMP
PRICE_CURRENCYR: SAM
SELLING_UNIT_RETAILR: 1.0000
CLEAR_IND: S
MULTI_UNITS: 1.0000
SNAPSHOT_DATE: 2026-01-01
MULTI_SELLING_UOM: SAMP
MULTI_UNIT_RETAIL: 1.0000
PROMO_SELLING_UOM: SAMP
REGULAR_UNIT_RETAIL: 1.0000
PROMO_SELLING_RETAIL: 1.0000

default

ITEM_IDRPK: ALT-STORE_ITEM-002
STORE_IDRPK: 1000000003
SELLING_UOMR: Stor
PRICE_CURRENCYR: Sto
SELLING_UNIT_RETAILR: 12.5000
CLEAR_IND: N
MULTI_UNITS: 12.5000
SNAPSHOT_DATE: 2026-01-03
MULTI_SELLING_UOM: Stor
MULTI_UNIT_RETAIL: 12.5000
PROMO_SELLING_UOM: Stor
REGULAR_UNIT_RETAIL: 12.5000
PROMO_SELLING_RETAIL: 12.5000