invantive documentation
Invantive Support ForumsLog In / Sign Up

ProjectHourTypeServices: Simplicate Project Hour Type Services

read only REST

  • Catalog: Simplicate
  • Schema: Projects
  • Label: Project Hour Type Services

Fetches all services

Can only retrieve data.

API Source

  • Endpoint: /projects/service
  • Operation: get /projects/service

Table Columns

The columns of the table ProjectHourTypeServices 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 and update.

Name Data Type Label Required Marks Documentation
amount double Amount
billable char Billable
budget double Budget
budget_financial_hours varchar2 Budget Financial (hrs)
budgeted_amount double Budgeted Amount
color varchar2 Colour
created_at varchar2 Created at
default_service_id varchar2 Default Service ID
end_date varchar2 End Date
expected_invoice_date varchar2 Expected Invoice Date
explanation varchar2 Explanation
hourstype_billable double itgen_spe_hourstype_billable
hourstype_blocked char itgen_spe_hourstype_blocked
hourstype_color varchar2 itgen_spe_hourstype_color
hourstype_id varchar2 itgen_spe_hourstype_id
hourstype_label varchar2 itgen_spe_hourstype_label
hourstype_tariff double itgen_spe_hourstype_tariff
hourstype_type varchar2 itgen_spe_hourstype_type
hourstype_vatclass_code varchar2 itgen_spe_hourstype_vatclass_code
hourstype_vatclass_id varchar2 itgen_spe_hourstype_vatclass_id
hourstype_vatclass_label varchar2 itgen_spe_hourstype_vatclass_label
hourstype_vatclass_name varchar2 itgen_spe_hourstype_vatclass_name
hourstype_vatclass_percentage double itgen_spe_hourstype_vatclass_percentage
id varchar2 ID
id_2 varchar2 itgen_spe_id_2
invoice_date varchar2 Invoice Date
invoice_in_installments char Invoice in Installments
invoice_method varchar2 Invoice Method
name varchar2 Name
price double Price
project_id varchar2 Project ID
related_service_id varchar2 Related Service ID
revenue_group_id varchar2 Revenue Group ID
revenue_group_label varchar2 Revenue Group Label
service_number varchar2 Service Number
start_date varchar2 Start Date
status varchar2 Status
subscription_cycle varchar2 Subscription Cycle
tariff double Tariff
track_cost char Track Cost
track_hours char Track Hours
updated_at varchar2 Updated at
use_in_resource_planner char Use in Resource Planner
vat_class_code varchar2 VAT Class Code
vat_class_id varchar2 VAT Class ID
vat_class_label varchar2 VAT Class Label
vat_class_name varchar2 VAT Class Name
vat_class_percentage double VAT Class Percentage
write_hours_end_date varchar2 Write Hours End Date
write_hours_start_date varchar2 Write Hours Start Date

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: