---
title: "CostExpenseAttachments (Simplicate)"
description: "itgen_spe_costexpenseattachments_plural"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.Costs.CostExpenseAttachments
original: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.Costs.CostExpenseAttachments
updated: 2024-10-18T06:48:11Z
license: https://documentation.invantive.eu/en/
---

# CostExpenseAttachments: Simplicate itgen_spe_costexpenseattachments_plural

`read only` `REST`

- Catalog: `Simplicate`
- Schema: `Costs`
- Label: itgen_spe_costexpenseattachments_plural

Fetches the expenses of employees

Can only retrieve data.

## API Source

- Endpoint: `/costs/expense`
- Operation: `get /costs/expense`

## Table Columns

The columns of the table `CostExpenseAttachments` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `amount` | `double` | Amount | [ ] |  |  |
| `approval_status_description` | `varchar2` | Approval Status Description | [ ] |  |  |
| `approval_status_label` | `varchar2` | Approval Status Label | [ ] |  |  |
| `costtype_budgeted_amount` | `double` | Cost Type Budgeted Amount | [ ] |  |  |
| `costtype_costtype_blocked` | `char` | Cost Type Blocked | [ ] |  |  |
| `costtype_costtype_id` | `varchar2` | Cost Type 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` | Cost Type ID | [ ] |  |  |
| `costtype_label` | `varchar2` | Cost Type Label | [ ] |  |  |
| `costtype_purchase_margin` | `double` | Cost Type Purchase Margin | [ ] |  |  |
| `costtype_purchase_tariff` | `double` | Cost Type Purchase Tariff | [ ] |  |  |
| `costtype_tariff` | `double` | Cost Type Tariff | [ ] |  |  |
| `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` | Employee Amount | [ ] |  |  |
| `employee_declarable` | `varchar2` | Employee Declarable | [ ] |  |  |
| `employee_employee_id` | `varchar2` | Employee ID | [ ] |  |  |
| `employee_id` | `varchar2` | Employee ID | [ ] |  |  |
| `employee_name` | `varchar2` | Employee Name | [ ] |  |  |
| `employee_person_id` | `varchar2` | Employee Person ID | [ ] |  | Added in order to comply with the original sales/sales responsible_employee response |
| `employee_tariff` | `double` | Employee Tariff | [ ] |  |  |
| `file_hash` | `varchar2` | itgen_spe_file_hash | [ ] |  |  |
| `file_name` | `varchar2` | itgen_spe_file_name | [ ] |  |  |
| `id` | `varchar2` | ID | [ ] |  |  |
| `invoice_comments` | `varchar2` | Invoice Comments | [ ] |  |  |
| `invoice_composition_type` | `varchar2` | Invoice Composition Type | [ ] |  |  |
| `invoice_contact_id` | `varchar2` | Invoice Contact ID | [ ] |  |  |
| `invoice_created` | `varchar2` | Invoice Created | [ ] |  |  |
| `invoice_created_at` | `varchar2` | Invoice Created at | [ ] |  |  |
| `invoice_date` | `varchar2` | Invoice Date | [ ] |  |  |
| `invoice_id` | `varchar2` | Invoice ID | [ ] |  |  |
| `invoice_invoice_number` | `varchar2` | Invoice Number | [ ] |  |  |
| `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 | [ ] |  | Added in order to comply with the original sales/sales responsible_employee response |
| `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` | Invoice Reference | [ ] |  |  |
| `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` | Invoice Status | [ ] |  |  |
| `invoice_status_2` | `varchar2` | itgen_spe_invoice_status_2 | [ ] |  |  |
| `invoice_subject` | `varchar2` | Invoice Subject | [ ] |  |  |
| `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` | Is Billable | [ ] |  |  |
| `note` | `varchar2` | Note | [ ] |  |  |
| `project_has_register_mileage_enabled` | `char` | itgen_spe_project_has_register_mileage_enabled | [ ] |  |  |
| `project_id` | `varchar2` | Project ID | [ ] |  |  |
| `project_name` | `varchar2` | Project Name | [ ] |  |  |
| `project_organization_id` | `varchar2` | Project Organisation ID | [ ] |  |  |
| `project_organization_name` | `varchar2` | Project Organisation Name | [ ] |  |  |
| `project_organization_relation_number` | `varchar2` | itgen_spe_project_organization_relation_number | [ ] |  |  |
| `project_person_full_name` | `varchar2` | Project Person Full Name | [ ] |  |  |
| `project_person_id` | `varchar2` | Project Person ID | [ ] |  |  |
| `project_person_relation_number` | `varchar2` | itgen_spe_project_person_relation_number | [ ] |  |  |
| `project_project_manager_amount` | `double` | Project Manager Amount | [ ] |  |  |
| `project_project_manager_declarable` | `varchar2` | Project Manager Declarable | [ ] |  |  |
| `project_project_manager_employee_id` | `varchar2` | Project Manager Employee ID | [ ] |  |  |
| `project_project_manager_id` | `varchar2` | Project Manager ID | [ ] |  |  |
| `project_project_manager_name` | `varchar2` | Project Manager Name | [ ] |  |  |
| `project_project_manager_person_id` | `varchar2` | Project Manager Person ID | [ ] |  | Added in order to comply with the original sales/sales responsible_employee response |
| `project_project_manager_tariff` | `double` | Project Manager Tariff | [ ] |  |  |
| `project_project_number` | `varchar2` | Project Number | [ ] |  |  |
| `purchase_margin` | `double` | Purchase Margin | [ ] |  |  |
| `purchase_price_total` | `double` | Purchase Price Total | [ ] |  |  |
| `purchase_price_unit` | `double` | Purchase Unit Price | [ ] |  |  |
| `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` | Total Price | [ ] |  |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

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

