invantive documentation
Forum di supporto InvantiveAccedi / Registrati

lead: Odoo itgen_odoo_lead

read only per partition

  • Catalogo: Odoo
  • Schema: crm
  • Etichetta: itgen_odoo_lead

Lead/Opportunity

È possibile solo recuperare i dati.

Colonne della tabella

Di seguito sono riportate le colonne della tabella lead. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati 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 Nome del contatto
country_id varchar2
country_id_label varchar2
create_date datetime Creato il
create_uid varchar2
create_uid_label varchar2
date_action_last datetime Ultima azione
date_closed datetime Data di chiusura
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 Giorni mancanti alla chiusura
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 Nome visualizzato
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 Entrate previste
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 Numero di allegati
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 Numero di azioni 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 Nome dell'impresa 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 È vinto
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2
zip varchar2 Zip

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: