invantive documentation
Invantive Support ForumsLog In / Sign Up

digest: Odoo itgen_odoo_digest

read only per partition

  • Catalog: Odoo
  • Schema: digest
  • Label: itgen_odoo_digest

Digest

Can only retrieve data.

Table Columns

The columns of the table digest are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
available_fields varchar2 Available Fields
company_id varchar2
company_id_label varchar2
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
currency_id varchar2
currency_id_label varchar2
display_name varchar2 Display Name
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

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: