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_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
datetime |
Next Activity Deadline | |||
activity_ |
varchar2 |
Activity Exception Decoration | Type of the exception activity on record. | ||
activity_ |
varchar2 |
Icon | Icon to indicate an exception activity. | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
Activity State | Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities. | ||
activity_ |
varchar2 |
Next Activity Summary | |||
activity_ |
varchar2 |
Activity Type Icon | Font awesome icon e.g. fa-tasks | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
automated_ |
numeric |
Automated Probability | |||
calendar_ |
int32 |
# Meetings | |||
calendar_ |
varchar2 |
||||
campaign_ |
varchar2 |
This is a name that helps you keep track of your different campaign efforts, e.g. Fall_Drive, Christmas_Special | |||
campaign_ |
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_ |
varchar2 |
||||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
contact_ |
varchar2 |
Contact Name | |||
country_ |
varchar2 |
||||
country_ |
varchar2 |
||||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
date_ |
datetime |
Last Action | |||
date_ |
datetime |
Closed Date | |||
date_ |
datetime |
Conversion Date | |||
date_ |
datetime |
Expected Closing | Estimate of the date on which the opportunity will be won. | ||
date_ |
datetime |
Last Stage Update | |||
date_ |
datetime |
Assignment Date | |||
day_ |
numeric |
Days to Close | |||
day_ |
numeric |
Days to Assign | |||
days_ |
numeric |
Exceeded Closing Days | |||
days_ |
numeric |
Days To Convert | |||
description |
varchar2 |
Notes | |||
display_ |
varchar2 |
Display Name | |||
duplicate_ |
int32 |
Potential Duplicate Lead Count | |||
duplicate_ |
varchar2 |
||||
email_ |
varchar2 |
Email cc | |||
email_ |
varchar2 |
||||
email_ |
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_ |
varchar2 |
Email Quality | |||
event_ |
varchar2 |
Event triggering the rule that created this lead | |||
event_ |
varchar2 |
Event triggering the rule that created this lead | |||
event_ |
varchar2 |
Rule that created this lead | |||
event_ |
varchar2 |
Rule that created this lead | |||
expected_ |
numeric |
Expected Revenue | |||
function |
varchar2 |
Job Position | |||
has_ |
boolean |
Is in the Call Queue | |||
has_ |
boolean |
Has Message | |||
iap_ |
boolean |
Enrichment done | Whether IAP service for lead enrichment based on email has been performed on this lead. | ||
id |
int32 |
ID | |||
is_ |
boolean |
Is automated probability? | |||
is_ |
boolean |
Blacklist | If the email address is on the blacklist, the contact won't receive mass mailing anymore, from any list | ||
is_ |
boolean |
Is Partner Visible | |||
kanban_ |
varchar2 |
Kanban State | |||
lang_ |
int32 |
Lang Active Count | |||
lang_ |
varchar2 |
Locale Code | This field is used to set/get locales for user | ||
lang_ |
varchar2 |
||||
lang_ |
varchar2 |
||||
lead_ |
varchar2 |
||||
lead_ |
varchar2 |
||||
lead_ |
varchar2 |
Properties | |||
lost_ |
varchar2 |
||||
lost_ |
varchar2 |
||||
medium_ |
varchar2 |
This is the method of delivery, e.g. Postcard, Email, or Banner Ad | |||
medium_ |
varchar2 |
This is the method of delivery, e.g. Postcard, Email, or Banner Ad | |||
message_ |
int32 |
Attachment Count | |||
message_ |
int32 |
Bounce | Counter of the number of bounced emails for this contact | ||
message_ |
varchar2 |
||||
message_ |
boolean |
Message Delivery error | If checked, some messages have a delivery error. | ||
message_ |
int32 |
Number of errors | Number of messages with delivery error | ||
message_ |
boolean |
SMS Delivery error | If checked, some messages have a delivery error. | ||
message_ |
varchar2 |
||||
message_ |
boolean |
Is Follower | |||
message_ |
varchar2 |
||||
message_ |
varchar2 |
||||
message_ |
boolean |
Action Needed | If checked, new messages require your attention. | ||
message_ |
int32 |
Number of Actions | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
mobile |
varchar2 |
Mobile | |||
mobile_ |
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_ |
datetime |
My Activity Deadline | |||
name |
varchar2 |
Opportunity | |||
order_ |
varchar2 |
||||
partner_ |
boolean |
Partner Email will Update | |||
partner_ |
varchar2 |
Linked partner (optional). Usually created when converting the lead. You can find a partner by its Name, TIN, Email or Internal Reference. | |||
partner_ |
varchar2 |
Linked partner (optional). Usually created when converting the lead. You can find a partner by its Name, TIN, Email or Internal Reference. | |||
partner_ |
boolean |
Partner is blacklisted | If the email address is on the blacklist, the contact won't receive mass mailing anymore, from any list | ||
partner_ |
varchar2 |
Company Name | The name of the future partner company that will be created while converting the lead into opportunity | ||
partner_ |
boolean |
Partner Phone will Update | |||
phone |
varchar2 |
Phone | |||
phone_ |
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_ |
varchar2 |
Phone/Mobile | |||
phone_ |
varchar2 |
Sanitized Number | Field used to store sanitized phone number. Helps speeding up searches and comparisons. | ||
phone_ |
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_ |
varchar2 |
Phone Quality | |||
priority |
varchar2 |
Priority | |||
probability |
numeric |
Probability | |||
prorated_ |
numeric |
Prorated Revenue | |||
quotation_ |
int32 |
Number of Quotations | |||
recurring_ |
varchar2 |
||||
recurring_ |
varchar2 |
||||
recurring_ |
numeric |
Recurring Revenues | |||
recurring_ |
numeric |
Expected MRR | |||
recurring_ |
numeric |
Prorated MRR | |||
recurring_ |
numeric |
Prorated Recurring Revenues | |||
referred |
varchar2 |
Referred By | |||
registration_ |
int32 |
# Registrations | Counter for the registrations linked to this lead | ||
registration_ |
varchar2 |
Registrations triggering the rule that created this lead | |||
rental_ |
numeric |
Sum of Rental Orders | Untaxed Total of Confirmed Orders | ||
rental_ |
int32 |
Number of Rental Orders | |||
rental_ |
varchar2 |
||||
rental_ |
int32 |
Number of Rental Quotations | |||
reveal_ |
varchar2 |
Reveal ID | |||
sale_ |
numeric |
Sum of Orders | Untaxed Total of Confirmed Orders | ||
sale_ |
int32 |
Number of Sale Orders | |||
show_ |
boolean |
Allow manual enrich | |||
source_ |
varchar2 |
This is the source of the link, e.g. Search Engine, another domain, or name of email list | |||
source_ |
varchar2 |
This is the source of the link, e.g. Search Engine, another domain, or name of email list | |||
stage_ |
varchar2 |
||||
stage_ |
varchar2 |
||||
state_ |
varchar2 |
||||
state_ |
varchar2 |
||||
street |
varchar2 |
Street | |||
street2 |
varchar2 |
Street2 | |||
tag_ |
varchar2 |
Classify and analyze your lead/opportunity categories like: Training, Service | |||
team_ |
varchar2 |
||||
team_ |
varchar2 |
||||
title |
varchar2 |
||||
title_ |
varchar2 |
||||
type |
varchar2 |
Type | |||
user_ |
varchar2 |
UX: Limit to lead company or all if no company | |||
user_ |
varchar2 |
||||
user_ |
varchar2 |
||||
visitor_ |
varchar2 |
||||
visitor_ |
int32 |
# Page Views | |||
visitor_ |
int32 |
# Sessions | |||
website |
varchar2 |
Website | Website of the contact | ||
website_ |
varchar2 |
Website communication history | |||
won_ |
varchar2 |
Is Won | |||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
||||
zip |
varchar2 |
Zip |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: