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

# Projekte: Simplicate Projekte

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

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

Ruft alle Projekte ab

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

## API-Quelle

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

## Tabellenspalten

Die Spalten der Tabelle `Projects` 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 |
|---|---|---|:---:|---|---|
| `abnormal_address` | `char` | Ungültige Adresse | [ ] |  |  |
| `abnormal_contact_id` | `varchar2` | Fehlerhafte Kontakt-ID | [ ] |  |  |
| `abnormal_organization_id` | `varchar2` | Ungültige Organisations-ID | [ ] |  |  |
| `abnormal_person_id` | `varchar2` | ID einer Person mit Behinderung | [ ] |  |  |
| `billable` | `char` | Billable | [ ] |  |  |
| `budget_costs_value_budget` | `double` | itgen_spe_budget_costs_value_budget | [ ] |  |  |
| `budget_costs_value_spent` | `double` | itgen_spe_budget_costs_value_spent | [ ] |  |  |
| `budget_hours_amount_budget` | `double` | itgen_spe_budget_hours_amount_budget | [ ] |  |  |
| `budget_hours_amount_spent` | `double` | itgen_spe_budget_hours_amount_spent | [ ] |  |  |
| `budget_hours_value_budget` | `double` | itgen_spe_budget_hours_value_budget | [ ] |  |  |
| `budget_hours_value_spent` | `double` | itgen_spe_budget_hours_value_spent | [ ] |  |  |
| `budget_total_value_budget` | `double` | itgen_spe_budget_total_value_budget | [ ] |  |  |
| `budget_total_value_invoiced` | `double` | itgen_spe_budget_total_value_invoiced | [ ] |  |  |
| `budget_total_value_spent` | `double` | itgen_spe_budget_total_value_spent | [ ] |  |  |
| `can_register_mileage` | `char` | Kilometerstand kann erfasst werden | [ ] |  |  |
| `contact_id` | `varchar2` | Kontakt-ID | [ ] |  |  |
| `contact_id_2` | `varchar2` | itgen_spe_contact_id_2 | [ ] |  |  |
| `contact_organization_id` | `varchar2` | Kontakt-Organisations-ID | [ ] |  |  |
| `contact_organization_name` | `varchar2` | Kontakt – Name der Organisation | [ ] |  |  |
| `contact_organization_relation_number` | `varchar2` | itgen_spe_contact_organization_relation_number | [ ] |  |  |
| `contact_person_full_name` | `varchar2` | Vollständiger Name des Ansprechpartners | [ ] |  |  |
| `contact_person_id` | `varchar2` | Ansprechpartner-ID | [ ] |  |  |
| `contact_person_relation_number` | `varchar2` | itgen_spe_contact_person_relation_number | [ ] |  |  |
| `copied_from_project_has_register_mileage_enabled` | `char` | itgen_spe_copied_from_project_has_register_mileage_enabled | [ ] |  |  |
| `copied_from_project_id` | `varchar2` | itgen_spe_copied_from_project_id | [ ] |  |  |
| `copied_from_project_name` | `varchar2` | itgen_spe_copied_from_project_name | [ ] |  |  |
| `copied_from_project_organization_id` | `varchar2` | itgen_spe_copied_from_project_organization_id | [ ] |  |  |
| `copied_from_project_organization_name` | `varchar2` | itgen_spe_copied_from_project_organization_name | [ ] |  |  |
| `copied_from_project_organization_relation_number` | `varchar2` | itgen_spe_copied_from_project_organization_relation_number | [ ] |  |  |
| `copied_from_project_person_full_name` | `varchar2` | itgen_spe_copied_from_project_person_full_name | [ ] |  |  |
| `copied_from_project_person_id` | `varchar2` | itgen_spe_copied_from_project_person_id | [ ] |  |  |
| `copied_from_project_person_relation_number` | `varchar2` | itgen_spe_copied_from_project_person_relation_number | [ ] |  |  |
| `copied_from_project_project_manager_amount` | `double` | itgen_spe_copied_from_project_project_manager_amount | [ ] |  |  |
| `copied_from_project_project_manager_declarable` | `varchar2` | itgen_spe_copied_from_project_project_manager_declarable | [ ] |  |  |
| `copied_from_project_project_manager_employee_id` | `varchar2` | itgen_spe_copied_from_project_project_manager_employee_id | [ ] |  |  |
| `copied_from_project_project_manager_id` | `varchar2` | itgen_spe_copied_from_project_project_manager_id | [ ] |  |  |
| `copied_from_project_project_manager_name` | `varchar2` | itgen_spe_copied_from_project_project_manager_name | [ ] |  |  |
| `copied_from_project_project_manager_person_id` | `varchar2` | itgen_spe_copied_from_project_project_manager_person_id | [ ] |  | Hinzugefügt, um der ursprünglichen sales/sales responsible_employee-Antwort zu entsprechen |
| `copied_from_project_project_manager_tariff` | `double` | itgen_spe_copied_from_project_project_manager_tariff | [ ] |  |  |
| `copied_from_project_project_number` | `varchar2` | itgen_spe_copied_from_project_project_number | [ ] |  |  |
| `created` | `varchar2` | Created | [ ] |  |  |
| `created_at` | `varchar2` | Erstellt bei | [ ] |  |  |
| `divergent_payment_term_days` | `int64` | Abweichende Zahlungsfrist (Tage) | [ ] |  |  |
| `divergent_payment_term_id` | `varchar2` | ID der abweichenden Zahlungsbedingung | [ ] |  |  |
| `divergent_payment_term_method` | `varchar2` | Methode bei abweichenden Zahlungsbedingungen | [ ] |  |  |
| `divergent_payment_term_name` | `varchar2` | Bezeichnung der abweichenden Zahlungsbedingung | [ ] |  |  |
| `end_date` | `varchar2` | Enddatum | [ ] |  |  |
| `hours_rate_type` | `varchar2` | Stunden, Tarif, Art | [ ] |  |  |
| `id` | `varchar2` | ID | [ ] |  |  |
| `invoice_reference` | `varchar2` | Geschäftszeichen / Bezug | [ ] |  |  |
| `is_invoice_approval` | `char` | Rechnungsfreigabe | [ ] |  |  |
| `is_reverse_billing` | `char` | Ist die umgekehrte Abrechnung | [ ] |  |  |
| `modified` | `varchar2` | Modified | [ ] |  |  |
| `my_organization_profile_id` | `varchar2` | ID meines Organisationsprofils | [ ] |  |  |
| `my_organization_profile_id_2` | `varchar2` | itgen_spe_my_organization_profile_id_2 | [ ] |  |  |
| `my_organization_profile_organization_id` | `varchar2` | itgen_spe_my_organization_profile_organization_id | [ ] |  |  |
| `my_organization_profile_organization_name` | `varchar2` | itgen_spe_my_organization_profile_organization_name | [ ] |  |  |
| `my_organization_profile_organization_relation_number` | `varchar2` | itgen_spe_my_organization_profile_organization_relation_number | [ ] |  |  |
| `name` | `varchar2` | Name | [ ] |  |  |
| `note` | `varchar2` | Note | [ ] |  |  |
| `organization_id` | `varchar2` | Organisations-ID | [ ] |  |  |
| `organization_id_2` | `varchar2` | itgen_spe_organization_id_2 | [ ] |  |  |
| `organization_name` | `varchar2` | Name der Organisation | [ ] |  |  |
| `organization_relation_number` | `varchar2` | itgen_spe_organization_relation_number | [ ] |  |  |
| `person_full_name` | `varchar2` | Vollständiger Name der Person | [ ] |  |  |
| `person_id` | `varchar2` | Personen ID | [ ] |  |  |
| `person_id_2` | `varchar2` | itgen_spe_person_id_2 | [ ] |  |  |
| `person_relation_number` | `varchar2` | itgen_spe_person_relation_number | [ ] |  |  |
| `project_manager_amount` | `double` | itgen_spe_project_manager_amount | [ ] |  |  |
| `project_manager_declarable` | `varchar2` | itgen_spe_project_manager_declarable | [ ] |  |  |
| `project_manager_employee_id` | `varchar2` | itgen_spe_project_manager_employee_id | [ ] |  |  |
| `project_manager_id` | `varchar2` | itgen_spe_project_manager_id | [ ] |  |  |
| `project_manager_name` | `varchar2` | itgen_spe_project_manager_name | [ ] |  |  |
| `project_manager_person_id` | `varchar2` | itgen_spe_project_manager_person_id | [ ] |  | Hinzugefügt, um der ursprünglichen sales/sales responsible_employee-Antwort zu entsprechen |
| `project_manager_tariff` | `double` | itgen_spe_project_manager_tariff | [ ] |  |  |
| `project_number` | `varchar2` | Projektnummer | [ ] |  |  |
| `project_status_color` | `varchar2` | Farbe des Projektstatus | [ ] |  |  |
| `project_status_id` | `varchar2` | Projektstatus-ID | [ ] |  |  |
| `project_status_label` | `varchar2` | Projektstatus-Bezeichnung | [ ] |  |  |
| `separate_invoice_recipient_contact_id` | `varchar2` | itgen_spe_separate_invoice_recipient_contact_id | [ ] |  |  |
| `separate_invoice_recipient_contact_organization_id` | `varchar2` | itgen_spe_separate_invoice_recipient_contact_organization_id | [ ] |  |  |
| `separate_invoice_recipient_contact_organization_name` | `varchar2` | itgen_spe_separate_invoice_recipient_contact_organization_name | [ ] |  |  |
| `separate_invoice_recipient_contact_organization_relation_number` | `varchar2` | itgen_spe_separate_invoice_recipient_contact_organization_relation_number | [ ] |  |  |
| `separate_invoice_recipient_contact_person_full_name` | `varchar2` | itgen_spe_separate_invoice_recipient_contact_person_full_name | [ ] |  |  |
| `separate_invoice_recipient_contact_person_id` | `varchar2` | itgen_spe_separate_invoice_recipient_contact_person_id | [ ] |  |  |
| `separate_invoice_recipient_contact_person_relation_number` | `varchar2` | itgen_spe_separate_invoice_recipient_contact_person_relation_number | [ ] |  |  |
| `separate_invoice_recipient_is_separate_invoice_recipient` | `char` | itgen_spe_separate_invoice_recipient_is_separate_invoice_recipient | [ ] |  |  |
| `separate_invoice_recipient_organization_id` | `varchar2` | itgen_spe_separate_invoice_recipient_organization_id | [ ] |  |  |
| `separate_invoice_recipient_organization_name` | `varchar2` | itgen_spe_separate_invoice_recipient_organization_name | [ ] |  |  |
| `separate_invoice_recipient_organization_relation_number` | `varchar2` | itgen_spe_separate_invoice_recipient_organization_relation_number | [ ] |  |  |
| `separate_invoice_recipient_person_full_name` | `varchar2` | itgen_spe_separate_invoice_recipient_person_full_name | [ ] |  |  |
| `separate_invoice_recipient_person_id` | `varchar2` | itgen_spe_separate_invoice_recipient_person_id | [ ] |  |  |
| `separate_invoice_recipient_person_relation_number` | `varchar2` | itgen_spe_separate_invoice_recipient_person_relation_number | [ ] |  |  |
| `simplicate_url` | `varchar2` | Simplicate URL | [ ] |  |  |
| `start_date` | `varchar2` | Anfangsdatum | [ ] |  |  |
| `timeline_email_address` | `varchar2` | Zeitleiste E-Mail-Adresse | [ ] |  |  |
| `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)
