Content
Settlement files are generated for each payment run and contain all transactions and fees for a transaction. They are provided in the formats CSV.
The settlement files can be retrieved through our ORCA interface or SFTP connection and are generated for each payment run.
| Column | Description | Possible Values | Example Values |
|---|---|---|---|
SHOP_IDbigint |
Identifier of shop | - | 99999999 |
PAYMENTDATEdate |
Date when payment was received by Ratepay-FiBu | YYYY-MM-DD | |
PAYMENTMONTHchar(10) |
Month when payment was received by Ratepay-FiBu | YYYY-MM | 2022-01 |
SHOPNAMEchar(50) |
Name of shop | - | Testshop |
AMOUNTdecimal(14,2) |
Amount of position | - | 111.99 |
DESCRIPTORchar(20) |
Ratepay-reference of order | - | DG1234567Z1 |
SHOPINVOICE_IDchar(50) |
Identifier of shop-Invoice | - | abcde |
SHOPSORDER_IDchar(50) |
Identifier of shop-order | - | 12344545abc |
INVOICENUMBERchar(50) |
Identifier of Ratepay-Invoice | - | 99999999002 |
DESCRIPTIONchar(100) |
Description of type of amount | - Factoring-Kaufpreis FmV - Ratepaydisagio - Transaktionsgebühr Käufer - Kulanz Käufer (Tr.) - Gutschriftgebühr - Stornogebühren - Retoure Fact.-Kaufpreis (FmV) - Retourengebühren - Nachbelastungsgebühr - Chargeback - Diverse |
Ratepaydisagio |
FEETYPEchar(10) |
ID of type of amount | 1 - Original amount, return, cancellation, credit memo, additional debit 2 - Disagio 3 - Transaction fee (occur at cancellation or delivery) 4 - Fees for return, cancellation, credit memo, additional debit 5 - Service charge 6 - VAT 7 - Interest cost (monthly fee or similar) 8 - Retransfer / Chargeback/Reassignment |
|
ORDERDATEtimestamp |
Date when request was sent to Ratepay-gateway | YYYY-MM-DD HH:MM:SS.FFFFFF |
2022-01-01 12:32:53.123456 |
SENTDATEdate |
Date when operation was sent to Ratepay-gateway | YYYY-MM-DD | 2022-01-05 |
TRANSACTION_IDchar(20) |
Ratepay-Identifier of order | - | 39-2013050217283 |
CUSTOMERGROUPchar(10) |
Customer Group Identifier | 1 - B2B 2 - B2C |
2 |
KNOWNCUSTOMERchar(1) |
Customer sent as known regular customer by shop | 1 - Known customer 0 - Unknown customer |
1 |
PRODUCTchar(1) |
ID describing product | 1 - INVOICE 2 - INSTALLMENT 3 - DIRECT DEBIT 4 - PREPAYMENT 5 - INSTALLMENT DIRECT DEBIT |
1 |
REFERENCE_ID_ACCOUNTINGchar(255) |
Shop internal accounting number (e. g. from ERP-system such as SAP), used to reference payment-changes | - | ABC-123-B |
CHARGEBACK_REASONchar(50) |
Reason code for the chargeback at dispute process; provided only in case of fee type 8 | - INR - SUM - SNAD - DEFEND - FRAUD |
INR |