Bookshelf v7.5: Integration Components

The EAI Account integration object incorporates five integration components: Account, Account_Business Address, Account_Organization, Account_Position, and Contact. A Price List can be associated with an Account, and an Organization can be associated with a Contact.

In Figure 19, Account is the central element in the Account integration object. Using this integration object, you can insert, update, or delete information from the account integration component. Account is the primary integration component for this integration object.

Similarly, new rows can be inserted or existing rows updated in the Business Address and Contact entities at the same time that rows are inserted or updated in the Account component. When an account is deleted, all addresses associated with that account are also deleted. However, when an account is deleted, the contact associated with that account is not deleted. The association between the account and contact is deleted. As Figure 19 indicates, the relationship between account and contact is many-to-many. Thus, when an account is deleted, the contact associated with this account might be associated with other accounts that are still there in the system.

The relationship between Account/Position and Account/Organization is made through an association. This means that you can not create, update, or delete positions or organizations using this integration object. In other words, when an account is associated with a position or organization, that particular position or organization must already exist in the Siebel database.

Account also has a one-to-many relationship with Price List. This means that a foreign key to Price List (named Price List Id) exists in the Account component. This relationship is implemented through the picklist. An existing Price List can be identified by any one of the following three fields: Price List Id (the foreign key), Price List (the name), or Price List Int Id (the integration id).

Similarly, the relationship between contact and organization is implemented through a picklist. As in Price List, three organization related fields are added to the contact component: Organization Id, Organization, and Contact Organization Integration Id. You can see this in Table 12.

Table 12. Integration Components
Integration Component	Business Component	XML Tag	User Keys	Comments
Account		Account	1. Id 2. Integration Id 3. Location, Name 4. CSN	Account is the Primary Integration Component
Account_ Business Address	Business Address	Account_ BusinessAddres	1. Address Id 2. Address Integration Id
Account _Organization	Internal Division	Account_ Organization	1. Organization Id 2. Organization Integration Id 3. Organization
Account_ Position	Position	Account_ Position	1. Position Id 2. Position Integration Id 3. Position
Contact	Contact	Contact	1. Id 2. Integration Id