Learn about the different types of data that can be included in reports.
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. |
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. |