HoursEmployeeexpense: Simplicate itgen_spe_hoursemployeeexpense_plural
read only REST
- Katalog:
Simplicate - Schema:
Hours - Bezeichnung: itgen_spe_hoursemployeeexpense_plural
Ruft die Spesen der Mitarbeiter ab
Es können nur Daten abgerufen werden.
API-Quelle
- Endpunkt:
/hours/employeeexpense - Operation:
get /hours/employeeexpense
Tabellenspalten
Die Spalten der Tabelle HoursEmployeeexpense sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
amount |
double |
Amount | |||
approval_ |
varchar2 |
Genehmigungsstatus Beschreibung | |||
approval_ |
varchar2 |
Kennzeichnung des Genehmigungsstatus | |||
costtype_ |
double |
Kostenart Budgetierter Betrag | |||
costtype_ |
char |
Kostenart gesperrt | |||
costtype_ |
varchar2 |
Kostenart-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 |
Kostenart-ID | |||
costtype_ |
varchar2 |
Kostenart-Bezeichnung | |||
costtype_ |
double |
Kostenart Kaufspanne | |||
costtype_ |
double |
Kostenart: Einkaufstarif | |||
costtype_ |
double |
Kostenart Tarif | |||
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 |
Mitarbeiterbetrag | |||
employee_ |
varchar2 |
Mitarbeiter deklarierbar | |||
employee_ |
varchar2 |
Mitarbeiter ID | |||
employee_ |
varchar2 |
Mitarbeiter ID | |||
employee_ |
varchar2 |
Mitarbeitername | |||
employee_ |
varchar2 |
Mitarbeiter-Personen-ID | Hinzugefügt, um der ursprünglichen sales/sales responsible_employee-Antwort zu entsprechen | ||
employee_ |
double |
Mitarbeitertarif | |||
id |
varchar2 |
ID | |||
invoice_ |
varchar2 |
Anmerkungen zur Rechnung | |||
invoice_ |
varchar2 |
Rechnungsart | |||
invoice_ |
varchar2 |
Rechnungskontakt-ID | |||
invoice_ |
varchar2 |
Rechnung erstellt | |||
invoice_ |
varchar2 |
Rechnung erstellt am | |||
invoice_ |
varchar2 |
Rechnungsdatum | |||
invoice_ |
varchar2 |
Rechnungs-ID | |||
invoice_ |
varchar2 |
Rechnungsnummer | |||
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 | Hinzugefügt, um der ursprünglichen sales/sales responsible_employee-Antwort zu entsprechen | ||
invoice_ |
double |
itgen_spe_invoice_project_project_manager_tariff | |||
invoice_ |
varchar2 |
itgen_spe_invoice_project_project_number | |||
invoice_ |
varchar2 |
Geschäftszeichen / Bezug | |||
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 |
Rechnungsstatus | |||
invoice_ |
varchar2 |
itgen_spe_invoice_status_2 | |||
invoice_ |
varchar2 |
Betreff der Rechnung | |||
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 |
Ist abrechnungsfähig | |||
note |
varchar2 |
Note | |||
project_ |
char |
itgen_spe_project_has_register_mileage_enabled | |||
project_ |
varchar2 |
Projekt ID | |||
project_ |
varchar2 |
Projektname | |||
project_ |
varchar2 |
Projekt-Organisations-ID | |||
project_ |
varchar2 |
Name der Projektorganisation | |||
project_ |
varchar2 |
itgen_spe_project_organization_relation_number | |||
project_ |
varchar2 |
Vollständiger Name der Projektverantwortlichen | |||
project_ |
varchar2 |
Projekt-Person-ID | |||
project_ |
varchar2 |
itgen_spe_project_person_relation_number | |||
project_ |
double |
Projektleiter Betrag | |||
project_ |
varchar2 |
Projektmanager (selbstständig) | |||
project_ |
varchar2 |
Projektmanager-Mitarbeiter-ID | |||
project_ |
varchar2 |
Projektmanager-ID | |||
project_ |
varchar2 |
Name des Projektleiters | |||
project_ |
varchar2 |
Projektmanager-ID | Hinzugefügt, um der ursprünglichen sales/sales responsible_employee-Antwort zu entsprechen | ||
project_ |
double |
Projektmanager Tarife | |||
project_ |
varchar2 |
Projektnummer | |||
purchase_ |
double |
Einkaufsspanne | |||
purchase_ |
double |
Gesamtkaufpreis | |||
purchase_ |
double |
Einkaufspreis pro Einheit | |||
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 |
Gesamtpreis |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: