---
title: "ProjectCustomFieldOptions (Simplicate)"
description: "itgen_spe_projectcustomfieldoptions_plural"
language: fr
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/fr/datamodels/simplicate/Simplicate.Projects.ProjectCustomFieldOptions
original: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.Projects.ProjectCustomFieldOptions
updated: 2026-11-18T23:54:06Z
license: https://documentation.invantive.eu/fr/
---

# ProjectCustomFieldOptions : Simplicate itgen_spe_projectcustomfieldoptions_plural

`read only` `REST`

- Catalogue : `Simplicate`
- Schéma : `Projects`
- Étiquette : itgen_spe_projectcustomfieldoptions_plural

Récupère tous les projets

Permet uniquement de récupérer des données.

## Source de l'API

- Point de terminaison : `/projects/project`
- Opération : `get /projects/project`

## Colonnes de table

Les colonnes de la table `ProjectCustomFieldOptions` sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `abnormal_address` | `char` | Adresse incorrecte | [ ] |  |  |
| `abnormal_contact_id` | `varchar2` | Identifiant de contact anormal | [ ] |  |  |
| `abnormal_organization_id` | `varchar2` | Identifiant d'organisation anormal | [ ] |  |  |
| `abnormal_person_id` | `varchar2` | Identifiant de personne anormale | [ ] |  |  |
| `billable` | `char` | Billable | [ ] |  |  |
| `budget_costs_value_budget` | `double` | itgen_spe_budget_costs_value_budget | [ ] |  |  |
| `budget_costs_value_spent` | `double` | itgen_spe_budget_costs_value_spent | [ ] |  |  |
| `budget_hours_amount_budget` | `double` | itgen_spe_budget_hours_amount_budget | [ ] |  |  |
| `budget_hours_amount_spent` | `double` | itgen_spe_budget_hours_amount_spent | [ ] |  |  |
| `budget_hours_value_budget` | `double` | itgen_spe_budget_hours_value_budget | [ ] |  |  |
| `budget_hours_value_spent` | `double` | itgen_spe_budget_hours_value_spent | [ ] |  |  |
| `budget_total_value_budget` | `double` | itgen_spe_budget_total_value_budget | [ ] |  |  |
| `budget_total_value_invoiced` | `double` | itgen_spe_budget_total_value_invoiced | [ ] |  |  |
| `budget_total_value_spent` | `double` | itgen_spe_budget_total_value_spent | [ ] |  |  |
| `can_register_mileage` | `char` | Possibilité d'enregistrer le kilométrage | [ ] |  |  |
| `contact_id` | `varchar2` | ID de contact | [ ] |  |  |
| `contact_id_2` | `varchar2` | itgen_spe_contact_id_2 | [ ] |  |  |
| `contact_organization_id` | `varchar2` | Identifiant de l'organisation de contact | [ ] |  |  |
| `contact_organization_name` | `varchar2` | Nom de l'organisme à contacter | [ ] |  |  |
| `contact_organization_relation_number` | `varchar2` | itgen_spe_contact_organization_relation_number | [ ] |  |  |
| `contact_person_full_name` | `varchar2` | Nom complet de la personne à contacter | [ ] |  |  |
| `contact_person_id` | `varchar2` | Identifiant de la personne à contacter | [ ] |  |  |
| `contact_person_relation_number` | `varchar2` | itgen_spe_contact_person_relation_number | [ ] |  |  |
| `copied_from_project_has_register_mileage_enabled` | `char` | itgen_spe_copied_from_project_has_register_mileage_enabled | [ ] |  |  |
| `copied_from_project_id` | `varchar2` | itgen_spe_copied_from_project_id | [ ] |  |  |
| `copied_from_project_name` | `varchar2` | itgen_spe_copied_from_project_name | [ ] |  |  |
| `copied_from_project_organization_id` | `varchar2` | itgen_spe_copied_from_project_organization_id | [ ] |  |  |
| `copied_from_project_organization_name` | `varchar2` | itgen_spe_copied_from_project_organization_name | [ ] |  |  |
| `copied_from_project_organization_relation_number` | `varchar2` | itgen_spe_copied_from_project_organization_relation_number | [ ] |  |  |
| `copied_from_project_person_full_name` | `varchar2` | itgen_spe_copied_from_project_person_full_name | [ ] |  |  |
| `copied_from_project_person_id` | `varchar2` | itgen_spe_copied_from_project_person_id | [ ] |  |  |
| `copied_from_project_person_relation_number` | `varchar2` | itgen_spe_copied_from_project_person_relation_number | [ ] |  |  |
| `copied_from_project_project_manager_amount` | `double` | itgen_spe_copied_from_project_project_manager_amount | [ ] |  |  |
| `copied_from_project_project_manager_declarable` | `varchar2` | itgen_spe_copied_from_project_project_manager_declarable | [ ] |  |  |
| `copied_from_project_project_manager_employee_id` | `varchar2` | itgen_spe_copied_from_project_project_manager_employee_id | [ ] |  |  |
| `copied_from_project_project_manager_id` | `varchar2` | itgen_spe_copied_from_project_project_manager_id | [ ] |  |  |
| `copied_from_project_project_manager_name` | `varchar2` | itgen_spe_copied_from_project_project_manager_name | [ ] |  |  |
| `copied_from_project_project_manager_person_id` | `varchar2` | itgen_spe_copied_from_project_project_manager_person_id | [ ] |  | Ajouté afin de respecter la réponse originale sales/sales responsible_employee |
| `copied_from_project_project_manager_tariff` | `double` | itgen_spe_copied_from_project_project_manager_tariff | [ ] |  |  |
| `copied_from_project_project_number` | `varchar2` | itgen_spe_copied_from_project_project_number | [ ] |  |  |
| `created` | `varchar2` | Created | [ ] |  |  |
| `created_at` | `varchar2` | Créé le | [ ] |  |  |
| `custom_field_group_id` | `varchar2` | ID du groupe de champs personnalisés | [ ] |  |  |
| `custom_field_group_model_id` | `varchar2` | ID du modèle de groupe de champs personnalisés | [ ] |  |  |
| `custom_field_group_model_label` | `varchar2` | Libellé du modèle de groupe de champs personnalisés | [ ] |  |  |
| `custom_field_group_name` | `varchar2` | Nom du groupe de champs personnalisés | [ ] |  |  |
| `custom_field_group_position` | `varchar2` | Position du groupe de champs personnalisés | [ ] |  |  |
| `custom_field_group_type` | `varchar2` | Type de groupe de champs personnalisés | [ ] |  |  |
| `divergent_payment_term_days` | `int64` | Délai de paiement différent (jours) | [ ] |  |  |
| `divergent_payment_term_id` | `varchar2` | Identifiant des conditions de paiement divergentes | [ ] |  |  |
| `divergent_payment_term_method` | `varchar2` | Méthode des conditions de paiement divergentes | [ ] |  |  |
| `divergent_payment_term_name` | `varchar2` | Nom de la condition de paiement divergente | [ ] |  |  |
| `end_date` | `varchar2` | Date de fin | [ ] |  |  |
| `filterable` | `char` | Filterable | [ ] |  |  |
| `hours_rate_type` | `varchar2` | Heures Taux Type | [ ] |  |  |
| `id` | `varchar2` | ID | [ ] |  |  |
| `id_2` | `varchar2` | itgen_spe_id_2 | [ ] |  |  |
| `id_3` | `varchar2` | itgen_spe_id_3 | [ ] |  |  |
| `invoice_reference` | `varchar2` | Référence de la facture | [ ] |  |  |
| `is_invoice_approval` | `char` | Approbation des factures | [ ] |  |  |
| `is_reverse_billing` | `char` | Qu'est-ce que la facturation inversée ? | [ ] |  |  |
| `label` | `varchar2` | Label | [ ] |  |  |
| `label_2` | `varchar2` | itgen_spe_label_2 | [ ] |  |  |
| `mandatory` | `char` | itgen_spe_mandatory | [ ] |  |  |
| `modified` | `varchar2` | Modified | [ ] |  |  |
| `my_organization_profile_id` | `varchar2` | Identifiant de profil de mon organisation | [ ] |  |  |
| `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 | [ ] |  |  |
| `name_2` | `varchar2` | itgen_spe_name_2 | [ ] |  |  |
| `note` | `varchar2` | Note | [ ] |  |  |
| `organization_id` | `varchar2` | ID de l'organisation | [ ] |  |  |
| `organization_id_2` | `varchar2` | itgen_spe_organization_id_2 | [ ] |  |  |
| `organization_name` | `varchar2` | Nom d'organisation | [ ] |  |  |
| `organization_relation_number` | `varchar2` | itgen_spe_organization_relation_number | [ ] |  |  |
| `person_full_name` | `varchar2` | Nom complet de la personne | [ ] |  |  |
| `person_id` | `varchar2` | Identifiant de la personne | [ ] |  |  |
| `person_id_2` | `varchar2` | itgen_spe_person_id_2 | [ ] |  |  |
| `person_relation_number` | `varchar2` | itgen_spe_person_relation_number | [ ] |  |  |
| `position` | `int64` | Position | [ ] |  |  |
| `position_2` | `int64` | itgen_spe_position_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 | [ ] |  | Ajouté afin de respecter la réponse originale sales/sales responsible_employee |
| `project_manager_tariff` | `double` | itgen_spe_project_manager_tariff | [ ] |  |  |
| `project_number` | `varchar2` | Numéro de Projet | [ ] |  |  |
| `project_status_color` | `varchar2` | Couleur indiquant l'état du projet | [ ] |  |  |
| `project_status_id` | `varchar2` | Identifiant de l'état du projet | [ ] |  |  |
| `project_status_label` | `varchar2` | Étiquette d'état du projet | [ ] |  |  |
| `render_type` | `varchar2` | Type de rendu | [ ] |  |  |
| `searchable` | `char` | Searchable | [ ] |  |  |
| `separate_invoice_recipient_contact_id` | `varchar2` | itgen_spe_separate_invoice_recipient_contact_id | [ ] |  |  |
| `separate_invoice_recipient_contact_organization_id` | `varchar2` | itgen_spe_separate_invoice_recipient_contact_organization_id | [ ] |  |  |
| `separate_invoice_recipient_contact_organization_name` | `varchar2` | itgen_spe_separate_invoice_recipient_contact_organization_name | [ ] |  |  |
| `separate_invoice_recipient_contact_organization_relation_number` | `varchar2` | itgen_spe_separate_invoice_recipient_contact_organization_relation_number | [ ] |  |  |
| `separate_invoice_recipient_contact_person_full_name` | `varchar2` | itgen_spe_separate_invoice_recipient_contact_person_full_name | [ ] |  |  |
| `separate_invoice_recipient_contact_person_id` | `varchar2` | itgen_spe_separate_invoice_recipient_contact_person_id | [ ] |  |  |
| `separate_invoice_recipient_contact_person_relation_number` | `varchar2` | itgen_spe_separate_invoice_recipient_contact_person_relation_number | [ ] |  |  |
| `separate_invoice_recipient_is_separate_invoice_recipient` | `char` | itgen_spe_separate_invoice_recipient_is_separate_invoice_recipient | [ ] |  |  |
| `separate_invoice_recipient_organization_id` | `varchar2` | itgen_spe_separate_invoice_recipient_organization_id | [ ] |  |  |
| `separate_invoice_recipient_organization_name` | `varchar2` | itgen_spe_separate_invoice_recipient_organization_name | [ ] |  |  |
| `separate_invoice_recipient_organization_relation_number` | `varchar2` | itgen_spe_separate_invoice_recipient_organization_relation_number | [ ] |  |  |
| `separate_invoice_recipient_person_full_name` | `varchar2` | itgen_spe_separate_invoice_recipient_person_full_name | [ ] |  |  |
| `separate_invoice_recipient_person_id` | `varchar2` | itgen_spe_separate_invoice_recipient_person_id | [ ] |  |  |
| `separate_invoice_recipient_person_relation_number` | `varchar2` | itgen_spe_separate_invoice_recipient_person_relation_number | [ ] |  |  |
| `simplicate_url` | `varchar2` | Simplicate URL | [ ] |  |  |
| `start_date` | `varchar2` | Date de début | [ ] |  |  |
| `timeline_email_address` | `varchar2` | Chronologie Adresse e-mail | [ ] |  |  |
| `type` | `varchar2` | Type | [ ] |  |  |
| `updated_at` | `varchar2` | Mise à jour à | [ ] |  |  |
| `value` | `varchar2` | Value | [ ] |  |  |
| `value_2` | `varchar2` | itgen_spe_value_2 | [ ] |  |  |
| `value_type` | `varchar2` | Type valeur | [ ] |  |  |


## Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :

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