Skip to main content

Payment Reports

This section describes the Payments reports available from Payen.

Payment Report Variants

There are 3 variations of the report, that all share the same format:

ReportDescription
Payment ReportAll transactional data by operation.
Credit ReportThe Payment report filtered to only include Credits.
Refund ReportThe Payment report filtered to only include Refunds.

Payment Report File Format

The following table describes the format of the Payen payment files.

FieldDescriptionData Type
Transaction IdAn ID representing the transaction.Numeric - max 19 digits.
Entry DateA timestamp for when the request was made.Alphanumeric - ISO 8601 date/time format (YYYY-MM-DD hh:mm:ss).
Processed DateA timestamp for when the request was processed.Alphanumeric - ISO 8601 date/time format (YYYY-MM-DD hh:mm:ss).
MerchantThe assigned merchant identifer used to process the request.Alphanumeric - max 50 chars.
AccountThe assigned account identifier used to process the request.Alphanumeric - max 50 chars.
Merchant ReferenceThe unique value provided by the merchant for the request.Alphanumeric - max 29 chars.
TypeThe type of action which has been undertaken.Alphanumeric - Operation Type - e.g. Auth, Capture, Refund
Transaction TypeA value to indicate the type of transaction.Alphanumeric - Possible values: E-Commerce (Customer Not Present), Mail Order (Customer Not Present), Telephone Order (Customer Not Present).
Processed AmountTransaction value.Numeric Decimal - max 12 digits.
CurrencyThe currency of the processed amount.Alphanumeric - ISO 4217 3 char currency code - e.g. CAD.
ResultThe result code of the request.Alphanumeric - Status Code - e.g. Success, Rejected, Pending.
Result MessageContains the textual representation of the result codeAlphanumeric - max 1024 chars.
Payment Method TypeAn enumerated list of possible payment method type valuesAlphanumeric - e.g. Card.
Auth CodeThe authorisation code provided by the acquirer.Alphanumeric - max 20chars.
Card BinThe card bin used for the payment attempt.Numeric - max 6 chars.
Card Last FourThe card last four used for the payment attempt.Numeric - max 4 chars.
Card TypeThe Card Type.Alphanumeric - e.g. Visa Credit, Mastercard Debit.
Card Issuing CountryThe card issuer country.Alphanumeric - ISO 4217 3 char currency code - e.g. CAD.
Card Issuing BankThe card issuer bank.Alphanumeric - max 255 chars.
Card StartValid or start Date on the card.Alphanumeric - format MMYYYY.
Card ExpiryExpiry Date on the card.Alphanumeric - format MMYYYY.
Customer IdA merchant supplied customer identifier.Alphanumeric - max 255 chars.
Email AddressThe email of the customer.Alphanumeric - match to regex ^[a-zA-Z0-9._+-]{1,99}@[a-zA-Z0-9._-]{1,99}\.[\w]{2,11}$.
SourceThe source of the request.Alphanumeric - e.g. IP.Frame.
OriginThe endpoint called to make the request.Alphanumeric - e.g. IP.Frame Capture.
ISO-8583 Response CodeA normalised code representing the processor response.Alphanumeric - ISO-8583 response code.
AVS Address ResultResult of the AVS address check.Alphanumeric - Possible values: Matched, Not Matched, Not Checked, Not Required.
AVS Post Code ResultResult of the AVS post code check.Alphanumeric - Possible values: Matched, Not Matched, Not Checked, Not Required.
CVV2 ResultThe result of the CVV check.Alphanumeric - Possible values: Matched, Not Matched, Not Checked, Not Required.
3D Secure StatusThe overall 3-D Secure status of the transaction.Alphanumeric - ThreeDSSecureStatus - e.g. Authentication Successful.
Gateway ReferenceA unique value provided by the payment gatewayAlphanumeric - max 32 chars.
Processor RefThe processor reference (when available).Alphanumeric - max 32 chars.
External Card TokenA reusable token uniquely representing the payment instrument.Alphanumeric - max 255 chars.
Caller IPThe request caller IP addressAlphanumeric - IPv4 or IPv6 format.
Name on CardThe card holder name, as entered by the user, and used for the paymentAlphanumeric - max 255 chars.
First NameThe customer's first name (permissioned)Alphanumeric - max 255 chars. This field is only populated for merchants with extended customer information enabled.
SurnameThe customer's last name (permissioned)Alphanumeric - max 255 chars. This field is only populated for merchants with extended customer information enabled.
D.O.B.The customer's date of Birth (permissioned)Alphanumeric - ISO 8601 date format (YYYY-MM-DD). This field is only populated for merchants with Extended customer information enabled.
MobileThe customer's mobile number (permissioned)Alphanumeric - max 255 chars. This field is only populated for merchants with extended customer information enabled.
Operation ReferenceUnique reference for the operation performed in response to the payment request.Alphanumeric - max 25 chars.

Operation Types

Transactions are composed of many types of operation. These are defined here:

Operation TypeDescription
AuthAn authorization
Auth CaptureA combined authorization and capture of funds
Bank TransferA bank transfer
CaptureA capture of funds against a prior authorization
ConfirmA payment confirmation
PaymentAn alternative payment
ReversalA payment reversal
VoidA payment void
CreditA credit
RefundA refund

Result Codes

The following result codes may be generated for a transaction:

Result CodeDescription
SuccessThe transaction was sucessful
DeclinedThe transaction was declined
RejectedThe request was rejected
ErrorAn internal or external error occured
TimeoutA downstream service communication timeout occured
CancelledThe transaction was cancelled part way through
CVV2 Check FailedThe CVV2 check failed
AVS Address Check FailedThe AVS address check failed
AVS Post Code Check FailedThe AVS postcode check failed
Informer ExceptionAn exception occured communicating with a downstream service
PendingThe operation is pending with a downstream service

ThreeDSSecure Status

The following outcomes are possible for the ThreeDSSecure Status:

Status CodeDescription
Pending
Authentication SuccessfulSuccessful authentication
Authentication FailedFailed authentication
Not EnrolledCard not participating / card holder not enrolled in the scheme / Issuer is not registered for VbV or SecureCode / customer not signed up, but Issuer allows customer to continue without signing up
Authentication UnavailableDirectory Server or ACS may return 'unavailable' status / data communication problems / unknown scheme
Authentication AttemptedACS implementations may produce signed 'attempt' messages even in cases where the issuer or cardholder is not participating.
ACS ErrorMerchant authentication in Directory Server failed / Error message received from Directory Server or ACS
Internal ErrorAn internal error occured