Received payment detail report

The received payment detail contains the details for all the received transactions in the given date range.

Position

Column name

Data type

Description

1

Company Account

C X80

The static name of your company account within the Adyen payments platform.

2

Merchant Account

C X80

The static 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

C 16

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

C X80

This is the reference number that was provided when initiating the payment request.

5

Payment Method

C X30

The payment method type of the payment which was processed. For example: visa, mc, amex.

6

Creation Date

D+" "+T

The timestamp indicating when the payment was created, as entered in the Adyen payments platform.
Format: YYYY-MM-DD HH:MM:SS.
For example: 2012-07-26 19:58:55.

7

TimeZone

A 4

The creation date time zone.
This is the ISO code for the time zone which is set up on your company account.
In the Customer Area, go to Account > Company Settings > Time Zone (BST, CET, CEST etc).

8

Currency

A 3

The three-character ISO currency code.

9

Amount

N 16

The amount of the payment (authorisation amount).

10

Type

C X50

The record type.
For this report, the corresponding value is always Payment.

11

Risk Scoring

I

The total risk scoring value of the payment.

12

Shopper Interaction

A 30

The transaction type.
Possible values:

  • Ecommerce
  • ContAuth
  • POS
  • Moto

13

Shopper Name

C X80

The name of the shopper/consumer, as provided with the transaction, if available.

14

Shopper PAN

AN X80

The account number of the shopper/consumer.
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.

15

Shopper IP

C X50

The IP address (IPV4 or IPV6) of the shopper/consumer as provided during the original transaction, if available.

16

Shopper Country

A 2

The ISO country code of the shopper (if available, otherwise computed based on the shopper's IP address).

17

Issuer Name

C X256

The name of the issuing bank, if available.

18

Issuer ID

AN 30

The unique identifier of the issuer.
In case of card payments this will be the issuer BIN (first 6 digits of the card number).

19

Issuer City

C X80

The city of the issuer (if available).

20

Issuer Country

A 2

The ISO country code of the issuer.

21

Acquirer Response

A X30

The normalised response from the acquirer.
Not necessarily the final status of the payment.

22

Authorisation Code

C X50

If the payment was not declined, the authorisation code.

23

Shopper Email

C X256

The email address of the shopper/consumer, as provided during the original transaction (if available).

24

Shopper Reference

C X256

The supplied customer id/reference as supplied in the original transaction.

25

3D Directory Response

A 1

For payments which were processed using 3D Secure (Secure Code / Verified by Visa), the directory response
(values: Y,N,U,E).

26

3D Authentication Response

A 1

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).

27

CVC2 Response

N 1

The result passed back by the issuer after verifying the CVC2 (or CVV2/CID in case of Visa/Amex).

28

AVS Response

N 2

If AVS (Address Verification) was performed, the result of the AVS check.

29

Billing Street

C X256

The street part of the billing address.

30

Billing House Number / Name

C X256

The house number or name part of the billing address.

31

Billing City

C X256

The city part of the billing address.

32

Billing Postal Code / Zip Code

C X30

The zip code or postal code part of the billing address.

33

Billing State / Province

C X256

The state or province of the billing address.

34

Billing Country

A 2

The ISO country code of the of the billing address.

35

Delivery Street

C X256

The street part of the delivery address.

36

Delivery House Number / Name

C X256

The house number or name part of the delivery address.

37

Delivery City

C X256

The city part of the delivery address.

38

Delivery Postal Code / Zip Code

C X30

The zip code or postal code part of the delivery address.

39

Delivery State / Province

C X256

The state or province of the delivery address.

40

Delivery Country

A 2

The ISO country code of the of the delivery address.

41

Acquirer Reference

C X256

Reference number for the transaction provided by the acquirer.

42

Payment Method Variant

C X30

The payment method sub-brand, or the main payment method if not available (e.g. mccredit or visagold).

43

Raw acquirer response

C X256

The raw response we receive from the acquirer, where available.

44

DCC

C X30

Indicates whether DCC was used during the transaction.

Possible values:

  • DCC accepted – The shopper accepted DCC and completed the transaction in their currency.
  • DCC declined – The shopper refused DCC and completed the transaction in the merchant's currency.
  • DCC not offered – The shopper and merchant both share the same currency, therefore DCC was not offered.

This information is available only when DCC reporting is turned on.
If DCC reporting is not activated, this columns reads Reserved 4.

45

Reserved 5

Reserved for future enhancements

46

Reserved 6

Reserved for future enhancements

47

Reserved 7

Reserved for future enhancements

48

Reserved 8

Reserved for future enhancements

49

Reserved 9

Reserved for future enhancements

50

Reserved 10

Reserved for future enhancements