---
title: "ProjectAssignments (Simplicate)"
description: "Project Assignments"
language: de
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/de/datamodels/simplicate/Simplicate.Projects.ProjectAssignments
original: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.Projects.ProjectAssignments
updated: 2026-11-18T23:54:05Z
license: https://documentation.invantive.eu/de/
---

# ProjectAssignments: Simplicate Projektzuordnungen

`insert` `update` `REST`

- Katalog: `Simplicate`
- Schema: `Projects`
- Primärschlüssel: `id`
- Bezeichnung: Projektzuordnungen

Ruft alle verfügbaren Zuordnungen für Projekte ab

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

## API-Quelle

- Endpunkt: `/projects/assignment`
- Operation: `get /projects/assignment`

## Tabellenspalten

Die Spalten der Tabelle `ProjectAssignments` 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 |
|---|---|---|:---:|---|---|
| `created_at` | `varchar2` | Erstellt bei | [ ] |  |  |
| `description` | `varchar2` | Description | [ ] |  |  |
| `end_date` | `varchar2` | Enddatum | [ ] |  |  |
| `hours` | `double` | Hours | [ ] |  |  |
| `hours_total` | `double` | Stunden insgesamt | [ ] |  |  |
| `hours_type` | `varchar2` | Öffnungszeiten – Art | [ ] |  |  |
| `id` | `varchar2` | ID | [ ] |  |  |
| `is_planned` | `char` | Ist geplant | [ ] |  |  |
| `name` | `varchar2` | Name | [ ] |  |  |
| `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 | [ ] |  |  |
| `projecthourstype_billable` | `char` | itgen_spe_projecthourstype_billable | [ ] |  |  |
| `projecthourstype_budgeted_amount` | `double` | itgen_spe_projecthourstype_budgeted_amount | [ ] |  |  |
| `projecthourstype_color` | `varchar2` | itgen_spe_projecthourstype_color | [ ] |  |  |
| `projecthourstype_hourstype_billable` | `double` | itgen_spe_projecthourstype_hourstype_billable | [ ] |  |  |
| `projecthourstype_hourstype_blocked` | `char` | itgen_spe_projecthourstype_hourstype_blocked | [ ] |  |  |
| `projecthourstype_hourstype_color` | `varchar2` | itgen_spe_projecthourstype_hourstype_color | [ ] |  |  |
| `projecthourstype_hourstype_id` | `varchar2` | itgen_spe_projecthourstype_hourstype_id | [ ] |  |  |
| `projecthourstype_hourstype_label` | `varchar2` | itgen_spe_projecthourstype_hourstype_label | [ ] |  |  |
| `projecthourstype_hourstype_tariff` | `double` | itgen_spe_projecthourstype_hourstype_tariff | [ ] |  |  |
| `projecthourstype_hourstype_type` | `varchar2` | itgen_spe_projecthourstype_hourstype_type | [ ] |  |  |
| `projecthourstype_hourstype_vatclass_code` | `varchar2` | itgen_spe_projecthourstype_hourstype_vatclass_code | [ ] |  |  |
| `projecthourstype_hourstype_vatclass_id` | `varchar2` | itgen_spe_projecthourstype_hourstype_vatclass_id | [ ] |  |  |
| `projecthourstype_hourstype_vatclass_label` | `varchar2` | itgen_spe_projecthourstype_hourstype_vatclass_label | [ ] |  |  |
| `projecthourstype_hourstype_vatclass_name` | `varchar2` | itgen_spe_projecthourstype_hourstype_vatclass_name | [ ] |  |  |
| `projecthourstype_hourstype_vatclass_percentage` | `double` | itgen_spe_projecthourstype_hourstype_vatclass_percentage | [ ] |  |  |
| `projecthourstype_id` | `varchar2` | itgen_spe_projecthourstype_id | [ ] |  |  |
| `projecthourstype_tariff` | `double` | itgen_spe_projecthourstype_tariff | [ ] |  |  |
| `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_use_in_resource_planner` | `char` | itgen_spe_projectservice_use_in_resource_planner | [ ] |  |  |
| `spent_amount` | `varchar2` | Ausgegebener Betrag | [ ] |  |  |
| `spread` | `varchar2` | itgen_spe_spread | [ ] |  |  |
| `start_date` | `varchar2` | Anfangsdatum | [ ] |  |  |
| `status_color` | `varchar2` | Statusfarbe | [ ] |  |  |
| `status_created_at` | `varchar2` | Status Erstellt am | [ ] |  |  |
| `status_id` | `varchar2` | Status-ID | [ ] |  |  |
| `status_is_blocked` | `char` | Status: Gesperrt | [ ] |  |  |
| `status_is_done` | `char` | Status: Erledigt | [ ] |  |  |
| `status_name` | `varchar2` | Statusname | [ ] |  |  |
| `status_order` | `int64` | Bestellstatus | [ ] |  |  |
| `status_updated_at` | `varchar2` | Status aktualisiert am | [ ] |  |  |
| `updated_at` | `varchar2` | Aktualisiert am | [ ] |  |  |
| `use_spread` | `char` | Spread verwenden | [ ] |  |  |


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