![]() |
BillMax Billing Solutions 877.245.5629 sales@billmax.com |
config table — table for Virtual Company data
During installation, BillMax inserts a record with the set of defaults listing here. Normal practice is to use one Virtual Company as a template for a new Virtual Company
| Name | Description |
Data Type | BillMax Default |
|---|---|---|---|
| Name | Description |
Data Type | BillMax Default |
| acemail | Administrative Contact email address. This email address is used as the "To:" for daily processing emails. A value for this field is required. |
varchar(100) | No default. User input required. |
| acfname | Administrative Contact first name. |
varchar(30) | BLANK |
| aclname | Administrative Contact last name. |
varchar(30) | BLANK |
| addr1 | Address field. |
varchar(30) | BLANK |
| addr2 | Address field. |
varchar(30) | BLANK |
| addr3 | Address field. |
varchar(30) | BLANK |
| addr4 | Address field. |
varchar(30) | BLANK |
| autocredit |
When the Service end date is specified using the Staff Interface, this option defines what to do for Sales that have Payhist Enddates in the future relative to the Service end date. The value supplied may be overridden on a Service by Service basis.
|
int(11) | 0 |
| bcemail | Billing Contact email address. This email address is used as the "From:" address when BillMax sends emails to customers. This address receives daily processing emails. A value for this field is required. |
varchar(100) | No default. User input required. |
| bcfname | Billing Contact first name. |
varchar(30) | BLANK |
| bclname | Billing Contact last name. |
varchar(30) | BLANK |
| billnextterm |
Defines billing if a partial service term is billed a prorated amount. If this occurs, the setting of billnextterm determines whether an additional complete service term is billed in addition to the prorated term?
|
int(11) | 1 |
| billtaxable |
Defines tax status of postal and fax surcharges.
|
int(11) | 0 |
| ccdecipher | The Permissions needed to view the full credit card number. |
int(11) | 0 |
| ccexpwarn | Defines how long in days before an Account's credit card expiration date an email may be sent to the Account notifying the Account holder of the impending credit card expiration. See Email Template Files. |
int(11) | 30 |
| ccfailcharge | Defines the amount to bill an Account when the Account credit card is declined. |
int(11) | 0 |
| ccspan | The number of days to wait between re-trying a declined credit card. |
int(11) | 4 |
| cctries | The maximum number of consecutive unsuccessful attempts to charge a credit card. |
int(11) | 3 |
| chargemax | The default maximum Account balance that will be charged to a credit card through nightly processing. If the Account balance is greater than this amount and this amount is non-zero, credit card processing will not occur for the Account. |
int(11) | 0 |
| chargemin | The default minimum Account balance that will be charged to a credit card through nightly processing. If the Account balance is less than this amount and this amount is non-zero, credit card processing will not occur for the Account. |
int(11) | 500(5.00 in USD) |
| city | Address field. |
varchar(30) | BLANK |
| company | Company name. |
varchar(30) | BLANK |
| country | Address field. |
varchar(30) | BLANK |
| creditdue | The default minimum Account balance (specified as a small negative value) that will be refunded to a credit card through nightly processing. Ignoring the negative sign, if the Account balance is refundable and the amount is less than this amount and this amount is non-zero, credit card processing will not occur for the Account |
int(11) | -2000(-20.00 in USD) |
| defdomain | Default domain used when creating an email address for a User or Account. If a User or Account does not have an email address, when a Service is created, the Service d01 field is combined with defdomain to create an email address for the User and/or Account. The Customer Service Representative is prompted whether to use the value to populate the Account and/or User data. |
varchar(65) | BLANK |
| definvday |
The default used for populating the Invday of a new Account
|
int(11) | 0 |
| epaydays | Default epaydays for an Account. When an invoice is created through automated processing, this value is added to the invoice date to set the invoice's epaydate. Epaydate is the first date an attempt will be made to collect payment for an unpaid invoice through automated payment processing. |
int(11) | 0 |
| expiredclose | Defines the number of days a Account, User or Service remains in a Suspended State before being changed to a Closed State. |
int(11) | 7 |
| fax | Virtual Company's fax number. |
varchar(30) | BLANK |
| faxcost | Default monthly charge for sending an Account fax statements. |
int(11) | 0 |
| gracewarn | Specifies how many days before the expiration of a Grace Date an email is sent. Once emails are started, an email is sent daily until Grace Date is reached. See Email Template Files. |
int(11) | 0 |
| lateamt | A surcharge billed to an Account when the Account becomes overdue. If latepct is specified, the larger of the two is billed. These surcharges are billed monthly every invday without regards to p-rebilldays. |
int(11) | 0 |
| lateclosed |
Determines whether or not Accounts in the Closed State are billed late fees.
|
int(11) | 0 |
| latepct | A percentage used to calculate the surcharge billed to an Account when the Account becomes overdue. The surcharge is the amount overdue multiplied by the percentage. If lateamt is specified, the larger of the two is billed. These surcharges are billed monthly every invday without regards to prebilldays. |
float(10,2) | 0 |
| latetaxable |
Defines whether or not late fees are taxable charges.
|
int(11) | 0 |
| newservice |
The default state of a new Service.
The state of a service will be changed from WAIT_FOR_PAYMENT to OPEN if either a payment is received or 30 days elapse. |
int(11) | 0 |
| number | System Identifier for a database row. In most cases automatically generated. Allowable range is 1-2147483647. |
int(11) | System Identifier for a database row. In most cases automatically generated. Allowable range is 1-2147483647. |
| odinterval |
How often overdue notices are sent. Number of days between overdue notices is odinterval - 1. Examples
|
int(11) | 1 |
| odmax |
Maximum number of overdue notices sent to an overdue Account.
|
int(11) | 0 |
| overduemin | Minimum amount owed by a Account that will trigger Overdue Processing. |
int(11) | 2000(20.00 in USD) |
| overduenotice | Number of days an amount is overdue before overdue notices are sent to an Account. If 0, no notices are sent. |
int(11) | 5 |
| overduesusp | Number of days an amount is overdue before an Account gets suspended. If 0, Accounts are not suspended. |
int(11) | 10 |
| phone | Virtual Company phone number. |
varchar(30) | BLANK |
| postalcost | Default postal cost for Accounts that receive postal statements. |
int(11) | 0 |
| prebilldays | A renewable service will be pre-billed this many days before it expires. Statements will be sent to customers this many days before their Invday also. |
int(11) | 0 |
| primeend | 24 hour clock time specifying the end of Prime Time used in Metered Billing. |
time | 23:00:00(24 hour clock) |
| primestart | 24 hour clock time specifying the start of Prime Time used in Metered Billing. |
time | 18:00:00(24 hour clock) |
| refundmax | The default maximum Account balance (specified as a large negative value) that will be refunded to a credit card through nightly processing. Ignoring the negative sign, if the Account balance is refundable and the amount is greater than this amount and this amount is non-zero, credit card processing will not occur for the Account |
int(11) | 0 |
| refwait | Number of days that a service must be open before referral Store Credit will be issued to the referring Account. |
int(11) | 30 |
| sendnullstmt |
A bitmask.
|
int(11) | 0 |
| state | Address Field. |
varchar(30) | BLANK |
| stmtnote | The message that appears at the end of customer statements. Each line will be centered when printed on the statement. |
mediumtext | BLANK |
| taxid | Placeholder for the Federal Tax ID. |
varchar(15) | BLANK |
| termscheck | Default payment terms for Accounts paying via the check or cash Payment Method. |
int(11) | 15 |
| termscredit | Default payment terms for Accounts paying via the credit card Payment Method. |
int(11) | 15 |
| termsecash | Default payment terms for Accounts paying via the ecash Payment Method. |
int(11) | 15 |
| termseft | Default payment terms for Accounts paying via the EFT Payment Method. |
int(11) | 15 |
| usageepaydays |
Choose whether or not timing for collecting funds for usage data should take into account epaydays.
|
int(11) | 0 |
| usageprebilldays |
Specified whether to-date usage will be billed this config.prebilldays days before the next usage billing period as specified by usage billing options of a Service Definition.
|
int(11) | 0 |
| waitcredit |
When a Service State is changed from Wait_For_Payment State to Open State, should BillMax automatically issue Store Credit for the time the Service State was Wait_For_Payment State?
|
tinyint(4) | 0 |
| zip | Address Field. |
varchar(30) | BLANK |
Relevant Interfaces
Library Routines
| BillMax_ConfigGet |
| BillMax_ConfigGetNext |
| BillMax_ConfigGetWhere |
| BillMax_ConfigPutIntoEnviron |
Command Line Routines - NONE
CGI Routines - NONE
Web Forms - the section called “Configuring a Virtual Company”
Relevant Interfaces
Library Routines
| BillMax_ConfigGet |
| BillMax_ConfigGetNext |
| BillMax_ConfigGetWhere |
| BillMax_ConfigPutIntoEnviron |
Command Line Routines - NONE
CGI Routines - NONE
Web Forms - the section called “Configuring a Virtual Company”