---
title: "ProjectHourTypeServices (Simplicate)"
description: "Project Hour Type Services"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.Projects.ProjectHourTypeServices
original: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.Projects.ProjectHourTypeServices
updated: 2024-10-18T06:48:11Z
license: https://documentation.invantive.eu/en/
---

# 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:

- [Simplicate](/en/release-notes/drivers?driver=simplicate)

