VTERM 1.0
BILLING DATABASE PROCESSING SYSTEM
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 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.