DeclaratiesAll: Easyflex RF Expense Claims All
read only XML
- Catalog:
DataService - Schema:
Combinatie - Label: RF Expense Claims All
Can only retrieve data.
API Source
- XML service:
dataservice/ - XML topic:
ds_rf_declaraties_all
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
rf_ |
`` | Select rows added and/or changed from specified date. | ||
rf_ |
`` | Identification number (idnr) of the declaration. | ||
rf_ |
`` | End date. | ||
rf_ |
`` | Identification number (idnr) of the flex worker. | ||
rf_ |
`` | True | Whether to include obsoleted rows. | |
rf_ |
`` | Year to retrieve data from. | ||
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_ |
`` | End row of data to be selected (at most 5000). | ||
rf_ |
`` | Start row of data to be selected. |
Table Columns
The columns of the table DeclaratiesAll 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_ |
number |
itgen_easyflex_rf_decl_accoord_door_idnr | |||
ACCOORD_ |
datetime |
Approved at | |||
BOEKING |
number |
itgen_easyflex_rf_decl_boeking | |||
DATUMTIJDGEWIJZIGD |
datetime |
Last Changed | |||
EINDDATUM |
date |
End Date | |||
EINDEWERK_ |
number |
itgen_easyflex_rf_decl_eindewerk_fw | |||
EINDEWERK_ |
number |
itgen_easyflex_rf_decl_eindewerk_rl | |||
FACT_ |
datetime |
itgen_easyflex_rf_decl_fact_klaar | |||
FLEXWERKER_ |
number |
ID Number | |||
GEREED_ |
datetime |
itgen_easyflex_rf_decl_gereed_fw | |||
GEREED_ |
datetime |
itgen_easyflex_rf_decl_gereed_rl | |||
IDNR |
number |
ID Number | |||
IDNR_ |
number |
itgen_easyflex_rf_decl_idnr_bron | |||
JAAR |
number |
Year | |||
JOB_ |
number |
itgen_easyflex_rf_decl_job_accorderen | |||
JOB_ |
date |
itgen_easyflex_rf_decl_job_einddatum | |||
JOB_ |
varchar2 |
itgen_easyflex_rf_decl_job_functie | |||
JOB_ |
number |
itgen_easyflex_rf_decl_job_functie_idnr | |||
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_ |
date |
itgen_easyflex_rf_decl_job_startdatum | |||
JOBNR |
number |
Job Number | |||
LOON_ |
datetime |
itgen_easyflex_rf_decl_loon_klaar | |||
OPMERKING_ |
varchar2 |
itgen_easyflex_rf_decl_opmerking_fw | |||
OPMERKING_ |
varchar2 |
itgen_easyflex_rf_decl_opmerking_rl | |||
PERIODENR |
number |
Period Number | |||
PERIODESOORT |
number |
Period Type | |||
RELATIE_ |
number |
itgen_easyflex_rf_decl_relatie_idnr | |||
STARTDATUM |
date |
Start Date | |||
STATUS |
number |
itgen_easyflex_rf_decl_status | |||
STATUS_ |
number |
itgen_easyflex_rf_decl_status_fw | |||
STATUS_ |
number |
itgen_easyflex_rf_decl_status_rl | |||
TVT |
number |
itgen_easyflex_rf_decl_tvt | |||
TVT_ |
number |
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: