# Declaratieregels: Easyflex Declaration Rules
- Catalog: `DataService`
- Schema: `BITool`
- Label: Declaration Rules
This is a read-only table function. The Easyflex API may not support changing the data or the Invantive UniversalSQL driver for Easyflex does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Easyflex API.
## Parameters of Table Function
The following parameters can be used to control the behaviour of the table function `Declaratieregels`. 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 |
|---|:---:|:---:|:---:|---|
| `allemedewerkers` | `` | ☐ | True | Whether to include all employees. When false, the setting of vastemedewerker is used. |
| `datumtijdgewijzigd` | `` | ☐ | | Select rows added and/or changed from specified date. |
| `fwmemonummer` | `` | ☐ | | Identification number (idnr) of the flex worker memo field. |
| `fwregistratienummer` | `` | ☐ | | Identification number (idnr) of the flex worker. |
| `jaar` | `` | ☑ | | Payroll year. |
| `loonslipnummer` | `` | ☐ | | Identification number (idnr) of payroll slip. |
| `maand` | `` | ☐ | | Payroll month |
| `plaatsingnummer` | `` | ☐ | | Identification number (idnr) of the placement. |
| `rlregistratienummer` | `` | ☐ | | Identification number (idnr) of the customer. |
| `statuswachten` | `` | ☐ | False | Whether to include with state 'Waiting'. Defaults to false. |
| `totenmet` | `` | ☐ | | End row of data to be selected (at most 5000). |
| `vanaf` | `` | ☐ | | Start row of data to be selected. |
| `vastemedewerkers` | `` | ☐ | False | Whether to include own employees. Defaults to false. |
| `week` | `` | ☐ | | Payroll week |
## Columns of Table Function
The columns of the table function `Declaratieregels` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `AANVRAAGNUMMER` | `number` | Request Number | | |
| `BTWCODE` | `number` | VAT Code | | |
| `BUSINESSUNIT` | `number` | Business Unit | | |
| `BUSINESSUNITNAAM` | `varchar2` | Business Unit Name | | |
| `DECLDATUM` | `date` | Declaration Date | | |
| `DECLEINDDATUM` | `date` | Declaration End Date | | |
| `DECLID` | `number` | Declaration ID | | |
| `DECLJAAR` | `number` | Declaration Year | | |
| `DECLNUMMER` | `number` | Declaration Number | | |
| `DECLPERIODENUMMER` | `number` | Declaration Period Number | | |
| `DECLSTARTDATUM` | `date` | Declaration Start Date | | |
| `EENHEID` | `number` | Unit | | |
| `FACTUREERDATUM` | `datetime` | Invoicing Date | | |
| `FACTUURDATUM` | `date` | Invoice Date | | |
| `FACTUURNUMMER` | `number` | Invoice Number | | |
| `FACTUURTEKST` | `varchar2` | Invoice Text | | |
| `FUNCTIE_DISCIPLINE` | `number` | Function Discipline | | |
| `FUNCTIE` | `varchar2` | Function | | |
| `FWAANTAL` | `number` | Count | | |
| `FWACHTERNAAM` | `varchar2` | Last Name | | |
| `FWBEH_PERC_OMZET_KOSTEN` | `number` | | | |
| `FWBEH_PERC_UREN` | `number` | | | |
| `FWGELDBELAST` | `number` | Amount Taxed | | |
| `FWGELDONBELAST` | `number` | Amount Non-taxed | | |
| `FWLOC_PERC_OMZET_KOSTEN` | `number` | | | |
| `FWLOC_PERC_UREN` | `number` | | | |
| `FWLOCATIE` | `number` | Locations | | |
| `FWMEDEWERKER` | `number` | Employee | | |
| `FWMEISJESACHTERNAAM` | `varchar2` | Maiden Name | | |
| `FWMEISJESVOORVOEGSELS` | `varchar2` | Maiden Prefixes | | |
| `FWMEMOWAARDE` | `varchar2` | Memo Value | | |
| `FWPERCENTAGE` | `number` | Percentage | | |
| `FWRAYONNUMMER` | `number` | Region Number | | |
| `FWREGISTRATIENUMMER` | `number` | Registration Number | | |
| `FWUREN` | `number` | Hours | | |
| `FWUURLOON` | `number` | Hourly Rate | | |
| `FWVOORLETTERS` | `varchar2` | Initials | | |
| `FWVOORNAAM` | `varchar2` | First Name | | |
| `FWVOORVOEGSELS` | `varchar2` | Prefixes | | |
| `GEWIJZIGD` | `datetime` | Changed | | |
| `HIST_FWMEDEWERKER` | `number` | | | |
| `HIST_RLMEDEWERKER` | `number` | | | |
| `INDIRECTE_KOSTEN` | `number` | Indirect Costs | | |
| `KOSTENPLAATS` | `number` | Cost Centre | | |
| `LCFACTUUR` | `varchar2` | Invoice | | |
| `LCLOONSLIP` | `varchar2` | Payroll Slip | | |
| `LCNAAM` | `varchar2` | Name | | |
| `LCTYPE` | `number` | Type | | |
| `LEVERINGSWIJZE` | `number` | Delivery Method | | |
| `LOONBELAST` | `number` | | | |
| `LOONBELASTBUITENSTAT` | `number` | | | |
| `LOONCOMPNUMMER` | `number` | | | |
| `LOONDATUM` | `date` | | | |
| `LOONONBELAST` | `number` | | | |
| `LOONONBELASTBUITENSTAT` | `number` | | | |
| `LOONSLIPNUMMER` | `number` | | | |
| `LOONSLIPTEKST` | `varchar2` | | | |
| `OMZET` | `number` | Revenue | | |
| `OMZETBUITENSTAT` | `number` | Revenue Outside Statistics | | |
| `OMZETHANDMATIG` | `number` | Revenue Manual | | |
| `OMZETHANDMATIGBUITENSTAT` | `number` | Revenue Manual Outside Statistics | | |
| `PLAATSINGNUMMER` | `number` | | | |
| `RISICOGROEP` | `number` | Risk Group | | |
| `RISICOGROEPCODE` | `varchar2` | Risk Group Code | | |
| `RLAANTAL` | `number` | Count | | |
| `RLBEDRIJFSNAAM` | `varchar2` | Company Name | | |
| `RLBEH_PERC_OMZET_KOSTEN` | `number` | | | |
| `RLBEH_PERC_UREN` | `number` | | | |
| `RLLOC_PERC_OMZET_KOSTEN` | `number` | | | |
| `RLLOC_PERC_UREN` | `number` | | | |
| `RLLOCATIE` | `number` | Location | | |
| `RLMEDEWERKER` | `number` | Employee | | |
| `RLPERCENTAGE` | `number` | Percentage | | |
| `RLRAYONNUMMER` | `number` | Region Number | | |
| `RLREGISTRATIENUMMER` | `number` | Registration Number | | |
| `RLTARIEF` | `number` | Rate | | |
| `RLUREN` | `number` | Hours | | |
| `SECTOR` | `number` | Industry | | |
| `SECTORCODE` | `varchar2` | Industry Code | | |
| `SECTORNAAM` | `varchar2` | Industry Name | | |
| `STATUS` | `number` | Status | | |
| `TYPE` | `number` | Type | | |
| `TYPEID` | `varchar2` | Type ID | | |
| `VERLOONDATUM` | `datetime` | | | |