---
title: "ticket (Odoo)"
description: "itgen_odoo_ticket"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.helpdesk.ticket
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.helpdesk.ticket
updated: 2023-03-01T15:29:04Z
license: https://documentation.invantive.eu/en/
---

# ticket: Odoo itgen_odoo_ticket

`read only` `per partition`

- Catalog: `Odoo`
- Schema: `helpdesk`
- Label: itgen_odoo_ticket

Helpdesk Ticket

Can only retrieve data.

## Table Columns

The columns of the table `ticket` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | 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` | Created on | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `date_last_stage_update` | `datetime` | Last Stage Update | [ ] |  |  |
| `description` | `varchar2` | Description | [ ] |  |  |
| `display_name` | `varchar2` | Display Name | [ ] |  |  |
| `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` | Attachment Count | [ ] |  |  |
| `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` | Number of Actions | [ ] |  | 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` | Customer Email | [ ] |  |  |
| `partner_id` | `varchar2` |  | [ ] |  |  |
| `partner_id_label` | `varchar2` |  | [ ] |  |  |
| `partner_name` | `varchar2` | Customer Name | [ ] |  |  |
| `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` | Average Rating | [ ] |  |  |
| `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` | SLA Policies | [ ] |  |  |
| `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` |  | [ ] |  |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

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

