Asset Management
This ERD (see the following figure) illustrates how Siebel Business Applications track instances of assets. The diagram shows how internal products can be made into assets and associated with an account or a contact to register ownership. Additional relationships can be made between assets and accounts, contacts, and employees. Additional information includes the related opportunities, the current business or personal address location of the asset, notes, and related assets. There are also relationships with service requests, activities, and related part movements.

The following table shows the entities in this ERD and their corresponding tables.
Entity | Table |
---|---|
Activity |
S_EVT_ACT |
Activity Part Movement |
S_ACTPART_MVMT |
Asset Contact Relationship |
S_ASSET_CON |
Asset Employee Relationship |
S_ASSET_EMP |
Asset External Organization |
S_ASSET_ACCNT |
Asset Feature |
S_ASSET_FEA |
Asset Modification |
S_ASSET_TXN |
Asset Relationship |
S_ASSET_REL |
Business Address |
S_ADDR_ORG (Siebel Cross-Industry Applications) S_ADDR_PER (Siebel Industry Applications) |
Competitive Metric |
S_CMPT_MTRC |
Competitive Product Feature |
S_CMPT_PROD_FEA |
Contact |
S_CONTACT, S_PARTY |
Employee |
S_EMP_PER, S_CONTACT, S_PARTY |
External Product |
S_PROD_EXT |
Internal Product |
S_PROD_INT |
Opportunity |
S_OPTY |
Opportunity Asset |
S_OPTY_ASSET |
Person |
S_CONTACT, S_PARTY |
Personal Address |
S_ADDR_PER |
Product Instance (Asset) |
S_ASSET |
Service Request |
S_SRV_REQ |