Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Simplicate API Data Model

Navigation: Schema: Hours > Tables

Hours: Simplicate Hours

 Contents Previous Home Next More

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

 

☐

 

approvalstatus_description

string

 

☐

 

approvalstatus_id

string

 

☐

 

approvalstatus_label

string

 

☐

 

assignment_id

string

 

☐

 

billable

boolean

 

☐

 

corrections_amount

float

 

☐

 

corrections_last_correction_date

string

 

☐

 

corrections_value

float

 

☐

 

created_at

string

Created at

☐

 

employee_amount

float

 

☐

 

employee_declarable

string

 

☐

 

employee_employee_id

string

 

☐

 

employee_id

string

Employee ID

☐

 

employee_name

string

 

☐

 

employee_person_id

string

 

☐

 

employee_tariff

float

 

☐

 

end_date

string

End Date

☐

 

hours

float

 

☐

 

id

string

ID

☐

 

invoice_id

string

 

☐

See /invoices/invoice

invoice_status

string

 

☐

 

invoiceline_id

string

 

☐

See /invoices/invoice

is_external

boolean

 

☐

 

is_recurring

boolean

 

☐

 

is_time_defined

boolean

 

☐

 

leave_id

string

 

☐

 

leave_status_id

string

 

☐

 

leave_status_label

string

 

☐

 

locked

boolean

 

☐

 

note

string

Note

☐

 

project_id

string

Project ID

☐

 

project_name

string

 

☐

 

project_organization_id

string

 

☐

 

project_organization_name

string

 

☐

 

project_person_full_name

string

 

☐

 

project_person_id

string

 

☐

 

project_project_manager_amount

float

 

☐

 

project_project_manager_declarable

string

 

☐

 

project_project_manager_employee_id

string

 

☐

 

project_project_manager_id

string

 

☐

 

project_project_manager_name

string

 

☐

 

project_project_manager_person_id

string

 

☐

 

project_project_manager_tariff

float

 

☐

 

project_project_number

string

 

☐

 

project_separate_invoice_recipient_contact_id

string

 

☐

See 'linked_persons_contact' in /crm/organization, or 'linked_as_contact_to_organization' in /crm/person, or /crm/contactperson

project_separate_invoice_recipient_is_separate_invoice_recipient

boolean

 

☐

 

project_separate_invoice_recipient_organization_id

string

 

☐

See /crm/organization

project_separate_invoice_recipient_person_id

string

 

☐

See /crm/person

projectservice_default_service_id

string

 

☐

 

projectservice_id

string

 

☐

 

projectservice_name

string

 

☐

 

projectservice_revenue_group_id

string

 

☐

 

source

string

 

☐

 

start_date

string

Start Date

☐

 

status

string

 

☐

 

tariff

float

 

☐

 

type_billable

float

 

☐

 

type_blocked

boolean

 

☐

 

type_color

string

 

☐

 

type_has_workflow

boolean

 

☐

 

type_id

string

 

☐

 

type_label

string

 

☐

 

type_tariff

float

 

☐

 

type_type

string

 

☐

 

type_vatclass_code

string

 

☐

 

type_vatclass_id

string

 

☐

 

type_vatclass_label

string

 

☐

 

type_vatclass_name

string

 

☐

 

type_vatclass_percentage

float

 

☐

 

updated_at

string

Updated at

☐

 

 

06-04-2021 14:59 Version 20.1.393-BETA+3152