This feature or setting is available to all customers on any Recurly subscription plan.
The Transactions export section provides a detailed report of all interactions communicated to and received from the payment gateway while processing a transaction. This data gives you a deeper understanding of every payment interaction to help you manage your financial transactions better.
Involves transactions created within a chosen time span, utilizing the "date" column in the export.
Entails transactions modified in a selected time range, reflected in the "modified_at" column in the export.
To help you identify and organize information effectively, the export provides a structured table that contains the following columns:
|account_code||123sd341||The specific account code charged during the transaction.|
|name||JJ Smith||Customer name as stated in their billing data.|
|transaction_id||6c17ba39e8734ebaa5bf98fff6d91bb9||Unique identifier for the transaction within Recurly.|
|type||authorization, purchase, refund||Specifies the type of transaction reported to the gateway.|
|amount||9.95||The total amount of the transaction sent to the payment gateway.|
|tax_amount||15.00||The tax charges associated with the transaction.|
|currency||USD||The currency reported to the payment gateway for transaction processing.|
|date||2012-01-19 11:16:41 PST||The date and time the transaction took place. Used for "created" date range filter.|
|status||declined, void, success, processing||The response received from the payment gateway concerning the transaction.|
|message||This transaction has been approved||Message received from the payment gateway regarding the transaction.|
|test||TRUE, FALSE||Indicates if the transaction was carried out on a production gateway.|
|cc_type||visa, master, discover, amex, jcb, diners||The type of credit card utilized for the transaction.|
|cvv_result||M, N||The result from checking the CVV/CVC value on the transaction when it was processed.|
|avs_result||N, P, D||The overall AVS result from checking the transaction when it was processed.|
|avs_result_postal||N, Y||The result from verifying the zip code on the transaction when it was processed.|
|avs_result_street||N, Y||The result from verifying the address 1 value on the transaction when it was processed.|
|reference||4119385445||The identifier for the transaction from the payment gateway.|
|approval_code||varies by gateway||The approval code for the transaction from the payment gateway.|
|description||varies by gateway||The description sent to the payment gateway for the transaction.|
|state||CA||The state value from the customer's billing information on the account.|
|country||US||The country value from the customer's billing information on the account.|
|ip_address_country||US||The country associated with the IP address of the customer's location when the transaction was processed.|
|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 instigated this transaction.|
|po_number||AE12523||The purchase order number for the invoice.|
|collection_method||automatic, manual||The type of collection method used for the invoice.|
|transaction_gateway_type||test, wirecard, authorize, etc||The payment gateway utilized to process the transaction.|
|modified_at||2014-01-01 10:00:00 PST||The date/time the transaction was last updated. Used for the "modified" date range filter.|
|origin||recurring, API, hpp||Identifies what initiated the transaction.|
|gateway_error_codes||500||Lists the gateway error code for declined transactions, if applicable.|
|payment_method||PayPal, Amazon Payment, Credit Card, etc||Specifies the method used for payment.|
|collected_at||2014-01-01 10:00:00 PST||For manually recorded payments, this reflects the specified date when recording the transaction.|
|fraud_decision||DECLINE, REVIEW, APPROVE||Contains the decision returned by the Kount risk check service for this transaction.|
|fraud_score||36 (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 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||The gateway used for each transaction is denoted here.|
|cc_first_6||111111||The first six digits of the credit card used for processing the transaction.|
|vat_number||EU12345678||The VAT or Tax ID number of the customer during the transaction in the export.|
|backup_payment_method_used||TRUE, FALSE||Indicates whether a backup payment method was used in the transaction attempt.|
|vat_number||123456||Indicates vat number.|
- Column Changes: Introduced "vat_number" column for merchants to capture customer's VAT or Tax ID number during a transaction in the export.
- Column Changes: The 'backup_payment_method_used' column was added at the end of the export to identify transactions initiated through a backup payment method attempt.
- Column Changes: 'cc_first_6' column incorporated at the end of the export.
- Column Additions: Addition of "cc_first_6" column.
- Mapping: New payment gateway mappings included for Adyen, Qiwi, SEPA, SOFORT, and iDeal.
Updated 12 days ago