invantive documentation
Invantive Support ForumsLog In / Sign Up

activity: Odoo itgen_odoo_activity

read only per partition

  • Catalog: Odoo
  • Schema: mail
  • Label: itgen_odoo_activity

Activity

Can only retrieve data.

Summary

An actual activity to perform. Activities are linked to documents using res_id and res_model_id fields. Activities have a deadline that can be used in kanban view to display a status. Once done activities are unlinked and a message is posted. This message has a new activity_type_id field that indicates the activity linked to the message.

Table Columns

The columns of the table activity 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
activity_category varchar2 Action Actions may trigger specific behavior like opening calendar view or automatically mark as done when a document is uploaded
activity_decoration varchar2 Decoration Type Change the background color of the related activities of this type.
activity_type_id varchar2
activity_type_id_label varchar2
automated boolean Automated activity Indicates this activity has been created automatically and not by any user.
calendar_event_id varchar2
calendar_event_id_label varchar2
can_write boolean Can Write
chaining_type varchar2 Chaining Type
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
date_deadline datetime Due Date
display_name varchar2 Display Name
has_recommended_activities boolean Next activities available
icon varchar2 Icon Font awesome icon e.g. fa-tasks
id int32 ID
mail_template_ids varchar2
mobile varchar2 Mobile
note varchar2 Note
note_id varchar2
note_id_label varchar2
phone varchar2 Phone
previous_activity_type_id varchar2
previous_activity_type_id_label varchar2
recommended_activity_type_id varchar2
recommended_activity_type_id_label varchar2
request_partner_id varchar2
request_partner_id_label varchar2
res_id int32 Related Document ID
res_model varchar2 Related Document Model
res_model_id varchar2
res_model_id_label varchar2
res_name varchar2 Document Name
state varchar2 State
summary varchar2 Summary
user_id varchar2
user_id_label varchar2
voip_phonecall_id varchar2
voip_phonecall_id_label 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: