Payments report

This report provides a standardized view of authorization health and transaction outcomes across your entire processing portfolio. By aggregating fragmented provider data, it offers granular visibility into authorization success rates, failure reasons, and technical payment attributes like 3DS status and token types.

Columns

Column	Type	Description
created_at	TIMESTAMP_NTZ	Date when Payment has been created.
updated_at	TIMESTAMP_NTZ	Date when latest payment event has happened.
timezone	VARCHAR	Timezone in which the session happened.
merchant_id	VARCHAR	Unique identifier of the merchant.
workspace_id	VARCHAR	Workspace identifier mapped from the merchant, used for Payrails reporting.
payrails_payment_id	VARCHAR	Unique identifier of the Payment in Payrails.
payrails_execution_id	VARCHAR	Unique identifier of the execution.
holder_id	VARCHAR	ID of the payer (holder).
merchant_reference	VARCHAR	Payment reference provided by the merchant.
provider_name	VARCHAR	Provider who processed the payment.
provider_account_name	VARCHAR	Provider account display name.
provider_reference	VARCHAR	Unique identifier of the Payment in an external system, e.g. PSP.
is_zero_auth	BOOLEAN	If payment is zero authorization.
status	VARCHAR	Final status of the payment.
is_authorized	BOOLEAN	If payment was authorized.
authorization_failure_result	VARCHAR	Transformed authorization failure response code, provides more details on failed transactions than status.
processing_type	VARCHAR	Payment processing type, values: Regular, Subscription, CardOnFile, UnscheduledCardOnFile
currency	VARCHAR	Three-letter ISO currency code, in uppercase.
amount	NUMBER	Payment amount in local currency.
captured_amount	NUMBER	Amount that was captured from the Payment in local currency. If no capture is initiated for the payment, the value will be 0 until a successful capture occurs.
refunded_amount	NUMBER	Amount that was refunded from the Payment in local currency. If multiple partial refunds have been made, this will be the sum of them. If no refund is initiated for the payment, the value will remain 0 until a successful refund occurs.
has_threeds	BOOLEAN	Whether payment went through 3ds.
threeds_id	VARCHAR	Unique identifier of the associated 3ds object.
eci	VARCHAR	Electronic commerce indicator
payment_method_type	VARCHAR	Payment method type, values: card, easypaisa, jazzCash, fawryPay, etc.
bin	NUMBER	First 6-8 digits of the Card number. Also known as IIN (Issuer Identification Number). Card only.
issuer	VARCHAR	Card issuing bank.
issuer_country_code	VARCHAR	ISO alpha-2 issuer country.
issuer_country_name	VARCHAR	English name of the country of the bank or institution that issued the card. Card only.
card_network	VARCHAR	Card network that supports the card, e.g. Visa, Mastercard, American Express. Card only.
card_local_network	VARCHAR	Card local network that supports the card, e.g. CartesBancaires, Dankort, Mada, Bancontact.
card_segment	VARCHAR	Segment of the card, e.g. gold, black, business. Card only.
card_type	VARCHAR	Card type, values: credit, debit, notset, prepaid.
card_type_details	VARCHAR	More information about the card type, e.g. personal, commercial. Card only.
token_id	VARCHAR	Instrument Token ID related to the payment.
token_type	VARCHAR	Type of the token, values: network, vault, psp, networkOffers.
error_reason_source	VARCHAR	Source of the error reason (null if payment was successful).
error_reason_detail	VARCHAR	Details of the error reason (null if payment was successful).
error_reason_result	VARCHAR	End result of the error reason (null if payment was successful).
error_reason_category	VARCHAR	Category of error reason (null if payment was successful).
error_detail	VARCHAR	Details of the error (null if payment was successful).
is_success	BOOLEAN	Whether execution action was succeeded.
milliseconds_to_completion	NUMBER	Time from request to completion in milliseconds.
raw_psp_response	VARIANT	PSP result details for Authorize operation.
meta	VARIANT	Complete merchant's metadata details (ex: customer, order, risk, tags, etc.).