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_ |
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_ |
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_ |
int32 |
# Appointments | |||
appointment_ |
int32 |
# Appointments in the last 30 days | |||
appointment_ |
numeric |
Duration | |||
appointment_ |
varchar2 |
Appointment Duration Formatted | Appointment Duration formatted in words | ||
appointment_ |
varchar2 |
||||
appointment_ |
varchar2 |
Timezone | Timezone where appointment take place | ||
assign_ |
varchar2 |
Assignment Method | How users will be assigned to meetings customers book on your website. | ||
avatars_ |
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_ |
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_ |
varchar2 |
Keep empty to allow visitors from any country, otherwise you only allow visitors from selected countries | |||
cover_ |
varchar2 |
Cover Properties | |||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
display_ |
varchar2 |
Display Name | |||
has_ |
boolean |
Has Message | |||
id |
int32 |
ID | |||
is_ |
boolean |
Is Published | |||
is_ |
boolean |
SEO optimized | |||
lead_ |
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_ |
varchar2 |
||||
location_ |
varchar2 |
||||
max_ |
int32 |
Schedule not after (days) | |||
meeting_ |
varchar2 |
||||
message_ |
int32 |
Attachment Count | |||
message_ |
varchar2 |
Confirmation Message | Extra information provided once the appointment is booked. | ||
message_ |
varchar2 |
||||
message_ |
boolean |
Message Delivery error | If checked, some messages have a delivery error. | ||
message_ |
int32 |
Number of errors | Number of messages with delivery error | ||
message_ |
boolean |
SMS Delivery error | If checked, some messages have a delivery error. | ||
message_ |
varchar2 |
||||
message_ |
varchar2 |
Introduction Message | Small description of the appointment type. | ||
message_ |
boolean |
Is Follower | |||
message_ |
varchar2 |
||||
message_ |
varchar2 |
||||
message_ |
boolean |
Action Needed | If checked, new messages require your attention. | ||
message_ |
int32 |
Number of Actions | Number of messages which requires an action | ||
message_ |
varchar2 |
Contacts that need to be notified whenever a new appointment is booked or canceled, regardless of whether they attend or not | |||
min_ |
numeric |
Cancel Before (hours) | |||
min_ |
numeric |
Schedule before (hours) | |||
name |
varchar2 |
Appointment Title | |||
opportunity_ |
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_ |
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_ |
varchar2 |
||||
reminder_ |
varchar2 |
||||
seo_ |
varchar2 |
Seo name | |||
sequence |
int32 |
Sequence | |||
slot_ |
varchar2 |
||||
staff_ |
int32 |
# Staff Users | |||
staff_ |
varchar2 |
||||
website_ |
varchar2 |
Website communication history | |||
website_ |
varchar2 |
Website meta description | |||
website_ |
varchar2 |
Website meta keywords | |||
website_ |
varchar2 |
Website opengraph image | |||
website_ |
varchar2 |
Website meta title | |||
website_ |
boolean |
Visible on current website | |||
website_ |
varchar2 |
Website URL | The full URL to access the document through the website. | ||
work_ |
boolean |
Limit to Work Hours | |||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: