EmployeeExpenseAttachments: Simplicate itgen_spe_employeeexpenseattachments_plural
read only REST
- Catalogus:
Simplicate - Schema:
Hours - Label: itgen_spe_employeeexpenseattachments_plural
Haalt de declaraties van medewerkers op
Kan alleen gegevens ophalen.
API-bron
- Eindpunt:
/hours/employeeexpense - Operatie:
get /hours/employeeexpense
Tabelkolommen
De kolommen van de tabel EmployeeExpenseAttachments 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 |
|---|---|---|---|---|---|
amount |
double |
Amount | |||
approval_ |
varchar2 |
Goedkeuringsstatus Omschrijving | |||
approval_ |
varchar2 |
Goedkeuringsstatuslabel | |||
costtype_ |
double |
Kostentype Gebudgetteerd Bedrag | |||
costtype_ |
char |
Geblokkeerde Kostensoort | |||
costtype_ |
varchar2 |
Kostentype ID | |||
costtype_ |
char |
itgen_spe_costtype_costtype_is_attachment_allowed | |||
costtype_ |
char |
itgen_spe_costtype_costtype_is_unit_tariff | |||
costtype_ |
varchar2 |
itgen_spe_costtype_costtype_label | |||
costtype_ |
double |
itgen_spe_costtype_costtype_tariff | |||
costtype_ |
varchar2 |
itgen_spe_costtype_costtype_unit_name | |||
costtype_ |
varchar2 |
Kostentype ID | |||
costtype_ |
varchar2 |
Kostentypelabel | |||
costtype_ |
double |
Kostensoort Aankoopmarge | |||
costtype_ |
double |
Kostensoort Aankooptarief | |||
costtype_ |
double |
Kostensoorttarief | |||
date |
varchar2 |
Date | |||
default_ |
char |
itgen_spe_default_costtype_blocked | |||
default_ |
varchar2 |
itgen_spe_default_costtype_id | |||
default_ |
char |
itgen_spe_default_costtype_is_attachment_allowed | |||
default_ |
char |
itgen_spe_default_costtype_is_unit_tariff | |||
default_ |
varchar2 |
itgen_spe_default_costtype_label | |||
default_ |
double |
itgen_spe_default_costtype_tariff | |||
default_ |
varchar2 |
itgen_spe_default_costtype_unit_name | |||
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 | |||
file_ |
varchar2 |
itgen_spe_file_hash | |||
file_ |
varchar2 |
itgen_spe_file_name | |||
id |
varchar2 |
ID | |||
invoice_ |
varchar2 |
Factuuropmerkingen | |||
invoice_ |
varchar2 |
Factuur Samenstelling Soort | |||
invoice_ |
varchar2 |
Factuurcontactpersoon ID | |||
invoice_ |
varchar2 |
Factuur Aangemaakt | |||
invoice_ |
varchar2 |
Factuur aangemaakt op | |||
invoice_ |
varchar2 |
Factuurdatum | |||
invoice_ |
varchar2 |
Factuur ID | |||
invoice_ |
varchar2 |
Factuurnummer | |||
invoice_ |
varchar2 |
itgen_spe_invoice_my_organization_profile_id | |||
invoice_ |
varchar2 |
itgen_spe_invoice_my_organization_profile_id_2 | |||
invoice_ |
varchar2 |
itgen_spe_invoice_my_organization_profile_organization_id | |||
invoice_ |
varchar2 |
itgen_spe_invoice_my_organization_profile_organization_name | |||
invoice_ |
varchar2 |
itgen_spe_invoice_my_organization_profile_organization_relation_number | |||
invoice_ |
varchar2 |
itgen_spe_invoice_organization_id | |||
invoice_ |
varchar2 |
itgen_spe_invoice_organization_id_2 | |||
invoice_ |
varchar2 |
itgen_spe_invoice_organization_name | |||
invoice_ |
varchar2 |
itgen_spe_invoice_organization_relation_number | |||
invoice_ |
int64 |
itgen_spe_invoice_payment_term_days | |||
invoice_ |
varchar2 |
itgen_spe_invoice_payment_term_id | |||
invoice_ |
varchar2 |
itgen_spe_invoice_payment_term_method | |||
invoice_ |
varchar2 |
itgen_spe_invoice_payment_term_name | |||
invoice_ |
varchar2 |
itgen_spe_invoice_person_full_name | |||
invoice_ |
varchar2 |
itgen_spe_invoice_person_id | |||
invoice_ |
varchar2 |
itgen_spe_invoice_person_id_2 | |||
invoice_ |
varchar2 |
itgen_spe_invoice_person_relation_number | |||
invoice_ |
char |
itgen_spe_invoice_project_has_register_mileage_enabled | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_id | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_id_2 | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_name | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_organization_id | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_organization_name | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_organization_relation_number | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_person_full_name | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_person_id | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_person_relation_number | |||
invoice_ |
double |
itgen_spe_invoice_project_project_manager_amount | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_project_manager_declarable | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_project_manager_employee_id | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_project_manager_id | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_project_manager_name | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_project_manager_person_id | Toegevoegd om te voldoen aan de oorspronkelijke sales/sales responsible_employee-reactie | ||
invoice_ |
double |
itgen_spe_invoice_project_project_manager_tariff | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_project_number | |||
invoice_ |
varchar2 |
Factuur Referentie | |||
invoice_ |
varchar2 |
itgen_spe_invoice_reminder_next_action | |||
invoice_ |
char |
itgen_spe_invoice_reminder_paused | |||
invoice_ |
char |
itgen_spe_invoice_reminder_set_disabled | |||
invoice_ |
varchar2 |
itgen_spe_invoice_reminder_set_label | |||
invoice_ |
varchar2 |
itgen_spe_invoice_reminder_status | |||
invoice_ |
varchar2 |
itgen_spe_invoice_sending_method | |||
invoice_ |
varchar2 |
itgen_spe_invoice_simplicate_url | |||
invoice_ |
varchar2 |
Factuurstatus | |||
invoice_ |
varchar2 |
itgen_spe_invoice_status_2 | |||
invoice_ |
varchar2 |
Factuuronderwerp | |||
invoice_ |
varchar2 |
itgen_spe_invoice_subscription_cycle_end_date | |||
invoice_ |
char |
itgen_spe_invoice_subscription_cycle_is_invoiced | |||
invoice_ |
varchar2 |
itgen_spe_invoice_subscription_cycle_start_date | |||
invoice_ |
varchar2 |
itgen_spe_invoice_timeline_email_address | |||
invoice_ |
double |
itgen_spe_invoice_total_excluding_vat | |||
invoice_ |
double |
itgen_spe_invoice_total_including_vat | |||
invoice_ |
double |
itgen_spe_invoice_total_outstanding | |||
invoice_ |
double |
itgen_spe_invoice_total_vat | |||
invoice_ |
varchar2 |
itgen_spe_invoice_updated_at | |||
is_ |
char |
Is Facturabel | |||
note |
varchar2 |
Note | |||
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 | |||
purchase_ |
double |
Inkoop Marge | |||
purchase_ |
double |
Inkoopprijs Totaal | |||
purchase_ |
double |
Aankoop Eenheidsprijs | |||
service_ |
varchar2 |
Service-ID | |||
service_ |
varchar2 |
itgen_spe_service_purchase_end_date | |||
service_ |
varchar2 |
itgen_spe_service_purchase_start_date | |||
tariff |
double |
Tariff | |||
total_ |
double |
Totale Prijs |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: