partner |
Contact
Catalog: Odoo
Schema: res
Documentation:
Update of res.partner class to take into account the livechat username.
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 partner are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
account_represented_company_ids |
string |
|
☐ |
|
active_lang_count |
int32 |
Active Lang Count |
☐ |
|
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 |
|
☐ |
|
additional_info |
string |
Additional info |
☐ |
|
amazon_email |
string |
Amazon Email |
☐ |
The encrypted email of the customer. Does not forward mails. |
avatar_1024 |
byte[] |
Avatar 1024 |
☐ |
|
avatar_128 |
byte[] |
Avatar 128 |
☐ |
|
avatar_1920 |
byte[] |
Avatar |
☐ |
|
avatar_256 |
byte[] |
Avatar 256 |
☐ |
|
avatar_512 |
byte[] |
Avatar 512 |
☐ |
|
bank_account_count |
int32 |
Bank |
☐ |
|
bank_ids |
string |
|
☐ |
|
barcode |
string |
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 numberand 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 |
string |
|
☐ |
|
certifications_company_count |
int32 |
Company Certifications Count |
☐ |
|
certifications_count |
int32 |
Certifications Count |
☐ |
|
channel_ids |
string |
|
☐ |
|
child_ids |
string |
|
☐ |
|
city |
string |
City |
☐ |
|
color |
int32 |
Color Index |
☐ |
|
comment |
string |
Notes |
☐ |
|
commercial_company_name |
string |
Company Name Entity |
☐ |
|
commercial_partner_id_label |
string |
|
☐ |
|
commercial_partner_id |
string |
|
☐ |
|
company_id_label |
string |
|
☐ |
|
company_id |
string |
|
☐ |
|
company_name |
string |
Company Name |
☐ |
|
company_registry |
string |
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 |
string |
Company Type |
☐ |
|
contact_address_complete |
string |
Contact Address Complete |
☐ |
|
contact_address |
string |
Complete Address |
☐ |
|
contract_ids |
string |
|
☐ |
|
country_code |
string |
Country Code |
☐ |
The ISO country code in two chars. You can use this field for quick search. |
country_id_label |
string |
|
☐ |
|
country_id |
string |
|
☐ |
|
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
credit_limit |
decimal |
Credit Limit |
☐ |
Credit limit specific to this partner. |
credit |
decimal |
Total Receivable |
☐ |
Total amount this customer owes you. |
currency_id_label |
string |
|
☐ |
|
currency_id |
string |
|
☐ |
|
customer_rank |
int32 |
Customer Rank |
☐ |
|
date_localization |
datetime |
Geolocation Date |
☐ |
|
date |
datetime |
Date |
☐ |
|
debit_limit |
decimal |
Payable Limit |
☐ |
|
debit |
decimal |
Total Payable |
☐ |
Total amount you have to pay to this vendor. |
display_name |
string |
Display Name |
☐ |
|
document_count |
int32 |
Document Count |
☐ |
|
duplicated_bank_account_partners_count |
int32 |
Duplicated Bank Account Partners Count |
☐ |
|
ebay_id |
string |
eBay User ID |
☐ |
|
email_formatted |
string |
Formatted Email |
☐ |
Format email address "Name <email@domain>" |
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. |
string |
☐ |
|
||
employee_ids |
string |
|
☐ |
Related employees based on their private address |
employee |
boolean |
Employee |
☐ |
Check this box if this contact is an Employee. |
employees_count |
int32 |
Employees Count |
☐ |
|
event_count |
int32 |
# Events |
☐ |
|
fiscal_country_codes |
string |
Fiscal Country Codes |
☐ |
|
followup_line_id_label |
string |
|
☐ |
|
followup_line_id |
string |
|
☐ |
|
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 {current level delay} days- if no level defined at all -> next date never automatically set |
followup_reminder_type |
string |
Reminders |
☐ |
|
followup_responsible_id_label |
string |
|
☐ |
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 |
string |
|
☐ |
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 |
string |
Follow-up Status |
☐ |
|
function |
string |
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 |
string |
IM Status |
☐ |
|
image_1024 |
byte[] |
Image 1024 |
☐ |
|
image_128 |
byte[] |
Image 128 |
☐ |
|
image_1920 |
byte[] |
Image |
☐ |
|
image_256 |
byte[] |
Image 256 |
☐ |
|
image_512 |
byte[] |
Image 512 |
☐ |
|
image_medium |
byte[] |
Medium-sized image |
☐ |
|
industry_id_label |
string |
|
☐ |
|
industry_id |
string |
|
☐ |
|
invoice_ids |
string |
|
☐ |
|
invoice_warn_msg |
string |
Message for Invoice |
☐ |
|
invoice_warn |
string |
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. |
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 |
string |
KVK-nummer |
☐ |
|
l10n_nl_oin |
string |
Organisatie Indentificatie Nummer |
☐ |
|
lang |
string |
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_label |
string |
|
☐ |
|
last_website_so_id |
string |
|
☐ |
|
meeting_count |
int32 |
# Meetings |
☐ |
|
meeting_ids |
string |
|
☐ |
|
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 |
Name |
☐ |
|
ocn_token |
string |
OCN Token |
☐ |
Used for sending notification to registered devices |
on_time_rate |
decimal |
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 |
string |
Online Partner Information |
☐ |
|
opportunity_count |
int32 |
Opportunity |
☐ |
|
opportunity_ids |
string |
|
☐ |
|
parent_id_label |
string |
|
☐ |
|
parent_id |
string |
|
☐ |
|
parent_name |
string |
Parent name |
☐ |
|
partner_gid |
int32 |
Company database ID |
☐ |
|
partner_latitude |
decimal |
Geo Latitude |
☐ |
|
partner_longitude |
decimal |
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 |
string |
|
☐ |
|
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 |
string |
Phone |
☐ |
|
picking_warn_msg |
string |
Message for Stock Picking |
☐ |
|
picking_warn |
string |
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. |
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 |
string |
|
☐ |
|
property_account_payable_id_label |
string |
|
☐ |
This account will be used instead of the default one as the payable account for the current partner |
property_account_payable_id |
string |
|
☐ |
This account will be used instead of the default one as the payable account for the current partner |
property_account_position_id_label |
string |
|
☐ |
The fiscal position determines the taxes/accounts used for this contact. |
property_account_position_id |
string |
|
☐ |
The fiscal position determines the taxes/accounts used for this contact. |
property_account_receivable_id_label |
string |
|
☐ |
This account will be used instead of the default one as the receivable account for the current partner |
property_account_receivable_id |
string |
|
☐ |
This account will be used instead of the default one as the receivable account for the current partner |
property_delivery_carrier_id_label |
string |
|
☐ |
Default delivery method used in sales orders. |
property_delivery_carrier_id |
string |
|
☐ |
Default delivery method used in sales orders. |
property_payment_term_id_label |
string |
|
☐ |
This payment term will be used instead of the default one for sales orders and customer invoices |
property_payment_term_id |
string |
|
☐ |
This payment term will be used instead of the default one for sales orders and customer invoices |
property_product_pricelist_label |
string |
|
☐ |
This pricelist will be used, instead of the default one, for sales to the current partner |
property_product_pricelist |
string |
|
☐ |
This pricelist will be used, instead of the default one, for sales to the current partner |
property_purchase_currency_id_label |
string |
|
☐ |
This currency will be used, instead of the default one, for purchases from the current partner |
property_purchase_currency_id |
string |
|
☐ |
This currency will be used, instead of the default one, for purchases from the current partner |
property_stock_customer_label |
string |
|
☐ |
The stock location used as destination when sending goods to this contact. |
property_stock_customer |
string |
|
☐ |
The stock location used as destination when sending goods to this contact. |
property_stock_supplier_label |
string |
|
☐ |
The stock location used as source when receiving goods from this contact. |
property_stock_supplier |
string |
|
☐ |
The stock location used as source when receiving goods from this contact. |
property_supplier_payment_term_id_label |
string |
|
☐ |
This payment term will be used instead of the default one for purchase orders and vendor bills |
property_supplier_payment_term_id |
string |
|
☐ |
This payment term will be used instead of the default one for purchase orders and vendor bills |
property_ups_carrier_account |
string |
UPS Account Number |
☐ |
|
purchase_line_ids |
string |
|
☐ |
|
purchase_order_count |
int32 |
Purchase Order Count |
☐ |
|
purchase_warn_msg |
string |
Message for Purchase Order |
☐ |
|
purchase_warn |
string |
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. |
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_company_ids |
string |
|
☐ |
|
ref |
string |
Reference |
☐ |
|
registration_ids |
string |
|
☐ |
|
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 |
string |
|
☐ |
|
sale_warn_msg |
string |
Message for Sales Order |
☐ |
|
sale_warn |
string |
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. |
same_company_registry_partner_id_label |
string |
|
☐ |
|
same_company_registry_partner_id |
string |
|
☐ |
|
same_vat_partner_id_label |
string |
|
☐ |
|
same_vat_partner_id |
string |
|
☐ |
|
sanitized_mobile |
string |
Mobile number sanitized |
☐ |
|
sanitized_phone |
string |
Phone number sanitized |
☐ |
|
self_label |
string |
|
☐ |
|
self |
string |
|
☐ |
|
seo_name |
string |
Seo name |
☐ |
|
show_credit_limit |
boolean |
Show Credit Limit |
☐ |
|
signature_count |
int32 |
# Signatures |
☐ |
|
signup_expiration |
datetime |
Signup Expiration |
☐ |
|
signup_token |
string |
Signup Token |
☐ |
|
signup_type |
string |
Signup Token Type |
☐ |
|
signup_url |
string |
Signup URL |
☐ |
|
signup_valid |
boolean |
Signup Token is Valid |
☐ |
|
sla_ids |
string |
|
☐ |
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 |
string |
|
☐ |
|
slide_channel_count |
int32 |
Course Count |
☐ |
|
slide_channel_ids |
string |
|
☐ |
|
state_id_label |
string |
|
☐ |
|
state_id |
string |
|
☐ |
|
street |
string |
Street |
☐ |
|
street2 |
string |
Street2 |
☐ |
|
subscription_count |
int32 |
Subscriptions |
☐ |
|
supplier_invoice_count |
int32 |
# Vendor Bills |
☐ |
|
supplier_rank |
int32 |
Supplier Rank |
☐ |
|
task_count |
int32 |
# Tasks |
☐ |
|
task_ids |
string |
|
☐ |
|
team_id_label |
string |
|
☐ |
If set, this Sales Team will be used for sales and assignments related to this partner |
team_id |
string |
|
☐ |
If set, this Sales Team will be used for sales and assignments related to this partner |
ticket_count |
int32 |
Tickets |
☐ |
|
title_label |
string |
|
☐ |
|
title |
string |
|
☐ |
|
total_due |
decimal |
Total Due |
☐ |
|
total_invoiced |
decimal |
Total Invoiced |
☐ |
|
total_overdue |
decimal |
Total Overdue |
☐ |
|
trust |
string |
Degree of trust you have in this debtor |
☐ |
|
type |
string |
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_offset |
string |
Timezone offset |
☐ |
|
tz |
string |
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. |
unpaid_invoice_ids |
string |
|
☐ |
|
unpaid_invoices_count |
int32 |
Unpaid Invoices Count |
☐ |
|
unreconciled_aml_ids |
string |
|
☐ |
|
use_partner_credit_limit |
boolean |
Partner Limit |
☐ |
|
user_id_label |
string |
|
☐ |
The internal user in charge of this contact. |
user_id |
string |
|
☐ |
The internal user in charge of this contact. |
user_ids |
string |
|
☐ |
|
user_livechat_username |
string |
User Livechat Username |
☐ |
|
vat |
string |
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 |
string |
Technical field display a message to the user if the VIES check fails. |
☐ |
|
visitor_ids |
string |
|
☐ |
|
website_description |
string |
Website Partner Full Description |
☐ |
|
website_id_label |
string |
|
☐ |
Restrict publishing to this website. |
website_id |
string |
|
☐ |
Restrict publishing to this website. |
website_message_ids |
string |
|
☐ |
Website communication history |
website_meta_description |
string |
Website meta description |
☐ |
|
website_meta_keywords |
string |
Website meta keywords |
☐ |
|
website_meta_og_img |
string |
Website opengraph image |
☐ |
|
website_meta_title |
string |
Website meta title |
☐ |
|
website_published |
boolean |
Visible on current website |
☐ |
|
website_short_description |
string |
Website Partner Short Description |
☐ |
|
website_url |
string |
Website URL |
☐ |
The full URL to access the document through the website. |
website |
string |
Website Link |
☐ |
|
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