Expanded Fields/Comma Separated

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

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 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

 

Related Topics