invantive documentation
Invantive Support ForumsLog In / Sign Up

point: Odoo itgen_odoo_point

read only per partition

  • Catalog: Odoo
  • Schema: quality
  • Label: itgen_odoo_point

Quality Control Point

Can only retrieve data.

Table Columns

The columns of the table point 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
active boolean Active
average numeric Average
check_count int32 Check Count
check_ids varchar2
company_id varchar2
company_id_label varchar2
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
device_id varchar2
device_id_label varchar2
display_name varchar2 Display Name
failure_message varchar2 Failure Message
has_message boolean Has Message
id int32 ID
is_lot_tested_fractionally boolean Lot Tested Fractionally Determines if only a fraction of the lot should be tested
measure_frequency_type varchar2 Control Frequency
measure_frequency_unit varchar2 Measure Frequency Unit
measure_frequency_unit_value int32 Frequency Unit Value
measure_frequency_value numeric Percentage
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.
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
name varchar2 Reference
norm numeric Norm
norm_unit varchar2 Norm Unit
note varchar2 Note
picking_type_ids varchar2
product_category_ids varchar2 Quality Point will apply to every Products in the selected Product Categories.
product_ids varchar2 Quality Point will apply to every selected Products.
reason varchar2 Cause
sequence int32 Sequence
standard_deviation numeric Standard Deviation
team_id varchar2
team_id_label varchar2
test_type varchar2 Technical name
test_type_id varchar2 Defines the type of the quality control point.
test_type_id_label varchar2 Defines the type of the quality control point.
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
user_id varchar2
user_id_label varchar2
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: