ContractRates: Horeko Contract Rates
read only REST
- Catalog:
Horeko - Schema:
Contracts - Label: Contract Rates
Returns contracts Returns list of contracts. Available sort options: Id, StartDate, EndDate, ContractHours, WorkingDays. DaysOfWeek enum values: Sunday-0,Monday=1,Tuesday-2,Wednesday-3,Thursday-4,Friday-5,Saturday-6
Can only retrieve data.
API Source
- Endpoint:
/v4/contracts - Operation:
get /v4/contracts
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
active |
`` | get only contracts that are active for this specific date (format yyyy-mm-dd hh:mm:ss) | ||
sortBy |
`` | comma separated list of available options for sorting | ||
sort |
`` | true = descending | false = asceding. default is false |
Table Columns
The columns of the table ContractRates 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 |
|---|---|---|---|---|---|
Additional |
double |
Additional Cost Factor | |||
Contract |
double |
Contract Hours | |||
Contract |
int32 |
itgen_horeko_contracttype_id | |||
Contract |
varchar2 |
itgen_horeko_contracttype_name | |||
Create |
datetime |
Create Date | |||
Days |
varchar2 |
Days of Week | |||
Employee_ |
varchar2 |
itgen_horeko_employee_firstname | |||
Employee_ |
int32 |
Employee ID | |||
Employee_ |
varchar2 |
itgen_horeko_employee_lastname | |||
Employee_ |
varchar2 |
itgen_horeko_employee_middlename | |||
End |
datetime |
End Date | |||
End |
datetime |
itgen_horeko_enddate_2 | |||
Function |
varchar2 |
Function Description | |||
Hourly |
double |
Hourly Rate | |||
Id |
int32 |
ID | |||
Id_2 |
int32 |
itgen_horeko_id_2 | |||
Start |
datetime |
Start Date | |||
Start |
datetime |
itgen_horeko_startdate_2 | |||
Update |
datetime |
Update date | |||
Working |
int32 |
Working Days |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: