||Back to the Model.
The Area being Modelled is :-
This is a Statement of the User Requirements.
Database for Sales Commissions and Residuals
Question: I am trying to create a db to track a small insurance agencies
2.) sales and
3.)paying commissions and residuals to agents***most important.
I have the client info and sales records worked out, but I am stumped on
what table(s) I will need for commissions/residuals.
Each agent is paid one yr. commission in advance at time policy is written
then monthly residuals for 7 years(84 months)starting one year from effective date.
I need to be able to track this plus create a report that will show the agent the
client name, policy and amount of commission being paid, residual being paid, date
paid and check number used.
I want this to be automatically calculated in the report.
Yes, the report will end up being several pages long when an agent is receiving monthly
residuals for 100's of clients, but that is the way it has to be done.
Do I need 84 fields showing month1, month2, etc. for these residuals?
Also, if the policy cancels, the residuals stop.
Any help would be greatly appreciated.
B. The Things of Interest, ('THINGS'), include :-
C. These THINGS are Related as follows :-
D. Other Characteristics of these THINGS include :-
E. Sample Data includes :-
F. Typical Enquiries include :-