Please enable JavaScript to view this site.

Made in EU
Odoo Forums

Navigation: Schema: res > Tables

company

Companies

Catalog: Odoo

Schema: res

Documentation:

Populate factory part for the accountings applications of res.company.

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 company are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

account_cash_basis_base_account_id_label

string

 

Account that will be set on lines created in cash basis journal entry and used to keep track of the tax base amount.

account_cash_basis_base_account_id

string

 

Account that will be set on lines created in cash basis journal entry and used to keep track of the tax base amount.

account_consolidation_currency_is_different

boolean

Account Consolidation Currency Is Different

 

account_dashboard_onboarding_state

string

State of the account dashboard onboarding panel

 

account_default_pos_receivable_account_id_label

string

 

 

account_default_pos_receivable_account_id

string

 

 

account_display_representative_field

boolean

Account Display Representative Field

 

account_enabled_tax_country_ids

string

 

Technical field containing the countries for which this company is using tax-related features(hence the ones for which l10n modules need to show tax-related fields).

account_fiscal_country_id_label

string

 

The country to use the tax reports from for this company

account_fiscal_country_id

string

 

The country to use the tax reports from for this company

account_folder_label

string

 

 

account_folder

string

 

 

account_invoice_onboarding_state

string

State of the account invoice onboarding panel

 

account_journal_early_pay_discount_gain_account_id_label

string

 

 

account_journal_early_pay_discount_gain_account_id

string

 

 

account_journal_early_pay_discount_loss_account_id_label

string

 

 

account_journal_early_pay_discount_loss_account_id

string

 

 

account_journal_payment_credit_account_id_label

string

 

 

account_journal_payment_credit_account_id

string

 

 

account_journal_payment_debit_account_id_label

string

 

 

account_journal_payment_debit_account_id

string

 

 

account_journal_suspense_account_id_label

string

 

 

account_journal_suspense_account_id

string

 

 

account_onboarding_create_invoice_state_flag

boolean

Account Onboarding Create Invoice State Flag

 

account_onboarding_create_invoice_state

string

State of the onboarding create invoice step

 

account_onboarding_invoice_layout_state

string

State of the onboarding invoice layout step

 

account_onboarding_sale_tax_state

string

State of the onboarding sale tax step

 

account_opening_date

datetime

Opening Entry

That is the date of the opening entry.

account_opening_journal_id_label

string

 

Journal where the opening entry of this company's accounting has been posted.

account_opening_journal_id

string

 

Journal where the opening entry of this company's accounting has been posted.

account_opening_move_id_label

string

 

The journal entry containing the initial balance of all this company's accounts.

account_opening_move_id

string

 

The journal entry containing the initial balance of all this company's accounts.

account_purchase_tax_id_label

string

 

 

account_purchase_tax_id

string

 

 

account_representative_id_label

string

 

Specify an Accounting Firm that will act as a representative when exporting reports.

account_representative_id

string

 

Specify an Accounting Firm that will act as a representative when exporting reports.

account_revaluation_expense_provision_account_id_label

string

 

 

account_revaluation_expense_provision_account_id

string

 

 

account_revaluation_income_provision_account_id_label

string

 

 

account_revaluation_income_provision_account_id

string

 

 

account_revaluation_journal_id_label

string

 

 

account_revaluation_journal_id

string

 

 

account_sale_tax_id_label

string

 

 

account_sale_tax_id

string

 

 

account_setup_bank_data_state

string

State of the onboarding bank data step

 

account_setup_bill_state

string

State of the onboarding bill step

 

account_setup_coa_state

string

State of the onboarding charts of account step

 

account_setup_fy_data_state

string

State of the onboarding fiscal year step

 

account_setup_taxes_state

string

State of the onboarding Taxes step

 

account_storno

boolean

Storno accounting

 

account_tax_periodicity_journal_id_label

string

 

 

account_tax_periodicity_journal_id

string

 

 

account_tax_periodicity_reminder_day

int32

Start from

 

account_tax_periodicity

string

Delay units

Periodicity

account_tax_unit_ids

string

 

The tax units this company belongs to.

account_use_credit_limit

boolean

Sales Credit Limit

Enable the use of credit limit on partners.

active

boolean

Active

 

analytic_plan_id_label

string

 

Default Plan for a new analytic account for projects

analytic_plan_id

string

 

Default Plan for a new analytic account for projects

anglo_saxon_accounting

boolean

Use anglo-saxon accounting

 

annual_inventory_day

int32

Day of the month

Day of the month when the annual inventory should occur. If zero or negative, then the first day of the month will be selected instead.If greater than the last day of a month, then the last day of the month will be selected instead.

annual_inventory_month

string

Annual Inventory Month

Annual inventory month for products not in a location with a cyclic inventory date. Set to no month if no automatic annual inventory.

appraisal_confirm_mail_template_label

string

 

 

appraisal_confirm_mail_template

string

 

 

appraisal_employee_feedback_template

string

Appraisal Employee Feedback Template

 

appraisal_manager_feedback_template

string

Appraisal Manager Feedback Template

 

appraisal_plan

boolean

Automatically Generate Appraisals

 

assessment_note_ids

string

 

 

attendance_barcode_source

string

Barcode Source

 

attendance_kiosk_delay

int32

Attendance Kiosk Delay

 

attendance_kiosk_mode

string

Attendance Mode

 

automatic_entry_default_journal_id_label

string

 

Journal used by default for moving the period of an entry

automatic_entry_default_journal_id

string

 

Journal used by default for moving the period of an entry

background_image

byte[]

Home Menu Background Image

 

bank_account_code_prefix

string

Prefix of the bank accounts

 

bank_ids

string

 

 

bank_journal_ids

string

 

 

base_onboarding_company_state

string

State of the onboarding company step

 

cash_account_code_prefix

string

Prefix of the cash accounts

 

catchall_email

string

Catchall Email

 

catchall_formatted

string

Catchall

 

chart_template_id_label

string

 

The chart template for the company (if any)

chart_template_id

string

 

The chart template for the company (if any)

child_ids

string

 

 

city

string

City

 

company_details

string

Company Details

Header text displayed at the top of all reports.

company_expense_journal_id_label

string

 

The company's default journal used when a company expense is created.

company_expense_journal_id

string

 

The company's default journal used when a company expense is created.

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

consolidation_color

int32

Accounts color

 

consolidation_create_period_state

string

State Of The Onboarding Create Period Step

 

consolidation_dashboard_onboarding_state

string

State Of The Account Consolidation Dashboard Onboarding Panel

 

consolidation_setup_ccoa_state

string

State Of The Onboarding Consolidated Chart Of Account Step

 

consolidation_setup_consolidation_state

string

State Of The Onboarding Consolidation Step

 

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

 

 

currency_exchange_journal_id_label

string

 

 

currency_exchange_journal_id

string

 

 

currency_id_label

string

 

 

currency_id

string

 

 

currency_interval_unit

string

Interval Unit

 

currency_next_execution_date

datetime

Next Execution Date

 

currency_provider

string

Service Provider

 

days_to_purchase

decimal

Days to Purchase

Days needed to confirm a PO, define when a PO should be validated

default_cash_difference_expense_account_id_label

string

 

 

default_cash_difference_expense_account_id

string

 

 

default_cash_difference_income_account_id_label

string

 

 

default_cash_difference_income_account_id

string

 

 

deferred_time_off_manager_label

string

 

 

deferred_time_off_manager

string

 

 

display_name

string

Display Name

 

documents_account_settings

boolean

Documents Account Settings

 

documents_fleet_folder_label

string

 

 

documents_fleet_folder

string

 

 

documents_fleet_settings

boolean

Documents Fleet Settings

 

documents_fleet_tags

string

 

 

documents_hr_contracts_tags

string

 

 

documents_hr_folder_label

string

 

 

documents_hr_folder

string

 

 

documents_hr_payslips_tags

string

 

 

documents_hr_settings

boolean

Documents Hr Settings

 

documents_payroll_folder_id_label

string

 

 

documents_payroll_folder_id

string

 

 

documents_product_settings

boolean

Documents Product Settings

 

documents_recruitment_settings

boolean

Documents Recruitment Settings

 

documents_spreadsheet_folder_id_label

string

 

 

documents_spreadsheet_folder_id

string

 

 

duration_after_recruitment

int32

Create an Appraisal after recruitment

 

duration_first_appraisal

int32

Create a first Appraisal after

 

duration_next_appraisal

int32

Create a second Appraisal after

 

early_pay_discount_computation

string

Cash Discount Tax Reduction

 

email_formatted

string

Formatted Email

 

email

string

Email

 

expects_chart_of_accounts

boolean

Expects a Chart of Accounts

 

expense_accrual_account_id_label

string

 

Account used to move the period of an expense

expense_accrual_account_id

string

 

Account used to move the period of an expense

expense_currency_exchange_account_id_label

string

 

 

expense_currency_exchange_account_id

string

 

 

expense_extract_show_ocr_option_selection

string

Send mode on expense attachments

 

expense_journal_id_label

string

 

The company's default journal used when an employee expense is created.

expense_journal_id

string

 

The company's default journal used when an employee expense is created.

external_report_layout_id_label

string

 

 

external_report_layout_id

string

 

 

extra_day

decimal

Per Day

 

extra_hour

decimal

Per Hour

 

extra_product_label

string

 

The product is used to add the cost to the sales order

extra_product

string

 

The product is used to add the cost to the sales order

extract_in_invoice_digitalization_mode

string

Digitization mode on vendor bills

 

extract_out_invoice_digitalization_mode

string

Digitization mode on customer invoices

 

extract_single_line_per_tax

boolean

Single Invoice Line Per Tax

 

favicon

byte[]

Company Favicon

This field holds the image used to display a favicon for a given company.

fiscalyear_last_day

int32

Fiscalyear Last Day

 

fiscalyear_last_month

string

Fiscalyear Last Month

 

fiscalyear_lock_date

datetime

All Users Lock Date

No users, including Advisers, can edit accounts prior to and inclusive of this date. Use it for fiscal year locking for example.

font

string

Font

 

gain_account_id_label

string

 

Account used to write the journal item in case of gain while selling an asset

gain_account_id

string

 

Account used to write the journal item in case of gain while selling an asset

has_message

boolean

Has Message

 

has_received_warning_stock_sms

boolean

Has Received Warning Stock Sms

 

hr_attendance_overtime

boolean

Count Extra Hours

 

hr_presence_control_email_amount

int32

# emails to send

 

hr_presence_control_ip_list

string

Valid IP addresses

 

hr_referral_background

byte[]

Referral Background

 

iap_enrich_auto_done

boolean

Enrich Done

 

id

int32

ID

 

income_currency_exchange_account_id_label

string

 

 

income_currency_exchange_account_id

string

 

 

incoterm_id_label

string

 

International Commercial Terms are a series of predefined commercial terms used in international transactions.

incoterm_id

string

 

International Commercial Terms are a series of predefined commercial terms used in international transactions.

internal_project_id_label

string

 

Default project value for timesheet generated from time off type.

internal_project_id

string

 

Default project value for timesheet generated from time off type.

internal_transit_location_id_label

string

 

 

internal_transit_location_id

string

 

 

invoice_is_email

boolean

Email by default

 

invoice_is_print

boolean

Print by default

 

invoice_is_snailmail

boolean

Send by Post

 

invoice_terms_html

string

Default Terms and Conditions as a Web page

 

invoice_terms

string

Default Terms and Conditions

 

invoicing_switch_threshold

datetime

Invoicing Switch Threshold

Every payment and invoice before this date will receive the 'From Invoicing' status, hiding all the accounting entries related to it. Use this option after installing Accounting if you were using only Invoicing before, before importing all your actual accounting data in to Odoo.

l10n_nl_kvk

string

KVK-nummer

 

l10n_nl_oin

string

Organisatie Indentificatie Nummer

 

layout_background_image

byte[]

Background Image

 

layout_background

string

Layout Background

 

leave_timesheet_task_id_label

string

 

 

leave_timesheet_task_id

string

 

 

logo_web

byte[]

Logo Web

 

logo

byte[]

Company Logo

 

loss_account_id_label

string

 

Account used to write the journal item in case of loss while selling an asset

loss_account_id

string

 

Account used to write the journal item in case of loss while selling an asset

lunch_minimum_threshold

decimal

Lunch Minimum Threshold

 

lunch_notify_message

string

Lunch Notify Message

 

manufacturing_lead

decimal

Manufacturing Lead Time

Security days for each manufacturing operation.

message_attachment_count

int32

Attachment Count

 

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

 

 

min_extra_hour

int32

Minimum delay time before applying fines.

 

mobile

string

Mobile

 

name

string

Company Name

 

nomenclature_id_label

string

 

 

nomenclature_id

string

 

 

overtime_company_threshold

int32

Tolerance Time In Favor Of Company

 

overtime_employee_threshold

int32

Tolerance Time In Favor Of Employee

 

overtime_start_date

datetime

Extra Hours Starting Date

 

padding_time

decimal

Padding Time

Amount of time (in hours) during which a product is considered unavailable prior to renting (preparation time).

paperformat_id_label

string

 

 

paperformat_id

string

 

 

parent_id_label

string

 

 

parent_id

string

 

 

partner_gid

int32

Company database ID

 

partner_id_label

string

 

 

partner_id

string

 

 

payment_onboarding_payment_method

string

Selected onboarding payment method

 

payment_provider_onboarding_state

string

State of the onboarding payment provider step

 

period_lock_date

datetime

Journals Entries Lock Date

Only users with the 'Adviser' role can edit accounts prior to and inclusive of this date. Use it for period locking inside an open fiscal year, for example.

phone

string

Phone

 

planning_allow_self_unassign

boolean

Can Employee Un-Assign Themselves?

 

planning_generation_interval

int32

Rate Of Shift Generation

 

planning_self_unassign_days_before

int32

Days before shift for unassignment

Deadline in days for shift unassignment

po_double_validation_amount

decimal

Double validation amount

Minimum amount for which a double validation is required

po_double_validation

string

Levels of Approvals

Provide a double validation mechanism for purchases

po_lead

decimal

Purchase Lead Time

Margin of error for vendor lead times. When the system generates Purchase Orders for procuring products, they will be scheduled that many days earlier to cope with unexpected vendor delays.

po_lock

string

Purchase Order Modification

Purchase Order Modification used when you want to purchase order editable after confirm

point_of_sale_update_stock_quantities

string

Update quantities in stock

At the session closing: A picking is created for the entire session when it's closedIn real time: Each order sent to the server create its own picking

point_of_sale_use_ticket_qr_code

boolean

Use QR code on ticket

Add a QR code on the ticket, which the user can scan to request the invoice linked to its order.

portal_confirmation_pay

boolean

Online Payment

 

portal_confirmation_sign

boolean

Online Signature

 

predict_bill_product

boolean

Predict Bill Product

 

primary_color

string

Primary Color

 

product_folder_label

string

 

 

product_folder

string

 

 

product_tags

string

 

 

project_time_mode_id_label

string

 

This will set the unit of measure used in projects and tasks.If you use the timesheet linked to projects, don't forget to setup the right unit of measure in your employees.

project_time_mode_id

string

 

This will set the unit of measure used in projects and tasks.If you use the timesheet linked to projects, don't forget to setup the right unit of measure in your employees.

property_stock_account_input_categ_id_label

string

 

 

property_stock_account_input_categ_id

string

 

 

property_stock_account_output_categ_id_label

string

 

 

property_stock_account_output_categ_id

string

 

 

property_stock_valuation_account_id_label

string

 

 

property_stock_valuation_account_id

string

 

 

qr_code

boolean

Display QR-code on invoices

 

quick_edit_mode

string

Quick encoding

 

quotation_validity_days

int32

Default Quotation Validity (Days)

 

recruitment_extract_show_ocr_option_selection

string

Send mode on applicant attachments

 

recruitment_folder_id_label

string

 

 

recruitment_folder_id

string

 

 

recruitment_tag_ids

string

 

 

rental_loc_id_label

string

 

This technical location serves as stock for products currently in rentalThis location is internal because products in rentalare still considered as company assets.

rental_loc_id

string

 

This technical location serves as stock for products currently in rentalThis location is internal because products in rentalare still considered as company assets.

renting_forbidden_fri

boolean

Friday

 

renting_forbidden_mon

boolean

Monday

 

renting_forbidden_sat

boolean

Saturday

 

renting_forbidden_sun

boolean

Sunday

 

renting_forbidden_thu

boolean

Thursday

 

renting_forbidden_tue

boolean

Tuesday

 

renting_forbidden_wed

boolean

Wednesday

 

renting_minimal_time_duration

int32

Minimal Rental Duration

 

renting_minimal_time_unit

string

Minimal Rental Duration Unit

 

report_footer

string

Report Footer

Footer text displayed at the bottom of all reports.

report_header

string

Company Tagline

Appears by default on the top right corner of your printed documents (report header).

resource_calendar_id_label

string

 

 

resource_calendar_id

string

 

 

resource_calendar_ids

string

 

 

revenue_accrual_account_id_label

string

 

Account used to move the period of a revenue

revenue_accrual_account_id

string

 

Account used to move the period of a revenue

sale_onboarding_order_confirmation_state

string

State of the onboarding confirmation order step

 

sale_onboarding_payment_method

string

Sale onboarding selected payment method

 

sale_onboarding_sample_quotation_state

string

State of the onboarding sample quotation step

 

sale_order_template_id_label

string

 

 

sale_order_template_id

string

 

 

sale_quotation_onboarding_state

string

State of the sale onboarding panel

 

secondary_color

string

Secondary Color

 

security_lead

decimal

Sales Safety Days

Margin of error for dates promised to customers. Products will be scheduled for procurement and delivery that many days earlier than the actual promised date, to cope with unexpected delays in the supply chain.

sepa_initiating_party_name

string

Your Company Name

Will appear in SEPA payments as the name of the party initiating the payment. Limited to 70 characters.

sepa_orgid_id

string

Identification

Identification assigned by an institution (eg. VAT number).

sepa_orgid_issr

string

Issuer

Entity that assigns the identification (eg. KBE-BCO or Finanzamt Muenchen IV).

sequence

int32

Sequence

Used to order Companies in the company switcher

sign_terms_html

string

Sign Default Terms and Conditions as a Web page

 

sign_terms_type

string

Sign Terms & Conditions format

Terms in Email - The text will be displayed at the bottom of every signature request email.Terms as Web Page - A link will be pasted at the bottom of every signature request email, leading to your content.

sign_terms

string

Sign Default Terms and Conditions

 

snailmail_color

boolean

Color

 

snailmail_cover

boolean

Add a Cover Page

 

snailmail_duplex

boolean

Both sides

 

social_facebook

string

Facebook Account

 

social_github

string

GitHub Account

 

social_instagram

string

Instagram Account

 

social_linkedin

string

LinkedIn Account

 

social_twitter

string

Twitter Account

 

social_youtube

string

Youtube Account

 

state_id_label

string

 

 

state_id

string

 

 

stock_mail_confirmation_template_id_label

string

 

Email sent to the customer once the order is done.

stock_mail_confirmation_template_id

string

 

Email sent to the customer once the order is done.

stock_move_email_validation

boolean

Email Confirmation picking

 

stock_move_sms_validation

boolean

SMS Confirmation

 

stock_sms_confirmation_template_id_label

string

 

SMS sent to the customer once the order is delivered.

stock_sms_confirmation_template_id

string

 

SMS sent to the customer once the order is delivered.

street

string

Street

 

street2

string

Street2

 

tax_calculation_rounding_method

string

Tax Calculation Rounding Method

 

tax_cash_basis_journal_id_label

string

 

 

tax_cash_basis_journal_id

string

 

 

tax_exigibility

boolean

Use Cash Basis

 

tax_lock_date

datetime

Tax Return Lock Date

No users can edit journal entries related to a tax prior and inclusive of this date.

terms_type

string

Terms & Conditions format

 

timesheet_encode_uom_id_label

string

 

 

timesheet_encode_uom_id

string

 

 

timesheet_mail_allow

boolean

Approver Reminder

 

timesheet_mail_delay

int32

Approver Reminder Days

 

timesheet_mail_employee_allow

boolean

Employee Reminder

 

timesheet_mail_employee_delay

int32

Employee Reminder Days

 

timesheet_mail_employee_interval

string

Employee Frequency

 

timesheet_mail_employee_nextdate

datetime

Next scheduled date for employee reminder

 

timesheet_mail_interval

string

Approver Reminder Frequency

 

timesheet_mail_nextdate

datetime

Next scheduled date for approver reminder

 

totals_below_sections

boolean

Add totals below sections

When ticked, totals and subtotals appear below the sections of the report.

transfer_account_code_prefix

string

Prefix of the transfer accounts

 

transfer_account_id_label

string

 

Intermediary account used when moving money from a liqity account to another

transfer_account_id

string

 

Intermediary account used when moving money from a liqity account to another

user_ids

string

 

 

vat_check_vies

boolean

Verify VAT Numbers

 

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.

website_id_label

string

 

 

website_id

string

 

 

website_message_ids

string

 

Website communication history

website_sale_dashboard_onboarding_state

string

State of the website sale onboarding panel

 

website_sale_onboarding_payment_provider_state

string

State of the website sale onboarding payment provider step

 

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