invantive documentation
Forum di supporto InvantiveAccedi / Registrati

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_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 Creato il
create_uid varchar2
create_uid_label varchar2
device_name varchar2 Device Name:
display_name varchar2 Nome visualizzato
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 Numero di allegati
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 Numero di azioni 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

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: