---
title: "analytic_line (Odoo)"
description: "itgen_odoo_analytic_line"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.account.analytic_line
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.account.analytic_line
updated: 2023-03-01T15:29:04Z
license: https://documentation.invantive.eu/en/
---

# analytic_line: Odoo itgen_odoo_analytic_line

`read only` `per partition`

- Catalog: `Odoo`
- Schema: `account`
- Label: itgen_odoo_analytic_line

Analytic Line

Can only retrieve data.

## Table Columns

The columns of the table `analytic_line` 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_id` | `varchar2` |  | [ ] |  |  |
| `account_id_label` | `varchar2` |  | [ ] |  |  |
| `allow_billable` | `boolean` | Billable | [ ] |  |  |
| `amount` | `numeric` | Amount | [x] |  |  |
| `ancestor_task_id` | `varchar2` |  | [ ] |  |  |
| `ancestor_task_id_label` | `varchar2` |  | [ ] |  |  |
| `can_edit` | `boolean` | Can Edit | [ ] |  |  |
| `category` | `varchar2` | Category | [ ] |  |  |
| `code` | `varchar2` | Code | [ ] |  |  |
| `commercial_partner_id` | `varchar2` |  | [ ] |  |  |
| `commercial_partner_id_label` | `varchar2` |  | [ ] |  |  |
| `company_id` | `varchar2` |  | [ ] |  |  |
| `company_id_label` | `varchar2` |  | [ ] |  |  |
| `create_date` | `datetime` | Created on | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `currency_id` | `varchar2` |  | [ ] |  |  |
| `currency_id_label` | `varchar2` |  | [ ] |  |  |
| `date` | `datetime` | Date | [x] |  |  |
| `department_id` | `varchar2` |  | [ ] |  |  |
| `department_id_label` | `varchar2` |  | [ ] |  |  |
| `display_name` | `varchar2` | Display Name | [ ] |  |  |
| `display_timer` | `boolean` | Display Timer | [ ] |  | Technical field used to display the timer if the encoding unit is 'Hours'. |
| `display_timer_pause` | `boolean` | Display Timer Pause | [ ] |  |  |
| `display_timer_resume` | `boolean` | Display Timer Resume | [ ] |  |  |
| `display_timer_start_primary` | `boolean` | Display Timer Start Primary | [ ] |  |  |
| `display_timer_stop` | `boolean` | Display Timer Stop | [ ] |  |  |
| `duration_unit_amount` | `numeric` | Timesheet Init Amount | [ ] |  |  |
| `employee_id` | `varchar2` |  | [ ] |  | Define an 'hourly cost' on the employee to track the cost of their time. |
| `employee_id_label` | `varchar2` |  | [ ] |  | Define an 'hourly cost' on the employee to track the cost of their time. |
| `encoding_uom_id` | `varchar2` |  | [ ] |  |  |
| `encoding_uom_id_label` | `varchar2` |  | [ ] |  |  |
| `general_account_id` | `varchar2` |  | [ ] |  |  |
| `general_account_id_label` | `varchar2` |  | [ ] |  |  |
| `global_leave_id` | `varchar2` |  | [ ] |  |  |
| `global_leave_id_label` | `varchar2` |  | [ ] |  |  |
| `has_so_access` | `boolean` | Has So Access | [ ] |  | Check that user has a sales access right or not. |
| `holiday_id` | `varchar2` |  | [ ] |  |  |
| `holiday_id_label` | `varchar2` |  | [ ] |  |  |
| `id` | `int32` | ID | [ ] |  |  |
| `is_so_line_edited` | `boolean` | Is Sales Order Item Manually Edited | [ ] |  |  |
| `is_timer_running` | `boolean` | Is Timer Running | [ ] |  |  |
| `is_timesheet` | `boolean` | Timesheet Line | [ ] |  | Set if this analytic line represents a line of timesheet. |
| `job_title` | `varchar2` | Job Title | [ ] |  |  |
| `journal_id` | `varchar2` |  | [ ] |  |  |
| `journal_id_label` | `varchar2` |  | [ ] |  |  |
| `manager_id` | `varchar2` |  | [ ] |  |  |
| `manager_id_label` | `varchar2` |  | [ ] |  |  |
| `move_line_id` | `varchar2` |  | [ ] |  |  |
| `move_line_id_label` | `varchar2` |  | [ ] |  |  |
| `name` | `varchar2` | Description | [x] |  |  |
| `order_id` | `varchar2` |  | [ ] |  |  |
| `order_id_label` | `varchar2` |  | [ ] |  |  |
| `partner_id` | `varchar2` |  | [ ] |  |  |
| `partner_id_label` | `varchar2` |  | [ ] |  |  |
| `plan_id` | `varchar2` |  | [ ] |  |  |
| `plan_id_label` | `varchar2` |  | [ ] |  |  |
| `product_id` | `varchar2` |  | [ ] |  |  |
| `product_id_label` | `varchar2` |  | [ ] |  |  |
| `product_uom_category_id` | `varchar2` |  | [ ] |  | Conversion between Units of Measure can only occur if they belong to the same category. The conversion will be made based on the ratios. |
| `product_uom_category_id_label` | `varchar2` |  | [ ] |  | Conversion between Units of Measure can only occur if they belong to the same category. The conversion will be made based on the ratios. |
| `product_uom_id` | `varchar2` |  | [ ] |  |  |
| `product_uom_id_label` | `varchar2` |  | [ ] |  |  |
| `project_id` | `varchar2` |  | [ ] |  |  |
| `project_id_label` | `varchar2` |  | [ ] |  |  |
| `ref` | `varchar2` | Ref. | [ ] |  |  |
| `so_line` | `varchar2` |  | [ ] |  | Sales order item to which the time spent will be added in order to be invoiced to your customer. Remove the sales order item for the timesheet entry to be non-billable. |
| `so_line_label` | `varchar2` |  | [ ] |  | Sales order item to which the time spent will be added in order to be invoiced to your customer. Remove the sales order item for the timesheet entry to be non-billable. |
| `task_id` | `varchar2` |  | [ ] |  |  |
| `task_id_label` | `varchar2` |  | [ ] |  |  |
| `timer_pause` | `datetime` | Timer Last Pause | [ ] |  |  |
| `timer_start` | `datetime` | Timer Start | [ ] |  |  |
| `timesheet_invoice_id` | `varchar2` |  | [ ] |  | Invoice created from the timesheet |
| `timesheet_invoice_id_label` | `varchar2` |  | [ ] |  | Invoice created from the timesheet |
| `timesheet_invoice_type` | `varchar2` | Billable Type | [ ] |  |  |
| `unit_amount` | `numeric` | Quantity | [ ] |  |  |
| `unit_amount_validate` | `numeric` | Timesheet Unit Time | [ ] |  |  |
| `user_can_validate` | `boolean` | User Can Validate | [ ] |  | Whether or not the current user can validate/reset to draft the record. |
| `user_id` | `varchar2` |  | [ ] |  |  |
| `user_id_label` | `varchar2` |  | [ ] |  |  |
| `user_timer_id` | `varchar2` |  | [ ] |  |  |
| `validated` | `boolean` | Validated line | [ ] |  |  |
| `validated_status` | `varchar2` | Validated Status | [x] |  |  |
| `write_date` | `datetime` | Last Updated on | [ ] |  |  |
| `write_uid` | `varchar2` |  | [ ] |  |  |
| `write_uid_label` | `varchar2` |  | [ ] |  |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Odoo](/en/release-notes/drivers?driver=odoo)

