This is the default format for transaction version 3.1, and contains the following fields. Each field in the file is separated by a tab.
Note: If you do not know the transaction version you use, see the Transaction Version page in the Settings menu
|
FIELD NAME |
DEFINITION |
SAMPLE DATA |
|
Response Code |
The overall status of the transaction: 1 — Approved 2 — Declined 3 — Errored 4 — Held for review |
2 |
|
Authorization Code |
A code assigned to the transaction by the processor indicating its authorization status. |
Q78U78 |
|
Address Verifications Status Code |
The AVS response code indicating the results of the customer billing and cardholder billing match to the payment gateway. |
X |
|
Transaction ID |
The unique identification number assigned to a transaction by the payment gateway. |
301244354 |
|
Submit Date/Time |
The date and time the transaction was submitted to the payment gateway. The time displays according to the time zone set for your account. |
21-Aug-2006 03:26:23 PM MDT |
|
Card Number |
The number associated with a cardholder account. |
XXXX9876 (blank if an eCheck.Net transaction) |
|
Expiration Date |
The month and year a credit card expires. |
XXXX (blank if an eCheck.Net transaction) |
|
Invoice Number |
The merchant-assigned invoice number associated with the transaction. |
1202 |
|
Invoice Description |
A description of the transaction or order. |
This is an invoice description. |
|
Total Amount |
The total amount charged or refunded to the customer's credit card or bank account. |
50.00 |
|
Method |
The type of credit card or eCheck.Net used for the transaction: A — American Express C — Diners Club D — Discover E — EnRoute H — eCheck.Net J — JCB M — MasterCard V — Visa |
V |
|
Action Code |
The type of transaction submitted to the payment gateway. |
AUTH_CAPTURE |
|
Customer ID |
A unique merchant-assigned identifier for a customer. |
1254585 |
|
Customer First Name |
The customer's first name. |
John |
|
Customer Last Name |
The customer last name. |
Doe |
|
Company |
The company associated with the customer. |
John Doe Enterprises |
|
Address |
The customer's street address. |
123 Cherry Lane |
|
City |
The city of the customer's address. |
Cherry |
|
State |
The state of the customer's address. |
WA |
|
Zip |
The ZIP code of the customer's address. |
98521 |
|
Country |
The country of the customer's address. |
United States |
|
Phone |
The customer's phone number. |
2124445656 |
|
Fax |
The customer's fax number. |
3123337878 |
|
|
The customer's email address. |
johndoe@johndoe.com |
|
Ship-To First Name |
The first name of the person to whom the product should be shipped. |
Jane |
|
Ship-To Last Name |
The last name of the person to whom the product should be shipped. |
Doe |
|
Ship-To Company |
The company of the person to whom the product should be shipped. |
Jane Doe Enterprises |
|
Ship-To Address |
The address where the product should be shipped. |
225 Apple Road |
|
Ship-To City |
The city where the product should be shipped. |
Apple |
|
Ship-To State |
The state where the product should be shipped. |
WA |
|
Ship-To Country |
The country where the product should be shipped. |
United States |
|
L2 - Tax |
An additional fee to cover state or other merchandise tax. |
0 |
|
L2 - Duty |
An additional fee for imported or exported merchandise. |
0 |
|
L2 - Freight |
An additional fee to cover the merchant's shipping costs. |
0 |
|
L2 - Tax Exempt |
A Yes or No value indicating whether the transaction is tax exempt. |
No |
|
L2 - Purchase Order Number |
Transaction purchase order number. |
45256 |
|
Routing Number |
The nine-digit number that identifies the financial institution associated with a bank account. |
XXXX6789 (blank if a credit card transaction) |
|
Bank Account Number |
The account number associated with the customer's savings or checking account. |
XXXX6789 (blank if a credit card transaction) |
|
Card Code Status |
The code that indicates the card code verification (CCV) results returned by the processor for a transaction. |
N |
|
Recurring Billing Transaction |
A Yes (Y) or No (N) value indicating whether the transaction is single or recurring. |
Y |
|
Settlement Date/Time |
The date and time the transaction was picked up and sent for settlement. The time displays according to the time zone set for your account. |
21-Aug-2006 03:26:23 PM MDT |