Timer: Simplicate Timer
insert update delete REST
- Katalog:
Simplicate - Schema:
Hours - Primärschlüssel:
id - Bezeichnung: Timer
Ruft alle Timer ab
Mit insert, update und delete können Daten abgerufen und geändert werden.
API-Quelle
- Endpunkt:
/timers/timer - Operation:
get /timers/timer
Tabellenspalten
Die Spalten der Tabelle Timers 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 |
|---|---|---|---|---|---|
created_ |
varchar2 |
Erstellt bei | |||
description |
varchar2 |
Description | |||
employee_ |
double |
Mitarbeiterbetrag | |||
employee_ |
varchar2 |
Mitarbeiter deklarierbar | |||
employee_ |
varchar2 |
Mitarbeiter ID | |||
employee_ |
varchar2 |
Mitarbeiter ID | |||
employee_ |
varchar2 |
Mitarbeitername | |||
employee_ |
varchar2 |
Mitarbeiter-Personen-ID | Hinzugefügt, um der ursprünglichen sales/sales responsible_employee-Antwort zu entsprechen | ||
employee_ |
double |
Mitarbeitertarif | |||
hourstype_ |
double |
itgen_spe_hourstype_billable | |||
hourstype_ |
char |
itgen_spe_hourstype_blocked | |||
hourstype_ |
varchar2 |
itgen_spe_hourstype_color | |||
hourstype_ |
varchar2 |
itgen_spe_hourstype_id | |||
hourstype_ |
varchar2 |
itgen_spe_hourstype_label | |||
hourstype_ |
double |
itgen_spe_hourstype_tariff | |||
hourstype_ |
varchar2 |
itgen_spe_hourstype_type | |||
hourstype_ |
varchar2 |
itgen_spe_hourstype_vatclass_code | |||
hourstype_ |
varchar2 |
itgen_spe_hourstype_vatclass_id | |||
hourstype_ |
varchar2 |
itgen_spe_hourstype_vatclass_label | |||
hourstype_ |
varchar2 |
itgen_spe_hourstype_vatclass_name | |||
hourstype_ |
double |
itgen_spe_hourstype_vatclass_percentage | |||
id |
varchar2 |
ID | |||
metadata |
varchar2 |
Metadata | JSON | ||
min_ |
double |
itgen_spe_min_seconds_step | |||
project_ |
char |
itgen_spe_project_has_register_mileage_enabled | |||
project_ |
varchar2 |
Projekt ID | |||
project_ |
varchar2 |
Projektname | |||
project_ |
varchar2 |
Projekt-Organisations-ID | |||
project_ |
varchar2 |
Name der Projektorganisation | |||
project_ |
varchar2 |
itgen_spe_project_organization_relation_number | |||
project_ |
varchar2 |
Vollständiger Name der Projektverantwortlichen | |||
project_ |
varchar2 |
Projekt-Person-ID | |||
project_ |
varchar2 |
itgen_spe_project_person_relation_number | |||
project_ |
double |
Projektleiter Betrag | |||
project_ |
varchar2 |
Projektmanager (selbstständig) | |||
project_ |
varchar2 |
Projektmanager-Mitarbeiter-ID | |||
project_ |
varchar2 |
Projektmanager-ID | |||
project_ |
varchar2 |
Name des Projektleiters | |||
project_ |
varchar2 |
Projektmanager-ID | Hinzugefügt, um der ursprünglichen sales/sales responsible_employee-Antwort zu entsprechen | ||
project_ |
double |
Projektmanager Tarife | |||
project_ |
varchar2 |
Projektnummer | |||
projectservice_ |
varchar2 |
itgen_spe_projectservice_default_service_id | |||
projectservice_ |
varchar2 |
Projekt-Service-ID | |||
projectservice_ |
varchar2 |
Name des Projektdienstes | |||
projectservice_ |
varchar2 |
itgen_spe_projectservice_revenue_group_id | |||
projectservice_ |
char |
itgen_spe_projectservice_use_in_resource_planner | |||
related_ |
varchar2 |
itgen_spe_related_hours_address_country_code | |||
related_ |
varchar2 |
itgen_spe_related_hours_address_country_id | |||
related_ |
varchar2 |
itgen_spe_related_hours_address_line_1 | |||
related_ |
varchar2 |
itgen_spe_related_hours_address_line_2 | |||
related_ |
varchar2 |
itgen_spe_related_hours_address_locality | |||
related_ |
varchar2 |
itgen_spe_related_hours_address_postal_code | |||
related_ |
varchar2 |
itgen_spe_related_hours_address_province | |||
related_ |
varchar2 |
itgen_spe_related_hours_address_type | |||
related_ |
varchar2 |
itgen_spe_related_hours_assignment_id | |||
related_ |
char |
itgen_spe_related_hours_billable | |||
related_ |
int64 |
itgen_spe_related_hours_duration_in_minutes | |||
related_ |
varchar2 |
itgen_spe_related_hours_end_date | |||
related_ |
double |
itgen_spe_related_hours_hours | |||
related_ |
varchar2 |
itgen_spe_related_hours_id | |||
related_ |
char |
itgen_spe_related_hours_is_external | |||
related_ |
char |
itgen_spe_related_hours_is_recurring | |||
related_ |
char |
itgen_spe_related_hours_is_time_defined | |||
related_ |
varchar2 |
itgen_spe_related_hours_note | |||
related_ |
varchar2 |
itgen_spe_related_hours_recurrence_id | |||
related_ |
varchar2 |
itgen_spe_related_hours_recurrence_rrule_byday | |||
related_ |
varchar2 |
itgen_spe_related_hours_recurrence_rrule_bysetpos | |||
related_ |
int64 |
itgen_spe_related_hours_recurrence_rrule_count | |||
related_ |
varchar2 |
itgen_spe_related_hours_recurrence_rrule_dtstart | |||
related_ |
int64 |
itgen_spe_related_hours_recurrence_rrule_freq | |||
related_ |
int64 |
itgen_spe_related_hours_recurrence_rrule_interval | |||
related_ |
varchar2 |
itgen_spe_related_hours_recurrence_rrule_until | |||
related_ |
varchar2 |
itgen_spe_related_hours_recurrence_rrule_wkst | |||
related_ |
varchar2 |
itgen_spe_related_hours_recurrence_update | |||
related_ |
char |
itgen_spe_related_hours_should_sync_to_cronofy | |||
related_ |
varchar2 |
itgen_spe_related_hours_source | |||
related_ |
varchar2 |
itgen_spe_related_hours_start_date | |||
seconds_ |
int64 |
itgen_spe_seconds_spent | |||
state |
varchar2 |
State | |||
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: