---
title: "Invoices (Simplicate)"
description: "Invoices"
language: es
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/es/datamodels/simplicate/Simplicate.Invoices.Invoices
original: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.Invoices.Invoices
updated: 2026-11-18T23:54:03Z
license: https://documentation.invantive.eu/es/
---

# Facturas: Facturas de Simplicate

`insert` `update` `delete` `REST`

- Catálogo: `Simplicate`
- Esquema: `Invoices`
- Llaves Primarias: `id`
- Etiqueta: Facturas

Obtiene todas las facturas

Permite recuperar y modificar datos utilizando `insert`, `update` y `delete`.

## Fuente de la API

- Punto final: `/invoices/invoice`
- Operación: `get /invoices/invoice`

## Columnas de la Tabla

A continuación se muestran las columnas de la tabla `Invoices`. 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 |
|---|---|---|:---:|---|---|
| `comments` | `varchar2` | Comments | [ ] |  |  |
| `composition_type` | `varchar2` | Tipo de composición | [ ] |  |  |
| `contact_id` | `varchar2` | ID de contacto | [ ] |  |  |
| `created` | `varchar2` | Created | [ ] |  |  |
| `created_at` | `varchar2` | Creado en | [ ] |  |  |
| `date` | `varchar2` | Date | [ ] |  |  |
| `id` | `varchar2` | ID | [ ] |  |  |
| `invoice_number` | `varchar2` | Número de factura | [ ] |  |  |
| `my_organization_profile_id` | `varchar2` | ID de perfil de mi organización | [ ] |  |  |
| `my_organization_profile_id_2` | `varchar2` | itgen_spe_my_organization_profile_id_2 | [ ] |  |  |
| `my_organization_profile_organization_id` | `varchar2` | itgen_spe_my_organization_profile_organization_id | [ ] |  |  |
| `my_organization_profile_organization_name` | `varchar2` | itgen_spe_my_organization_profile_organization_name | [ ] |  |  |
| `my_organization_profile_organization_relation_number` | `varchar2` | itgen_spe_my_organization_profile_organization_relation_number | [ ] |  |  |
| `organization_id` | `varchar2` | ID de la Organización | [ ] |  |  |
| `organization_id_2` | `varchar2` | itgen_spe_organization_id_2 | [ ] |  |  |
| `organization_name` | `varchar2` | Nombre de Organización | [ ] |  |  |
| `organization_relation_number` | `varchar2` | itgen_spe_organization_relation_number | [ ] |  |  |
| `payment_term_days` | `int64` | Días de plazo de pago | [ ] |  |  |
| `payment_term_id` | `varchar2` | ID del plazo de pago | [ ] |  |  |
| `payment_term_method` | `varchar2` | Método de plazo de pago | [ ] |  |  |
| `payment_term_name` | `varchar2` | Nombre del plazo de pago | [ ] |  |  |
| `person_full_name` | `varchar2` | Nombre completo de la persona | [ ] |  |  |
| `person_id` | `varchar2` | Identificación de la Persona | [ ] |  |  |
| `person_id_2` | `varchar2` | itgen_spe_person_id_2 | [ ] |  |  |
| `person_relation_number` | `varchar2` | itgen_spe_person_relation_number | [ ] |  |  |
| `project_has_register_mileage_enabled` | `char` | itgen_spe_project_has_register_mileage_enabled | [ ] |  |  |
| `project_id` | `varchar2` | Identificación del Proyecto | [ ] |  |  |
| `project_id_2` | `varchar2` | itgen_spe_project_id_2 | [ ] |  |  |
| `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 | [ ] |  |  |
| `reference` | `varchar2` | Reference | [ ] |  |  |
| `reminder_next_action` | `varchar2` | itgen_spe_reminder_next_action | [ ] |  |  |
| `reminder_paused` | `char` | itgen_spe_reminder_paused | [ ] |  |  |
| `reminder_set_disabled` | `char` | itgen_spe_reminder_set_disabled | [ ] |  |  |
| `reminder_set_label` | `varchar2` | itgen_spe_reminder_set_label | [ ] |  |  |
| `reminder_status` | `varchar2` | itgen_spe_reminder_status | [ ] |  |  |
| `sending_method` | `varchar2` | Método de envío | [ ] |  |  |
| `simplicate_url` | `varchar2` | Simplicate URL | [ ] |  |  |
| `status` | `varchar2` | Status | [ ] |  |  |
| `subject` | `varchar2` | Subject | [ ] |  |  |
| `subscription_cycle_end_date` | `varchar2` | itgen_spe_subscription_cycle_end_date | [ ] |  |  |
| `subscription_cycle_is_invoiced` | `char` | itgen_spe_subscription_cycle_is_invoiced | [ ] |  |  |
| `subscription_cycle_start_date` | `varchar2` | itgen_spe_subscription_cycle_start_date | [ ] |  |  |
| `timeline_email_address` | `varchar2` | Dirección de correo electrónico de Timeline | [ ] |  |  |
| `total_excluding_vat` | `double` | Total excluyendo VAT | [ ] |  |  |
| `total_including_vat` | `double` | Total con IVA | [ ] |  |  |
| `total_outstanding` | `double` | Total sobresaliente | [ ] |  |  |
| `total_vat` | `double` | IVA total | [ ] |  |  |
| `updated_at` | `varchar2` | Actualizado en | [ ] |  |  |


## 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)
