OrganizationById: Simplicate Organizzazione per ID
read only REST
- Catalogo:
Simplicate - Schema:
CRM - Etichetta: Organizzazione per ID
Recupera una singola organizzazione tramite ID
È possibile solo recuperare i dati.
Codice sorgente dell'API
- Punto finale:
/crm/organization/{id} - Operazione:
get /crm/organization/{id}
Parametri
| Name | Tipo di dati | Required | Default | Documentation |
|---|---|---|---|---|
id |
`` | L'ID del modello |
Colonne della tabella
Di seguito sono riportate le colonne della tabella OrganizationById. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
accountancy_ |
char |
Contabilità - L'IVA è l'unità fiscale | |||
accountancy_ |
char |
Contabilità - L'unità fiscale è VPB | |||
accountancy_ |
varchar2 |
Contabilità - Ruolo IVA dell'unità fiscale | |||
accountancy_ |
varchar2 |
Contabilità - È il ruolo VPB dell'unità fiscale | |||
accountancy_ |
varchar2 |
Contabilità - Partita IVA Unità fiscale | |||
allow_ |
char |
Raccolta automatica | |||
bank_ |
varchar2 |
Conto bancario | |||
bank_ |
varchar2 |
Banca BIC | |||
coc_ |
varchar2 |
Codice CoC | |||
created |
varchar2 |
Created | |||
created_ |
varchar2 |
Creato il | |||
customer_ |
varchar2 |
itgen_spe_customer_group_id | |||
customer_ |
varchar2 |
itgen_spe_customer_group_name | |||
debtor_ |
varchar2 |
Attenzione del debitore a | |||
debtor_ |
varchar2 |
Attenzione del debitore a (fissa) | |||
debtor_ |
varchar2 |
Attenzione del debitore all'ID della persona | Vedi /crm/person | ||
debtor_ |
char |
Raccolta automatica del debitore | |||
debtor_ |
char |
itgen_spe_debtor_autosend_subscription_invoice | |||
debtor_ |
varchar2 |
ID del modello di fattura del debitore | |||
debtor_ |
int64 |
Termine di pagamento del debitore (giorni) | |||
debtor_ |
varchar2 |
ID del termine di pagamento del debitore | |||
debtor_ |
varchar2 |
Metodo del termine di pagamento del debitore | |||
debtor_ |
varchar2 |
Nome del termine di pagamento del debitore | |||
debtor_ |
varchar2 |
itgen_spe_debtor_provision_contactperson_id | Vedi /crm/person | ||
debtor_ |
varchar2 |
Metodo di erogazione | |||
debtor_ |
char |
Reminders | |||
debtor_ |
varchar2 |
Invia e-mail | |||
debtor_ |
varchar2 |
Tipo di invio e-mail | |||
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 |
||||
has_ |
char |
Indirizzo postale diverso | |||
id |
varchar2 |
ID | |||
industry_ |
varchar2 |
ID del settore | |||
industry_ |
varchar2 |
Nome del settore | |||
invoice_ |
varchar2 |
Ricevitore della fattura | |||
is_ |
char |
itgen_spe_is_active | |||
linkedin_ |
varchar2 |
URL di LinkedIn | |||
modified |
varchar2 |
Modified | |||
name |
varchar2 |
Name | |||
note |
varchar2 |
Note | |||
organizationsize_ |
varchar2 |
ID delle dimensioni dell'organizzazione | |||
organizationsize_ |
varchar2 |
Nome delle dimensioni dell'organizzazione | |||
phone |
varchar2 |
Phone | |||
postal_ |
varchar2 |
Paese dell'indirizzo postale | |||
postal_ |
varchar2 |
Codice del Paese dell'indirizzo postale | |||
postal_ |
varchar2 |
Indirizzo postale ID del paese | |||
postal_ |
varchar2 |
ID dell'indirizzo postale | |||
postal_ |
varchar2 |
Indirizzo postale Linea 1 | |||
postal_ |
varchar2 |
Indirizzo postale Linea 2 | |||
postal_ |
varchar2 |
Indirizzo postale Località | |||
postal_ |
varchar2 |
Indirizzo postale Codice postale | |||
postal_ |
varchar2 |
Indirizzo postale Provincia | |||
postal_ |
varchar2 |
Tipo di indirizzo 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 |
ID del responsabile delle relazioni | |||
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 |
Nome del responsabile delle relazioni | |||
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 del responsabile delle relazioni | |||
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 |
Numero di relazione | |||
relation_ |
varchar2 |
Colore del tipo di relazione | |||
relation_ |
varchar2 |
ID del tipo di relazione | |||
relation_ |
varchar2 |
Etichetta del tipo di relazione | |||
relation_ |
varchar2 |
Tipo di relazione | |||
simplicate_ |
varchar2 |
Simplicate URL | |||
timeline_ |
varchar2 |
Indirizzo e-mail della timeline | |||
updated_ |
varchar2 |
Aggiornato il | |||
url |
varchar2 |
URL | |||
vat_ |
varchar2 |
Numero di partita IVA | |||
visiting_ |
varchar2 |
Paese dell'unità locale | |||
visiting_ |
varchar2 |
Codice Paese dell'indirizzo di visita | |||
visiting_ |
varchar2 |
ID del paese dell'indirizzo di visita | |||
visiting_ |
varchar2 |
ID dell'indirizzo di visita | |||
visiting_ |
varchar2 |
Indirizzo di visita (riga 1) | |||
visiting_ |
varchar2 |
Indirizzo di visita (riga 2) | |||
visiting_ |
varchar2 |
Località dell'indirizzo di visita | |||
visiting_ |
varchar2 |
Indirizzo di visita Codice postale | |||
visiting_ |
varchar2 |
Indirizzo di visita Provincia | |||
visiting_ |
varchar2 |
Tipo di indirizzo di visita |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: