Standard/Tab Delimited

This is the default format for transaction version 3.0, 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

Email

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 ZIP

The ZIP code where the product should be shipped.

88905

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)

 

Related Topics