DeclaratieRegels: Easyflex Declaration Lines
read only
- Catalog:
Easyflex - Schema:
Views - Label: Declaration Lines
Can only retrieve data.
Table Columns
The columns of the table DeclaratieRegels are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | 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 |
varchar2 |
Function | |||
FUNCTIE_ |
number |
Function Discipline | |||
FWAANTAL |
number |
Count | |||
FWACHTERNAAM |
varchar2 |
Last Name | |||
FWBEH_ |
number |
itgen_easyflex_bi_fwbeh_perc_omzet_kosten | |||
FWBEH_ |
number |
itgen_easyflex_bi_fwbeh_perc_uren | |||
FWGELDBELAST |
number |
Amount Taxed | |||
FWGELDONBELAST |
number |
Amount Non-taxed | |||
FWLOC_ |
number |
itgen_easyflex_bi_fwloc_perc_omzet_kosten | |||
FWLOC_ |
number |
itgen_easyflex_bi_fwloc_perc_uren | |||
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_ |
number |
itgen_easyflex_bi_hist_fwmedewerker | |||
HIST_ |
number |
itgen_easyflex_bi_hist_rlmedewerker | |||
INDIRECTE_ |
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 |
itgen_easyflex_bi_loonbelast | |||
LOONBELASTBUITENSTAT |
number |
itgen_easyflex_bi_loonbelastbuitenstat | |||
LOONCOMPNUMMER |
number |
itgen_easyflex_bi_looncompnummer | |||
LOONDATUM |
date |
itgen_easyflex_bi_loondatum | |||
LOONONBELAST |
number |
itgen_easyflex_bi_loononbelast | |||
LOONONBELASTBUITENSTAT |
number |
itgen_easyflex_bi_loononbelastbuitenstat | |||
LOONSLIPNUMMER |
number |
itgen_easyflex_bi_loonslipnummer | |||
LOONSLIPTEKST |
varchar2 |
itgen_easyflex_bi_loonsliptekst | |||
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 |
itgen_easyflex_bi_plaatsingnummer | |||
RISICOGROEP |
number |
Risk Group | |||
RISICOGROEPCODE |
varchar2 |
Risk Group Code | |||
RLAANTAL |
number |
Count | |||
RLBEDRIJFSNAAM |
varchar2 |
Company Name | |||
RLBEH_ |
number |
itgen_easyflex_bi_rlbeh_perc_omzet_kosten | |||
RLBEH_ |
number |
itgen_easyflex_bi_rlbeh_perc_uren | |||
RLLOC_ |
number |
itgen_easyflex_bi_rlloc_perc_omzet_kosten | |||
RLLOC_ |
number |
itgen_easyflex_bi_rlloc_perc_uren | |||
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 |
itgen_easyflex_bi_verloondatum |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: