FND_MAP_FLEX_DFF_COLUMNS

Stores map information about descriptive flexfield context-specific columns in source and its corresponding ones defined in Fusion

Details

• Schema: FUSION

• Object owner: FUSION

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
FND_MAP_FLEX_DFF_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_DFF_CODE	VARCHAR2	40			Source Descriptive Flexfield Name
S_CONTEXT_CODE	VARCHAR2	30			Source Descriptive Flexfield Context
S_COLUMN_NAME	VARCHAR2	30		Yes	Source Descriptive Flexfield Application Column Name
S_FORMAT_TYPE	VARCHAR2	10		Yes	Source Format Type
T_APPLICATION_ID	NUMBER		18		Target Application Id
T_DFF_CODE	VARCHAR2	40			Target Descriptive Flexfield Code
T_CONTEXT_CODE	VARCHAR2	80			Target Descriptive Flexfield Context Code
T_COLUMN_NAME	VARCHAR2	30			Target Descriptive Flexfield Application Column Name
T_FORMAT_TYPE	VARCHAR2	10		Yes	Target Format Type
MODULE_ID	VARCHAR2	32			Target 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_DFF_COLUMNS	fnd_map_flex_dff	PARENT_MAP_ID

Indexes

Index	Uniqueness	Tablespace	Columns
FND_MAP_FLEX_DFF_COLUMNS_U2	Unique	Default	MAP_ID
FND_MAP_FLEX_DFF_COLUMNS_U3	Unique	Default	PARENT_MAP_ID, S_CONTEXT_CODE, S_COLUMN_NAME