{runquery 1}{runsubquery 2.1.xcms_id} {runsubquery 3.1.xcms_id} {runsubquery 4.1.xcms_id}{runquery 5}{runsubquery 6.1.xcms_id}{runsubquery 7.1.xcms_id} {runsubquery 8.1.xcms_id}{runsubquery 9.1.xcms_id} {runsubquery 10.1.xcms_id} {runsubquery 11.1.xcms_id} {runsubquery 12.1.xcms_id} {runsubquery 13.1.xcms_id}{runsubquery 14.1.xcms_id}{runsubquery 15.1.xcms_id}{runsubquery 16.1.xcms_id} {runsubquery 17.1.xcms_id} {runsubquery 18.1.xcms_id} {runsubquery 19.1.xcms_id} {runsubquery 20.1.xcms_id} {runsubquery 21.1.xcms_id} {runsubquery 22.1.xcms_id} {runquery 23} {runsubquery 24.1.xcms_id} {runsubquery 25.1.xcms_id} {runquerywithparameter 26.parameter.{userid}} {runsubquery 27.1.xcms_id}
Profile Information
- Company Name
  {field 1.xcms_name1} {field 1.xcms_name2} {field 1.xcms_name3} {dif '{field 24.OrgHotel}'=''}{/dif} {else} Created in {field 24.OrgHotel}{/else}
{dif {field 1.xcms_active.0}=1}{/dif}{else}
- Inactive
  Date: {field 1.xcms_inacttime} Reason: {field 1.xcms_inactreason}
{/else} {dif('{field 1.xcms_creditstat}'='')}{/dif}{else}
- Credit Status
  {dif '{field 1.xcms_creditstat}'='B'} {field 1.CREDITSTAT} {dif '{field 1.xcms_credtime}'=''}{/dif}{else} Date: {field 1.xcms_credtime} Reason: {field 1.xcms_credreason}{/else} {/dif} {dif '{field 1.xcms_creditstat}'='C'} {field 1.CREDITSTAT} {dif '{field 1.xcms_credtime}'=''}{/dif}{else} Date: {field 1.xcms_credtime} Reason: {field 1.xcms_credreason}{/else} {/dif} {dif '{field 1.xcms_creditstat}'='A'} {field 1.CREDITSTAT} {dif '{field 1.xcms_credtime}'=''}{/dif}{else} Date: {field 1.xcms_credtime} Reason: {field 1.xcms_credreason}{/else} {/dif}
{/else} {dif '{field 1.xccd_division}'=''}{/dif}{else}
- Division
  {field 1.xccd_division}
{/else}
- Address
  {field 17.address}
{dif '{field 3.xcom_value}'=''}{/dif}{else}
- Communication
  {forall 3}
  {field 3.xcmt_longdesc}
  {dif {field 3.xcmt_type}=2} {field 3.xcom_value} {/dif} {else} {dif {field 3.xcmt_type}=1} {field 3.xcom_value} {/dif} {else}{field 3.xcom_value} {/else} {/else}
  {/forall}
{/else} {dif {field 20.XMSL_SUB_ID.0}=0}{/dif}{else}
- Master Companies
  {forall 20}{field 20.Name1} {field 20.Name2} {field 20.Name3}
  {/forall}
{/else} {dif {field 21.XMSL_MASTER_ID.0}=0}{/dif}{else}
- Sub Companies
  {forall 21}{field 21.Name1} {field 21.Name2} {field 21.Name3}
  {/forall}
{/else} {dif({field 22.XCCL_TO_XCMS_ID.0}=0)}{/dif}{else}
- Linked Companies
  {forall 22}{field 22.CompanyName1} {field 22.CompanyName2} {field 22.CompanyName3}
  {/forall}
{/else} {dif {field 9.Contact_XCMS_ID.0}=0}{/dif}{else}
- Linked Contacts
  {forall 9} {field 9.ContactLastName}, {field 9.ContactFirstName} {field 9.ContactMiddleInitial} {field 9.xcid_addrgreet}
  {/forall}
{/else} {dif '{field 10.YRch_Shortdesc}'=''}{/dif}{else}
- Rate Codes
  {forall 10}{field 10.YRch_Shortdesc} {/forall}
{/else} {dif {field 13.xcno_id.0}=0}{/dif}{else}
- Notes
  {forall 13} {dif ({field 13.xcnc_restriction.0}=1) and ({field 26.RestrictedNotesAllowed.0}=0)}{/dif}{else} {field 13.xcnc_shortdesc}: {field 13.xcno_notes}
  {/else} {/forall}
{/else}
Statistics
- Room Nights
  {dif {field 16.RoomNights.0}=0}0{/dif}{else} {field 16.RoomNights} {/else}
- Adult Nights
  {dif {field 16.AdultNights.0}=0}0{/dif}{else} {field 16.AdultNights.}{/else}
- Stays
  {dif {field 16.Arrivals.0}=0}0{/dif}{else} {field 16.Arrivals}{/else}
- Revenue
  {field 25.TotalGrossRevenue} {field 23.Currency}
{dif '{field 14.xmty_longdesc}'=''}{/dif}{else}
- A/R
  Credit Limit
  Balance
{forall 14}
- {dif {field 14.xmnr_value.0}=0} {/dif}{else}{field 14.xmnr_value}{/else}
  {field 14.creditlimit}
  {dif '{field 14.BALANCE.0}'='0'} 0.00 {/dif}{else} {field 14.BALANCE}{/else}
{/forall} {/else} {dif '{field 27.NOOFROOMS.0}'='0'}{/dif}{else}
- Summary Future Reservations (Room Nights incl. Block Pick Up)
  {forall 27}
- {field 27.DATE_YEAR}
  {field 27.DATE_MONTH}
  {field 27.NOOFROOMS}
  {field 27.REVENUE_GROSS} {field 23.Currency}
{/forall} {/else} {dif '{field 6.YRES_EXPARRTIME.0}'='0'}{/dif}{else}
- Next Reservations
  {forall 6}
- {field 6.YRES_ID} {field 6.xcms_name1}
  {field 6.YRES_EXPARRTIME}
  {field 6.ycat_shortdesc}
{/forall} {/else} {dif '{field 7.ybom_arrival.0}'='0'}{/dif}{else}
- Next Conference Bookings
  {forall 7}
- {field 7.ybom_id}
  {field 7.ybom_arrival}
  {field 7.ybom_name}
{/forall} {/else}