{runquery 1} {runquery 2} {runquery 3} {runquery 4} {runquery 5} {runquery 6}
{field 1.name2} {dif {field 2.yres_id.0}=0}{/dif}
{else} ( {translatestatictext 'Res.No.:'.{const language}} {field 2.yres_id} ){/else}
{dif {field 2.yres_id.0}=0}{/dif}{else}
- {translatestatictext 'Open Balance'.{const language}}
  {field 2.BALANCE} {field 2.currency}
- {translatestatictext 'Credit limit of'.{const language}} {field 2.yres_creditlimit} {field 2.currency} {translatestatictext 'exceeded by'.{const language}}
  {dif {field 2.EXCEEDED_BALANCE.0}>0}
  {field 2.EXCEEDED_BALANCE} {field 2.currency}
  {/dif} {else}
  {field 2.EXCEEDED_BALANCE} {field 2.currency}
  {/else}
- {translatestatictext 'Arrival'.{const language}}
  {field 2.Arrivalday}, {field 2.arrivaldate}
- {translatestatictext 'Departure'.{const language}}
  {field 2.Departureday}, {field 2.departuredate}
- {translatestatictext 'Room No.'.{const language}}
  {field 2.yrms_shortdesc}
- {translatestatictext 'Company'.{const language}}
  {field 2.COMPANY_NAME}
- {translatestatictext 'Travel Agent'.{const language}}
  {field 2.TRAVELAGENT_NAME}
- {translatestatictext 'Source'.{const language}}
  {field 2.SOURCE_NAME}
{/else}
- {translatestatictext 'Preferred Table'.{const language}}
  {field 1.PREF_TABLES_SHORT}
- {translatestatictext 'Preferred Restaurant'.{const language}}
  {field 1.PREF_RESTAURANTS_LONG}
- {translatestatictext 'Table Res. Statistics'.{const language}}
- {dif {field 3.RRES_ID.0}=0}{/dif} {else}
  {translatestatictext 'Table Reservations'.{const language}}
  {dif {field 3.TABLERES}=1}{/dif} {else} {/else} {/else}
- {translatestatictext 'Avrg. Check Amount'.{const language}}
  {dif {field 6.xcms_id.0}=0}
  {translatestatictext 'No POS Revenue'.{const language}}
  {/dif} {else}
  {field 6.AVG_REV_GUEST} {field 5.currency}
  {/else}
- {translatestatictext 'Avrg. Rev. by Restaurant/Department'.{const language}}
  {dif {field 6.xcms_id.0}=0}
  {translatestatictext 'No POS Revenue'.{const language}}
  {/dif} {else}
  {/else}
- {translatestatictext 'Total POS Revenue'.{const language}}
  {dif {field 4.TotalPosRev.0}=0}
  {translatestatictext 'No POS Revenue'.{const language}}
  {/dif} {else}
  {field 4.TotalPosRev} {field 5.currency}
  {/else}
- {translatestatictext 'Top Consumptions'.{const language}}
  {dif {field 4.TotalPosRev.0}=0}
  {translatestatictext 'No POS Revenue'.{const language}}
  {/dif} {else}
  {/else}
- {translatestatictext 'Last 10 Consumptions'.{const language}}
  {dif {field 4.TotalPosRev.0}=0}
  {translatestatictext 'No POS Revenue'.{const language}}
  {/dif} {else}
  {/else}
- {translatestatictext 'Consumption by Overgroup'.{const language}}
  {dif {field 4.TotalPosRev.0}=0}
  {translatestatictext 'No POS Revenue'.{const language}}
  {/dif} {else}
  {/else}