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_ |
varchar2 |
Security Token | |||
access_ |
varchar2 |
Portal Access URL | Customer Portal URL | ||
access_ |
varchar2 |
Access warning | |||
active |
boolean |
Active | |||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
datetime |
Next Activity Deadline | |||
activity_ |
varchar2 |
Activity Exception Decoration | Type of the exception activity on record. | ||
activity_ |
varchar2 |
Icon | Icon to indicate an exception activity. | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
Activity State | Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities. | ||
activity_ |
varchar2 |
Next Activity Summary | |||
activity_ |
varchar2 |
Activity Type Icon | Font awesome icon e.g. fa-tasks | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
answered_ |
int32 |
# Exchanges | |||
assign_ |
datetime |
First assignment date | |||
assign_ |
int32 |
Time to first assignment (hours) | |||
avg_ |
numeric |
Average Hours to Respond | |||
campaign_ |
varchar2 |
This is a name that helps you keep track of your different campaign efforts, e.g. Fall_Drive, Christmas_Special | |||
campaign_ |
varchar2 |
This is a name that helps you keep track of your different campaign efforts, e.g. Fall_Drive, Christmas_Special | |||
close_ |
datetime |
Close date | |||
close_ |
int32 |
Time to close (hours) | |||
closed_ |
boolean |
Closed by Partner | |||
color |
int32 |
Color Index | |||
commercial_ |
varchar2 |
||||
commercial_ |
varchar2 |
||||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
create_ |
datetime |
Creado en | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
date_ |
datetime |
Last Stage Update | |||
description |
varchar2 |
Description | |||
display_ |
varchar2 |
Nombre para mostrar | |||
domain_ |
varchar2 |
||||
email_ |
varchar2 |
Email cc | |||
first_ |
numeric |
Hours to First Response | |||
fold |
boolean |
Folded in Kanban | Tickets in a folded stage are considered as closed. | ||
fsm_ |
int32 |
Fsm Task Count | |||
fsm_ |
varchar2 |
Tasks generated from this ticket | |||
has_ |
boolean |
Has Message | |||
id |
int32 |
ID | |||
is_ |
boolean |
Partner Email will Update | |||
is_ |
boolean |
Partner Phone will Update | |||
kanban_ |
varchar2 |
Kanban State | |||
kanban_ |
varchar2 |
Kanban State Label | |||
legend_ |
varchar2 |
Kanban Blocked Explanation | |||
legend_ |
varchar2 |
Kanban Valid Explanation | |||
legend_ |
varchar2 |
Kanban Ongoing Explanation | |||
medium_ |
varchar2 |
This is the method of delivery, e.g. Postcard, Email, or Banner Ad | |||
medium_ |
varchar2 |
This is the method of delivery, e.g. Postcard, Email, or Banner Ad | |||
message_ |
int32 |
Número de archivos adjuntos | |||
message_ |
varchar2 |
||||
message_ |
boolean |
Message Delivery error | If checked, some messages have a delivery error. | ||
message_ |
int32 |
Number of errors | Number of messages with delivery error | ||
message_ |
boolean |
SMS Delivery error | If checked, some messages have a delivery error. | ||
message_ |
varchar2 |
||||
message_ |
boolean |
Is Follower | |||
message_ |
varchar2 |
||||
message_ |
varchar2 |
||||
message_ |
boolean |
Action Needed | If checked, new messages require your attention. | ||
message_ |
int32 |
Número de acciones | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
my_ |
datetime |
My Activity Deadline | |||
name |
varchar2 |
Subject | |||
oldest_ |
datetime |
Oldest Unanswered Customer Message Date | |||
open_ |
int32 |
Open Time (hours) | |||
partner_ |
varchar2 |
Correo electrónico del cliente | |||
partner_ |
varchar2 |
||||
partner_ |
varchar2 |
||||
partner_ |
varchar2 |
Nombre del Cliente | |||
partner_ |
int32 |
Number of other open tickets from the same partner | |||
partner_ |
varchar2 |
Customer Phone | |||
partner_ |
int32 |
Number of other tickets from the same partner | |||
partner_ |
varchar2 |
||||
priority |
varchar2 |
Priority | |||
properties |
varchar2 |
Properties | |||
rating_ |
numeric |
Calificación promedio | |||
rating_ |
varchar2 |
Rating Avg Text | |||
rating_ |
int32 |
Rating count | |||
rating_ |
varchar2 |
||||
rating_ |
varchar2 |
Rating Last Feedback | |||
rating_ |
varbinary |
Rating Last Image | |||
rating_ |
varchar2 |
Rating Text | |||
rating_ |
numeric |
Rating Last Value | |||
rating_ |
numeric |
Rating Satisfaction | |||
sale_ |
varchar2 |
||||
sale_ |
varchar2 |
||||
sla_ |
datetime |
SLA Deadline | |||
sla_ |
numeric |
Hours to SLA Deadline | |||
sla_ |
boolean |
Failed SLA Policy | |||
sla_ |
varchar2 |
||||
sla_ |
boolean |
Has SLA reached | |||
sla_ |
boolean |
Has SLA reached late | |||
sla_ |
varchar2 |
||||
sla_ |
boolean |
Success SLA Policy | |||
source_ |
varchar2 |
This is the source of the link, e.g. Search Engine, another domain, or name of email list | |||
source_ |
varchar2 |
This is the source of the link, e.g. Search Engine, another domain, or name of email list | |||
stage_ |
varchar2 |
||||
stage_ |
varchar2 |
||||
tag_ |
varchar2 |
||||
team_ |
varchar2 |
||||
team_ |
varchar2 |
||||
team_ |
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_ |
varchar2 |
Ticket IDs Sequence | |||
ticket_ |
varchar2 |
||||
ticket_ |
varchar2 |
||||
total_ |
numeric |
Total Exchange Time in Hours | |||
use_ |
boolean |
Use Coupons | |||
use_ |
boolean |
Use Credit Notes | |||
use_ |
boolean |
Field Service | |||
use_ |
boolean |
Use Repairs | |||
use_ |
boolean |
Use Returns | |||
use_ |
boolean |
Use Customer Ratings | |||
use_ |
boolean |
Políticas de SLA | |||
user_ |
varchar2 |
||||
user_ |
varchar2 |
||||
website_ |
varchar2 |
Website communication history | |||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: