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

# type: Odoo itgen_odoo_type

`read only` `per partition`

- Catalog: `Odoo`
- Schema: `appointment`
- Label: itgen_odoo_type

Appointment Type

Can only retrieve data.

## Table Columns

The columns of the table `type` 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 |
|---|---|---|:---:|---|---|
| `active` | `boolean` | Active | [ ] |  |  |
| `applicant_id` | `varchar2` |  | [ ] |  | Link an applicant to the appointment type created. Used when creating a custom appointment type from the Meeting action in the applicant form view. |
| `applicant_id_label` | `varchar2` |  | [ ] |  | Link an applicant to the appointment type created. Used when creating a custom appointment type from the Meeting action in the applicant form view. |
| `appointment_count` | `int32` | # Appointments | [ ] |  |  |
| `appointment_count_report` | `int32` | # Appointments in the last 30 days | [ ] |  |  |
| `appointment_duration` | `numeric` | Duration | [x] |  |  |
| `appointment_duration_formatted` | `varchar2` | Appointment Duration Formatted  | [ ] |  | Appointment Duration formatted in words |
| `appointment_invite_ids` | `varchar2` |  | [ ] |  |  |
| `appointment_tz` | `varchar2` | Timezone | [x] |  | Timezone where appointment take place |
| `assign_method` | `varchar2` | Assignment Method | [ ] |  | How users will be assigned to meetings customers book on your website. |
| `avatars_display` | `varchar2` | Front-End Display | [ ] |  | This option toggles the display of avatars of the staff members during the frontend appointment process.         When choosing amongst several users, a selection screen will also be used, if website is installed. |
| `can_publish` | `boolean` | Can Publish | [ ] |  |  |
| `category` | `varchar2` | Category | [ ] |  | Used to define this appointment type's category.          Can be one of:              - Website: the default category, the people can access and schedule the appointment with users from the website              - Custom: the user will create and share to another user a custom appointment type with hand-picked time slots              - Anytime: the user will create and share to another user an appointment type covering all their time slots |
| `country_ids` | `varchar2` |  | [ ] |  | Keep empty to allow visitors from any country, otherwise you only allow visitors from selected countries |
| `cover_properties` | `varchar2` | Cover Properties | [ ] |  |  |
| `create_date` | `datetime` | Created on | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `display_name` | `varchar2` | Display Name | [ ] |  |  |
| `has_message` | `boolean` | Has Message | [ ] |  |  |
| `id` | `int32` | ID | [ ] |  |  |
| `is_published` | `boolean` | Is Published | [ ] |  |  |
| `is_seo_optimized` | `boolean` | SEO optimized | [ ] |  |  |
| `lead_create` | `boolean` | Create Opportunities | [ ] |  | For each scheduled appointment, create a new opportunity and assign it to the responsible user. |
| `location` | `varchar2` | Location formatted | [ ] |  | Location formatted for one line uses |
| `location_id` | `varchar2` |  | [ ] |  |  |
| `location_id_label` | `varchar2` |  | [ ] |  |  |
| `max_schedule_days` | `int32` | Schedule not after (days) | [x] |  |  |
| `meeting_ids` | `varchar2` |  | [ ] |  |  |
| `message_attachment_count` | `int32` | Attachment Count | [ ] |  |  |
| `message_confirmation` | `varchar2` | Confirmation Message | [ ] |  | Extra information provided once the appointment is booked. |
| `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_intro` | `varchar2` | Introduction Message | [ ] |  | Small description of the appointment type. |
| `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` |  | [ ] |  | Contacts that need to be notified whenever a new appointment is booked or canceled,                                                  regardless of whether they attend or not |
| `min_cancellation_hours` | `numeric` | Cancel Before (hours) | [x] |  |  |
| `min_schedule_hours` | `numeric` | Schedule before (hours) | [x] |  |  |
| `name` | `varchar2` | Appointment Title | [x] |  |  |
| `opportunity_id` | `varchar2` |  | [ ] |  | Link an opportunity/lead to the appointment type created. Used when creating a custom appointment type from the Meeting action in the crm form view. |
| `opportunity_id_label` | `varchar2` |  | [ ] |  | Link an opportunity/lead to the appointment type created. Used when creating a custom appointment type from the Meeting action in the crm form view. |
| `question_ids` | `varchar2` |  | [ ] |  |  |
| `reminder_ids` | `varchar2` |  | [ ] |  |  |
| `seo_name` | `varchar2` | Seo name | [ ] |  |  |
| `sequence` | `int32` | Sequence | [ ] |  |  |
| `slot_ids` | `varchar2` |  | [ ] |  |  |
| `staff_user_count` | `int32` | # Staff Users | [ ] |  |  |
| `staff_user_ids` | `varchar2` |  | [ ] |  |  |
| `website_message_ids` | `varchar2` |  | [ ] |  | Website communication history |
| `website_meta_description` | `varchar2` | Website meta description | [ ] |  |  |
| `website_meta_keywords` | `varchar2` | Website meta keywords | [ ] |  |  |
| `website_meta_og_img` | `varchar2` | Website opengraph image | [ ] |  |  |
| `website_meta_title` | `varchar2` | Website meta title | [ ] |  |  |
| `website_published` | `boolean` | Visible on current website | [ ] |  |  |
| `website_url` | `varchar2` | Website URL | [ ] |  | The full URL to access the document through the website. |
| `work_hours_activated` | `boolean` | Limit to Work Hours | [ ] |  |  |
| `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)

