...
<fielditem>
<field>
(CASE
WHEN CONTACTINFORMATION.CITYPE = 'COMPANY'
THEN CONTACTINFORMATION.CICOMPANYNAME
WHEN (SELECT CONTACTINFODEFINITIONS.CIDEFNAMEGENRULE
FROM CONTACTINFODEFINITIONS WHERE CIDEFACTIVE = 1 AND CIDEFDELETED = 0) = 1
THEN CONTACTINFORMATION.CIFIRSTNAME SQL_+ ' ' SQL_+
CONTACTINFORMATION.CILASTNAME
WHEN (SELECT CONTACTINFODEFINITIONS.CIDEFNAMEGENRULE
FROM CONTACTINFODEFINITIONS WHERE CIDEFACTIVE = 1 AND CIDEFDELETED = 0) = 2
THEN CONTACTINFORMATION.CILASTNAME SQL_+ ' ' SQL_+
CONTACTINFORMATION.CIFIRSTNAME
WHEN (SELECT CONTACTINFODEFINITIONS.CIDEFNAMEGENRULE
FROM CONTACTINFODEFINITIONS WHERE CIDEFACTIVE = 1 AND CIDEFDELETED = 0) = 3
THEN CONTACTINFORMATION.CIFIRSTNAME SQL_+ ' ' SQL_+
COALESCE (CONTACTINFORMATION.CIMIDDLENAME ,'') SQL_+ ' ' SQL_+
CONTACTINFORMATION.CILASTNAME
WHEN (SELECT CONTACTINFODEFINITIONS.CIDEFNAMEGENRULE
FROM CONTACTINFODEFINITIONS WHERE CIDEFACTIVE =1 AND CIDEFDELETED = 0) = 4
THEN CONTACTINFORMATION.CILASTNAME SQL_+ ' ' SQL_+
COALESCE (CONTACTINFORMATION.CIMIDDLENAME ,'') SQL_+ ' ' SQL_+
CONTACTINFORMATION.CIFIRSTNAME
END)
</field>
<label>key_name</label>
<alias>NAME</alias>
<expression>VALUE</expression>
<datatype>ftXString</datatype>
<fieldlen>256</fieldlen>
<searchcriteria>1</searchcriteria>
<visible>1</visible>
<executable>1</executable>
<casesensitive>false</casesensitive>
<indexorder>70</indexorder>
</fielditem>
<fielditem>
<field>ACCOUNTSRECEIVABLE.ACCRECPRIMARY</field>
<label>key_primary</label>
<expression>VALUE</expression>
<datatype>ftXInteger</datatype>
<fieldlen>10</fieldlen>
<searchcriteria>1</searchcriteria>
<visible>1</visible>
<executable>1</executable>
<displaytype>combobox;0;key_no;1;key_yes</displaytype>
<indexorder>80</indexorder>
</fielditem>
... | 