Merge from pi, rev: 2a0022c73fbf
authorStefan Hühner <stefan.huehner@openbravo.com>
Sun, 24 Oct 2010 22:28:31 +0200
changeset 8749 22021bb414f7
parent 8748 3d4dc96ba425 (current diff)
parent 8619 2a0022c73fbf (diff)
child 8750 8fe20cfac148
Merge from pi, rev: 2a0022c73fbf
src-db/database/sourcedata/AD_COLUMN.xml
src-db/database/sourcedata/AD_ELEMENT.xml
src-db/database/sourcedata/AD_FIELD.xml
--- a/src-db/database/model/tables/AD_REF_TABLE.xml	Sun Oct 24 21:43:26 2010 +0200
+++ b/src-db/database/model/tables/AD_REF_TABLE.xml	Sun Oct 24 22:28:31 2010 +0200
@@ -57,6 +57,14 @@
         <default/>
         <onCreateDefault/>
       </column>
+      <column name="HQLWHERECLAUSE" primaryKey="false" required="false" type="VARCHAR" size="2000" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
+      <column name="HQLORDERBYCLAUSE" primaryKey="false" required="false" type="VARCHAR" size="2000" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
       <foreign-key foreignTable="AD_COLUMN" name="AD_COLUMN_REFTABLE_DISPLAY">
         <reference local="AD_DISPLAY" foreign="AD_COLUMN_ID"/>
       </foreign-key>
--- a/src-db/database/model/tables/AD_TAB.xml	Sun Oct 24 21:43:26 2010 +0200
+++ b/src-db/database/model/tables/AD_TAB.xml	Sun Oct 24 22:28:31 2010 +0200
@@ -145,6 +145,18 @@
         <default><![CDATA[STD]]></default>
         <onCreateDefault><![CDATA[CASE WHEN ISREADONLY='Y' THEN 'RO' ELSE 'STD' END]]></onCreateDefault>
       </column>
+      <column name="HQLWHERECLAUSE" primaryKey="false" required="false" type="VARCHAR" size="2000" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
+      <column name="HQLORDERBYCLAUSE" primaryKey="false" required="false" type="VARCHAR" size="2000" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
+      <column name="HQLFILTERCLAUSE" primaryKey="false" required="false" type="VARCHAR" size="2000" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
       <foreign-key foreignTable="AD_COLUMN" name="AD_COLUMN_AD_TAB">
         <reference local="AD_COLUMN_ID" foreign="AD_COLUMN_ID"/>
       </foreign-key>
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Sun Oct 24 21:43:26 2010 +0200
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Sun Oct 24 22:28:31 2010 +0200
@@ -266847,6 +266847,37 @@
 <!--46923D90F2BE11DD899E001D09C4A2FE-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
 <!--46923D90F2BE11DD899E001D09C4A2FE--></AD_COLUMN>
 
+<!--469587568C9D46DA9DB12E6B59AD6BDF--><AD_COLUMN>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->  <AD_COLUMN_ID><![CDATA[469587568C9D46DA9DB12E6B59AD6BDF]]></AD_COLUMN_ID>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->  <NAME><![CDATA[Hqlwhereclause]]></NAME>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->  <COLUMNNAME><![CDATA[Hqlwhereclause]]></COLUMNNAME>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->  <AD_TABLE_ID><![CDATA[103]]></AD_TABLE_ID>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->  <FIELDLENGTH><![CDATA[2000]]></FIELDLENGTH>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->  <SEQNO><![CDATA[11]]></SEQNO>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->  <AD_ELEMENT_ID><![CDATA[ECAC136184A746C39804BD71BC3C78DB]]></AD_ELEMENT_ID>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->  <POSITION><![CDATA[15]]></POSITION>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--469587568C9D46DA9DB12E6B59AD6BDF-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--469587568C9D46DA9DB12E6B59AD6BDF--></AD_COLUMN>
+
 <!--46982462F2BE11DDA3E5001D09C4A2FE--><AD_COLUMN>
 <!--46982462F2BE11DDA3E5001D09C4A2FE-->  <AD_COLUMN_ID><![CDATA[46982462F2BE11DDA3E5001D09C4A2FE]]></AD_COLUMN_ID>
 <!--46982462F2BE11DDA3E5001D09C4A2FE-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -279901,6 +279932,37 @@
 <!--5BE6AE18C0031D56E040007F010148F2-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
 <!--5BE6AE18C0031D56E040007F010148F2--></AD_COLUMN>
 
+<!--5C264276D5C94E7B8F05444D78FD0BA0--><AD_COLUMN>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->  <AD_COLUMN_ID><![CDATA[5C264276D5C94E7B8F05444D78FD0BA0]]></AD_COLUMN_ID>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->  <NAME><![CDATA[Hqlwhereclause]]></NAME>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->  <COLUMNNAME><![CDATA[Hqlwhereclause]]></COLUMNNAME>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->  <AD_TABLE_ID><![CDATA[106]]></AD_TABLE_ID>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->  <FIELDLENGTH><![CDATA[2000]]></FIELDLENGTH>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->  <SEQNO><![CDATA[52]]></SEQNO>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->  <AD_ELEMENT_ID><![CDATA[ECAC136184A746C39804BD71BC3C78DB]]></AD_ELEMENT_ID>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->  <POSITION><![CDATA[37]]></POSITION>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--5C264276D5C94E7B8F05444D78FD0BA0-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--5C264276D5C94E7B8F05444D78FD0BA0--></AD_COLUMN>
+
 <!--5C2A95460C2B4FD5B6AB75C8F7021B41--><AD_COLUMN>
 <!--5C2A95460C2B4FD5B6AB75C8F7021B41-->  <AD_COLUMN_ID><![CDATA[5C2A95460C2B4FD5B6AB75C8F7021B41]]></AD_COLUMN_ID>
 <!--5C2A95460C2B4FD5B6AB75C8F7021B41-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -309444,6 +309506,37 @@
 <!--A437240FB0894CFFAA0C96A925D69141-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
 <!--A437240FB0894CFFAA0C96A925D69141--></AD_COLUMN>
 
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F--><AD_COLUMN>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->  <AD_COLUMN_ID><![CDATA[A6730B8F9A5F4EADA0976C1FF09CF66F]]></AD_COLUMN_ID>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->  <NAME><![CDATA[Hqlorderbyclause]]></NAME>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->  <COLUMNNAME><![CDATA[Hqlorderbyclause]]></COLUMNNAME>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->  <AD_TABLE_ID><![CDATA[106]]></AD_TABLE_ID>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->  <FIELDLENGTH><![CDATA[2000]]></FIELDLENGTH>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->  <SEQNO><![CDATA[62]]></SEQNO>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->  <AD_ELEMENT_ID><![CDATA[8348666AB4E04BDBAC130A4C921440CC]]></AD_ELEMENT_ID>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->  <POSITION><![CDATA[38]]></POSITION>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--A6730B8F9A5F4EADA0976C1FF09CF66F--></AD_COLUMN>
+
 <!--A7354004EBD211DD897A0016D4EE9DB3--><AD_COLUMN>
 <!--A7354004EBD211DD897A0016D4EE9DB3-->  <AD_COLUMN_ID><![CDATA[A7354004EBD211DD897A0016D4EE9DB3]]></AD_COLUMN_ID>
 <!--A7354004EBD211DD897A0016D4EE9DB3-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -310634,6 +310727,37 @@
 <!--C83C1EB5414D4A528EDB166768B22C84-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
 <!--C83C1EB5414D4A528EDB166768B22C84--></AD_COLUMN>
 
+<!--C8AE5CAA0579450D801E70F9BF497D46--><AD_COLUMN>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->  <AD_COLUMN_ID><![CDATA[C8AE5CAA0579450D801E70F9BF497D46]]></AD_COLUMN_ID>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->  <NAME><![CDATA[Hqlorderbyclause]]></NAME>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->  <COLUMNNAME><![CDATA[Hqlorderbyclause]]></COLUMNNAME>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->  <AD_TABLE_ID><![CDATA[103]]></AD_TABLE_ID>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->  <FIELDLENGTH><![CDATA[2000]]></FIELDLENGTH>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->  <SEQNO><![CDATA[21]]></SEQNO>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->  <AD_ELEMENT_ID><![CDATA[8348666AB4E04BDBAC130A4C921440CC]]></AD_ELEMENT_ID>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->  <POSITION><![CDATA[16]]></POSITION>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--C8AE5CAA0579450D801E70F9BF497D46-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--C8AE5CAA0579450D801E70F9BF497D46--></AD_COLUMN>
+
 <!--CA49F473D15C4B778B338AE9ECB5DEA7--><AD_COLUMN>
 <!--CA49F473D15C4B778B338AE9ECB5DEA7-->  <AD_COLUMN_ID><![CDATA[CA49F473D15C4B778B338AE9ECB5DEA7]]></AD_COLUMN_ID>
 <!--CA49F473D15C4B778B338AE9ECB5DEA7-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -310670,6 +310794,37 @@
 <!--CA49F473D15C4B778B338AE9ECB5DEA7-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
 <!--CA49F473D15C4B778B338AE9ECB5DEA7--></AD_COLUMN>
 
+<!--CC3F4812548548AE9E1E8D0FCD8269DF--><AD_COLUMN>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->  <AD_COLUMN_ID><![CDATA[CC3F4812548548AE9E1E8D0FCD8269DF]]></AD_COLUMN_ID>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->  <NAME><![CDATA[Hqlfilterclause]]></NAME>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->  <COLUMNNAME><![CDATA[Hqlfilterclause]]></COLUMNNAME>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->  <AD_TABLE_ID><![CDATA[106]]></AD_TABLE_ID>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->  <FIELDLENGTH><![CDATA[2000]]></FIELDLENGTH>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->  <SEQNO><![CDATA[72]]></SEQNO>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->  <AD_ELEMENT_ID><![CDATA[F3B77B38FDF84D7293862DF5A927783D]]></AD_ELEMENT_ID>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->  <POSITION><![CDATA[39]]></POSITION>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--CC3F4812548548AE9E1E8D0FCD8269DF--></AD_COLUMN>
+
 <!--CC754B47555D4F66974371B151632F41--><AD_COLUMN>
 <!--CC754B47555D4F66974371B151632F41-->  <AD_COLUMN_ID><![CDATA[CC754B47555D4F66974371B151632F41]]></AD_COLUMN_ID>
 <!--CC754B47555D4F66974371B151632F41-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_ELEMENT.xml	Sun Oct 24 21:43:26 2010 +0200
+++ b/src-db/database/sourcedata/AD_ELEMENT.xml	Sun Oct 24 22:28:31 2010 +0200
@@ -26391,6 +26391,17 @@
 <!--828EE0AE80575FA1E040007F010067C7-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--828EE0AE80575FA1E040007F010067C7--></AD_ELEMENT>
 
+<!--8348666AB4E04BDBAC130A4C921440CC--><AD_ELEMENT>
+<!--8348666AB4E04BDBAC130A4C921440CC-->  <AD_ELEMENT_ID><![CDATA[8348666AB4E04BDBAC130A4C921440CC]]></AD_ELEMENT_ID>
+<!--8348666AB4E04BDBAC130A4C921440CC-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--8348666AB4E04BDBAC130A4C921440CC-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--8348666AB4E04BDBAC130A4C921440CC-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--8348666AB4E04BDBAC130A4C921440CC-->  <COLUMNNAME><![CDATA[Hqlorderbyclause]]></COLUMNNAME>
+<!--8348666AB4E04BDBAC130A4C921440CC-->  <NAME><![CDATA[HQL Order by Clause]]></NAME>
+<!--8348666AB4E04BDBAC130A4C921440CC-->  <PRINTNAME><![CDATA[HQL Order by Clause]]></PRINTNAME>
+<!--8348666AB4E04BDBAC130A4C921440CC-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--8348666AB4E04BDBAC130A4C921440CC--></AD_ELEMENT>
+
 <!--841CB823976F391BE040007F0101218F--><AD_ELEMENT>
 <!--841CB823976F391BE040007F0101218F-->  <AD_ELEMENT_ID><![CDATA[841CB823976F391BE040007F0101218F]]></AD_ELEMENT_ID>
 <!--841CB823976F391BE040007F0101218F-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -27747,6 +27758,17 @@
 <!--E89D147962E04590B41F406D9AEF4C8E-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--E89D147962E04590B41F406D9AEF4C8E--></AD_ELEMENT>
 
+<!--ECAC136184A746C39804BD71BC3C78DB--><AD_ELEMENT>
+<!--ECAC136184A746C39804BD71BC3C78DB-->  <AD_ELEMENT_ID><![CDATA[ECAC136184A746C39804BD71BC3C78DB]]></AD_ELEMENT_ID>
+<!--ECAC136184A746C39804BD71BC3C78DB-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--ECAC136184A746C39804BD71BC3C78DB-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--ECAC136184A746C39804BD71BC3C78DB-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--ECAC136184A746C39804BD71BC3C78DB-->  <COLUMNNAME><![CDATA[Hqlwhereclause]]></COLUMNNAME>
+<!--ECAC136184A746C39804BD71BC3C78DB-->  <NAME><![CDATA[HQL Where Clause]]></NAME>
+<!--ECAC136184A746C39804BD71BC3C78DB-->  <PRINTNAME><![CDATA[HQL Where Clause]]></PRINTNAME>
+<!--ECAC136184A746C39804BD71BC3C78DB-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--ECAC136184A746C39804BD71BC3C78DB--></AD_ELEMENT>
+
 <!--EFCDB5D6E2BD4E5C906C43D2839B1573--><AD_ELEMENT>
 <!--EFCDB5D6E2BD4E5C906C43D2839B1573-->  <AD_ELEMENT_ID><![CDATA[EFCDB5D6E2BD4E5C906C43D2839B1573]]></AD_ELEMENT_ID>
 <!--EFCDB5D6E2BD4E5C906C43D2839B1573-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -27773,6 +27795,17 @@
 <!--F197B6D6CCCE4C2F8EB42C34B560428E-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--F197B6D6CCCE4C2F8EB42C34B560428E--></AD_ELEMENT>
 
+<!--F3B77B38FDF84D7293862DF5A927783D--><AD_ELEMENT>
+<!--F3B77B38FDF84D7293862DF5A927783D-->  <AD_ELEMENT_ID><![CDATA[F3B77B38FDF84D7293862DF5A927783D]]></AD_ELEMENT_ID>
+<!--F3B77B38FDF84D7293862DF5A927783D-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--F3B77B38FDF84D7293862DF5A927783D-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--F3B77B38FDF84D7293862DF5A927783D-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--F3B77B38FDF84D7293862DF5A927783D-->  <COLUMNNAME><![CDATA[Hqlfilterclause]]></COLUMNNAME>
+<!--F3B77B38FDF84D7293862DF5A927783D-->  <NAME><![CDATA[HQL Filter Clause]]></NAME>
+<!--F3B77B38FDF84D7293862DF5A927783D-->  <PRINTNAME><![CDATA[HQL Filter Clause]]></PRINTNAME>
+<!--F3B77B38FDF84D7293862DF5A927783D-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--F3B77B38FDF84D7293862DF5A927783D--></AD_ELEMENT>
+
 <!--F3BF680089754BAC858ECFF2D5D0F232--><AD_ELEMENT>
 <!--F3BF680089754BAC858ECFF2D5D0F232-->  <AD_ELEMENT_ID><![CDATA[F3BF680089754BAC858ECFF2D5D0F232]]></AD_ELEMENT_ID>
 <!--F3BF680089754BAC858ECFF2D5D0F232-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_FIELD.xml	Sun Oct 24 21:43:26 2010 +0200
+++ b/src-db/database/sourcedata/AD_FIELD.xml	Sun Oct 24 22:28:31 2010 +0200
@@ -1452,7 +1452,7 @@
 <!--183-->  <DISPLAYLOGIC><![CDATA[@ParentReference_ID@='18']]></DISPLAYLOGIC>
 <!--183-->  <DISPLAYLENGTH><![CDATA[60]]></DISPLAYLENGTH>
 <!--183-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--183-->  <SEQNO><![CDATA[100]]></SEQNO>
+<!--183-->  <SEQNO><![CDATA[90]]></SEQNO>
 <!--183-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--183-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--183-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -3631,7 +3631,7 @@
 <!--312-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--312-->  <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
 <!--312-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--312-->  <SEQNO><![CDATA[150]]></SEQNO>
+<!--312-->  <SEQNO><![CDATA[140]]></SEQNO>
 <!--312-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--312-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--312-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -11011,7 +11011,7 @@
 <!--927-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--927-->  <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
 <!--927-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--927-->  <SEQNO><![CDATA[160]]></SEQNO>
+<!--927-->  <SEQNO><![CDATA[150]]></SEQNO>
 <!--927-->  <ISSAMELINE><![CDATA[Y]]></ISSAMELINE>
 <!--927-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--927-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -11034,7 +11034,7 @@
 <!--928-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--928-->  <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
 <!--928-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--928-->  <SEQNO><![CDATA[170]]></SEQNO>
+<!--928-->  <SEQNO><![CDATA[160]]></SEQNO>
 <!--928-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--928-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--928-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -11057,7 +11057,6 @@
 <!--929-->  <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED>
 <!--929-->  <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
 <!--929-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--929-->  <SEQNO><![CDATA[140]]></SEQNO>
 <!--929-->  <ISSAMELINE><![CDATA[Y]]></ISSAMELINE>
 <!--929-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--929-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -19261,7 +19260,7 @@
 <!--1546-->  <DISPLAYLOGIC><![CDATA[@IsSortTab@='N']]></DISPLAYLOGIC>
 <!--1546-->  <DISPLAYLENGTH><![CDATA[44]]></DISPLAYLENGTH>
 <!--1546-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--1546-->  <SEQNO><![CDATA[220]]></SEQNO>
+<!--1546-->  <SEQNO><![CDATA[210]]></SEQNO>
 <!--1546-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--1546-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--1546-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -19284,7 +19283,7 @@
 <!--1548-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--1548-->  <DISPLAYLENGTH><![CDATA[60]]></DISPLAYLENGTH>
 <!--1548-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--1548-->  <SEQNO><![CDATA[240]]></SEQNO>
+<!--1548-->  <SEQNO><![CDATA[230]]></SEQNO>
 <!--1548-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--1548-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--1548-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -19307,7 +19306,7 @@
 <!--1549-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--1549-->  <DISPLAYLENGTH><![CDATA[20]]></DISPLAYLENGTH>
 <!--1549-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--1549-->  <SEQNO><![CDATA[270]]></SEQNO>
+<!--1549-->  <SEQNO><![CDATA[280]]></SEQNO>
 <!--1549-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--1549-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--1549-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -19330,7 +19329,7 @@
 <!--1550-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--1550-->  <DISPLAYLENGTH><![CDATA[60]]></DISPLAYLENGTH>
 <!--1550-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--1550-->  <SEQNO><![CDATA[250]]></SEQNO>
+<!--1550-->  <SEQNO><![CDATA[240]]></SEQNO>
 <!--1550-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--1550-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--1550-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -28617,7 +28616,7 @@
 <!--2575-->  <DISPLAYLOGIC><![CDATA[@IsSortTab@='N']]></DISPLAYLOGIC>
 <!--2575-->  <DISPLAYLENGTH><![CDATA[44]]></DISPLAYLENGTH>
 <!--2575-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--2575-->  <SEQNO><![CDATA[230]]></SEQNO>
+<!--2575-->  <SEQNO><![CDATA[220]]></SEQNO>
 <!--2575-->  <ISSAMELINE><![CDATA[Y]]></ISSAMELINE>
 <!--2575-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--2575-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -36802,7 +36801,7 @@
 <!--3205-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--3205-->  <DISPLAYLENGTH><![CDATA[23]]></DISPLAYLENGTH>
 <!--3205-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--3205-->  <SEQNO><![CDATA[310]]></SEQNO>
+<!--3205-->  <SEQNO><![CDATA[330]]></SEQNO>
 <!--3205-->  <ISSAMELINE><![CDATA[Y]]></ISSAMELINE>
 <!--3205-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--3205-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -59415,7 +59414,7 @@
 <!--4956-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--4956-->  <DISPLAYLENGTH><![CDATA[44]]></DISPLAYLENGTH>
 <!--4956-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--4956-->  <SEQNO><![CDATA[280]]></SEQNO>
+<!--4956-->  <SEQNO><![CDATA[300]]></SEQNO>
 <!--4956-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--4956-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--4956-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -59656,7 +59655,7 @@
 <!--5131-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--5131-->  <DISPLAYLENGTH><![CDATA[23]]></DISPLAYLENGTH>
 <!--5131-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--5131-->  <SEQNO><![CDATA[300]]></SEQNO>
+<!--5131-->  <SEQNO><![CDATA[320]]></SEQNO>
 <!--5131-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--5131-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--5131-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -69464,7 +69463,7 @@
 <!--5707-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--5707-->  <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
 <!--5707-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--5707-->  <SEQNO><![CDATA[180]]></SEQNO>
+<!--5707-->  <SEQNO><![CDATA[170]]></SEQNO>
 <!--5707-->  <ISSAMELINE><![CDATA[Y]]></ISSAMELINE>
 <!--5707-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--5707-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -69488,7 +69487,7 @@
 <!--5708-->  <DISPLAYLOGIC><![CDATA[@IsSortTab@='Y']]></DISPLAYLOGIC>
 <!--5708-->  <DISPLAYLENGTH><![CDATA[44]]></DISPLAYLENGTH>
 <!--5708-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--5708-->  <SEQNO><![CDATA[210]]></SEQNO>
+<!--5708-->  <SEQNO><![CDATA[200]]></SEQNO>
 <!--5708-->  <ISSAMELINE><![CDATA[Y]]></ISSAMELINE>
 <!--5708-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--5708-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -69512,7 +69511,7 @@
 <!--5709-->  <DISPLAYLOGIC><![CDATA[@IsSortTab@='Y']]></DISPLAYLOGIC>
 <!--5709-->  <DISPLAYLENGTH><![CDATA[44]]></DISPLAYLENGTH>
 <!--5709-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--5709-->  <SEQNO><![CDATA[190]]></SEQNO>
+<!--5709-->  <SEQNO><![CDATA[180]]></SEQNO>
 <!--5709-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--5709-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--5709-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -79042,7 +79041,7 @@
 <!--6432-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--6432-->  <DISPLAYLENGTH><![CDATA[44]]></DISPLAYLENGTH>
 <!--6432-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--6432-->  <SEQNO><![CDATA[200]]></SEQNO>
+<!--6432-->  <SEQNO><![CDATA[190]]></SEQNO>
 <!--6432-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--6432-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--6432-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -128077,7 +128076,7 @@
 <!--801108-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--801108-->  <DISPLAYLENGTH><![CDATA[44]]></DISPLAYLENGTH>
 <!--801108-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--801108-->  <SEQNO><![CDATA[290]]></SEQNO>
+<!--801108-->  <SEQNO><![CDATA[310]]></SEQNO>
 <!--801108-->  <ISSAMELINE><![CDATA[Y]]></ISSAMELINE>
 <!--801108-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--801108-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -182874,6 +182873,27 @@
 <!--28BD4315630F47F0B6BEB131C7F2625A-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--28BD4315630F47F0B6BEB131C7F2625A--></AD_FIELD>
 
+<!--291BD4A564ED491E83B79B5B4F048FA7--><AD_FIELD>
+<!--291BD4A564ED491E83B79B5B4F048FA7-->  <AD_FIELD_ID><![CDATA[291BD4A564ED491E83B79B5B4F048FA7]]></AD_FIELD_ID>
+<!--291BD4A564ED491E83B79B5B4F048FA7-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--291BD4A564ED491E83B79B5B4F048FA7-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--291BD4A564ED491E83B79B5B4F048FA7-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--291BD4A564ED491E83B79B5B4F048FA7-->  <NAME><![CDATA[HQL Order by Clause]]></NAME>
+<!--291BD4A564ED491E83B79B5B4F048FA7-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--291BD4A564ED491E83B79B5B4F048FA7-->  <AD_TAB_ID><![CDATA[106]]></AD_TAB_ID>
+<!--291BD4A564ED491E83B79B5B4F048FA7-->  <AD_COLUMN_ID><![CDATA[A6730B8F9A5F4EADA0976C1FF09CF66F]]></AD_COLUMN_ID>
+<!--291BD4A564ED491E83B79B5B4F048FA7-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--291BD4A564ED491E83B79B5B4F048FA7-->  <DISPLAYLENGTH><![CDATA[2000]]></DISPLAYLENGTH>
+<!--291BD4A564ED491E83B79B5B4F048FA7-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--291BD4A564ED491E83B79B5B4F048FA7-->  <SEQNO><![CDATA[290]]></SEQNO>
+<!--291BD4A564ED491E83B79B5B4F048FA7-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--291BD4A564ED491E83B79B5B4F048FA7-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--291BD4A564ED491E83B79B5B4F048FA7-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--291BD4A564ED491E83B79B5B4F048FA7-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--291BD4A564ED491E83B79B5B4F048FA7-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--291BD4A564ED491E83B79B5B4F048FA7-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--291BD4A564ED491E83B79B5B4F048FA7--></AD_FIELD>
+
 <!--2994A25901A44EFBB69D86B3341B9A74--><AD_FIELD>
 <!--2994A25901A44EFBB69D86B3341B9A74-->  <AD_FIELD_ID><![CDATA[2994A25901A44EFBB69D86B3341B9A74]]></AD_FIELD_ID>
 <!--2994A25901A44EFBB69D86B3341B9A74-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -184094,6 +184114,27 @@
 <!--4FD3EEF17FA24F16BEDFE2312CB765DA-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--4FD3EEF17FA24F16BEDFE2312CB765DA--></AD_FIELD>
 
+<!--5056DBAF06014411BBDE8DB8D3070651--><AD_FIELD>
+<!--5056DBAF06014411BBDE8DB8D3070651-->  <AD_FIELD_ID><![CDATA[5056DBAF06014411BBDE8DB8D3070651]]></AD_FIELD_ID>
+<!--5056DBAF06014411BBDE8DB8D3070651-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--5056DBAF06014411BBDE8DB8D3070651-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--5056DBAF06014411BBDE8DB8D3070651-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--5056DBAF06014411BBDE8DB8D3070651-->  <NAME><![CDATA[HQL Order by Clause]]></NAME>
+<!--5056DBAF06014411BBDE8DB8D3070651-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--5056DBAF06014411BBDE8DB8D3070651-->  <AD_TAB_ID><![CDATA[103]]></AD_TAB_ID>
+<!--5056DBAF06014411BBDE8DB8D3070651-->  <AD_COLUMN_ID><![CDATA[C8AE5CAA0579450D801E70F9BF497D46]]></AD_COLUMN_ID>
+<!--5056DBAF06014411BBDE8DB8D3070651-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--5056DBAF06014411BBDE8DB8D3070651-->  <DISPLAYLENGTH><![CDATA[2000]]></DISPLAYLENGTH>
+<!--5056DBAF06014411BBDE8DB8D3070651-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--5056DBAF06014411BBDE8DB8D3070651-->  <SEQNO><![CDATA[120]]></SEQNO>
+<!--5056DBAF06014411BBDE8DB8D3070651-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--5056DBAF06014411BBDE8DB8D3070651-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--5056DBAF06014411BBDE8DB8D3070651-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--5056DBAF06014411BBDE8DB8D3070651-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--5056DBAF06014411BBDE8DB8D3070651-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--5056DBAF06014411BBDE8DB8D3070651-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--5056DBAF06014411BBDE8DB8D3070651--></AD_FIELD>
+
 <!--50D9B08EA13C4546BC86338AC576FC1F--><AD_FIELD>
 <!--50D9B08EA13C4546BC86338AC576FC1F-->  <AD_FIELD_ID><![CDATA[50D9B08EA13C4546BC86338AC576FC1F]]></AD_FIELD_ID>
 <!--50D9B08EA13C4546BC86338AC576FC1F-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -190513,6 +190554,27 @@
 <!--58E839A092AF0D3BE040007F01015CDF-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--58E839A092AF0D3BE040007F01015CDF--></AD_FIELD>
 
+<!--58F5280D82DF4041A132083493B42441--><AD_FIELD>
+<!--58F5280D82DF4041A132083493B42441-->  <AD_FIELD_ID><![CDATA[58F5280D82DF4041A132083493B42441]]></AD_FIELD_ID>
+<!--58F5280D82DF4041A132083493B42441-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--58F5280D82DF4041A132083493B42441-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--58F5280D82DF4041A132083493B42441-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--58F5280D82DF4041A132083493B42441-->  <NAME><![CDATA[HQL Filter Clause]]></NAME>
+<!--58F5280D82DF4041A132083493B42441-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--58F5280D82DF4041A132083493B42441-->  <AD_TAB_ID><![CDATA[106]]></AD_TAB_ID>
+<!--58F5280D82DF4041A132083493B42441-->  <AD_COLUMN_ID><![CDATA[CC3F4812548548AE9E1E8D0FCD8269DF]]></AD_COLUMN_ID>
+<!--58F5280D82DF4041A132083493B42441-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--58F5280D82DF4041A132083493B42441-->  <DISPLAYLENGTH><![CDATA[2000]]></DISPLAYLENGTH>
+<!--58F5280D82DF4041A132083493B42441-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--58F5280D82DF4041A132083493B42441-->  <SEQNO><![CDATA[270]]></SEQNO>
+<!--58F5280D82DF4041A132083493B42441-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--58F5280D82DF4041A132083493B42441-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--58F5280D82DF4041A132083493B42441-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--58F5280D82DF4041A132083493B42441-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--58F5280D82DF4041A132083493B42441-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--58F5280D82DF4041A132083493B42441-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--58F5280D82DF4041A132083493B42441--></AD_FIELD>
+
 <!--5920A450BEAC149DE040007F010106F4--><AD_FIELD>
 <!--5920A450BEAC149DE040007F010106F4-->  <AD_FIELD_ID><![CDATA[5920A450BEAC149DE040007F010106F4]]></AD_FIELD_ID>
 <!--5920A450BEAC149DE040007F010106F4-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -192703,6 +192765,27 @@
 <!--60B7D5ABB5FD47608ACB13EC89966A6B-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--60B7D5ABB5FD47608ACB13EC89966A6B--></AD_FIELD>
 
+<!--60DF138727B64DD687494FE0DBEDF5D9--><AD_FIELD>
+<!--60DF138727B64DD687494FE0DBEDF5D9-->  <AD_FIELD_ID><![CDATA[60DF138727B64DD687494FE0DBEDF5D9]]></AD_FIELD_ID>
+<!--60DF138727B64DD687494FE0DBEDF5D9-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--60DF138727B64DD687494FE0DBEDF5D9-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--60DF138727B64DD687494FE0DBEDF5D9-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--60DF138727B64DD687494FE0DBEDF5D9-->  <NAME><![CDATA[HQL Where Clause]]></NAME>
+<!--60DF138727B64DD687494FE0DBEDF5D9-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--60DF138727B64DD687494FE0DBEDF5D9-->  <AD_TAB_ID><![CDATA[106]]></AD_TAB_ID>
+<!--60DF138727B64DD687494FE0DBEDF5D9-->  <AD_COLUMN_ID><![CDATA[5C264276D5C94E7B8F05444D78FD0BA0]]></AD_COLUMN_ID>
+<!--60DF138727B64DD687494FE0DBEDF5D9-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--60DF138727B64DD687494FE0DBEDF5D9-->  <DISPLAYLENGTH><![CDATA[2000]]></DISPLAYLENGTH>
+<!--60DF138727B64DD687494FE0DBEDF5D9-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--60DF138727B64DD687494FE0DBEDF5D9-->  <SEQNO><![CDATA[250]]></SEQNO>
+<!--60DF138727B64DD687494FE0DBEDF5D9-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--60DF138727B64DD687494FE0DBEDF5D9-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--60DF138727B64DD687494FE0DBEDF5D9-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--60DF138727B64DD687494FE0DBEDF5D9-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--60DF138727B64DD687494FE0DBEDF5D9-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--60DF138727B64DD687494FE0DBEDF5D9-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--60DF138727B64DD687494FE0DBEDF5D9--></AD_FIELD>
+
 <!--60FCCD631EBAEDF8E040007F01013AD4--><AD_FIELD>
 <!--60FCCD631EBAEDF8E040007F01013AD4-->  <AD_FIELD_ID><![CDATA[60FCCD631EBAEDF8E040007F01013AD4]]></AD_FIELD_ID>
 <!--60FCCD631EBAEDF8E040007F01013AD4-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -201815,6 +201898,27 @@
 <!--8C84C9E4B8B89247E040007F01013819-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--8C84C9E4B8B89247E040007F01013819--></AD_FIELD>
 
+<!--8C8CC82B940147AF953DDACB0CF3AB36--><AD_FIELD>
+<!--8C8CC82B940147AF953DDACB0CF3AB36-->  <AD_FIELD_ID><![CDATA[8C8CC82B940147AF953DDACB0CF3AB36]]></AD_FIELD_ID>
+<!--8C8CC82B940147AF953DDACB0CF3AB36-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--8C8CC82B940147AF953DDACB0CF3AB36-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--8C8CC82B940147AF953DDACB0CF3AB36-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--8C8CC82B940147AF953DDACB0CF3AB36-->  <NAME><![CDATA[HQL Where Clause]]></NAME>
+<!--8C8CC82B940147AF953DDACB0CF3AB36-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--8C8CC82B940147AF953DDACB0CF3AB36-->  <AD_TAB_ID><![CDATA[103]]></AD_TAB_ID>
+<!--8C8CC82B940147AF953DDACB0CF3AB36-->  <AD_COLUMN_ID><![CDATA[469587568C9D46DA9DB12E6B59AD6BDF]]></AD_COLUMN_ID>
+<!--8C8CC82B940147AF953DDACB0CF3AB36-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--8C8CC82B940147AF953DDACB0CF3AB36-->  <DISPLAYLENGTH><![CDATA[2000]]></DISPLAYLENGTH>
+<!--8C8CC82B940147AF953DDACB0CF3AB36-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--8C8CC82B940147AF953DDACB0CF3AB36-->  <SEQNO><![CDATA[100]]></SEQNO>
+<!--8C8CC82B940147AF953DDACB0CF3AB36-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--8C8CC82B940147AF953DDACB0CF3AB36-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--8C8CC82B940147AF953DDACB0CF3AB36-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--8C8CC82B940147AF953DDACB0CF3AB36-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--8C8CC82B940147AF953DDACB0CF3AB36-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--8C8CC82B940147AF953DDACB0CF3AB36-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--8C8CC82B940147AF953DDACB0CF3AB36--></AD_FIELD>
+
 <!--8CB852B414BA4B66B20790634D899D85--><AD_FIELD>
 <!--8CB852B414BA4B66B20790634D899D85-->  <AD_FIELD_ID><![CDATA[8CB852B414BA4B66B20790634D899D85]]></AD_FIELD_ID>
 <!--8CB852B414BA4B66B20790634D899D85-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>