invantive documentation
Forum di supporto InvantiveAccedi / Registrati

ProjectCustomFieldOptions: Simplicate itgen_spe_projectcustomfieldoptions_plural

read only REST

  • Catalogo: Simplicate
  • Schema: Projects
  • Etichetta: itgen_spe_projectcustomfieldoptions_plural

Recupera tutti i progetti

È possibile solo recuperare i dati.

Codice sorgente dell'API

  • Punto finale: /projects/project
  • Operazione: get /projects/project

Colonne della tabella

Di seguito sono riportate le colonne della tabella ProjectCustomFieldOptions. 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
abnormal_address char Indirizzo anomalo
abnormal_contact_id varchar2 ID di contatto anomalo
abnormal_organization_id varchar2 ID dell'organizzazione anomalo
abnormal_person_id varchar2 ID persona anomala
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 Può registrare il chilometraggio
contact_id varchar2 ID contatto
contact_id_2 varchar2 itgen_spe_contact_id_2
contact_organization_id varchar2 ID dell'organizzazione di contatto
contact_organization_name varchar2 Nome dell'organizzazione di contatto
contact_organization_relation_number varchar2 itgen_spe_contact_organization_relation_number
contact_person_full_name varchar2 Nome completo della persona di contatto
contact_person_id varchar2 ID persona di contatto
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 Aggiunto per conformità alla risposta 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 Creato il
custom_field_group_id varchar2 ID del gruppo di campi personalizzato
custom_field_group_model_id varchar2 ID del modello del gruppo di campi personalizzato
custom_field_group_model_label varchar2 Etichetta modello gruppo di campi personalizzati
custom_field_group_name varchar2 Nome del gruppo di campi personalizzato
custom_field_group_position varchar2 Posizione del gruppo di campi personalizzato
custom_field_group_type varchar2 Tipo di gruppo di campi personalizzato
divergent_payment_term_days int64 Termine di pagamento divergente (giorni)
divergent_payment_term_id varchar2 ID del termine di pagamento divergente
divergent_payment_term_method varchar2 Metodo di termine di pagamento divergente
divergent_payment_term_name varchar2 Nome del termine di pagamento divergente
end_date varchar2 Data di fine
filterable char Filterable
hours_rate_type varchar2 Tipo di tariffa oraria
id varchar2 ID
id_2 varchar2 itgen_spe_id_2
id_3 varchar2 itgen_spe_id_3
invoice_reference varchar2 Riferimento della fattura
is_invoice_approval char È l'approvazione della fattura
is_reverse_billing char È fatturazione inversa
label varchar2 Label
label_2 varchar2 itgen_spe_label_2
mandatory char itgen_spe_mandatory
modified varchar2 Modified
my_organization_profile_id varchar2 ID del profilo della mia organizzazione
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 dell'organizzazione
organization_id_2 varchar2 itgen_spe_organization_id_2
organization_name varchar2 Nome dell'organizzazione
organization_relation_number varchar2 itgen_spe_organization_relation_number
person_full_name varchar2 Nome completo della persona
person_id varchar2 ID persona
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 Aggiunto per conformità alla risposta originale sales/sales responsible_employee
project_manager_tariff double itgen_spe_project_manager_tariff
project_number varchar2 Numero del progetto
project_status_color varchar2 Colore dello stato del progetto
project_status_id varchar2 ID di stato del progetto
project_status_label varchar2 Etichetta di stato del progetto
render_type varchar2 Tipo di rendering
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 Data di inizio
timeline_email_address varchar2 Indirizzo e-mail della timeline
type varchar2 Type
updated_at varchar2 Aggiornato il
value varchar2 Value
value_2 varchar2 itgen_spe_value_2
value_type varchar2 Tipo di valore

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: