Please enable JavaScript to view this site.

Made in EU
Odoo Forums

Navigation: Schema: res > Tables

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.

email

string

Email

 

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

X

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

  • Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
  • Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
  • Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
  • Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
  • Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
  • Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
  • Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
  • Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

  
Disclaimer