check: Odoo itgen_odoo_check
read only per partition
- Catalogo:
Odoo - Schema:
quality - Etichetta: itgen_odoo_check
Quality Check
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella check. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | 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 |
Creato il | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
device_ |
varchar2 |
Device Name: | |||
display_ |
varchar2 |
Nome visualizzato | |||
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 |
Numero di allegati | |||
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 |
Numero di azioni | 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 |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: