Daily payments report
The daily report is sent in CSV format to the email address specified in your agreement with Pike. If you wish to receive the reports in the XLSX or in a different way, for example, via SFTP, please contact your Pike manager.
How to use the report
The report sent by Pike contains a list of all successful operations for a day (24 hours). You need to check the operations on your side against those in the report.
In case of any discrepancy, contact your Pike manager. The timeframe for making corrections is specified in your agreement with Pike.
Report file name
<Project name>_YYYY-MM-DD_YYYY-MM-DD
Report fields
| Field name | Description | Field length | Example |
|---|---|---|---|
| ID | Pike payment identifier | 15-32 | pm_1313 |
| paymentSessionId | Payment session identifier | 0-100 | ps_3230 |
| Project name | The name of your project on Pike's side | 2-100 | acquiring_card |
| Type of payment | Payment type Possible options: Adjustment, Advice, Refund, Recurrent. More details | 10-16 | Advice |
| Amount | Total of the operation in rubles | 1-12 | 110 |
| Settlement | Total of the settlement Pike must transfer to you. The total of the settlement can be negative, for example for Refund or Chargeback | 1-12 | -2 |
| Fee | Pike's total fee (as per the agreement). Specified as a negative value. | 1-12 | -2 |
| Transaction Date and Time | Date and time of the transaction on Pike's side | 19 | 11.01.2020 00:00:08 |
| Card number | Masked number of the card/wallet number used to make the payment | 9-19 | 4...1878 |
| RRN | Retrieval Reference Number: the unique identifier of a transaction with Pike (optional field) | 12 | 12345678 |
| paymentSessionMerchantMetadata | Your additional data that you passed within the request for the operation | 6-20 | 1Di732vw57 |
Payment types (Type of payment)
Adjustment– partial cancellation of a transactionAdvice– successful transactionRefund– rollback of a successful transactionRecurrent– recurring payment (automatic payment or repeated payment)
How to receive large report files
If required, Pike can send report files with one of the methods below:
- A CSV or XLSX file split into parts in CSV or XLSX format.
- A single ZIP archive file (CSV or XLSX file archived).
- A ZIP archive file split into parts (CSV or XLSX file archived and then split into parts).
This can help to deal with the issues when your email server cannot process a single email file with a size larger than specified. To know more about this service, please contact your manager at Pike.
In some cases, Pike can split and/or archive reports based on their own business and/or operational needs.
A report file is split into parts by the number of transactions.