Liberis can share data about the history of advances for merchants that have used our platform.
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 The ordering of the fields below is presented in alphabetical order. For outputs in CSV format, the ordering within the file itself is not guaranteed to match this.
Fields - Partner Reporting V1.0 - Advance Performance
| Column name | Column Definition | Data Type (Parquet) | Nullable | Example |
|---|---|---|---|---|
| account_status | The status of the account at the time of processing. Note that this is eventually consistent with our API so if you require a more up to date status please use the account-status endpoint. Available values are: UNKNOWN_ACCOUNT_STATUS ACTIVE FROZEN PAID WRITTEN_OFF NEVER_UTILISED | STRING | No | FROZEN |
| advance_amount_lcy | The amount of funding that the advance has requested in the local currency (lcy) of the advance. | DECIMAL | No | 123.45 |
| advance_created_at_timestamp | The timestamp of when the advance was created. The format is: YYYY-MM-DD HH:MM:SS. No timezone is specified; assume that the timezone is GMT. | TIMESTAMP | No | 2024-01-05 00:00:00 |
| advance_factor_rate | The factor rate for the advance. | DECIMAL | No | 1.20 |
| advance_id | A unique identifier for the advance. This may come in the form of a guid human-readable ID or generic UID generated by Liberis systems. | STRING | No | FLEXIADV-00001 |
| advance_status | The status of the advance. Possible values are: UNKNOWN DECLINED CANCELLED PENDING_DECISION PENDING_DISBURSEMENT PENDING_FULFILMENT FUNDED FUNDINGCONFIRMED | STRING | No | FUNDED |
| advance_type | The advance type which corresponds to the product that orchestrated the advance. Possible values are: - BCA- FLEXI- PAYWITHLIBERIS | STRING | No | BCA |
| advance_total_lcy | The amount of funding that the advance has requested including liberis feed in the local currency (lcy) of the advance. | DECIMAL | No | 150.01 |
| country_code | ISO 3166-1 A-3 format country code of the partner. Note: country_code is based off the configured country for the partner linked to that account not the currency settlement of the account or advance. | STRING | No | GBR |
| currency_code | ISO 4217 format currency code of the advance. | STRING | No | GBP |
| is_on_liberis_balance_sheet | "Determines if the advance has been calculated as ""On balance sheet"" for Liberis. **true** means that liberis has funded the advance_amount_lcy." | BOOLEAN | No | true |
| outstanding_balance | The outstanding balance on the account. Note that this is eventually consistent with our API so if you require a more real-time balance please use the GetBalance endpoint | DECIMAL | No | 100.00 |
| partner_name | The name of the partner. | STRING | No | LIBERIS |