invantive documentation
Invantive Support ForumsLog In / Sign Up

company: Odoo itgen_odoo_company

read only per partition

  • Catalog: Odoo
  • Schema: res
  • Label: itgen_odoo_company

Companies

Can only retrieve data.

Summary

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

Table Columns

The columns of the table company 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_cash_basis_base_account_id varchar2 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_label varchar2 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 varchar2 State of the account dashboard onboarding panel
account_default_pos_receivable_account_id varchar2
account_default_pos_receivable_account_id_label varchar2
account_display_representative_field boolean Account Display Representative Field
account_enabled_tax_country_ids varchar2 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 varchar2 The country to use the tax reports from for this company
account_fiscal_country_id_label varchar2 The country to use the tax reports from for this company
account_folder varchar2
account_folder_label varchar2
account_invoice_onboarding_state varchar2 State of the account invoice onboarding panel
account_journal_early_pay_discount_gain_account_id varchar2
account_journal_early_pay_discount_gain_account_id_label varchar2
account_journal_early_pay_discount_loss_account_id varchar2
account_journal_early_pay_discount_loss_account_id_label varchar2
account_journal_payment_credit_account_id varchar2
account_journal_payment_credit_account_id_label varchar2
account_journal_payment_debit_account_id varchar2
account_journal_payment_debit_account_id_label varchar2
account_journal_suspense_account_id varchar2
account_journal_suspense_account_id_label varchar2
account_onboarding_create_invoice_state varchar2 State of the onboarding create invoice step
account_onboarding_create_invoice_state_flag boolean Account Onboarding Create Invoice State Flag
account_onboarding_invoice_layout_state varchar2 State of the onboarding invoice layout step
account_onboarding_sale_tax_state varchar2 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 varchar2 Journal where the opening entry of this company's accounting has been posted.
account_opening_journal_id_label varchar2 Journal where the opening entry of this company's accounting has been posted.
account_opening_move_id varchar2 The journal entry containing the initial balance of all this company's accounts.
account_opening_move_id_label varchar2 The journal entry containing the initial balance of all this company's accounts.
account_purchase_tax_id varchar2
account_purchase_tax_id_label varchar2
account_representative_id varchar2 Specify an Accounting Firm that will act as a representative when exporting reports.
account_representative_id_label varchar2 Specify an Accounting Firm that will act as a representative when exporting reports.
account_revaluation_expense_provision_account_id varchar2
account_revaluation_expense_provision_account_id_label varchar2
account_revaluation_income_provision_account_id varchar2
account_revaluation_income_provision_account_id_label varchar2
account_revaluation_journal_id varchar2
account_revaluation_journal_id_label varchar2
account_sale_tax_id varchar2
account_sale_tax_id_label varchar2
account_setup_bank_data_state varchar2 State of the onboarding bank data step
account_setup_bill_state varchar2 State of the onboarding bill step
account_setup_coa_state varchar2 State of the onboarding charts of account step
account_setup_fy_data_state varchar2 State of the onboarding fiscal year step
account_setup_taxes_state varchar2 State of the onboarding Taxes step
account_storno boolean Storno accounting
account_tax_periodicity varchar2 Delay units Periodicity
account_tax_periodicity_journal_id varchar2
account_tax_periodicity_journal_id_label varchar2
account_tax_periodicity_reminder_day int32 Start from
account_tax_unit_ids varchar2 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 varchar2 Default Plan for a new analytic account for projects
analytic_plan_id_label varchar2 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 varchar2 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 varchar2
appraisal_confirm_mail_template_label varchar2
appraisal_employee_feedback_template varchar2 Appraisal Employee Feedback Template
appraisal_manager_feedback_template varchar2 Appraisal Manager Feedback Template
appraisal_plan boolean Automatically Generate Appraisals
assessment_note_ids varchar2
attendance_barcode_source varchar2 Barcode Source
attendance_kiosk_delay int32 Attendance Kiosk Delay
attendance_kiosk_mode varchar2 Attendance Mode
automatic_entry_default_journal_id varchar2 Journal used by default for moving the period of an entry
automatic_entry_default_journal_id_label varchar2 Journal used by default for moving the period of an entry
background_image varbinary Home Menu Background Image
bank_account_code_prefix varchar2 Prefix of the bank accounts
bank_ids varchar2
bank_journal_ids varchar2
base_onboarding_company_state varchar2 State of the onboarding company step
cash_account_code_prefix varchar2 Prefix of the cash accounts
catchall_email varchar2 Catchall Email
catchall_formatted varchar2 Catchall
chart_template_id varchar2 The chart template for the company (if any)
chart_template_id_label varchar2 The chart template for the company (if any)
child_ids varchar2
city varchar2 City
company_details varchar2 Company Details Header text displayed at the top of all reports.
company_expense_journal_id varchar2 The company's default journal used when a company expense is created.
company_expense_journal_id_label varchar2 The company's default journal used when a company expense is created.
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
consolidation_color int32 Accounts color
consolidation_create_period_state varchar2 State Of The Onboarding Create Period Step
consolidation_dashboard_onboarding_state varchar2 State Of The Account Consolidation Dashboard Onboarding Panel
consolidation_setup_ccoa_state varchar2 State Of The Onboarding Consolidated Chart Of Account Step
consolidation_setup_consolidation_state varchar2 State Of The Onboarding Consolidation Step
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
currency_exchange_journal_id varchar2
currency_exchange_journal_id_label varchar2
currency_id varchar2
currency_id_label varchar2
currency_interval_unit varchar2 Interval Unit
currency_next_execution_date datetime Next Execution Date
currency_provider varchar2 Service Provider
days_to_purchase numeric Days to Purchase Days needed to confirm a PO, define when a PO should be validated
default_cash_difference_expense_account_id varchar2
default_cash_difference_expense_account_id_label varchar2
default_cash_difference_income_account_id varchar2
default_cash_difference_income_account_id_label varchar2
deferred_time_off_manager varchar2
deferred_time_off_manager_label varchar2
display_name varchar2 Display Name
documents_account_settings boolean Documents Account Settings
documents_fleet_folder varchar2
documents_fleet_folder_label varchar2
documents_fleet_settings boolean Documents Fleet Settings
documents_fleet_tags varchar2
documents_hr_contracts_tags varchar2
documents_hr_folder varchar2
documents_hr_folder_label varchar2
documents_hr_payslips_tags varchar2
documents_hr_settings boolean Documents Hr Settings
documents_payroll_folder_id varchar2
documents_payroll_folder_id_label varchar2
documents_product_settings boolean Documents Product Settings
documents_recruitment_settings boolean Documents Recruitment Settings
documents_spreadsheet_folder_id varchar2
documents_spreadsheet_folder_id_label varchar2
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 varchar2 Cash Discount Tax Reduction
email varchar2 Email
email_formatted varchar2 Formatted Email
expects_chart_of_accounts boolean Expects a Chart of Accounts
expense_accrual_account_id varchar2 Account used to move the period of an expense
expense_accrual_account_id_label varchar2 Account used to move the period of an expense
expense_currency_exchange_account_id varchar2
expense_currency_exchange_account_id_label varchar2
expense_extract_show_ocr_option_selection varchar2 Send mode on expense attachments
expense_journal_id varchar2 The company's default journal used when an employee expense is created.
expense_journal_id_label varchar2 The company's default journal used when an employee expense is created.
external_report_layout_id varchar2
external_report_layout_id_label varchar2
extra_day numeric Per Day
extra_hour numeric Per Hour
extra_product varchar2 The product is used to add the cost to the sales order
extra_product_label varchar2 The product is used to add the cost to the sales order
extract_in_invoice_digitalization_mode varchar2 Digitization mode on vendor bills
extract_out_invoice_digitalization_mode varchar2 Digitization mode on customer invoices
extract_single_line_per_tax boolean Single Invoice Line Per Tax
favicon varbinary 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 varchar2 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 varchar2 Font
gain_account_id varchar2 Account used to write the journal item in case of gain while selling an asset
gain_account_id_label varchar2 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 varchar2 Valid IP addresses
hr_referral_background varbinary Referral Background
iap_enrich_auto_done boolean Enrich Done
id int32 ID
income_currency_exchange_account_id varchar2
income_currency_exchange_account_id_label varchar2
incoterm_id varchar2 International Commercial Terms are a series of predefined commercial terms used in international transactions.
incoterm_id_label varchar2 International Commercial Terms are a series of predefined commercial terms used in international transactions.
internal_project_id varchar2 Default project value for timesheet generated from time off type.
internal_project_id_label varchar2 Default project value for timesheet generated from time off type.
internal_transit_location_id varchar2
internal_transit_location_id_label varchar2
invoice_is_email boolean Email by default
invoice_is_print boolean Print by default
invoice_is_snailmail boolean Send by Post
invoice_terms varchar2 Default Terms and Conditions
invoice_terms_html varchar2 Default Terms and Conditions as a Web page
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 varchar2 KVK-nummer
l10n_nl_oin varchar2 Organisatie Indentificatie Nummer
layout_background varchar2 Layout Background
layout_background_image varbinary Background Image
leave_timesheet_task_id varchar2
leave_timesheet_task_id_label varchar2
logo varbinary Company Logo
logo_web varbinary Logo Web
loss_account_id varchar2 Account used to write the journal item in case of loss while selling an asset
loss_account_id_label varchar2 Account used to write the journal item in case of loss while selling an asset
lunch_minimum_threshold numeric Lunch Minimum Threshold
lunch_notify_message varchar2 Lunch Notify Message
manufacturing_lead numeric Manufacturing Lead Time Security days for each manufacturing operation.
message_attachment_count int32 Attachment Count
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
min_extra_hour int32 Minimum delay time before applying fines.
mobile varchar2 Mobile
name varchar2 Company Name
nomenclature_id varchar2
nomenclature_id_label varchar2
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 numeric Padding Time Amount of time (in hours) during which a product is considered unavailable prior to renting (preparation time).
paperformat_id varchar2
paperformat_id_label varchar2
parent_id varchar2
parent_id_label varchar2
partner_gid int32 Company database ID
partner_id varchar2
partner_id_label varchar2
payment_onboarding_payment_method varchar2 Selected onboarding payment method
payment_provider_onboarding_state varchar2 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 varchar2 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 varchar2 Levels of Approvals Provide a double validation mechanism for purchases
po_double_validation_amount numeric Double validation amount Minimum amount for which a double validation is required
po_lead numeric 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 varchar2 Purchase Order Modification Purchase Order Modification used when you want to purchase order editable after confirm
point_of_sale_update_stock_quantities varchar2 Update quantities in stock At the session closing: A picking is created for the entire session when it's closed In 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 varchar2 Primary Color
product_folder varchar2
product_folder_label varchar2
product_tags varchar2
project_time_mode_id varchar2 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_label varchar2 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 varchar2
property_stock_account_input_categ_id_label varchar2
property_stock_account_output_categ_id varchar2
property_stock_account_output_categ_id_label varchar2
property_stock_valuation_account_id varchar2
property_stock_valuation_account_id_label varchar2
qr_code boolean Display QR-code on invoices
quick_edit_mode varchar2 Quick encoding
quotation_validity_days int32 Default Quotation Validity (Days)
recruitment_extract_show_ocr_option_selection varchar2 Send mode on applicant attachments
recruitment_folder_id varchar2
recruitment_folder_id_label varchar2
recruitment_tag_ids varchar2
rental_loc_id varchar2 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_label varchar2 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 varchar2 Minimal Rental Duration Unit
report_footer varchar2 Report Footer Footer text displayed at the bottom of all reports.
report_header varchar2 Company Tagline Appears by default on the top right corner of your printed documents (report header).
resource_calendar_id varchar2
resource_calendar_id_label varchar2
resource_calendar_ids varchar2
revenue_accrual_account_id varchar2 Account used to move the period of a revenue
revenue_accrual_account_id_label varchar2 Account used to move the period of a revenue
sale_onboarding_order_confirmation_state varchar2 State of the onboarding confirmation order step
sale_onboarding_payment_method varchar2 Sale onboarding selected payment method
sale_onboarding_sample_quotation_state varchar2 State of the onboarding sample quotation step
sale_order_template_id varchar2
sale_order_template_id_label varchar2
sale_quotation_onboarding_state varchar2 State of the sale onboarding panel
secondary_color varchar2 Secondary Color
security_lead numeric 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 varchar2 Your Company Name Will appear in SEPA payments as the name of the party initiating the payment. Limited to 70 characters.
sepa_orgid_id varchar2 Identification Identification assigned by an institution (eg. VAT number).
sepa_orgid_issr varchar2 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 varchar2 Sign Default Terms and Conditions
sign_terms_html varchar2 Sign Default Terms and Conditions as a Web page
sign_terms_type varchar2 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.
snailmail_color boolean Color
snailmail_cover boolean Add a Cover Page
snailmail_duplex boolean Both sides
social_facebook varchar2 Facebook Account
social_github varchar2 GitHub Account
social_instagram varchar2 Instagram Account
social_linkedin varchar2 LinkedIn Account
social_twitter varchar2 Twitter Account
social_youtube varchar2 Youtube Account
state_id varchar2
state_id_label varchar2
stock_mail_confirmation_template_id varchar2 Email sent to the customer once the order is done.
stock_mail_confirmation_template_id_label varchar2 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 varchar2 SMS sent to the customer once the order is delivered.
stock_sms_confirmation_template_id_label varchar2 SMS sent to the customer once the order is delivered.
street varchar2 Street
street2 varchar2 Street2
tax_calculation_rounding_method varchar2 Tax Calculation Rounding Method
tax_cash_basis_journal_id varchar2
tax_cash_basis_journal_id_label varchar2
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 varchar2 Terms & Conditions format
timesheet_encode_uom_id varchar2
timesheet_encode_uom_id_label varchar2
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 varchar2 Employee Frequency
timesheet_mail_employee_nextdate datetime Next scheduled date for employee reminder
timesheet_mail_interval varchar2 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 varchar2 Prefix of the transfer accounts
transfer_account_id varchar2 Intermediary account used when moving money from a liqity account to another
transfer_account_id_label varchar2 Intermediary account used when moving money from a liqity account to another
user_ids varchar2
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.
vat_check_vies boolean Verify VAT Numbers
website varchar2 Website Link
website_id varchar2
website_id_label varchar2
website_message_ids varchar2 Website communication history
website_sale_dashboard_onboarding_state varchar2 State of the website sale onboarding panel
website_sale_onboarding_payment_provider_state varchar2 State of the website sale onboarding payment provider step
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: