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.

Universal Customer Master: This image is described in the surrounding text.

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