VTERM 1.0

BILLING DATABASE PROCESSING SYSTEM

Created by Drew Star

Database to upload:

Database requirements are outlined below

Your database must be created in a field delimited, flat file format using the PIPE | character to separate fields.  Click on the BROWSE button to locate your flatfile billing database.  If you do not have a database you may create one by clicking on the START NEW DATABASE button.  If you are uploading an existing database the fields must be arranged EXACTLY in the following order:

$NAME|$ADDRESS|$CITY|$STATE|$ZIP|$COUNTRY|$PHONE|$EMAIL|$ACCTNO|$ABACODE|$BANKNAME|$CARDNUM|$EXPDATE|$AMOUNT|$REBILL|$CYCLE|$METHOD|$STATUS|$RESPONSE

Each field is described below

FIELD Description
$NAME The cardholders name (first and last)
$ADDRESS Billing address
$CITY Billing city
$STATE billing state
$ZIP billing zipcode
$COUNTRY billing country (optional)
$PHONE billing phone number
$EMAIL billing email address
$ACCTNO checking account number (if billing by check)
$ABACODE checking routing number (if billing by check)
$BANKNAME checking bank name (if billing by check)
$CARDNUM credit card number (if billing by credit card)
$EXPDATE expiration date (if billing by credit card)  format is monthyear (eg:  0202)
$AMOUNT

 

amount to bill.  must be followed by 2 decimal places.  eg:  10.00
$REBILL days between billing periods.  eg:  30 for every 30 days
$CYCLE days since last billing.  when this value exceeds the REBILL value billing may occur
$METHOD method of billing.  values must equal one of the following:  ECHECK (for checking), Visa, MasterCard, Discover,American Express, Diners Club, JCB.  This field is case sensitive.
$STATUS values equal passed, failed or testing.  If the last billing attempt failed this will cause the entry to be highlighted in red.  This value can be re-initialized in the edit menu.  This field value is generated by the billing software.
$RESPONSE this field contains error messages returned by authorize.net.  The problem must be corrected in the edit menu in order to bill successfully.