Invantive-Dokumentation
Invantive SupportforenAnmelden / Eintragen

TimeTables: Simplicate Zeitpläne

insert REST

  • Katalog: Simplicate
  • Schema: HRM
  • Bezeichnung: Zeitpläne

Ruft alle verfügbaren Zeitpläne ab

Mit insert können Daten abgerufen und geändert werden.

API-Quelle

  • Endpunkt: /hrm/timetable
  • Operation: get /hrm/timetable

Tabellenspalten

Die Spalten der Tabelle TimeTables 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
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
end_date varchar2 Enddatum
even_week_day_1_end_time double itgen_spe_even_week_day_1_end_time
even_week_day_1_hours double itgen_spe_even_week_day_1_hours
even_week_day_1_start_time double itgen_spe_even_week_day_1_start_time
even_week_day_2_end_time double itgen_spe_even_week_day_2_end_time
even_week_day_2_hours double itgen_spe_even_week_day_2_hours
even_week_day_2_start_time double itgen_spe_even_week_day_2_start_time
even_week_day_3_end_time double itgen_spe_even_week_day_3_end_time
even_week_day_3_hours double itgen_spe_even_week_day_3_hours
even_week_day_3_start_time double itgen_spe_even_week_day_3_start_time
even_week_day_4_end_time double itgen_spe_even_week_day_4_end_time
even_week_day_4_hours double itgen_spe_even_week_day_4_hours
even_week_day_4_start_time double itgen_spe_even_week_day_4_start_time
even_week_day_5_end_time double itgen_spe_even_week_day_5_end_time
even_week_day_5_hours double itgen_spe_even_week_day_5_hours
even_week_day_5_start_time double itgen_spe_even_week_day_5_start_time
even_week_day_6_end_time double itgen_spe_even_week_day_6_end_time
even_week_day_6_hours double itgen_spe_even_week_day_6_hours
even_week_day_6_start_time double itgen_spe_even_week_day_6_start_time
even_week_day_7_end_time double itgen_spe_even_week_day_7_end_time
even_week_day_7_hours double itgen_spe_even_week_day_7_hours
even_week_day_7_start_time double itgen_spe_even_week_day_7_start_time
hourly_cost_tariff double Stundensattarif
hourly_sales_tariff double Stundentarif für den Stromverkauf
id varchar2 ID employee_id, siehe /hrm/employee
odd_week_day_1_end_time double itgen_spe_odd_week_day_1_end_time
odd_week_day_1_hours double itgen_spe_odd_week_day_1_hours
odd_week_day_1_start_time double itgen_spe_odd_week_day_1_start_time
odd_week_day_2_end_time double itgen_spe_odd_week_day_2_end_time
odd_week_day_2_hours double itgen_spe_odd_week_day_2_hours
odd_week_day_2_start_time double itgen_spe_odd_week_day_2_start_time
odd_week_day_3_end_time double itgen_spe_odd_week_day_3_end_time
odd_week_day_3_hours double itgen_spe_odd_week_day_3_hours
odd_week_day_3_start_time double itgen_spe_odd_week_day_3_start_time
odd_week_day_4_end_time double itgen_spe_odd_week_day_4_end_time
odd_week_day_4_hours double itgen_spe_odd_week_day_4_hours
odd_week_day_4_start_time double itgen_spe_odd_week_day_4_start_time
odd_week_day_5_end_time double itgen_spe_odd_week_day_5_end_time
odd_week_day_5_hours double itgen_spe_odd_week_day_5_hours
odd_week_day_5_start_time double itgen_spe_odd_week_day_5_start_time
odd_week_day_6_end_time double itgen_spe_odd_week_day_6_end_time
odd_week_day_6_hours double itgen_spe_odd_week_day_6_hours
odd_week_day_6_start_time double itgen_spe_odd_week_day_6_start_time
odd_week_day_7_end_time double itgen_spe_odd_week_day_7_end_time
odd_week_day_7_hours double itgen_spe_odd_week_day_7_hours
odd_week_day_7_start_time double itgen_spe_odd_week_day_7_start_time
productivity_target int64 Produktivitätsziel
should_write_hours char itgen_spe_should_write_hours
start_date varchar2 Anfangsdatum
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: