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.


e-Bills
Billing & Customer Management
Overview
Customer profile
Database overview
Features & Benefits
Samples
Old downloads
HOWTO (online)

Management Services
Billing consultancy
Project management
Web and programming

e-Bills at SourceForge
ebills.sourceforge.net
Project summary
Stats
Latest downloads
Demo register
Demo login


Legal stuff
 mailto:webmaster@asplen.co.uk

Last updated