sp_rsv_pickup_stat


Parameters

Name Type Mode
period_type text IN (DEFAULT NULL)
start_date date IN (DEFAULT NULL)
end_date date IN (DEFAULT NULL)
date_type character IN (DEFAULT 'B')
segment text IN (DEFAULT NULL)
segment_group text IN (DEFAULT NULL)
sort_column text IN (DEFAULT NULL)
limit_rows integer IN (DEFAULT NULL)
filter_text text IN (DEFAULT NULL)
revenue_calc_type integer IN (DEFAULT fn_revenue_calc_type())
days json IN (DEFAULT NULL)
seq integer OUT
group_id integer OUT
group_name text OUT
id integer OUT
name text OUT
new_bookings integer OUT
new_rooms integer OUT
new_roomnights integer OUT
new_revenue t_money OUT
new_adult integer OUT
new_child integer OUT
new_infant integer OUT
clx_bookings integer OUT
clx_rooms integer OUT
clx_roomnights integer OUT
clx_revenue t_money OUT
clx_adult integer OUT
clx_child integer OUT
clx_infant integer OUT
nos_bookings integer OUT
nos_rooms integer OUT
nos_roomnights integer OUT
amd_rooms integer OUT
amd_roomnights integer OUT
amd_revenue t_money OUT
net_bookings integer OUT
net_rooms integer OUT
net_roomnights integer OUT
net_revenue t_money OUT
adr t_money OUT
alos numeric OUT
alt numeric OUT

Definition