TimeTables: Simplicate Tijd Tabellen |
Fetches all available timetables
Catalogus: Simplicate
Schema: HRM
Label: Tijd Tabellen
Ophalen: true
Invoegen: true
Bijwerken: false
Verwijderen: false
Tabelkolommen
De kolommen van de tabel TimeTables worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet tijdens het invoegen steeds een nieuwe, niet-lege waarde worden opgegeven.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
created_at |
string |
Aangemaakt op |
☐ |
|
employee_amount |
float |
Medewerkerbedrag |
☐ |
|
employee_declarable |
string |
Declarabele Medewerker |
☐ |
|
employee_employee_id |
string |
Werknemer ID |
☐ |
|
employee_id |
string |
Werknemer ID |
☐ |
|
employee_name |
string |
Naam Werknemer |
☐ |
|
employee_person_id |
string |
Werknemer Persoon ID |
☐ |
Added in order to comply with the original sales/sales responsible_employee response |
employee_tariff |
float |
Personeelstarief |
☐ |
|
end_date |
string |
Einddatum |
☐ |
|
even_week_day_1_end_time |
float |
|
☐ |
|
even_week_day_1_hours |
float |
|
☐ |
|
even_week_day_1_start_time |
float |
|
☐ |
|
even_week_day_2_end_time |
float |
|
☐ |
|
even_week_day_2_hours |
float |
|
☐ |
|
even_week_day_2_start_time |
float |
|
☐ |
|
even_week_day_3_end_time |
float |
|
☐ |
|
even_week_day_3_hours |
float |
|
☐ |
|
even_week_day_3_start_time |
float |
|
☐ |
|
even_week_day_4_end_time |
float |
|
☐ |
|
even_week_day_4_hours |
float |
|
☐ |
|
even_week_day_4_start_time |
float |
|
☐ |
|
even_week_day_5_end_time |
float |
|
☐ |
|
even_week_day_5_hours |
float |
|
☐ |
|
even_week_day_5_start_time |
float |
|
☐ |
|
even_week_day_6_end_time |
float |
|
☐ |
|
even_week_day_6_hours |
float |
|
☐ |
|
even_week_day_6_start_time |
float |
|
☐ |
|
even_week_day_7_end_time |
float |
|
☐ |
|
even_week_day_7_hours |
float |
|
☐ |
|
even_week_day_7_start_time |
float |
|
☐ |
|
hourly_cost_tariff |
float |
Tarief per Uur |
☐ |
|
hourly_sales_tariff |
float |
Verkooptarief per Uur |
☐ |
|
id |
string |
ID |
☐ |
employee_id, Zie /hrm/employee |
odd_week_day_1_end_time |
float |
|
☐ |
|
odd_week_day_1_hours |
float |
|
☐ |
|
odd_week_day_1_start_time |
float |
|
☐ |
|
odd_week_day_2_end_time |
float |
|
☐ |
|
odd_week_day_2_hours |
float |
|
☐ |
|
odd_week_day_2_start_time |
float |
|
☐ |
|
odd_week_day_3_end_time |
float |
|
☐ |
|
odd_week_day_3_hours |
float |
|
☐ |
|
odd_week_day_3_start_time |
float |
|
☐ |
|
odd_week_day_4_end_time |
float |
|
☐ |
|
odd_week_day_4_hours |
float |
|
☐ |
|
odd_week_day_4_start_time |
float |
|
☐ |
|
odd_week_day_5_end_time |
float |
|
☐ |
|
odd_week_day_5_hours |
float |
|
☐ |
|
odd_week_day_5_start_time |
float |
|
☐ |
|
odd_week_day_6_end_time |
float |
|
☐ |
|
odd_week_day_6_hours |
float |
|
☐ |
|
odd_week_day_6_start_time |
float |
|
☐ |
|
odd_week_day_7_end_time |
float |
|
☐ |
|
odd_week_day_7_hours |
float |
|
☐ |
|
odd_week_day_7_start_time |
float |
|
☐ |
|
productivity_target |
int64 |
Productiviteitsdoel |
☐ |
|
should_write_hours |
boolean |
|
☐ |
|
start_date |
string |
Startdatum |
☐ |
|
updated_at |
string |
Bijgewerkt op |
☐ |
|
18-10-2024 06:48 Versie 24.0.345-PROD+4945