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

# InvoiceProjects: Simplicate Invoice Projects

`read only` `REST`

- Catalog: `Simplicate`
- Schema: `Invoices`
- Label: Invoice Projects

Fetches all invoices

Can only retrieve data.

## API Source

- Endpoint: `/invoices/invoice`
- Operation: `get /invoices/invoice`

## Table Columns

The columns of the table `InvoiceProjects` 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 |
|---|---|---|:---:|---|---|
| `comments` | `varchar2` | Comments | [ ] |  |  |
| `composition_type` | `varchar2` | Composition Type | [ ] |  |  |
| `contact_id` | `varchar2` | Contact ID | [ ] |  |  |
| `created` | `varchar2` | Created | [ ] |  |  |
| `created_at` | `varchar2` | Created at | [ ] |  |  |
| `date` | `varchar2` | Date | [ ] |  |  |
| `has_register_mileage_enabled` | `char` | itgen_spe_has_register_mileage_enabled | [ ] |  |  |
| `id` | `varchar2` | ID | [ ] |  |  |
| `id_2` | `varchar2` | itgen_spe_id_2 | [ ] |  |  |
| `invoice_number` | `varchar2` | Invoice Number | [ ] |  |  |
| `my_organization_profile_id` | `varchar2` | My Organisation Profile ID | [ ] |  |  |
| `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 | [ ] |  |  |
| `name` | `varchar2` | Name | [ ] |  |  |
| `organization_id` | `varchar2` | Organisation ID | [ ] |  |  |
| `organization_id_2` | `varchar2` | itgen_spe_organization_id_2 | [ ] |  |  |
| `organization_id_3` | `varchar2` | itgen_spe_organization_id_3 | [ ] |  |  |
| `organization_name` | `varchar2` | Organisation Name | [ ] |  |  |
| `organization_name_2` | `varchar2` | itgen_spe_organization_name_2 | [ ] |  |  |
| `organization_relation_number` | `varchar2` | itgen_spe_organization_relation_number | [ ] |  |  |
| `organization_relation_number_2` | `varchar2` | itgen_spe_organization_relation_number_2 | [ ] |  |  |
| `payment_term_days` | `int64` | Payment Term Days | [ ] |  |  |
| `payment_term_id` | `varchar2` | Payment Term ID | [ ] |  |  |
| `payment_term_method` | `varchar2` | Payment Term Method | [ ] |  |  |
| `payment_term_name` | `varchar2` | Payment Term Name | [ ] |  |  |
| `person_full_name` | `varchar2` | Person Full Name | [ ] |  |  |
| `person_full_name_2` | `varchar2` | itgen_spe_person_full_name_2 | [ ] |  |  |
| `person_id` | `varchar2` | Person ID | [ ] |  |  |
| `person_id_2` | `varchar2` | itgen_spe_person_id_2 | [ ] |  |  |
| `person_id_3` | `varchar2` | itgen_spe_person_id_3 | [ ] |  |  |
| `person_relation_number` | `varchar2` | itgen_spe_person_relation_number | [ ] |  |  |
| `person_relation_number_2` | `varchar2` | itgen_spe_person_relation_number_2 | [ ] |  |  |
| `project_has_register_mileage_enabled` | `char` | itgen_spe_project_has_register_mileage_enabled | [ ] |  |  |
| `project_id` | `varchar2` | Project ID | [ ] |  |  |
| `project_id_2` | `varchar2` | itgen_spe_project_id_2 | [ ] |  |  |
| `project_manager_amount` | `double` | itgen_spe_project_manager_amount | [ ] |  |  |
| `project_manager_declarable` | `varchar2` | itgen_spe_project_manager_declarable | [ ] |  |  |
| `project_manager_employee_id` | `varchar2` | itgen_spe_project_manager_employee_id | [ ] |  |  |
| `project_manager_id` | `varchar2` | itgen_spe_project_manager_id | [ ] |  |  |
| `project_manager_name` | `varchar2` | itgen_spe_project_manager_name | [ ] |  |  |
| `project_manager_person_id` | `varchar2` | itgen_spe_project_manager_person_id | [ ] |  | Added in order to comply with the original sales/sales responsible_employee response |
| `project_manager_tariff` | `double` | itgen_spe_project_manager_tariff | [ ] |  |  |
| `project_name` | `varchar2` | Project Name | [ ] |  |  |
| `project_number` | `varchar2` | Project Number | [ ] |  |  |
| `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 | [ ] |  |  |
| `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` | Sending Method | [ ] |  |  |
| `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` | Timeline Email Address | [ ] |  |  |
| `total_excluding_vat` | `double` | Total excluding VAT | [ ] |  |  |
| `total_including_vat` | `double` | Total including VAT | [ ] |  |  |
| `total_outstanding` | `double` | Total Outstanding | [ ] |  |  |
| `total_vat` | `double` | Total VAT | [ ] |  |  |
| `updated_at` | `varchar2` | Updated at | [ ] |  |  |



## Release Notes

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

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

