Derivation Hierarchy

Subclasses:
No Subclasses
Siblings:
No Siblings

Table Details

Name:
sn_apptmnt_booking_service_config
Label:
Appointment Booking Service Configuration (en)
Created On:
2022.12.29 15:33:46
Created By:
admin
Updated On:
2022.12.30 11:16:10
Updated By:
system
Column Updated On:
2022.12.29 15:33:48
Column Updated By:
admin
Scope Name:
Appointment Booking
Scope:
sn_apptmnt_booking
Listing:
open
Dictionary:
open

Columns

+ Status Name Label Datatype Length Scope Reference Included By
  active
Active boolean 40 Appointment Booking sn_apptmnt_booking_service_config
  appointments_per_bookable_slot
Appointments per window integer 40 Appointment Booking sn_apptmnt_booking_service_config
 
M
appointment_booking_config
Configuration reference 32 Appointment Booking sn_apptmnt_booking_config sn_apptmnt_booking_service_config
 
M
appointment_duration
Appointment window choice[choice] 40 Appointment Booking sn_apptmnt_booking_service_config
 
M
availability_table
Availability table table_name 80 Appointment Booking sn_apptmnt_booking_service_config
 
M
average_travel_duration
Travel duration (round trip) choice[choice] 40 Appointment Booking sn_apptmnt_booking_service_config
 
M
bookable_days
Bookable days days_of_week 40 Appointment Booking sn_apptmnt_booking_service_config
  bookable_time
Bookable time string 4096 Appointment Booking sn_apptmnt_booking_service_config
  break_time
Break time string 4096 Appointment Booking sn_apptmnt_booking_service_config
  cancel_by_time
Reschedule/Cancel by time glide_duration 40 Appointment Booking sn_apptmnt_booking_service_config
 
M
catalog_item
Catalog item reference 32 Appointment Booking sc_cat_item_producer sn_apptmnt_booking_service_config
 
M
daily_end_time
Daily end time choice[choice] 40 Appointment Booking sn_apptmnt_booking_service_config
 
M
daily_start_time
Daily start time choice[choice] 40 Appointment Booking sn_apptmnt_booking_service_config
  default_timezone
Timezone choice[choice] 40 Appointment Booking sn_apptmnt_booking_service_config
  enable_day_level_config
Enable day level configuration boolean 40 Appointment Booking sn_apptmnt_booking_service_config
  future_bookable_max_days
Future bookable max days integer 40 Appointment Booking sn_apptmnt_booking_service_config
  holiday_schedule
Holiday Schedule reference 32 Appointment Booking cmn_schedule sn_apptmnt_booking_service_config
  ignore_default_notifications
Ignore Default Notifications boolean 40 Appointment Booking sn_apptmnt_booking_service_config
  include_daily_break
Include daily break boolean 40 Appointment Booking sn_apptmnt_booking_service_config
  lead_time
Lead time glide_duration 40 Appointment Booking sn_apptmnt_booking_service_config
  location
Location reference 32 Appointment Booking item_option_new sn_apptmnt_booking_service_config
  mandatory
Appointment is mandatory boolean 40 Appointment Booking sn_apptmnt_booking_service_config
 
M
D
name
Name translated_text 40 Appointment Booking sn_apptmnt_booking_service_config
  reminder
Appointment reminder choice[choice] 40 Appointment Booking sn_apptmnt_booking_service_config
  sys_created_by
Created by string 40 Appointment Booking sn_apptmnt_booking_service_config
  sys_created_on
Created glide_date_time 40 Appointment Booking sn_apptmnt_booking_service_config
 
K
sys_id
Sys ID GUID 32 Appointment Booking sn_apptmnt_booking_service_config
  sys_mod_count
Updates integer 40 Appointment Booking sn_apptmnt_booking_service_config
  sys_updated_by
Updated by string 40 Appointment Booking sn_apptmnt_booking_service_config
  sys_updated_on
Updated glide_date_time 40 Appointment Booking sn_apptmnt_booking_service_config
 
M
user_contact
User contact reference 32 Appointment Booking item_option_new sn_apptmnt_booking_service_config
 
M
work_duration
Work duration choice[choice] 40 Appointment Booking sn_apptmnt_booking_service_config
P
Passive
M
Mandatory
D
Display Value
K
Key
U
Unique
X
Deleted

Table Distribution

Washington Vancouver Uta Tokyo (Vanilla) Tokyo Sandiego

Deviating Attributes

Column Current Environment Vancouver Uta
use_slot_end_time_as missing

Referenced

sn_apptmnt_booking_service_config referenced from table:
sn_apptmnt_booking_day_configuration

shift+click on node to show path. mouse scroll to zoom, dblclick to zoom in, dblclick+shift to zoom out