FND_MAP_FLEX_KFF_COLUMNS

Stores information about key flexfield columns in source mapped to its corresponding ones in Fusion

Details

• Schema: FUSION

• Object owner: FUSION

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
FND_MAP_FLEX_KFF_COLUMNS_PK	MAP_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
MAP_ID	VARCHAR2	64		Yes	Map Identifier
PARENT_MAP_ID	VARCHAR2	64		Yes	Parent Map Identifier
S_TYPE	VARCHAR2	1			Source
S_APPLICATION_ID	NUMBER		15		Source Application Id
S_KFF_CODE	VARCHAR2	4			Source Key Flexfield Code
S_STRUCTURE_CODE	VARCHAR2	30			Source Developer Key for Key Flexfield Structure
S_COLUMN_NAME	VARCHAR2	30		Yes	Source Flexfield Column Name
S_FORMAT_TYPE	VARCHAR2	10		Yes	Source Format Type
T_APPLICATION_ID	NUMBER		18		Target Application Id
T_KFF_CODE	VARCHAR2	4			Target Key Flexfield Code
T_STRUCTURE_CODE	VARCHAR2	30			Target Developer Key for Key Flexfield Structure
T_COLUMN_NAME	VARCHAR2	30			Target Flexfield Column Name
T_FORMAT_TYPE	VARCHAR2	10		Yes	Target Format Type
MODULE_ID	VARCHAR2	32			Module Id
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32		Yes	Who column: indicates the session login associated to the user who last updated the row.

Foreign Keys

Table	Foreign Table	Foreign Key Column
FND_MAP_FLEX_KFF_COLUMNS	fnd_map_flex_kff	PARENT_MAP_ID

Indexes

Index	Uniqueness	Tablespace	Columns
FND_MAP_FLEX_KFF_COLUMNS_U2	Unique	Default	MAP_ID
FND_MAP_FLEX_KFF_COLUMNS_U3	Unique	Default	PARENT_MAP_ID, S_STRUCTURE_CODE, S_COLUMN_NAME