invantive documentation
Invantive Support ForumsLog In / Sign Up

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
appointment_duration_formatted varchar2 Appointment Duration Formatted Appointment Duration formatted in words
appointment_invite_ids varchar2
appointment_tz varchar2 Timezone 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)
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)
min_schedule_hours numeric Schedule before (hours)
name varchar2 Appointment Title
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: