Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Simplicate API Data Model

Navigation: Schema: Hours > Tables

HourCustomFields

Contents Previous Home Next More

Fetches all hours

Catalog: Simplicate

Schema: Hours

This is a read-only table function. The Simplicate API may not support changing the data or the Invantive SQL driver for Simplicate does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Simplicate API.

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[*].custom_fields[*]

Select Simplicate API Operation: get /hours/hours

Table Function Columns

The columns of the table function HourCustomFields are shown below. Each column has an SQL data type.

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

 

custom_field_group_id

string

 

 

custom_field_group_model_id

string

 

 

custom_field_group_model_label

string

 

 

custom_field_group_name

string

 

 

custom_field_group_position

string

 

 

custom_field_group_type

string

 

 

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

 

filterable

boolean

 

 

hours

float

 

 

id_1

string

 

 

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

 

 

label

string

Label

 

leave_id

string

 

 

leave_status_id

string

 

 

leave_status_label

string

 

 

locked

boolean

 

 

name

string

Name

 

note

string

Note

 

position

int64

 

 

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

 

 

render_type

string

 

 

searchable

boolean

Searchable

 

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

 

 

type

string

Type

 

updated_at

string

Updated at

 

value_type

string

Value Type

 

value

string

Value

 

 

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