aonestar.public

Parameters

Name	Type	Mode
folio_item_id	integer	IN
folio_id	integer	OUT
folio_seq	integer	OUT
folio_name	text	OUT
folio_closed	boolean	OUT
folio_note	text	OUT
folio_type	t_folio_type	OUT
register_id	integer	OUT
register_status	character	OUT
booking_id	integer	OUT
booking_status	character	OUT
name	text	OUT
company	text	OUT
address1	text	OUT
address2	text	OUT
country	text	OUT
room_number	text	OUT
arrival	date	OUT
departure	date	OUT
adult	smallint	OUT
child	smallint	OUT
infant	smallint	OUT
channel	text	OUT
rate_plan	text	OUT

Definition

SELECT fi.folio_id, fi.folio_seq, fi.folio_name, fi.closed AS folio_closed, 
        fi.note AS folio_note, f.folio_type, f.register_id, 
        rg.status AS register_status, f.booking_id, b.status AS booking_status, 
        COALESCE(b.booking_name, g.full_name, cs."name") AS name, 
        COALESCE(g.company, cs.company), 
        COALESCE(g.address1, cs.address1), 
        COALESCE(g.address2, cs.address2), 
        ct."name" AS country, 
        rm.room_number, coalesce(rg.arrival, b.arrival, f.open_date), coalesce(rg.departure, b.departure, f.close_date),
        rg.adult, rg.child, rg.infant, cn."name" AS channel, rp."name" AS rate_plan
    FROM folio_items fi 
        LEFT JOIN folio f ON f.id = fi.folio_id 
        LEFT JOIN registration rg ON rg.id = f.register_id 
        LEFT JOIN booking b ON b.id = f.booking_id 
        LEFT JOIN cash_sale cs ON cs.folio_id = f.id 
        LEFT JOIN guest g ON g.id = coalesce(rg.guest_id, b.guest_id)
        LEFT JOIN room rm ON rm.id = rg.room_id
        LEFT JOIN rate_plan rp ON rp.id = rg.rateplan_id 
        LEFT JOIN channel cn ON cn.id = coalesce(rg.channel_id, b.channel_id, cs.channel_id)
        LEFT JOIN country ct ON ct.id = g.country_id 
    WHERE fi.item_id = $1

sp_get_folio_print_header

Parameters

Definition