invantive documentation
Forum di supporto InvantiveAccedi / Registrati

equipment: Odoo itgen_odoo_equipment

read only per partition

  • Catalogo: Odoo
  • Schema: maintenance
  • Etichetta: itgen_odoo_equipment

Maintenance Equipment

È possibile solo recuperare i dati.

Colonne della tabella

Di seguito sono riportate le colonne della tabella equipment. 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
active boolean Active
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
assign_date datetime Data assegnata
category_id varchar2
category_id_label varchar2
color int32 Color Index
company_id varchar2
company_id_label varchar2
cost numeric Cost
create_date datetime Creato il
create_uid varchar2
create_uid_label varchar2
department_id varchar2
department_id_label varchar2
display_name varchar2 Nome visualizzato
effective_date datetime Data di validità Date at which the equipment became effective.This date will be used to compute the Mean Time Between Failure.
employee_id varchar2
employee_id_label varchar2
equipment_assign_to varchar2 Used By
has_message boolean Has Message
id int32 ID
location varchar2 Location
maintenance_count int32 Maintenance Count
maintenance_duration numeric Maintenance Duration Maintenance Duration in hours.
maintenance_ids varchar2
maintenance_open_count int32 Current Maintenance
maintenance_team_id varchar2
maintenance_team_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
model varchar2 Model
my_activity_date_deadline datetime My Activity Deadline
name varchar2 Nome dell'attrezzatura
next_action_date datetime Date of the next preventive maintenance
note varchar2 Note
owner_user_id varchar2
owner_user_id_label varchar2
partner_id varchar2
partner_id_label varchar2
partner_ref varchar2 Vendor Reference
period int32 Days between each preventive maintenance
scrap_date datetime Scrap Date
serial_no varchar2 Numero di serie
technician_user_id varchar2
technician_user_id_label varchar2
warranty_date datetime Data di scadenza della garanzia
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: