Billing

Billing Process

Account Billing Info

Used by Bill generator

Name type Descriptions
Account Number varchar Account Number
(Imported from external account system)
Account User varchar <user> component of the account.
<Account User>@<Account Domain> together uniquely identify the user in the system.
<Account User>=="*" denotes a combined bill for all users in a domain.
<Account User>=="domain" denotes a bill for the "domain" user, and not the whole domain.
Account Domain varchar <domain> component of the account.
Company Name varchar Company Name
First Name varchar First Name
Last Name varchar Last Name
Street Address varchar Street Address
State varchar State
Zip Code varchar Zip Code
Country varchar Country
Phone varchar Primary contact phone number
Fax varchar Fax number
E-Mail varchar Primary contact e-mail address
Status 'active' or 'inactive' Acitive or Inactive
Time Zone varchar e.g. US/Pacific
Last Bill Date varchar Date of last bill.
Billing Period varchar e.g. week, month, quarter
Billing Date varchar Date to generate next bill


Bills

This table lists all the generated bills and their summary.

  • Billing Period
    • The Billing Period may be different from the Service Plan Period
    • Each Bill includes an integral number of Service Plan Period
    • There can be more then one Service Plan Period in each Bill.
    • The billed Usage Period correspond to the billed Service Plan Period(s)
    • The billed Usage Period >= Period Start Date and < Period End Date

  • Credit/Debit from "Usage Record" and "Service Record" are applied to the corresponding account at the instance a Bill entry is inserted.
  • Non-Recurrent Charge will be entries in Service Record with special Category code.
  • This file info is written by BIRT each time it generate a new bill.
  • There will be a periodic auto export mechanism, similar to the NMS's CDR export.
  • 1st Bill if there was no previous bill
    • 1st Bill period start from Date 1st Use for a single account or MIN(Date 1st user) for a domain
Name type Descriptions
Account User varchar <user> component of the account.
<Account User>@<Account Domain> together uniquely identify the user in the system.
Account Domain varchar <domain> component of the account.
Bill From Date yyyy-mm-dd Start date for this billing period
Bill # varchar 10-digit sequence number
Bill Date yyyy-mm-dd Billing date
Billing period is >= Bill From Date and < Bill Date
Creation Date yyyy-mm-dd hh:mm:ss Date that the bill is created
Last Bill Date yyyy-mm-dd Date of last bill.
Last Bill Total double Total of last bill
Total Payment double Total Payment in the Service Record for this billing period
Total Adjustment double Total Adjustment in the Service Record for this billing period
Past Due double Last Bill Total + Total Adjustments - Total Payment Total
Minute Usage double Total number of minute consumed in this billing period
Minute Charge double Total usage charges, e.g. minutes
Service Charge double Total of all items belonging to the account's Service Plan in the Service Record for this billing period.
Non-Recurrent Charge double Total of all items NOT belonging to the account's Service Plan, NOT Payment and NOT Adjustment in the Service Record for this billing period.
Tax double Tax applied
New Charge double Usage Charge + Non-Recurrent Charge + Recurrent Charge + Tax
Total Charge double New Charge + Past Due
Filename varchar Filename of the Bill
File Date yyyy-mm-dd hh:mm:ss Date that the bill file was generated
Status varchar Status of this bill to help keep tracking of the file generation, sending of invoice, and receive of payment.