Bookshelf Home | Contents | Index | Search | PDF |
Siebel Connector for PeopleSoft > Prebuilt Integration Objects > EAI Account Integration Object >
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.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Connector for PeopleSoft Published: 18 April 2003 |