# Hours: Simplicate Hours Fetches all hours Can retrieve and modify data using insert, update and delete. - Catalog: `Simplicate` - Schema: `Hours` - Primary Keys: `id` - Label: Hours ## Table Columns The columns of the table `Hours` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `absence_id` | `string` | Absence ID | ☐ | | | `address_country_code` | `string` | Address Country Code | ☐ | | | `address_country_id` | `string` | Address Country ID | ☐ | | | `address_line_1` | `string` | Address Line 1 | ☐ | | | `address_line_2` | `string` | Address Line 2 | ☐ | | | `address_locality` | `string` | Address City | ☐ | | | `address_postal_code` | `string` | Address Postal Code | ☐ | | | `address_province` | `string` | Address Province | ☐ | | | `address_type` | `string` | Address Type | ☐ | | | `approvalstatus_description` | `string` | Approval Status Description | ☐ | | | `approvalstatus_id` | `string` | Approval Status ID | ☐ | | | `approvalstatus_label` | `string` | Approval Status Label | ☐ | | | `assignment_id` | `string` | Assignment ID | ☐ | | | `billable` | `boolean` | Billable | ☐ | | | `corrections_amount` | `float` | Corrections Amount | ☐ | | | `corrections_last_correction_date` | `string` | | ☐ | | | `corrections_value` | `float` | Correction Value | ☐ | | | `created_at` | `string` | Created On | ☐ | | | `duration_in_minutes` | `int64` | | ☐ | | | `employee_amount` | `float` | Employee Amount | ☐ | | | `employee_declarable` | `string` | Billable Employee | ☐ | | | `employee_employee_id` | `string` | Employee ID | ☐ | | | `employee_id` | `string` | Employee ID | ☐ | | | `employee_name` | `string` | Employee Name | ☐ | | | `employee_person_id` | `string` | Employee Person ID | ☐ | Added in order to comply with the original sales/sales responsible_employee response | | `employee_tariff` | `float` | Employee Rate | ☐ | | | `end_date` | `string` | End Date | ☐ | | | `hours` | `float` | Hours | ☐ | | | `id` | `string` | ID | ☐ | | | `invoice_id` | `string` | Invoice ID | ☐ | See /invoices/invoice | | `invoice_status` | `string` | Invoice Status | ☐ | | | `invoiceline_id` | `string` | Invoice Line ID | ☐ | See /invoices/invoice | | `is_deletable_reason_message` | `string` | | ☐ | | | `is_deletable_reason_translated_message` | `string` | | ☐ | | | `is_deletable_value` | `boolean` | | ☐ | | | `is_editable_reason_message` | `string` | | ☐ | | | `is_editable_reason_translated_message` | `string` | | ☐ | | | `is_editable_value` | `boolean` | | ☐ | | | `is_external` | `boolean` | Is External | ☐ | | | `is_productive` | `boolean` | | ☐ | | | `is_recurring` | `boolean` | Is Recurring | ☐ | | | `is_time_defined` | `boolean` | Is Time Defined | ☐ | | | `leave_id` | `string` | Absence ID | ☐ | | | `leave_status_id` | `string` | Absence Status ID | ☐ | | | `leave_status_label` | `string` | Absence Status Label | ☐ | | | `locked` | `boolean` | Closed | ☐ | | | `mileage_id` | `string` | Mileage ID | ☐ | | | `mileage_mileage` | `float` | Mileage | ☐ | | | `note` | `string` | Note | ☐ | | | `project_has_register_mileage_enabled` | `boolean` | | ☐ | | | `project_id` | `string` | Project ID | ☐ | | | `project_name` | `string` | Project Name | ☐ | | | `project_organization_id` | `string` | Project Organisation ID | ☐ | | | `project_organization_name` | `string` | Project Organisation Name | ☐ | | | `project_organization_relation_number` | `string` | | ☐ | | | `project_person_full_name` | `string` | Project Person Full Name | ☐ | | | `project_person_id` | `string` | Project Person ID | ☐ | | | `project_person_relation_number` | `string` | | ☐ | | | `project_project_manager_amount` | `float` | Project Manager Amount | ☐ | | | `project_project_manager_declarable` | `string` | Project Manager Billable | ☐ | | | `project_project_manager_employee_id` | `string` | Project Manager Employee ID | ☐ | | | `project_project_manager_id` | `string` | Project Manager ID | ☐ | | | `project_project_manager_name` | `string` | Project Manager Name | ☐ | | | `project_project_manager_person_id` | `string` | Project Manager Person ID | ☐ | Added in order to comply with the original sales/sales responsible_employee response | | `project_project_manager_tariff` | `float` | Project Manager Rate | ☐ | | | `project_project_number` | `string` | Project Number | ☐ | | | `projectservice_default_service_id` | `string` | | ☐ | | | `projectservice_id` | `string` | Project Service ID | ☐ | | | `projectservice_name` | `string` | Project Service Name | ☐ | | | `projectservice_revenue_group_id` | `string` | | ☐ | | | `projectservice_start_date` | `string` | | ☐ | Y-m-d, e.g. 2020-01-01 | | `projectservice_until_date` | `string` | | ☐ | Y-m-d, e.g. 2020-01-01 | | `recurrence_id` | `string` | Recurrence ID | ☐ | | | `recurrence_rrule_byday` | `string` | | ☐ | | | `recurrence_rrule_bysetpos` | `string` | | ☐ | | | `recurrence_rrule_count` | `int64` | | ☐ | | | `recurrence_rrule_dtstart` | `string` | | ☐ | | | `recurrence_rrule_freq` | `int64` | | ☐ | | | `recurrence_rrule_interval` | `int64` | | ☐ | | | `recurrence_rrule_until` | `string` | | ☐ | | | `recurrence_rrule_wkst` | `string` | | ☐ | | | `recurrence_update` | `string` | Recurrence Update | ☐ | | | `should_sync_to_cronofy` | `boolean` | Must Sync with Cronofy | ☐ | | | `source` | `string` | Source | ☐ | | | `start_date` | `string` | Start Date | ☐ | | | `status` | `string` | Status | ☐ | | | `tariff` | `float` | Rate | ☐ | | | `type_billable` | `float` | Type Billable | ☐ | | | `type_blocked` | `boolean` | Type Blocked | ☐ | | | `type_color` | `string` | Type Colour | ☐ | | | `type_id` | `string` | Type ID | ☐ | | | `type_label` | `string` | Type Label | ☐ | | | `type_tariff` | `float` | Type Rate | ☐ | | | `type_type` | `string` | Type | ☐ | | | `type_vatclass_code` | `string` | Type VAT Class Code | ☐ | | | `type_vatclass_id` | `string` | Type VAT Class ID | ☐ | | | `type_vatclass_label` | `string` | Type VAT Class Label | ☐ | | | `type_vatclass_name` | `string` | Type VAT Class Name | ☐ | | | `type_vatclass_percentage` | `float` | Type VAT Class Percentage | ☐ | | | `updated_at` | `string` | Updated On | ☐ | |