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

N 16

Adyen's 16-digit 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 into Adyen's system.
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 Settings | 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.
Allowed 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

Dynamic Currency Conversion: indicates whether DCC was used or not during a transaction.

This information is available only when DCC is configured for a POS integration.
If DCC 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

  

Questions

Can't find something you are looking for? Look at our FAQ for answers or send an email to support.