# Content

## CSV Formatting

- All fields of the CSV are enclosed in double quotes `"`.
- Fields are separated by a semicolon `;`.
- Line breaks are Windows-style `CR/LF`.
- A line break is also included on the last line.


## Content

details
summary
Content template A - suited for platform partners
| Data Point | Description / Comment |
|  --- | --- |
| REPORT_DATErequired | Date of settlement report generation. |
| PAYMENT_DATErequired | Date of payout. |
| PAYMENT_MONTHrequired | Month of payout. |
| AMOUNTrequired | Amount of claim, deducted refund amount, applicable Ratepay fee or Ratepay chargeback. |
| CURRENCYrequired | Currency of the amount as per [ISO 4217](https://en.wikipedia.org/wiki/ISO_4217). |
| RATEPAY_PAYMENT_REFERENCErequired | Ratepay payment reference as shown in buyer communication and [returned with accepted authorization request](/apis/payment/openapi/payment_api/transaction-management/createtransaction#!c=201&path=payment_details/ratepay_payment_reference&t=response). |
| RATEPAY_PARTNER_INVOICE_ID | Identifier of the monthly invoice Ratepay provides to the partner. |
| RATEPAY_PAYOUT_IDrequired | Payment reference, as included in the bank transfer reference of the payout. |
| RECORD_DESCRIPTIONrequired | Description of the report entry. |
| RECORD_TYPErequired | Identifier of the report entry. |
| AUTHORIZATION_REQUEST_DATErequired | Date of the initial [authorization request](/apis/payment/openapi/payment_api/transaction-management/createtransaction). |
| OPERATION_DATErequired | Date of respective operation that lead to this report entry [Payment API](/apis/payment/openapi/payment_api/). |
| RATEPAY_TRANSACTION_IDrequired | Ratepay transaction identifier as per response to an [authorization request](/apis/payment/openapi/payment_api/transaction-management/createtransaction#!c=201&path=ratepay_transaction_id&t=response). |
| BUYER_TYPE | Buyer type identifier (B2B or B2C). |
| PAYMENT_METHODrequired | The respective Ratepay payment method used for the transaction. |
| PARTNER_TRANSACTION_IDrequired | Partner transaction identifier as per [authorization request](/apis/payment/openapi/payment_api/transaction-management/createtransaction#!path=partner_transaction_id&t=request). |
| PARTNER_SHOP_ID | The shop identifier submitted by the partner in the [authorization request](/apis/payment/openapi/payment_api/transaction-management/createtransaction#!path=shops/partner_shop_id&t=request). |
| RATEPAY_RESOURCE_TYPE | Describes the Ratepay API resource where additional information about the settlement entry can be requested using the RATEPAY_RESOURCE_ID. |
| RATEPAY_RESOURCE_ID | The key of the originating resource mentioned in RATEPAY_RESOURCE_TYPE. |
| PARTNER_OPERATION_ID | Identifier of the operation as transmitted by the partner in the request [Payment API](/apis/payment/openapi/payment_api/). Will be empty if not transmitted by the partner or if the operation was initiated by Ratepay (e.g. dispute process). |


## Enumerated values in the csv report

| Field | Allowed values |
|  --- | --- |
| RECORD_TYPE | ACCOUNTS_RECEIVABLEDISAGIOTRANSACTION_FEEMISCELLANEOUSCHARGEBACK |
| RECORD_DESCRIPTION | Factoring purchase priceReturn purchase priceCancellation purchase priceGoodwill buyer refundDisagioTransaction feeVAT 19% factoringChargeback |
| BUYER_TYPE | B2CB2B |
| PAYMENT_METHOD | Open Invoice Bank TransferOpen Invoice Direct DebitInstallment Bank TransferInstallment Direct DebitPrepayment |
| RATEPAY_RESOURCE_TYPE | ratepay_capture_idratepay_refund_idratepay_dispute_idratepay_cancellation_id |