Exported Field Names and Data-Types:

•

Time_Stamp
This is the time the transaction was first stored. Data type is date.

•

Sale_Type
This is the sales type. Data type is string.

•

Transaction_Date
This is the time of the last transaction time. When issuing a void, credit or adjustment, this data will be different from the Time_Stamp field. Data type is date.

•

Rep_ID
This is the Rep/User ID for the transaction. It can be empty if the Administrator performed the transaction. Data type is string.

•

Account_Name
This is the name on the Credit Card or Bank Account.. Data type is string.

•

Address
This is the address. Data type is string.

•

City
This is the city. Data type is string.

•

State
This is the 2 letter State/Province abbreviation. Data type is string.

•

Zip
This is the Zip or Postal Code. Data type is string.

•

Telephone
This a formatted (xxx) xxx-xxxx telephone number. Data type is string

•

Reference
This is the reference number (max. 10 digits). Data type is string.

•

Sale_Amount
This is the amount of the sale. Data type is currency.

•

Sale_Tip
This is the tip amount for the sale. It can be empty. Data type is currency.

•

Sale_Total
This is the total amount sent for processing (amount + tip). Data type is currency. Note: currency data types are not formatted as 0.00.

•

Card_Type
This type of card used in credit card sales. Card types are: Unknown, AMEX, Amer Diner's, Diner's Club, Carte Blanche, Discover, Enroute, JBC, MasterCard, and Visa. Data type is string.

•

Card_Number
This represents the last 4 digits of the credit card. Data type is string.

•

Exp_Date
This is the credit card expiration date formatted as _MM/YY. Note that there is a single character space in front of the month. Data type is string.

•

CVV2
This is the Credit Card Identification Number (CIN). Data type is string.

•

CVV2_Check
This is the validation status of the CIN. Values are: None, Partial, Complete, Illegible, and Incorrect. Data type is string.

•

Swipe
This indicates if a credit card was swiped for the transaction. N = No, Y = Yes. Data type is a single character string.

•

Account_Type
This is the bank account type. Twp types are available: Checking Account and Savings Account. Data type is string.

•

ABA_Number
This represents the last 4 digits of the bank routing number. Data type is string.

•

Account_Number
This represents the last 4 digits of the bank account number. Data type is string.

•

Check_Number
This is the check number. Data type is string.

•

Trans_ID
This is the transaction ID that comes from the progressing bank. Data type is string.

•

Auth_ID
This is the authorization code that comes from the progressing bank. Data type is string.

•

Signature
This indicates if a signature was captured during the transaction. N = No, Y = Yes. Data type is a single character string.

•

Notes
In some cases, the processing bank returns information about the transaction. That information is entered here. Data type is string.

8.