877.245.5629
sales@billmax.com
|
BillMax Billing Solutions 877.245.5629 sales@billmax.com |
| service table | ||
|---|---|---|
 |
Chapter 3. Database Schema | 
|
service table — table for Service data
| Name | Description |
Data Type |
|---|---|---|
| Name | Description |
Data Type |
| bwreportdate | The last date that a Tierplan usage report was sent. |
date |
| changetocnt | The number of times the Service has been subjected to a Service Change. |
int(11) |
| cleardate | The last date that service.totseconds and service.primeseconds were reset to 0. |
date |
| d01 | In general, the login name for a Service. Used for provisioning purposes. |
char(100) |
| d02 | In general, the password name for a Service. Used for provisioning purposes. |
char(100) |
| d03 | An arbitrary value associated with the Service. |
char(100) |
| d04 | An arbitrary value associated with the Service. |
char(100) |
| d05 | An arbitrary value associated with the Service. |
char(100) |
| d06 | An arbitrary value associated with the Service. |
char(100) |
| d07 | An arbitrary value associated with the Service. |
char(100) |
| d08 | An arbitrary value associated with the Service. |
char(100) |
| d09 | An arbitrary value associated with the Service. |
char(100) |
| d10 | An arbitrary value associated with the Service. |
char(100) |
| empl | The Authorized BillMax User who created the entry. |
mediumint(8) |
| enddate | The day AFTER the last day of service delivery. As the assumption is that billmax-admin will be run at midnight or shortly thereafter, this value represents the day that the State of a Service will be changed from Open State to Closed State. If billing for time past this date has not be done when the date is specified, daily BillMax processing will eventually bill through the day before this date. If billing for time past this date has been done when this date is specified, BillMax may generate credits for unused part of the Service when specified through the Staff Interface. |
date |
| entdate | The date the entry was created. |
date |
| enttime | The the time the entry was created. |
time |
| free | If non-zero, neither the recurring portion nor usage portion of the Service will be billed. |
tinyint(4) |
| generation | A timestamp denoting the last time the record was modified. |
timestamp(14) |
| icnt | The number of times to bill a Service the service.iprice rate. |
int(11) |
| invcnt | A counter used to decide whether the recurring portion of the Service should be billed at the service.iprice or service.price rate. Note that if a full term is charged at the same time as a prorated term, this counts as one billing. If a prorated term is billed followed at a later date by a full term billing, this counts as two billings. |
int(11) |
| invdate | The next date that the Service will be processed for billing the recurring portion. |
date |
| invday | The day of month to bill the recurring portion of the Service |
tinyint(4) |
| iprice | The initial price for the Service. This will be billed service.icnt times. |
int(11) |
| misc01 | A miscellaneous field to be used by the purchaser of BillMax. |
int(11) |
| misc02 | A miscellaneous field to be used by the purchaser of BillMax. |
int(11) |
| misc03 | A miscellaneous field to be used by the purchaser of BillMax. |
int(11) |
| misc04 | A miscellaneous field to be used by the purchaser of BillMax. |
int(11) |
| misc05 | A miscellaneous field to be used by the purchaser of BillMax. |
int(11) |
| misc06 | A miscellaneous field to be used by the purchaser of BillMax. |
char(50) |
| misc07 | A miscellaneous field to be used by the purchaser of BillMax. |
char(50) |
| misc08 | A miscellaneous field to be used by the purchaser of BillMax. |
char(50) |
| misc09 | A miscellaneous field to be used by the purchaser of BillMax. |
char(50) |
| misc10 | A miscellaneous field to be used by the purchaser of BillMax. |
char(50) |
| misc11 | A miscellaneous field to be used by the purchaser of BillMax. |
date |
| misc12 | A miscellaneous field to be used by the purchaser of BillMax. |
date |
| misc13 | A miscellaneous field to be used by the purchaser of BillMax. |
date |
| misc14 | A miscellaneous field to be used by the purchaser of BillMax. |
date |
| misc15 | A miscellaneous field to be used by the purchaser of BillMax. |
date |
| misc16 | A miscellaneous field to be used by the purchaser of BillMax. |
time |
| misc17 | A miscellaneous field to be used by the purchaser of BillMax. |
time |
| misc18 | A miscellaneous field to be used by the purchaser of BillMax. |
time |
| misc19 | A miscellaneous field to be used by the purchaser of BillMax. |
time |
| misc20 | A miscellaneous field to be used by the purchaser of BillMax. |
time |
| nextusagedate | The next date that the usage portion of the Service will be billed. |
date |
| number | System Identifier for a database row. In most cases automatically generated. Allowable range is 1-2147483647. |
int(11) |
| ou_notice |
When a Service exceeds this number of regular hours, an email warning is sent to the Account email using |
int(11) |
| ou_susp | Denotes the number of hours over regular hours a Service may use. When the number of hours is met or exceeded, the State of the Service is changed to Suspended State until the next usage billing period. |
int(11) |
| ouprime_notice |
When a Service exceeds this number of primetime hours, an email warning is sent to the Account email using |
int(11) |
| ouprime_susp | Denotes the number of hours over primetime hours a Service may use. When the number of primetimehours is met or exceeded, the State of the Service is changed to Suspended State until the next usage billing period. |
int(11) |
| plaintextpass | The plain text representation of service.d02; |
char(50) |
| ponumber | If supplied, the Purchase Order number for the Service. |
char(30) |
| pop | The POP Region to which the Service is associated. |
int(11) |
| price | The rate at which the Service will be billed after the Service has been billed at the service.iprice rate for service.icnt times. |
int(11) |
| prime_seconds | The total amount of prime time (see config.primestart and config.primeend) online time since the last time that this field was reset to 0. This field is populated from RADIUS data. |
int(11) |
| quantity | If non-zero, a multiplier for service.price and service.iprice when computing the total rate for the recurring portion of the Service. |
float(10,2) |
| reason | A value from reasons list indicating why the State of the Service is not the Open State. |
int(11) |
| refaccount | The account.number of the Account that should get referral credit for the creation of the Service. |
int(11) |
| refdate | The effective date of the referral. |
date |
| resources | The Resource Set for a Service. See servdef.resources. This value is copied from servdef.resources for performance reasons. If servdef.resources is modified, it may be necessary to modify this using database utilities. |
int(11) |
| servdef | The value of servdef.number of the Service Definition to which the Service is associated. |
int(11) |
| setup_taxable | A non-zero value indicates that tax should be assessed if the setup fee is billed to the customer. |
tinyint(4) |
| startdate | The first date that the recurring portion of the Service should be billed. The setup and deposit fees are billed at the time the Service is created. |
date |
| state | tinyint(4) | |
| suspdate | The date that the State of the Service was changed from Open State to Suspended State. |
date |
| taxable | A non-zero value indicates that tax should be assessed on both the recurring and usage portions of the billings for the Service. |
tinyint(4) |
| tiervalue | If non-zero, a value of tierplan.number indicating Usage Based Billing associated with the Service. |
double(20,8) |
| tot_seconds | The total amount of online time since the last time that this field was reset to 0. This field is populated from RADIUS data. |
int(11) |
| user | The value of user.number for the User to which this Service is associated. |
int(11) |
| wdeposit | The deposit fee to charge. |
int(11) |
| wsetup | A non-zero value indicated that the deposit fee should not be charged. |
tinyint(4) |
Relevant Interfaces
Library Routines
| BillMax_ServiceConflict |
| BillMax_ServiceChargeForUsage |
| BillMax_ServiceGet |
| BillMax_ServiceGetNext |
| BillMax_ServiceGetWhere |
| BillMax_ServicePut |
| BillMax_ServicePutIntoEnviron |
Command Line Routines - NONE
CGI Routines
| enter_service.cgi |
Web Forms - Chapter 5, Administering Services
|
|
 |
|
| servdefselection table |  |
servicechange table |