---
title: "Hours (Simplicate)"
description: "Hours"
language: de
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/de/datamodels/simplicate/Simplicate.Hours.Hours
original: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.Hours.Hours
updated: 2026-11-18T23:53:51Z
license: https://documentation.invantive.eu/de/
---

# Stunden: Simplicate Stunden

`insert` `update` `delete` `REST`

- Katalog: `Simplicate`
- Schema: `Hours`
- Primärschlüssel: `id`
- Label: Uren

Ruft alle Stunden ab

Mit `insert`, `update` und `delete` können Daten abgerufen und geändert werden.

## API-Quelle

- Endpunkt: `/hours/hours`
- Operation: `get /hours/hours`

## Tabellenspalten

Die Spalten der Tabelle `Hours` sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `absence_id` | `varchar2` | Absenz-ID | [ ] |  |  |
| `address_country_code` | `varchar2` | Adresslandcode | [ ] |  |  |
| `address_country_id` | `varchar2` | Adresse, Ländercode | [ ] |  |  |
| `address_line_1` | `varchar2` | Adresszeile 1 | [ ] |  |  |
| `address_line_2` | `varchar2` | Adresszeile 2 | [ ] |  |  |
| `address_locality` | `varchar2` | Adresse, Ort | [ ] |  |  |
| `address_postal_code` | `varchar2` | Adresse Postleitzahl | [ ] |  |  |
| `address_province` | `varchar2` | Adresse Bundesland | [ ] |  |  |
| `address_type` | `varchar2` | Adresstyp | [ ] |  |  |
| `approvalstatus_description` | `varchar2` | Genehmigungsstatus Beschreibung | [ ] |  |  |
| `approvalstatus_id` | `varchar2` | ID des Genehmigungsstatus | [ ] |  |  |
| `approvalstatus_label` | `varchar2` | Kennzeichnung des Genehmigungsstatus | [ ] |  |  |
| `assignment_id` | `varchar2` | Auftrags-ID | [ ] |  |  |
| `billable` | `char` | Billable | [ ] |  |  |
| `corrections_amount` | `double` | Betrag der Berichtigungen | [ ] |  |  |
| `corrections_last_correction_date` | `varchar2` | itgen_spe_corrections_last_correction_date | [ ] |  |  |
| `corrections_value` | `double` | Korrekturwert | [ ] |  |  |
| `created_at` | `varchar2` | Erstellt bei | [ ] |  |  |
| `duration_in_minutes` | `int64` | itgen_spe_duration_in_minutes | [ ] |  |  |
| `employee_amount` | `double` | Mitarbeiterbetrag | [ ] |  |  |
| `employee_declarable` | `varchar2` | Mitarbeiter deklarierbar | [ ] |  |  |
| `employee_employee_id` | `varchar2` | Mitarbeiter ID | [ ] |  |  |
| `employee_id` | `varchar2` | Mitarbeiter ID | [ ] |  |  |
| `employee_name` | `varchar2` | Mitarbeitername | [ ] |  |  |
| `employee_person_id` | `varchar2` | Mitarbeiter-Personen-ID | [ ] |  | Hinzugefügt, um der ursprünglichen sales/sales responsible_employee-Antwort zu entsprechen |
| `employee_tariff` | `double` | Mitarbeitertarif | [ ] |  |  |
| `end_date` | `varchar2` | Enddatum | [ ] |  |  |
| `hours` | `double` | Hours | [ ] |  |  |
| `id` | `varchar2` | ID | [ ] |  |  |
| `invoice_id` | `varchar2` | Rechnungs-ID | [ ] |  | Siehe /invoices/invoice |
| `invoice_status` | `varchar2` | Rechnungsstatus | [ ] |  |  |
| `invoiceline_id` | `varchar2` | Rechnungszeilen-ID | [ ] |  | Siehe /invoices/invoice |
| `is_deletable_reason_message` | `varchar2` | itgen_spe_is_deletable_reason_message | [ ] |  |  |
| `is_deletable_reason_translated_message` | `varchar2` | itgen_spe_is_deletable_reason_translated_message | [ ] |  |  |
| `is_deletable_value` | `char` | itgen_spe_is_deletable_value | [ ] |  |  |
| `is_editable_reason_message` | `varchar2` | itgen_spe_is_editable_reason_message | [ ] |  |  |
| `is_editable_reason_translated_message` | `varchar2` | itgen_spe_is_editable_reason_translated_message | [ ] |  |  |
| `is_editable_value` | `char` | itgen_spe_is_editable_value | [ ] |  |  |
| `is_external` | `char` | Ist extern | [ ] |  |  |
| `is_productive` | `char` | itgen_spe_is_productive | [ ] |  |  |
| `is_recurring` | `char` | Ist wiederkehrend | [ ] |  |  |
| `is_time_defined` | `char` | Ist Zeit definiert? | [ ] |  |  |
| `leave_id` | `varchar2` | Urlaubs-ID | [ ] |  |  |
| `leave_status_id` | `varchar2` | Urlaubsstatus-ID | [ ] |  |  |
| `leave_status_label` | `varchar2` | Status „Urlaub“ – Bezeichnung | [ ] |  |  |
| `locked` | `char` | Locked | [ ] |  |  |
| `mileage_id` | `varchar2` | Kilometerstand-ID | [ ] |  |  |
| `mileage_mileage` | `double` | Mileage | [ ] |  |  |
| `note` | `varchar2` | Note | [ ] |  |  |
| `project_has_register_mileage_enabled` | `char` | itgen_spe_project_has_register_mileage_enabled | [ ] |  |  |
| `project_id` | `varchar2` | Projekt ID | [ ] |  |  |
| `project_name` | `varchar2` | Projektname | [ ] |  |  |
| `project_organization_id` | `varchar2` | Projekt-Organisations-ID | [ ] |  |  |
| `project_organization_name` | `varchar2` | Name der Projektorganisation | [ ] |  |  |
| `project_organization_relation_number` | `varchar2` | itgen_spe_project_organization_relation_number | [ ] |  |  |
| `project_person_full_name` | `varchar2` | Vollständiger Name der Projektverantwortlichen | [ ] |  |  |
| `project_person_id` | `varchar2` | Projekt-Person-ID | [ ] |  |  |
| `project_person_relation_number` | `varchar2` | itgen_spe_project_person_relation_number | [ ] |  |  |
| `project_project_manager_amount` | `double` | Projektleiter Betrag | [ ] |  |  |
| `project_project_manager_declarable` | `varchar2` | Projektmanager (selbstständig) | [ ] |  |  |
| `project_project_manager_employee_id` | `varchar2` | Projektmanager-Mitarbeiter-ID | [ ] |  |  |
| `project_project_manager_id` | `varchar2` | Projektmanager-ID | [ ] |  |  |
| `project_project_manager_name` | `varchar2` | Name des Projektleiters | [ ] |  |  |
| `project_project_manager_person_id` | `varchar2` | Projektmanager-ID | [ ] |  | Hinzugefügt, um der ursprünglichen sales/sales responsible_employee-Antwort zu entsprechen |
| `project_project_manager_tariff` | `double` | Projektmanager Tarife | [ ] |  |  |
| `project_project_number` | `varchar2` | Projektnummer | [ ] |  |  |
| `projectservice_default_service_id` | `varchar2` | itgen_spe_projectservice_default_service_id | [ ] |  |  |
| `projectservice_id` | `varchar2` | Projekt-Service-ID | [ ] |  |  |
| `projectservice_name` | `varchar2` | Name des Projektdienstes | [ ] |  |  |
| `projectservice_revenue_group_id` | `varchar2` | itgen_spe_projectservice_revenue_group_id | [ ] |  |  |
| `projectservice_start_date` | `varchar2` | itgen_spe_projectservice_start_date | [ ] |  | Y-m-d, eg.2020-01-01 |
| `projectservice_until_date` | `varchar2` | itgen_spe_projectservice_until_date | [ ] |  | Y-m-d, eg.2020-01-01 |
| `recurrence_id` | `varchar2` | Wiederholungs-ID | [ ] |  |  |
| `recurrence_rrule_byday` | `varchar2` | itgen_spe_recurrence_rrule_byday | [ ] |  |  |
| `recurrence_rrule_bysetpos` | `varchar2` | itgen_spe_recurrence_rrule_bysetpos | [ ] |  |  |
| `recurrence_rrule_count` | `int64` | itgen_spe_recurrence_rrule_count | [ ] |  |  |
| `recurrence_rrule_dtstart` | `varchar2` | itgen_spe_recurrence_rrule_dtstart | [ ] |  |  |
| `recurrence_rrule_freq` | `int64` | itgen_spe_recurrence_rrule_freq | [ ] |  |  |
| `recurrence_rrule_interval` | `int64` | itgen_spe_recurrence_rrule_interval | [ ] |  |  |
| `recurrence_rrule_until` | `varchar2` | itgen_spe_recurrence_rrule_until | [ ] |  |  |
| `recurrence_rrule_wkst` | `varchar2` | itgen_spe_recurrence_rrule_wkst | [ ] |  |  |
| `recurrence_update` | `varchar2` | Aktuelles zum Rezidiv | [ ] |  |  |
| `should_sync_to_cronofy` | `char` | Sollte mit Cronofy synchronisiert werden | [ ] |  |  |
| `source` | `varchar2` | Source | [ ] |  |  |
| `start_date` | `varchar2` | Anfangsdatum | [ ] |  |  |
| `status` | `varchar2` | Status | [ ] |  |  |
| `tariff` | `double` | Tariff | [ ] |  |  |
| `type_billable` | `double` | Typ: Abrechnungsfähig | [ ] |  |  |
| `type_blocked` | `char` | Typ: Gesperrt | [ ] |  |  |
| `type_color` | `varchar2` | Typ Farbe | [ ] |  |  |
| `type_id` | `varchar2` | Typ-ID | [ ] |  |  |
| `type_label` | `varchar2` | Typenbezeichnung | [ ] |  |  |
| `type_tariff` | `double` | Tarifart | [ ] |  |  |
| `type_type` | `varchar2` | Type | [ ] |  |  |
| `type_vatclass_code` | `varchar2` | Typ, Umsatzsteuerklasse, Code | [ ] |  |  |
| `type_vatclass_id` | `varchar2` | Typ, Umsatzsteuerklasse, ID | [ ] |  |  |
| `type_vatclass_label` | `varchar2` | Typ, Umsatzsteuerklasse, Bezeichnung | [ ] |  |  |
| `type_vatclass_name` | `varchar2` | Typ Umsatzsteuerklasse Name | [ ] |  |  |
| `type_vatclass_percentage` | `double` | Art Umsatzsteuerklasse Prozentsatz | [ ] |  |  |
| `updated_at` | `varchar2` | Aktualisiert am | [ ] |  |  |


## Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert:

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