Component Shop List (Service Layer)

In Scope

Technical: SVC_COMP_SHOP_LIST | ID: OR-FND-SVC_COMP_SHOP_LIST-COMPONENT_SHOP_LIST_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_SHOP_LIST.

See how this object fits into Foundation Data

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_SHOP_LIST

Field Definitions(5)

Rules & Considerations(25)

constraint

validation

Sample Load Data(4)

_scenario	ROW_SEQRPK	CHUNK_IDR	PROCESS_IDRPK	ITEM	ACTION	SHOPPER	REC_DATE	REF_ITEM	COMP_NAME	CREATE_ID	ITEM_DESC	SHOP_DATE	COMPETITOR	COMP_STORE	OFFER_TYPE	COMP_RETAIL	LAST_UPD_ID	MULTI_UNITS	PROM_END_DATE	PROCESS$STATUS	COMP_STORE_NAME	CREATE_DATETIME	PROM_START_DATE	COMP_RETAIL_TYPE	LAST_UPD_DATETIME	MULTI_UNIT_RETAIL
Example values from field definitions	1	1	1	SAMPLE	SAMPLE	1	2026-01-01	SAMPLE	SAMPLE	SAMPLE	SAMPLE	2026-01-01	1	1	SAMPLE	1.0000	SAMPLE	1.0000	2026-01-01	SAMPLE	SAMPLE	2026-01-01	2026-01-01	SAMPLE	2026-01-01	1.0000
default	3	1000000003	1000000003	Svc Comp Shop List-002-AL	Svc Comp S	3	2026-01-03	Svc Comp Shop List-002-AL	Svc Comp Shop List Secondary	USER	Svc Comp Shop List-002-ALT	2026-01-03	3	1003	Svc Co	12.5000	USER	12.5000	2026-01-03	N	Svc Comp Shop List Secondary	2026-01-03	2026-01-03	P	2026-01-03	12.5000
default	5	1000000005	1000000005	Svc Comp Shop List-003-ED	Svc Comp S	5	2026-01-05	Svc Comp Shop List-003-ED	Svc Comp Shop List Core	USER	Svc Comp Shop List-003-EDGE	2026-01-05	5	1005	Svc Co	14.0000	USER	14.0000	2026-01-05	N	Svc Comp Shop List Core	2026-01-05	2026-01-05	C	2026-01-05	14.0000

Example values from field definitions

ROW_SEQRPK: 1
CHUNK_IDR: 1
PROCESS_IDRPK: 1
ITEM: SAMPLE
ACTION: SAMPLE
SHOPPER: 1
REC_DATE: 2026-01-01
REF_ITEM: SAMPLE
COMP_NAME: SAMPLE
CREATE_ID: SAMPLE
ITEM_DESC: SAMPLE
SHOP_DATE: 2026-01-01
COMPETITOR: 1
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
COMP_STORE_NAME: 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 Shop List-002-AL
ACTION: Svc Comp S
SHOPPER: 3
REC_DATE: 2026-01-03
REF_ITEM: Svc Comp Shop List-002-AL
COMP_NAME: Svc Comp Shop List Secondary
CREATE_ID: USER
ITEM_DESC: Svc Comp Shop List-002-ALT
SHOP_DATE: 2026-01-03
COMPETITOR: 3
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
COMP_STORE_NAME: Svc Comp Shop List Secondary
CREATE_DATETIME: 2026-01-03
PROM_START_DATE: 2026-01-03
COMP_RETAIL_TYPE: P
LAST_UPD_DATETIME: 2026-01-03
MULTI_UNIT_RETAIL: 12.5000