Transactions report

This report can be used to reconcile individual transactions.

Columns

Column	Type	Description
workspace_id	VARCHAR	Workspace identifier mapped from the merchant, used for Payrails reporting.
merchant_id	VARCHAR	Unique identifier of the merchant.
payrails_payment_id	VARCHAR	Unique identifier of the Payment in Payrails.
payrails_execution_id	VARCHAR	Unique identifier of the execution.
action_id	VARCHAR	Unique identifier of this execution action.
merchant_reference	VARCHAR	The merchant reference related to the transaction. For example, the order_id.
action	VARCHAR	Type of action (authorize, refund, cancel).
created_at	TIMESTAMP_NTZ	Timestamp at which the action was created.
completed_at	TIMESTAMP_NTZ	Timestamp at which the action was completed.
timezone	VARCHAR	Timezone in which the session happened.
milliseconds_to_completion	NUMBER	Time from request to completion in milliseconds
is_success	BOOLEAN	Whether execution action was succeeded
is_completed	BOOLEAN	Whether event action is completed.
currency	VARCHAR	Three-letter ISO currency code, in uppercase
amount	NUMBER	Payment amount in local currency
provider_name	VARCHAR	Provider who processed the payment
provider_account	VARCHAR	Provider account display name.
provider_reference	STRING	The providers reference for the payment which this transaction relates to.
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).
has_threeds	BOOLEAN	Whether payment went through 3ds.
eci	VARCHAR	Electronic commerce indicator.
payment_method_type	VARCHAR	Payment method type, values: card, easypaisa, jazzCash, fawryPay, etc
card_bin	VARCHAR	4-digit BIN of the card.
card_network	VARCHAR	Card network that supports the card, e.g. Visa, Mastercard, American Express. Card only.
card_type	VARCHAR	The type of card used for processing, values: credit, debit, notset, prepaid.
card_type_details	VARCHAR	More information about the card type, e.g. personal, commercial. Card only.
card_segment	VARCHAR	Segment of the card, e.g. gold, black, business. Card only.
card_issuer	VARCHAR	Card issuing bank.
card_issuer_country_code	VARCHAR	ISO alpha-2 country code of card issuer.
card_issuer_country_name	VARCHAR	Full country name of card issuer.
token_id	VARCHAR	Instrument Token ID related to the payment
token_type	VARCHAR	Type of the token, values: network, vault, psp, networkOffers.
authorization_code	VARCHAR	Authorization code from issuing bank.
retrieval_reference_number	VARCHAR	Retrieval Reference Number (RRN).
network_transaction_reference	VARCHAR	Scheme-level transaction reference.
provider_response_additional_fields	VARIANT	PSP-specific additional response fields.
mapped_psp_response	VARIANT	Mapped/normalized PSP result details.
meta	VARIANT	Complete merchant's meta details.