Volume per refund file description

The -volume-per-refund.csv file includes a detail-level report of all refunds across all boarded merchants within a given settlement period. This is delivered every day when the settlement has been made along with the other 7 describing that settlement period.

The naming convention is:

<merchant number>-<frequency>-<year>-<ongoing number>-<suffix>.csv

Example: 1-999-W-2016-07-volume-per-refund.csv

The file will contain the following data:

MERCHANT_TX_IDAn optional merchant-provided identifier for the refund

RF_IDA PPRO-provided identifier for refundnumeric
PAYMENT_REFERENCEThe public identifier of the refundstring
EVENT_TYPEThe event type specifies the transaction event which triggers a fund movement. See the table below for details of each event typestring
EVENT_TIMESTAMPISO_8601 UTC timestamp (format YYYY-MM-DDThh:mm:ssZ) of the eventstring
MERCHANT_IDContract ID identifying each unique merchant as provided by PPRO upon onboardingstring
PAYMENT_METHODName of the payment method (e.g. “SEPA Direct Debit”)

AMOUNTThe refund amountnumeric
CURRENCY3-digit ISO currency code describing the amountstring
COUNTRY2-digit ISO country code describing the origin of the paymentstring
REFERENCE_TX_IDTX_ID of the original transaction of this refundnumeric

EVENT_TYPE Description

SUCCEEDEDA transaction in a technical successful state. Assumed OK if it never becomes FUNDSREJECTED
FUNDSREJECTEDStatus shown in the event PPRO is unable to push funds to a consumer.

Example: the consumer closed their bank account



When files are delivered in the SFTP, they will be zipped in a gzip format (*.gz). Please ensure that your system can extract gz files before processing.