OrganizationCustomFieldOptions : Simplicate itgen_spe_organizationcustomfieldoptions_plural
read only REST
- Catalogue :
Simplicate - Schéma :
CRM - Étiquette : itgen_spe_organizationcustomfieldoptions_plural
Récupère toutes les organisations
Permet uniquement de récupérer des données.
Source de l'API
- Point de terminaison :
/crm/organization - Opération :
get /crm/organization
Colonnes de table
Les colonnes de la table OrganizationCustomFieldOptions 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 |
|---|---|---|---|---|---|
accountancy_ |
char |
Comptabilité - Service fiscal : TVA | |||
accountancy_ |
char |
Comptabilité - Service fiscal VPB | |||
accountancy_ |
varchar2 |
Comptabilité - Rôle du service fiscal en matière de TVA | |||
accountancy_ |
varchar2 |
Comptabilité - Rôle de responsable du service fiscal au sein de VPB | |||
accountancy_ |
varchar2 |
Comptabilité - Numéro de TVA - Entité fiscale | |||
allow_ |
char |
Prélèvement automatique | |||
bank_ |
varchar2 |
Compte bancaire | |||
bank_ |
varchar2 |
BIC bancaire | |||
coc_ |
varchar2 |
Code CoC | |||
created |
varchar2 |
Created | |||
created_ |
varchar2 |
Créé le | |||
custom_ |
varchar2 |
ID du groupe de champs personnalisés | |||
custom_ |
varchar2 |
ID du modèle de groupe de champs personnalisés | |||
custom_ |
varchar2 |
Libellé du modèle de groupe de champs personnalisés | |||
custom_ |
varchar2 |
Nom du groupe de champs personnalisés | |||
custom_ |
varchar2 |
Position du groupe de champs personnalisés | |||
custom_ |
varchar2 |
Type de groupe de champs personnalisés | |||
customer_ |
varchar2 |
itgen_spe_customer_group_id | |||
customer_ |
varchar2 |
itgen_spe_customer_group_name | |||
debtor_ |
varchar2 |
À l'attention du débiteur | |||
debtor_ |
varchar2 |
À l'attention du débiteur (fixe) | |||
debtor_ |
varchar2 |
Attention du débiteur concernant l'identifiant de la personne | Voir /crm/person | ||
debtor_ |
char |
Recouvrement automatique des créances | |||
debtor_ |
char |
itgen_spe_debtor_autosend_subscription_invoice | |||
debtor_ |
varchar2 |
Référence du modèle de facture client | |||
debtor_ |
int64 |
Délai de paiement du débiteur (jours) | |||
debtor_ |
varchar2 |
Référence du délai de paiement du débiteur | |||
debtor_ |
varchar2 |
Méthode de calcul des délais de paiement des débiteurs | |||
debtor_ |
varchar2 |
Nom du délai de paiement du débiteur | |||
debtor_ |
varchar2 |
itgen_spe_debtor_provision_contactperson_id | Voir /crm/person | ||
debtor_ |
varchar2 |
Méthode de provisionnement | |||
debtor_ |
char |
Reminders | |||
debtor_ |
varchar2 |
Envoyer email | |||
debtor_ |
varchar2 |
Type d'e-mail à envoyer | |||
debtor_ |
char |
itgen_spe_debtor_send_invoice_email_to_cc | |||
debtor_ |
char |
itgen_spe_debtor_send_invoice_email_to_contact | |||
debtor_ |
char |
itgen_spe_debtor_send_invoice_email_to_fixed_email | |||
debtor_ |
char |
itgen_spe_debtor_send_invoice_email_to_project_contact | |||
email |
varchar2 |
||||
filterable |
char |
Filterable | |||
has_ |
char |
Autre adresse postale | |||
id |
varchar2 |
ID | |||
id_2 |
varchar2 |
itgen_spe_id_2 | |||
id_3 |
varchar2 |
itgen_spe_id_3 | |||
industry_ |
varchar2 |
Code sectoriel | |||
industry_ |
varchar2 |
Nom de l'industrie | |||
invoice_ |
varchar2 |
Destinataire de la facture | |||
is_ |
char |
itgen_spe_is_active | |||
label |
varchar2 |
Label | |||
label_ |
varchar2 |
itgen_spe_label_2 | |||
linkedin_ |
varchar2 |
URL LinkedIn | |||
mandatory |
char |
itgen_spe_mandatory | |||
modified |
varchar2 |
Modified | |||
name |
varchar2 |
Name | |||
name_2 |
varchar2 |
itgen_spe_name_2 | |||
note |
varchar2 |
Note | |||
organizationsize_ |
varchar2 |
Taille de l'organisation - ID | |||
organizationsize_ |
varchar2 |
Taille de l'organisation Nom | |||
phone |
varchar2 |
Phone | |||
position |
int64 |
Position | |||
position_ |
int64 |
itgen_spe_position_2 | |||
postal_ |
varchar2 |
Adresse postale Pays | |||
postal_ |
varchar2 |
Code postal Code pays | |||
postal_ |
varchar2 |
Adresse postale Code pays | |||
postal_ |
varchar2 |
Identifiant d'adresse postale | |||
postal_ |
varchar2 |
Adresse postale – Ligne 1 | |||
postal_ |
varchar2 |
Adresse postale – Ligne 2 | |||
postal_ |
varchar2 |
Adresse postale : Localité | |||
postal_ |
varchar2 |
Adresse postale Code postal | |||
postal_ |
varchar2 |
Adresse postale Province | |||
postal_ |
varchar2 |
Type d'adresse postale | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_avatar_color | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_avatar_initials | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_avatar_url_large | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_avatar_url_small | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_bank_account | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_civil_status | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_created | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_created_at | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_employment_status | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_function | |||
relation_ |
double |
itgen_spe_relation_manager_hourly_cost_tariff | |||
relation_ |
double |
itgen_spe_relation_manager_hourly_sales_tariff | |||
relation_ |
varchar2 |
Identifiant du chargé de relations clients | |||
relation_ |
char |
itgen_spe_relation_manager_is_user | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_marital_status | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_modified | |||
relation_ |
varchar2 |
Nom du chargé de relations clients | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_address_country | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_address_country_code | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_address_country_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_address_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_address_line_1 | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_address_line_2 | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_address_locality | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_address_postal_code | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_address_province | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_address_type | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_avatar_color | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_avatar_initials | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_avatar_url_large | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_avatar_url_small | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_bank_account | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_bank_bic | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_created_at | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_custom_salutation | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_date_of_birth | |||
relation_ |
varchar2 |
E-mail du responsable de la relation client | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_facebook_url | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_family_name | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_family_name_prefix | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_first_name | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_full_name | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_gender | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_gender_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_id_2 | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_initials | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_invoice_receiver | |||
relation_ |
char |
itgen_spe_relation_manager_person_is_active | |||
relation_ |
int64 |
itgen_spe_relation_manager_person_is_employee | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_linkedin_url | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_mailing_list_email | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_note | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_phone | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_avatar_color | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_avatar_initials | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_avatar_url_large | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_avatar_url_small | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_bank_account | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_civil_status | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_created | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_created_at | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_employment_status | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_function | |||
relation_ |
double |
itgen_spe_relation_manager_person_relation_manager_hourly_cost_tariff | |||
relation_ |
double |
itgen_spe_relation_manager_person_relation_manager_hourly_sales_tariff | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_id | |||
relation_ |
char |
itgen_spe_relation_manager_person_relation_manager_is_user | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_marital_status | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_modified | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_name | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_address_country | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_address_country_code | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_address_country_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_address_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_address_line_1 | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_address_line_2 | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_address_locality | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_address_postal_code | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_address_province | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_address_type | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_avatar_color | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_avatar_initials | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_avatar_url_large | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_avatar_url_small | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_bank_account | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_bank_bic | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_created_at | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_custom_salutation | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_date_of_birth | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_email | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_facebook_url | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_family_name | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_family_name_prefix | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_first_name | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_full_name | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_gender | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_gender_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_id_2 | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_initials | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_invoice_receiver | |||
relation_ |
char |
itgen_spe_relation_manager_person_relation_manager_person_is_active | |||
relation_ |
int64 |
itgen_spe_relation_manager_person_relation_manager_person_is_employee | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_linkedin_url | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_mailing_list_email | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_note | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_phone | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_bank_account | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_civil_status | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_created | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_created_at | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_employment_status | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_function | |||
relation_ |
double |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_hourly_cost_tariff | |||
relation_ |
double |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_hourly_sales_tariff | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_id | |||
relation_ |
char |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_is_user | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_marital_status | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_modified | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_name | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_person_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_simplicate_url | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_social_security_number | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_timeline_email_address | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_updated_at | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_work_email | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_work_mobile | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_work_phone | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_number | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_type_color | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_type_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_type_label | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_type_type | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_simplicate_url | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_timeline_email_address | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_twitter_url | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_updated_at | |||
relation_ |
char |
itgen_spe_relation_manager_person_relation_manager_person_use_custom_salutation | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_website_url | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_simplicate_url | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_social_security_number | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_status_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_status_label | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_timeline_email_address | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_type_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_type_label | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_updated_at | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_work_email | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_work_mobile | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_work_phone | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_number | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_type_color | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_type_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_type_label | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_type_type | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_simplicate_url | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_timeline_email_address | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_twitter_url | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_updated_at | |||
relation_ |
char |
itgen_spe_relation_manager_person_use_custom_salutation | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_website_url | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_simplicate_url | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_social_security_number | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_status_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_status_label | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_timeline_email_address | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_type_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_type_label | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_updated_at | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_work_email | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_work_mobile | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_work_phone | |||
relation_ |
varchar2 |
Numéro de relation | |||
relation_ |
varchar2 |
Type de relation Couleur | |||
relation_ |
varchar2 |
ID du type de relation | |||
relation_ |
varchar2 |
Étiquette du type de relation | |||
relation_ |
varchar2 |
Type de relation | |||
render_ |
varchar2 |
Type de rendu | |||
searchable |
char |
Searchable | |||
simplicate_ |
varchar2 |
Simplicate URL | |||
timeline_ |
varchar2 |
Chronologie Adresse e-mail | |||
type |
varchar2 |
Type | |||
updated_ |
varchar2 |
Mise à jour à | |||
url |
varchar2 |
URL | |||
value |
varchar2 |
Value | |||
value_ |
varchar2 |
itgen_spe_value_2 | |||
value_ |
varchar2 |
Type valeur | |||
vat_ |
varchar2 |
Numéro de TVA | |||
visiting_ |
varchar2 |
Adresse de visite Pays | |||
visiting_ |
varchar2 |
Adresse de visite Code pays | |||
visiting_ |
varchar2 |
Adresse de visite Code pays | |||
visiting_ |
varchar2 |
Identifiant de l'adresse de visite | |||
visiting_ |
varchar2 |
Adresse de visite – Ligne 1 de l'adresse | |||
visiting_ |
varchar2 |
Adresse de visite – Ligne 2 de l'adresse | |||
visiting_ |
varchar2 |
Adresse de visite Localité | |||
visiting_ |
varchar2 |
Adresse de visite Code postal | |||
visiting_ |
varchar2 |
Adresse de visite Province | |||
visiting_ |
varchar2 |
Type d'adresse de visite |
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 :