# company_period Consolidation Company Period - Catalog: `Odoo` - Schema: `consolidation` 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_period` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `chart_id_label` | `string` | | ☐ | | | `chart_id` | `string` | | ☐ | | | `company_id_label` | `string` | | ☐ | | | `company_id` | `string` | | ☐ | | | `company_name` | `string` | Company Name | ☐ | | | `consolidation_method` | `string` | Consolidation Method | ☑ | | | `create_date` | `datetime` | Created on | ☐ | | | `create_uid_label` | `string` | | ☐ | | | `create_uid` | `string` | | ☐ | | | `currencies_are_different` | `boolean` | Currencies Are Different | ☐ | | | `currency_chart_id_label` | `string` | | ☐ | | | `currency_chart_id` | `string` | | ☐ | | | `currency_company_id_label` | `string` | | ☐ | | | `currency_company_id` | `string` | | ☐ | | | `currency_rate_avg` | `decimal` | Average Currency Rate | ☐ | How many units of company currency is needed to get 1 unit of chart currency | | `currency_rate_end` | `decimal` | End Currency Rate | ☐ | How many units of company currency is needed to get 1 unit of chart currency | | `date_company_begin` | `datetime` | Start Date | ☑ | | | `date_company_end` | `datetime` | End Date | ☑ | | | `display_name` | `string` | Display Name | ☐ | | | `exclude_journal_ids` | `string` | | ☐ | | | `id` | `int32` | ID | ☐ | | | `period_id_label` | `string` | | ☐ | | | `period_id` | `string` | | ☐ | | | `rate_consolidation` | `decimal` | Consolidation Rate | ☑ | Should be between 0 and 100 % | | `rate_control` | `decimal` | Rate Control | ☑ | Should be between 0 and 100 % | | `rate_ownership` | `decimal` | Rate Ownership | ☑ | Should be between 0 and 100 % | | `write_date` | `datetime` | Last Updated on | ☐ | | | `write_uid_label` | `string` | | ☐ | | | `write_uid` | `string` | | ☐ | |