# Content

div
div
⏱ 3 min
div
👤 Onboarding Developer Team
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_ID`bigint | Ratepay identifier of the shop | Ratepay | - | 99999999 |
| `PAYMENTDATE`date | Date when payout was initiated by Ratepay | Ratepay | YYYY-MM-DD |  |
| `PAYMENTMONTH`char(10) | Month when payout was initiated by Ratepay | Ratepay | YYYY-MM | 2022-01 |
| `SHOPNAME`char(50) | Name of the shop | Ratepay | - | Testshop |
| `AMOUNT`decimal(14,2) | Amount of position | Ratepay (based on captured amounts) | - | 111.99 |
| `DESCRIPTOR`char(20) | Ratepay reference of order | Ratepay | - | DG1234567Z1 |
| `SHOPINVOICE_ID`char(50) | Merchant identifier of shop invoice | Merchant (based on transmitted [<invoice-id>](https://docs.ratepay.com/docs/developer/api_integration/payment_1.8/payment_api_documentation/api_explorer/content/invoicing/invoice-id) on Payment API 1.8, or [partner_invoice_id](https://docs.ratepay.com/apis/payment/openapi/payment_api/capture/capturetransaction#capture/capturetransaction/t=request&path=partner_invoice_id) on Payment API 2.0) | - | abcde |
| `SHOPSORDER_ID`char(50) | Merchant identifier of shop order | Merchant (based on transmitted [<order-id>](https://docs.ratepay.com/docs/developer/api_integration/payment_1.8/payment_api_documentation/api_explorer/head/external/order-id) on Payment API 1.8, or [partner_transaction_id](https://docs.ratepay.com/apis/payment/openapi/payment_api/transaction-management/createtransaction#transaction-management/createtransaction/t=request&path=partner_transaction_id) on Payment API 2.0) | - | 12344545abc |
| `INVOICENUMBER`char(50) | Ratepay identifier of this invoice | Ratepay | - | 99999999002 |
| `DESCRIPTION`char(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 |
| `FEETYPE`char(10) | ID of type of amount | Ratepay | 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 transaction was initially sent to Ratepay | Ratepay | YYYY-MM-DDHH:MM:SS.FFFFFF | 2022-01-0112:32:53.123456 |
| `SENTDATE`date | Date when operation was sent to Ratepay, which initiated this consideration in settlement files | Ratepay | YYYY-MM-DD | 2022-01-05 |
| `TRANSACTION_ID`char(20) | Ratepay identifier of transaction | Ratepay | - | 39-2013050217283 |
| `CUSTOMERGROUP`char(10) | Customer Group Identifier | Ratepay | 1 - B2B2 - B2C | 2 |
| `KNOWNCUSTOMER`char(1) | Customer sent as known regular customer by shop | Ratepay | 1 - Known customer0 - Unknown customer | 1 |
| `PRODUCT`char(1) | ID describing product | Ratepay | 1 - INVOICE2 - INSTALLMENT3 - DIRECT DEBIT4 - PREPAYMENT5 - INSTALLMENT DIRECT DEBIT | 1 |
| `REFERENCE_ID_ACCOUNTING`char(255) | Shop internal accounting number (e. g. from ERP systems), used to reference transaction changes | Merchant (based on transmitted [<reference-id>](https://docs.ratepay.com/docs/developer/api_integration/payment_1.8/payment_api_documentation/api_explorer/head/external/reference-id) on Payment API 1.8, or [partner_operation_id](https://docs.ratepay.com/apis/payment/openapi/payment_api/capture/capturetransaction#capture/capturetransaction/t=request&path=partner_operation_id) on Payment API 2.0) | - | ABC-123-B |
| `CHARGEBACK_REASON`char(50) | Reason code for the chargeback at dispute process; provided only in case of fee type 8 | Ratepay | - INR- SUM- SNAD- DEFEND- FRAUD | INR |