# 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_ID`bigint | Identifier of shop | - | 99999999 |
| `PAYMENTDATE`date | Date when payment was received by Ratepay-FiBu | YYYY-MM-DD |  |
| `PAYMENTMONTH`char(10) | Month when payment was received by Ratepay-FiBu | YYYY-MM | 2022-01 |
| `SHOPNAME`char(50) | Name of shop | - | Testshop |
| `AMOUNT`decimal(14,2) | Amount of position | - | 111.99 |
| `DESCRIPTOR`char(20) | Ratepay-reference of order | - | DG1234567Z1 |
| `SHOPINVOICE_ID`char(50) | Identifier of shop-Invoice | - | abcde |
| `SHOPSORDER_ID`char(50) | Identifier of shop-order | - | 12344545abc |
| `INVOICENUMBER`char(50) | Identifier of Ratepay-Invoice | - | 99999999002 |
| `DESCRIPTION`char(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 |
| `FEETYPE`char(10) | ID of type of amount | 1 - Original amount, return, cancellation, credit memo, additional debit2 - Disagio3 - Transaction fee (occur at cancellation or delivery)4 - Fees for return, cancellation, credit memo, additional debit5 - Service charge6 - VAT7 - Interest cost (monthly fee or similar)8 - Retransfer / Chargeback/Reassignment |  |
| `ORDERDATE`timestamp | Date when request was sent to Ratepay-gateway | YYYY-MM-DDHH:MM:SS.FFFFFF | 2022-01-0112:32:53.123456 |
| `SENTDATE`date | Date when operation was sent to Ratepay-gateway | YYYY-MM-DD | 2022-01-05 |
| `TRANSACTION_ID`char(20) | Ratepay-Identifier of order | - | 39-2013050217283 |
| `CUSTOMERGROUP`char(10) | Customer Group Identifier | 1 - B2B2 - B2C | 2 |
| `KNOWNCUSTOMER`char(1) | Customer sent as known regular customer by shop | 1 - Known customer0 - Unknown customer | 1 |
| `PRODUCT`char(1) | ID describing product | 1 - INVOICE2 - INSTALLMENT3 - DIRECT DEBIT4 - PREPAYMENT5 - INSTALLMENT DIRECT DEBIT | 1 |
| `REFERENCE_ID_ACCOUNTING`char(255) | Shop internal accounting number (e. g. from ERP-system such as SAP), used to reference payment-changes | - | ABC-123-B |
| `CHARGEBACK_REASON`char(50) | Reason code for the chargeback at dispute process; provided only in case of fee type 8 | - INR- SUM- SNAD- DEFEND- FRAUD | INR |