request: Odoo itgen_odoo_request
read only per partition
- Catálogo:
Odoo - Esquema:
maintenance - Etiqueta: itgen_odoo_request
Maintenance Request
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla request. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
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 |
||||
archive |
boolean |
Archive | Set archive to true to hide the maintenance request without deleting it. | ||
category_ |
varchar2 |
||||
category_ |
varchar2 |
||||
close_ |
datetime |
Fecha de Cierre | Date the maintenance was finished. | ||
color |
int32 |
Color Index | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
create_ |
datetime |
Creado en | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
description |
varchar2 |
Description | |||
display_ |
varchar2 |
Nombre para mostrar | |||
done |
boolean |
Request Done | |||
duration |
numeric |
Duration | Duration in hours. | ||
email_ |
varchar2 |
Email cc | |||
employee_ |
varchar2 |
||||
employee_ |
varchar2 |
||||
equipment_ |
varchar2 |
||||
equipment_ |
varchar2 |
||||
has_ |
boolean |
Has Message | |||
id |
int32 |
ID | |||
kanban_ |
varchar2 |
Kanban State | |||
maintenance_ |
varchar2 |
||||
maintenance_ |
varchar2 |
||||
maintenance_ |
varchar2 |
Maintenance Type | |||
message_ |
int32 |
Número de archivos adjuntos | |||
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 |
Número de acciones | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
my_ |
datetime |
My Activity Deadline | |||
name |
varchar2 |
Subjects | |||
owner_ |
varchar2 |
||||
owner_ |
varchar2 |
||||
priority |
varchar2 |
Priority | |||
request_ |
datetime |
Fecha de petición | Date requested for the maintenance to happen | ||
schedule_ |
datetime |
Fecha Programada | Date the maintenance team plans the maintenance.It should not differ much from the Request Date. | ||
stage_ |
varchar2 |
||||
stage_ |
varchar2 |
||||
user_ |
varchar2 |
||||
user_ |
varchar2 |
||||
website_ |
varchar2 |
Website communication history | |||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: