changeset:   25852:8c287f5541ee
tag:         tip
user:        Augusto Mauch <augusto.mauch@openbravo.com>
date:        Thu Feb 05 12:39:22 2015 +0100
summary:     Test issue 28843

diff --git a/src-db/database/model/tables/M_PRODUCT_CH.xml b/src-db/database/model/tables/M_PRODUCT_CH.xml
--- a/src-db/database/model/tables/M_PRODUCT_CH.xml
+++ b/src-db/database/model/tables/M_PRODUCT_CH.xml
@@ -65,6 +65,10 @@
         <default><![CDATA[SALES]]></default>
         <onCreateDefault><![CDATA['ALL']]></onCreateDefault>
       </column>
+      <column name="M_CH_VALUE" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
       <foreign-key foreignTable="AD_CLIENT" name="M_PRODUCT_CH_AD_CLIENT">
         <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
       </foreign-key>
diff --git a/src-db/database/sourcedata/AD_COLUMN.xml b/src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml
+++ b/src-db/database/sourcedata/AD_COLUMN.xml
@@ -324439,6 +324439,39 @@
 <!--D330031212524D2CAA0C5ECEE52C20B8-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--D330031212524D2CAA0C5ECEE52C20B8--></AD_COLUMN>
 
+<!--D35442BFFD9E40A3872713FC487F6F90--><AD_COLUMN>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <AD_COLUMN_ID><![CDATA[D35442BFFD9E40A3872713FC487F6F90]]></AD_COLUMN_ID>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <NAME><![CDATA[M_Ch_Value]]></NAME>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <COLUMNNAME><![CDATA[M_Ch_Value]]></COLUMNNAME>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <AD_TABLE_ID><![CDATA[8E4A6598CA2747B6B0E7257C6F3DEB19]]></AD_TABLE_ID>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <AD_REFERENCE_ID><![CDATA[8C57A4A2E05F4261A1FADF47C30398AD]]></AD_REFERENCE_ID>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <AD_REFERENCE_VALUE_ID><![CDATA[D3D9A7BAF4594950922A22B2D7ABFA74]]></AD_REFERENCE_VALUE_ID>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <SEQNO><![CDATA[190]]></SEQNO>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <POSITION><![CDATA[17]]></POSITION>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--D35442BFFD9E40A3872713FC487F6F90-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--D35442BFFD9E40A3872713FC487F6F90--></AD_COLUMN>
+
 <!--D36D4B0065004AFEB99191A531E976D3--><AD_COLUMN>
 <!--D36D4B0065004AFEB99191A531E976D3-->  <AD_COLUMN_ID><![CDATA[D36D4B0065004AFEB99191A531E976D3]]></AD_COLUMN_ID>
 <!--D36D4B0065004AFEB99191A531E976D3-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff --git a/src-db/database/sourcedata/AD_FIELD.xml b/src-db/database/sourcedata/AD_FIELD.xml
--- a/src-db/database/sourcedata/AD_FIELD.xml
+++ b/src-db/database/sourcedata/AD_FIELD.xml
@@ -183550,6 +183550,32 @@
 <!--112C5AD5B37F4BCFB73C477A423CE187-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--112C5AD5B37F4BCFB73C477A423CE187--></AD_FIELD>
 
+<!--114B95FD6C05433FA9D4A95531A25D8A--><AD_FIELD>
+<!--114B95FD6C05433FA9D4A95531A25D8A-->  <AD_FIELD_ID><![CDATA[114B95FD6C05433FA9D4A95531A25D8A]]></AD_FIELD_ID>
+<!--114B95FD6C05433FA9D4A95531A25D8A-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--114B95FD6C05433FA9D4A95531A25D8A-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--114B95FD6C05433FA9D4A95531A25D8A-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--114B95FD6C05433FA9D4A95531A25D8A-->  <NAME><![CDATA[M_Ch_Value]]></NAME>
+<!--114B95FD6C05433FA9D4A95531A25D8A-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--114B95FD6C05433FA9D4A95531A25D8A-->  <AD_TAB_ID><![CDATA[769BB4BF6B0B4C39AD28E9A00D260F33]]></AD_TAB_ID>
+<!--114B95FD6C05433FA9D4A95531A25D8A-->  <AD_COLUMN_ID><![CDATA[D35442BFFD9E40A3872713FC487F6F90]]></AD_COLUMN_ID>
+<!--114B95FD6C05433FA9D4A95531A25D8A-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--114B95FD6C05433FA9D4A95531A25D8A-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--114B95FD6C05433FA9D4A95531A25D8A-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
+<!--114B95FD6C05433FA9D4A95531A25D8A-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--114B95FD6C05433FA9D4A95531A25D8A-->  <SEQNO><![CDATA[100]]></SEQNO>
+<!--114B95FD6C05433FA9D4A95531A25D8A-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--114B95FD6C05433FA9D4A95531A25D8A-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--114B95FD6C05433FA9D4A95531A25D8A-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--114B95FD6C05433FA9D4A95531A25D8A-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--114B95FD6C05433FA9D4A95531A25D8A-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--114B95FD6C05433FA9D4A95531A25D8A-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--114B95FD6C05433FA9D4A95531A25D8A-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--114B95FD6C05433FA9D4A95531A25D8A-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--114B95FD6C05433FA9D4A95531A25D8A-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--114B95FD6C05433FA9D4A95531A25D8A-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--114B95FD6C05433FA9D4A95531A25D8A--></AD_FIELD>
+
 <!--119FCD6CC06F43E6BE4DA88BC1368A4D--><AD_FIELD>
 <!--119FCD6CC06F43E6BE4DA88BC1368A4D-->  <AD_FIELD_ID><![CDATA[119FCD6CC06F43E6BE4DA88BC1368A4D]]></AD_FIELD_ID>
 <!--119FCD6CC06F43E6BE4DA88BC1368A4D-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff --git a/src-db/database/sourcedata/AD_REF_TREE.xml b/src-db/database/sourcedata/AD_REF_TREE.xml
--- a/src-db/database/sourcedata/AD_REF_TREE.xml
+++ b/src-db/database/sourcedata/AD_REF_TREE.xml
@@ -7,7 +7,6 @@
 <!--95582A51651D415993D0FD3B64C8E861-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--95582A51651D415993D0FD3B64C8E861-->  <AD_REFERENCE_ID><![CDATA[D3D9A7BAF4594950922A22B2D7ABFA74]]></AD_REFERENCE_ID>
 <!--95582A51651D415993D0FD3B64C8E861-->  <AD_TABLE_ID><![CDATA[E913D17C9B3847CF92235082DBE2EC44]]></AD_TABLE_ID>
-<!--95582A51651D415993D0FD3B64C8E861-->  <WHERECLAUSE><![CDATA[e.characteristic.id=@parentCharId@]]></WHERECLAUSE>
 <!--95582A51651D415993D0FD3B64C8E861-->  <VALUEFIELD_ID><![CDATA[7B82AF2B5C2C48CDB05C78BA3DC26989]]></VALUEFIELD_ID>
 <!--95582A51651D415993D0FD3B64C8E861-->  <DISPLAYFIELD_ID><![CDATA[01982CD5659A4E76A0781FBE4FA3CFC7]]></DISPLAYFIELD_ID>
 <!--95582A51651D415993D0FD3B64C8E861-->  <AD_TABLE_TREE_ID><![CDATA[B6C7204712CC4EDEB5705C93F706DF05]]></AD_TABLE_TREE_ID>