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


Purpose & contents


Manage customer names, addresses and other business data
  • Customer name
  • ID
  • Address
  • Contact details
  • Billing method (post, email or fax)


Manage contracts held, including type, start/end date and billing dates
  • Contract reference
  • Start and end
  • Billing dates
  • Billing frequency


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


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


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


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.

Billing & Customer Management
Customer profile
Database overview
Features & Benefits
Old downloads
HOWTO (online)

Management Services
Billing consultancy
Project management
Web and programming

e-Bills at SourceForge
Project summary
Latest downloads
Demo register
Demo login

Legal stuff

Last updated