EIM Interface Table Columns for Processing a Foreign Key

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

Column	Value
Name	Derived from the target table name and the corresponding foreign key column on the target table using the following format: PART ONE FOREIGN KEY COLUMN OF THE TARGET TABLE where: PART ONE is the target table name with the CX_ prefix replaced with T_.
Type	Set to IFMGR: Fkey
Physical Type	Physical type of foreign key column of the target table, which is typically Varchar.
Length	Length of foreign key column of the target table, which is typically 15.
User Name	Derived using the following format: TARGET TABLE NAME or EIM TABLE MAPPING NAME.FOREIGN KEY COLUMN NAME

The following table describes the EIM table columns that EIM creates if the CX_SEC_LEV table contains the following foreign key column mappings:

• The OPTY_ID foreign key column mapping references the S_OPTY table

• The ACCNT_ID foreign key column mapping references the S_ORG_EXT table

Name	Physical Type	Length	Type	User Name
T_SEC_LEV_OPTY_ID	Varchar	15	IFMGR: Fkey	CX_SEC_LEV.OPTY_ID
T_SEC_LEV_ACCNT_ID	Varchar	15	IFMGR: Fkey	CX_SEC_LEV.ACCNT_ID