<summary xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../../../xsd/summary.xsd">
<title>Accounts Receivable</title>
<sql>FROM ACCOUNTSRECEIVABLE
LEFT JOIN USERS CREATEDBY ON CREATEDBY.USERID = ACCOUNTSRECEIVABLE.ACCRECCREATEDBYUSERID
LEFT JOIN USERS UPDATEDBY ON UPDATEDBY.USERID = ACCOUNTSRECEIVABLE.ACCRECUPDATEDBYUSERID
LEFT JOIN OUUNITS CREATEDBYUNIT ON CREATEDBYUNIT.OUUID = ACCOUNTSRECEIVABLE.ACCRECCREATEDBYOUUID
LEFT JOIN OUUNITS UPDATEDBYUNIT ON UPDATEDBYUNIT.OUUID = ACCOUNTSRECEIVABLE.ACCRECUPDATEDBYOUUID
LEFT JOIN CONTACTINFORMATION ON CONTACTINFORMATION.CIID = ACCOUNTSRECEIVABLE.CIID
INNER JOIN CONTACTINFODEFINITIONS ON CONTACTINFODEFINITIONS.CIDEFACTIVE = 1 AND CONTACTINFODEFINITIONS.CIDEFDELETED = 0
LEFT JOIN ACCCLASSIFICATIONS ON ACCCLASSIFICATIONS.ACCCLASSID = ACCOUNTSRECEIVABLE.ACCCLASSID
WHERE ACCOUNTSRECEIVABLE.ACCRECDELETED = 0
</sql>
<rowsperpage>20</rowsperpage>
<primaryfield>ACCOUNTSRECEIVABLE.ACCRECID</primaryfield>
<mainlinkfield>ACCOUNTSRECEIVABLE.ACCRECNUM</mainlinkfield>
<orderbyfields>ACCOUNTSRECEIVABLE.ACCRECNUM</orderbyfields>
<module>ACCOUNTS_RECEIVABLE</module>
<fieldlist>
<!-- external filters -->
<field>
<fieldname>ACCOUNTSRECEIVABLE.ACCRECID</fieldname>
<filtertextoption>equal</filtertextoption>
</field>
<!-- fields -->
<field>
<fieldname>ACCOUNTSRECEIVABLE.ACCRECNUM</fieldname>
<caption>No.</caption>
<summary>true</summary>
<filter>true</filter>
<filteravailable>true</filteravailable>
<filtertextoption>like</filtertextoption>
<link>page.do?xml=accounts/accountReceivable&act=itm&jndi=ejb/CRMUIAccountReceivable&fc=loadForm&pv0=((ACCOUNTSRECEIVABLE.ACCRECID))&pvc=1</link>
</field>
<field>
<fieldname>ACCOUNTSRECEIVABLE.ACCRECNAME</fieldname>
<caption>Name</caption>
<summary>true</summary>
<filter>true</filter>
</field>
...
<!-- drilldowns -->
<field>
<fieldname>BILLINGADDRESS</fieldname>
<fieldfunction>''</fieldfunction>
<caption>Billing Address</caption>
<summary>true</summary>
<fieldtype>label</fieldtype>
<label>Billing Address</label>
<link>drilldown:accounts/accountReceivable_billingAddress;hidefilters~true~CONTACTINFORMATION.CIID~((ACCOUNTSRECEIVABLE.CIID))</link>
</field>
...
</fieldlist>
<actions>
<action>
<caption>New</caption>
<topmenu>true</topmenu>
<link>page.do?xml=accounts/accountReceivable&act=new&fc=createButton&jndi=ejb/CRMUIAccountReceivable</link>
</action>
...
</actions>
</summary> |