HourCustomFields: Simplicate Aangepaste velden uren
read only REST
- Catalogus:
Simplicate - Schema:
Hours - Label: Aangepaste velden uren
Haalt alle uren op
Kan alleen gegevens ophalen.
API-bron
- Eindpunt:
/hours/hours - Operatie:
get /hours/hours
Tabelkolommen
De kolommen van de tabel HourCustomFields 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.
| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
absence_ |
varchar2 |
Afwezigheid ID | |||
address_ |
varchar2 |
Adres Landcode | |||
address_ |
varchar2 |
Adres Land-ID | |||
address_ |
varchar2 |
Adresregel 1 | |||
address_ |
varchar2 |
Adresregel 2 | |||
address_ |
varchar2 |
Adres Plaats | |||
address_ |
varchar2 |
Adres Postcode | |||
address_ |
varchar2 |
Adres Provincie | |||
address_ |
varchar2 |
Adressoort | |||
approvalstatus_ |
varchar2 |
Goedkeuringsstatus Omschrijving | |||
approvalstatus_ |
varchar2 |
Goedkeuringsstatus ID | |||
approvalstatus_ |
varchar2 |
Goedkeuringsstatuslabel | |||
assignment_ |
varchar2 |
Opdracht-ID | |||
billable |
char |
Billable | |||
corrections_ |
double |
Correcties Bedrag | |||
corrections_ |
varchar2 |
itgen_spe_corrections_last_correction_date | |||
corrections_ |
double |
Correctiewaarde | |||
created_ |
varchar2 |
Aangemaakt op | |||
custom_ |
varchar2 |
Maatwerkveldgroep ID | |||
custom_ |
varchar2 |
Maatwerkveldgroep Model ID | |||
custom_ |
varchar2 |
Maatwerkveldgroep Modellabel | |||
custom_ |
varchar2 |
Aangepast Veldgroepnaam | |||
custom_ |
varchar2 |
Maatwerkveld Groeppositie | |||
custom_ |
varchar2 |
Aangepast Veldgroepsoort | |||
duration_ |
int64 |
itgen_spe_duration_in_minutes | |||
employee_ |
double |
Medewerkerbedrag | |||
employee_ |
varchar2 |
Declarabele Medewerker | |||
employee_ |
varchar2 |
Werknemer ID | |||
employee_ |
varchar2 |
Werknemer ID | |||
employee_ |
varchar2 |
Naam Werknemer | |||
employee_ |
varchar2 |
Werknemer Persoon ID | Toegevoegd om te voldoen aan de oorspronkelijke sales/sales responsible_employee-reactie | ||
employee_ |
double |
Personeelstarief | |||
end_ |
varchar2 |
Einddatum | |||
filterable |
char |
Filterable | |||
hours |
double |
Hours | |||
id |
varchar2 |
ID | |||
id_2 |
varchar2 |
itgen_spe_id_2 | |||
invoice_ |
varchar2 |
Factuur ID | Zie /invoices/invoice | ||
invoice_ |
varchar2 |
Factuurstatus | |||
invoiceline_ |
varchar2 |
Factuurregel ID | Zie /invoices/invoice | ||
is_ |
varchar2 |
itgen_spe_is_deletable_reason_message | |||
is_ |
varchar2 |
itgen_spe_is_deletable_reason_translated_message | |||
is_ |
char |
itgen_spe_is_deletable_value | |||
is_ |
varchar2 |
itgen_spe_is_editable_reason_message | |||
is_ |
varchar2 |
itgen_spe_is_editable_reason_translated_message | |||
is_ |
char |
itgen_spe_is_editable_value | |||
is_ |
char |
Is Extern | |||
is_ |
char |
itgen_spe_is_productive | |||
is_ |
char |
Is Terugkerend | |||
is_ |
char |
Is tijd gedefinieerd | |||
label |
varchar2 |
Label | |||
leave_ |
varchar2 |
Afwezigheid ID | |||
leave_ |
varchar2 |
Afwezigheid Status ID | |||
leave_ |
varchar2 |
Afwezigheid Status Label | |||
locked |
char |
Locked | |||
mandatory |
char |
itgen_spe_mandatory | |||
mileage_ |
varchar2 |
Kilometer-ID | |||
mileage_ |
double |
Mileage | |||
name |
varchar2 |
Name | |||
note |
varchar2 |
Note | |||
position |
int64 |
Position | |||
project_ |
char |
itgen_spe_project_has_register_mileage_enabled | |||
project_ |
varchar2 |
Project ID | |||
project_ |
varchar2 |
Projectnaam | |||
project_ |
varchar2 |
Projectorganisatie-ID | |||
project_ |
varchar2 |
Naam Projectorganisatie | |||
project_ |
varchar2 |
itgen_spe_project_organization_relation_number | |||
project_ |
varchar2 |
Project Persoon Volledige naam | |||
project_ |
varchar2 |
Projectpersoon-ID | |||
project_ |
varchar2 |
itgen_spe_project_person_relation_number | |||
project_ |
double |
Projectmanager Bedrag | |||
project_ |
varchar2 |
Projectmanager Declarable | |||
project_ |
varchar2 |
Projectmanager Werknemer ID | |||
project_ |
varchar2 |
Projectmanager ID | |||
project_ |
varchar2 |
Projectmanager Naam | |||
project_ |
varchar2 |
Projectmanager Persoon ID | Toegevoegd om te voldoen aan de oorspronkelijke sales/sales responsible_employee-reactie | ||
project_ |
double |
Projectmanager Tarief | |||
project_ |
varchar2 |
Projectnummer | |||
projectservice_ |
varchar2 |
itgen_spe_projectservice_default_service_id | |||
projectservice_ |
varchar2 |
Projectdienst ID | |||
projectservice_ |
varchar2 |
Projectservicenaam | |||
projectservice_ |
varchar2 |
itgen_spe_projectservice_revenue_group_id | |||
projectservice_ |
varchar2 |
itgen_spe_projectservice_start_date | Y-m-d, eg.2020-01-01 | ||
projectservice_ |
varchar2 |
itgen_spe_projectservice_until_date | Y-m-d, eg.2020-01-01 | ||
recurrence_ |
varchar2 |
Herhaling ID | |||
recurrence_ |
varchar2 |
itgen_spe_recurrence_rrule_byday | |||
recurrence_ |
varchar2 |
itgen_spe_recurrence_rrule_bysetpos | |||
recurrence_ |
int64 |
itgen_spe_recurrence_rrule_count | |||
recurrence_ |
varchar2 |
itgen_spe_recurrence_rrule_dtstart | |||
recurrence_ |
int64 |
itgen_spe_recurrence_rrule_freq | |||
recurrence_ |
int64 |
itgen_spe_recurrence_rrule_interval | |||
recurrence_ |
varchar2 |
itgen_spe_recurrence_rrule_until | |||
recurrence_ |
varchar2 |
itgen_spe_recurrence_rrule_wkst | |||
recurrence_ |
varchar2 |
Herhalingsupdate | |||
render_ |
varchar2 |
Rendertype | |||
searchable |
char |
Searchable | |||
should_ |
char |
Moet Synchroniseren met Cronofy | |||
source |
varchar2 |
Source | |||
start_ |
varchar2 |
Startdatum | |||
status |
varchar2 |
Status | |||
tariff |
double |
Tariff | |||
type |
varchar2 |
Type | |||
type_ |
double |
itgen_spe_type_2_billable | |||
type_ |
char |
itgen_spe_type_2_blocked | |||
type_ |
varchar2 |
itgen_spe_type_2_color | |||
type_ |
varchar2 |
itgen_spe_type_2_id | |||
type_ |
varchar2 |
itgen_spe_type_2_label | |||
type_ |
double |
itgen_spe_type_2_tariff | |||
type_ |
varchar2 |
itgen_spe_type_2_type | |||
type_ |
varchar2 |
itgen_spe_type_2_vatclass_code | |||
type_ |
varchar2 |
itgen_spe_type_2_vatclass_id | |||
type_ |
varchar2 |
itgen_spe_type_2_vatclass_label | |||
type_ |
varchar2 |
itgen_spe_type_2_vatclass_name | |||
type_ |
double |
itgen_spe_type_2_vatclass_percentage | |||
updated_ |
varchar2 |
Bijgewerkt op | |||
value |
varchar2 |
Value | |||
value_ |
varchar2 |
Waardesoort |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: