Skip to content
Reporting
/
Settlement files
/
/
Content
Last updated

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.

ColumnDescriptionPossible ValuesExample Values
SHOP_ID
bigint		Identifier of shop-99999999
PAYMENTDATE
date		Date when payment was received by Ratepay-FiBuYYYY-MM-DD
PAYMENTMONTH
char(10)		Month when payment was received by Ratepay-FiBuYYYY-MM2022-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 amount1 - 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
ORDERDATE
timestamp		Date when request was sent to Ratepay-gatewayYYYY-MM-DD
HH:MM:SS.FFFFFF		2022-01-01
12:32:53.123456
SENTDATE
date		Date when operation was sent to Ratepay-gatewayYYYY-MM-DD2022-01-05
TRANSACTION_ID
char(20)		Ratepay-Identifier of order-39-2013050217283
CUSTOMERGROUP
char(10)		Customer Group Identifier1 - B2B
2 - B2C		2
KNOWNCUSTOMER
char(1)		Customer sent as known regular customer by shop1 - Known customer
0 - Unknown customer		1
PRODUCT
char(1)		ID describing product1 - INVOICE
2 - INSTALLMENT
3 - DIRECT DEBIT
4 - PREPAYMENT
5 - 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
Previous page
Next page