Transactions Export

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

Version Change Log

Version 5 - 4/20/21

  • Column changes: Added 'backup_payment_method_used' column to the end of the export to identify if the transaction was initiated by a backup payment method attempt

Version 4 - 5/23/2019

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

Version 3 - 4/25/2019

  • Column additions: "cc_first_6"

Version 2 - 1/15/2019

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

Date Range Filters

Created

Transactions that were created during the selected time range. Uses the "date" column of the export.

Modified

Transactions that were modified during the selected time range. Uses the "modified_at" column of the export.

Export Contents

Column NameExampleDescription
account_code123sd341Account code that the transaction was charged to.
nameJJ SmithName of customer, as provided on their billing information.
transaction_id6c17ba39e8734ebaa5bf98fff6d91bb9Unique Recurly transaction identifier.
typeauthorization, purchase, refundIdentifies the type of transaction that was reported to the gateway.
amount9.95Total transaction amount sent to the payment gateway.
tax_amount15.00Amount of transaction from tax charges.
currencyUSDCurrency reported to the payment gateway for processing.
date2012-01-19 11:16:41 PSTDate and time the transaction occurred. Used for created date range filter.
statusdeclined, void, success, processingTransaction response from the payment gateway.
messageThis transaction has been approvedTransaction message from the payment gateway.
testTRUE, FALSEIdentifies whether or not the transaction was done on a production gateway.
cc_typevisa, master, discover, amex, jcb, dinersType of credit card used to process the transaction.
cvv_resultM, NWhen processed, result from checking the CVV/CVC value on the transaction.
avs_resultN, P, DWhen processed, result from checking the overall AVS on the transaction.
avs_result_postalN, YWhen processed, result from checking the zip code verification on the transaction.
avs_result_streetN, YWhen processed, result from checking the address 1 value on the transaction.
reference4119385445Transaction identifier from the payment gateway.
approval_codevaries by gatewayTransaction approval code from the payment gateway.
descriptionvaries by gatewayTransaction description sent to the payment gateway.
stateCACustomer state value from the account's billing information.
countryUSCustomer country value from the account's billing information.
ip_address_countryUSWhen provided, the country associated with the IP address of customer's location when processing transaction.
original_transaction_id6b9fc18e2497498b9e3700cd55e2ea84For refunds, this field identifies the payment being refunded.
invoice_id4bdb2171cebe4ecfb0cb129bd1a65746References the invoice that generated this transaction.
subscription_id3252sdasdbe4ecfb0cb129bd1a65746References the subscription that generated this transaction.
po_numberAE12523Purchase order number for the invoice.
collection_methodautomatic, manualType of collection method used for the invoice.
transaction_gateway_typetest, wirecard, authorize, etcIdentifies the payment gateway used to process the transaction.
modified_at2014-01-01 10:00:00 PSTThis field identifies the date/time the transaction was last updated. Used for modified date range filter.
originrecurring, API, hppThis field identifies what created the transaction.
gateway_error_codes500For declined transactions, this field lists the gateway error code, if applicable.
payment_methodPayPal, Amazon Payment, Credit Card, ACH, EFT, Wire Transfer, Money Order, Check, Apple Pay or Other.Identifies how the payment was made.
collected_at2014-01-01 10:00:00 PSTFor manually recorded payments, this reflects the date specified when recording the transaction.
fraud_decisionDECLINE, REVIEW, APPROVEContains the decision returned by Kount risk check service for this transaction.
fraud_score36 (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_typeinvalid_payment_method_hardProvides additional information regarding the failure type of a transaction.
gateway_codeih06u98jfotoDenotes the gateway that was used for each transaction.
cc_first_6111111First six numbers of the credit card used to process the transaction.
backup_payment_method_usedtrue, falseIdentifies if the transaction was initiated by a backup payment method attempt