# HourTypes: Simplicate Hour Types
Fetches all hour types
- Catalog: `Simplicate`
- Schema: `Hours`
- Primary Keys: `id`
- Label: Hour Types
- Retrieve: true
- Insert: true
- Update: true
- Delete: false
## Table Columns
The columns of the table `HourTypes` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `blocked` | `boolean` | Blocked | ☐ | |
| `color` | `string` | Colour | ☐ | |
| `id` | `string` | ID | ☐ | |
| `label` | `string` | Label | ☐ | |
| `tariff` | `string` | Rate | ☐ | |
| `type` | `string` | Type | ☐ | |
| `vatclass_code` | `string` | VAT Class Code | ☐ | |
| `vatclass_id` | `string` | VAT Class ID | ☐ | |
| `vatclass_label` | `string` | VAT Class Label | ☐ | |
| `vatclass_name` | `string` | VAT Class Name | ☐ | |
| `vatclass_percentage` | `float` | VAT Class Percentage | ☐ | |