ProjectCustomFieldOptions: Simplicate itgen_spe_projectcustomfieldoptions_plural
read only REST
- Katalog:
Simplicate - Schema:
Projects - Bezeichnung: itgen_spe_projectcustomfieldoptions_plural
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 ProjectCustomFieldOptions 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 | |||
custom_ |
varchar2 |
ID der benutzerdefinierten Feldgruppe | |||
custom_ |
varchar2 |
ID des Modells für benutzerdefinierte Feldgruppen | |||
custom_ |
varchar2 |
Bezeichnung des Modells für benutzerdefinierte Feldgruppen | |||
custom_ |
varchar2 |
Name der benutzerdefinierten Feldgruppe | |||
custom_ |
varchar2 |
Position der benutzerdefinierten Feldgruppe | |||
custom_ |
varchar2 |
Typ der benutzerdefinierten Feldgruppe | |||
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 | |||
filterable |
char |
Filterable | |||
hours_ |
varchar2 |
Stunden, Tarif, Art | |||
id |
varchar2 |
ID | |||
id_2 |
varchar2 |
itgen_spe_id_2 | |||
id_3 |
varchar2 |
itgen_spe_id_3 | |||
invoice_ |
varchar2 |
Geschäftszeichen / Bezug | |||
is_ |
char |
Rechnungsfreigabe | |||
is_ |
char |
Ist die umgekehrte Abrechnung | |||
label |
varchar2 |
Label | |||
label_ |
varchar2 |
itgen_spe_label_2 | |||
mandatory |
char |
itgen_spe_mandatory | |||
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 | |||
position |
int64 |
Position | |||
position_ |
int64 |
itgen_spe_position_2 | |||
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 | |||
render_ |
varchar2 |
Render-Typ | |||
searchable |
char |
Searchable | |||
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 | |||
type |
varchar2 |
Type | |||
updated_ |
varchar2 |
Aktualisiert am | |||
value |
varchar2 |
Value | |||
value_ |
varchar2 |
itgen_spe_value_2 | |||
value_ |
varchar2 |
Wert Typ |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: