equipment: Odoo itgen_odoo_equipment
read only per partition
- Catalog:
Odoo - Schema:
maintenance - Label: itgen_odoo_equipment
Maintenance Equipment
Can only retrieve data.
Table Columns
The columns of the table equipment 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 | |||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
datetime |
Next Activity Deadline | |||
activity_ |
varchar2 |
Activity Exception Decoration | Type of the exception activity on record. | ||
activity_ |
varchar2 |
Icon | Icon to indicate an exception activity. | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
Activity State | Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities. | ||
activity_ |
varchar2 |
Next Activity Summary | |||
activity_ |
varchar2 |
Activity Type Icon | Font awesome icon e.g. fa-tasks | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
assign_ |
datetime |
Assigned Date | |||
category_ |
varchar2 |
||||
category_ |
varchar2 |
||||
color |
int32 |
Color Index | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
cost |
numeric |
Cost | |||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
department_ |
varchar2 |
||||
department_ |
varchar2 |
||||
display_ |
varchar2 |
Display Name | |||
effective_ |
datetime |
Effective Date | Date at which the equipment became effective. This date will be used to compute the Mean Time Between Failure. | ||
employee_ |
varchar2 |
||||
employee_ |
varchar2 |
||||
equipment_ |
varchar2 |
Used By | |||
has_ |
boolean |
Has Message | |||
id |
int32 |
ID | |||
location |
varchar2 |
Location | |||
maintenance_ |
int32 |
Maintenance Count | |||
maintenance_ |
numeric |
Maintenance Duration | Maintenance Duration in hours. | ||
maintenance_ |
varchar2 |
||||
maintenance_ |
int32 |
Current Maintenance | |||
maintenance_ |
varchar2 |
||||
maintenance_ |
varchar2 |
||||
message_ |
int32 |
Attachment Count | |||
message_ |
varchar2 |
||||
message_ |
boolean |
Message Delivery error | If checked, some messages have a delivery error. | ||
message_ |
int32 |
Number of errors | Number of messages with delivery error | ||
message_ |
boolean |
SMS Delivery error | If checked, some messages have a delivery error. | ||
message_ |
varchar2 |
||||
message_ |
boolean |
Is Follower | |||
message_ |
varchar2 |
||||
message_ |
varchar2 |
||||
message_ |
boolean |
Action Needed | If checked, new messages require your attention. | ||
message_ |
int32 |
Number of Actions | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
model |
varchar2 |
Model | |||
my_ |
datetime |
My Activity Deadline | |||
name |
varchar2 |
Equipment Name | |||
next_ |
datetime |
Date of the next preventive maintenance | |||
note |
varchar2 |
Note | |||
owner_ |
varchar2 |
||||
owner_ |
varchar2 |
||||
partner_ |
varchar2 |
||||
partner_ |
varchar2 |
||||
partner_ |
varchar2 |
Vendor Reference | |||
period |
int32 |
Days between each preventive maintenance | |||
scrap_ |
datetime |
Scrap Date | |||
serial_ |
varchar2 |
Serial Number | |||
technician_ |
varchar2 |
||||
technician_ |
varchar2 |
||||
warranty_ |
datetime |
Warranty Expiration Date | |||
website_ |
varchar2 |
Website communication history | |||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: