invantive documentation
Invantive Support ForumsLog In / Sign Up

activity: Odoo itgen_odoo_activity

read only per partition

  • Catalog: Odoo
  • Schema: marketing
  • Label: itgen_odoo_activity

Marketing Activity

Can only retrieve data.

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_domain varchar2 Activity Filter Domain that applies to this activity and its child activities
activity_type varchar2 Activity Type
allowed_parent_ids varchar2 All activities which can be the parent of this one
campaign_id varchar2
campaign_id_label varchar2
child_ids varchar2
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
display_name varchar2 Display Name
domain varchar2 Applied Filter Activity will only be performed if record satisfies this domain, obtained from the combination of the activity filter and its inherited filter
id int32 ID
interval_number int32 Send after
interval_standardized int32 Send after (in hours)
interval_type varchar2 Delay Type
mass_mailing_id varchar2
mass_mailing_id_label varchar2
mass_mailing_id_mailing_type varchar2 Mailing Type
model_id varchar2
model_id_label varchar2
model_name varchar2 Model Name
name varchar2 Name
parent_id varchar2
parent_id_label varchar2
processed int32 Processed
rejected int32 Rejected
require_sync boolean Require trace sync
server_action_id varchar2
server_action_id_label varchar2
source_id varchar2
source_id_label varchar2
statistics_graph_data varchar2 Statistics Graph Data
total_bounce int32 Total Bounce
total_click int32 Total Click
total_open int32 Total Open
total_reply int32 Total Reply
total_sent int32 Total Sent
trace_ids varchar2
trigger_category varchar2 Trigger Category
trigger_type varchar2 Trigger Type
utm_campaign_id varchar2
utm_campaign_id_label varchar2
validity_duration boolean Validity Duration Check this to make sure your actions are not executed after a specific amount of time after the scheduled date. (e.g. : Time-limited offer, Upcoming event, …)
validity_duration_number int32 Valid during
validity_duration_type varchar2 Validity Duration Type
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: