Foreign Key Mapping Properties of Foreign Key Columns on the Target Table

The following table describes the properties of each foreign key mapping that EIM creates for each foreign key mapping column on the target table.

Property	Value
Name	Name of the user key column.
Foreign Key Column	Name of the user key column.
User Key	Name of the U1 user key of the foreign key table.
EIM Foreign Key Proc Column	Corresponding EIM interface table column for foreign key processing derived from the following format: T_PART ONE_NAME OF THE USER KEY COLUMN where: PART ONE is the name of the target table without the CX_ prefix.

The following table describes the foreign key mapping, using the CX_SEC_LEV table as an example.

Name	Foreign Key Column	User Key	EIM Foreign Key Proc Column
OPTY_ID	OPTY_ID	S_OPTY_U1	T_SEC_LEV_OPTY_ID
ACCNT_ID	ACCNT_ID	S_ORG_EXT_U1	T_SEC_LEV_ACCNT_ID