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

# Vertrieb: Simplicate Vertrieb

`insert` `update` `REST`

- Katalog: `Simplicate`
- Schema: `Sales`
- Primärschlüssel: `id`
- Bezeichnung: Verkauf

Ruft alle Verkäufe ab

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

## API-Quelle

- Endpunkt: `/sales/sales`
- Operation: `get /sales/sales`

## Tabellenspalten

Die Spalten der Tabelle `Sales` 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 |
|---|---|---|:---:|---|---|
| `chance_to_score` | `double` | Torchance | [ ] |  |  |
| `contact_family_name` | `varchar2` | Kontakt Nachname | [ ] |  |  |
| `contact_family_name_prefix` | `varchar2` | Kontakt Nachname Präfix | [ ] |  |  |
| `contact_first_name` | `varchar2` | Kontakt Vorname | [ ] |  |  |
| `contact_id` | `varchar2` | Kontakt-ID | [ ] |  |  |
| `contact_id_2` | `varchar2` | itgen_spe_contact_id_2 | [ ] |  |  |
| `contact_is_active` | `char` | itgen_spe_contact_is_active | [ ] |  |  |
| `contact_person_id` | `varchar2` | Ansprechpartner-ID | [ ] |  |  |
| `contact_work_email` | `varchar2` | Kontakt E-Mail-Adresse (geschäftlich) | [ ] |  |  |
| `contact_work_function` | `varchar2` | Kontakt Funktion | [ ] |  |  |
| `contact_work_mobile` | `varchar2` | Kontakt Arbeit Mobil | [ ] |  |  |
| `contact_work_phone` | `varchar2` | Kontakt, Diensttelefon | [ ] |  |  |
| `created` | `varchar2` | Created | [ ] |  |  |
| `created_at` | `varchar2` | Erstellt bei | [ ] |  |  |
| `expected_closing_date` | `varchar2` | Erwartetes Abschlussdatum | [ ] |  |  |
| `expected_revenue` | `double` | Erwarteter Erlös | [ ] |  |  |
| `id` | `varchar2` | ID | [ ] |  |  |
| `linked_project_has_register_mileage_enabled` | `char` | itgen_spe_linked_project_has_register_mileage_enabled | [ ] |  |  |
| `linked_project_id` | `varchar2` | Verknüpfte Projekt-ID | [ ] |  |  |
| `linked_project_name` | `varchar2` | Name des verknüpften Projekts | [ ] |  |  |
| `linked_project_organization_id` | `varchar2` | ID der verknüpften Projektorganisation | [ ] |  |  |
| `linked_project_organization_name` | `varchar2` | Name der mit dem Projekt verknüpften Organisation | [ ] |  |  |
| `linked_project_organization_relation_number` | `varchar2` | itgen_spe_linked_project_organization_relation_number | [ ] |  |  |
| `linked_project_person_full_name` | `varchar2` | Zugeordnete Projektperson – Vollständiger Name | [ ] |  |  |
| `linked_project_person_id` | `varchar2` | Verknüpfte Projekt-Personen-ID | [ ] |  |  |
| `linked_project_person_relation_number` | `varchar2` | itgen_spe_linked_project_person_relation_number | [ ] |  |  |
| `linked_project_project_manager_amount` | `double` | itgen_spe_linked_project_project_manager_amount | [ ] |  |  |
| `linked_project_project_manager_declarable` | `varchar2` | itgen_spe_linked_project_project_manager_declarable | [ ] |  |  |
| `linked_project_project_manager_employee_id` | `varchar2` | itgen_spe_linked_project_project_manager_employee_id | [ ] |  |  |
| `linked_project_project_manager_id` | `varchar2` | itgen_spe_linked_project_project_manager_id | [ ] |  |  |
| `linked_project_project_manager_name` | `varchar2` | itgen_spe_linked_project_project_manager_name | [ ] |  |  |
| `linked_project_project_manager_person_id` | `varchar2` | itgen_spe_linked_project_project_manager_person_id | [ ] |  | Hinzugefügt, um der ursprünglichen sales/sales responsible_employee-Antwort zu entsprechen |
| `linked_project_project_manager_tariff` | `double` | itgen_spe_linked_project_project_manager_tariff | [ ] |  |  |
| `linked_project_project_number` | `varchar2` | Nummer des verknüpften Projekts | [ ] |  |  |
| `lost_to_competitor_id` | `varchar2` | An Wettbewerber verloren (ID) | [ ] |  |  |
| `lost_to_competitor_name` | `varchar2` | An [Name des Mitbewerbers] verloren | [ ] |  |  |
| `modified` | `varchar2` | Modified | [ ] |  |  |
| `my_organization_profile_id` | `varchar2` | ID meines Organisationsprofils | [ ] |  |  |
| `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 | [ ] |  |  |
| `progress_chance_to_score` | `double` | Fortschritt – Torchance | [ ] |  |  |
| `progress_color` | `varchar2` | Fortschritt Farbe | [ ] |  |  |
| `progress_id` | `varchar2` | Fortschritts-ID | [ ] |  |  |
| `progress_label` | `varchar2` | Fortschrittsanzeige | [ ] |  |  |
| `progress_position` | `int64` | Fortschrittsstand | [ ] |  |  |
| `reason_blocked` | `char` | itgen_spe_reason_blocked | [ ] |  |  |
| `reason_id` | `varchar2` | Grund-ID | [ ] |  |  |
| `reason_name` | `varchar2` | Grund Name | [ ] |  |  |
| `responsible_employee_amount` | `double` | itgen_spe_responsible_employee_amount | [ ] |  |  |
| `responsible_employee_declarable` | `varchar2` | itgen_spe_responsible_employee_declarable | [ ] |  |  |
| `responsible_employee_employee_id` | `varchar2` | itgen_spe_responsible_employee_employee_id | [ ] |  |  |
| `responsible_employee_id` | `varchar2` | itgen_spe_responsible_employee_id | [ ] |  |  |
| `responsible_employee_name` | `varchar2` | itgen_spe_responsible_employee_name | [ ] |  |  |
| `responsible_employee_person_id` | `varchar2` | itgen_spe_responsible_employee_person_id | [ ] |  | Hinzugefügt, um der ursprünglichen sales/sales responsible_employee-Antwort zu entsprechen |
| `responsible_employee_tariff` | `double` | itgen_spe_responsible_employee_tariff | [ ] |  |  |
| `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 | [ ] |  |  |
| `source_id` | `varchar2` | Quellen-Kennzahl | [ ] |  |  |
| `source_name` | `varchar2` | Quellenname | [ ] |  |  |
| `start_date` | `varchar2` | Anfangsdatum | [ ] |  |  |
| `status_id` | `varchar2` | Status-ID | [ ] |  |  |
| `status_label` | `varchar2` | Statusbezeichnung | [ ] |  |  |
| `status_updated_at` | `varchar2` | Status aktualisiert am | [ ] |  |  |
| `subject` | `varchar2` | Subject | [ ] |  |  |
| `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)
