<config>
<name>PaymentsByUser</name>
<description>Payments By Users</description>
<defaultgroupby></defaultgroupby>
<dataset></dataset>
<sqlansi>
SELECT p.PAYMENTID,
p.PAYMENTNUM,
p.PAYMENTAMT,
p.PAYMENTCREATEDBYUSERID,
p.PAYMENTCREATEDDATE,
p.PAYMENTAMT,
users.USERNAME,
pm.PAYMETHODNAME,
v.VOUCHERNUM,
v.VOUCHEREXPIRATIONDATE,
s.SUBNUM
FROM PAYMENTS p
INNER JOIN USERS ON USERS.USERID = p.PAYMENTCREATEDBYUSERID AND USERS.USERDELETED = 0
INNER JOIN PAYMENTMETHODS pm ON pm.PAYMETHODID = p.PAYMETHODID AND pm.PAYMETHODDELETED = 0
INNER JOIN VOUCHERS v on v.VOUCHERID = p.VOUCHERID AND v.VOUCHERDELETED = 0
INNER JOIN ACCOUNTSRECEIVABLE acr on acr.ACCRECID = p.ACCRECID AND acr.ACCRECDELETED = 0
INNER JOIN SUBSCRIPTIONS s on s.ACCRECID = acr.ACCRECID AND s.SUBDELETED = 0
ORDER BY p.PAYMENTCREATEDDATE,
users.USERNAME,
p.PAYMENTCREATEDBYUSERID,
p.PAYMETHODID
</sqlansi>
<copysqltosubreports>true</copysqltosubreports>
<hql></hql>
<criterialist>
<criteria>
<ordernum>1</ordernum>
<criteriatype>0</criteriatype>
<label>User Name</label>
<entitytablename>users</entitytablename>
<entityfieldname>USERNAME</entityfieldname>
<fieldtype>ftXString</fieldtype>
<fieldsize>32</fieldsize>
<displaytable>USERS</displaytable>
<displaylabel>Person Name</displaylabel>
<displayfield>UserPersonName</displayfield>
<sourcealias>UserName</sourcealias>
<displayalias>UserPersonName</displayalias>
<datasetname>users.load</datasetname>
</criteria>
<criteria>
<ordernum>2</ordernum>
<criteriatype>0</criteriatype>
<label>Creation Date</label>
<entitytablename>p</entitytablename>
<entityfieldname>PAYMENTCREATEDDATE</entityfieldname>
<fieldtype>ftXdatetime</fieldtype>
<fieldsize>32</fieldsize>
</criteria>
<criteria>
<ordernum>3</ordernum>
<criteriatype>0</criteriatype>
<label>Payment Method</label>
<extralabel>Payment Method</extralabel>
<tooltip></tooltip>
<hibernatefield></hibernatefield>
<entitytablename>p</entitytablename>
<entityfieldname>paymethodid</entityfieldname>
<displaytable>Payments</displaytable>
<displaylabel></displaylabel>
<displayfield>paymethodname</displayfield>
<fieldtype>ftXString</fieldtype>
<fieldsize>32</fieldsize>
<sourcealias>paymethodid</sourcealias>
<displayalias>paymethodname</displayalias>
<datasetname>financialtransactions.loadpaymentmethods</datasetname>
<treename></treename>
<multiselect>1</multiselect>
</criteria>
</criterialist>
</config> | 
