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(26)

Rules & Considerations(24)

constraint

validation

Sample Load Data(4)

_scenario	ROW_SEQR	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

Example values from field definitions

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

Rule Validation Summary

Source Rule Count: 31
Governed Rule Count: 24

All objects