invantive documentation
Invantive Support ForumsLog In / Sign Up

lead: Odoo itgen_odoo_lead

read only per partition

  • Catalog: Odoo
  • Schema: crm
  • Label: itgen_odoo_lead

Lead/Opportunity

Can only retrieve data.

Table Columns

The columns of the table lead 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
activity_calendar_event_id varchar2
activity_calendar_event_id_label varchar2
activity_date_deadline datetime Next Activity Deadline
activity_exception_decoration varchar2 Activity Exception Decoration Type of the exception activity on record.
activity_exception_icon varchar2 Icon Icon to indicate an exception activity.
activity_ids varchar2
activity_state varchar2 Activity State Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities.
activity_summary varchar2 Next Activity Summary
activity_type_icon varchar2 Activity Type Icon Font awesome icon e.g. fa-tasks
activity_type_id varchar2
activity_type_id_label varchar2
activity_user_id varchar2
activity_user_id_label varchar2
automated_probability numeric Automated Probability
calendar_event_count int32 # Meetings
calendar_event_ids varchar2
campaign_id varchar2 This is a name that helps you keep track of your different campaign efforts, e.g. Fall_Drive, Christmas_Special
campaign_id_label varchar2 This is a name that helps you keep track of your different campaign efforts, e.g. Fall_Drive, Christmas_Special
city varchar2 City
color int32 Color Index
company_currency varchar2
company_currency_label varchar2
company_id varchar2
company_id_label varchar2
contact_name varchar2 Contact Name
country_id varchar2
country_id_label varchar2
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
date_action_last datetime Last Action
date_closed datetime Closed Date
date_conversion datetime Conversion Date
date_deadline datetime Expected Closing Estimate of the date on which the opportunity will be won.
date_last_stage_update datetime Last Stage Update
date_open datetime Assignment Date
day_close numeric Days to Close
day_open numeric Days to Assign
days_exceeding_closing numeric Exceeded Closing Days
days_to_convert numeric Days To Convert
description varchar2 Notes
display_name varchar2 Display Name
duplicate_lead_count int32 Potential Duplicate Lead Count
duplicate_lead_ids varchar2
email_cc varchar2 Email cc
email_from varchar2 Email
email_normalized varchar2 Normalized Email This field is used to search on email address as the primary email field can contain more than strictly an email address.
email_state varchar2 Email Quality
event_id varchar2 Event triggering the rule that created this lead
event_id_label varchar2 Event triggering the rule that created this lead
event_lead_rule_id varchar2 Rule that created this lead
event_lead_rule_id_label varchar2 Rule that created this lead
expected_revenue numeric Expected Revenue
function varchar2 Job Position
has_call_in_queue boolean Is in the Call Queue
has_message boolean Has Message
iap_enrich_done boolean Enrichment done Whether IAP service for lead enrichment based on email has been performed on this lead.
id int32 ID
is_automated_probability boolean Is automated probability?
is_blacklisted boolean Blacklist If the email address is on the blacklist, the contact won't receive mass mailing anymore, from any list
is_partner_visible boolean Is Partner Visible
kanban_state varchar2 Kanban State
lang_active_count int32 Lang Active Count
lang_code varchar2 Locale Code This field is used to set/get locales for user
lang_id varchar2
lang_id_label varchar2
lead_mining_request_id varchar2
lead_mining_request_id_label varchar2
lead_properties varchar2 Properties
lost_reason_id varchar2
lost_reason_id_label varchar2
medium_id varchar2 This is the method of delivery, e.g. Postcard, Email, or Banner Ad
medium_id_label varchar2 This is the method of delivery, e.g. Postcard, Email, or Banner Ad
message_attachment_count int32 Attachment Count
message_bounce int32 Bounce Counter of the number of bounced emails for this contact
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
mobile varchar2 Mobile
mobile_blacklisted boolean Blacklisted Phone Is Mobile Indicates if a blacklisted sanitized phone number is a mobile number. Helps distinguish which number is blacklisted when there is both a mobile and phone field in a model.
my_activity_date_deadline datetime My Activity Deadline
name varchar2 Opportunity
order_ids varchar2
partner_email_update boolean Partner Email will Update
partner_id varchar2 Linked partner (optional). Usually created when converting the lead. You can find a partner by its Name, TIN, Email or Internal Reference.
partner_id_label varchar2 Linked partner (optional). Usually created when converting the lead. You can find a partner by its Name, TIN, Email or Internal Reference.
partner_is_blacklisted boolean Partner is blacklisted If the email address is on the blacklist, the contact won't receive mass mailing anymore, from any list
partner_name varchar2 Company Name The name of the future partner company that will be created while converting the lead into opportunity
partner_phone_update boolean Partner Phone will Update
phone varchar2 Phone
phone_blacklisted boolean Blacklisted Phone is Phone Indicates if a blacklisted sanitized phone number is a phone number. Helps distinguish which number is blacklisted when there is both a mobile and phone field in a model.
phone_mobile_search varchar2 Phone/Mobile
phone_sanitized varchar2 Sanitized Number Field used to store sanitized phone number. Helps speeding up searches and comparisons.
phone_sanitized_blacklisted boolean Phone Blacklisted If the sanitized phone number is on the blacklist, the contact won't receive mass mailing sms anymore, from any list
phone_state varchar2 Phone Quality
priority varchar2 Priority
probability numeric Probability
prorated_revenue numeric Prorated Revenue
quotation_count int32 Number of Quotations
recurring_plan varchar2
recurring_plan_label varchar2
recurring_revenue numeric Recurring Revenues
recurring_revenue_monthly numeric Expected MRR
recurring_revenue_monthly_prorated numeric Prorated MRR
recurring_revenue_prorated numeric Prorated Recurring Revenues
referred varchar2 Referred By
registration_count int32 # Registrations Counter for the registrations linked to this lead
registration_ids varchar2 Registrations triggering the rule that created this lead
rental_amount_total numeric Sum of Rental Orders Untaxed Total of Confirmed Orders
rental_order_count int32 Number of Rental Orders
rental_order_ids varchar2
rental_quotation_count int32 Number of Rental Quotations
reveal_id varchar2 Reveal ID
sale_amount_total numeric Sum of Orders Untaxed Total of Confirmed Orders
sale_order_count int32 Number of Sale Orders
show_enrich_button boolean Allow manual enrich
source_id varchar2 This is the source of the link, e.g. Search Engine, another domain, or name of email list
source_id_label varchar2 This is the source of the link, e.g. Search Engine, another domain, or name of email list
stage_id varchar2
stage_id_label varchar2
state_id varchar2
state_id_label varchar2
street varchar2 Street
street2 varchar2 Street2
tag_ids varchar2 Classify and analyze your lead/opportunity categories like: Training, Service
team_id varchar2
team_id_label varchar2
title varchar2
title_label varchar2
type varchar2 Type
user_company_ids varchar2 UX: Limit to lead company or all if no company
user_id varchar2
user_id_label varchar2
visitor_ids varchar2
visitor_page_count int32 # Page Views
visitor_sessions_count int32 # Sessions
website varchar2 Website Website of the contact
website_message_ids varchar2 Website communication history
won_status varchar2 Is Won
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2
zip varchar2 Zip

Release Notes

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