---
title: "HoursEmployeeexpense (Simplicate)"
description: "itgen_spe_hoursemployeeexpense_plural"
language: es
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/es/datamodels/simplicate/Simplicate.Hours.HoursEmployeeexpense
original: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.Hours.HoursEmployeeexpense
updated: 2026-11-18T23:53:51Z
license: https://documentation.invantive.eu/es/
---

# HoursEmployeeexpense: Simplicate itgen_spe_hoursemployeeexpense_plural

`read only` `REST`

- Catálogo: `Simplicate`
- Esquema: `Hours`
- Etiqueta: itgen_spe_hoursemployeeexpense_plural

Obtiene los gastos de los empleados

Solo puede recuperar datos.

## Fuente de la API

- Punto final: `/hours/employeeexpense`
- Operación: `get /hours/employeeexpense`

## Columnas de la Tabla

A continuación se muestran las columnas de la tabla `HoursEmployeeexpense`. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `amount` | `double` | Amount | [ ] |  |  |
| `approval_status_description` | `varchar2` | Descripción del Estado de Aprobación | [ ] |  |  |
| `approval_status_label` | `varchar2` | Etiqueta de estado de aprobación | [ ] |  |  |
| `costtype_budgeted_amount` | `double` | Tipo de costo Importe presupuestado | [ ] |  |  |
| `costtype_costtype_blocked` | `char` | Tipo de costo bloqueado | [ ] |  |  |
| `costtype_costtype_id` | `varchar2` | ID del tipo de coste | [ ] |  |  |
| `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` | ID del tipo de coste | [ ] |  |  |
| `costtype_label` | `varchar2` | Etiqueta de tipo de costo | [ ] |  |  |
| `costtype_purchase_margin` | `double` | Tipo de costo Margen de compra | [ ] |  |  |
| `costtype_purchase_tariff` | `double` | Tipo de costo Tarifa de compra | [ ] |  |  |
| `costtype_tariff` | `double` | Tarifa de tipo de costo | [ ] |  |  |
| `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` | Monto del empleado | [ ] |  |  |
| `employee_declarable` | `varchar2` | Empleado declarable | [ ] |  |  |
| `employee_employee_id` | `varchar2` | Identificación del Empleado | [ ] |  |  |
| `employee_id` | `varchar2` | Identificación del Empleado | [ ] |  |  |
| `employee_name` | `varchar2` | Nombre del empleado | [ ] |  |  |
| `employee_person_id` | `varchar2` | ID de persona del empleado | [ ] |  | Añadido para cumplir con la respuesta original de ventas/ventas responsible_employee |
| `employee_tariff` | `double` | Tarifa para empleados | [ ] |  |  |
| `id` | `varchar2` | ID | [ ] |  |  |
| `invoice_comments` | `varchar2` | Comentarios sobre la factura | [ ] |  |  |
| `invoice_composition_type` | `varchar2` | Tipo de composición de factura | [ ] |  |  |
| `invoice_contact_id` | `varchar2` | ID de contacto de la factura | [ ] |  |  |
| `invoice_created` | `varchar2` | Factura creada | [ ] |  |  |
| `invoice_created_at` | `varchar2` | Factura creada en | [ ] |  |  |
| `invoice_date` | `varchar2` | Fecha de la Factura | [ ] |  |  |
| `invoice_id` | `varchar2` | ID de la Factura | [ ] |  |  |
| `invoice_invoice_number` | `varchar2` | Número de factura | [ ] |  |  |
| `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 | [ ] |  | Añadido para cumplir con la respuesta original de ventas/ventas responsible_employee |
| `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` | Referencia de factura | [ ] |  |  |
| `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` | Estatus de la Factura | [ ] |  |  |
| `invoice_status_2` | `varchar2` | itgen_spe_invoice_status_2 | [ ] |  |  |
| `invoice_subject` | `varchar2` | Asunto de la factura | [ ] |  |  |
| `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` | Es facturable | [ ] |  |  |
| `note` | `varchar2` | Note | [ ] |  |  |
| `project_has_register_mileage_enabled` | `char` | itgen_spe_project_has_register_mileage_enabled | [ ] |  |  |
| `project_id` | `varchar2` | Identificación del Proyecto | [ ] |  |  |
| `project_name` | `varchar2` | Nombre del Proyecto | [ ] |  |  |
| `project_organization_id` | `varchar2` | ID de organización del proyecto | [ ] |  |  |
| `project_organization_name` | `varchar2` | Nombre de la organización del proyecto | [ ] |  |  |
| `project_organization_relation_number` | `varchar2` | itgen_spe_project_organization_relation_number | [ ] |  |  |
| `project_person_full_name` | `varchar2` | Nombre completo de la persona del proyecto | [ ] |  |  |
| `project_person_id` | `varchar2` | ID de persona del proyecto | [ ] |  |  |
| `project_person_relation_number` | `varchar2` | itgen_spe_project_person_relation_number | [ ] |  |  |
| `project_project_manager_amount` | `double` | Monto del gerente de proyecto | [ ] |  |  |
| `project_project_manager_declarable` | `varchar2` | Gestor de proyectos declarable | [ ] |  |  |
| `project_project_manager_employee_id` | `varchar2` | ID de empleado del gerente de proyecto | [ ] |  |  |
| `project_project_manager_id` | `varchar2` | ID de gerente de proyecto | [ ] |  |  |
| `project_project_manager_name` | `varchar2` | Nombre del Administrador del Proyecto | [ ] |  |  |
| `project_project_manager_person_id` | `varchar2` | ID de persona del gerente del proyecto | [ ] |  | Añadido para cumplir con la respuesta original de ventas/ventas responsible_employee |
| `project_project_manager_tariff` | `double` | Tarifa de gerente de proyecto | [ ] |  |  |
| `project_project_number` | `varchar2` | Número de proyecto | [ ] |  |  |
| `purchase_margin` | `double` | Margen de compra | [ ] |  |  |
| `purchase_price_total` | `double` | Precio total de compra | [ ] |  |  |
| `purchase_price_unit` | `double` | Precio unitario de compra | [ ] |  |  |
| `service_id` | `varchar2` | ID de servicio | [ ] |  |  |
| `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` | Precio Total | [ ] |  |  |


## Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador:

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