![]() |
BillMax Billing Solutions 877.245.5629 sales@billmax.com |
account table — table for Account data
| Name | Description |
Data Type | BillMax Default |
|---|---|---|---|
| Name | Description |
Data Type | BillMax Default |
| adcode | The advertising code captured when the Account was created. A valid value from the adcodes list. |
tinyint(4) | 0 |
| addr1 | Address field |
char(50) | BLANK |
| addr2 | Address field |
char(50) | BLANK |
| addr3 | Address field |
char(50) | BLANK |
| addr4 | Address field |
char(50) | BLANK |
| bacct | The Account's bank account number. May be used for EFT, ECHECK or ACH processing. |
char(20) | BLANK |
| balance | The Account's overall balance. The sum of unAllocated Store Credits and Payments, and unpaid purchases and Deposit Charges. |
int(11) | Computed |
| bcity | Address field |
char(30) | BLANK |
| bmui |
Setting allows or denies subscriber access to BillMax data through the Customer Interface.
|
tinyint(4) | 1 |
| bname | The Account's bank account name. May be used for EFT, ECHECK or ACH processing. |
char(30) | BLANK |
| brout | The Account's bank routing number. May be used for EFT, ECHECK or ACH processing. |
char(20) | BLANK |
| bstate | The state or province in which the Account's bank is located. May be used for EFT, ECHECK or ACH processing. |
char(30) | BLANK |
| cancelreasons |
The reason stated by the Account holder for closing the account. A valid value from the cancelreasons list. The |
int(11) | 0 |
| ccaddr | The address at which the Account's credit card is registered. May be used for credit card processing. |
char(50) | BLANK |
| ccdeclines | The current number of consecutive time a Account's electronic payment processing has failed. This number is set back to 0 when electronic payment for processing for the Account is successful. This parameter works in conjunction with the cctries option in the config table. When the number of consecutive declines equals cctries electronic payment processing for this Account is suspended. |
tinyint(4) | 0 |
| ccexp | The expiration date of the Accounts credit card. May be used for credit card processing. |
date | 0000-00-00 |
| ccname | The name on the Accounts credit card. May be used for credit card processing. |
char(50) | BLANK |
| ccnexttry | Used when an Account pays via automated electronic payment processing. If set to a future date, processing will not be attempted until that date. May be set by either manually or through closeofday |
date | 0000-00-00 |
| ccnum | The Account's credit card number in the form ##**********####. |
char(20) | BLANK |
| ccnumenc | The Account's credit card number as ciphered or encrypted by BillMax_DataCipher. |
char(255) | BLANK |
| ccpass | An optional password field associated with a Account's credit card. May be used for credit card processing. |
char(20) | BLANK |
| ccpin | An option PIN field associated with a Account's credit card. May be used for credit card processing. |
char(20) | BLANK |
| cctype | The brand of credit card (VISA, AMEX ...). A valid value from the cctypes list. |
tinyint(4) | 0 |
| cczip | The address at which the Account's credit card is registered. May be used for credit card processing. |
char(10) | BLANK |
| cdeposit | The sum of un-paid Deposit Charges. |
int(11) | Computed |
| cfname | The first name of the billing contact. |
char(30) | BLANK |
| chargemax | The maximum funds collection allowable by automated Electronic Funds Processing. Used to make sure an excessive incorrectly billed amount is not collected. |
int(11) | Copied from Company Defaults. |
| chargemin | The minimum allowable by automatic processing. Used to make sure that small customer balances are not collected. Collecting them may cost more in fees than they are worth. |
int(11) | Copied from Company Defaults. |
| city | The city of the billing contact. |
char(30) | BLANK |
| clname | The last name of the billing contact for the Account |
char(30) | BLANK |
| cmname | The middle name of the billing contact for the Account. |
char(30) | BLANK |
| company | The company name of the Account. |
char(50) | BLANK |
| country | The country of the Account. |
char(30) | Copied from Company Defaults. |
| cphone | The phone number of the billing contact for the Account. |
char(20) | BLANK |
| creditdue | The maximum allowable refund by automatic processing for this Account. |
int(11) | Copied from Company Defaults. |
| customerof | A valid value from config.number denoting the Virtual Company to which this Account belongs. |
int(11) | Lowest numbered Virtual Company |
The email of the billing contact for this Account. Populate this if it is not be an email that you provide the Account. Otherwise, BillMax will populate this field when you create a Service for this Account |
char(100) | BLANK | |
| empl | The Authorized BillMax User who created the entry. |
mediumint(8) | The Authorized BillMax User who created the entry. creating the Account |
| enddate | If populated, the date this Account's state will be changed to Suspended State. |
date | 0000-00-00 |
| entdate | The date the Account was be created. |
date | Date the Account is created |
| enttime | The time the Account was be created. |
time | Time of day the Account is created |
| epaydays |
Given the date an item is billed to an Account, this is the number of days after that date for the first attempt to automatically collect funds for the item via . As an example, assume the Account pays by credit card and the item was billed 1/1/2003. The following are examples of the effect of epaydays on the first time the credit card will be attempted for these funds.
|
int(11) | Copied from Company Defaults. |
| faxcost | A monthly charge assessed to the Account if they receive Statements by fax. |
int(11) | zero value for currency |
| finactivity | A field used to track financial activity since the last Summary entry. |
int(11) | 0 |
| fphone | The fax number to which the Statement is faxed. Generally the number of the billing contact. |
char(20) | BLANK |
| generation | A timestamp denoting the last time the record was modified. |
timestamp(14) | TIMESTAMP |
| gracedate | The date through which BillMax will ignore the overdue status of an Account (not send them any overdue notices, not suspend them, etc.). Use when making payment arrangements with Accounts that are overdue. |
date | 0000-00-00 |
| immune | Specifies whether an Account is immune from Overdue Processing. This is normally used for special Accounts. |
tinyint(4) | 0 |
| invday |
This value is a day of month, 1 through 31, and is used for several purposes:
|
tinyint(4) | Copied from Company Defaults. |
| invmethod |
The different methods by which an Account may receive a Statement. This is a BIT mask. If no BITs are set, no Statement is sent. The following represents the BIT positions for the different methods. A 0 value in the BIT position indicates the method is not used. A 1 value in the BIT position indicates the method is used. More than one method selected.
|
tinyint(4) | No default. User input required. |
| invterms | Statement terms. A positive integer representing how many days the customer has from the time of Statement creation to when the Account is pastdue if payment hasn't been received. |
tinyint(4) | Copied from Company Defaults. |
| latedate | The last date an overdue notice was sent to an Account |
date | 0000-00-00 |
| lockowner | The login of the employee who created the Account Lock |
mediumint(8) | 0 |
| locktime | The timestamp of the Account Lock |
int(11) | 00:00:00 |
| misc01 | A miscellaneous field to be used by the purchaser of BillMax. |
int(11) | 0 |
| misc02 | A miscellaneous field to be used by the purchaser of BillMax. |
int(11) | 0 |
| misc03 | A miscellaneous field to be used by the purchaser of BillMax. |
int(11) | 0 |
| misc04 | A miscellaneous field to be used by the purchaser of BillMax. |
int(11) | 0 |
| misc05 | A miscellaneous field to be used by the purchaser of BillMax. |
int(11) | 0 |
| misc06 | A miscellaneous field to be used by the purchaser of BillMax. |
char(50) | BLANK |
| misc07 | A miscellaneous field to be used by the purchaser of BillMax. |
char(50) | BLANK |
| misc08 | A miscellaneous field to be used by the purchaser of BillMax. |
char(50) | BLANK |
| misc09 | A miscellaneous field to be used by the purchaser of BillMax. |
char(50) | BLANK |
| misc10 | A miscellaneous field to be used by the purchaser of BillMax. |
char(50) | BLANK |
| misc11 | A miscellaneous field to be used by the purchaser of BillMax. |
date | 0000-00-00 |
| misc12 | A miscellaneous field to be used by the purchaser of BillMax. |
date | 0000-00-00 |
| misc13 | A miscellaneous field to be used by the purchaser of BillMax. |
date | 0000-00-00 |
| misc14 | A miscellaneous field to be used by the purchaser of BillMax. |
date | 0000-00-00 |
| misc15 | A miscellaneous field to be used by the purchaser of BillMax. |
date | 0000-00-00 |
| misc16 | A miscellaneous field to be used by the purchaser of BillMax. |
time | 00:00:00 |
| misc17 | A miscellaneous field to be used by the purchaser of BillMax. |
time | 00:00:00 |
| misc18 | A miscellaneous field to be used by the purchaser of BillMax. |
time | 00:00:00 |
| misc19 | A miscellaneous field to be used by the purchaser of BillMax. |
time | 00:00:00 |
| misc20 | A miscellaneous field to be used by the purchaser of BillMax. |
time | 00:00:00 |
| nlatenotes | The number of late notices sent to a Account |
tinyint(4) | 0 |
| number | System Identifier for a database row. In most cases automatically generated. Allowable range is 1-2147483647. |
int(11) | Autogenerated. Generally next available integer. |
| pastduebal | The Account's past due balance. The sum of unpaid purchases and Deposit Charges that are overdue. |
int(11) | Computed |
| paytype |
BillMax Payment Methods and their meanings
|
tinyint(4) | No default. User input required. |
| postalcost | A monthly charge assessed to the Account if they receive Statements by postal mail. |
int(11) | Zero value for currency. |
| purchases | The sum of un-paid purchases. |
int(11) | Computed |
| reason | The reason that the Account was changed to a State other than the Open State. A valid value from the reasons list. |
int(11) | 0 |
| referredby | A placeholder to store a referral code or name. If the intent is to credit an existing Account for referring a new customer, consider using the referral account field in a Service |
char(30) | BLANK |
| refundmax | The maximum refund allowable by automated Electronic Funds Processing. Used to make sure a mistaken excessive refund is not distributed. |
int(11) | Copied from Company Defaults. |
| reseller | A field that may be used to capture the reseller number for an Account that is taxexempt. |
char(30) | BLANK |
| startdate | The start date of the Account. Generally the only time this is different than the enter date of the Account is when migrating accounts from a different billing system to BillMax. |
date | Current Date |
| state | tinyint(4) | 1 | |
| statename | The state/province of the billing contact. |
char(30) | Copied from Company Defaults. |
| summarydate | The date of the last Summary entry. |
date | 0000-00-00 |
| suspdate | The date that the State of the Account was change to Suspended State. |
date | 0000-00-00 |
| taxable | Denotes whether the Account is taxable or not. Even if all the products sold are currently non-taxable, it is important to capture this information in the event of a future taxable sale. Only mark an Account non-taxable if you have supporting documentation. |
tinyint(4) | 1 |
| taxregion | The tax region of the Account. |
int(11) | No default. User input required. |
| title | The salutation of the billing contact. |
char(15) | 0 |
| ucash | The sum of unAllocated payments made with legal tender. |
int(11) | Computed |
| ucredit | The sum of unAllocated Store Credit. |
int(11) | Computed |
| useradmin |
Specifies which User is granted access to Account information through the Customer Interface
|
int(11) | -1 |
| zip | The postal code of the billing contact. |
char(30) | BLANK |
Relevant Interfaces
Library Routines
Command Line Routines
| reopen |
| billmax-admin |
| close |
| createcust |
CGI Routines
| enter_account.cgi |
Web Forms - Administering Accounts