Item Location Custom Flex Attribute Extension

In Scope

Technical: ITEM_LOC_CFA_EXT | ID: OR-ITM-ITEM_LOC_CFA_EXT-ITEM_LOCATION_CUSTOM_FLEX_ATTRIBUTE_EXTENSION

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

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_LOC_CFA_EXT

Field Definitions(5)

Rules & Considerations(37)

validation

constraint

Sample Load Data(4)

_scenario	LOCRPK	ITEMRPK	GROUP_IDRPK	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	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 Loc Cfa Ext-002-ALT	1000000003	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 Loc Cfa Ext-002-ALT	Item Loc Cfa Ext-002-ALT	Item Loc Cfa Ext-002-ALT	Item Loc Cfa Ext-002-ALT	Item Loc Cfa Ext-002-ALT	Item Loc Cfa Ext-002-ALT	Item Loc Cfa Ext-002-ALT	Item Loc Cfa Ext-002-ALT	Item Loc Cfa Ext-002-ALT	APP_USER_ID	Item Loc Cfa Ext-002-ALT	2026-01-03	2026-01-03
default	5	Item Loc Cfa Ext-003-EDGE	1000000005	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 Loc Cfa Ext-003-EDGE	Item Loc Cfa Ext-003-EDGE	Item Loc Cfa Ext-003-EDGE	Item Loc Cfa Ext-003-EDGE	Item Loc Cfa Ext-003-EDGE	Item Loc Cfa Ext-003-EDGE	Item Loc Cfa Ext-003-EDGE	Item Loc Cfa Ext-003-EDGE	Item Loc Cfa Ext-003-EDGE	USERENV	Item Loc Cfa Ext-003-EDGE	2026-01-05	2026-01-05

Example values from field definitions

default

LOCRPK: 3
ITEMRPK: Item Loc Cfa Ext-002-ALT
GROUP_IDRPK: 1000000003
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 Loc Cfa Ext-002-ALT
VARCHAR2_2: Item Loc Cfa Ext-002-ALT
VARCHAR2_3: Item Loc Cfa Ext-002-ALT
VARCHAR2_4: Item Loc Cfa Ext-002-ALT
VARCHAR2_5: Item Loc Cfa Ext-002-ALT
VARCHAR2_6: Item Loc Cfa Ext-002-ALT
VARCHAR2_7: Item Loc Cfa Ext-002-ALT
VARCHAR2_8: Item Loc Cfa Ext-002-ALT
VARCHAR2_9: Item Loc Cfa Ext-002-ALT
LAST_UPD_ID: APP_USER_ID
VARCHAR2_10: Item Loc Cfa Ext-002-ALT
CREATE_DATETIME: 2026-01-03
LAST_UPD_DATETIME: 2026-01-03

default

LOCRPK: 5
ITEMRPK: Item Loc Cfa Ext-003-EDGE
GROUP_IDRPK: 1000000005
DATE_21: 2026-01-05
DATE_22: 2026-01-05
DATE_23: 2026-01-05
DATE_24: 2026-01-05
DATE_25: 2026-01-05
CREATE_ID: USERENV
NUMBER_11: 5
NUMBER_12: 5
NUMBER_13: 5
NUMBER_14: 5
NUMBER_15: 5
NUMBER_16: 5
NUMBER_17: 5
NUMBER_18: 5
NUMBER_19: 5
NUMBER_20: 5
VARCHAR2_1: Item Loc Cfa Ext-003-EDGE
VARCHAR2_2: Item Loc Cfa Ext-003-EDGE
VARCHAR2_3: Item Loc Cfa Ext-003-EDGE
VARCHAR2_4: Item Loc Cfa Ext-003-EDGE
VARCHAR2_5: Item Loc Cfa Ext-003-EDGE
VARCHAR2_6: Item Loc Cfa Ext-003-EDGE
VARCHAR2_7: Item Loc Cfa Ext-003-EDGE
VARCHAR2_8: Item Loc Cfa Ext-003-EDGE
VARCHAR2_9: Item Loc Cfa Ext-003-EDGE
LAST_UPD_ID: USERENV
VARCHAR2_10: Item Loc Cfa Ext-003-EDGE
CREATE_DATETIME: 2026-01-05
LAST_UPD_DATETIME: 2026-01-05

Rule Validation Summary

Source Rule Count: 63
Governed Rule Count: 37