Transactions report
This report provides details on all transactions which impact your account balance.
This report can be used to reconcile individual transactions.
Columns
| Column | Type | Description |
|---|---|---|
| transaction_id | STRING | A unique identifier of the transaction in UUID format. |
| transaction_type | STRING | The type of transaction. Currently supported types: Capture, Refund |
| created_at | TIMESTAMP | The timestamp at which the transaction was processed in the timezone of the report |
| timezone | STRING | The timezone of the report in IANA timezone format. |
| merchant_reference | STRING | The merchant reference related to the transaction. For example, the order_id. |
| provider_reference | STRING | The providers reference for the payment which this transaction relates to. |
| payment_id | STRING | The payment identifier to which this transaction is related to. |
| provider_code | STRING | The code for the provider with which the transaction was processed. |
| currency | STRING | The processing currency of the transaction |
| amount | FLOAT | The amount of the transaction in the processing currency. |
| payment_method_code | STRING | The Payment method code is a unique code for each payment method in the Payrails system. |
| card_last4 | STRING | If the payment_method is card, the last four digits of the card number. |
| card_network | STRING | If the payment_method is card, the network over which the transaction is processed. |
| card_type | STRING | The type of card used for processing. |
| installment_count | INTEGER | The number of installments. |
| installment_cost | FLOAT | The financial cost associated with the installments. |
| batch_number | INTEGER | |
| coupon_number | INTEGER |
Reference
| Field | Possible values |
|---|---|
| provider_code | adyen, amex, aplazo, applepay, boku, braintree, checkout, citibank, cybersource, dlocal, fawry, flutterwave, googlepay, gosas, hyperpay, kueski, lidio, mangopay, mercadopago, mobimoney, myfatoorah, nium, nuvei, payflex, payjustnow, paypal, payu, platron, stripe, tap, telr, testhelpers, testpsp, thunes. |
| payment_method_code | alexBankMa7fazty, applePay, audi2pay, alfa, bankTransfer, card, cibSmartWallet, easypaisa, etisalatCash, fawryMobileWallet, fawryPay, googlePay, jazzCash, mercadoPago, monoDirectDebit, nbePhoneCash, orangeCash, oPayWallet, pagaWallet, payflex, payjustnow, payPal, pix, konnect, qnbEWallet, wafaCashWallet, weCash, genericRedirect, eftPro, upi, cashFreeWallet, paytmMWallet, netBanking. |
| card_network | atm, amex, argencard, aura, bc, bpfuelcard, bancomat, bancontact, bankcard, belkart, chjonesfuelcard, cmi, cmr, cabal, carnet, cartesbancaires, cencosud, cirrus, codensa, cobroexpress, dankort, dinacard, diners, discover, duet, ebt, eftpos, electron, elo, euroshellfuelcard, fuelcard, gecapital, girocard, hrgstore, hipercard, humo, interac, jcb, jcblankapay, lankapay, localbrand, loyalty, lukoilfuelcard, mir, mada, maestro, maestrobancontact, mastercard, mastercardmada, meeza, naranja, newday, ourocard, phhfuelcard, prostir, pagobancomat, pagofacil, paypak, paypal, privatelabel, rapipago, redfuelcard, redliquidfuelcard, rupay, sbercard, sodexo, sol, surcredito, starrewards, troy, tarjetashopping, uatp, ukfuelcard, unionpay, unionpayuzcard, unspecified, uzcard, vpay, verve, visa, visadankort, visamada, voyager, wex. |
| card_type | CREDIT, DEBIT |
| currency | Three letter ISO 4217 currency code (e.g. USD). |
Updated 13 days ago