HourCustomFields: Simplicate Hour Custom Fields
read only REST
- Catalog:
Simplicate - Schema:
Hours - Label: Hour Custom Fields
Fetches all hours
Can only retrieve data.
API Source
- Endpoint:
/hours/hours - Operation:
get /hours/hours
Table Columns
The columns of the table HourCustomFields 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 |
|---|---|---|---|---|---|
absence_ |
varchar2 |
Absence ID | |||
address_ |
varchar2 |
Address Country Code | |||
address_ |
varchar2 |
Address Country ID | |||
address_ |
varchar2 |
Address Line 1 | |||
address_ |
varchar2 |
Address Line 2 | |||
address_ |
varchar2 |
Address Locality | |||
address_ |
varchar2 |
Address Postal Code | |||
address_ |
varchar2 |
Address Province | |||
address_ |
varchar2 |
Address Type | |||
approvalstatus_ |
varchar2 |
Approval Status Description | |||
approvalstatus_ |
varchar2 |
Approval Status ID | |||
approvalstatus_ |
varchar2 |
Approval Status Label | |||
assignment_ |
varchar2 |
Assignment ID | |||
billable |
char |
Billable | |||
corrections_ |
double |
Corrections Amount | |||
corrections_ |
varchar2 |
itgen_spe_corrections_last_correction_date | |||
corrections_ |
double |
Corrections Value | |||
created_ |
varchar2 |
Created at | |||
custom_ |
varchar2 |
Custom Field Group ID | |||
custom_ |
varchar2 |
Custom Field Group Model ID | |||
custom_ |
varchar2 |
Custom Field Group Model Label | |||
custom_ |
varchar2 |
Custom Field Group Name | |||
custom_ |
varchar2 |
Custom Field Group Position | |||
custom_ |
varchar2 |
Custom Field Group Type | |||
duration_ |
int64 |
itgen_spe_duration_in_minutes | |||
employee_ |
double |
Employee Amount | |||
employee_ |
varchar2 |
Employee Declarable | |||
employee_ |
varchar2 |
Employee ID | |||
employee_ |
varchar2 |
Employee ID | |||
employee_ |
varchar2 |
Employee Name | |||
employee_ |
varchar2 |
Employee Person ID | Added in order to comply with the original sales/sales responsible_employee response | ||
employee_ |
double |
Employee Tariff | |||
end_ |
varchar2 |
End Date | |||
filterable |
char |
Filterable | |||
hours |
double |
Hours | |||
id |
varchar2 |
ID | |||
id_2 |
varchar2 |
itgen_spe_id_2 | |||
invoice_ |
varchar2 |
Invoice ID | See /invoices/invoice | ||
invoice_ |
varchar2 |
Invoice Status | |||
invoiceline_ |
varchar2 |
Invoice Line ID | See /invoices/invoice | ||
is_ |
varchar2 |
itgen_spe_is_deletable_reason_message | |||
is_ |
varchar2 |
itgen_spe_is_deletable_reason_translated_message | |||
is_ |
char |
itgen_spe_is_deletable_value | |||
is_ |
varchar2 |
itgen_spe_is_editable_reason_message | |||
is_ |
varchar2 |
itgen_spe_is_editable_reason_translated_message | |||
is_ |
char |
itgen_spe_is_editable_value | |||
is_ |
char |
Is External | |||
is_ |
char |
itgen_spe_is_productive | |||
is_ |
char |
Is Recurring | |||
is_ |
char |
Is time Defined | |||
label |
varchar2 |
Label | |||
leave_ |
varchar2 |
Leave ID | |||
leave_ |
varchar2 |
Leave status ID | |||
leave_ |
varchar2 |
Leave status Label | |||
locked |
char |
Locked | |||
mandatory |
char |
itgen_spe_mandatory | |||
mileage_ |
varchar2 |
Mileage ID | |||
mileage_ |
double |
Mileage | |||
name |
varchar2 |
Name | |||
note |
varchar2 |
Note | |||
position |
int64 |
Position | |||
project_ |
char |
itgen_spe_project_has_register_mileage_enabled | |||
project_ |
varchar2 |
Project ID | |||
project_ |
varchar2 |
Project Name | |||
project_ |
varchar2 |
Project Organisation ID | |||
project_ |
varchar2 |
Project Organisation Name | |||
project_ |
varchar2 |
itgen_spe_project_organization_relation_number | |||
project_ |
varchar2 |
Project Person Full Name | |||
project_ |
varchar2 |
Project Person ID | |||
project_ |
varchar2 |
itgen_spe_project_person_relation_number | |||
project_ |
double |
Project Manager Amount | |||
project_ |
varchar2 |
Project Manager Declarable | |||
project_ |
varchar2 |
Project Manager Employee ID | |||
project_ |
varchar2 |
Project Manager ID | |||
project_ |
varchar2 |
Project Manager Name | |||
project_ |
varchar2 |
Project Manager Person ID | Added in order to comply with the original sales/sales responsible_employee response | ||
project_ |
double |
Project Manager Tariff | |||
project_ |
varchar2 |
Project Number | |||
projectservice_ |
varchar2 |
itgen_spe_projectservice_default_service_id | |||
projectservice_ |
varchar2 |
Project Service ID | |||
projectservice_ |
varchar2 |
Project Service Name | |||
projectservice_ |
varchar2 |
itgen_spe_projectservice_revenue_group_id | |||
projectservice_ |
varchar2 |
itgen_spe_projectservice_start_date | Y-m-d, eg. 2020-01-01 | ||
projectservice_ |
varchar2 |
itgen_spe_projectservice_until_date | Y-m-d, eg. 2020-01-01 | ||
recurrence_ |
varchar2 |
Recurrence ID | |||
recurrence_ |
varchar2 |
itgen_spe_recurrence_rrule_byday | |||
recurrence_ |
varchar2 |
itgen_spe_recurrence_rrule_bysetpos | |||
recurrence_ |
int64 |
itgen_spe_recurrence_rrule_count | |||
recurrence_ |
varchar2 |
itgen_spe_recurrence_rrule_dtstart | |||
recurrence_ |
int64 |
itgen_spe_recurrence_rrule_freq | |||
recurrence_ |
int64 |
itgen_spe_recurrence_rrule_interval | |||
recurrence_ |
varchar2 |
itgen_spe_recurrence_rrule_until | |||
recurrence_ |
varchar2 |
itgen_spe_recurrence_rrule_wkst | |||
recurrence_ |
varchar2 |
Recurrence Update | |||
render_ |
varchar2 |
Render Type | |||
searchable |
char |
Searchable | |||
should_ |
char |
Should Sync to Cronofy | |||
source |
varchar2 |
Source | |||
start_ |
varchar2 |
Start Date | |||
status |
varchar2 |
Status | |||
tariff |
double |
Tariff | |||
type |
varchar2 |
Type | |||
type_ |
double |
itgen_spe_type_2_billable | |||
type_ |
char |
itgen_spe_type_2_blocked | |||
type_ |
varchar2 |
itgen_spe_type_2_color | |||
type_ |
varchar2 |
itgen_spe_type_2_id | |||
type_ |
varchar2 |
itgen_spe_type_2_label | |||
type_ |
double |
itgen_spe_type_2_tariff | |||
type_ |
varchar2 |
itgen_spe_type_2_type | |||
type_ |
varchar2 |
itgen_spe_type_2_vatclass_code | |||
type_ |
varchar2 |
itgen_spe_type_2_vatclass_id | |||
type_ |
varchar2 |
itgen_spe_type_2_vatclass_label | |||
type_ |
varchar2 |
itgen_spe_type_2_vatclass_name | |||
type_ |
double |
itgen_spe_type_2_vatclass_percentage | |||
updated_ |
varchar2 |
Updated at | |||
value |
varchar2 |
Value | |||
value_ |
varchar2 |
Value Type |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: