{runquerywithautoparameters 1} {field 1.HotelName}
{field 1.HotelZip} {field 1.HotelCity} {field 1.HotelCountry} {field 1.Siret} {field 1.NAF} {field 1.VAT} {runquerywithautoparameters 2} {runquerywithautoparameters 3} {dif('{field 2.idnum}'<> '')} {field 2.currdatetime} {field 2.fyear} {field 2.fmonth} {field 2.fday} {field 2.cummulative} {field 2.perpetual} {field 2.realperpetual} {field 2.signature} {dif('{field 2.flag}'<>'Y')} Yes {/dif}{else} No {/else} {field 2.prev_signature} {forall 3} {field 3.taxableamount} {field 3.taxrate} {field 3.taxamount} {/forall} {/dif} {runquerywithautoparameters 4} {forall 4} {runsubquery 5.4.TransactionId} {field 4.TransactionId} {field 4.sType} {field 4.InvoiceNum} {field 4.CreationDate} {field 4.InvoiceTotal} {field 4.Cummulative} {field 4.Perpetual} {field 4.Signature} {dif('{field 4.flag}'<>'Y')} Yes {/dif} {dif('{field 4.flag}'<>'N')} No {/dif} {field 4.prev_signature} {forall 5} {field 5.taxrate} {field 5.tax} {/forall} {/forall} {runquerywithautoparameters 6} {dif('{field 6.dupId}')<>''} {forall 6} {field 6.docType} {field 6.sellerId} {field 6.dupNumber} {field 6.dupCount} {field 6.amountlines} {field 6.InvNumber} {field 6.SignDate} {field 6.sign} {dif('{field 6.flag}'<>'Y')} Yes {/dif} {dif('{field 6.flag}'<>'N')} No {/dif} {field 6.prev_sign} {/forall} {/dif} {runquerywithautoparameters 7} {dif('{field 7.InvNumber}')<>''} {forall 7} {field 7.InvType} {field 7.InvNumber} {field 7.InvDate} {runsubquery 13.7.xcmsid} {field 7.guestname}
{field 7.guestzip} {field 7.guestcity} {runsubquery 22.7.addId} {field 22.guestcountry} {dif('{field 13.value}'<>'')} {field 13.value} {/dif} {field 7.InvNumber} {field 7.InvTotal} {field 7.CreationDate} {field 7.sign} {dif('{field 7.flag}'<>'Y')} Yes {/dif}{else} No {/else} {field 7.prev_sign} {runsubquery 8.7.InvId} {forall 8} {field 8.transId} {field 8.transName} {field 8.up} {field 8.quan} {field 8.tit} {field 8.tet} {runsubquery 17.8.transId} {forall 17} {field 17.taxrate} {field 17.taxamount} {/forall} {/forall} {runsubquery 18.7.InvId} {forall 18} {field 18.transId} {field 18.transName} {field 18.paid} {/forall} {/forall} {/dif} {runquerywithautoparameters 9} {dif('{field 9.jetid}'<>'')} {forall 9} {field 9.jetlogtime} `{field 9.jetcode}` {field 9.empid} {field 9.jettext} {field 9.sign} {dif('{field 9.flag}'<>'Y')} Yes {/dif}{else} No {/else} {field 9.prev_sign} {/forall} {/dif} {runquerywithautoparameters 10} {dif('{field 10.invNumber}'<>'')} {forall 10} {field 10.invNumber} {field 10.invDate} {field 10.billtotal} {runsubquery 12.10.invId} {field 12.taxtotal} {field 10.guestname} {field 10.sign} {dif('{field 10.flag}'<>'Y')} Yes {/dif} {dif('{field 10.flag}'<>'N')} No {/dif} {field 10.prev_sign} {runsubquery 19.10.invId} {forall 19} {field 19.transId} {field 19.transName} {field 19.up} {field 19.quan} {field 19.tit} {field 19.tet} {runsubquery 17.19.transId} {forall 17} {field 17.taxrate} {field 17.taxamount} {/forall} {/forall} {/forall} {/dif} {runquerywithautoparameters 14} {dif('{field 14.invId}'<>'')} {forall 14} {field 14.invNumber} {field 14.invDate} {field 14.billtotal} {runsubquery 16.14.invId} {field 16.taxtotal} {field 14.guestname} {field 14.sign} {dif('{field 14.flag}'<>'Y')} Yes {/dif} {dif('{field 14.flag}'<>'N')} No {/dif} {field 14.prev_sign} {runsubquery 20.14.invId} {forall 20} {field 20.transId} {field 20.transName} {field 20.up} {field 20.quan} {field 20.tit} {field 20.tet} {runsubquery 21.20.transId} {forall 21} {field 21.taxrate} {field 21.taxamount} {/forall} {/forall} {/forall} {/dif}