Liberis can share data about the history of deals for merchants that have used our platform for our BCA product.
This file is currently only available via SFTP. Your SFTP Credentials should be shared with you by Liberis when you are onboarded.
Filetypes currently available: CSV.
Filetypes available in the near future: Parquet. See: https://parquet.apache.org/docs/file-format/types/
Note: Data Type is only defined for Parquet exports. when sharing via CSV, the data type column can be used to infer what type you should store these as if you are ingesting the file into your own systems.
Note For outputs in CSV format, the ordering of columns within the file itself is not guaranteed to match the table below.
Fields - Partner Reporting V1.0 - Deal Performance
| Column name | Column | Data Type (Parquet) | Nullable | Example |
|---|---|---|---|---|
| application_id | The unique ID for the application that links to this contracted BCA. Format is Alphanumeric. | STRING | No | APP123 |
| contract_id | The unique ID for the contracted BCA that has been made. Format is Alphanumeric. | STRING | No | CONTRACT123 |
| country_code | The country code of the partner that this contract is linked to. ISO 3166-1 A-3 format. | STRING | No | GBR |
| currency_code | The currency code of the contract. ISO 4217 format. | STRING | No | GBP |
| contract_split | The amount of each payment that will be used to pay the remaining balance on the contract This will be a decimal between 0 and 1. For example, if a deal has a 21% split, the value of the contract_split column will be 0.21. | DECIMAL | Yes | 0.23 |
| contract_start_date | The start date of the contract. If null, the deal has not been funded yet. Datetime format: yyyy-MM-ddThh:mm:ss | DATETIME | Yes | 2024-01-05T00:00:00 |
| contract_purchase_amount_lcy | The total amount the customer is contracted to repay. | DECIMAL | Yes | 25000.00 |
| contract_purchase_price_lcy | The amount of money advanced according the contract. | DECIMAL | Yes | 20000.00 |
| disbursed_purchase_amount_lcy | The net cash disbursed to the merchant, exclusive of fees, in the currency of the contract. | DECIMAL | Yes | 15000.00 |
| disbursed_purchase_price_lcy | The net cash disbursed to the merchant, inclusive of fees, in the currency of the contract. | DECIMAL | Yes | 10000.00 |
| factor_rate | The ratio of the purchased price divided by the purchased amount. | DECIMAL | Yes | 1.21 |
| is_on_liberis_balance_sheet | Determines if the contract has been calculated as "On balance sheet" for Liberis. true means that liberis has funded the contract_amount_lcy. | BOOLEAN | No | true |
| merchant_reference_id | A reference ID or string provided to liberis during an application, usually as part of the partner flow. This is usually unique to the merchant but not unique across applications. This can be an ID such as the anonymised Merchant_ID, or another reference ID generated by our partners and provided in journey. | STRING | Yes | MERCHANTREF123 |
| outstanding_balance | The outstanding amount due still remaining on the contract. | DECIMAL | No | 123.45 |
| payoff_amount_due_to_liberis | The amount due back to liberis. | DECIMAL | No | 123.45 |
| partner_name | The name of the partner | STRING | No | LIBERIS |