The chart to the right represents the organization of tables in the SPC database. The primary philosophy behind it is to allow company, agent and supplier growth and change, while providing a means whereby sales history can remain a static archive.
This is accomplished by tying the sales transactions to the various profiles, rather than to the master records. If the agent's information changes, a new agent profile is generated and made active. New sales by the agent then reference the active profile, and are bound to it.
Below is a short description of each table.
|Sales||Central table in the database, holds all sales transactions|
|Stock||Similar to the Sales table, holds purchased inventory to sell|
|Agent||Agent master file, contains, static agent information such as name.|
|Agent Profile||Variable agent information dependent on current employment status, e.g., current salary. The number of records in this table grows as the agent's career advances.|
|Region||The regions to which agents may belong or in which they are responsible for sales.|
|Plan||Employment plan master file.|
|Plan Profile||Variable employment plan information, such as commission structure. The number of records increases as the company grows and changes.|
|Vendor||Master file for vendor information.|
|Vendor Profile||Variable vendor information. Records increase as the vendor's information changes over time.|
|Vendor Month||Contains sales quota target values by month in the vendor's fiscal year. Records may increase as the vendor's quota structure changes.|
|Quota||Contains specific sales quota values as generated from both sales and stock transactions.|
|Shop||Company and user preferences, such as display screen view scale.|
|Shop Profile||Variable company information, such as standard cost margin. Records will increase as company changes.|