check: Odoo itgen_odoo_check
read only per partition
- Catalog:
Odoo - Schema:
quality - Label: itgen_odoo_check
Quality Check
Can only retrieve data.
Table Columns
The columns of the table check 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 |
|---|---|---|---|---|---|
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 |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
device_ |
varchar2 |
Device Name: | |||
display_ |
varchar2 |
Display Name | |||
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 |
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 |
||||
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 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: