Volume per transaction file description
The -volume-per-transaction.csv file includes a detail-level report of all payments across all boarded merchants within a given settlement period. This file is delivered every day when the settlement has been made along with the other 7 files describing that settlement period.
The naming convention is:
<merchant number>-<frequency>-<year>-<ongoing number>-<suffix>.csv
Example: 1-999-W-2016-07-volume-per-transaction.csv
The file contains the following data:
| Column | Description | Type |
|---|---|---|
MERCHANT_TX_ID | An optional merchant-provided identifier for the transaction[a-zA-Z0-9.,-_]{1,40} | string |
TX_ID | A PPRO-provided identifier for the transaction | numeric |
PAYMENT_REFERENCE | The public identifier of the transaction | string |
EVENT_TYPE | The event type specifies the transaction event which triggers a fund movement. See the table below for details of each event type | string |
EVENT_TIMESTAMP | ISO_8601 UTC timestamp (format YYYY-MM-DDThh:mm:ssZ) of the event | string |
MERCHANT_ID | Contract ID identifying each unique merchant as provided by PPRO upon onboarding | string |
PAYMENT_METHOD | Name of the payment method (e.g. “SEPA Direct Debit”)[a-zA-Z0-9]{1,40} | string |
AMOUNT | The transaction amount | numeric |
CURRENCY | 3-digit ISO currency code describing the amount | string |
COUNTRY | 2-digit ISO country code describing the origin of the payment | string |
EVENT_TYPE Description
| EVENT_TYPE | Description |
|---|---|
SUCCEEDED | A transaction in a technical successful state |
READY* | When a payment method is configured to settle on funds receipt vs settle on SUCCEEDED, this EVENT_TYPE will show. Refer to PPRO’s contract if this is relevant. Only relevant for payment methods that do not have a payment guarantee. |
FUNDSRECEIVED | For payment methods without a payment guarantee, this status highlights when PPRO has secured funds for a payment. See the Terms Of Use in your contract for more information regarding payment guarantee for every payment method. |
FUNDSMISSING | For schemes without a payment guarantee, this status highlights when funds are not secured for a payment |
*Deprecated
Important
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.
Updated about 1 year ago