The Received payment details report provides details about all authorized and refused payments you processed through Adyen, including shopper interaction, risk score, and acquirer response.
Requirements
Before you begin, take into account the following requirements and preparations.
| Requirement | Description |
|---|---|
| Integration type | You must be onboarded as a franchisee by your franchisor. For more information, see Onboarding. |
| Customer Area roles | To download the report, you must have the following role: Generate key financial reports. |
This report contains personal shopper data such as card numbers, email addresses, and billing addresses. If you access unmasked shopper data, it can affect your PCI DSS compliance level. To download unmasked data, your user must have the Merchant View PII role.
Get the report
To generate and download the report:
- Log in to your Customer Area.
- Go to Reports > Reports overview.
- Select Received payment details report. You see a list of all generated Received payment details reports.
- Select Generate report to generate the report manually, or select Modify automatic generation to set up automatic generation.
Report structure
Entries
Under the header line, each line in the report is a separate entry.
Standard columns
| # | Column | Data type | Description |
|---|---|---|---|
| 1 | Company Account | Unicode Text (80-character) | The name of your company account as registered in the Adyen payments platform. |
| 2 | Merchant Account | Unicode Text (80-character) | The name of the merchant account that was used to process the original payment request. The report may contain line items for multiple merchant accounts. |
| 3 | Psp Reference | Unicode Text (16-character limit) | Adyen's 16-character unique reference associated with the transaction/the request. This value is globally unique; quote it when communicating with us about this request. |
| 4 | Merchant Reference | Unicode Text (80-character) | The reference that was specified in the payment request. |
| 5 | Payment Method | Unicode Text (30-character) | The payment method used for the transaction. For example: visa, mc, mc_applepay, amex. |
| 6 | Creation Date | String | The timestamp indicating when the payment was created on the Adyen payments platform. Format: YYYY-MM-DD HH:MM:SS. For example: 2012-07-26 19:58:55. |
| Creation Date Time Zone | Alpha Text (4-character limit) | The time zone of the Creation Date. This is the ISO code for your time zone setting. |
|
| 7 | Currency | Unicode Text (3-character limit) | The three-character ISO currency code. |
| Amount | Numeric or String (only in .XLS and .XLSX report files) |
The amount of the payment (authorization amount). Always a positive value, even if the payment was canceled before being captured. | |
| 8 | Type | Unicode Text (50-character) | The record type. For this report, the value is always Payment. |
| 9 | Risk Scoring | Integer | The total risk score of the payment. |
| 10 | Shopper Interaction | Alpha Text (30-character limit) | The transaction type. Possible values: Ecommerce, ContAuth, POS, MOTO. |
| 11 | Shopper Name | Unicode Text (80-character) | The name of the cardholder, as specified in the transaction, if available. |
| 12 | Shopper PAN | Alphanumeric (80-character) | The Primary Account Number (PAN). In case of card payments, the last four digits of the card number. For SEPA, this field shows the IBAN and BIC in the following format: IBAN/BIC |
| 13 | Shopper IP | Unicode Text (50-character) | The IP address (IPV4 or IPV6) of the shopper as specified in the original transaction, if available. |
| 14 | Shopper Country | Alpha Text (2-character limit) | The ISO country code of the shopper, if available. If not available, this is computed based on the shopper's IP address. |
| 15 | Issuer Name | Unicode Text | The name of the issuing bank, if available. |
| 16 | Issuer Id | Alphanumeric (30-character limit) | The unique identifier of the issuer. In case of card payments this will be the issuer BIN (first six digits of the card number). |
| 17 | Issuer City | Unicode Text (80-character) | The city of the issuer, if available. |
| 18 | Issuer Country | Alpha Text (2-character limit) | The ISO country code of the issuer. |
| 19 | Acquirer Response | Alphanumeric | The normalized response from the acquirer. Not necessarily the final status of the payment. When a payment is canceled before being captured, the acquirer response is Unknown. |
| 20 | Authorisation Code | Unicode Text (50-character) | The authorisation code returned for a successful payment. |
| 21 | Shopper Email | Unicode Text (256-character) | The email address of the shopper, as specified in the original transaction, if available. |
| 22 | Shopper Reference | Unicode Text (256-character) | The shopper ID or reference that was specified in the original transaction. |
| 23 | 3D Directory Response | Alpha Text (1-character limit) | For payments processed with 3D Secure (Secure Code/Verified by Visa), the 3D Directory response. Values: Y, N, U, E |
| 24 | 3D Authentication Response | Alpha Text (1-character limit) | For payments processed with 3D Secure (Secure Code/Verified by Visa), and directory response Y, this holds the authentication response. Values: Y, N, U, A, E |
| 25 | CVC2 Response | Text field Numeric (1-Character limit) | The result passed back by the issuer after verifying the CVC2, or CVV2/CID in case of Visa/Amex. |
| 26 | AVS Response | Text field Numeric (2-Character limit) | If Address Verification (AVS) was performed, the result of the AVS Check. |
| 27 | Billing Street | Unicode Text (256-character) | The street part of the billing address. |
| 28 | Billing House Number / Name | Unicode Text (256-character) | The house number or name part of the billing address. |
| 29 | Billing City | Unicode Text (256-character) | The city part of the billing address. |
| 30 | Billing Postal Code / ZIP | Unicode Text (30-character) | The ZIP code or postal code part of the billing address. |
| 31 | Billing State / Province | Unicode Text (256-character) | The state or province of the billing address. |
| 32 | Billing Country | Alpha Text (2-character limit) | The ISO country code of the billing address. |
| 33 | Delivery Street | String | The street part of the delivery address. |
| 34 | Delivery House Number / Name | String | The house number or name part of the billing address. |
| 35 | Delivery City | String | The city part of the delivery address. |
| 36 | Delivery Postal Code / ZIP | String | The ZIP code or postal code part of the delivery address. |
| 37 | Delivery State / Province | String | The state or province of the delivery address. |
| 38 | Delivery Country | String | The ISO country code of the delivery address. |
| 39 | Acquirer Reference | String | The reference number for the transaction provided by the acquirer. |
| 40 | Payment Method Variant | Unicode Text (32-character) | The payment method sub-brand, or the main payment method if not available (for example mccredit or visagold). |
| 41 | Raw Acquirer Response | String | The raw response received from the acquirer, where available. When a payment is canceled before being captured, the raw acquirer response is empty. |