invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

ticket: Odoo itgen_odoo_ticket

read only per partition

  • Catálogo: Odoo
  • Esquema: helpdesk
  • Etiqueta: itgen_odoo_ticket

Helpdesk Ticket

Solo puede recuperar datos.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla ticket. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

Name Tipo de Datos Label Required Marks Documentation
access_token varchar2 Security Token
access_url varchar2 Portal Access URL Customer Portal URL
access_warning varchar2 Access warning
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
answered_customer_message_count int32 # Exchanges
assign_date datetime First assignment date
assign_hours int32 Time to first assignment (hours)
avg_response_hours numeric Average Hours to Respond
campaign_id varchar2 This is a name that helps you keep track of your different campaign efforts, e.g. Fall_Drive, Christmas_Special
campaign_id_label varchar2 This is a name that helps you keep track of your different campaign efforts, e.g. Fall_Drive, Christmas_Special
close_date datetime Close date
close_hours int32 Time to close (hours)
closed_by_partner boolean Closed by Partner
color int32 Color Index
commercial_partner_id varchar2
commercial_partner_id_label varchar2
company_id varchar2
company_id_label varchar2
create_date datetime Creado en
create_uid varchar2
create_uid_label varchar2
date_last_stage_update datetime Last Stage Update
description varchar2 Description
display_name varchar2 Nombre para mostrar
domain_user_ids varchar2
email_cc varchar2 Email cc
first_response_hours numeric Hours to First Response
fold boolean Folded in Kanban Tickets in a folded stage are considered as closed.
fsm_task_count int32 Fsm Task Count
fsm_task_ids varchar2 Tasks generated from this ticket
has_message boolean Has Message
id int32 ID
is_partner_email_update boolean Partner Email will Update
is_partner_phone_update boolean Partner Phone will Update
kanban_state varchar2 Kanban State
kanban_state_label varchar2 Kanban State Label
legend_blocked varchar2 Kanban Blocked Explanation
legend_done varchar2 Kanban Valid Explanation
legend_normal varchar2 Kanban Ongoing Explanation
medium_id varchar2 This is the method of delivery, e.g. Postcard, Email, or Banner Ad
medium_id_label varchar2 This is the method of delivery, e.g. Postcard, Email, or Banner Ad
message_attachment_count int32 Número de archivos adjuntos
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 Número de acciones Number of messages which requires an action
message_partner_ids varchar2
my_activity_date_deadline datetime My Activity Deadline
name varchar2 Subject
oldest_unanswered_customer_message_date datetime Oldest Unanswered Customer Message Date
open_hours int32 Open Time (hours)
partner_email varchar2 Correo electrónico del cliente
partner_id varchar2
partner_id_label varchar2
partner_name varchar2 Nombre del Cliente
partner_open_ticket_count int32 Number of other open tickets from the same partner
partner_phone varchar2 Customer Phone
partner_ticket_count int32 Number of other tickets from the same partner
partner_ticket_ids varchar2
priority varchar2 Priority
properties varchar2 Properties
rating_avg numeric Calificación promedio
rating_avg_text varchar2 Rating Avg Text
rating_count int32 Rating count
rating_ids varchar2
rating_last_feedback varchar2 Rating Last Feedback
rating_last_image varbinary Rating Last Image
rating_last_text varchar2 Rating Text
rating_last_value numeric Rating Last Value
rating_percentage_satisfaction numeric Rating Satisfaction
sale_order_id varchar2
sale_order_id_label varchar2
sla_deadline datetime SLA Deadline
sla_deadline_hours numeric Hours to SLA Deadline
sla_fail boolean Failed SLA Policy
sla_ids varchar2
sla_reached boolean Has SLA reached
sla_reached_late boolean Has SLA reached late
sla_status_ids varchar2
sla_success boolean Success SLA Policy
source_id varchar2 This is the source of the link, e.g. Search Engine, another domain, or name of email list
source_id_label varchar2 This is the source of the link, e.g. Search Engine, another domain, or name of email list
stage_id varchar2
stage_id_label varchar2
tag_ids varchar2
team_id varchar2
team_id_label varchar2
team_privacy_visibility varchar2 Team Visibility People to whom this helpdesk team and its tickets will be visible. - Invited internal users: internal users can access the team and the tickets they are following.This access can be modified on each ticket individually by adding or removing the user as follower.A user with the helpdesk > administrator access right level can still access this team and its tickets, even if they are not explicitely part of the followers. - All internal users: all internal users can access the team and all of its tickets without distinction. - Invited portal users and all internal users: all internal users can access the team and all of its tickets without distinction.Portal users can only access the tickets they are following.This access can be modified on each ticket individually by adding or removing the portal user as follower.
ticket_ref varchar2 Ticket IDs Sequence
ticket_type_id varchar2
ticket_type_id_label varchar2
total_response_hours numeric Total Exchange Time in Hours
use_coupons boolean Use Coupons
use_credit_notes boolean Use Credit Notes
use_fsm boolean Field Service
use_product_repairs boolean Use Repairs
use_product_returns boolean Use Returns
use_rating boolean Use Customer Ratings
use_sla boolean Políticas de SLA
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

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: