Custom Flex Attribute Extension (Service Layer)

In Scope

Technical: SVC_CFA_EXT | ID: OR-ITM-SVC_CFA_EXT-CUSTOM_FLEX_ATTRIBUTE_EXTENSION_SERVICE_LAYER

This is the staging table for the custom flex attributes It is used to temporarily hold data before it is uploaded/updated in ITEM_MASTER_CFA_EXT, ITEM_).

See how this object fits into Item Management

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_CFA_EXT

Field Definitions(5)

Rules & Considerations(14)

constraint

validation

Sample Load Data(4)

_scenario	ROW_SEQR	CHUNK_IDR	PROCESS_IDR	BASE_RMS_TABLER	ACTION	CREATE_ID	LAST_UPD_ID	CREATE_DATETIME	LAST_UPD_DATETIME	GROUP_SET_VIEW_NAME	KEYS_COLNKEY_VAL_PAIRS37528ATTRS_COLNKEY_VAL_PAIRS37529PROCESS$STATUS
Example values from field definitions	1	1	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	2026-01-01	2026-01-01	SAMPLE	SAMPLE
default	3	1000000003	1000000003	Svc Cfa Ext-002-ALT	Svc Cfa Ex	C LIENT_INFO	C LIENT_INFO	2026-01-03	2026-01-03	Svc Cfa Ext Secondary	N
default	5	1000000005	1000000005	Svc Cfa Ext-003-EDGE	Svc Cfa Ex	USE RENV	USE RENV	2026-01-05	2026-01-05	Svc Cfa Ext Core	N

Example values from field definitions

ROW_SEQR: 1
CHUNK_IDR: 1
PROCESS_IDR: 1
BASE_RMS_TABLER: SAMPLE
ACTION: SAMPLE
CREATE_ID: SAMPLE
LAST_UPD_ID: SAMPLE
CREATE_DATETIME: 2026-01-01
LAST_UPD_DATETIME: 2026-01-01
GROUP_SET_VIEW_NAME: SAMPLE
KEYS_COLNKEY_VAL_PAIRS37528ATTRS_COLNKEY_VAL_PAIRS37529PROCESS$STATUS: SAMPLE

default

ROW_SEQR: 3
CHUNK_IDR: 1000000003
PROCESS_IDR: 1000000003
BASE_RMS_TABLER: Svc Cfa Ext-002-ALT
ACTION: Svc Cfa Ex
CREATE_ID: C LIENT_INFO
LAST_UPD_ID: C LIENT_INFO
CREATE_DATETIME: 2026-01-03
LAST_UPD_DATETIME: 2026-01-03
GROUP_SET_VIEW_NAME: Svc Cfa Ext Secondary
KEYS_COLNKEY_VAL_PAIRS37528ATTRS_COLNKEY_VAL_PAIRS37529PROCESS$STATUS: N