# analysis_report Timesheets Analysis Report - Catalog: `Odoo` - Schema: `timesheets` 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 `analysis_report` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `amount` | `decimal` | Amount | ☐ | | | `ancestor_task_id_label` | `string` | | ☐ | | | `ancestor_task_id` | `string` | | ☐ | | | `billable_time` | `decimal` | Billable Hours | ☐ | Number of hours/days linked to a SOL. | | `company_id_label` | `string` | | ☐ | | | `company_id` | `string` | | ☐ | | | `currency_id_label` | `string` | | ☐ | | | `currency_id` | `string` | | ☐ | | | `date` | `datetime` | Date | ☐ | | | `department_id_label` | `string` | | ☐ | | | `department_id` | `string` | | ☐ | | | `display_name` | `string` | Display Name | ☐ | | | `employee_id_label` | `string` | | ☐ | | | `employee_id` | `string` | | ☐ | | | `id` | `int32` | ID | ☐ | | | `is_timer_running` | `boolean` | Is Timer Running | ☐ | | | `is_timesheet` | `boolean` | Timesheet Line | ☐ | | | `manager_id_label` | `string` | | ☐ | | | `manager_id` | `string` | | ☐ | | | `margin` | `decimal` | Margin | ☐ | Timesheets revenues minus the costs | | `name` | `string` | Description | ☐ | | | `non_billable_time` | `decimal` | Non-billable Hours | ☐ | Number of hours/days not linked to a SOL. | | `order_id_label` | `string` | | ☐ | | | `order_id` | `string` | | ☐ | | | `project_id_label` | `string` | | ☐ | | | `project_id` | `string` | | ☐ | | | `so_line_label` | `string` | | ☐ | | | `so_line` | `string` | | ☐ | | | `task_id_label` | `string` | | ☐ | | | `task_id` | `string` | | ☐ | | | `timesheet_invoice_id_label` | `string` | | ☐ | Invoice created from the timesheet | | `timesheet_invoice_id` | `string` | | ☐ | Invoice created from the timesheet | | `timesheet_invoice_type` | `string` | Billable Type | ☐ | | | `timesheet_revenues` | `decimal` | Timesheet Revenues | ☐ | Number of hours spent multiplied by the unit price per hour/day. | | `unit_amount` | `decimal` | Hours Spent | ☐ | | | `user_id_label` | `string` | | ☐ | | | `user_id` | `string` | | ☐ | | | `validated` | `boolean` | Validated line | ☐ | |