Siebel Object Types Reference > Siebel Object Types Reference > EIM Interface Table Object Types >
Foreign Key Mapping
A foreign key mapping identifies a foreign key column in the destination table that an interface table populates. Siebel Enterprise Integration Manager (EIM) uses this object type. For more information, see Siebel Enterprise Integration Manager Administration Guide. CAUTION: You must not modify this object type. Any modifications can adversely affect performance.
This object type occurs in the following location in the object hierarchy:
Table 113 describes properties that Siebel CRM uses with a foreign key mapping.
Table 113. Properties of the Foreign Key Mapping
|
|
EIM Foreign Key Proc Column (S) |
Specifies the name of the column that EIM uses as the foreign key. |
Export Only (O) |
If TRUE, then the Foreign Key Mapping Column object definitions identify user key columns to the interface table so that Siebel CRM gets foreign key values when an export occurs. Each Foreign Key Mapping Column object definition identifies part of the user key columns that Siebel CRM uses to locate rows in the table that the foreign key references. The combination of user key columns uniquely identifies rows in this table. |
Foreign Key Column Name (S) |
Specifies the name of the column that Siebel CRM uses as the foreign key. |
Name (S) |
Specifies the name of the foreign key column. |
Override Ref Column Name (S) |
Specifies the name of the column that Siebel CRM uses to override the value that the EIM Foreign Key Proc Column property contains. |
User Key Name (S) |
Specifies the name of the user key column that Siebel CRM finds in the user key index. |
|