&ERWauth;
Account types, to distinguish between credit and debit accounts.
The classification of different accounts.
Status values for invoices, indicating their current disposition.
Standard payment types.
Types for indicating the nature of a particular electronic
contact.
Enumeration of US states, used for validation.
Enumeration of country abbreviations for validation.
This is a reference table for determining basic billing cycles. Most customers
wish to be billed on a monthly basis. The default values in this table reflect
this by describing weeks without overlapping months.
This table contains account information, to which all transactions are posted.
This contains employee information.
Customer information, other than contact information.
This contains nformation on vendors.
An employee can be contacted in a variety of ways. In combination with the
enumerated types, this table contains all relevent contact information.
This contains customer contact information, similar to the employee contact
table econtact.
This contains vendor contact information. This allows the user to specify
zero or more email addresses, phone numbers, etc.
This is the table of employee timesheets. It records daily information which
can be used in generating invoices.
This is the table of expenses, along with an indication as to whether the expense
can be billed to the client.
This is the table of credits issued to customers. This may happen in the
case of a rebate or refund to be issued.
This table holds project information for a company. Each company can have
zero or more projects, but a project belings to one company.
This is the invoice header table, and contains basic invoice information.
This is the payments table. It records all payments made by customers
on invoices.
This is the basic transaction table.
This is used to relate a employee to his or her contact info.
This is used to relate a customer with his or her contact info.
This is used to relate a vendor with his or her contact info.
This is used to relate projects to invoices.
This is used to relate a time record to a particular project.
This is used to relate expenses to projects.
This is used to specify the invoice credits.
This is used to specify the employee's timesheet info.
This is used to allocate expenses to employees.
This is used to specify the employee's rate info for a project. During the
lifetime of a project, an employee's rate may be adjusted, so the
date range is necessary.
This is used to relate an expense to a vendor.
This is used to identify which customer owns which project.
This is used to relate customers to payments.
This is used to allocate payments to accounts.
This is used to allocate payments to accounts.
This is used to allocate expenses to accounts.
This is used as a general transaction for internal payments.