HourCustomFields: Simplicate Uur Aangepaste Velden |
Fetches all hours
Catalogus: Simplicate
Schema: Hours
Label: Uur Aangepaste Velden
Dit is een alleen-lezen tabel. De Simplicate API biedt mogelijk geen ondersteuning voor het wijzigen van de data of het Invantive UniversalSQL-stuurprogramma voor Simplicate ondersteunt dit niet. In het laatste geval gebruikt u de tabel NativePlatformScalarRequests om gegevens te uploaden naar de Simplicate-API.
Tabelkolommen
De kolommen van de tabel HourCustomFields worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
absence_id |
string |
Afwezigheid ID |
☐ |
|
address_country_code |
string |
Adres Landcode |
☐ |
|
address_country_id |
string |
Adres Land-ID |
☐ |
|
address_line_1 |
string |
Adresregel 1 |
☐ |
|
address_line_2 |
string |
Adresregel 2 |
☐ |
|
address_locality |
string |
Adres Plaats |
☐ |
|
address_postal_code |
string |
Adres Postcode |
☐ |
|
address_province |
string |
Adres Provincie |
☐ |
|
address_type |
string |
Adressoort |
☐ |
|
approvalstatus_description |
string |
Goedkeuringsstatus Omschrijving |
☐ |
|
approvalstatus_id |
string |
Goedkeuringsstatus ID |
☐ |
|
approvalstatus_label |
string |
Goedkeuringsstatuslabel |
☐ |
|
assignment_id |
string |
Opdracht-ID |
☐ |
|
billable |
boolean |
Facturabel |
☐ |
|
corrections_amount |
float |
Correcties Bedrag |
☐ |
|
corrections_last_correction_date |
string |
|
☐ |
|
corrections_value |
float |
Correctiewaarde |
☐ |
|
created_at |
string |
Aangemaakt op |
☐ |
|
custom_field_group_id |
string |
Maatwerkveldgroep ID |
☐ |
|
custom_field_group_model_id |
string |
Maatwerkveldgroep Model ID |
☐ |
|
custom_field_group_model_label |
string |
Maatwerkveldgroep Modellabel |
☐ |
|
custom_field_group_name |
string |
Aangepast Veldgroepnaam |
☐ |
|
custom_field_group_position |
string |
Maatwerkveld Groeppositie |
☐ |
|
custom_field_group_type |
string |
Aangepast Veldgroepsoort |
☐ |
|
duration_in_minutes |
int64 |
|
☐ |
|
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 |
☐ |
|
filterable |
boolean |
Filterbaar |
☐ |
|
hours |
float |
Uren |
☐ |
|
id_2 |
string |
|
☐ |
|
id |
string |
ID |
☐ |
|
invoice_id |
string |
Factuur ID |
☐ |
Zie /facturen/factuur |
invoice_status |
string |
Factuurstatus |
☐ |
|
invoiceline_id |
string |
Factuurregel ID |
☐ |
Zie /facturen/factuur |
is_deletable_reason_message |
string |
|
☐ |
|
is_deletable_reason_translated_message |
string |
|
☐ |
|
is_deletable_value |
boolean |
|
☐ |
|
is_editable_reason_message |
string |
|
☐ |
|
is_editable_reason_translated_message |
string |
|
☐ |
|
is_editable_value |
boolean |
|
☐ |
|
is_external |
boolean |
Is Extern |
☐ |
|
is_productive |
boolean |
|
☐ |
|
is_recurring |
boolean |
Is Terugkerend |
☐ |
|
is_time_defined |
boolean |
Is tijd gedefinieerd |
☐ |
|
label |
string |
Label |
☐ |
|
leave_id |
string |
Afwezigheid ID |
☐ |
|
leave_status_id |
string |
Afwezigheid Status ID |
☐ |
|
leave_status_label |
string |
Afwezigheid Status Label |
☐ |
|
locked |
boolean |
Afgesloten |
☐ |
|
mandatory |
boolean |
|
☐ |
|
mileage_id |
string |
Kilometer-ID |
☐ |
|
mileage_mileage |
float |
Kilometerstand |
☐ |
|
name |
string |
Naam |
☐ |
|
note |
string |
Notitie |
☐ |
|
position |
int64 |
Positie |
☐ |
|
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_start_date |
string |
|
☐ |
Y-m-d, bijv. 2020-01-01 |
projectservice_until_date |
string |
|
☐ |
Y-m-d, bijv. 2020-01-01 |
recurrence_id |
string |
Herhaling ID |
☐ |
|
recurrence_rrule_byday |
string |
|
☐ |
|
recurrence_rrule_bysetpos |
string |
|
☐ |
|
recurrence_rrule_count |
int64 |
|
☐ |
|
recurrence_rrule_dtstart |
string |
|
☐ |
|
recurrence_rrule_freq |
int64 |
|
☐ |
|
recurrence_rrule_interval |
int64 |
|
☐ |
|
recurrence_rrule_until |
string |
|
☐ |
|
recurrence_rrule_wkst |
string |
|
☐ |
|
recurrence_update |
string |
Herhalingsupdate |
☐ |
|
render_type |
string |
Rendertype |
☐ |
|
searchable |
boolean |
Doorzoekbaar |
☐ |
|
should_sync_to_cronofy |
boolean |
Moet Synchroniseren met Cronofy |
☐ |
|
source |
string |
Bron |
☐ |
|
start_date |
string |
Startdatum |
☐ |
|
status |
string |
Status |
☐ |
|
tariff |
float |
Tarief |
☐ |
|
type_2_billable |
float |
|
☐ |
|
type_2_blocked |
boolean |
|
☐ |
|
type_2_color |
string |
|
☐ |
|
type_2_id |
string |
|
☐ |
|
type_2_label |
string |
|
☐ |
|
type_2_tariff |
float |
|
☐ |
|
type_2_type |
string |
|
☐ |
|
type_2_vatclass_code |
string |
|
☐ |
|
type_2_vatclass_id |
string |
|
☐ |
|
type_2_vatclass_label |
string |
|
☐ |
|
type_2_vatclass_name |
string |
|
☐ |
|
type_2_vatclass_percentage |
float |
|
☐ |
|
type |
string |
Soort |
☐ |
|
updated_at |
string |
Bijgewerkt op |
☐ |
|
value_type |
string |
Waardesoort |
☐ |
|
value |
string |
Waarde |
☐ |
|
18-10-2024 06:48 Versie 24.0.345-PROD+4945