invantive documentation
Forum di supporto InvantiveAccedi / Registrati

request: Odoo itgen_odoo_request

read only per partition

  • Catalogo: Odoo
  • Schema: maintenance
  • Etichetta: itgen_odoo_request

Maintenance Request

È possibile solo recuperare i dati.

Colonne della tabella

Di seguito sono riportate le colonne della tabella request. 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
archive boolean Archive Set archive to true to hide the maintenance request without deleting it.
category_id varchar2
category_id_label varchar2
close_date datetime Chiudi la data Date the maintenance was finished.
color int32 Color Index
company_id varchar2
company_id_label varchar2
create_date datetime Creato il
create_uid varchar2
create_uid_label varchar2
description varchar2 Description
display_name varchar2 Nome visualizzato
done boolean Request Done
duration numeric Duration Duration in hours.
email_cc varchar2 Email cc
employee_id varchar2
employee_id_label varchar2
equipment_id varchar2
equipment_id_label varchar2
has_message boolean Has Message
id int32 ID
kanban_state varchar2 Kanban State
maintenance_team_id varchar2
maintenance_team_id_label varchar2
maintenance_type varchar2 Maintenance Type
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 Subjects
owner_user_id varchar2
owner_user_id_label varchar2
priority varchar2 Priority
request_date datetime Data richiesta Date requested for the maintenance to happen
schedule_date datetime Data programmata Date the maintenance team plans the maintenance.It should not differ much from the Request Date.
stage_id varchar2
stage_id_label varchar2
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

Note di rilascio

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