# LoketNlLoonruns: Minox Loket.nl Payroll Runs Retrieves all the known loonruns for the loket.nl connection and their status in Minox - Catalog: `Minox` - Schema: `ThirdPartyLoketNl` - Label: Loket.nl Payroll Runs The data in this table is partitioned per value of the `administration_code` column. This is a read-only table. 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. ## Table Columns The columns of the table `LoketNlLoonruns` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `booked` | `char` | Booked | ☐ | | | `client_number` | `int64` | Client Number | ☐ | | | `created` | `datetime` | Created | ☐ | | | `done` | `char` | Done | ☐ | | | `externalAdministrationId` | `varchar2` | External Administration ID | ☐ | | | `finished` | `datetime` | Finished | ☐ | | | `id` | `varchar2` | ID | ☐ | | | `period_id` | `int64` | Period ID | ☐ | | | `serial_number_run` | `int64` | Serial Number Run | ☐ | | | `serial_number` | `int64` | Serial Number | ☐ | | | `year` | `int64` | Year | ☐ | |