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_ |
double |
Torchance | |||
contact_ |
varchar2 |
Kontakt Nachname | |||
contact_ |
varchar2 |
Kontakt Nachname Präfix | |||
contact_ |
varchar2 |
Kontakt Vorname | |||
contact_ |
varchar2 |
Kontakt-ID | |||
contact_ |
varchar2 |
itgen_spe_contact_id_2 | |||
contact_ |
char |
itgen_spe_contact_is_active | |||
contact_ |
varchar2 |
Ansprechpartner-ID | |||
contact_ |
varchar2 |
Kontakt E-Mail-Adresse (geschäftlich) | |||
contact_ |
varchar2 |
Kontakt Funktion | |||
contact_ |
varchar2 |
Kontakt Arbeit Mobil | |||
contact_ |
varchar2 |
Kontakt, Diensttelefon | |||
created |
varchar2 |
Created | |||
created_ |
varchar2 |
Erstellt bei | |||
expected_ |
varchar2 |
Erwartetes Abschlussdatum | |||
expected_ |
double |
Erwarteter Erlös | |||
id |
varchar2 |
ID | |||
linked_ |
char |
itgen_spe_linked_project_has_register_mileage_enabled | |||
linked_ |
varchar2 |
Verknüpfte Projekt-ID | |||
linked_ |
varchar2 |
Name des verknüpften Projekts | |||
linked_ |
varchar2 |
ID der verknüpften Projektorganisation | |||
linked_ |
varchar2 |
Name der mit dem Projekt verknüpften Organisation | |||
linked_ |
varchar2 |
itgen_spe_linked_project_organization_relation_number | |||
linked_ |
varchar2 |
Zugeordnete Projektperson – Vollständiger Name | |||
linked_ |
varchar2 |
Verknüpfte Projekt-Personen-ID | |||
linked_ |
varchar2 |
itgen_spe_linked_project_person_relation_number | |||
linked_ |
double |
itgen_spe_linked_project_project_manager_amount | |||
linked_ |
varchar2 |
itgen_spe_linked_project_project_manager_declarable | |||
linked_ |
varchar2 |
itgen_spe_linked_project_project_manager_employee_id | |||
linked_ |
varchar2 |
itgen_spe_linked_project_project_manager_id | |||
linked_ |
varchar2 |
itgen_spe_linked_project_project_manager_name | |||
linked_ |
varchar2 |
itgen_spe_linked_project_project_manager_person_id | Hinzugefügt, um der ursprünglichen sales/sales responsible_employee-Antwort zu entsprechen | ||
linked_ |
double |
itgen_spe_linked_project_project_manager_tariff | |||
linked_ |
varchar2 |
Nummer des verknüpften Projekts | |||
lost_ |
varchar2 |
An Wettbewerber verloren (ID) | |||
lost_ |
varchar2 |
An [Name des Mitbewerbers] verloren | |||
modified |
varchar2 |
Modified | |||
my_ |
varchar2 |
ID meines Organisationsprofils | |||
note |
varchar2 |
Note | |||
organization_ |
varchar2 |
Organisations-ID | |||
organization_ |
varchar2 |
itgen_spe_organization_id_2 | |||
organization_ |
varchar2 |
Name der Organisation | |||
organization_ |
varchar2 |
itgen_spe_organization_relation_number | |||
person_ |
varchar2 |
Vollständiger Name der Person | |||
person_ |
varchar2 |
Personen ID | |||
person_ |
varchar2 |
itgen_spe_person_id_2 | |||
person_ |
varchar2 |
itgen_spe_person_relation_number | |||
progress_ |
double |
Fortschritt – Torchance | |||
progress_ |
varchar2 |
Fortschritt Farbe | |||
progress_ |
varchar2 |
Fortschritts-ID | |||
progress_ |
varchar2 |
Fortschrittsanzeige | |||
progress_ |
int64 |
Fortschrittsstand | |||
reason_ |
char |
itgen_spe_reason_blocked | |||
reason_ |
varchar2 |
Grund-ID | |||
reason_ |
varchar2 |
Grund Name | |||
responsible_ |
double |
itgen_spe_responsible_employee_amount | |||
responsible_ |
varchar2 |
itgen_spe_responsible_employee_declarable | |||
responsible_ |
varchar2 |
itgen_spe_responsible_employee_employee_id | |||
responsible_ |
varchar2 |
itgen_spe_responsible_employee_id | |||
responsible_ |
varchar2 |
itgen_spe_responsible_employee_name | |||
responsible_ |
varchar2 |
itgen_spe_responsible_employee_person_id | Hinzugefügt, um der ursprünglichen sales/sales responsible_employee-Antwort zu entsprechen | ||
responsible_ |
double |
itgen_spe_responsible_employee_tariff | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_contact_id | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_contact_organization_id | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_contact_organization_name | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_contact_organization_relation_number | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_contact_person_full_name | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_contact_person_id | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_contact_person_relation_number | |||
separate_ |
char |
itgen_spe_separate_invoice_recipient_is_separate_invoice_recipient | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_organization_id | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_organization_name | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_organization_relation_number | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_person_full_name | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_person_id | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_person_relation_number | |||
simplicate_ |
varchar2 |
Simplicate URL | |||
source_ |
varchar2 |
Quellen-Kennzahl | |||
source_ |
varchar2 |
Quellenname | |||
start_ |
varchar2 |
Anfangsdatum | |||
status_ |
varchar2 |
Status-ID | |||
status_ |
varchar2 |
Statusbezeichnung | |||
status_ |
varchar2 |
Status aktualisiert am | |||
subject |
varchar2 |
Subject | |||
timeline_ |
varchar2 |
Zeitleiste E-Mail-Adresse | |||
updated_ |
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: