Timers: Simplicate Timers |
Fetches all timers
Catalogus: Simplicate
Schema: Hours
Primaire Sleutels: id
Label: Timers
Kan gegevens ophalen en wijzigen met behulp van toevoegen, bijwerken en verwijderen.
Tabelkolommen
De kolommen van de tabel Timers worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
created_at |
string |
Aangemaakt op |
☐ |
|
description |
string |
Omschrijving |
☐ |
|
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 |
☐ |
|
hourstype_billable |
float |
|
☐ |
|
hourstype_blocked |
boolean |
|
☐ |
|
hourstype_color |
string |
|
☐ |
|
hourstype_id |
string |
|
☐ |
|
hourstype_label |
string |
|
☐ |
|
hourstype_tariff |
float |
|
☐ |
|
hourstype_type |
string |
|
☐ |
|
hourstype_vatclass_code |
string |
|
☐ |
|
hourstype_vatclass_id |
string |
|
☐ |
|
hourstype_vatclass_label |
string |
|
☐ |
|
hourstype_vatclass_name |
string |
|
☐ |
|
hourstype_vatclass_percentage |
float |
|
☐ |
|
id |
string |
ID |
☐ |
|
metadata |
string |
Metadata |
☐ |
JSON |
min_seconds_step |
float |
|
☐ |
|
project_has_register_mileage_enabled |
boolean |
|
☐ |
|
project_id |
string |
Project ID |
☐ |
|
project_name |
string |
Projectnaam |
☐ |
|
project_organization_id |
string |
Projectorganisatie-ID |
☐ |
|
project_organization_name |
string |
Naam Projectorganisatie |
☐ |
|
project_organization_relation_number |
string |
|
☐ |
|
project_person_full_name |
string |
Project Persoon Volledige naam |
☐ |
|
project_person_id |
string |
Projectpersoon-ID |
☐ |
|
project_person_relation_number |
string |
|
☐ |
|
project_project_manager_amount |
float |
Projectmanager Bedrag |
☐ |
|
project_project_manager_declarable |
string |
Projectmanager Declarable |
☐ |
|
project_project_manager_employee_id |
string |
Projectmanager Werknemer ID |
☐ |
|
project_project_manager_id |
string |
Projectmanager ID |
☐ |
|
project_project_manager_name |
string |
Projectmanager Naam |
☐ |
|
project_project_manager_person_id |
string |
Projectmanager Persoon ID |
☐ |
Added in order to comply with the original sales/sales responsible_employee response |
project_project_manager_tariff |
float |
Projectmanager Tarief |
☐ |
|
project_project_number |
string |
Projectnummer |
☐ |
|
projectservice_default_service_id |
string |
|
☐ |
|
projectservice_id |
string |
Projectdienst ID |
☐ |
|
projectservice_name |
string |
Projectservicenaam |
☐ |
|
projectservice_revenue_group_id |
string |
|
☐ |
|
projectservice_use_in_resource_planner |
boolean |
|
☐ |
|
related_hours_address_country_code |
string |
|
☐ |
|
related_hours_address_country_id |
string |
|
☐ |
|
related_hours_address_line_1 |
string |
|
☐ |
|
related_hours_address_line_2 |
string |
|
☐ |
|
related_hours_address_locality |
string |
|
☐ |
|
related_hours_address_postal_code |
string |
|
☐ |
|
related_hours_address_province |
string |
|
☐ |
|
related_hours_address_type |
string |
|
☐ |
|
related_hours_assignment_id |
string |
|
☐ |
|
related_hours_billable |
boolean |
|
☐ |
|
related_hours_duration_in_minutes |
int64 |
|
☐ |
|
related_hours_end_date |
string |
|
☐ |
|
related_hours_hours |
float |
|
☐ |
|
related_hours_id |
string |
|
☐ |
|
related_hours_is_external |
boolean |
|
☐ |
|
related_hours_is_recurring |
boolean |
|
☐ |
|
related_hours_is_time_defined |
boolean |
|
☐ |
|
related_hours_note |
string |
|
☐ |
|
related_hours_recurrence_id |
string |
|
☐ |
|
related_hours_recurrence_rrule_byday |
string |
|
☐ |
|
related_hours_recurrence_rrule_bysetpos |
string |
|
☐ |
|
related_hours_recurrence_rrule_count |
int64 |
|
☐ |
|
related_hours_recurrence_rrule_dtstart |
string |
|
☐ |
|
related_hours_recurrence_rrule_freq |
int64 |
|
☐ |
|
related_hours_recurrence_rrule_interval |
int64 |
|
☐ |
|
related_hours_recurrence_rrule_until |
string |
|
☐ |
|
related_hours_recurrence_rrule_wkst |
string |
|
☐ |
|
related_hours_recurrence_update |
string |
|
☐ |
|
related_hours_should_sync_to_cronofy |
boolean |
|
☐ |
|
related_hours_source |
string |
|
☐ |
|
related_hours_start_date |
string |
|
☐ |
|
seconds_spent |
int64 |
|
☐ |
|
state |
string |
Provincie |
☐ |
|
updated_at |
string |
Bijgewerkt op |
☐ |
|
18-10-2024 06:48 Versie 24.0.345-PROD+4945