This is the default format for transaction version 3.1, and contains the following fields. Each field in the file is separated by a comma.
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 |
|---|---|---|
|
Transaction ID |
The unique identification number assigned to a transaction by the payment gateway. |
301244354 |
|
Transaction Status |
The current processing status of the transaction. |
Settled Successfully |
|
Settlement Amount |
The total settled amount of the transaction. |
50.00 |
|
Settlement Currency |
The currency of the Settlement Amount. |
USD |
|
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-2002 03:26:12 PM MDT |
|
Authorization Amount |
The transaction amount sent to the processor for authorization. This amount is reserved against the available balance of a customer’s credit card and may differ from the total amount actually charged to the customer. |
50.00 |
|
Authorization Currency |
The currency of the Authorization Amount. |
USD |
|
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-2002 03:26:12 PM MDT |
|
Authorization Code |
A code assigned to the transaction by the processor indicating its authorization status. |
Q78U78 |
|
Reference Transaction ID |
The original transaction ID of the transaction being refunded. "Not Applicable" appears for all other transaction types. |
254125896 |
|
Transaction Type |
The type of transaction submitted to the payment gateway. |
Authorization w/ Auto Capture |
|
Address Verification Status |
A code and description that indicate the Address Verification Service (AVS) results returned by the processor for a transaction. |
P - AVS Not Applicable |
|
Card Code Status |
The code that indicates the card code verification (CCV) results returned by the processor for a transaction. |
N - No Match |
|
Recurring Billing Transaction |
A Yes (Y) or No (N) value indicating whether the transaction is single or recurring. |
N |
|
Partial Capture Status |
Indicates whether a partial reversal was executed against the transaction. |
Not applicable |
|
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) |
|
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) |
|
Total Amount |
The total amount charged or refunded to the customer's credit card or bank account. |
50.00 |
|
Currency |
The currency for which the transaction amount was authorized. |
USD |
|
Invoice Number |
The merchant-assigned invoice number associated with the transaction. |
1452589 |
|
Invoice Description |
A description of the transaction or order. |
This is an invoice description |
|
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 |