invantive documentation
Invantive Support ForumsLog In / Sign Up

activity_report: Odoo itgen_odoo_activity_report

read only per partition

  • Catalog: Odoo
  • Schema: crm
  • Label: itgen_odoo_activity_report

CRM Activity Analysis

Can only retrieve data.

Summary

CRM Lead Analysis

Table Columns

The columns of the table activity_report 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
active boolean Active
author_id varchar2
author_id_label varchar2
body varchar2 Activity Description
company_id varchar2
company_id_label varchar2
country_id varchar2
country_id_label varchar2
date datetime Completion Date
date_closed datetime Closed Date
date_conversion datetime Conversion Date
date_deadline datetime Expected Closing
display_name varchar2 Display Name
id int32 ID
lead_create_date datetime Creation Date
lead_id varchar2
lead_id_label varchar2
lead_type varchar2 Type Type is used to separate Leads and Opportunities
mail_activity_type_id varchar2
mail_activity_type_id_label varchar2
partner_id varchar2
partner_id_label varchar2
stage_id varchar2
stage_id_label varchar2
subtype_id varchar2
subtype_id_label varchar2
tag_ids varchar2 Classify and analyze your lead/opportunity categories like: Training, Service
team_id varchar2
team_id_label varchar2
user_id varchar2
user_id_label varchar2
won_status varchar2 Is Won

Release Notes

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