The Reference Docs Developer Hub

Welcome to the Reference Docs developer hub. You'll find comprehensive guides and documentation to help you start working with Reference Docs as quickly as possible, as well as support if you get stuck. Let's jump right in!

Get Started    

Transaction Export

Transactions v4

Version created - 5/23/19
Version updates Summary

  • Column changes: Added 'cc_first_6' column to the end of the export

Transactions v3

Version created - 4/25/19
Version updates Summary

  • Column additions: "cc_first_6"

Transactions v2

Version created - 1/15/19
Version updates Summary

  • Payment Gateway mappings added for Adyen, Qiwi, SEPA, SOFORT and iDeal.

Transactions

The transaction export contains data representing all the information sent to and/or received back from the payment gateway when processing a transaction.

Date Range Filter

Created

Transactions that were created during the selected time range, reflected by the "date" column of the export

Modified

Transactions that were modified during the selected time range, reflected by the "modified_at" column of the export

Export Contents

Column Name
Example
Description

account_code

123sd341

Account code that the transaction was charged to.

name

JJ Smith

Name of customer, as provided on their billing information.

transaction_id

6c17ba39e8734ebaa5bf98fff6d91bb9

Unique Recurly transaction identifier.

type

authorization, purchase, refund

Identifies the type of transaction that was reported to the gateway.

amount

9.95

Total transaction amount sent to the payment gateway.

tax_amount

15.00

Amount of transaction from tax charges.

currency

USD

Currency reported to the payment gateway for processing.

date

2012-01-19 11:16:41 PST

Date and time the transaction occurred. Used for created date range filter.

status

declined, void, success, processing

Transaction response from the payment gateway.

message

This transaction has been approved

Transaction message from the payment gateway.

test

TRUE, FALSE

Identifies whether or not the transaction was done on a production gateway.

cc_type

visa, master, discover, amex, jcb, diners

Type of credit card used to process the transaction.

cvv_result

M, N

When processed, result from checking the CVV/CVC value on the transaction.

avs_result

N, P, D

When processed, result from checking the overall AVS on the transaction.

avs_result_postal

N, Y

When processed, result from checking the zip code verification on the transaction.

avs_result_street

N, Y

When processed, result from checking the address 1 value on the transaction.

reference

4119385445

Transaction identifier from the payment gateway.

approval_code

varies by gateway

Transaction approval code from the payment gateway.

description

varies by gateway

Transaction description sent to the payment gateway.

state

CA

Customer state value from the account's billing information.

country

US

Customer country value from the account's billing information.

ip_address_country

US

When provided, the country associated with the IP address of customer's location when processing transaction.

original_transaction_id

6b9fc18e2497498b9e3700cd55e2ea84

For refunds, this field identifies the payment being refunded.

invoice_id

4bdb2171cebe4ecfb0cb129bd1a65746

References the invoice that generated this transaction.

subscription_id

3252sdasdbe4ecfb0cb129bd1a65746

References the subscription that generated this transaction.

po_number

AE12523

Purchase order number for the invoice.

collection_method

automatic, manual

Type of collection method used for the invoice.

transaction_gateway_type

test, wirecard, authorize, etc

Identifies the payment gateway used to process the transaction.

modified_at

2014-01-01 10:00:00 PST

This field identifies the date/time the transaction was last updated. Used for modified date range filter.

origin

recurring, API, hpp

This field identifies what created the transaction.

gateway_error_codes

500

For declined transactions, this field lists the gateway error code, if applicable.

payment_method

PayPal, Amazon Payment, Credit Card, ACH, EFT, Wire Transfer, Money Order, Check, Apple Pay or Other.

Identifies how the payment was made.

collected_at

2014-01-01 10:00:00 PST

For manually recorded payments, this reflects the date specified when recording the transaction.

fraud_decision

DECLINE, REVIEW, APPROVE

Contains the decision returned by Kount risk check service for this transaction.

fraud_score

36 (possible values are between 1 and 99)

The risk score assigned by Kount's risk check service for this transaction.

fraud_message

"848742"=>"BIN <> Billing Country"

Contains all the rules that were triggered during the risk check service.

failure_type

invalid_payment_method_hard

Provides additional information regarding the failure type of a transaction.

gateway_code

ih06u98jfoto

Denotes the gateway that was used for each transaction.

cc_first_6

111111

First six numbers of the credit card used to process the transaction.

Transaction Export


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.