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