Routines

Routines

Name Type Language Deterministic Return Type Security Restriction Comments
sp_get_rate_schedule_js FUNCTION PLPGSQL false record INVOKER
sp_register_card FUNCTION PLPGSQL false SETOF record INVOKER
sp_log_debug FUNCTION SQL false void INVOKER
sp_send_message_to_guest FUNCTION SQL false integer INVOKER
sp_get_folio_patterns_js FUNCTION SQL false json INVOKER
sp_move_transactions FUNCTION PLPGSQL false json INVOKER
sp_get_charge_schedule_v3 FUNCTION SQL false SETOF record INVOKER
sp_tr_update_approved_flag FUNCTION PLPGSQL false trigger INVOKER
sp_tr_guest_request_delete_charges FUNCTION PLPGSQL false trigger INVOKER
sp_get_booking_rooms_js FUNCTION SQL false json INVOKER
sp_check_endday_process PROCEDURE PLPGSQL false INVOKER
sp_lock_booking FUNCTION PLPGSQL false bigint INVOKER
sp_get_issue_card_log FUNCTION PLPGSQL false json INVOKER
sp_get_batch_reports_js FUNCTION SQL false json INVOKER
fn_generate_years FUNCTION SQL true SETOF integer INVOKER
fn_lookup FUNCTION SQL true text INVOKER
sp_get_booking_folio_balances_js FUNCTION SQL false json INVOKER
sp_calc_outstanding FUNCTION PLPGSQL false record INVOKER
sp_recapitulate FUNCTION PLPGSQL false SETOF record INVOKER
sp_endday_check_auto_post PROCEDURE PLPGSQL false INVOKER
sp_check_booking_record_lock FUNCTION PLPGSQL false json INVOKER
sp_save_guest_document FUNCTION PLPGSQL false integer INVOKER
sp_unblock_rooms FUNCTION PLPGSQL false record INVOKER
sp_log_inhouse FUNCTION PLPGSQL false bigint INVOKER
fn_current_shift FUNCTION SQL false t_shift INVOKER
sp_search_guest_folio_js FUNCTION SQL false json INVOKER
sp_get_auto_post_rooms_js FUNCTION SQL false json INVOKER
sp_notify_from_system FUNCTION PLPGSQL false boolean INVOKER
sp_raise_error_if FUNCTION PLPGSQL false void INVOKER
sp_tr_folio_init FUNCTION PLPGSQL false trigger INVOKER
sp_get_keycard_issue_info FUNCTION PLPGSQL false SETOF record INVOKER
sp_trg_itemizer_before_delete FUNCTION PLPGSQL false trigger INVOKER
fn_get_inclusion_desc FUNCTION SQL true text INVOKER
sp_get_sync_roomavail FUNCTION PLPGSQL false json INVOKER
sp_productivity_compare FUNCTION PLPGSQL false SETOF record INVOKER
sp_set_session FUNCTION PLPGSQL false void INVOKER
sp_endday_update_outstanding PROCEDURE SQL false INVOKER
fn_path FUNCTION SQL true text INVOKER
sp_update_guest_inhouse FUNCTION PLPGSQL false record INVOKER
sp_deposit_noshow_charge FUNCTION PLPGSQL false json INVOKER
sp_run_endday_tasks_xxx PROCEDURE PLPGSQL false INVOKER
sp_replace_more_guest_inhouse_json FUNCTION PLPGSQL false json INVOKER
sp_save_inventory FUNCTION PLPGSQL false smallint INVOKER
sp_create_report_file FUNCTION PLPGSQL false record INVOKER
sp_get_folio_balances_js FUNCTION PLPGSQL false json INVOKER
sp_delete_notifications_user FUNCTION PLPGSQL false void INVOKER
sp_expected_arrival_js FUNCTION SQL false json INVOKER
sp_save_rate_schedule FUNCTION PLPGSQL false record INVOKER
fn_calc_link_rate FUNCTION SQL true t_money INVOKER
sp_save_mealtype_json FUNCTION PLPGSQL false json INVOKER
sp_save_guest FUNCTION PLPGSQL false integer INVOKER
sp_delete_more_guest_inhouse_json FUNCTION PLPGSQL false json INVOKER
fn_get_room_charge_dept FUNCTION SQL false integer INVOKER
fn_percent FUNCTION SQL true t_percent INVOKER
sp_cancel_checkin FUNCTION PLPGSQL false record INVOKER
fn_get_mapped_roomtype FUNCTION PLPGSQL false integer INVOKER
fn_match_dows FUNCTION SQL true boolean INVOKER
sp_get_folio_history_js FUNCTION SQL false json INVOKER
sp_calc_requirement_charges FUNCTION SQL false SETOF record INVOKER
fn_get_session2 FUNCTION PLPGSQL false text INVOKER
sp_raise_error FUNCTION PLPGSQL false void INVOKER
sp_check_shift PROCEDURE PLPGSQL false INVOKER
sp_get_rate_schedule FUNCTION PLPGSQL false SETOF record INVOKER
fn_json_diff FUNCTION SQL false jsonb INVOKER
sp_get_department_json FUNCTION PLPGSQL false json INVOKER
sp_db_change_owner FUNCTION PLPGSQL false void INVOKER
sp_get_bedtype_js FUNCTION PLPGSQL false json INVOKER
sp_tr_guest_messages_counter FUNCTION PLPGSQL false trigger INVOKER
fn_format_error FUNCTION SQL true text INVOKER
sp_trg_department_before_delete FUNCTION PLPGSQL false trigger INVOKER
sp_run_endday_task FUNCTION PLPGSQL false boolean INVOKER
sp_get_rateplan_link_details_js FUNCTION SQL false json INVOKER
sp_log_trans FUNCTION SQL false bigint INVOKER
sp_tr_transactions_folio_item_change FUNCTION PLPGSQL false trigger INVOKER
sp_get_available_rates_json FUNCTION PLPGSQL false json INVOKER
sp_get_charge_schedule FUNCTION SQL false SETOF record INVOKER
fn_result_success FUNCTION SQL false json INVOKER
sp_delete_mealtype_json FUNCTION PLPGSQL false json INVOKER
sp_save_draft FUNCTION SQL false integer INVOKER
fn_current_user FUNCTION PLPGSQL false citext INVOKER
sp_gen_request_charge_schedule FUNCTION PLPGSQL false integer INVOKER
sp_set_sys_param FUNCTION SQL false boolean INVOKER
sp_post_transaction FUNCTION PLPGSQL false json INVOKER
fn_find_available_room FUNCTION SQL false SETOF integer INVOKER
sp_void_transaction FUNCTION SQL false json INVOKER
fn_get_record_lock FUNCTION PLPGSQL false json INVOKER
sp_get_notifications_user_js FUNCTION PLPGSQL false json INVOKER

Modify by KenG (2020/05/19)
sp_log_booking FUNCTION PLPGSQL false void INVOKER
sp_search_booking_js FUNCTION PLPGSQL false json INVOKER
sp_booking_rates_breakdown FUNCTION SQL false SETOF record INVOKER
sp_get_posting_folio_patterns_js FUNCTION SQL false json INVOKER

Get guest’s folio pattern
sp_change_room_status1 FUNCTION PLPGSQL false record INVOKER
sp_change_room_status2 FUNCTION PLPGSQL false json INVOKER
fn_prop_name FUNCTION SQL false text INVOKER
sp_get_rate_plans_js FUNCTION SQL false json INVOKER
sp_meal_charges FUNCTION PLPGSQL false SETOF record INVOKER
sp_update_room_charge_schedule FUNCTION PLPGSQL false json INVOKER
fn_plantype_name FUNCTION SQL false text INVOKER
sp_cancel_auto_post FUNCTION PLPGSQL false json INVOKER
sp_check_out FUNCTION PLPGSQL false json INVOKER

Check out single/multiple rooms by specify either register_id/register_ids[] or folio_id/folio_ids[]

[]: ./null []: ./null
sp_tr_room_type_init FUNCTION PLPGSQL false trigger INVOKER
sp_log_warning FUNCTION SQL false void INVOKER
sp_recalc_booking_rooms FUNCTION SQL false void INVOKER
sp_get_available_rates FUNCTION PLPGSQL false SETOF record INVOKER
sp_create_booking FUNCTION PLPGSQL false record INVOKER
sp_tr_channel_log FUNCTION PLPGSQL false trigger INVOKER
sp_unlock_folio FUNCTION PLPGSQL false json INVOKER
sp_get_booking_js FUNCTION SQL false json INVOKER
fn_test FUNCTION PLPGSQL false text INVOKER
fn_get_block_rooms FUNCTION SQL false text INVOKER
sp_init_room_available FUNCTION PLPGSQL false void INVOKER
fn_revenue_calc_type FUNCTION SQL false smallint INVOKER
sp_room_avail_by_roomtype FUNCTION PLPGSQL false SETOF record INVOKER
fn_result_error FUNCTION SQL false json INVOKER
sp_get_guest_document_json FUNCTION PLPGSQL false json INVOKER
sp_execute_endday PROCEDURE PLPGSQL false INVOKER
fn_calc_inclusion_charge FUNCTION SQL true t_money INVOKER
fn_conn_realtime FUNCTION PLPGSQL false citext INVOKER
sp_get_propertyinfo_json FUNCTION PLPGSQL false json INVOKER
sp_group_check_out FUNCTION PLPGSQL false json INVOKER
sp_tr_booking_items_save_log FUNCTION PLPGSQL false trigger INVOKER
sp_tr_guest_request_gen_charges FUNCTION PLPGSQL false trigger INVOKER
sp_get_room_avail_js FUNCTION SQL false jsonb INVOKER
fn_get_rateplan_children FUNCTION SQL false ARRAY INVOKER
sp_trg_masterfile_before_delete FUNCTION PLPGSQL false trigger INVOKER
sp_assign_guest_document FUNCTION PLPGSQL false json INVOKER
sp_approve_rates FUNCTION PLPGSQL false record INVOKER
sp_tr_room_init FUNCTION PLPGSQL false trigger INVOKER
sp_change_maid_status FUNCTION PLPGSQL false record INVOKER
sp_update_rsv_pickup FUNCTION PLPGSQL false record INVOKER
sp_user_log FUNCTION SQL false void INVOKER
sp_get_keycard_issue_info_json FUNCTION PLPGSQL false json INVOKER
sp_tr_guest_init_name FUNCTION PLPGSQL false trigger INVOKER
sp_prop_query FUNCTION PLPGSQL false SETOF record INVOKER
sp_get_charge_schedule1 FUNCTION SQL false SETOF record INVOKER
sp_recapitulate_by_date FUNCTION PLPGSQL false SETOF record INVOKER
sp_save_batch_report_options FUNCTION PLPGSQL false json INVOKER
sp_get_scanned_documents_json FUNCTION PLPGSQL false json INVOKER
sp_endday_mark_noshow PROCEDURE PLPGSQL false INVOKER
fn_current_propcode FUNCTION SQL false text INVOKER
sp_get_rsv_pickup FUNCTION PLPGSQL false SETOF record INVOKER
sp_save_issued_keycard FUNCTION PLPGSQL false jsonb INVOKER
sp_unlock_booking_record_lock FUNCTION PLPGSQL false boolean INVOKER
sp_tr_booking_items_gen_item_id FUNCTION PLPGSQL false trigger INVOKER
sp_endday_clear_data PROCEDURE PLPGSQL false INVOKER
sp_void_transactions FUNCTION PLPGSQL false json INVOKER
sp_tr_room_block_status_changed FUNCTION PLPGSQL false trigger INVOKER
sp_cancel_booking FUNCTION PLPGSQL false record INVOKER
sp_get_charge_schedule1_js FUNCTION SQL false json INVOKER
sp_guest_inhouse_get_available_rate_json FUNCTION PLPGSQL false json INVOKER
sp_get_room_details_js FUNCTION SQL false json INVOKER
sp_center_search_json FUNCTION PLPGSQL false json INVOKER
sp_set_queue_realtime_notify FUNCTION PLPGSQL false boolean INVOKER
sp_reset_roomavail FUNCTION PLPGSQL false void INVOKER
fn_prop_key FUNCTION SQL false text INVOKER
sp_prop_exec FUNCTION SQL false text INVOKER
sp_get_rate_approval FUNCTION SQL false SETOF record INVOKER
sp_get_block_room_js FUNCTION PLPGSQL false json INVOKER
sp_update_transaction FUNCTION PLPGSQL false json INVOKER
sp_db_search_ex FUNCTION SQL false SETOF record INVOKER
fn_date_range FUNCTION SQL true SETOF date INVOKER
sp_recalc_folio_balance FUNCTION SQL false t_money INVOKER
sp_check_record_lock PROCEDURE PLPGSQL false INVOKER
sp_tr_user_logs_init FUNCTION PLPGSQL false trigger INVOKER
sp_lock_folio FUNCTION PLPGSQL false json INVOKER
sp_get_transaction_summary FUNCTION SQL false SETOF record INVOKER
sp_set_current_user FUNCTION PLPGSQL false boolean INVOKER
sp_test_proc PROCEDURE PLPGSQL false INVOKER
sp_endday_gen_batch_report PROCEDURE PLPGSQL false INVOKER
fn_get_target_folio_seq FUNCTION SQL false integer INVOKER
sp_get_photo_user_guest_document FUNCTION PLPGSQL false record INVOKER
sp_tr_department_init FUNCTION PLPGSQL false trigger INVOKER
sp_bulk_update_inventory FUNCTION PLPGSQL false json INVOKER
sp_tr_room_update_room_count FUNCTION PLPGSQL false trigger INVOKER
fn_charge_object FUNCTION SQL true json INVOKER
fn_weekends FUNCTION SQL false json INVOKER
fn_prop_code FUNCTION SQL false text INVOKER
sp_log_cashier FUNCTION SQL false bigint INVOKER
fn_result_warning FUNCTION SQL false json INVOKER
fn_match_day FUNCTION SQL true boolean INVOKER
sp_get_booking_rooms_and_guests_js FUNCTION PLPGSQL false json INVOKER
sp_trial_balance FUNCTION PLPGSQL false SETOF record INVOKER
sp_get_chart_data FUNCTION PLPGSQL false jsonb INVOKER
fn_qty FUNCTION SQL true text INVOKER
sp_reopen_folio FUNCTION PLPGSQL false json INVOKER
sp_bulk_update_inventory2 FUNCTION PLPGSQL false json INVOKER
sp_change_room_status FUNCTION PLPGSQL false json INVOKER
sp_get_rate_plans FUNCTION PLPGSQL false json INVOKER
sp_more_guest_assign_passport_json FUNCTION PLPGSQL false json INVOKER
sp_unlock_all_register_record_lock_by_user_name FUNCTION PLPGSQL false boolean INVOKER
sp_get_endday_process_list_js FUNCTION PLPGSQL false jsonb INVOKER
sp_get_guest_inhouse_js FUNCTION SQL false json INVOKER
sp_get_transaction_codes_js FUNCTION SQL false json INVOKER

List all transaction codes according to guest’s folio pattern
sp_save_guest_document_id_card_json FUNCTION PLPGSQL false json INVOKER
sp_tr_register_guests_update_registered_flag FUNCTION PLPGSQL false trigger INVOKER
sp_deposit_cancellation_charge FUNCTION PLPGSQL false json INVOKER
fn_sellable_statuses FUNCTION SQL false ARRAY INVOKER
sp_save_batch_report FUNCTION SQL false json INVOKER
sp_inventory_rates FUNCTION PLPGSQL false SETOF record INVOKER
sp_tr_followup_counter FUNCTION PLPGSQL false trigger INVOKER
fn_lock_timeout FUNCTION SQL false interval INVOKER
sp_get_rate_comparison_js FUNCTION SQL false json INVOKER
sp_tr_rate_plan_update_parent FUNCTION PLPGSQL false trigger INVOKER
sp_search_transaction_json FUNCTION PLPGSQL false json INVOKER
sp_delete_draft FUNCTION SQL false void INVOKER
sp_endday_increment_system_date PROCEDURE PLPGSQL false INVOKER
sp_tr_files_init FUNCTION PLPGSQL false trigger INVOKER
sp_print_form_header FUNCTION SQL false record INVOKER
sp_get_roomplan_resources_js FUNCTION SQL false json INVOKER
fn_get_session FUNCTION PLPGSQL false text INVOKER
sp_send_message_to_guests FUNCTION PLPGSQL false integer INVOKER
sp_get_folio_print_details FUNCTION SQL false SETOF record INVOKER
fn_get_linked_rateplans FUNCTION SQL false ARRAY INVOKER
sp_get_itemizer_amounts FUNCTION SQL false SETOF record INVOKER
fn_find_target_folio_item FUNCTION SQL false integer INVOKER

Find target folio item in folio pattern using specfied department id
fn_get_request_end FUNCTION SQL true date INVOKER
fn_period_end FUNCTION SQL true date INVOKER
sp_get_checkin_details_js FUNCTION PLPGSQL false json INVOKER
sp_test1 FUNCTION PLPGSQL false SETOF record INVOKER
sp_tr_booking_after_checkin FUNCTION PLPGSQL false trigger INVOKER
sp_productivity_stat_js FUNCTION SQL false json INVOKER
sp_get_rate_plans_js2 FUNCTION SQL false json INVOKER
fn_get_params FUNCTION SQL false ARRAY INVOKER
sp_get_room_charge_schedule FUNCTION SQL false json INVOKER
sp_map_channels_to_rateplan FUNCTION SQL false json INVOKER
sp_endday_post_room_charges PROCEDURE SQL false INVOKER
sp_save_issued_keycard_json FUNCTION PLPGSQL false jsonb INVOKER
sp_tr_registration_deleted FUNCTION PLPGSQL false trigger INVOKER
fn_format_address FUNCTION SQL true text INVOKER
fn_calc_inclusion_qty FUNCTION SQL true integer INVOKER
sp_save_reservation_more_guest_json FUNCTION PLPGSQL false json INVOKER
sp_authen_logout_all FUNCTION SQL false integer INVOKER
sp_get_reports_list_js FUNCTION PLPGSQL false json INVOKER
sp_auto_post_rooms PROCEDURE PLPGSQL false INVOKER
sp_generate_recapitulate FUNCTION PLPGSQL false record INVOKER
sp_expected_departure_js FUNCTION SQL false json INVOKER
sp_rate_discrepancy FUNCTION SQL false SETOF record INVOKER
sp_get_keycard_issue_logs_json FUNCTION PLPGSQL false json INVOKER
sp_seven_days_forecast_js FUNCTION SQL false json INVOKER
sp_tr_deposit_status_changed FUNCTION PLPGSQL false trigger INVOKER
sp_tr_guest_fullname_changed FUNCTION PLPGSQL false trigger INVOKER
fn_result FUNCTION SQL false json INVOKER
sp_save_folio_data FUNCTION PLPGSQL false jsonb INVOKER
sp_check_charge_schedule PROCEDURE PLPGSQL false INVOKER
fn_get_request_nights FUNCTION SQL true integer INVOKER
sp_get_folio_print_header FUNCTION SQL false SETOF record INVOKER
sp_endday_post_requirement_charges PROCEDURE SQL false INVOKER
sp_get_address_lines FUNCTION PLPGSQL true record INVOKER
sp_tr_booking_avail_change FUNCTION PLPGSQL false trigger INVOKER
sp_meal_plan FUNCTION PLPGSQL false SETOF record INVOKER
sp_get_recapitulatexxx FUNCTION PLPGSQL false SETOF record INVOKER
fn_split_period FUNCTION SQL true record INVOKER
sp_check_permission FUNCTION SQL false boolean INVOKER
sp_update_transaction_summary FUNCTION PLPGSQL false record INVOKER
sp_today_stat_js FUNCTION SQL false json INVOKER
fn_sys_param FUNCTION PLPGSQL false time without time zone INVOKER
fn_selected_items FUNCTION PLPGSQL false text INVOKER
sp_change_block_room FUNCTION PLPGSQL false json INVOKER
sp_log_roomstatus FUNCTION PLPGSQL false void INVOKER
fn_user_attribute FUNCTION SQL false text INVOKER
fn_online_shift FUNCTION SQL false t_shift INVOKER
sp_check_avail_diff FUNCTION PLPGSQL false SETOF record INVOKER
fn_default FUNCTION SQL false time without time zone INVOKER
sp_append_log FUNCTION PLPGSQL false bigint INVOKER
sp_change_booking_status FUNCTION PLPGSQL false record INVOKER
sp_get_inventory_by_channel_js FUNCTION PLPGSQL false json INVOKER
sp_save_keycard_log FUNCTION PLPGSQL false jsonb INVOKER
sp_template_function FUNCTION PLPGSQL false json INVOKER
sp_auto_post FUNCTION PLPGSQL false json INVOKER
fn_array_item FUNCTION SQL true text INVOKER
fn_get_request_start FUNCTION SQL true date INVOKER
sp_calc_extra FUNCTION PLPGSQL false record INVOKER
sp_save_rate_calendar FUNCTION PLPGSQL false SETOF record INVOKER
sp_get_user_logs_js FUNCTION PLPGSQL false json INVOKER
sp_get_folio_details_js FUNCTION PLPGSQL false json INVOKER
fn_money_div FUNCTION SQL true t_money INVOKER
sp_trg_department_before_update FUNCTION PLPGSQL false trigger INVOKER
sp_unblock_all FUNCTION PLPGSQL false record INVOKER
sp_get_room_activity FUNCTION SQL false SETOF record INVOKER
sp_tr_deposit_init FUNCTION PLPGSQL false trigger INVOKER
sp_lock_registration FUNCTION PLPGSQL false bigint INVOKER
fn_period FUNCTION PLPGSQL true record INVOKER
fn_get_room_activity FUNCTION SQL false integer INVOKER
fn_get_ooo_desc FUNCTION SQL false text INVOKER
sp_deposit_outstanding FUNCTION PLPGSQL false record INVOKER
sp_get_meal_qty FUNCTION PLPGSQL false record INVOKER
sp_handle_error FUNCTION PLPGSQL false text INVOKER
sp_get_room_avail_detail_js FUNCTION PLPGSQL false jsonb INVOKER
sp_get_followup_js FUNCTION PLPGSQL false json INVOKER

Create by KenG (2020/03/12) # Return json # Condition return - In case 1: all value null will returnn all followup data - In case 2: if have followup_id only -> will return followup and comments where id of followup table - In case 3: if have booking_id only -> will return followup and comments where ref_type = booking and ref_id = booking_id - In case 4: if have register_id only -> will return followup and comments where ref_type = register and ref_id = register_id - In case 5: if have assign_user only -> will return followup and comments where assign_users that have param assign_user (get all followup that assign that user)
sp_get_sys_params_js FUNCTION SQL false json INVOKER
sp_save_rates_and_restrictions FUNCTION PLPGSQL false smallint INVOKER
sp_get_booking_charges FUNCTION SQL false SETOF record INVOKER
sp_update_folio_note FUNCTION PLPGSQL false json INVOKER
sp_occupancy_forecast FUNCTION PLPGSQL false SETOF record INVOKER
sp_create_booking_folio FUNCTION PLPGSQL false integer INVOKER
sp_tr_room_block_avail_change FUNCTION PLPGSQL false trigger INVOKER
sp_tr_guest_request_save_log FUNCTION PLPGSQL false trigger INVOKER
sp_save_registration_rates FUNCTION PLPGSQL false record INVOKER
sp_trg_itemizer_before_update FUNCTION PLPGSQL false trigger INVOKER
sp_tr_registration_regenerate_charges FUNCTION PLPGSQL false trigger INVOKER
sp_productivity FUNCTION PLPGSQL false SETOF record INVOKER
sp_verify_folio FUNCTION PLPGSQL false json INVOKER
sp_get_users FUNCTION PLPGSQL false SETOF record INVOKER
sp_update_registration_summary FUNCTION PLPGSQL false void INVOKER
fn_match_value FUNCTION SQL true boolean INVOKER
sp_seven_days_forecast FUNCTION SQL false SETOF record INVOKER
sp_update_avail FUNCTION SQL false void INVOKER
fn_intf_param FUNCTION SQL false text INVOKER
sp_cancel_checkout FUNCTION PLPGSQL false json INVOKER
sp_check_transaction PROCEDURE PLPGSQL false INVOKER
fn_get_mapped_rateplan FUNCTION PLPGSQL false integer INVOKER
sp_unblock_rooms_old FUNCTION PLPGSQL false record INVOKER
fn_inhouse_summary_js FUNCTION PLPGSQL false json INVOKER
sp_create_folio_item FUNCTION PLPGSQL false integer INVOKER
sp_get_outstanding FUNCTION PLPGSQL false record INVOKER
sp_log_room FUNCTION SQL false bigint INVOKER
sp_occupancy_calendar_js FUNCTION PLPGSQL false json INVOKER
fn_result_confirm FUNCTION SQL false json INVOKER
fn_open_cashsale_folio FUNCTION PLPGSQL false integer INVOKER
sp_delete_batch_report FUNCTION PLPGSQL false json INVOKER
sp_tr_booking_items_avail_change FUNCTION PLPGSQL false trigger INVOKER
sp_get_guest_list_js FUNCTION SQL false json INVOKER
fn_length FUNCTION SQL true integer INVOKER
sp_get_draft FUNCTION SQL false json INVOKER
sp_get_roomplan_events_js FUNCTION PLPGSQL false json INVOKER
sp_log_info FUNCTION SQL false void INVOKER
sp_trg_vip_before_delete FUNCTION PLPGSQL false trigger INVOKER
sp_send_mail FUNCTION PLPYTHON3U false integer INVOKER
sp_tr_registration_avail_change FUNCTION PLPGSQL false trigger INVOKER
sp_get_rate_summary_js FUNCTION SQL false json INVOKER
sp_save_guest_js FUNCTION PLPGSQL false integer INVOKER
sp_check_out_old FUNCTION PLPGSQL false json INVOKER
sp_get_guest_folio_pattern_json FUNCTION PLPGSQL false jsonb INVOKER
sp_tr_department_group_init FUNCTION PLPGSQL false trigger INVOKER
fn_check_endday_processing FUNCTION SQL false boolean INVOKER
fn_quantity FUNCTION SQL true text INVOKER
sp_search_guest_in_house_js FUNCTION PLPGSQL false json INVOKER
sp_check_register_record_lock FUNCTION PLPGSQL false json INVOKER
sp_verify_rate_and_available FUNCTION PLPGSQL false json INVOKER
sp_save_rateplan_channel_mapping FUNCTION PLPGSQL false json INVOKER
fn_period_start FUNCTION SQL true date INVOKER
sp_get_checkin_summary_js FUNCTION SQL false json INVOKER
sp_get_rateplan_mapping_channel_json FUNCTION PLPGSQL false json INVOKER
sp_trg_room_before_update_connecting_room FUNCTION PLPGSQL false trigger INVOKER
sp_update_outstanding FUNCTION PLPGSQL false record INVOKER
fn_random_range FUNCTION PLPGSQL false integer INVOKER
sp_change_bedtype FUNCTION PLPGSQL false record INVOKER
fn_handle_error FUNCTION PLPGSQL false json INVOKER
sp_check_room_available FUNCTION PLPGSQL false record INVOKER

result_code, msg_code 0, 10100 : Available 4, 10101 : All rooms were full 2, 10102 : Specified room type is not sellable (confirm user to make booking) 4, 10103 : Specified room type not enough, overbook not allow 2, 10104 : Specified room type not enough (confirm user to make booking)
sp_get_rate_plans_js_old FUNCTION PLPGSQL false json INVOKER
sp_trg_room_after_update_connecting_room FUNCTION PLPGSQL false trigger INVOKER
sp_check_out_booking FUNCTION PLPGSQL false json INVOKER
fn_prop_config FUNCTION SQL false SETOF text INVOKER

Create by KenG (2020/06/06)
sp_get_posting_departments_js FUNCTION SQL false json INVOKER

List all departments according to guest’s folio pattern
sp_save_guest_folio_pattern FUNCTION PLPGSQL false jsonb INVOKER
sp_change_room_status_old FUNCTION PLPGSQL false record INVOKER
sp_get_rate_approval_js FUNCTION SQL false json INVOKER
fn_room_number FUNCTION SQL false text INVOKER
fn_calc_itemizers FUNCTION SQL false record INVOKER
fn_get_itemizer_amounts FUNCTION SQL false jsonb INVOKER
fn_map FUNCTION SQL false anyelement INVOKER
sp_update_out_of_order FUNCTION PLPGSQL false record INVOKER
sp_close_cashsale_folio FUNCTION PLPGSQL false json INVOKER
sp_close_folio FUNCTION PLPGSQL false json INVOKER
sp_replace_guest_assign_passport_json FUNCTION SQL false json INVOKER
sp_get_charge_schedule_js FUNCTION SQL false json INVOKER
sp_get_user_logs FUNCTION SQL false SETOF record INVOKER
sp_parse_report_param FUNCTION PLPGSQL false jsonb INVOKER
sp_get_reports_option_js FUNCTION PLPGSQL false jsonb INVOKER
fn_work_shift FUNCTION SQL false t_shift INVOKER
sp_mealplan_forecast FUNCTION SQL false SETOF record INVOKER
sp_get_inventory_js FUNCTION PLPGSQL false json INVOKER
sp_get_room_info_js FUNCTION SQL false json INVOKER
sp_get_booking_rooms_and_guests_js2 FUNCTION SQL false json INVOKER
sp_tr_out_of_order_avail_change FUNCTION PLPGSQL false trigger INVOKER
sp_run_batch_report FUNCTION SQL false integer INVOKER
sp_get_batch_report_details_js FUNCTION SQL false json INVOKER
fn_system_date FUNCTION SQL false date INVOKER
sp_endday_update_room_status PROCEDURE PLPGSQL false INVOKER
sp_endday_gen_transaction_summary PROCEDURE SQL false INVOKER
sp_verify_rate_and_available2 FUNCTION PLPGSQL false record INVOKER
sp_get_folio_details1_js FUNCTION PLPGSQL false json INVOKER
sp_update_endday_task FUNCTION PLPGSQL false boolean INVOKER
sp_update_propertyinfo_json FUNCTION PLPGSQL false json INVOKER
sp_search_guest_js FUNCTION PLPGSQL false json INVOKER
sp_tr_room_activity_update_usage FUNCTION PLPGSQL false trigger INVOKER
sp_get_booking_summary_js FUNCTION PLPGSQL false jsonb INVOKER
fn_prop_id FUNCTION SQL false integer INVOKER
sp_endday_gen_recapitulate PROCEDURE SQL false INVOKER
sp_db_reset_data PROCEDURE PLPGSQL false INVOKER
fn_query_to_json FUNCTION PLPGSQL false json INVOKER
sp_finish_log FUNCTION SQL false void INVOKER
sp_unconfirm_booking FUNCTION PLPGSQL false record INVOKER
sp_update_rategroup_by_id_json FUNCTION PLPGSQL false json INVOKER
fn_get_mapped_channel FUNCTION PLPGSQL false integer INVOKER
sp_endday_update_room_summary PROCEDURE SQL false INVOKER
sp_get_occupancy_calendar FUNCTION PLPGSQL false SETOF record INVOKER
sp_get_params FUNCTION PLPGSQL false SETOF record INVOKER
sp_test_endday_task PROCEDURE PLPGSQL false INVOKER
fn_get_rateplan_parents FUNCTION SQL false ARRAY INVOKER
sp_tr_group_info_name_changed FUNCTION PLPGSQL false trigger INVOKER
sp_tr_booking_update_booking_name FUNCTION PLPGSQL false trigger INVOKER
sp_rate_calendar_js2 FUNCTION PLPGSQL false json INVOKER
fn_validate_shift FUNCTION SQL false t_shift INVOKER
sp_change_ooo_period FUNCTION PLPGSQL false json INVOKER
sp_search_room_js FUNCTION PLPGSQL false json INVOKER
fn_get_guest_revenues_js FUNCTION SQL false jsonb INVOKER
sp_get_room_available FUNCTION SQL false SETOF record INVOKER
sp_rate_calendar_js FUNCTION PLPGSQL false json INVOKER
sp_parse_guest_name FUNCTION PLPGSQL false record INVOKER
fn_generate_dropdown_items FUNCTION PLPGSQL false json INVOKER
sp_get_room_summary FUNCTION PLPGSQL false SETOF record INVOKER
sp_update_guest_stat FUNCTION SQL false record INVOKER
fn_period_to_str FUNCTION SQL true text INVOKER
sp_tr_followup_alert FUNCTION PLPGSQL false trigger INVOKER
fn_booking_summary_js FUNCTION PLPGSQL false json INVOKER
sp_get_checkout_balances_js FUNCTION PLPGSQL false json INVOKER
sp_check_folio PROCEDURE PLPGSQL false INVOKER
sp_change_departure FUNCTION PLPGSQL false json INVOKER
sp_system_notify FUNCTION SQL false bigint INVOKER
sp_get_registration_summary_js FUNCTION SQL false json INVOKER
sp_endday_check_non_extensions PROCEDURE PLPGSQL false INVOKER
fn_age_str FUNCTION SQL false text INVOKER
fn_get_param FUNCTION SQL false text INVOKER
sp_monthly_revenue FUNCTION SQL false SETOF record INVOKER
sp_tr_booking_save_log FUNCTION PLPGSQL false trigger INVOKER
sp_change_online_shift FUNCTION SQL false boolean INVOKER
sp_delete_rategroup_by_id_json FUNCTION PLPGSQL false json INVOKER
sp_tr_registration_request_gen_charges FUNCTION PLPGSQL false trigger INVOKER
sp_change_stay_room FUNCTION PLPGSQL false json INVOKER
fn_user_email FUNCTION SQL false text INVOKER
sp_trg_vip_before_update FUNCTION PLPGSQL false trigger INVOKER
sp_open_cashsale_folio FUNCTION PLPGSQL false json INVOKER
sp_save_guests_js FUNCTION SQL false ARRAY INVOKER
sp_convert_supper_block FUNCTION PLPGSQL false record INVOKER
fn_get_transaction_js FUNCTION SQL false json INVOKER
sp_save_guest_document_passport_json FUNCTION PLPGSQL false json INVOKER
sp_add_out_of_order FUNCTION PLPGSQL false record INVOKER
sp_split_transaction FUNCTION PLPGSQL false json INVOKER
sp_update_booking_summary FUNCTION PLPGSQL false void INVOKER
sp_log_guest FUNCTION SQL false bigint INVOKER
sp_tr_update_system_params FUNCTION PLPGSQL false trigger INVOKER
sp_map_rateplans_to_channel FUNCTION PLPGSQL false json INVOKER
sp_auto_post_requirement_charges FUNCTION PLPGSQL false record INVOKER
sp_gen_booking_rates PROCEDURE PLPGSQL false INVOKER
fn_fullname FUNCTION PLPGSQL false text INVOKER
sp_addnew_guest_assign_passport_json FUNCTION SQL false json INVOKER
fn_conn_authen FUNCTION PLPGSQL false citext INVOKER
sp_unlock_register_record_lock FUNCTION PLPGSQL false boolean INVOKER
sp_update_cashsale_folio FUNCTION PLPGSQL false json INVOKER
sp_block_rooms FUNCTION PLPGSQL false record INVOKER
sp_auto_post_room_charges FUNCTION PLPGSQL false record INVOKER
sp_save_rategroup_json FUNCTION PLPGSQL false json INVOKER
sp_db_import_roomrecap PROCEDURE PLPGSQL false INVOKER
sp_get_guest_js FUNCTION SQL false json INVOKER
sp_tr_followup_notificattion FUNCTION PLPGSQL false trigger INVOKER
sp_get_guest_stat FUNCTION SQL false SETOF record INVOKER
sp_auto_block_rooms FUNCTION PLPGSQL false json INVOKER
sp_calc_meal FUNCTION PLPGSQL false numeric INVOKER
sp_check_folio_item PROCEDURE PLPGSQL false INVOKER
fn_pax FUNCTION SQL true text INVOKER
sp_get_rate_inclusions FUNCTION SQL false SETOF record INVOKER
sp_get_folio_printing_items FUNCTION SQL false SETOF record INVOKER
sp_get_rateplan_amount FUNCTION PLPGSQL false t_money INVOKER
sp_transfer_transactions FUNCTION PLPGSQL false json INVOKER

Transfer transactions to another folio
sp_save_guest_requests FUNCTION PLPGSQL false record INVOKER
fn_get_request_qty FUNCTION PLPGSQL true integer INVOKER
sp_search_transaction_js FUNCTION SQL false json INVOKER
sp_process_booking FUNCTION PLPGSQL false SETOF record INVOKER
sp_get_scan_inhouse_json FUNCTION SQL false json INVOKER
fn_accommodation FUNCTION SQL true text INVOKER
sp_query_logs FUNCTION SQL false SETOF sys_log INVOKER
fn_lookup_values FUNCTION PLPGSQL false text INVOKER
sp_update_mealtype_by_id_json FUNCTION PLPGSQL false json INVOKER
sp_get_recapitulate FUNCTION PLPGSQL false SETOF record INVOKER
fn_month_end FUNCTION SQL false date INVOKER
fn_rate_link_description FUNCTION SQL false text INVOKER
sp_save_draft_booking_js FUNCTION PLPGSQL false jsonb INVOKER
fn_get_params_old FUNCTION SQL false ARRAY INVOKER
sp_tr_registration_save_log FUNCTION PLPGSQL false trigger INVOKER
sp_save_rate_plan FUNCTION PLPGSQL false json INVOKER
sp_log_error FUNCTION SQL false void INVOKER
sp_tr_room_validate_roomno FUNCTION PLPGSQL false trigger INVOKER
sp_get_online_shift FUNCTION PLPGSQL false text INVOKER
sp_log_endday PROCEDURE PLPGSQL false INVOKER
sp_trg_registration_before_update_extend_stay FUNCTION PLPGSQL false trigger INVOKER
sp_enqueue_realtime FUNCTION PLPGSQL false boolean INVOKER
sp_db_search FUNCTION SQL false SETOF record INVOKER
sp_set_param FUNCTION PLPGSQL false boolean INVOKER
fn_format_log FUNCTION PLPGSQL false text INVOKER
sp_trg_masterfile_before_update FUNCTION PLPGSQL false trigger INVOKER
sp_sys_log FUNCTION SQL false void INVOKER
sp_calc_itemizers FUNCTION SQL false SETOF record INVOKER
sp_update_room_summary FUNCTION PLPGSQL false record INVOKER
sp_check_in FUNCTION PLPGSQL false json INVOKER
sp_tr_deposit_save_log FUNCTION PLPGSQL false trigger INVOKER
sp_get_payment_codes_js FUNCTION SQL false json INVOKER

