invantive documentation
Invantive Support ForumsLog In / Sign Up

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
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
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
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
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: