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