Default columns

The following columns are included by default.

Name	Description
State	The transaction state.
Mer. Trans. ID	The merchant transaction ID.
Sys. Trans. ID	The system transaction ID.
Mer. Trans. Date	The merchant transaction date.
Parent Sys. Trans. ID	The parent system transaction ID.
Transaction creation date	The transaction creation date.
Mer.	The merchant ID.
Site	The site ID.
Intent	The transaction intent.
Funding type	The transaction funding type.
Entry type	The transaction entry type.
MIT type	The MIT type.
Authorised amount (total)	The total authorised amount.
Original amount	The original transaction amount.
Currency	The transaction currency, in ISO 4217 format.
Card scheme	The card scheme.

Additional columns

The following columns aren't included by default, but can be added.

Name	Description
Scheme transaction id	The scheme transaction ID.
Owner type	The owner type. This can be either `Consumer`/`Individual` or `Commercial`/`Corporate`.
Last 4 digits of the card	The last four digits of the payment card.
BIN	The card's Bank Identification Number (BIN).
Issuer country	The issuer country.
Issuer name	The issuer name.
Funding source	The funding source. This can be `Credit`, `Debit`, or `Prepaid`.
3DS authentication state	The 3DS authentication state.
3DS version	The 3DS version.
Authentication flow	The authentication flow.
Is SCA mandated	Whether the transaction was SCA mandated.
Requestor challenge indicator	The requestor challenge indicator.
Is exemption granted	Whether exemption was granted.
Granted exemption by Issuer	Whether exemption was granted by the issuer.
SCA exemption	Whether there was an SCA exemption.
Total captured amount	The total amount that was captured.
Canceled amount	The cancelled amount.
Gateway token Id	The gateway token ID.
Merchant shopper Id	The merchant shopper ID.
Shopper first name	The shopper's first name.
Shopper last name	The shopper's last name.
Shopper country	The shopper's country.
Shopper state	The shopper's state.
Shopper city	The shopper's city.
ECI	The ECI. For example, `05`.
CVC result	The CVC result.
AVS result	The AVS result.
MAC	The MasterCard Merchant Advice Code. If present, this provides insights into why a transaction was declined. For example, `41` means that a single-use virtual card number was used.
Payment account reference	The payment account reference.
ISO response code	The ISO response code.
Wallet type	The wallet type. For example, `ApplePay`.