The clearing files can be retrieved through a SFTP connection and are provided daily.
To set up the SFTP connection, please follow these steps: SFTP
The clearing files are stored on the SFTP server as a CSV file under the following path: /from_ratepay/clearing/
Each clearing file will be removed from this path after 30 days and copied to /archive/clearing/
Download: clearing_example.csv
| Column | Description | Possible Values | Example |
|---|---|---|---|
UIDbigint | Unique identifier | - | 123 |
ORDER_DATEtimestamp | Date when request was sent to Ratepay-gateway | YYYY-MM-DD HH:MM:SS | 2013-01-01 12:32:53 |
TRANSACTION_IDchar(20) | Ratepay-Identifier of order | - | 39-2013050217283 |
SHOPSORDER_ID | Shop-Identifier of order | - | 47110815 |
REFERENCEchar(20) | Ratepay-Identifier of record (unique identifier) | - | RP12313123XY |
ENTRY_TYPEchar(20) | Type of entry | 1 - PAYMENT_REQUEST 2 - PAYMENT_CONFIRM 3 - CONFIRMATION_DELIVER 4 - CANCELLATION 5 - RETURN 6 - CREDIT 7 - CHANGE-ORDER | PAYMENT_REQUEST |
EXPORT_DATEtimestamp | Date when entry was exported to Ratepay-FIBU. If EXPORT_DATE is empty then the entry is send only for informational purpose. | YYYY-MM-DD HH:MM:SS | 2013-01-05 12:32:53 |
AMOUNT_GROSSdecimal(14,2) | Gross amount of order / payment change | - | 111.99 |
DISAGIO_GROSSdecimal(14,2) | Gross amount of disagio | - | 11.99 |
TRANSACTIONFEE_GROSSdecimal(14,2) | Gross amount of transaction fee | - | 1.99 |
PAYMENTCHANGEFEE_GROSSdecimal(14,2) | Gross amount of payment change fee | - | 2.99 |
CURRENCYchar(3) | Currency of order | EUR | EUR |
CUSTOMERGROUPchar(10) | Customer Group Identifier | 1 - B2B 2 - B2C | 2 |
KNOWNCUSTOMERchar(1) | Customer sent as known regular customer by shop | 1 0 | 1 |
PRODUCTchar(1) | ID describing product | 1 - INVOICE 2 - INSTALLMENT 3 - DIRECT DEBIT 4 - PREPAYMENT 5 - INSTALLMENT DIRECT DEBIT | 1 |