How Siebel CRM Creates a Many-To-Many Relationship

The following figure describes how Siebel CRM uses properties in two links to create a many-to-many relationship. In this example, the relationship is between opportunities and contacts.

Explanation of Callouts

Siebel CRM uses the following objects to create a many-to-many relationship:

1. OPTY_ID column. The following properties reference the OPTY_ID column in the S_OPTY_CON table:

   • The Inter Child Column property of the Contact/Opportunity link

   • The Inter Parent Column property of the Opportunity/Contact link

2. PER_ID column. The following properties reference the PER_ID column in the S_OPTY_CON table:

   • The Inter Parent Column property of the Contact/Opportunity link

   • The Inter Child Column property of the Opportunity/Contact link

3. Contact business component. The following properties reference the Contact business component:

   • The Parent Business Component property of the Contact/Opportunity link

   • The Child Business Component property of the Opportunity/Contact link

4. Opportunity business component. The following properties reference the Opportunity business component:

   • The Child Business Component property of the Contact/Opportunity link

   • The Parent Business Component property of the Opportunity/Contact link