check: Odoo itgen_odoo_check
read only per partition
- Catálogo:
Odoo - Esquema:
quality - Etiqueta: itgen_odoo_check
Quality Check
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla check. 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 |
||||
additional_ |
varchar2 |
Additional Note | Additional remarks concerning this check. | ||
alert_ |
int32 |
# Quality Alerts | |||
alert_ |
varchar2 |
||||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
control_ |
datetime |
Control Date | |||
create_ |
datetime |
Creado en | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
device_ |
varchar2 |
Device Name: | |||
display_ |
varchar2 |
Nombre para mostrar | |||
failure_ |
varchar2 |
Failure Message | |||
has_ |
boolean |
Has Message | |||
id |
int32 |
ID | |||
identifier |
varchar2 |
Identifier | |||
ip |
varchar2 |
Domain Address | |||
is_ |
boolean |
Lot Tested Fractionally | Determines if only a fraction of the lot should be tested | ||
lot_id |
varchar2 |
||||
lot_ |
varchar2 |
||||
lot_ |
varchar2 |
||||
lot_ |
varchar2 |
||||
lot_ |
varchar2 |
Lot/Serial Number Name | |||
measure |
numeric |
Measure | |||
measure_ |
varchar2 |
Control per | Operation = One quality check is requested at the operation level.Product = A quality check is requested per product.Quantity = A quality check is requested for each new product quantity registered, with partial quantity checks also possible. | ||
measure_ |
varchar2 |
Measure Success | |||
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 |
||||
move_ |
varchar2 |
In case of Quality Check by Quantity, Move Line on which the Quality Check applies | |||
move_ |
varchar2 |
In case of Quality Check by Quantity, Move Line on which the Quality Check applies | |||
my_ |
datetime |
My Activity Deadline | |||
name |
varchar2 |
Reference | |||
norm_ |
varchar2 |
Norm Unit | |||
note |
varchar2 |
Note | |||
partner_ |
varchar2 |
||||
partner_ |
varchar2 |
||||
picking_ |
varchar2 |
||||
picking_ |
varchar2 |
||||
picture |
varbinary |
Picture | |||
point_ |
varchar2 |
||||
point_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
varchar2 |
Tracking | Ensure the traceability of a storable product in your warehouse. | ||
production_ |
varchar2 |
||||
production_ |
varchar2 |
||||
qty_ |
numeric |
Quantity | |||
qty_ |
numeric |
Quantity Tested | Quantity of product tested within the lot | ||
qty_ |
numeric |
Quantity to Test | Quantity of product to test within the lot | ||
quality_ |
varchar2 |
Status | |||
show_ |
boolean |
Show Lot Text | |||
team_ |
varchar2 |
||||
team_ |
varchar2 |
||||
test_ |
varchar2 |
Technical name | |||
test_ |
varchar2 |
||||
test_ |
varchar2 |
||||
testing_ |
numeric |
Testing Percentage Within Lot | Defines the percentage within a lot that should be tested | ||
title |
varchar2 |
Title | |||
tolerance_ |
numeric |
Max Tolerance | |||
tolerance_ |
numeric |
Min Tolerance | |||
uom_id |
varchar2 |
Default unit of measure used for all stock operations. | |||
uom_ |
varchar2 |
Default unit of measure used for all stock operations. | |||
user_ |
varchar2 |
||||
user_ |
varchar2 |
||||
warning_ |
varchar2 |
Warning Message | |||
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: