Booking Type Booking Status

The BookingTypeBookingStatus table in the Payment package provides an overview of the current booking status of each type of booking. This table contains columns to indicate the booking type, the status of the booking, and other useful information related to the booking, such as the amount paid and the date of the booking. This table helps Payment module users view and track their various booking statuses at a glance.

Body Params
int32

BookingTypeBookingStatusId is an int field in the BookingTypeBookingStatus table and represents a unique identifier for each specific combination of booking type and booking status. The value assigned to this identity field is used to reference these records when joining other database tables.

string | null

BookingStatusId is a data field in the BookingTypeBookingStatus table of type nvarchar with a maximum length of 128. It is a unique identifier used to identify the booking status of a reservation.

int32

The sequence field records an integer-based order associated with each BookingTypeBookingStatus record in the BookingTypeBookingStatus table; it is used to ensure that the data is stored in a predefined sequence.

string | null

FilterCondition is an nvarchar field with a maximum length of 128 in the BookingTypeBookingStatus table. This field is used to store a condition value for applying a filter when retrieving data associated with a particular booking type and status combination.

int32 | null

SystemRoleId is an integer that will identify the user roles associated with a BookingTypeBookingStatus row in the table. It will link the BookingTypeBookingStatus table to other tables in the system that contain user roles.

int32

The ActionId field is an integer data type field in the BookingTypeBookingStatus table that is used to store an identification number for the action taken on a given booking type-booking status (for example, 'Add' for addition, or 'Remove' for removal).

boolean

The Notify field in the BookingTypeBookingStatus table is a bit data type field that is used to indicate if the user should be notified of new changes or updates to a booking. This field is used to track if the user should be notified once the booking is either modified or cancelled. A value of 0 indicates the user should not be notified, while a value of 1 indicates the user should be notified.

boolean

ExclusiveAccount is a bit field in the BookingTypeBookingStatus table that tracks whether or not a booking type has exclusive access to a particular account. The possible values for this field are 0 for not exclusive and 1 for exclusive access.

Response
200

OK

Language
URL
Response
Click Try It! to start a request and see the response here!