⏱ 3 min
Settlement files are generated with every payout and contains a breakdown of the payout, by stating the amounts and occured Ratepay fees for each transaction. These are provided as a csv file.
| Column | Description | Provided by... | Possible Values | Example Values |
|---|---|---|---|---|
SHOP_IDbigint | Ratepay identifier of the shop | Ratepay | - | 99999999 |
PAYMENTDATEdate | Date when payout was initiated by Ratepay | Ratepay | YYYY-MM-DD | |
PAYMENTMONTHchar(10) | Month when payout was initiated by Ratepay | Ratepay | YYYY-MM | 2022-01 |
SHOPNAMEchar(50) | Name of the shop | Ratepay | - | Testshop |
AMOUNTdecimal(14,2) | Amount of position | Ratepay (based on captured amounts) | - | 111.99 |
DESCRIPTORchar(20) | Ratepay reference of order | Ratepay | - | DG1234567Z1 |
SHOPINVOICE_IDchar(50) | Merchant identifier of shop invoice | Merchant (based on transmitted <invoice-id> on Payment API 1.8, or partner_invoice_id on Payment API 2.0) | - | abcde |
SHOPSORDER_IDchar(50) | Merchant identifier of shop order | Merchant (based on transmitted <order-id> on Payment API 1.8, or partner_transaction_id on Payment API 2.0) | - | 12344545abc |
INVOICENUMBERchar(50) | Ratepay identifier of this invoice | Ratepay | - | 99999999002 |
DESCRIPTIONchar(100) | Description of type of amount | Ratepay | - 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 | Ratepay | 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 transaction was initially sent to Ratepay | Ratepay | YYYY-MM-DD HH:MM:SS.FFFFFF | 2022-01-01 12:32:53.123456 |
SENTDATEdate | Date when operation was sent to Ratepay, which initiated this consideration in settlement files | Ratepay | YYYY-MM-DD | 2022-01-05 |
TRANSACTION_IDchar(20) | Ratepay identifier of transaction | Ratepay | - | 39-2013050217283 |
CUSTOMERGROUPchar(10) | Customer Group Identifier | Ratepay | 1 - B2B 2 - B2C | 2 |
KNOWNCUSTOMERchar(1) | Customer sent as known regular customer by shop | Ratepay | 1 - Known customer 0 - Unknown customer | 1 |
PRODUCTchar(1) | ID describing product | Ratepay | 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 systems), used to reference transaction changes | Merchant (based on transmitted <reference-id> on Payment API 1.8, or partner_operation_id on Payment API 2.0) | - | ABC-123-B |
CHARGEBACK_REASONchar(50) | Reason code for the chargeback at dispute process; provided only in case of fee type 8 | Ratepay | - INR - SUM - SNAD - DEFEND - FRAUD | INR |