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.
|
|
|