table - sn_apptmnt_booking_service_config «Appointment Booking Service Configuration»

Derivation Hierarchy

sn_apptmnt_booking_service_config
«Appointment Booking Service Configuration»

Appointment Booking

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

Passive

Mandatory

Display Value

Key

Unique

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

Diagram sn_apptmnt_booking_service_config «Appointment Booking Service Configuration» / Appointment Booking (sn_apptmnt_booking)

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