---
title: "ExpenseCostsById (Simplicate)"
description: "Expense Costs by ID"
language: de
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/de/datamodels/simplicate/Simplicate.Costs.ExpenseCostsById
original: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.Costs.ExpenseCostsById
updated: 2026-11-18T23:53:33Z
license: https://documentation.invantive.eu/de/
---

# ExpenseCostsById: Simplicate Spesenkosten nach ID

`read only` `REST`

- Katalog: `Simplicate`
- Schema: `Costs`
- Bezeichnung: Spesenkosten nach ID

Ruft eine einzelne Spese eines Mitarbeiters ab

Es können nur Daten abgerufen werden.

## API-Quelle

- Endpunkt: `/costs/expense/{id}`
- Operation: `get /costs/expense/{id}`

## Parameter

| Name | Datentyp | Required | Default | Documentation |
|---|---|:---:|---|---|
| `id` | `` | [x] |  | Die ID der Vorlage |

## Tabellenspalten

Die Spalten der Tabelle `ExpenseCostsById` 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_status_description` | `varchar2` | Genehmigungsstatus Beschreibung | [ ] |  |  |
| `approval_status_label` | `varchar2` | Kennzeichnung des Genehmigungsstatus | [ ] |  |  |
| `costtype_budgeted_amount` | `double` | Kostenart Budgetierter Betrag | [ ] |  |  |
| `costtype_costtype_blocked` | `char` | Kostenart gesperrt | [ ] |  |  |
| `costtype_costtype_id` | `varchar2` | Kostenart-ID | [ ] |  |  |
| `costtype_costtype_is_attachment_allowed` | `char` | itgen_spe_costtype_costtype_is_attachment_allowed | [ ] |  |  |
| `costtype_costtype_is_unit_tariff` | `char` | itgen_spe_costtype_costtype_is_unit_tariff | [ ] |  |  |
| `costtype_costtype_label` | `varchar2` | itgen_spe_costtype_costtype_label | [ ] |  |  |
| `costtype_costtype_tariff` | `double` | itgen_spe_costtype_costtype_tariff | [ ] |  |  |
| `costtype_costtype_unit_name` | `varchar2` | itgen_spe_costtype_costtype_unit_name | [ ] |  |  |
| `costtype_id` | `varchar2` | Kostenart-ID | [ ] |  |  |
| `costtype_label` | `varchar2` | Kostenart-Bezeichnung | [ ] |  |  |
| `costtype_purchase_margin` | `double` | Kostenart Kaufspanne | [ ] |  |  |
| `costtype_purchase_tariff` | `double` | Kostenart: Einkaufstarif | [ ] |  |  |
| `costtype_tariff` | `double` | Kostenart Tarif | [ ] |  |  |
| `date` | `varchar2` | Date | [ ] |  |  |
| `default_costtype_blocked` | `char` | itgen_spe_default_costtype_blocked | [ ] |  |  |
| `default_costtype_id` | `varchar2` | itgen_spe_default_costtype_id | [ ] |  |  |
| `default_costtype_is_attachment_allowed` | `char` | itgen_spe_default_costtype_is_attachment_allowed | [ ] |  |  |
| `default_costtype_is_unit_tariff` | `char` | itgen_spe_default_costtype_is_unit_tariff | [ ] |  |  |
| `default_costtype_label` | `varchar2` | itgen_spe_default_costtype_label | [ ] |  |  |
| `default_costtype_tariff` | `double` | itgen_spe_default_costtype_tariff | [ ] |  |  |
| `default_costtype_unit_name` | `varchar2` | itgen_spe_default_costtype_unit_name | [ ] |  |  |
| `employee_amount` | `double` | Mitarbeiterbetrag | [ ] |  |  |
| `employee_declarable` | `varchar2` | Mitarbeiter deklarierbar | [ ] |  |  |
| `employee_employee_id` | `varchar2` | Mitarbeiter ID | [ ] |  |  |
| `employee_id` | `varchar2` | Mitarbeiter ID | [ ] |  |  |
| `employee_name` | `varchar2` | Mitarbeitername | [ ] |  |  |
| `employee_person_id` | `varchar2` | Mitarbeiter-Personen-ID | [ ] |  | Hinzugefügt, um der ursprünglichen sales/sales responsible_employee-Antwort zu entsprechen |
| `employee_tariff` | `double` | Mitarbeitertarif | [ ] |  |  |
| `id` | `varchar2` | ID | [ ] |  |  |
| `invoice_comments` | `varchar2` | Anmerkungen zur Rechnung | [ ] |  |  |
| `invoice_composition_type` | `varchar2` | Rechnungsart | [ ] |  |  |
| `invoice_contact_id` | `varchar2` | Rechnungskontakt-ID | [ ] |  |  |
| `invoice_created` | `varchar2` | Rechnung erstellt | [ ] |  |  |
| `invoice_created_at` | `varchar2` | Rechnung erstellt am | [ ] |  |  |
| `invoice_date` | `varchar2` | Rechnungsdatum | [ ] |  |  |
| `invoice_id` | `varchar2` | Rechnungs-ID | [ ] |  |  |
| `invoice_invoice_number` | `varchar2` | Rechnungsnummer | [ ] |  |  |
| `invoice_my_organization_profile_id` | `varchar2` | itgen_spe_invoice_my_organization_profile_id | [ ] |  |  |
| `invoice_my_organization_profile_id_2` | `varchar2` | itgen_spe_invoice_my_organization_profile_id_2 | [ ] |  |  |
| `invoice_my_organization_profile_organization_id` | `varchar2` | itgen_spe_invoice_my_organization_profile_organization_id | [ ] |  |  |
| `invoice_my_organization_profile_organization_name` | `varchar2` | itgen_spe_invoice_my_organization_profile_organization_name | [ ] |  |  |
| `invoice_my_organization_profile_organization_relation_number` | `varchar2` | itgen_spe_invoice_my_organization_profile_organization_relation_number | [ ] |  |  |
| `invoice_organization_id` | `varchar2` | itgen_spe_invoice_organization_id | [ ] |  |  |
| `invoice_organization_id_2` | `varchar2` | itgen_spe_invoice_organization_id_2 | [ ] |  |  |
| `invoice_organization_name` | `varchar2` | itgen_spe_invoice_organization_name | [ ] |  |  |
| `invoice_organization_relation_number` | `varchar2` | itgen_spe_invoice_organization_relation_number | [ ] |  |  |
| `invoice_payment_term_days` | `int64` | itgen_spe_invoice_payment_term_days | [ ] |  |  |
| `invoice_payment_term_id` | `varchar2` | itgen_spe_invoice_payment_term_id | [ ] |  |  |
| `invoice_payment_term_method` | `varchar2` | itgen_spe_invoice_payment_term_method | [ ] |  |  |
| `invoice_payment_term_name` | `varchar2` | itgen_spe_invoice_payment_term_name | [ ] |  |  |
| `invoice_person_full_name` | `varchar2` | itgen_spe_invoice_person_full_name | [ ] |  |  |
| `invoice_person_id` | `varchar2` | itgen_spe_invoice_person_id | [ ] |  |  |
| `invoice_person_id_2` | `varchar2` | itgen_spe_invoice_person_id_2 | [ ] |  |  |
| `invoice_person_relation_number` | `varchar2` | itgen_spe_invoice_person_relation_number | [ ] |  |  |
| `invoice_project_has_register_mileage_enabled` | `char` | itgen_spe_invoice_project_has_register_mileage_enabled | [ ] |  |  |
| `invoice_project_id` | `varchar2` | itgen_spe_invoice_project_id | [ ] |  |  |
| `invoice_project_id_2` | `varchar2` | itgen_spe_invoice_project_id_2 | [ ] |  |  |
| `invoice_project_name` | `varchar2` | itgen_spe_invoice_project_name | [ ] |  |  |
| `invoice_project_organization_id` | `varchar2` | itgen_spe_invoice_project_organization_id | [ ] |  |  |
| `invoice_project_organization_name` | `varchar2` | itgen_spe_invoice_project_organization_name | [ ] |  |  |
| `invoice_project_organization_relation_number` | `varchar2` | itgen_spe_invoice_project_organization_relation_number | [ ] |  |  |
| `invoice_project_person_full_name` | `varchar2` | itgen_spe_invoice_project_person_full_name | [ ] |  |  |
| `invoice_project_person_id` | `varchar2` | itgen_spe_invoice_project_person_id | [ ] |  |  |
| `invoice_project_person_relation_number` | `varchar2` | itgen_spe_invoice_project_person_relation_number | [ ] |  |  |
| `invoice_project_project_manager_amount` | `double` | itgen_spe_invoice_project_project_manager_amount | [ ] |  |  |
| `invoice_project_project_manager_declarable` | `varchar2` | itgen_spe_invoice_project_project_manager_declarable | [ ] |  |  |
| `invoice_project_project_manager_employee_id` | `varchar2` | itgen_spe_invoice_project_project_manager_employee_id | [ ] |  |  |
| `invoice_project_project_manager_id` | `varchar2` | itgen_spe_invoice_project_project_manager_id | [ ] |  |  |
| `invoice_project_project_manager_name` | `varchar2` | itgen_spe_invoice_project_project_manager_name | [ ] |  |  |
| `invoice_project_project_manager_person_id` | `varchar2` | itgen_spe_invoice_project_project_manager_person_id | [ ] |  | Hinzugefügt, um der ursprünglichen sales/sales responsible_employee-Antwort zu entsprechen |
| `invoice_project_project_manager_tariff` | `double` | itgen_spe_invoice_project_project_manager_tariff | [ ] |  |  |
| `invoice_project_project_number` | `varchar2` | itgen_spe_invoice_project_project_number | [ ] |  |  |
| `invoice_reference` | `varchar2` | Geschäftszeichen / Bezug | [ ] |  |  |
| `invoice_reminder_next_action` | `varchar2` | itgen_spe_invoice_reminder_next_action | [ ] |  |  |
| `invoice_reminder_paused` | `char` | itgen_spe_invoice_reminder_paused | [ ] |  |  |
| `invoice_reminder_set_disabled` | `char` | itgen_spe_invoice_reminder_set_disabled | [ ] |  |  |
| `invoice_reminder_set_label` | `varchar2` | itgen_spe_invoice_reminder_set_label | [ ] |  |  |
| `invoice_reminder_status` | `varchar2` | itgen_spe_invoice_reminder_status | [ ] |  |  |
| `invoice_sending_method` | `varchar2` | itgen_spe_invoice_sending_method | [ ] |  |  |
| `invoice_simplicate_url` | `varchar2` | itgen_spe_invoice_simplicate_url | [ ] |  |  |
| `invoice_status` | `varchar2` | Rechnungsstatus | [ ] |  |  |
| `invoice_status_2` | `varchar2` | itgen_spe_invoice_status_2 | [ ] |  |  |
| `invoice_subject` | `varchar2` | Betreff der Rechnung | [ ] |  |  |
| `invoice_subscription_cycle_end_date` | `varchar2` | itgen_spe_invoice_subscription_cycle_end_date | [ ] |  |  |
| `invoice_subscription_cycle_is_invoiced` | `char` | itgen_spe_invoice_subscription_cycle_is_invoiced | [ ] |  |  |
| `invoice_subscription_cycle_start_date` | `varchar2` | itgen_spe_invoice_subscription_cycle_start_date | [ ] |  |  |
| `invoice_timeline_email_address` | `varchar2` | itgen_spe_invoice_timeline_email_address | [ ] |  |  |
| `invoice_total_excluding_vat` | `double` | itgen_spe_invoice_total_excluding_vat | [ ] |  |  |
| `invoice_total_including_vat` | `double` | itgen_spe_invoice_total_including_vat | [ ] |  |  |
| `invoice_total_outstanding` | `double` | itgen_spe_invoice_total_outstanding | [ ] |  |  |
| `invoice_total_vat` | `double` | itgen_spe_invoice_total_vat | [ ] |  |  |
| `invoice_updated_at` | `varchar2` | itgen_spe_invoice_updated_at | [ ] |  |  |
| `is_billable` | `char` | Ist abrechnungsfähig | [ ] |  |  |
| `note` | `varchar2` | Note | [ ] |  |  |
| `project_has_register_mileage_enabled` | `char` | itgen_spe_project_has_register_mileage_enabled | [ ] |  |  |
| `project_id` | `varchar2` | Projekt ID | [ ] |  |  |
| `project_name` | `varchar2` | Projektname | [ ] |  |  |
| `project_organization_id` | `varchar2` | Projekt-Organisations-ID | [ ] |  |  |
| `project_organization_name` | `varchar2` | Name der Projektorganisation | [ ] |  |  |
| `project_organization_relation_number` | `varchar2` | itgen_spe_project_organization_relation_number | [ ] |  |  |
| `project_person_full_name` | `varchar2` | Vollständiger Name der Projektverantwortlichen | [ ] |  |  |
| `project_person_id` | `varchar2` | Projekt-Person-ID | [ ] |  |  |
| `project_person_relation_number` | `varchar2` | itgen_spe_project_person_relation_number | [ ] |  |  |
| `project_project_manager_amount` | `double` | Projektleiter Betrag | [ ] |  |  |
| `project_project_manager_declarable` | `varchar2` | Projektmanager (selbstständig) | [ ] |  |  |
| `project_project_manager_employee_id` | `varchar2` | Projektmanager-Mitarbeiter-ID | [ ] |  |  |
| `project_project_manager_id` | `varchar2` | Projektmanager-ID | [ ] |  |  |
| `project_project_manager_name` | `varchar2` | Name des Projektleiters | [ ] |  |  |
| `project_project_manager_person_id` | `varchar2` | Projektmanager-ID | [ ] |  | Hinzugefügt, um der ursprünglichen sales/sales responsible_employee-Antwort zu entsprechen |
| `project_project_manager_tariff` | `double` | Projektmanager Tarife | [ ] |  |  |
| `project_project_number` | `varchar2` | Projektnummer | [ ] |  |  |
| `purchase_margin` | `double` | Einkaufsspanne | [ ] |  |  |
| `purchase_price_total` | `double` | Gesamtkaufpreis | [ ] |  |  |
| `purchase_price_unit` | `double` | Einkaufspreis pro Einheit | [ ] |  |  |
| `service_id` | `varchar2` | Service-ID | [ ] |  |  |
| `service_purchase_end_date` | `varchar2` | itgen_spe_service_purchase_end_date | [ ] |  |  |
| `service_purchase_start_date` | `varchar2` | itgen_spe_service_purchase_start_date | [ ] |  |  |
| `tariff` | `double` | Tariff | [ ] |  |  |
| `total_price` | `double` | Gesamtpreis | [ ] |  |  |


## Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert:

- [Simplicate](/de/release-notes/drivers?driver=simplicate)
