Payments

The available fields in the 'Payments' data source and their corresponding descriptions are listed below.

Field	Description
Fraud Flag	Indicates whether or not the transaction has been identified as fraudulent. Possible values are safe, suspicious,fraudulent.
Gateway Transaction ID	Displays the ID with which this transaction is referred by the gateway.
Gateway Account ID	Displays the gateway used for the transaction.
Masked Card Number	Displays the masked card number used for the transaction. Applicable only for 'Card' Payment Method.
Capturable Amount	Displays the unused but authorized amount present for this transaction. Applicable only for Authorization transactions.
Unused Amount	Displays the unused amount present for this transaction. Applicable only for Payments.
Authorization Reason Code	TDisplays the type of authorization. Possible values are blocking_funds, verification.
Settled On	Displays the time at which the final status of the transaction has been marked.
Reference Authorization ID	Displays the original authorization transaction id that got captured. Applicable only for payment transactions.
Amount	Displays the amount for the transaction.
Amount (Transaction Currency)	Displays the amount in the specified transaction currency for the payment.
Reversal Transaction ID	Displays the reversal transaction id. Applicable only for payment transactions.
Voided On	Timestamp indicating when the payment was voided or authorization expired at gateway.
Payment Gateway	Gateway through which this transaction was done. Applicable only for 'Card' Payment Method.
Error Code	Displays the Error code received from the payment gateway on failure.
Status	Displays the status of this transaction. Possible values are in_progress, success, voided, failure, timeout, needs_attention.
Currency	The currency code (ISO 4217 format) for the transaction.
Reference Number	Displays the reference number for the transaction. e.g check number in case of 'check' payments.
Type	Displays the type of the transaction. Possible values are authorization, payment, refund, payment_reversal.
Transaction Date	Indicates when this transaction occurred.
Fraud Reason	Displays the description why the transaction was marked as fraud/suspicious.
Transaction ID	Displays the transaction ID.
Payment Method	Displays the Payment Method of this transaction. Possible values are card, cash, check, chargeback, bank_transfer, amazon_payments, paypal_express_checkout, direct_debit, alipay, unionpay, apple_pay, wechat_pay, ach_credit, sepa_credit, other.

Was this article helpful?