Please enable JavaScript to view this site.

Made in EU
Odoo Forums

Navigation: Schema: crm > Tables

lead

Lead/Opportunity

Catalog: Odoo

Schema: crm

The data in this table is partitioned per value of the column.

This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API.

Table Columns

The columns of the table lead are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

active

boolean

Active

 

activity_calendar_event_id_label

string

 

 

activity_calendar_event_id

string

 

 

activity_date_deadline

datetime

Next Activity Deadline

 

activity_exception_decoration

string

Activity Exception Decoration

Type of the exception activity on record.

activity_exception_icon

string

Icon

Icon to indicate an exception activity.

activity_ids

string

 

 

activity_state

string

Activity State

Status based on activitiesOverdue: Due date is already passedToday: Activity date is todayPlanned: Future activities.

activity_summary

string

Next Activity Summary

 

activity_type_icon

string

Activity Type Icon

Font awesome icon e.g. fa-tasks

activity_type_id_label

string

 

 

activity_type_id

string

 

 

activity_user_id_label

string

 

 

activity_user_id

string

 

 

automated_probability

decimal

Automated Probability

 

calendar_event_count

int32

# Meetings

 

calendar_event_ids

string

 

 

campaign_id_label

string

 

This is a name that helps you keep track of your different campaign efforts, e.g. Fall_Drive, Christmas_Special

campaign_id

string

 

This is a name that helps you keep track of your different campaign efforts, e.g. Fall_Drive, Christmas_Special

city

string

City

 

color

int32

Color Index

 

company_currency_label

string

 

 

company_currency

string

 

 

company_id_label

string

 

 

company_id

string

 

 

contact_name

string

Contact Name

 

country_id_label

string

 

 

country_id

string

 

 

create_date

datetime

Created on

 

create_uid_label

string

 

 

create_uid

string

 

 

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

decimal

Days to Close

 

day_open

decimal

Days to Assign

 

days_exceeding_closing

decimal

Exceeded Closing Days

 

days_to_convert

decimal

Days To Convert

 

description

string

Notes

 

display_name

string

Display Name

 

duplicate_lead_count

int32

Potential Duplicate Lead Count

 

duplicate_lead_ids

string

 

 

email_cc

string

Email cc

 

email_from

string

Email

 

email_normalized

string

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

string

Email Quality

 

event_id_label

string

 

Event triggering the rule that created this lead

event_id

string

 

Event triggering the rule that created this lead

event_lead_rule_id_label

string

 

Rule that created this lead

event_lead_rule_id

string

 

Rule that created this lead

expected_revenue

decimal

Expected Revenue

 

function

string

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

string

Kanban State

 

lang_active_count

int32

Lang Active Count

 

lang_code

string

Locale Code

This field is used to set/get locales for user

lang_id_label

string

 

 

lang_id

string

 

 

lead_mining_request_id_label

string

 

 

lead_mining_request_id

string

 

 

lead_properties

string

Properties

 

lost_reason_id_label

string

 

 

lost_reason_id

string

 

 

medium_id_label

string

 

This is the method of delivery, e.g. Postcard, Email, or Banner Ad

medium_id

string

 

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

string

 

 

message_has_error_counter

int32

Number of errors

Number of messages with delivery error

message_has_error

boolean

Message Delivery error

If checked, some messages have a delivery error.

message_has_sms_error

boolean

SMS Delivery error

If checked, some messages have a delivery error.

message_ids

string

 

 

message_is_follower

boolean

Is Follower

 

message_main_attachment_id_label

string

 

 

message_main_attachment_id

string

 

 

message_needaction_counter

int32

Number of Actions

Number of messages which requires an action

message_needaction

boolean

Action Needed

If checked, new messages require your attention.

message_partner_ids

string

 

 

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.

mobile

string

Mobile

 

my_activity_date_deadline

datetime

My Activity Deadline

 

name

string

Opportunity

 

order_ids

string

 

 

partner_email_update

boolean

Partner Email will Update

 

partner_id_label

string

 

Linked partner (optional). Usually created when converting the lead. You can find a partner by its Name, TIN, Email or Internal Reference.

partner_id

string

 

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

string

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_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

string

Phone/Mobile

 

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_sanitized

string

Sanitized Number

Field used to store sanitized phone number. Helps speeding up searches and comparisons.

phone_state

string

Phone Quality

 

phone

string

Phone

 

priority

string

Priority

 

probability

decimal

Probability

 

prorated_revenue

decimal

Prorated Revenue

 

quotation_count

int32

Number of Quotations

 

recurring_plan_label

string

 

 

recurring_plan

string

 

 

recurring_revenue_monthly_prorated

decimal

Prorated MRR

 

recurring_revenue_monthly

decimal

Expected MRR

 

recurring_revenue_prorated

decimal

Prorated Recurring Revenues

 

recurring_revenue

decimal

Recurring Revenues

 

referred

string

Referred By

 

registration_count

int32

# Registrations

Counter for the registrations linked to this lead

registration_ids

string

 

Registrations triggering the rule that created this lead

rental_amount_total

decimal

Sum of Rental Orders

Untaxed Total of Confirmed Orders

rental_order_count

int32

Number of Rental Orders

 

rental_order_ids

string

 

 

rental_quotation_count

int32

Number of Rental Quotations

 

reveal_id

string

Reveal ID

 

sale_amount_total

decimal

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_label

string

 

This is the source of the link, e.g. Search Engine, another domain, or name of email list

source_id

string

 

This is the source of the link, e.g. Search Engine, another domain, or name of email list

stage_id_label

string

 

 

stage_id

string

 

 

state_id_label

string

 

 

state_id

string

 

 

street

string

Street

 

street2

string

Street2

 

tag_ids

string

 

Classify and analyze your lead/opportunity categories like: Training, Service

team_id_label

string

 

 

team_id

string

 

 

title_label

string

 

 

title

string

 

 

type

string

Type

 

user_company_ids

string

 

UX: Limit to lead company or all if no company

user_id_label

string

 

 

user_id

string

 

 

visitor_ids

string

 

 

visitor_page_count

int32

# Page Views

 

visitor_sessions_count

int32

# Sessions

 

website_message_ids

string

 

Website communication history

website

string

Website

Website of the contact

won_status

string

Is Won

 

write_date

datetime

Last Updated on

 

write_uid_label

string

 

 

write_uid

string

 

 

zip

string

Zip

 

 

01-03-2023 15:29 Version 22.1.135-BETA+3826

X

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

  • Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
  • Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
  • Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
  • Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
  • Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
  • Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
  • Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
  • Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

  
Disclaimer