Fleet Management - Location

This ERD (see the following figure) illustrates how geographic locations related to fleet management can be modeled to optimize deliveries or pickups for a given location. In this model, a given location is the persons and organizations located in that general area and the addresses associated with the parties in that area.

The following table lists the entities in this ERD and their corresponding tables.

Entity	Table
Contact	S_CONTACT, S_PARTY, S_LOC_CONTACT
Account	S_ORG_EXT, S_PARTY, S_LOC_ACCNT
Address	S_ADDR_PER, S_ADDR_CON, S_LOC_ADDR
Location	S_LOCATION
Location Role	S_LOC_ROLE