Vehicle
This ERD (see the following figure) illustrates how Siebel Automotive tracks the configuration and relationships associated with a vehicle. Vehicles represent a physical asset based on a product that can be related to one or more contacts, organizations, accounts, and positions. In addition to the attributes inherited from the product upon which it is based, a vehicle can also have one or more options (also products) associated with it. A vehicle's sales history, financial detail, service history and service requests can be tracked through its life cycle.

The following table lists the entities in this ERD and their corresponding tables.
Entity | Table |
---|---|
Asset |
S_ASSET |
Contact |
S_CONTACT, S_PARTY |
Dealer |
S_ORG_EXT, S_PARTY |
Features |
S_PROD_SPEC |
Financial Detail |
S_VHCL_FIN_DTL |
Installed Option |
S_ASSET_REL |
Option |
S_PROD_REL |
Position |
S_POSITION, S_PARTY |
Product |
S_PROD_INT |
Product Features |
S_PROD_SPEC |
Sales History |
S_VHCL_SALES |
Service History |
S_VHCL_SRV |
Service Request |
S_SRV_REQ |
Specifications |
S_PROD_SPEC |
Vehicle |
S_ASSET, S_ASSET_ATX |
Vehicle Product |
S_PROD_INT |