# DeclaratieRegels: Easyflex Declaration Lines - Catalog: `Easyflex` - Schema: `Views` - Label: Declaration Lines This is a read-only view. 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. ## View Columns The columns of the view `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 | | | | `Jaar` | `int32` | Year Number | ☑ | The number of the year. | | `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` | | | | | `Maand` | `int32` | Month Number | ☑ | The number of the month. | | `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` | | | |