ProjectTeamProjects: Simplicate Projektteam-Projekte
read only REST
- Katalog:
Simplicate - Schema:
Projects - Bezeichnung: Projektteam-Projekte
Ruft alle Projekte ab
Es können nur Daten abgerufen werden.
API-Quelle
- Endpunkt:
/projects/project - Operation:
get /projects/project
Tabellenspalten
Die Spalten der Tabelle ProjectTeamProjects 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_ |
char |
Ungültige Adresse | |||
abnormal_ |
varchar2 |
Fehlerhafte Kontakt-ID | |||
abnormal_ |
varchar2 |
Ungültige Organisations-ID | |||
abnormal_ |
varchar2 |
ID einer Person mit Behinderung | |||
billable |
char |
Billable | |||
budget_ |
double |
itgen_spe_budget_costs_value_budget | |||
budget_ |
double |
itgen_spe_budget_costs_value_spent | |||
budget_ |
double |
itgen_spe_budget_hours_amount_budget | |||
budget_ |
double |
itgen_spe_budget_hours_amount_spent | |||
budget_ |
double |
itgen_spe_budget_hours_value_budget | |||
budget_ |
double |
itgen_spe_budget_hours_value_spent | |||
budget_ |
double |
itgen_spe_budget_total_value_budget | |||
budget_ |
double |
itgen_spe_budget_total_value_invoiced | |||
budget_ |
double |
itgen_spe_budget_total_value_spent | |||
can_ |
char |
Kilometerstand kann erfasst werden | |||
contact_ |
varchar2 |
Kontakt-ID | |||
contact_ |
varchar2 |
itgen_spe_contact_id_2 | |||
contact_ |
varchar2 |
Kontakt-Organisations-ID | |||
contact_ |
varchar2 |
Kontakt – Name der Organisation | |||
contact_ |
varchar2 |
itgen_spe_contact_organization_relation_number | |||
contact_ |
varchar2 |
Vollständiger Name des Ansprechpartners | |||
contact_ |
varchar2 |
Ansprechpartner-ID | |||
contact_ |
varchar2 |
itgen_spe_contact_person_relation_number | |||
copied_ |
char |
itgen_spe_copied_from_project_has_register_mileage_enabled | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_id | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_name | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_organization_id | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_organization_name | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_organization_relation_number | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_person_full_name | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_person_id | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_person_relation_number | |||
copied_ |
double |
itgen_spe_copied_from_project_project_manager_amount | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_project_manager_declarable | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_project_manager_employee_id | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_project_manager_id | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_project_manager_name | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_project_manager_person_id | Hinzugefügt, um der ursprünglichen sales/sales responsible_employee-Antwort zu entsprechen | ||
copied_ |
double |
itgen_spe_copied_from_project_project_manager_tariff | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_project_number | |||
created |
varchar2 |
Created | |||
created_ |
varchar2 |
Erstellt bei | |||
divergent_ |
int64 |
Abweichende Zahlungsfrist (Tage) | |||
divergent_ |
varchar2 |
ID der abweichenden Zahlungsbedingung | |||
divergent_ |
varchar2 |
Methode bei abweichenden Zahlungsbedingungen | |||
divergent_ |
varchar2 |
Bezeichnung der abweichenden Zahlungsbedingung | |||
end_ |
varchar2 |
Enddatum | |||
hours_ |
varchar2 |
Stunden, Tarif, Art | |||
id |
varchar2 |
ID | |||
id_2 |
varchar2 |
itgen_spe_id_2 | |||
invoice_ |
varchar2 |
Geschäftszeichen / Bezug | |||
is_ |
char |
Rechnungsfreigabe | |||
is_ |
char |
Ist die umgekehrte Abrechnung | |||
modified |
varchar2 |
Modified | |||
my_ |
varchar2 |
ID meines Organisationsprofils | |||
my_ |
varchar2 |
itgen_spe_my_organization_profile_id_2 | |||
my_ |
varchar2 |
itgen_spe_my_organization_profile_organization_id | |||
my_ |
varchar2 |
itgen_spe_my_organization_profile_organization_name | |||
my_ |
varchar2 |
itgen_spe_my_organization_profile_organization_relation_number | |||
name |
varchar2 |
Name | |||
name_2 |
varchar2 |
itgen_spe_name_2 | |||
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 | |||
project_ |
double |
itgen_spe_project_manager_amount | |||
project_ |
varchar2 |
itgen_spe_project_manager_declarable | |||
project_ |
varchar2 |
itgen_spe_project_manager_employee_id | |||
project_ |
varchar2 |
itgen_spe_project_manager_id | |||
project_ |
varchar2 |
itgen_spe_project_manager_name | |||
project_ |
varchar2 |
itgen_spe_project_manager_person_id | Hinzugefügt, um der ursprünglichen sales/sales responsible_employee-Antwort zu entsprechen | ||
project_ |
double |
itgen_spe_project_manager_tariff | |||
project_ |
varchar2 |
Projektnummer | |||
project_ |
varchar2 |
Farbe des Projektstatus | |||
project_ |
varchar2 |
Projektstatus-ID | |||
project_ |
varchar2 |
Projektstatus-Bezeichnung | |||
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 | |||
start_ |
varchar2 |
Anfangsdatum | |||
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: