billmax documentation   BillMax Billing Solutions
  877.245.5629
  sales@billmax.com
 

Name

account table — table for Account data

account Field Definitions

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.

  • 0 - Access denied

  • 1 - Access granted

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 MARKETING report makes use of this value.

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
email

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.

  • 0 - The credit card will be attempted 1/1/03

  • 1 - The credit card will be attempted 1/2/03

  • 7 - The credit card will be attempted 1/8/03

  • 15 - The credit card will be attempted 1/16/03

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.

  • 1 - email sent

  • 2 - postal sent

  • 4 - fax sent

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

  • Cash/Check - The Account pays bills using either cash or checks.

  • Credit - The Account pays bills using a credit card.

  • Credit Once, Then Cash/Check - The Account initially pays their bill using a credit card. If the credit card charge is successful, then the payment method for the Account is changed to Cash/Check. In addition, the Account terms are changed to the Virtual Company terms for Cash/Check.

  • E-Cash - The Account pays bills using electronic checks through an electronic check processor.

  • EFT - A placeholder. May be used to denote Accounts that pay their bills using wire transfers or direct deposits.

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

The State of the Account

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

SEE ALSO


Document Revision A for BillMax 2.2.0   -   Copyright © 1997-2006 The iSpark Group, Inc.

All rights reserved. No part of this documentation may be reproduced or transmitted in any fashion without written permission by The iSpark Group, Inc. This documentation is for the sole use of licensees of the BillMax billing software created by The iSpark Group, Inc. Making the documentation available to a non-licensee of BillMax without written permission of The iSpark Group, Inc. is a violation of the use of this documentation.

While precautions have been taken in the preparation of this documentation, The iSpark Group, Inc. assumes neither liability nor responsibility for errors or omissions, or for damages resulting from the use of the information contained herein.

All terms mentioned that are known to be trademarks have been appropriately capitalized. Use of the a trademark does not affect the validity of any trademark or service mark.

Links to third-party Web sites are provided for convenience. The iSpark Group, Inc. is not responsible for any content contained in the third-party Web sites.

Comments about this documentation may be sent to doc@billmax.com