Fixes issue 19355: in Expense Sheet Window,
authorIoritz Cia <ioritz.cia@openbravo.com>
Sun, 26 Feb 2012 17:25:02 +0100
changeset 15622 b5f38705d906
parent 15621 05c3f4453733
child 15623 14313dc2eac4
Fixes issue 19355: in Expense Sheet Window,
column 'processed' is not displayed in grid mode.
src-db/database/model/tables/S_TIMEEXPENSE.xml
src-db/database/sourcedata/AD_COLUMN.xml
src-db/database/sourcedata/AD_FIELD.xml
--- a/src-db/database/model/tables/S_TIMEEXPENSE.xml	Fri Feb 17 11:37:54 2012 +0100
+++ b/src-db/database/model/tables/S_TIMEEXPENSE.xml	Sun Feb 26 17:25:02 2012 +0100
@@ -49,12 +49,12 @@
         <default/>
         <onCreateDefault/>
       </column>
-      <column name="PROCESSING" primaryKey="false" required="false" type="CHAR" size="1" autoIncrement="false">
+      <column name="PROCESSING" primaryKey="false" required="false" type="VARCHAR" size="60" autoIncrement="false">
         <default/>
         <onCreateDefault/>
       </column>
-      <column name="PROCESSED" primaryKey="false" required="true" type="VARCHAR" size="60" autoIncrement="false">
-        <default><![CDATA[N]]></default>
+      <column name="PROCESSED" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false">
+        <default><![CDATA['N'::character(1)]]></default>
         <onCreateDefault/>
       </column>
       <column name="M_PRICELIST_ID" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false">
@@ -85,6 +85,6 @@
         <reference local="M_WAREHOUSE_ID" foreign="M_WAREHOUSE_ID"/>
       </foreign-key>
       <check name="S_TIMEEXPENSE_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
-      <check name="S_TIMEEXPENSE_PROCESSED_CHK"><![CDATA[PROCESSED IN ('Y', 'N')]]></check>
+      <check name="S_TIMEEXPENSE_PROCESSING_CHK"><![CDATA[PROCESSING IN 'Y', 'N']]></check>
     </table>
   </database>
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Fri Feb 17 11:37:54 2012 +0100
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Sun Feb 26 17:25:02 2012 +0100
@@ -95746,9 +95746,8 @@
 <!--6835-->  <HELP><![CDATA[The Processed checkbox indicates that a document has been processed.]]></HELP>
 <!--6835-->  <COLUMNNAME><![CDATA[Processed]]></COLUMNNAME>
 <!--6835-->  <AD_TABLE_ID><![CDATA[486]]></AD_TABLE_ID>
-<!--6835-->  <AD_REFERENCE_ID><![CDATA[28]]></AD_REFERENCE_ID>
-<!--6835-->  <AD_REFERENCE_VALUE_ID><![CDATA[1005900000]]></AD_REFERENCE_VALUE_ID>
-<!--6835-->  <FIELDLENGTH><![CDATA[60]]></FIELDLENGTH>
+<!--6835-->  <AD_REFERENCE_ID><![CDATA[20]]></AD_REFERENCE_ID>
+<!--6835-->  <FIELDLENGTH><![CDATA[1]]></FIELDLENGTH>
 <!--6835-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--6835-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--6835-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
@@ -95759,7 +95758,6 @@
 <!--6835-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
 <!--6835-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
 <!--6835-->  <AD_ELEMENT_ID><![CDATA[1047]]></AD_ELEMENT_ID>
-<!--6835-->  <AD_PROCESS_ID><![CDATA[184]]></AD_PROCESS_ID>
 <!--6835-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
 <!--6835-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
 <!--6835-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
@@ -95783,8 +95781,9 @@
 <!--6836-->  <HELP><![CDATA[When this field is set as 'Y' a process is being performed on this record.]]></HELP>
 <!--6836-->  <COLUMNNAME><![CDATA[Processing]]></COLUMNNAME>
 <!--6836-->  <AD_TABLE_ID><![CDATA[486]]></AD_TABLE_ID>
-<!--6836-->  <AD_REFERENCE_ID><![CDATA[20]]></AD_REFERENCE_ID>
-<!--6836-->  <FIELDLENGTH><![CDATA[1]]></FIELDLENGTH>
+<!--6836-->  <AD_REFERENCE_ID><![CDATA[28]]></AD_REFERENCE_ID>
+<!--6836-->  <AD_REFERENCE_VALUE_ID><![CDATA[1005900000]]></AD_REFERENCE_VALUE_ID>
+<!--6836-->  <FIELDLENGTH><![CDATA[60]]></FIELDLENGTH>
 <!--6836-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--6836-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--6836-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
@@ -95795,6 +95794,7 @@
 <!--6836-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
 <!--6836-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
 <!--6836-->  <AD_ELEMENT_ID><![CDATA[524]]></AD_ELEMENT_ID>
+<!--6836-->  <AD_PROCESS_ID><![CDATA[184]]></AD_PROCESS_ID>
 <!--6836-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
 <!--6836-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
 <!--6836-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
--- a/src-db/database/sourcedata/AD_FIELD.xml	Fri Feb 17 11:37:54 2012 +0100
+++ b/src-db/database/sourcedata/AD_FIELD.xml	Sun Feb 26 17:25:02 2012 +0100
@@ -65140,9 +65140,9 @@
 <!--5441-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--5441-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--5441-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--5441-->  <NAME><![CDATA[Process Expenses]]></NAME>
-<!--5441-->  <DESCRIPTION><![CDATA[Process Expenses]]></DESCRIPTION>
-<!--5441-->  <HELP><![CDATA[Process expense sheet.]]></HELP>
+<!--5441-->  <NAME><![CDATA[Processed]]></NAME>
+<!--5441-->  <DESCRIPTION><![CDATA[A confirmation that the associated documents or requests are processed.]]></DESCRIPTION>
+<!--5441-->  <HELP><![CDATA[The Processed checkbox indicates that a document has been processed.]]></HELP>
 <!--5441-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
 <!--5441-->  <AD_TAB_ID><![CDATA[412]]></AD_TAB_ID>
 <!--5441-->  <AD_COLUMN_ID><![CDATA[6835]]></AD_COLUMN_ID>
@@ -65167,13 +65167,13 @@
 <!--5442-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--5442-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--5442-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--5442-->  <NAME><![CDATA[Process Now]]></NAME>
-<!--5442-->  <DESCRIPTION><![CDATA[A request to process the respective document or task.]]></DESCRIPTION>
-<!--5442-->  <HELP><![CDATA[When this field is set as 'Y' a process is being performed on this record.]]></HELP>
+<!--5442-->  <NAME><![CDATA[Process Expenses]]></NAME>
+<!--5442-->  <DESCRIPTION><![CDATA[Process Expenses]]></DESCRIPTION>
+<!--5442-->  <HELP><![CDATA[Process expense sheet.]]></HELP>
 <!--5442-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
 <!--5442-->  <AD_TAB_ID><![CDATA[412]]></AD_TAB_ID>
 <!--5442-->  <AD_COLUMN_ID><![CDATA[6836]]></AD_COLUMN_ID>
-<!--5442-->  <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED>
+<!--5442-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--5442-->  <DISPLAYLENGTH><![CDATA[23]]></DISPLAYLENGTH>
 <!--5442-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
 <!--5442-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>