Item Supp Country Location Custom Flex Attribute Extension

In Scope

Technical: ITEM_SUPP_COUNTRY_LOC_CFA_EXT | ID: OR-ITM-ITEM_SUPP_COUNTRY_LOC_CFA_EXT-ITEM_SUPP_COUNTRY_LOCATION_CUSTOM_FLEX_ATTRIBUTE_EXTENSION

This is the custom attribute extension table for the entity ITEM_SUPP_COUNTRY.

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

Field Definitions(5)

Rules & Considerations(41)

validation

constraint

Sample Load Data(4)

_scenario	LOCR	ITEMRPK	GROUP_IDR	SUPPLIERR	ORIGIN_COUNTRY_IDR	DATE_21	DATE_22	DATE_23	DATE_24	DATE_25	CREATE_ID	NUMBER_11	NUMBER_12	NUMBER_13	NUMBER_14	NUMBER_15	NUMBER_16	NUMBER_17	NUMBER_18	NUMBER_19	NUMBER_20	VARCHAR2_1	VARCHAR2_2	VARCHAR2_3	VARCHAR2_4	VARCHAR2_5	VARCHAR2_6	VARCHAR2_7	VARCHAR2_8	VARCHAR2_9	LAST_UPD_ID	VARCHAR2_10	CREATE_DATETIME	LAST_UPD_DATETIME
Example values from field definitions	1	SAMPLE	1	1	SAM	2026-01-01	2026-01-01	2026-01-01	2026-01-01	2026-01-01	SAMPLE	1	1	1	1	1	1	1	1	1	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	2026-01-01	2026-01-01
default	3	Item Supp Country Loc Cfa	1000000003	3	ALT	2026-01-03	2026-01-03	2026-01-03	2026-01-03	2026-01-03	APP_USER_ID	3	3	3	3	3	3	3	3	3	3	Item Supp Country Loc Cfa Ext-002-ALT	Item Supp Country Loc Cfa Ext-002-ALT	Item Supp Country Loc Cfa Ext-002-ALT	Item Supp Country Loc Cfa Ext-002-ALT	Item Supp Country Loc Cfa Ext-002-ALT	Item Supp Country Loc Cfa Ext-002-ALT	Item Supp Country Loc Cfa Ext-002-ALT	Item Supp Country Loc Cfa Ext-002-ALT	Item Supp Country Loc Cfa Ext-002-ALT	APP_USER_ID	Item Supp Country Loc Cfa Ext-002-ALT	2026-01-03	2026-01-03
default	5	Item Supp Country Loc Cfa	1000000005	5	EDG	2026-01-05	2026-01-05	2026-01-05	2026-01-05	2026-01-05	USERENV	5	5	5	5	5	5	5	5	5	5	Item Supp Country Loc Cfa Ext-003-EDGE	Item Supp Country Loc Cfa Ext-003-EDGE	Item Supp Country Loc Cfa Ext-003-EDGE	Item Supp Country Loc Cfa Ext-003-EDGE	Item Supp Country Loc Cfa Ext-003-EDGE	Item Supp Country Loc Cfa Ext-003-EDGE	Item Supp Country Loc Cfa Ext-003-EDGE	Item Supp Country Loc Cfa Ext-003-EDGE	Item Supp Country Loc Cfa Ext-003-EDGE	USERENV	Item Supp Country Loc Cfa Ext-003-EDGE	2026-01-05	2026-01-05

Example values from field definitions

LOCR: 1
ITEMRPK: SAMPLE
GROUP_IDR: 1
SUPPLIERR: 1
ORIGIN_COUNTRY_IDR: SAM
DATE_21: 2026-01-01
DATE_22: 2026-01-01
DATE_23: 2026-01-01
DATE_24: 2026-01-01
DATE_25: 2026-01-01
CREATE_ID: SAMPLE
NUMBER_11: 1
NUMBER_12: 1
NUMBER_13: 1
NUMBER_14: 1
NUMBER_15: 1
NUMBER_16: 1
NUMBER_17: 1
NUMBER_18: 1
NUMBER_19: 1
NUMBER_20: 1
VARCHAR2_1: SAMPLE
VARCHAR2_2: SAMPLE
VARCHAR2_3: SAMPLE
VARCHAR2_4: SAMPLE
VARCHAR2_5: SAMPLE
VARCHAR2_6: SAMPLE
VARCHAR2_7: SAMPLE
VARCHAR2_8: SAMPLE
VARCHAR2_9: SAMPLE
LAST_UPD_ID: SAMPLE
VARCHAR2_10: SAMPLE
CREATE_DATETIME: 2026-01-01
LAST_UPD_DATETIME: 2026-01-01

default

LOCR: 3
ITEMRPK: Item Supp Country Loc Cfa
GROUP_IDR: 1000000003
SUPPLIERR: 3
ORIGIN_COUNTRY_IDR: ALT
DATE_21: 2026-01-03
DATE_22: 2026-01-03
DATE_23: 2026-01-03
DATE_24: 2026-01-03
DATE_25: 2026-01-03
CREATE_ID: APP_USER_ID
NUMBER_11: 3
NUMBER_12: 3
NUMBER_13: 3
NUMBER_14: 3
NUMBER_15: 3
NUMBER_16: 3
NUMBER_17: 3
NUMBER_18: 3
NUMBER_19: 3
NUMBER_20: 3
VARCHAR2_1: Item Supp Country Loc Cfa Ext-002-ALT
VARCHAR2_2: Item Supp Country Loc Cfa Ext-002-ALT
VARCHAR2_3: Item Supp Country Loc Cfa Ext-002-ALT
VARCHAR2_4: Item Supp Country Loc Cfa Ext-002-ALT
VARCHAR2_5: Item Supp Country Loc Cfa Ext-002-ALT
VARCHAR2_6: Item Supp Country Loc Cfa Ext-002-ALT
VARCHAR2_7: Item Supp Country Loc Cfa Ext-002-ALT
VARCHAR2_8: Item Supp Country Loc Cfa Ext-002-ALT
VARCHAR2_9: Item Supp Country Loc Cfa Ext-002-ALT
LAST_UPD_ID: APP_USER_ID
VARCHAR2_10: Item Supp Country Loc Cfa Ext-002-ALT
CREATE_DATETIME: 2026-01-03
LAST_UPD_DATETIME: 2026-01-03