sp_rate_schedule_breakdown


Parameters

Name Type Mode
post_date date IN (DEFAULT NULL)
posted boolean IN (DEFAULT NULL)
register_id integer IN (DEFAULT NULL)
status character IN (DEFAULT 'I')
charge_to_booking boolean IN (DEFAULT false)
register_id integer OUT
charge_date date OUT
arrival date OUT
departure date OUT
adult smallint OUT
child smallint OUT
infant smallint OUT
extra_adult smallint OUT
extra_child smallint OUT
room_id integer OUT
rateplan_id integer OUT
mealtype_id integer OUT
rate_amount t_money OUT
room t_money OUT
extrabed t_money OUT
abf t_money OUT
lunch t_money OUT
dinner t_money OUT
inclusive t_money OUT
other t_money OUT
inclusive_items json OUT
other_items json OUT
charge_to_booking boolean OUT
room_posted boolean OUT
other_posted boolean OUT
approved boolean OUT
abf_included t_money OUT
lunch_included t_money OUT
dinner_included t_money OUT
abf_extra t_money OUT
lunch_extra t_money OUT
dinner_extra t_money OUT

Definition