---
title: "ticket (Odoo)"
description: "itgen_odoo_ticket"
language: it
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/it/datamodels/odoo/Odoo.helpdesk.ticket
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.helpdesk.ticket
updated: 2026-11-18T01:03:05Z
license: https://documentation.invantive.eu/it/
---

# ticket: Odoo itgen_odoo_ticket

`read only` `per partition`

- Catalogo: `Odoo`
- Schema: `helpdesk`
- Etichetta: itgen_odoo_ticket

Helpdesk Ticket

È possibile solo recuperare i dati.

## Colonne della tabella

Di seguito sono riportate le colonne della tabella `ticket`. 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 |
|---|---|---|:---:|---|---|
| `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` | Creato il | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `date_last_stage_update` | `datetime` | Last Stage Update | [ ] |  |  |
| `description` | `varchar2` | Description | [ ] |  |  |
| `display_name` | `varchar2` | Nome visualizzato | [ ] |  |  |
| `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 | [x] |  |  |
| `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` | 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` | Subject | [x] |  |  |
| `oldest_unanswered_customer_message_date` | `datetime` | Oldest Unanswered Customer Message Date | [ ] |  |  |
| `open_hours` | `int32` | Open Time (hours) | [ ] |  |  |
| `partner_email` | `varchar2` | E-mail del cliente | [ ] |  |  |
| `partner_id` | `varchar2` |  | [ ] |  |  |
| `partner_id_label` | `varchar2` |  | [ ] |  |  |
| `partner_name` | `varchar2` | Nome 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` | Valutazione media | [ ] |  |  |
| `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` | Politiche 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` |  | [ ] |  |  |


## Note di rilascio

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

- [Odoo](/it/release-notes/drivers?driver=odoo)
