project_task_user_fsm: Odoo itgen_odoo_project_task_user_fsm
read only per partition
- Catalog:
Odoo - Schema:
report - Label: itgen_odoo_project_task_user_fsm
FSM Tasks Analysis
Can only retrieve data.
Table Columns
The columns of the table project_task_user_fsm 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 |
|---|---|---|---|---|---|
active |
boolean |
Active | |||
allocated_ |
numeric |
Allocated Hours | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
create_ |
datetime |
Create Date | |||
date_ |
datetime |
Assignment Date | |||
date_ |
datetime |
Deadline | |||
date_ |
datetime |
Ending Date | |||
date_ |
datetime |
Last Stage Update | |||
delay_ |
numeric |
Days to Deadline | |||
dependent_ |
varchar2 |
||||
description |
varchar2 |
Description | |||
display_ |
varchar2 |
Display Name | |||
effective_ |
numeric |
Hours Spent | |||
id |
int32 |
ID | |||
invoice_ |
varchar2 |
Invoice Status | |||
is_ |
boolean |
Is Blocked | |||
is_ |
boolean |
Closing Stage | Folded in Kanban stages are closing stages. | ||
kanban_ |
varchar2 |
Kanban State | |||
message_ |
boolean |
Is Follower | |||
milestone_ |
varchar2 |
||||
milestone_ |
varchar2 |
||||
name |
varchar2 |
Task | |||
nbr |
int32 |
# of Tasks | |||
overtime |
numeric |
Overtime | |||
parent_ |
varchar2 |
||||
parent_ |
varchar2 |
||||
partner_ |
varchar2 |
||||
partner_ |
varchar2 |
||||
personal_ |
varchar2 |
||||
planned_ |
datetime |
Start date | |||
planned_ |
datetime |
End date | |||
planned_ |
numeric |
Initially Planned Hours | |||
priority |
varchar2 |
Priority | |||
progress |
numeric |
Progress | |||
project_ |
varchar2 |
||||
project_ |
varchar2 |
||||
rating_ |
numeric |
Average Rating | |||
rating_ |
varchar2 |
Rating Last Text | |||
rating_ |
numeric |
Rating Value (/5) | |||
remaining_ |
numeric |
Remaining Hours | |||
remaining_ |
numeric |
Remaining Hours Percentage | |||
remaining_ |
numeric |
Remaining Hours on SO | |||
sale_ |
varchar2 |
||||
sale_ |
varchar2 |
||||
sale_ |
varchar2 |
||||
sale_ |
varchar2 |
||||
stage_ |
varchar2 |
||||
stage_ |
varchar2 |
||||
tag_ |
varchar2 |
||||
task_ |
varchar2 |
||||
task_ |
varchar2 |
||||
user_ |
varchar2 |
||||
working_ |
numeric |
Working Days to Close | |||
working_ |
numeric |
Working Days to Assign | |||
working_ |
numeric |
Working Hours to Close | |||
working_ |
numeric |
Working Hours to Assign | |||
worksheet_ |
varchar2 |
||||
worksheet_ |
varchar2 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: