Declaraties: Easyflex Declarations
read only XML
- Catalog:
DataService - Schema:
Combinatie - Label: Declarations
Can only retrieve data.
API Source
- XML service:
dataservice/ - XML topic:
ds_rf_declaraties
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
rf_ |
`` | Select rows added and/or changed from specified date. | ||
rf_ |
`` | End date. | ||
rf_ |
`` | Identification number (idnr) of the flex worker. | ||
rf_ |
`` | Whether to include obsoleted rows. | ||
rf_ |
`` | Year to retrieve data from. | ||
rf_ |
`` | Filter on cost center, 0 = No cost center. | ||
rf_ |
`` | Period number. | ||
rf_ |
`` | Type of payroll period: 29770 = Week, 29771 = Four weeks, 29772 = Month. | ||
rf_ |
`` | Identification number (idnr) of the placement. | ||
rf_ |
`` | Identification number (idnr) of the customer. | ||
rf_ |
`` | Start date. | ||
rf_ |
`` | Status. | ||
rf_ |
`` | End row of data to be selected (at most 5000). | ||
rf_ |
`` | Start row of data to be selected. | ||
rf_ |
`` | Sorting order: oplopend = ascending, aflopend = descending. |
Table Columns
The columns of the table Declaraties 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 |
|---|---|---|---|---|---|
AANVRAAGNR |
number |
Request Number | |||
ACCOORD_ |
varchar2 |
Approved by | |||
ACCOORD_ |
datetime |
Approved at | |||
DATUMTIJDGEWIJZIGD |
datetime |
Last Changed | |||
DEFAULT_ |
number |
itgen_easyflex_rf_decl_default_lc_percfw | |||
DEFAULT_ |
number |
itgen_easyflex_rf_decl_default_lc_percrl | |||
DEFAULT_ |
number |
itgen_easyflex_rf_decl_default_lc_wijzig_fw | |||
DEFAULT_ |
number |
itgen_easyflex_rf_decl_default_lc_wijzig_rl | |||
DEFAULT_ |
number |
itgen_easyflex_rf_decl_default_lcnr | |||
EINDDATUM |
varchar2 |
End Date | |||
EINDEWERK_ |
number |
itgen_easyflex_rf_decl_eindewerk_fw | |||
EINDEWERK_ |
number |
itgen_easyflex_rf_decl_eindewerk_rl | |||
EXTRAFACTTEKST |
varchar2 |
Additional Invoice Text | |||
EXTRAFACTTEKST2 |
varchar2 |
Additional Invoice Text 2 | |||
FLEXWERKER |
varchar2 |
itgen_easyflex_rf_decl_flexwerker | |||
FLEXWERKER_ |
varchar2 |
Last Name | |||
FLEXWERKER_ |
number |
ID Number | |||
GEREED_ |
number |
itgen_easyflex_rf_decl_gereed_fw | |||
GEREED_ |
number |
itgen_easyflex_rf_decl_gereed_rl | |||
IDNR |
number |
ID Number | |||
JAAR |
number |
Year | |||
JOB_ |
varchar2 |
itgen_easyflex_rf_decl_job_einddatum | |||
JOB_ |
varchar2 |
itgen_easyflex_rf_decl_job_functie | |||
JOB_ |
number |
itgen_easyflex_rf_decl_job_kostenplaats_nr | |||
JOB_ |
varchar2 |
itgen_easyflex_rf_decl_job_premiegroep | |||
JOB_ |
varchar2 |
itgen_easyflex_rf_decl_job_speccode | |||
JOB_ |
varchar2 |
itgen_easyflex_rf_decl_job_startdatum | |||
JOBNR |
number |
Job Number | |||
MEDEDELINGLOONSPEC1 |
varchar2 |
itgen_easyflex_rf_decl_mededelingloonspec1 | |||
MEDEDELINGLOONSPEC2 |
varchar2 |
itgen_easyflex_rf_decl_mededelingloonspec2 | |||
MEDEDELINGLOONSPEC3 |
varchar2 |
itgen_easyflex_rf_decl_mededelingloonspec3 | |||
OPMERKING_ |
varchar2 |
itgen_easyflex_rf_decl_opmerking_fw | |||
OPMERKING_ |
varchar2 |
itgen_easyflex_rf_decl_opmerking_rl | |||
PERIODENR |
number |
Period Number | |||
PERIODESOORT |
varchar2 |
Period Type | |||
RELATIE |
varchar2 |
itgen_easyflex_rf_decl_relatie | |||
RELATIE_ |
number |
itgen_easyflex_rf_decl_relatie_idnr | |||
STARTDATUM |
varchar2 |
Start Date | |||
STATUS |
varchar2 |
itgen_easyflex_rf_decl_status | |||
STATUS_ |
varchar2 |
itgen_easyflex_rf_decl_status_fw | |||
STATUS_ |
varchar2 |
itgen_easyflex_rf_decl_status_rl | |||
TOELICHTING_ |
varchar2 |
itgen_easyflex_rf_decl_toelichting_fw | |||
TOELICHTING_ |
varchar2 |
itgen_easyflex_rf_decl_toelichting_rl | |||
TVT |
varchar2 |
itgen_easyflex_rf_decl_tvt | |||
TVT_ |
varchar2 |
itgen_easyflex_rf_decl_tvt_onr | |||
VD_ |
number |
itgen_easyflex_rf_decl_vd_verdeling |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: