Component Price History (Service Layer)

In Scope

Technical: SVC_COMP_PRICE_HIST | ID: OR-PRC-SVC_COMP_PRICE_HIST-COMPONENT_PRICE_HISTORY_SERVICE_LAYER

This is a staging table used for Admin API spreadsheet upload process.It is used to temporarily hold data before it is uploaded/updated in COMP_PRICE_HIST.

See how this object fits into Pricing & Promotions

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

Field Definitions(5)

Rules & Considerations(20)

constraint

validation

Sample Load Data(4)

_scenario	ROW_SEQRPK	CHUNK_IDR	PROCESS_IDRPK	ITEM	ACTION	REC_DATE	REF_ITEM	CREATE_ID	COMP_STORE	OFFER_TYPE	COMP_RETAIL	LAST_UPD_ID	MULTI_UNITS	PROM_END_DATE	PROCESS$STATUS	CREATE_DATETIME	PROM_START_DATE	COMP_RETAIL_TYPE	LAST_UPD_DATETIME	MULTI_UNIT_RETAIL
Example values from field definitions	1	1	1	SAMPLE	SAMPLE	2026-01-01	SAMPLE	SAMPLE	1	SAMPLE	1.0000	SAMPLE	1.0000	2026-01-01	SAMPLE	2026-01-01	2026-01-01	SAMPLE	2026-01-01	1.0000
default	3	1000000003	1000000003	Svc Comp Price Hist-002-A	Svc Comp P	2026-01-03	Svc Comp Price Hist-002-A	USER	1003	Svc Co	12.5000	USER	12.5000	2026-01-03	N	2026-01-03	2026-01-03	R	2026-01-03	12.5000
default	5	1000000005	1000000005	Svc Comp Price Hist-003-E	Svc Comp P	2026-01-05	Svc Comp Price Hist-003-E	USER	1005	Svc Co	14.0000	USER	14.0000	2026-01-05	N	2026-01-05	2026-01-05	R	2026-01-05	14.0000

Example values from field definitions

ROW_SEQRPK: 1
CHUNK_IDR: 1
PROCESS_IDRPK: 1
ITEM: SAMPLE
ACTION: SAMPLE
REC_DATE: 2026-01-01
REF_ITEM: SAMPLE
CREATE_ID: SAMPLE
COMP_STORE: 1
OFFER_TYPE: SAMPLE
COMP_RETAIL: 1.0000
LAST_UPD_ID: SAMPLE
MULTI_UNITS: 1.0000
PROM_END_DATE: 2026-01-01
PROCESS$STATUS: SAMPLE
CREATE_DATETIME: 2026-01-01
PROM_START_DATE: 2026-01-01
COMP_RETAIL_TYPE: SAMPLE
LAST_UPD_DATETIME: 2026-01-01
MULTI_UNIT_RETAIL: 1.0000

default

ROW_SEQRPK: 3
CHUNK_IDR: 1000000003
PROCESS_IDRPK: 1000000003
ITEM: Svc Comp Price Hist-002-A
ACTION: Svc Comp P
REC_DATE: 2026-01-03
REF_ITEM: Svc Comp Price Hist-002-A
CREATE_ID: USER
COMP_STORE: 1003
OFFER_TYPE: Svc Co
COMP_RETAIL: 12.5000
LAST_UPD_ID: USER
MULTI_UNITS: 12.5000
PROM_END_DATE: 2026-01-03
PROCESS$STATUS: N
CREATE_DATETIME: 2026-01-03
PROM_START_DATE: 2026-01-03
COMP_RETAIL_TYPE: R
LAST_UPD_DATETIME: 2026-01-03
MULTI_UNIT_RETAIL: 12.5000