{runquery 1}

#

suche
{runquery 9} {runquery 10} {runquery 11} {runquery 15} {runquery 16} {runquery 17}

- Rooms
- Arrivals {field 10.ExpArr}
- In House {field 16.InHouse}
- Departures {field 11.ExpDep}
- Availability Panel {field 9.DefAvl}
{if {feature TableReservation}}
- Restaurants
- Table Reservation {field 17.CountTableRes}
{/if} {if {feature Maintenance}}
- Services
- Maintenance {field 15.CountMaint}
{/if}

{runquery 4}

{forall 4}
- {field 4.ycat_shortdesc} {field 4.yrms_shortdesc} {field 4.Name} {dif '{field 4.VipCode}'<>''} VIP {field 4.VipCode} {/dif}
{/forall}

{runquery 3}

{forall 3}
- {field 3.ycat_shortdesc} {field 3.yrms_shortdesc} {field 3.Name} {dif '{field 3.VipCode}'<>''} VIP {field 3.VipCode} {/dif}
{/forall}

{runquery 7}

{forall 7}
- {field 7.RoomNUmber} {field 7.Name} {field 7.Balance}
{/forall}

{runquery 6} {forall 6} {runsubquery 5.6.YRES_ID}

{forall 5}
Name

{field 5.Name2}

{dif '{field 5.VipCode}'<>''}
VIP

{field 5.VipCode}

{/dif}
Stay

{field 5.Arrivaldate} - {field 5.Departuredate}

Persons

{field 5.Ydet_AdultNo} Adults and {field 5.TotalKids} Children

Room

{field 5.ycat_Shortdesc} {field 5.yrms_Shortdesc}

{dif '{field 5.HASADR}'<>''}
Adress

{field 5.XADR_ZIP} {field 5.XADR_City} {field 5.XADR_Street1}

{/dif} {dif '{field 5.yrms_shortdesc}'<>''} {dif '{field 5.yres_calcstatus}'='1'} {/dif} {/dif}
{/forall}

{/forall}

- Avail Max / Min / Occ. Max / Min
{forall 9}
- {field 9.TheDate} {field 9.DefAvl} / {field 9.TentAvl} / {field 9.MaxOcc} / {field 9.MinOcc}
{/forall}

{forall 1}
- {field 1.restaurant} {field 1.reservations}
{/forall}

{runquery 1} {forall 1} {runsubquery 2.1.RRST_ID}

{forall 2}
- {field 2.starttime} {field 2.Hint_Desc} {field 2.name2} Table {field 2.restables}
{/forall}

{/forall} {runquery 8} {forall 8}

Name

{field 8.Name2}

Restaurant

{field 8.Restaurant}

Table

{field 8.ResTables}

Time

{field 8.Starttime} - {field 8.Endtime}

Persons

{field 8.RRES_PAX} Adults and {field 8.TotalChildren} Children

Description

{field 8.RRES_Description}

{/forall}

{runquery 12} {forall 12} {runsubquery 13.12.WACT_WATY_ID}
- {field 12.WATY_LONGDESC}
{forall 13}
- {field 13.PlaceType} {field 13.Place} Due: {field 13.DueShort}
{/forall} {/forall}

{runquery 14} {forall 14}

Place

{field 14.placetype} {field 14.place}

Entered

{field 14.created_date_time}

Age

{field 14.age_string}

Due

{field 14.Due}

Resp.

{field 14.emp_name}

Problem

{field 14.notes}

{/forall}