invantive documentation
Invantive SupportforenAnmelden / Eintragen

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_at varchar2 Erstellt bei
description varchar2 Description
employee_amount double Mitarbeiterbetrag
employee_declarable varchar2 Mitarbeiter deklarierbar
employee_employee_id varchar2 Mitarbeiter ID
employee_id varchar2 Mitarbeiter ID
employee_name varchar2 Mitarbeitername
employee_person_id varchar2 Mitarbeiter-Personen-ID Hinzugefügt, um der ursprünglichen sales/sales responsible_employee-Antwort zu entsprechen
employee_tariff double Mitarbeitertarif
hourstype_billable double itgen_spe_hourstype_billable
hourstype_blocked char itgen_spe_hourstype_blocked
hourstype_color varchar2 itgen_spe_hourstype_color
hourstype_id varchar2 itgen_spe_hourstype_id
hourstype_label varchar2 itgen_spe_hourstype_label
hourstype_tariff double itgen_spe_hourstype_tariff
hourstype_type varchar2 itgen_spe_hourstype_type
hourstype_vatclass_code varchar2 itgen_spe_hourstype_vatclass_code
hourstype_vatclass_id varchar2 itgen_spe_hourstype_vatclass_id
hourstype_vatclass_label varchar2 itgen_spe_hourstype_vatclass_label
hourstype_vatclass_name varchar2 itgen_spe_hourstype_vatclass_name
hourstype_vatclass_percentage double itgen_spe_hourstype_vatclass_percentage
id varchar2 ID
metadata varchar2 Metadata JSON
min_seconds_step double itgen_spe_min_seconds_step
project_has_register_mileage_enabled char itgen_spe_project_has_register_mileage_enabled
project_id varchar2 Projekt ID
project_name varchar2 Projektname
project_organization_id varchar2 Projekt-Organisations-ID
project_organization_name varchar2 Name der Projektorganisation
project_organization_relation_number varchar2 itgen_spe_project_organization_relation_number
project_person_full_name varchar2 Vollständiger Name der Projektverantwortlichen
project_person_id varchar2 Projekt-Person-ID
project_person_relation_number varchar2 itgen_spe_project_person_relation_number
project_project_manager_amount double Projektleiter Betrag
project_project_manager_declarable varchar2 Projektmanager (selbstständig)
project_project_manager_employee_id varchar2 Projektmanager-Mitarbeiter-ID
project_project_manager_id varchar2 Projektmanager-ID
project_project_manager_name varchar2 Name des Projektleiters
project_project_manager_person_id varchar2 Projektmanager-ID Hinzugefügt, um der ursprünglichen sales/sales responsible_employee-Antwort zu entsprechen
project_project_manager_tariff double Projektmanager Tarife
project_project_number varchar2 Projektnummer
projectservice_default_service_id varchar2 itgen_spe_projectservice_default_service_id
projectservice_id varchar2 Projekt-Service-ID
projectservice_name varchar2 Name des Projektdienstes
projectservice_revenue_group_id varchar2 itgen_spe_projectservice_revenue_group_id
projectservice_use_in_resource_planner char itgen_spe_projectservice_use_in_resource_planner
related_hours_address_country_code varchar2 itgen_spe_related_hours_address_country_code
related_hours_address_country_id varchar2 itgen_spe_related_hours_address_country_id
related_hours_address_line_1 varchar2 itgen_spe_related_hours_address_line_1
related_hours_address_line_2 varchar2 itgen_spe_related_hours_address_line_2
related_hours_address_locality varchar2 itgen_spe_related_hours_address_locality
related_hours_address_postal_code varchar2 itgen_spe_related_hours_address_postal_code
related_hours_address_province varchar2 itgen_spe_related_hours_address_province
related_hours_address_type varchar2 itgen_spe_related_hours_address_type
related_hours_assignment_id varchar2 itgen_spe_related_hours_assignment_id
related_hours_billable char itgen_spe_related_hours_billable
related_hours_duration_in_minutes int64 itgen_spe_related_hours_duration_in_minutes
related_hours_end_date varchar2 itgen_spe_related_hours_end_date
related_hours_hours double itgen_spe_related_hours_hours
related_hours_id varchar2 itgen_spe_related_hours_id
related_hours_is_external char itgen_spe_related_hours_is_external
related_hours_is_recurring char itgen_spe_related_hours_is_recurring
related_hours_is_time_defined char itgen_spe_related_hours_is_time_defined
related_hours_note varchar2 itgen_spe_related_hours_note
related_hours_recurrence_id varchar2 itgen_spe_related_hours_recurrence_id
related_hours_recurrence_rrule_byday varchar2 itgen_spe_related_hours_recurrence_rrule_byday
related_hours_recurrence_rrule_bysetpos varchar2 itgen_spe_related_hours_recurrence_rrule_bysetpos
related_hours_recurrence_rrule_count int64 itgen_spe_related_hours_recurrence_rrule_count
related_hours_recurrence_rrule_dtstart varchar2 itgen_spe_related_hours_recurrence_rrule_dtstart
related_hours_recurrence_rrule_freq int64 itgen_spe_related_hours_recurrence_rrule_freq
related_hours_recurrence_rrule_interval int64 itgen_spe_related_hours_recurrence_rrule_interval
related_hours_recurrence_rrule_until varchar2 itgen_spe_related_hours_recurrence_rrule_until
related_hours_recurrence_rrule_wkst varchar2 itgen_spe_related_hours_recurrence_rrule_wkst
related_hours_recurrence_update varchar2 itgen_spe_related_hours_recurrence_update
related_hours_should_sync_to_cronofy char itgen_spe_related_hours_should_sync_to_cronofy
related_hours_source varchar2 itgen_spe_related_hours_source
related_hours_start_date varchar2 itgen_spe_related_hours_start_date
seconds_spent int64 itgen_spe_seconds_spent
state varchar2 State
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: