invantive documentation
Forum di supporto InvantiveAccedi / Registrati

lot: Odoo itgen_odoo_lot

read only per partition

  • Catalogo: Odoo
  • Schema: stock
  • Etichetta: itgen_odoo_lot

Lot/Serial

È possibile solo recuperare i dati.

Colonne della tabella

Di seguito sono riportate le colonne della tabella lot. 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
company_id varchar2
company_id_label varchar2
create_date datetime Creato il
create_uid varchar2
create_uid_label varchar2
delivery_count int32 Delivery order count
delivery_ids varchar2
display_complete boolean Display Complete
display_name varchar2 Nome visualizzato
has_message boolean Has Message
id int32 ID
last_delivery_partner_id varchar2
last_delivery_partner_id_label varchar2
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
my_activity_date_deadline datetime My Activity Deadline
name varchar2 Lot/Serial Number Unique Lot/Serial Number
note varchar2 Description
product_id varchar2
product_id_label varchar2
product_qty numeric Quantity
product_uom_id varchar2 Default unit of measure used for all stock operations.
product_uom_id_label varchar2 Default unit of measure used for all stock operations.
purchase_order_count int32 Purchase order count
purchase_order_ids varchar2
quality_check_qty int32 Quality Check Qty
quant_ids varchar2
ref varchar2 Riferimento interno Internal reference number in case it differs from the manufacturer's lot/serial number
repair_order_count int32 Repair order count
repair_order_ids varchar2
sale_order_count int32 Sale order count
sale_order_ids varchar2
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: