ContractWeekDays: Horeko Contract Weekdays
read only REST
- Catalog:
Horeko - Schema:
Contracts - Label: Contract Weekdays
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 ContractWeekDays 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 | |||
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 | |||
Function |
varchar2 |
Function Description | |||
Id |
int32 |
ID | |||
Start |
datetime |
Start Date | |||
TEXT |
int32 |
Text | |||
Working |
int32 |
Working Days |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: