invantive documentation
Forum di supporto InvantiveAccedi / Registrati

digest: Odoo itgen_odoo_digest

read only per partition

  • Catalogo: Odoo
  • Schema: digest
  • Etichetta: itgen_odoo_digest

Digest

È possibile solo recuperare i dati.

Colonne della tabella

Di seguito sono riportate le colonne della tabella digest. 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
available_fields varchar2 Available Fields
company_id varchar2
company_id_label varchar2
create_date datetime Creato il
create_uid varchar2
create_uid_label varchar2
currency_id varchar2
currency_id_label varchar2
display_name varchar2 Nome visualizzato
id int32 ID
is_subscribed boolean Is user subscribed
kpi_account_bank_cash boolean Bank & Cash Moves
kpi_account_bank_cash_value numeric Kpi Account Bank Cash Value
kpi_account_total_revenue boolean Revenue
kpi_account_total_revenue_value numeric Kpi Account Total Revenue Value
kpi_all_sale_total boolean All Sales
kpi_all_sale_total_value numeric Kpi All Sale Total Value
kpi_crm_lead_created boolean New Leads
kpi_crm_lead_created_value int32 Kpi Crm Lead Created Value
kpi_crm_opportunities_won boolean Opportunities Won
kpi_crm_opportunities_won_value int32 Kpi Crm Opportunities Won Value
kpi_helpdesk_tickets_closed boolean Tickets Closed
kpi_helpdesk_tickets_closed_value int32 Kpi Helpdesk Tickets Closed Value
kpi_hr_recruitment_new_colleagues boolean New Employees
kpi_hr_recruitment_new_colleagues_value int32 Kpi Hr Recruitment New Colleagues Value
kpi_livechat_conversations boolean Conversations handled
kpi_livechat_conversations_value int32 Kpi Livechat Conversations Value
kpi_livechat_rating boolean % of Happiness
kpi_livechat_rating_value numeric Kpi Livechat Rating Value
kpi_livechat_response boolean Time to answer (sec)
kpi_livechat_response_value numeric Kpi Livechat Response Value
kpi_mail_message_total boolean Messages Sent
kpi_mail_message_total_value int32 Kpi Mail Message Total Value
kpi_pos_total boolean POS Sales
kpi_pos_total_value numeric Kpi Pos Total Value
kpi_project_task_opened boolean Open Tasks
kpi_project_task_opened_value int32 Kpi Project Task Opened Value
kpi_res_users_connected boolean Connected Users
kpi_res_users_connected_value int32 Kpi Res Users Connected Value
kpi_website_sale_total boolean eCommerce Sales
kpi_website_sale_total_value numeric Kpi Website Sale Total Value
name varchar2 Name
next_run_date datetime Next Mailing Date
periodicity varchar2 Periodicity
state varchar2 Status
user_ids varchar2
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Note di rilascio

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