Authorizations Report
Last updated: January 22, 2025
The Authorizations Report lists all authorization messages during a specified period. It provides information about:
- The authorization, the related transaction, and their statuses
- The card, its verification process, and any 3D Secure (3DS) challenge
- The conditions at the point of sale (PoS)
- Whether the authorization relay passed the authorization to you
- Any user-defined fields you specified during setup
The report is provided as a CSV file. By default, the file name uses the following format:
issuing_authorizations_{EntityID}_{Start Date: YYYYMMDD}_{End Date:YYYYMMDD}_1.csv
The report data is refreshed daily at 01:00:00 UTC.
See instructions on how to download the report on demand or on a schedule:
Download a sample report (CSV file).
Information
If using Safari, hold down the Option key when selecting the link to download the file.
The report includes the following fields in this order:
Field name | Description |
---|---|
Message ID string | The unique identifier for the authorization message. |
Client ID string | Your unique identifier from Checkout.com. |
Client Name string | Your Checkout.com client name. |
Entity ID string | The unique identifier for your Checkout.com entity. |
Entity Name string | The name of your Checkout.com entity. |
Cardholder ID string | The unique identifier for the cardholder. |
Card ID string | The unique identifier for the card. |
Transaction ID string | The unique identifier for the transaction, which links all related authorization, reversal, and clearing messages. |
Type string | The type of message. This can be one of:
|
Indicator string | The type of authorization. This can be one of:
|
Transaction Type string | The type of transaction. This can be one of:
|
Is Cleared boolean | Indicates whether the payment has cleared:
|
Is Relayed boolean | Indicates whether authorization relay sent you the authorization to approve or decline:
|
Status string | The status of the authorization. This can be one of:
|
Decline Reason string | The decline code you provided when you declined the authorization. If you approved the authorization, this field is empty. |
Verification Result Cryptogram string | Indicates whether the card’s identity was successfully verified. This can be one of:
|
Verification Result CVC1 string | Indicates whether the card validation code (CVC1) encoded in the magnetic stripe was successfully verified. This can be one of:
|
Verification Result CVC2 string | Indicates whether the card validation code (CVC2) printed on the card is valid. This can be one of:
|
Verification Result Expiry Date string | Indicates whether the card’s expiry date is still valid. This can be one of:
|
Verification Result PVV string | Indicates whether the pin verification value (PVV) was successfully verified. This can be one of:
|
Verification Result Service Code string | Indicates whether the three or four-digit number that specifies the card’s acceptance requirements and transaction limitations was successfully verified. This can be one of:
|
Transaction Currency string | The acquirer's local currency or the local currency where the transaction took place. |
Transaction Amount decimal | The amount for the transaction in the major currency unit. |
Billing Currency string | The currency you bill the cardholder in. |
Billing Amount decimal | The amount to bill the cardholder in the major currency unit. |
Is Issuer Reversed boolean | Indicates whether you, as the issuer, reversed the transaction:
|
Issuer Reversed Billing Amount decimal | The billing amount you reversed for the transaction in the major currency unit. |
3DS Version string | The 3D Secure (3DS) protocol version used for authorization. This can be one of:
|
Requested Exemption Type string | The type of exemption from 3DS requested for the transaction. This can be one of:
|
Has ECB Conversion Rate boolean | Indicates whether currency conversion is required at the European Central Bank (ECB) rate:
|
ECB Conversion Rate decimal | The European Central Bank (ECB) currency conversion rate against the euro applied to the transaction. |
Merchant ID string | The unique identifier for the merchant. This may vary per acquirer. |
Merchant Category Code integer | The merchant's four-digit category code. Merchants can have multiple category codes. |
Merchant Name string | The merchant's company name. |
Merchant Country Code string | The country where the merchant is registered. |
Merchant State string | For US merchants, the state where they are registered. For merchants outside the US, this value is |
Merchant City string | The city where the merchant is registered. |
POS Entry Mode string | The way the payment was captured at the point of sale (PoS). This can be one of:
|
Digital Card ID string | The unique identifier for the digital card. For a physical card, this field is empty. |
Verification Result Digital Card Expiry Date string | Indicates whether the digital card was successfully verified. This can be one of:
|
Xpay Device Type string | The type of device used for an Xpay transaction. If not relevant, this field is empty. |
Xpay Wallet Type string | The type of digital wallet used for an Xpay transaction. If not relevant, this field is empty. |
Created On UTC datetime | The date and time when the transaction was initiated in UTC. |
Transmitted By Scheme on UTC datetime | The date and time when the card scheme transmitted the authorization in UTC. |
Card Type string | The type of card. This can be one of:
|
Card Status string | The current status of the card. This can be one of:
|
Card Masked PAN string | The masked primary account number (PAN) for the card. |
Card Expiry Date datetime | The date and time when the card expires in UTC. |
Card Issuing Country string | The country where you issued the card. |
Card Display Name string | The display name you provided when creating the card. |
Card Reference string | The identification reference you provided when creating the card. |
Card UDF 1 string | A user-defined field (UDF) you specified during setup. |
Card UDF 2 string | A UDF you specified during setup. |
Card UDF 3 string | A UDF you specified during setup. |
Card UDF 4 string | A UDF you specified during setup. |
Card UDF 5 string | A UDF you specified during setup. |