type |
Appointment Type
Catalog: Odoo
Schema: appointment
The data in this table is partitioned per value of the column.
This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API.
Table Columns
The columns of the table type are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
active |
boolean |
Active |
☐ |
|
applicant_id_label |
string |
|
☐ |
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 |
string |
|
☐ |
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_report |
int32 |
# Appointments in the last 30 days |
☐ |
|
appointment_count |
int32 |
# Appointments |
☐ |
|
appointment_duration_formatted |
string |
Appointment Duration Formatted |
☐ |
Appointment Duration formatted in words |
appointment_duration |
decimal |
Duration |
☑ |
|
appointment_invite_ids |
string |
|
☐ |
|
appointment_tz |
string |
Timezone |
☑ |
Timezone where appointment take place |
assign_method |
string |
Assignment Method |
☐ |
How users will be assigned to meetings customers book on your website. |
avatars_display |
string |
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 |
string |
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 |
string |
|
☐ |
Keep empty to allow visitors from any country, otherwise you only allow visitors from selected countries |
cover_properties |
string |
Cover Properties |
☐ |
|
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
display_name |
string |
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_id_label |
string |
|
☐ |
|
location_id |
string |
|
☐ |
|
location |
string |
Location formatted |
☐ |
Location formatted for one line uses |
max_schedule_days |
int32 |
Schedule not after (days) |
☑ |
|
meeting_ids |
string |
|
☐ |
|
message_attachment_count |
int32 |
Attachment Count |
☐ |
|
message_confirmation |
string |
Confirmation Message |
☐ |
Extra information provided once the appointment is booked. |
message_follower_ids |
string |
|
☐ |
|
message_has_error_counter |
int32 |
Number of errors |
☐ |
Number of messages with delivery error |
message_has_error |
boolean |
Message Delivery error |
☐ |
If checked, some messages have a delivery error. |
message_has_sms_error |
boolean |
SMS Delivery error |
☐ |
If checked, some messages have a delivery error. |
message_ids |
string |
|
☐ |
|
message_intro |
string |
Introduction Message |
☐ |
Small description of the appointment type. |
message_is_follower |
boolean |
Is Follower |
☐ |
|
message_main_attachment_id_label |
string |
|
☐ |
|
message_main_attachment_id |
string |
|
☐ |
|
message_needaction_counter |
int32 |
Number of Actions |
☐ |
Number of messages which requires an action |
message_needaction |
boolean |
Action Needed |
☐ |
If checked, new messages require your attention. |
message_partner_ids |
string |
|
☐ |
Contacts that need to be notified whenever a new appointment is booked or canceled, regardless of whether they attend or not |
min_cancellation_hours |
decimal |
Cancel Before (hours) |
☑ |
|
min_schedule_hours |
decimal |
Schedule before (hours) |
☑ |
|
name |
string |
Appointment Title |
☑ |
|
opportunity_id_label |
string |
|
☐ |
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 |
string |
|
☐ |
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 |
string |
|
☐ |
|
reminder_ids |
string |
|
☐ |
|
seo_name |
string |
Seo name |
☐ |
|
sequence |
int32 |
Sequence |
☐ |
|
slot_ids |
string |
|
☐ |
|
staff_user_count |
int32 |
# Staff Users |
☐ |
|
staff_user_ids |
string |
|
☐ |
|
website_message_ids |
string |
|
☐ |
Website communication history |
website_meta_description |
string |
Website meta description |
☐ |
|
website_meta_keywords |
string |
Website meta keywords |
☐ |
|
website_meta_og_img |
string |
Website opengraph image |
☐ |
|
website_meta_title |
string |
Website meta title |
☐ |
|
website_published |
boolean |
Visible on current website |
☐ |
|
website_url |
string |
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_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826