Technical information

Last update: August 3, 2023

Payment report details

The first line of the file is always the same. It provides the name of each column, given that the file is opened with a spreadsheet. Column names can be in French or in English, the language is chosen during the file setting.

The other lines provide details on every transaction. Each line contains one single transaction. The "len" column indicates the maximum length of the field.

A line is divided in three parts:

• Details of purchase (always filled)
• Details of deposit (optional)
• Details of fundings (optional)

Operation of the payment report

Payments

3x 4x Oney

In case of a Oney 3x4x payment, every field is filled.

Paylater

In case of a Oney Paylater payment, only part 1 and part 3 will be filled.

Payments with an Oney Card

These records, where the value in first column is "CA", will have only the two first parts filled.

Funding with an Oney Card

These records will only have part 1 and part 3 filled.

Long-term funding

These records will have all three parts filled.

Commissions

When the subscribed product involves charging commissions, the commissions will be displayed in the payment report.

If you chose the credit transfer/direct debit mode, which means that Oney will allocate the total amount of purchases and will charge the commissions once a month, the debit ID will be displayed in the payment report.

If you chose the clearing mode, which means that Oney will allocate the total amount of purchases net of the commissions amount, the debit ID will not be displayed.

Cancellation of Oney 3x4x

A cancellation can be total or partial, and the information displayed will be different following one case or the other.

Partial cancellation

If the amount of the partial cancellation is lesser than the deferred outstanding amount, only parts 1 and 3 will be filled. In the column Payment_amount_2 the amount taken back to Oney will be displayed, and in column Commission_amount_2 the amount of refunded commissions. Note that the symbols will be reversed compared to a purchase (- symbol for Payment_amount_2 and + symbol for Commissoin_amount_2.)

If the amount of the partial cancellation is greater than the deferred outstanding amount, all three parts will be filled. In the column Payment_amount_2 the amount of the outstanding deferred (that is cancelled) will be displayed, and in the column Commission_amount_2 the amount of refunded commissions. The complement of the refund will be displayed in the column Payment_amount. Again, the symbols will be reversed compared to a purchase.

If the partial cancellation concerns a fully refunded purchase, only parts 1 and 2 will be filled in. We will find in the Payment_amount column the amount taken back to Oney and in the Commission_amount column the commissions reimbursed by Oney. Note that the signs are therefore reversed in relation to a purchase (sign – for Payment_amount and + for Commission_amount).

Total Cancellation

In the case of a total cancellation, the outstanding deferred amount (that is cancelled) will be displayed in the column Payment_amount_2 and the amount of refunded commissions will be in the column Commission_amount_2. The complement of the refund will be displayed in the column Payment_amount. Again, the symbols will be reversed compared to a purchase.

The commission on the deposit is never refunded, therefore the column Commission_amount is to remain void.

Note: when a cancellation occurs during the deferral period of the monthly payment, it will be processed once the debit has occurred. Therefore, there can be a 5-day delay before a cancellation is processed.

Cancellation of other products

Cancellation of other products will be treated the same as the original purchase, therefore the same columns will be filled.

Payment report file

M: Mandatory
O: Optional

General

Deposit

Funding