invantive documentation
Invantive Support ForumsLog In / Sign Up

team: Odoo itgen_odoo_team

read only per partition

  • Catalog: Odoo
  • Schema: crm
  • Label: itgen_odoo_team

Sales Team

Can only retrieve data.

Summary

A mixin for models that inherits mail.alias. This mixin initializes the alias_id column in database, and manages the expected one-to-one relation between your model and mail aliases.

Table Columns

The columns of the table team 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
abandoned_carts_amount int32 Amount of Abandoned Carts
abandoned_carts_count int32 Number of Abandoned Carts
active boolean Active If the active field is set to false, it will allow you to hide the Sales Team without removing it.
alias_bounced_content varchar2 Custom Bounced Message If set, this content will automatically be sent out to unauthorized users instead of the default message.
alias_contact varchar2 Alias Contact Security Policy to post a message on the document using the mailgateway. - everyone: everyone can post - partners: only authenticated partners - followers: only followers of the related document or members of following channels
alias_defaults varchar2 Default Values A Python dictionary that will be evaluated to provide default values when creating new records for this alias.
alias_domain varchar2 Alias domain
alias_force_thread_id int32 Record Thread ID Optional ID of a thread (record) to which all incoming messages will be attached, even if they did not reply to it. If set, this will disable the creation of new records completely.
alias_id varchar2 The email address associated with this channel. New emails received will automatically create new leads assigned to the channel.
alias_id_label varchar2 The email address associated with this channel. New emails received will automatically create new leads assigned to the channel.
alias_model_id varchar2 The model (Odoo Document Kind) to which this alias corresponds. Any incoming email that does not reply to an existing record will cause the creation of a new record of this model (e.g. a Project Task)
alias_model_id_label varchar2 The model (Odoo Document Kind) to which this alias corresponds. Any incoming email that does not reply to an existing record will cause the creation of a new record of this model (e.g. a Project Task)
alias_name varchar2 Alias Name The name of the email alias, e.g. 'jobs' if you want to catch emails for jobs@example.odoo.com
alias_parent_model_id varchar2 Parent model holding the alias. The model holding the alias reference is not necessarily the model given by alias_model_id (example: project (parent_model) and task (model))
alias_parent_model_id_label varchar2 Parent model holding the alias. The model holding the alias reference is not necessarily the model given by alias_model_id (example: project (parent_model) and task (model))
alias_parent_thread_id int32 Parent Record Thread ID ID of the parent record holding the alias (example: project holding the task creation alias)
alias_status varchar2 Alias Status Alias status assessed on the last message received.
alias_user_id varchar2 The owner of records created upon receiving emails on this alias. If this field is not set the system will attempt to find the right owner based on the sender (From) address, or will use the Administrator account if no system user is found for that address.
alias_user_id_label varchar2 The owner of records created upon receiving emails on this alias. If this field is not set the system will attempt to find the right owner based on the sender (From) address, or will use the Administrator account if no system user is found for that address.
amazon_team boolean Amazon Team Whether this sales team is associated with Amazon orders or not.
assignment_auto_enabled boolean Auto Assignment
assignment_domain varchar2 Assignment Domain Additional filter domain when fetching unassigned leads to allocate to the team.
assignment_enabled boolean Lead Assign
assignment_max int32 Lead Average Capacity Monthly average leads capacity for all salesmen belonging to the team
assignment_optout boolean Skip auto assignment
color int32 Color Index The color of the channel
company_id varchar2
company_id_label varchar2
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
crm_team_member_all_ids varchar2
crm_team_member_ids varchar2 Add members to automatically assign their documents to this sales team.
currency_id varchar2
currency_id_label varchar2
dashboard_button_name varchar2 Dashboard Button
dashboard_graph_data varchar2 Dashboard Graph Data
display_name varchar2 Display Name
favorite_user_ids varchar2
has_message boolean Has Message
id int32 ID
invoiced numeric Invoiced This Month Invoice revenue for the current month. This is the amount the sales channel has invoiced this month. It is used to compute the progression ratio of the current and target revenue on the kanban view.
invoiced_target numeric Invoicing Target Revenue target for the current month (untaxed total of confirmed invoices).
is_favorite boolean Show on dashboard Favorite teams to display them in the dashboard and access them easily.
is_membership_multi boolean Multiple Memberships Allowed If True, users may belong to several sales teams. Otherwise membership is limited to a single sales team.
lead_all_assigned_month_count int32 # Leads/Opps assigned this month Number of leads and opportunities assigned this last month.
lead_properties_definition varchar2 Lead Properties
lead_unassigned_count int32 # Unassigned Leads
member_company_ids varchar2 UX: Limit to team company or all if no company
member_ids varchar2 Users assigned to this team.
member_warning varchar2 Membership Issue Warning
message_attachment_count int32 Attachment Count
message_follower_ids varchar2
message_has_error boolean Message Delivery error If checked, some messages have a delivery error.
message_has_error_counter int32 Number of errors Number of messages with delivery error
message_has_sms_error boolean SMS Delivery error If checked, some messages have a delivery error.
message_ids varchar2
message_is_follower boolean Is Follower
message_main_attachment_id varchar2
message_main_attachment_id_label varchar2
message_needaction boolean Action Needed If checked, new messages require your attention.
message_needaction_counter int32 Number of Actions Number of messages which requires an action
message_partner_ids varchar2
name varchar2 Sales Team
opportunities_amount numeric Opportunities Revenues
opportunities_count int32 # Opportunities
opportunities_overdue_amount numeric Overdue Opportunities Revenues
opportunities_overdue_count int32 # Overdue Opportunities
pos_config_ids varchar2
pos_order_amount_total numeric Session Sale Amount
pos_sessions_open_count int32 Open POS Sessions
quotations_amount numeric Amount of quotations to invoice
quotations_count int32 Number of quotations to invoice
sale_order_count int32 # Sale Orders
sales_to_invoice_count int32 Number of sales to invoice
sequence int32 Sequence
use_leads boolean Leads Check this box to filter and qualify incoming requests as leads before converting them into opportunities and assigning them to a salesperson.
use_opportunities boolean Pipeline Check this box to manage a presales process with opportunities.
use_quotations boolean Quotations Check this box if you send quotations to your customers rather than confirming orders straight away.
user_id varchar2
user_id_label varchar2
website_ids varchar2
website_message_ids varchar2 Website communication history
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: