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 |