List all payment codes
sp_make_payment FUNCTION PLPGSQL false json INVOKER
sp_calc_meal_prices FUNCTION PLPGSQL false SETOF record INVOKER
sp_endday_update_rsv_pickup PROCEDURE SQL false INVOKER
sp_rate_schedule_breakdown FUNCTION SQL false SETOF record INVOKER
sp_productivity_by_geocode FUNCTION SQL false SETOF record INVOKER
sp_endday_update_task PROCEDURE PLPGSQL false INVOKER
sp_delete_guest_document_json FUNCTION PLPGSQL false json INVOKER
sp_confirm_booking FUNCTION PLPGSQL false record INVOKER
sp_delete_out_of_order FUNCTION PLPGSQL false record INVOKER
sp_get_rategroup_by_id_json FUNCTION PLPGSQL false json INVOKER
sp_check_room_activity PROCEDURE PLPGSQL false INVOKER
sp_reopen_cashsale_folio FUNCTION PLPGSQL false json INVOKER
sp_amend_booking FUNCTION PLPGSQL false record INVOKER
sp_get_batch_report_options FUNCTION PLPGSQL false json INVOKER
sp_change_folio_pattern FUNCTION PLPGSQL false json INVOKER
fn_itemizer FUNCTION PLPGSQL false t_money INVOKER
fn_month_start FUNCTION SQL false date INVOKER
sp_send_message FUNCTION PLPGSQL false bigint INVOKER
sp_get_available_rates_js FUNCTION PLPGSQL false record INVOKER
sp_select_room_id_by_roomnumber FUNCTION PLPGSQL false integer INVOKER
sp_db_create_backup_table PROCEDURE PLPGSQL false INVOKER