HourById: Simplicate Hour by ID
read only REST
- Catalog:
Simplicate - Schema:
Hours - Label: Hour by ID
Fetches a single hours by hours id
Can only retrieve data.
API Source
- Endpoint:
/hours/hours/{id} - Operation:
get /hours/hours/{id}
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
id |
`` | The template's id |
Table Columns
The columns of the table HourById 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 | |||
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 | |||
hours |
double |
Hours | |||
id |
varchar2 |
ID | |||
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 | |||
leave_ |
varchar2 |
Leave ID | |||
leave_ |
varchar2 |
Leave status ID | |||
leave_ |
varchar2 |
Leave status Label | |||
locked |
char |
Locked | |||
mileage_ |
varchar2 |
Mileage ID | |||
mileage_ |
double |
Mileage | |||
note |
varchar2 |
Note | |||
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 | |||
should_ |
char |
Should Sync to Cronofy | |||
source |
varchar2 |
Source | |||
start_ |
varchar2 |
Start Date | |||
status |
varchar2 |
Status | |||
tariff |
double |
Tariff | |||
type_ |
double |
Type Billable | |||
type_ |
char |
Type Blocked | |||
type_ |
varchar2 |
Type Colour | |||
type_ |
varchar2 |
Type ID | |||
type_ |
varchar2 |
Type Label | |||
type_ |
double |
Type Tariff | |||
type_ |
varchar2 |
Type | |||
type_ |
varchar2 |
Type VAT Class Code | |||
type_ |
varchar2 |
Type VAT Class ID | |||
type_ |
varchar2 |
Type VAT Class Label | |||
type_ |
varchar2 |
Type VAT Class Name | |||
type_ |
double |
Type VAT Class Percentage | |||
updated_ |
varchar2 |
Updated at |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: