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