877.245.5629
sales@billmax.com
|
BillMax Billing Solutions 877.245.5629 sales@billmax.com |
| servicechange table | ||
|---|---|---|
 |
Chapter 3. Database Schema | 
|
servicechange table — table for servicechange data
| Name | Description |
Data Type | BillMax Default |
|---|---|---|---|
| Name | Description |
Data Type | BillMax Default |
| changeon | The effective date of the Service Change. |
date | No default. User input required. |
| chargedeposit | If non-zero, indicates that any Deposit Charge associated with the new Service Definition will be billed when the Service Change takes place. |
tinyint(4) | 0 |
| chargeiterms | If non-zero, indicates that billing for the new Service Definition will begin with the initial price. |
tinyint(4) | 0 |
| chargesetup | If non-zero, indicates that any setup fees associated with the new Service Definition will be billed when the Service Change takes place. |
tinyint(4) | 0 |
| comment | A comment about the Service Change. |
char(100) | BLANK |
| creditbyvoid | If non-zero, when the Service Change is executed, credit for future unused service will be made using Voids. Otherwise, issue Store Credit for future unused service. |
tinyint(4) | 0 |
| creditsetup | If non-zero, credit the old setup fee. |
tinyint(4) | 0 |
| creditusage | If non-zero, credit usages fees. |
tinyint(4) | 0 |
| empl | The Authorized BillMax User who created the entry. |
mediumint(8) | The Authorized BillMax User who created the entry. |
| entdate | The date the entry was created. |
date | The date the entry was created. |
| enttime | The the time the entry was created. |
time | The the time the entry was created. |
| free | If non-zero, the Service will be set to free when the Service Change takes place. |
tinyint(4) | Taken from the new Service Definition |
| iprice | The initial price to use for the new billings. |
int(11) | Taken from the new Service Definition |
| number | System Identifier for a database row. In most cases automatically generated. Allowable range is 1-2147483647. |
int(11) | Autogenerated. Generally next available integer. |
| oldservdef | The value of servdef.number of the old Service Definition. |
int(11) | No default. User input required. |
| price | The regular price to use for the new billings. |
int(11) | Taken from the new Service Definition |
| quantity | The quantity to use for the new billings. |
float(10,2) | 1 |
| refunddeposits | If non-zero, either refund the old Deposit Charge or Void the old Deposit Charge. |
tinyint(4) | 0 |
| servdef | The value of servdef.number of the new Service Definition. |
int(11) | No default. User input required. |
| service | The value of service.number of the Service undergoing the Service Change. |
int(11) | No default. User input required. |
| setup_taxable | If non-zero, tax will be assessed on the setup fee billed when the Service Change takes place. |
tinyint(4) | Taken from the new Service Definition |
| status | Stores the result of executing the Service Change. |
tinyint(4) | BillMax derived |
| statustext | Stores the textual result of executing the Service Change. |
char(100) | BillMax derived |
| taxable | If non-zero, tax will be assessed on the recurring and initial fees billed after the Service Change. |
tinyint(4) | Taken from the new Service Definition |
|
|
 |
|
| service table |  |
stats table |