| adcode |
Advertising Code. Used in Advertising report. List
adcodes. |
tinyint(4) |
| addr1 |
Address Line 1 |
char(50) |
| addr2 |
|
char(50) |
| addr3 |
|
char(50) |
| addr4 |
|
char(50) |
| appointmentroute |
Default Appointment Route. Used with Scheduling. List
appointmentroutes. |
int(11) |
| autoeft |
|
int(11) |
| bacct |
Deprecated. |
|
| balance |
Account balance. |
bigint(20) |
| bcity |
Deprecated. |
|
| bmui |
Customer Portal access:
- 1
- Yes
- 0
- No
|
tinyint(4) |
| bname |
Deprecated. |
|
| brout |
Deprecated. |
|
| bstate |
Deprecated. |
|
| cancelreasons |
Reason an Account canceled. List cancelreasons |
mediumint(8) |
| ccaddr |
Deprecated. |
|
| cccity |
Deprecated. |
|
| cccountry |
Deprecated. |
|
| ccdeclines |
Deprecated. |
|
| ccexp |
Deprecated. |
|
| ccfname |
Deprecated. |
|
| cclname |
Deprecated. |
|
| ccname |
Deprecated. |
|
| ccnexttry |
Deprecated. |
|
| ccnum |
Deprecated. |
|
| ccnumenc |
Deprecated. |
|
| ccpass |
Deprecated. |
|
| ccphone |
Deprecated. |
|
| ccpin |
Deprecated. |
|
| ccstatename |
Deprecated. |
|
| cctype |
Deprecated. |
|
| cczip |
Deprecated. |
|
| cfname |
First Name |
|
| city |
|
char(30) |
| clname |
Last Name |
char(30) |
| cmname |
Middle Name |
char(30) |
| company |
Customer's company. |
char(30) |
| country |
|
char(30) |
| county |
|
char(30) |
| cphone |
Phone |
char(30) |
| customerof |
Virtual Company |
int(11) |
| datetoreopen |
Date in the future to automatically reopen an Account. |
date |
| deposit |
Total deposits held. |
bigint(20) |
| email |
|
char(100) |
| empl |
|
mediumint(8) |
| enddate |
Date Account Closed or Date to Close. The date after end of service. |
date |
| enddatereason |
Reason for closing. List reasons |
tinyint(4) |
| entdate |
|
date |
| enttime |
|
time |
| finactivity |
Internal Use. |
|
| flags |
Internal Use. |
|
| fphone |
Fax. |
char(40) |
| generation |
|
timestamp |
| gracedate |
Date through which reminders for overdue balances will not be sent and automated
suspension will not occur. |
date |
| guarantor |
Account number of an Account in BillMax that will pay outstanding Debits for the
current Account. |
int(11) |
| immune |
Bit Field. The following are bit values:
- 1
- Do not automatically Suspend
- 2
- Do not assess Late Fees
- 4
- Do not send Overdue Emails
|
tinyint(4) |
| importid |
|
char(100) |
| invday |
Billing/Prorate Day of Month |
tinyint(4) |
| invmethod |
Billing Statement/Invoicing Methods. A bit mask that references First, Second, …
from the Account Profile Document Delivery Methods |
int(11) |
| lastmodempl |
|
int(11) |
| latedate |
|
date |
| lockowner |
|
mediumint(8) |
| locktime |
|
int(11) |
| misc01 |
Integer Field through misc05 |
int(11) |
| misc02 |
|
int(11) |
| misc03 |
|
int(11) |
| misc04 |
|
int(11) |
| misc05 |
|
int(11) |
| misc06 |
Character (50) Field through misc10 |
char(50) |
| misc07 |
|
char(50) |
| misc08 |
|
char(50) |
| misc09 |
|
char(50) |
| misc10 |
|
char(50) |
| misc11 |
Date Field through misc15 |
date |
| misc12 |
|
date |
| misc13 |
|
date |
| misc14 |
|
date |
| misc15 |
|
date |
| misc16 |
Time Field through misc20 |
time |
| misc17 |
|
time |
| misc18 |
|
time |
| misc19 |
|
time |
| misc20 |
|
time |
| nlatenotes |
|
tinyint(4) |
| number |
|
int(11) |
| pastduebal |
Past Due Balance |
bigint(20) |
| payerid |
|
char(50) |
| paytype |
Default Payment Method:
- 1
- Cash/Check
- 2
- Credit Card
- 3
- Electronic Check
- 4
- EFT
- 5
- Credit Card Once, then Cash/Check
|
tinyint(4) |
| pctdiscount |
Percent Discount for all Sales to this Account. |
decimal(10,6) |
| pctdiscountexpdate |
Date the Discount expires. |
date |
| popupnote |
Reference to record in notes table that is displayed when an
Account is accessed in the Staff Portal. |
int(11) |
| profile |
Account Profile |
mediumint(8) |
| purchases |
Sales amounts owed |
bigint(20) |
| reason |
Reason why Account is not Open. List reasons |
mediumint(8) |
| referredby |
Referral Code |
char(30) |
| reseller |
Reseller ID |
char(30) |
| sla |
Service Level Agreement |
int(11) |
| startdate |
|
date |
| state |
Status of the Account:
- 0
- Open
- 1
- Closed
- 2
- Suspended
- 4
- Collections
|
tinyint(4) |
| statename |
State or Province |
char(30) |
| summarydate |
Last date a Billing Statement was generated. |
date |
| suspdate |
Date the Account was Suspended. |
date |
| taxable |
- 1
- Account is subject to paying taxes.
- 0
- Account is not subject to paying taxes. Examples are non-profit and government
organizations.
|
tinyint(4) |
| taxregion |
- -1
- Not Applicable. Only use if never collecting any type of tax.
- otherwise
- Foreign Key to taxregion.number.
|
int(11) |
| textmessage |
Number to use to send text messages. If not integrated with SMS service, use
email address for text message device. |
char(100) |
| timezone |
List timezones. |
tinyint(4) |
| title |
Salutation. List titles. |
tinyint(4) |
| ucash |
Amount of unused Payments. |
bigint(20) |
| ucredit |
Amount of unused Store Credit. |
bigint(20) |
| usagepctdiscount |
Percentage discount for Usage Sales. |
decimal(10,6) |
| usagepctdiscountexpdate |
Date percentage discount for usage sales expires. |
date |
| useradmin |
User authorized to make Account adjustment through the Customer Portal. |
int(11) |
| vataxid |
Value Added Tax ID or customer. |
char(15) |
| verifiedaddr |
Verification results if using Address Verification:
- 0
- Not Verified
- 1
- Verified
- 2
- Address Verification in use, but address saved even though Address
Verification failed.
|
int(11) |
| zip |
ZIP/Postal Code |
char(30) |
