Please enable JavaScript to view this site.

Navigation: Schema: Hours > Tables

Hours: Simplicate Hours

Fetches all hours

Catalog: Simplicate

Schema: Hours

Label: Hours

Can retrieve data and change data using insert, update and delete.

Select Simplicate API URL: /hours/hours

Insert Simplicate API URL: /hours/hours

Update Simplicate API URL: /hours/hours

Delete Simplicate API URL: /hours/hours

Field Selection Method: NotRequired

Base Path: data[*]

Select Simplicate API Operation: get /hours/hours

Insert Simplicate API Operation: post /hours/hours

Update Simplicate API Operation: put /hours/hours/{id}

Delete Simplicate API Operation: delete /hours/hours/{id}

Table Function Columns

The columns of the table function Hours 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 or update.

Name

Data Type

Label

Required

Documentation

absence_id

string

Absence ID

 

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

Corrections Value

 

created_at

string

Created at

 

employee_amount

float

Employee Amount

 

employee_declarable

string

Employee Declarable

 

employee_employee_id

string

Employee ID

 

employee_id

string

Employee ID

 

employee_name

string

Employee Name

 

employee_person_id

string

Employee Person ID

 

employee_tariff

float

Employee Tariff

 

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

Leave ID

 

leave_status_id

string

Leave status ID

 

leave_status_label

string

Leave status Label

 

locked

boolean

Locked

 

mileage_id

string

Mileage ID

 

mileage_mileage

float

Mileage

 

note

string

Note

 

project_id

string

Project ID

 

project_name

string

Project Name

 

project_organization_id

string

Project Organization ID

 

project_organization_name

string

Project Organization Name

 

project_person_full_name

string

Project Person Full Name

 

project_person_id

string

Project Person ID

 

project_project_manager_amount

float

Project Manager Amount

 

project_project_manager_declarable

string

Project Manager Declarable

 

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

 

project_project_manager_tariff

float

Project Manager Tariff

 

project_project_number

string

Project Number

 

project_separate_invoice_recipient_is_separate_invoice_recipient

boolean

Project Separate Invoice Recipient

 

projectservice_default_service_id

string

 

 

projectservice_id

string

Project Service ID

 

projectservice_name

string

Project Service Name

 

projectservice_revenue_group_id

string

 

 

projectservice_use_in_resource_planner

boolean

 

 

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

Should Sync to Cronofy

 

source

string

Source

 

start_date

string

Start Date

 

status

string

Status

 

tariff

float

Tariff

 

type_billable

float

Type Billable

 

type_blocked

boolean

Type Blocked

 

type_color

string

Type Color

 

type_id

string

Type ID

 

type_label

string

Type Label

 

type_tariff

float

Type Tariff

 

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 at

 

 

15-06-2022 20:27 Version 22.0.232-PROD+3445