Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Simplicate API Data Model

Navigation: Schema: Projects > Tables

ProjectHourTypeServices

Contents Previous Home Next More

Fetches all services

Catalog: Simplicate

Schema: Projects

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: /projects/service

Insert Simplicate API URL: /projects/service

Update Simplicate API URL: /projects/service

Delete Simplicate API URL: /projects/service

Field Selection Method: NotRequired

Base Path: data[*].hour_types[*]

Select Simplicate API Operation: get /projects/service

Table Function Columns

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

Name

Data Type

Label

Required

Documentation

amount

float

 

 

billable

boolean

 

 

budget_financial_hours

string

 

 

budget

float

 

 

budgeted_amount

float

 

 

created_at

string

Created at

 

default_service_id

string

 

 

end_date

string

End Date

 

expected_invoice_date

string

 

 

hourstype_billable

float

 

 

hourstype_blocked

boolean

 

 

hourstype_color

string

 

 

hourstype_has_workflow

boolean

 

 

hourstype_id

string

 

 

hourstype_label

string

 

 

hourstype_tariff

float

 

 

hourstype_type

string

 

 

hourstype_vatclass_code

string

 

 

hourstype_vatclass_id

string

 

 

hourstype_vatclass_label

string

 

 

hourstype_vatclass_name

string

 

 

hourstype_vatclass_percentage

float

 

 

id_1

string

 

 

id

string

ID

 

invoice_date

string

 

 

invoice_in_installments

boolean

 

 

invoice_method

string

 

 

name

string

Name

 

price

float

 

 

project_id

string

Project ID

 

related_service_id

string

 

 

revenue_group_id

string

 

 

revenue_group_label

string

 

 

start_date

string

Start Date

 

status

string

 

 

subscription_cycle

string

 

 

tariff

float

 

 

track_cost

boolean

 

 

track_hours

boolean

 

 

updated_at

string

Updated at

 

vat_class_code

string

 

 

vat_class_id

string

 

 

vat_class_label

string

 

 

vat_class_name

string

 

 

vat_class_percentage

float

 

 

write_hours_end_date

string

 

 

write_hours_start_date

string

 

 

 

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