invantive documentation
Invantive Support ForumsLog In / Sign Up

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_decl_datumtijdgewijzigd `` Select rows added and/or changed from specified date.
rf_decl_declnr `` Identification number (idnr) of the declaration.
rf_decl_einddatum `` End date.
rf_decl_fwregnr `` Identification number (idnr) of the flex worker.
rf_decl_inclusief_vervallen `` True Whether to include obsoleted rows.
rf_decl_jaar `` Year to retrieve data from.
rf_decl_periodenr `` Period number.
rf_decl_periodesoort `` Type of payroll period: 29770 = Week, 29771 = Four weeks, 29772 = Month.
rf_decl_plaatsingnummer `` Identification number (idnr) of the placement.
rf_decl_rlregnr `` Identification number (idnr) of the customer.
rf_decl_startdatum `` Start date.
rf_decl_totenmet `` End row of data to be selected (at most 5000).
rf_decl_vanaf `` 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_DOOR_IDNR number itgen_easyflex_rf_decl_accoord_door_idnr
ACCOORD_OP datetime Approved at
BOEKING number itgen_easyflex_rf_decl_boeking
DATUMTIJDGEWIJZIGD datetime Last Changed
EINDDATUM date End Date
EINDEWERK_FW number itgen_easyflex_rf_decl_eindewerk_fw
EINDEWERK_RL number itgen_easyflex_rf_decl_eindewerk_rl
FACT_KLAAR datetime itgen_easyflex_rf_decl_fact_klaar
FLEXWERKER_IDNR number ID Number
GEREED_FW datetime itgen_easyflex_rf_decl_gereed_fw
GEREED_RL datetime itgen_easyflex_rf_decl_gereed_rl
IDNR number ID Number
IDNR_BRON number itgen_easyflex_rf_decl_idnr_bron
JAAR number Year
JOB_ACCORDEREN number itgen_easyflex_rf_decl_job_accorderen
JOB_EINDDATUM date itgen_easyflex_rf_decl_job_einddatum
JOB_FUNCTIE varchar2 itgen_easyflex_rf_decl_job_functie
JOB_FUNCTIE_IDNR number itgen_easyflex_rf_decl_job_functie_idnr
JOB_KOSTENPLAATS_NR number itgen_easyflex_rf_decl_job_kostenplaats_nr
JOB_PREMIEGROEP varchar2 itgen_easyflex_rf_decl_job_premiegroep
JOB_SPECCODE varchar2 itgen_easyflex_rf_decl_job_speccode
JOB_STARTDATUM date itgen_easyflex_rf_decl_job_startdatum
JOBNR number Job Number
LOON_KLAAR datetime itgen_easyflex_rf_decl_loon_klaar
OPMERKING_FW varchar2 itgen_easyflex_rf_decl_opmerking_fw
OPMERKING_RL varchar2 itgen_easyflex_rf_decl_opmerking_rl
PERIODENR number Period Number
PERIODESOORT number Period Type
RELATIE_IDNR number itgen_easyflex_rf_decl_relatie_idnr
STARTDATUM date Start Date
STATUS number itgen_easyflex_rf_decl_status
STATUS_FW number itgen_easyflex_rf_decl_status_fw
STATUS_RL number itgen_easyflex_rf_decl_status_rl
TVT number itgen_easyflex_rf_decl_tvt
TVT_ONR number itgen_easyflex_rf_decl_tvt_onr
VD_VERDELING number itgen_easyflex_rf_decl_vd_verdeling

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: