Database fields used by e-Bills
It would not be practical to provide a full listing of all the database
fields we use. Needless to say the database contents have been carefully
considered to provide excellent performance and functionality.
The following is a summary of the main database tables
|
Database
|
Purpose & contents
|
|
Customers
|
Manage customer names, addresses and other business data
- Customer name
- ID
- Address
- Contact details
- Billing method (post, email or fax)
|
|
Contracts
|
Manage contracts held, including type, start/end date and
billing dates
- Contract reference
- Start and end
- Billing dates
- Billing frequency
|
|
Products
|
Manage all standard products & services that your
business offers, including price and basis for billing
- Product code
- Description
- Price
- Charge frequency
- Setup and final charges
|
|
Charges
|
All charges, special charges, refunds or discounts that
have been applied to a customer's contract
- Product code
- Price charged
- Applicable discounts
- Date applied
|
|
Bills issued
|
Log of all bills issued by customer contract / date to
assist will billing enquiries
- Date of bill
- Bill reference number
- Net value of bill
- File name of Adobe® Portable Document Format (PDF) bills
|
|
Payments made
|
Stores a record of payments made by each customer
- Customer and contract references
- Amount paid
- Amount still owed
- Invoice number
- Timestamp
|
|
Notes
|
Store notes entered by users against customer or contract records
- Customer and contract references
- Text
- Status & priority
- Timestamp
|
|
Contact history
|
Contact history with each customer
- Customer reference
- Type of contact (letter, invoice, call, document received
- Contact details
- User who dealt with contact
- Timestamp
|
|
Users
|
Control access to the system and ensure functionality is
given to the appropriate class of user
- User names and passwords
- User type
- User status
- Login information
|
MySQL supports multiple databases and this applies to multiple e-Bills tables.
This allows one server to handle the billing for multiple legal entities
within your organisation or produce bills for different parts of the business
or operate in an ASP environment.
|
|