invantive documentation
Invantive Support ForumsLog In / Sign Up

partner: Odoo itgen_odoo_partner

read only per partition

  • Catalog: Odoo
  • Schema: res
  • Label: itgen_odoo_partner

Contact

Can only retrieve data.

Summary

Update of res.partner class to take into account the livechat username.

Table Columns

The columns of the table partner 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
account_represented_company_ids varchar2
active boolean Active
active_lang_count int32 Active Lang Count
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
additional_info varchar2 Additional info
amazon_email varchar2 Amazon Email The encrypted email of the customer. Does not forward mails.
avatar_1024 varbinary Avatar 1024
avatar_128 varbinary Avatar 128
avatar_1920 varbinary Avatar
avatar_256 varbinary Avatar 256
avatar_512 varbinary Avatar 512
bank_account_count int32 Bank
bank_ids varchar2
barcode varchar2 Barcode Use a barcode to identify this contact.
bill_my_account boolean Bill My Account If checked, ecommerce users will be prompted their UPS account number and delivery fees will be charged on it.
calendar_last_notif_ack datetime Last notification marked as read from base Calendar
can_publish boolean Can Publish
category_id varchar2
certifications_company_count int32 Company Certifications Count
certifications_count int32 Certifications Count
channel_ids varchar2
child_ids varchar2
city varchar2 City
color int32 Color Index
comment varchar2 Notes
commercial_company_name varchar2 Company Name Entity
commercial_partner_id varchar2
commercial_partner_id_label varchar2
company_id varchar2
company_id_label varchar2
company_name varchar2 Company Name
company_registry varchar2 Company ID The registry number of the company. Use it if it is different from the Tax ID. It must be unique across all partners of a same country
company_type varchar2 Company Type
contact_address varchar2 Complete Address
contact_address_complete varchar2 Contact Address Complete
contract_ids varchar2
country_code varchar2 Country Code The ISO country code in two chars. You can use this field for quick search.
country_id varchar2
country_id_label varchar2
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
credit numeric Total Receivable Total amount this customer owes you.
credit_limit numeric Credit Limit Credit limit specific to this partner.
currency_id varchar2
currency_id_label varchar2
customer_rank int32 Customer Rank
date datetime Date
date_localization datetime Geolocation Date
debit numeric Total Payable Total amount you have to pay to this vendor.
debit_limit numeric Payable Limit
display_name varchar2 Display Name
document_count int32 Document Count
duplicated_bank_account_partners_count int32 Duplicated Bank Account Partners Count
ebay_id varchar2 eBay User ID
email varchar2 Email
email_formatted varchar2 Formatted Email Format email address "Name email@domain"
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.
employee boolean Employee Check this box if this contact is an Employee.
employee_ids varchar2 Related employees based on their private address
employees_count int32 Employees Count
event_count int32 # Events
fiscal_country_codes varchar2 Fiscal Country Codes
followup_line_id varchar2
followup_line_id_label varchar2
followup_next_action_date datetime Next reminder The date before which no follow-up action should be taken. You can set it manually if desired but it is automatically set when follow-ups are processed. The date is computed according to the following rules (depending on the follow-up levels): - default -> next date set in {next level delay - current level delay} days - if no next level -> next date set in {current level delay - previous level delay} days - if no next level AND no previous level -> next date set in days - if no level defined at all -> next date never automatically set
followup_reminder_type varchar2 Reminders
followup_responsible_id varchar2 Optionally you can assign a user to this field, which will make him responsible for the activities. If empty, we will find someone responsible.
followup_responsible_id_label varchar2 Optionally you can assign a user to this field, which will make him responsible for the activities. If empty, we will find someone responsible.
followup_status varchar2 Follow-up Status
function varchar2 Job Position
has_call_in_queue boolean Is in the Call Queue
has_message boolean Has Message
has_unreconciled_entries boolean Has Unreconciled Entries The partner has at least one unreconciled debit and credit since last time the invoices & payments matching was performed.
id int32 ID
im_status varchar2 IM Status
image_1024 varbinary Image 1024
image_128 varbinary Image 128
image_1920 varbinary Image
image_256 varbinary Image 256
image_512 varbinary Image 512
image_medium varbinary Medium-sized image
industry_id varchar2
industry_id_label varchar2
invoice_ids varchar2
invoice_warn varchar2 Invoice Selecting the "Warning" option will notify user with the message, Selecting "Blocking Message" will throw an exception with the message and block the flow. The Message has to be written in the next field.
invoice_warn_msg varchar2 Message for Invoice
is_blacklisted boolean Blacklist If the email address is on the blacklist, the contact won't receive mass mailing anymore, from any list
is_company boolean Is a Company Check if the contact is a company, otherwise it is a person
is_public boolean Is Public
is_published boolean Is Published
is_seo_optimized boolean SEO optimized
journal_item_count int32 Journal Items
l10n_nl_kvk varchar2 KVK-nummer
l10n_nl_oin varchar2 Organisatie Indentificatie Nummer
lang varchar2 Language All the emails and documents sent to this contact will be translated in this language.
last_time_entries_checked datetime Latest Invoices & Payments Matching Date Last time the invoices & payments matching was performed for this partner. It is set either if there's not at least an unreconciled debit and an unreconciled credit or if you click the "Done" button.
last_website_so_id varchar2
last_website_so_id_label varchar2
meeting_count int32 # Meetings
meeting_ids varchar2
message_attachment_count int32 Attachment Count
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 Number of Actions 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 Name
ocn_token varchar2 OCN Token Used for sending notification to registered devices
on_time_rate numeric On-Time Delivery Rate Over the past 12 months; the number of products received on time divided by the number of ordered products.
online_partner_information varchar2 Online Partner Information
opportunity_count int32 Opportunity
opportunity_ids varchar2
parent_id varchar2
parent_id_label varchar2
parent_name varchar2 Parent name
partner_gid int32 Company database ID
partner_latitude numeric Geo Latitude
partner_longitude numeric Geo Longitude
partner_share boolean Share Partner Either customer (not a user), either shared user. Indicated the current partner is a customer without access or with a limited access created for sharing data.
payment_token_count int32 Payment Token Count
payment_token_ids varchar2
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
picking_warn varchar2 Stock Picking Selecting the "Warning" option will notify user with the message, Selecting "Blocking Message" will throw an exception with the message and block the flow. The Message has to be written in the next field.
picking_warn_msg varchar2 Message for Stock Picking
plan_to_change_bike boolean Plan To Change Bike
plan_to_change_car boolean Plan To Change Car
pos_order_count int32 Pos Order Count The number of point of sales orders related to this customer
pos_order_ids varchar2
property_account_payable_id varchar2 This account will be used instead of the default one as the payable account for the current partner
property_account_payable_id_label varchar2 This account will be used instead of the default one as the payable account for the current partner
property_account_position_id varchar2 The fiscal position determines the taxes/accounts used for this contact.
property_account_position_id_label varchar2 The fiscal position determines the taxes/accounts used for this contact.
property_account_receivable_id varchar2 This account will be used instead of the default one as the receivable account for the current partner
property_account_receivable_id_label varchar2 This account will be used instead of the default one as the receivable account for the current partner
property_delivery_carrier_id varchar2 Default delivery method used in sales orders.
property_delivery_carrier_id_label varchar2 Default delivery method used in sales orders.
property_payment_term_id varchar2 This payment term will be used instead of the default one for sales orders and customer invoices
property_payment_term_id_label varchar2 This payment term will be used instead of the default one for sales orders and customer invoices
property_product_pricelist varchar2 This pricelist will be used, instead of the default one, for sales to the current partner
property_product_pricelist_label varchar2 This pricelist will be used, instead of the default one, for sales to the current partner
property_purchase_currency_id varchar2 This currency will be used, instead of the default one, for purchases from the current partner
property_purchase_currency_id_label varchar2 This currency will be used, instead of the default one, for purchases from the current partner
property_stock_customer varchar2 The stock location used as destination when sending goods to this contact.
property_stock_customer_label varchar2 The stock location used as destination when sending goods to this contact.
property_stock_supplier varchar2 The stock location used as source when receiving goods from this contact.
property_stock_supplier_label varchar2 The stock location used as source when receiving goods from this contact.
property_supplier_payment_term_id varchar2 This payment term will be used instead of the default one for purchase orders and vendor bills
property_supplier_payment_term_id_label varchar2 This payment term will be used instead of the default one for purchase orders and vendor bills
property_ups_carrier_account varchar2 UPS Account Number
purchase_line_ids varchar2
purchase_order_count int32 Purchase Order Count
purchase_warn varchar2 Purchase Order Selecting the "Warning" option will notify user with the message, Selecting "Blocking Message" will throw an exception with the message and block the flow. The Message has to be written in the next field.
purchase_warn_msg varchar2 Message for Purchase Order
receipt_reminder_email boolean Receipt Reminder Automatically send a confirmation email to the vendor X days before the expected receipt date, asking him to confirm the exact date.
ref varchar2 Reference
ref_company_ids varchar2
registration_ids varchar2
reminder_date_before_receipt int32 Days Before Receipt Number of days to send reminder email before the promised receipt date
sale_order_count int32 Sale Order Count
sale_order_ids varchar2
sale_warn varchar2 Sales Warnings Selecting the "Warning" option will notify user with the message, Selecting "Blocking Message" will throw an exception with the message and block the flow. The Message has to be written in the next field.
sale_warn_msg varchar2 Message for Sales Order
same_company_registry_partner_id varchar2
same_company_registry_partner_id_label varchar2
same_vat_partner_id varchar2
same_vat_partner_id_label varchar2
sanitized_mobile varchar2 Mobile number sanitized
sanitized_phone varchar2 Phone number sanitized
self varchar2
self_label varchar2
seo_name varchar2 Seo name
show_credit_limit boolean Show Credit Limit
signature_count int32 # Signatures
signup_expiration datetime Signup Expiration
signup_token varchar2 Signup Token
signup_type varchar2 Signup Token Type
signup_url varchar2 Signup URL
signup_valid boolean Signup Token is Valid
sla_ids varchar2 SLA Policies that will automatically apply to the tickets submitted by this customer.
slide_channel_company_count int32 Company Course Count
slide_channel_completed_ids varchar2
slide_channel_count int32 Course Count
slide_channel_ids varchar2
state_id varchar2
state_id_label varchar2
street varchar2 Street
street2 varchar2 Street2
subscription_count int32 Subscriptions
supplier_invoice_count int32 # Vendor Bills
supplier_rank int32 Supplier Rank
task_count int32 # Tasks
task_ids varchar2
team_id varchar2 If set, this Sales Team will be used for sales and assignments related to this partner
team_id_label varchar2 If set, this Sales Team will be used for sales and assignments related to this partner
ticket_count int32 Tickets
title varchar2
title_label varchar2
total_due numeric Total Due
total_invoiced numeric Total Invoiced
total_overdue numeric Total Overdue
trust varchar2 Degree of trust you have in this debtor
type varchar2 Address Type - Contact: Use this to organize the contact details of employees of a given company (e.g. CEO, CFO, ...). - Invoice Address : Preferred address for all invoices. Selected by default when you invoice an order that belongs to this company. - Delivery Address : Preferred address for all deliveries. Selected by default when you deliver an order that belongs to this company. - Private: Private addresses are only visible by authorized users and contain sensitive data (employee home addresses, ...). - Other: Other address for the company (e.g. subsidiary, ...)
tz varchar2 Timezone When printing documents and exporting/importing data, time values are computed according to this timezone. If the timezone is not set, UTC (Coordinated Universal Time) is used. Anywhere else, time values are computed according to the time offset of your web client.
tz_offset varchar2 Timezone offset
unpaid_invoice_ids varchar2
unpaid_invoices_count int32 Unpaid Invoices Count
unreconciled_aml_ids varchar2
use_partner_credit_limit boolean Partner Limit
user_id varchar2 The internal user in charge of this contact.
user_id_label varchar2 The internal user in charge of this contact.
user_ids varchar2
user_livechat_username varchar2 User Livechat Username
vat varchar2 Tax ID The Tax Identification Number. Values here will be validated based on the country format. You can use '/' to indicate that the partner is not subject to tax.
vies_failed_message varchar2 Technical field display a message to the user if the VIES check fails.
visitor_ids varchar2
website varchar2 Website Link
website_description varchar2 Website Partner Full Description
website_id varchar2 Restrict publishing to this website.
website_id_label varchar2 Restrict publishing to this website.
website_message_ids varchar2 Website communication history
website_meta_description varchar2 Website meta description
website_meta_keywords varchar2 Website meta keywords
website_meta_og_img varchar2 Website opengraph image
website_meta_title varchar2 Website meta title
website_published boolean Visible on current website
website_short_description varchar2 Website Partner Short Description
website_url varchar2 Website URL The full URL to access the document through the website.
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2
zip varchar2 Zip

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: