invantive documentation
Invantive Support ForumsLog In / Sign Up

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_calendar_event_id varchar2
activity_calendar_event_id_label varchar2
activity_date_deadline datetime Next Activity Deadline
activity_exception_decoration varchar2 Activity Exception Decoration Type of the exception activity on record.
activity_exception_icon varchar2 Icon Icon to indicate an exception activity.
activity_ids varchar2
activity_state varchar2 Activity State Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities.
activity_summary varchar2 Next Activity Summary
activity_type_icon varchar2 Activity Type Icon Font awesome icon e.g. fa-tasks
activity_type_id varchar2
activity_type_id_label varchar2
activity_user_id varchar2
activity_user_id_label varchar2
additional_note varchar2 Additional Note Additional remarks concerning this check.
alert_count int32 # Quality Alerts
alert_ids varchar2
company_id varchar2
company_id_label varchar2
control_date datetime Control Date
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
device_name varchar2 Device Name:
display_name varchar2 Display Name
failure_message varchar2 Failure Message
has_message boolean Has Message
id int32 ID
identifier varchar2 Identifier
ip varchar2 Domain Address
is_lot_tested_fractionally boolean Lot Tested Fractionally Determines if only a fraction of the lot should be tested
lot_id varchar2
lot_id_label varchar2
lot_line_id varchar2
lot_line_id_label varchar2
lot_name varchar2 Lot/Serial Number Name
measure numeric Measure
measure_on 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_success varchar2 Measure Success
message_attachment_count int32 Attachment Count
message_follower_ids varchar2
message_has_error boolean Message Delivery error If checked, some messages have a delivery error.
message_has_error_counter int32 Number of errors Number of messages with delivery error
message_has_sms_error boolean SMS Delivery error If checked, some messages have a delivery error.
message_ids varchar2
message_is_follower boolean Is Follower
message_main_attachment_id varchar2
message_main_attachment_id_label varchar2
message_needaction boolean Action Needed If checked, new messages require your attention.
message_needaction_counter int32 Number of Actions Number of messages which requires an action
message_partner_ids varchar2
move_line_id varchar2 In case of Quality Check by Quantity, Move Line on which the Quality Check applies
move_line_id_label varchar2 In case of Quality Check by Quantity, Move Line on which the Quality Check applies
my_activity_date_deadline datetime My Activity Deadline
name varchar2 Reference
norm_unit varchar2 Norm Unit
note varchar2 Note
partner_id varchar2
partner_id_label varchar2
picking_id varchar2
picking_id_label varchar2
picture varbinary Picture
point_id varchar2
point_id_label varchar2
product_id varchar2
product_id_label varchar2
product_tracking varchar2 Tracking Ensure the traceability of a storable product in your warehouse.
production_id varchar2
production_id_label varchar2
qty_line numeric Quantity
qty_tested numeric Quantity Tested Quantity of product tested within the lot
qty_to_test numeric Quantity to Test Quantity of product to test within the lot
quality_state varchar2 Status
show_lot_text boolean Show Lot Text
team_id varchar2
team_id_label varchar2
test_type varchar2 Technical name
test_type_id varchar2
test_type_id_label varchar2
testing_percentage_within_lot numeric Testing Percentage Within Lot Defines the percentage within a lot that should be tested
title varchar2 Title
tolerance_max numeric Max Tolerance
tolerance_min numeric Min Tolerance
uom_id varchar2 Default unit of measure used for all stock operations.
uom_id_label varchar2 Default unit of measure used for all stock operations.
user_id varchar2
user_id_label varchar2
warning_message varchar2 Warning Message
website_message_ids varchar2 Website communication history
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: