res_company

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('res_company_id_seq'::regclass)
account_account.company_id account_account_company_id_fkey R
account_accrued_orders_wizard.company_id account_accrued_orders_wizard_company_id_fkey N
account_analytic_account.company_id account_analytic_account_company_id_fkey N
account_analytic_applicability.company_id account_analytic_applicability_company_id_fkey N
account_analytic_distribution_model.company_id account_analytic_distribution_model_company_id_fkey C
account_analytic_line.company_id account_analytic_line_company_id_fkey R
account_automatic_entry_wizard.company_id account_automatic_entry_wizard_company_id_fkey C
account_bank_statement.company_id account_bank_statement_company_id_fkey N
account_financial_year_op.company_id account_financial_year_op_company_id_fkey C
account_fiscal_position.company_id account_fiscal_position_company_id_fkey R
account_fiscal_position_account.company_id account_fiscal_position_account_company_id_fkey N
account_fiscal_position_tax.company_id account_fiscal_position_tax_company_id_fkey N
account_group.company_id account_group_company_id_fkey R
account_journal.company_id account_journal_company_id_fkey R
account_journal_group.company_id account_journal_group_company_id_fkey R
account_move.company_id account_move_company_id_fkey N
account_move_line.company_id account_move_line_company_id_fkey N
account_move_reversal.company_id account_move_reversal_company_id_fkey C
account_move_send.company_id account_move_send_company_id_fkey N
account_partial_reconcile.company_id account_partial_reconcile_company_id_fkey N
account_payment_register.company_id account_payment_register_company_id_fkey N
account_payment_term.company_id account_payment_term_company_id_fkey N
account_reconcile_model.company_id account_reconcile_model_company_id_fkey R
account_reconcile_model_line.company_id account_reconcile_model_line_company_id_fkey N
account_report_external_value.company_id account_report_external_value_company_id_fkey R
account_tax.company_id account_tax_company_id_fkey R
account_tax_group.company_id account_tax_group_company_id_fkey R
account_tax_repartition_line.company_id account_tax_repartition_line_company_id_fkey N
base_document_layout.company_id base_document_layout_company_id_fkey C
crm_team.company_id crm_team_company_id_fkey N
digest_digest.company_id digest_digest_company_id_fkey N
iap_account_res_company_rel.res_company_id iap_account_res_company_rel_res_company_id_fkey C
ir_attachment.company_id ir_attachment_company_id_fkey N
ir_default.company_id ir_default_company_id_fkey C
ir_property.company_id ir_property_company_id_fkey N
ir_sequence.company_id ir_sequence_company_id_fkey N
mail_activity_plan.company_id mail_activity_plan_company_id_fkey N
mail_compose_message.record_company_id mail_compose_message_record_company_id_fkey N
mail_message.record_company_id mail_message_record_company_id_fkey N
mrp_bom.company_id mrp_bom_company_id_fkey N
mrp_bom_byproduct.company_id mrp_bom_byproduct_company_id_fkey N
mrp_bom_line.company_id mrp_bom_line_company_id_fkey N
mrp_production.company_id mrp_production_company_id_fkey R
mrp_unbuild.company_id mrp_unbuild_company_id_fkey R
mrp_workcenter.company_id mrp_workcenter_company_id_fkey N
mrp_workcenter_productivity.company_id mrp_workcenter_productivity_company_id_fkey R
onboarding_progress.company_id onboarding_progress_company_id_fkey C
onboarding_progress_step.company_id onboarding_progress_step_company_id_fkey C
payment_provider.company_id payment_provider_company_id_fkey R
payment_token.company_id payment_token_company_id_fkey N
payment_transaction.company_id payment_transaction_company_id_fkey N
product_packaging.company_id product_packaging_company_id_fkey N
product_pricelist.company_id product_pricelist_company_id_fkey N
product_pricelist_item.company_id product_pricelist_item_company_id_fkey N
product_replenish.company_id product_replenish_company_id_fkey N
product_supplierinfo.company_id product_supplierinfo_company_id_fkey N
product_template.company_id product_template_company_id_fkey N
purchase_order.company_id purchase_order_company_id_fkey R
purchase_order_line.company_id purchase_order_line_company_id_fkey N
res_company.parent_id res_company_parent_id_fkey N
res_company_users_rel.cid res_company_users_rel_cid_fkey C
res_config_settings.company_id res_config_settings_company_id_fkey C
res_currency_rate.company_id res_currency_rate_company_id_fkey N
res_partner.company_id res_partner_company_id_fkey N
res_partner_bank.company_id res_partner_bank_company_id_fkey N
res_users.company_id res_users_company_id_fkey R
resource_calendar.company_id resource_calendar_company_id_fkey N
resource_calendar_leaves.company_id resource_calendar_leaves_company_id_fkey N
resource_resource.company_id resource_resource_company_id_fkey N
sale_advance_payment_inv.company_id sale_advance_payment_inv_company_id_fkey N
sale_order.company_id sale_order_company_id_fkey R
sale_order_line.company_id sale_order_line_company_id_fkey N
sale_order_template.company_id sale_order_template_company_id_fkey N
sale_order_template_line.company_id sale_order_template_line_company_id_fkey N
sale_order_template_option.company_id sale_order_template_option_company_id_fkey N
snailmail_letter.company_id snailmail_letter_company_id_fkey R
stock_location.company_id stock_location_company_id_fkey N
stock_lot.company_id stock_lot_company_id_fkey R
stock_move.company_id stock_move_company_id_fkey R
stock_move_line.company_id stock_move_line_company_id_fkey R
stock_package_level.company_id stock_package_level_company_id_fkey R
stock_package_type.company_id stock_package_type_company_id_fkey N
stock_picking.company_id stock_picking_company_id_fkey N
stock_picking_type.company_id stock_picking_type_company_id_fkey R
stock_putaway_rule.company_id stock_putaway_rule_company_id_fkey R
stock_quant.company_id stock_quant_company_id_fkey N
stock_quant_package.company_id stock_quant_package_company_id_fkey N
stock_route.company_id stock_route_company_id_fkey N
stock_rule.company_id stock_rule_company_id_fkey N
stock_scrap.company_id stock_scrap_company_id_fkey R
stock_storage_category.company_id stock_storage_category_company_id_fkey N
stock_valuation_layer.company_id stock_valuation_layer_company_id_fkey R
stock_valuation_layer_revaluation.company_id stock_valuation_layer_revaluation_company_id_fkey C
stock_warehouse.company_id stock_warehouse_company_id_fkey R
stock_warehouse_orderpoint.company_id stock_warehouse_orderpoint_company_id_fkey R
utm_campaign.company_id utm_campaign_company_id_fkey N
name varchar 2147483647 null
partner_id int4 10 null
res_partner.id res_company_partner_id_fkey R
currency_id int4 10 null
res_currency.id res_company_currency_id_fkey R
sequence int4 10 √ null
create_date timestamp 29,6 √ null
parent_path varchar 2147483647 √ null
parent_id int4 10 √ null
res_company.id res_company_parent_id_fkey N

Parent Company
paperformat_id int4 10 √ null
report_paperformat.id res_company_paperformat_id_fkey N

Paper format
external_report_layout_id int4 10 √ null
ir_ui_view.id res_company_external_report_layout_id_fkey N

Document Template
create_uid int4 10 √ null
res_users.id res_company_create_uid_fkey N

Created by
write_uid int4 10 √ null
res_users.id res_company_write_uid_fkey N

Last Updated by
email varchar 2147483647 √ null

Email
phone varchar 2147483647 √ null

Phone
mobile varchar 2147483647 √ null

Mobile
font varchar 2147483647 √ null

Font
primary_color varchar 2147483647 √ null

Primary Color
secondary_color varchar 2147483647 √ null

Secondary Color
layout_background varchar 2147483647 null

Layout Background
report_header jsonb 2147483647 √ null

Company Tagline
report_footer jsonb 2147483647 √ null

Report Footer
company_details jsonb 2147483647 √ null

Company Details
active bool 1 √ null

Active
bool 1 √ null

Uses Default Logo
write_date timestamp 29,6 √ null

Last Updated on
logo_web bytea 2147483647 √ null

Logo Web
nomenclature_id int4 10 √ null
barcode_nomenclature.id res_company_nomenclature_id_fkey N

Nomenclature
resource_calendar_id int4 10 √ null
resource_calendar.id res_company_resource_calendar_id_fkey R

Default Working Hours
alias_domain_id int4 10 √ null
mail_alias_domain.id res_company_alias_domain_id_fkey N

Email Domain
alias_domain_name varchar 2147483647 √ null

Alias Domain Name
email_primary_color varchar 2147483647 √ null

Email Header Color
email_secondary_color varchar 2147483647 √ null

Email Button Color
partner_gid int4 10 √ null

Company database ID
iap_enrich_auto_done bool 1 √ null

Enrich Done
snailmail_color bool 1 √ null

Snailmail Color
snailmail_cover bool 1 √ null

Add a Cover Page
snailmail_duplex bool 1 √ null

Both sides
payment_onboarding_payment_method varchar 2147483647 √ null

Selected onboarding payment method
fiscalyear_last_day int4 10 null

Fiscalyear Last Day
transfer_account_id int4 10 √ null
account_account.id res_company_transfer_account_id_fkey N

Inter-Banks Transfer Account
default_cash_difference_income_account_id int4 10 √ null
account_account.id res_company_default_cash_difference_income_account_id_fkey N

Cash Difference Income
default_cash_difference_expense_account_id int4 10 √ null
account_account.id res_company_default_cash_difference_expense_account_id_fkey N

Cash Difference Expense
account_journal_suspense_account_id int4 10 √ null
account_account.id res_company_account_journal_suspense_account_id_fkey N

Journal Suspense Account
account_journal_payment_debit_account_id int4 10 √ null
account_account.id res_company_account_journal_payment_debit_account_id_fkey N

Journal Outstanding Receipts
account_journal_payment_credit_account_id int4 10 √ null
account_account.id res_company_account_journal_payment_credit_account_id_fkey N

Journal Outstanding Payments
account_journal_early_pay_discount_gain_account_id int4 10 √ null
account_account.id res_company_account_journal_early_pay_discount_gain_accoun_fkey N

Cash Discount Write-Off Gain Account
account_journal_early_pay_discount_loss_account_id int4 10 √ null
account_account.id res_company_account_journal_early_pay_discount_loss_accoun_fkey N

Cash Discount Write-Off Loss Account
account_sale_tax_id int4 10 √ null
account_tax.id res_company_account_sale_tax_id_fkey N

Default Sale Tax
account_purchase_tax_id int4 10 √ null
account_tax.id res_company_account_purchase_tax_id_fkey N

Default Purchase Tax
currency_exchange_journal_id int4 10 √ null
account_journal.id res_company_currency_exchange_journal_id_fkey N

Exchange Gain or Loss Journal
income_currency_exchange_account_id int4 10 √ null
account_account.id res_company_income_currency_exchange_account_id_fkey N

Gain Exchange Rate Account
expense_currency_exchange_account_id int4 10 √ null
account_account.id res_company_expense_currency_exchange_account_id_fkey N

Loss Exchange Rate Account
incoterm_id int4 10 √ null
account_incoterms.id res_company_incoterm_id_fkey N

Default incoterm
account_opening_move_id int4 10 √ null
account_move.id res_company_account_opening_move_id_fkey N

Opening Journal Entry
account_default_pos_receivable_account_id int4 10 √ null
account_account.id res_company_account_default_pos_receivable_account_id_fkey N

Default PoS Receivable Account
expense_accrual_account_id int4 10 √ null
account_account.id res_company_expense_accrual_account_id_fkey N

Expense Accrual Account
revenue_accrual_account_id int4 10 √ null
account_account.id res_company_revenue_accrual_account_id_fkey N

Revenue Accrual Account
automatic_entry_default_journal_id int4 10 √ null
account_journal.id res_company_automatic_entry_default_journal_id_fkey N

Automatic Entry Default Journal
account_fiscal_country_id int4 10 √ null
res_country.id res_company_account_fiscal_country_id_fkey N

Fiscal Country
tax_cash_basis_journal_id int4 10 √ null
account_journal.id res_company_tax_cash_basis_journal_id_fkey N

Cash Basis Journal
account_cash_basis_base_account_id int4 10 √ null
account_account.id res_company_account_cash_basis_base_account_id_fkey N

Base Tax Received Account
account_discount_income_allocation_id int4 10 √ null
account_account.id res_company_account_discount_income_allocation_id_fkey N

Separate account for income discount
account_discount_expense_allocation_id int4 10 √ null
account_account.id res_company_account_discount_expense_allocation_id_fkey N

Separate account for expense discount
fiscalyear_last_month varchar 2147483647 null

Fiscalyear Last Month
chart_template varchar 2147483647 √ null

Chart Template
bank_account_code_prefix varchar 2147483647 √ null

Prefix of the bank accounts
cash_account_code_prefix varchar 2147483647 √ null

Prefix of the cash accounts
transfer_account_code_prefix varchar 2147483647 √ null

Prefix of the transfer accounts
tax_calculation_rounding_method varchar 2147483647 √ null

Tax Calculation Rounding Method
terms_type varchar 2147483647 √ null

Terms & Conditions format
quick_edit_mode varchar 2147483647 √ null

Quick encoding
period_lock_date date 13 √ null

Journals Entries Lock Date
fiscalyear_lock_date date 13 √ null

All Users Lock Date
tax_lock_date date 13 √ null

Tax Return Lock Date
account_opening_date date 13 null

Opening Entry
invoice_terms jsonb 2147483647 √ null

Default Terms and Conditions
invoice_terms_html jsonb 2147483647 √ null

Default Terms and Conditions as a Web page
expects_chart_of_accounts bool 1 √ null

Expects a Chart of Accounts
anglo_saxon_accounting bool 1 √ null

Use anglo-saxon accounting
qr_code bool 1 √ null

Display QR-code on invoices
invoice_is_email bool 1 √ null

Email by default
invoice_is_download bool 1 √ null

Download by default
display_invoice_amount_total_words bool 1 √ null

Total amount of invoice in letters
account_use_credit_limit bool 1 √ null

Sales Credit Limit
tax_exigibility bool 1 √ null

Use Cash Basis
account_storno bool 1 √ null

Storno accounting
internal_transit_location_id int4 10 √ null
stock_location.id res_company_internal_transit_location_id_fkey R

Internal Transit Location
stock_mail_confirmation_template_id int4 10 √ null
mail_template.id res_company_stock_mail_confirmation_template_id_fkey N

Email Template confirmation picking
annual_inventory_day int4 10 √ null

Day of the month
annual_inventory_month varchar 2147483647 √ null

Annual Inventory Month
stock_move_email_validation bool 1 √ null

Email Confirmation picking
invoice_is_ubl_cii bool 1 √ null

Generate Peppol format by default
manufacturing_lead float8 17,17 null

Manufacturing Lead Time
po_lock varchar 2147483647 √ null

Purchase Order Modification
po_double_validation varchar 2147483647 √ null

Levels of Approvals
po_double_validation_amount numeric 0 √ null

Double validation amount
po_lead float8 17,17 null

Purchase Lead Time
invoice_is_snailmail bool 1 √ null

Send by Post
stock_sms_confirmation_template_id int4 10 √ null
sms_template.id res_company_stock_sms_confirmation_template_id_fkey N

SMS Template
stock_move_sms_validation bool 1 √ null

SMS Confirmation
has_received_warning_stock_sms bool 1 √ null

Has Received Warning Stock Sms
days_to_purchase float8 17,17 √ null

Days to Purchase
quotation_validity_days int4 10 √ null

Default Quotation Validity
sale_discount_product_id int4 10 √ null
product_product.id res_company_sale_discount_product_id_fkey N

Discount Product
sale_down_payment_product_id int4 10 √ null
product_product.id res_company_sale_down_payment_product_id_fkey N

Deposit Product
sale_onboarding_payment_method varchar 2147483647 √ null

Sale onboarding selected payment method
portal_confirmation_sign bool 1 √ null

Online Signature
portal_confirmation_pay bool 1 √ null

Online Payment
prepayment_percent float8 17,17 √ null

Prepayment percentage
sale_order_template_id int4 10 √ null
sale_order_template.id res_company_sale_order_template_id_fkey N

Default Sale Template
security_lead float8 17,17 null

Sales Safety Days
sale_header_name varchar 2147483647 √ null

Sale Header Name
sale_footer_name varchar 2147483647 √ null

Sale Footer Name
account_check_printing_layout varchar 2147483647 √ null

Check Layout
account_check_printing_date_label bool 1 √ null

Print Date Label
account_check_printing_multi_stub bool 1 √ null

Multi-Pages Check Stub
account_check_printing_margin_top float8 17,17 √ null

Check Top Margin
account_check_printing_margin_left float8 17,17 √ null

Check Left Margin
account_check_printing_margin_right float8 17,17 √ null

Right Margin

Indexes

Constraint Name Type Sort Column(s)
res_company_pkey Primary key Asc id
res_company__parent_id_index Performance Asc parent_id
res_company__parent_path_index Performance Asc parent_path
res_company_name_uniq Must be unique Asc name

Check Constraints

Constraint Name Constraint
res_company_check_quotation_validity_days ((quotation_validity_days >= 0))

Relationships

Close relationships within degrees of separation