Fee per refund file description
The -fee-per-refund.csv file includes a detail-level report of all fees incurred on refunds across all boarded merchants within a given settlement period. This will be delivered every day that settlement has been made along with the other 7 describing that settlement period.
The naming convention will be:
<merchant number>-<frequency>-<year>-<ongoing number>-<suffix>.csv
Example: 1-999-W-2016-07-fee-per-refund.csv
The file will contain the following data:
| Column | Description | Type |
|---|---|---|
MERCHANT_TX_ID | An optional merchant-provided identifier for refund[a-zA-Z0-9.,-_]{1,40} | string |
RF_ID | A PPRO-provided identifier for refund | numeric |
PAYMENT_REFERENCE | Public identifier of the refund | string |
EVENT_TYPE | Can be INITIALIZED or SUCCEEDED | 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 |
FEE_TYPE | See FEE_TYPEs below | string |
AMOUNT | Amount of the fee | numeric |
CURRENCY | 3-digit ISO currency code describing the amount | string |
COUNTRY | 2-digit ISO country code describing the origin of the payment | string |
REFERENCE_TX_ID | TX_ID of the original transaction of this refund | numeric |
EVENT_TYPE Description
| EVENT_TYPE | Description |
|---|---|
INITIALIZED | A transaction which was initialized and billed as such |
SUCCEEDED | A transaction in a technical successful state |
FEE_TYPE Description
| FEE_TYPE | Description |
|---|---|
ACQUIRING_FEE | Per-transaction (not a %) fee for refund processing |
PROCESSING_FEE | Additional per-transaction (not a %) fee |
SUCCEEDED_FEE | The fee charged when a transaction moves from any state to a SUCCEEDED state (not a % of transaction value) |
Note
See your PPRO contract for information about the applicability of each fee type. Reach out to your account manager for more details.
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 7 months ago