# Payables: Minox Payables Retrieve all the payables from an administration. Retrieve all the payables from an administration. ## Documentation Retrieve all the payables from an administration. - Catalog: `Minox` - Schema: `FinancialPayable` - Label: Payables The data in this table is partitioned per value of the `administration_code` column. This is a read-only table function. The Minox API may not support changing the data or the Invantive UniversalSQL driver for Minox does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Minox API. ## Parameters of Table Function The following parameters can be used to control the behaviour of the table function `Payables`. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values. Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three. Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third. | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `administration_code` | `` | ☐ | | Partition to retrieve data from. | | `date_from` | `` | ☐ | | An option to filter on invoices from the given date and onwards in a YYYY-MM-DD pattern | | `next` | `` | ☐ | | A single request returns a maximum of 20000 receivables. In case more receivables have been found, a token will be provided in the response body. The next page can be accessed by providing this token to the next request. An example: GET /payable?next=[token] where [token] is the provided token | | `status` | `` | ☐ | | An option to filter on invoices with a certain payment status. This option can be 'open' to show all receivables that still need to be paid, or 'paid' receivables only to show all receivables that have already been paid. (Values: open, paid) | ## Columns of Table Function The columns of the table function `Payables` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `account_description` | `varchar2` | Account Description | ☐ | | | `account_id_2` | `varchar2` | | ☐ | | | `account_id` | `int64` | Account ID | ☐ | The account identifier for a payable or receivable | | `account_scheme` | `varchar2` | Account Scheme | ☐ | | | `account_type` | `varchar2` | Account Type | ☐ | | | `age` | `int64` | Age | ☐ | The age of the post in days | | `balance` | `decimal` | Balance | ☐ | The amount that still has to be paid to or received from a post. In case this amount is negative, there is a possibility that this is a credit note | | `blocked_active` | `char` | Blocked Active | ☐ | Indicates if the post is blocked | | `blocked_reason` | `varchar2` | Blocked Reason | ☐ | The reason the post is blocked, with a corresponding code | | `collection_date` | `datetime` | Collection Date | ☐ | The date at which a debt collection (Dutch: 'incasso') was performed | | `credit_restriction` | `decimal` | Credit Restriction | ☐ | The credit restriction amount, calculated by the payment term, that has been added to the total amount | | `currency_description` | `varchar2` | Currency Description | ☐ | | | `currency_exchange_rate` | `decimal` | Currency Exchange Rate | ☐ | | | `currency_id` | `varchar2` | Currency ID | ☐ | | | `document_id` | `varchar2` | Document ID | ☐ | | | `due_date` | `datetime` | Due Date | ☐ | The due date of the invoice with a YYYY-MM-DD pattern | | `invoice_date` | `datetime` | Invoice Date | ☐ | The date of the invoice with a YYYY-MM-DD pattern | | `invoice_number` | `int64` | Invoice Number | ☐ | The identifying number for an invoice | | `memo` | `varchar2` | Memo | ☐ | The memo attached to the post | | `paid` | `decimal` | Paid | ☐ | The amount that has already been paid to or received from a post | | `payment_discount` | `decimal` | Payment Discount | ☐ | The payment discount amount, calculated by the payment term, that can be subtracted from the total amount | | `payment_id` | `varchar2` | Payment ID | ☐ | The identification of a payment that is associated with this post | | `payment_term_days` | `decimal` | Payment Term Days | ☐ | | | `payment_term_description` | `varchar2` | Payment Term Description | ☐ | | | `payment_term_id` | `int64` | Payment Term ID | ☐ | | | `payment_term_mandate` | `varchar2` | Payment Term Mandate | ☐ | | | `payment_term_start` | `varchar2` | Payment Term Start | ☐ | | | `reminder_last_sent` | `datetime` | Reminder Last Sent | ☐ | The last time a reminder has been sent to the corresponding account | | `reminder_number_sent` | `decimal` | Reminder Number Sent | ☐ | The number of times a reminder has been sent to the corresponding account | | `total` | `decimal` | Total | ☐ | The total amount that needs to be paid to or received from the post | | `type` | `varchar2` | Type | ☐ | An identifier for whether a post is a payable or a receivable |