{runquery 1} {runquery 2} {runquery 3} {runquery 4} {runquery 6} {runquery 7} {runquery 8} {runquery 9} {runquery 10}{runquery 11}{runquery 12}

{dif '{field 11.ISLIVEDATA}'='1'}{/dif}{else}This is not the Live database !!!{/else}
Arrivals
- {dif {field 8.arrivals.0}=0}
  No arrivals found
{/dif}{else}
Name
Departure
#
Room
Status
Pax
Rate
{forall 3}
- {field 3.name}
  {field 3.YRES_expDEPTIME}
  {field 3.ydet_noofrooms}
  {dif '{field 3.Yrms_shortdesc}'=''} {/dif}{else}{field 3.Yrms_shortdesc}{/else}
  {dif '{field 3.hsk_status}'=''} {/dif}{else}{field 3.hsk_status}{/else}
  {field 3.ydet_adultno}
  {field 3.rate}
{/forall} {dif {field 8.Arrivals.0}>9}
- more...
{/dif} {/else}
Departures
- {dif {field 9.departures.0}=0}
  No departures found
{/dif}{else}
Name
Room
Pax
Open Balance
{forall 4}{runsubquery 5.4.yres_id}
- {field 4.name}
  {dif '{field 4.Yrms_shortdesc}'=''} {/dif}{else}{field 4.Yrms_shortdesc}{/else}
  {field 4.ydet_adultno}
  {field 5.totamount}
{/forall} {dif {field 9.Departures.0}>9}
- more...
{/dif} {/else}
- Total
  Occupied
  Vacant
- Dirty Rooms
  {field 6.dirtytotal}
  {field 6.dirtyoccupied}
  {field 6.dirtyvacant}
- Clean Rooms
  {field 6.cleantotal}
  {field 6.cleanoccupied}
  {field 6.cleanvacant}
- Out of Order Rooms
  {field 6.ooototal}
- Out of Service Rooms
  {field 6.oostotal}
- Revenue Group
  Amount
{forall 7}
- {field 7.ZDCG_LONGDESC}
  {field 7.grossamount}
{/forall}
Conferences
- {dif {field 12.YBOM_ID}=''}
  No conferences found
{/dif}{else}
Start/End Time
Booking Name
Event Name
Company Name
Contact Name
Status
Function Space
Seating
{forall 12}
- {fshorttime}{field 12.yevm_starttime}{/fshorttime} - {fshorttime}{field 12.yevm_endtime}{/fshorttime}
  {field 12.ybom_name}
  {field 12.yevm_name}
  {field 12.Company}
  {field 12.Contact}
  {field 12.yest_shortdesc}
  {field 12.yfsc_longdesc}
  {field 12.yssc_longdesc}
{/forall} {/else}
{constlist}