[Characteristics]Add is generic and generic product fields to product.
authorGorka Ion Damián <gorkaion.damian@openbravo.com>
Mon, 04 Mar 2013 18:52:40 +0100
changeset 20865 cbcc33734d13
parent 20864 c2079a6d34a1
child 20866 2baabfeeb97d
[Characteristics]Add is generic and generic product fields to product.
src-db/database/model/tables/M_PRODUCT.xml
src-db/database/sourcedata/AD_COLUMN.xml
src-db/database/sourcedata/AD_ELEMENT.xml
src-db/database/sourcedata/AD_FIELD.xml
src-db/database/sourcedata/AD_REFERENCE.xml
src-db/database/sourcedata/AD_REF_TABLE.xml
--- a/src-db/database/model/tables/M_PRODUCT.xml	Fri Mar 01 15:17:06 2013 +0100
+++ b/src-db/database/model/tables/M_PRODUCT.xml	Mon Mar 04 18:52:40 2013 +0100
@@ -325,6 +325,14 @@
         <default/>
         <onCreateDefault/>
       </column>
+      <column name="ISGENERIC" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false">
+        <default><![CDATA[N]]></default>
+        <onCreateDefault><![CDATA['N']]></onCreateDefault>
+      </column>
+      <column name="GENERIC_PRODUCT_ID" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
       <foreign-key foreignTable="AD_ORG" name="AD_ORG_MPRODUCT">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
@@ -349,6 +357,9 @@
       <foreign-key foreignTable="C_UOM" name="M_PRODUCT_C_UOM">
         <reference local="C_UOM_ID" foreign="C_UOM_ID"/>
       </foreign-key>
+      <foreign-key foreignTable="M_PRODUCT" name="M_PRODUCT_GENERICPRODUCT">
+        <reference local="GENERIC_PRODUCT_ID" foreign="M_PRODUCT_ID"/>
+      </foreign-key>
       <foreign-key foreignTable="M_ATTRIBUTESET" name="M_PRODUCT_M_ATTRIBUTESET" onDelete="cascade">
         <reference local="M_ATTRIBUTESET_ID" foreign="M_ATTRIBUTESET_ID"/>
       </foreign-key>
@@ -408,6 +419,7 @@
       <check name="M_PRODUCT_ISBOM_CHECK"><![CDATA[ISBOM IN ('Y', 'N')]]></check>
       <check name="M_PRODUCT_ISEXPDEFCOMPLETE_CHK"><![CDATA[(ISDEFERREDEXPENSE = 'N') OR ((((ISDEFERREDEXPENSE = 'Y') AND (EXPPLANTYPE IS NOT NULL)) AND (DEFAULTPERIOD_EXP IS NOT NULL)) AND (PERIODNUMBER_EXP IS NOT NULL))]]></check>
       <check name="M_PRODUCT_ISEXPDEFERRED_CHK"><![CDATA[ISDEFERREDEXPENSE IN ('Y', 'N')]]></check>
+      <check name="M_PRODUCT_ISGENERIC"><![CDATA[ISGENERIC IN ('Y', 'N')]]></check>
       <check name="M_PRODUCT_ISINVOICEPRINTDE_CHK"><![CDATA[ISINVOICEPRINTDETAILS IN ('Y', 'N')]]></check>
       <check name="M_PRODUCT_ISPICKLISTPRINTD_CHK"><![CDATA[ISPICKLISTPRINTDETAILS IN ('Y', 'N')]]></check>
       <check name="M_PRODUCT_ISPURCHASED_CHECK"><![CDATA[ISPURCHASED IN ('Y', 'N')]]></check>
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Fri Mar 01 15:17:06 2013 +0100
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Mon Mar 04 18:52:40 2013 +0100
@@ -310782,6 +310782,76 @@
 <!--D6DD1CEC663B4B1EE040007F01004675-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--D6DD1CEC663B4B1EE040007F01004675--></AD_COLUMN>
 
+<!--D7192114A6A5B6B7E040007F01001270--><AD_COLUMN>
+<!--D7192114A6A5B6B7E040007F01001270-->  <AD_COLUMN_ID><![CDATA[D7192114A6A5B6B7E040007F01001270]]></AD_COLUMN_ID>
+<!--D7192114A6A5B6B7E040007F01001270-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--D7192114A6A5B6B7E040007F01001270-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--D7192114A6A5B6B7E040007F01001270-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--D7192114A6A5B6B7E040007F01001270-->  <NAME><![CDATA[Is Generic]]></NAME>
+<!--D7192114A6A5B6B7E040007F01001270-->  <HELP><![CDATA[Identifies a generic product. A generic product cannot be purchased or sold.]]></HELP>
+<!--D7192114A6A5B6B7E040007F01001270-->  <COLUMNNAME><![CDATA[IsGeneric]]></COLUMNNAME>
+<!--D7192114A6A5B6B7E040007F01001270-->  <AD_TABLE_ID><![CDATA[208]]></AD_TABLE_ID>
+<!--D7192114A6A5B6B7E040007F01001270-->  <AD_REFERENCE_ID><![CDATA[20]]></AD_REFERENCE_ID>
+<!--D7192114A6A5B6B7E040007F01001270-->  <FIELDLENGTH><![CDATA[1]]></FIELDLENGTH>
+<!--D7192114A6A5B6B7E040007F01001270-->  <DEFAULTVALUE><![CDATA[N]]></DEFAULTVALUE>
+<!--D7192114A6A5B6B7E040007F01001270-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--D7192114A6A5B6B7E040007F01001270-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--D7192114A6A5B6B7E040007F01001270-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--D7192114A6A5B6B7E040007F01001270-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--D7192114A6A5B6B7E040007F01001270-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--D7192114A6A5B6B7E040007F01001270-->  <SEQNO><![CDATA[430]]></SEQNO>
+<!--D7192114A6A5B6B7E040007F01001270-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--D7192114A6A5B6B7E040007F01001270-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--D7192114A6A5B6B7E040007F01001270-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--D7192114A6A5B6B7E040007F01001270-->  <AD_ELEMENT_ID><![CDATA[D7192114A6B0B6B7E040007F01001270]]></AD_ELEMENT_ID>
+<!--D7192114A6A5B6B7E040007F01001270-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--D7192114A6A5B6B7E040007F01001270-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--D7192114A6A5B6B7E040007F01001270-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--D7192114A6A5B6B7E040007F01001270-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--D7192114A6A5B6B7E040007F01001270-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--D7192114A6A5B6B7E040007F01001270-->  <POSITION><![CDATA[82]]></POSITION>
+<!--D7192114A6A5B6B7E040007F01001270-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--D7192114A6A5B6B7E040007F01001270-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--D7192114A6A5B6B7E040007F01001270-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--D7192114A6A5B6B7E040007F01001270-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--D7192114A6A5B6B7E040007F01001270-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--D7192114A6A5B6B7E040007F01001270--></AD_COLUMN>
+
+<!--D7192114A6A6B6B7E040007F01001270--><AD_COLUMN>
+<!--D7192114A6A6B6B7E040007F01001270-->  <AD_COLUMN_ID><![CDATA[D7192114A6A6B6B7E040007F01001270]]></AD_COLUMN_ID>
+<!--D7192114A6A6B6B7E040007F01001270-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--D7192114A6A6B6B7E040007F01001270-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--D7192114A6A6B6B7E040007F01001270-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--D7192114A6A6B6B7E040007F01001270-->  <NAME><![CDATA[Generic Product]]></NAME>
+<!--D7192114A6A6B6B7E040007F01001270-->  <HELP><![CDATA[Generic product related to this product. The product will inherit all the properties defined in the generic product. Such as taxes or price.]]></HELP>
+<!--D7192114A6A6B6B7E040007F01001270-->  <COLUMNNAME><![CDATA[Generic_Product_ID]]></COLUMNNAME>
+<!--D7192114A6A6B6B7E040007F01001270-->  <AD_TABLE_ID><![CDATA[208]]></AD_TABLE_ID>
+<!--D7192114A6A6B6B7E040007F01001270-->  <AD_REFERENCE_ID><![CDATA[18]]></AD_REFERENCE_ID>
+<!--D7192114A6A6B6B7E040007F01001270-->  <AD_REFERENCE_VALUE_ID><![CDATA[84ECA724EF074F679DFD69556C6DAF21]]></AD_REFERENCE_VALUE_ID>
+<!--D7192114A6A6B6B7E040007F01001270-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--D7192114A6A6B6B7E040007F01001270-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--D7192114A6A6B6B7E040007F01001270-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--D7192114A6A6B6B7E040007F01001270-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--D7192114A6A6B6B7E040007F01001270-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--D7192114A6A6B6B7E040007F01001270-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--D7192114A6A6B6B7E040007F01001270-->  <SEQNO><![CDATA[440]]></SEQNO>
+<!--D7192114A6A6B6B7E040007F01001270-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--D7192114A6A6B6B7E040007F01001270-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--D7192114A6A6B6B7E040007F01001270-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--D7192114A6A6B6B7E040007F01001270-->  <AD_ELEMENT_ID><![CDATA[D7192114A6B1B6B7E040007F01001270]]></AD_ELEMENT_ID>
+<!--D7192114A6A6B6B7E040007F01001270-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--D7192114A6A6B6B7E040007F01001270-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--D7192114A6A6B6B7E040007F01001270-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--D7192114A6A6B6B7E040007F01001270-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--D7192114A6A6B6B7E040007F01001270-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--D7192114A6A6B6B7E040007F01001270-->  <POSITION><![CDATA[83]]></POSITION>
+<!--D7192114A6A6B6B7E040007F01001270-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--D7192114A6A6B6B7E040007F01001270-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--D7192114A6A6B6B7E040007F01001270-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--D7192114A6A6B6B7E040007F01001270-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--D7192114A6A6B6B7E040007F01001270-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--D7192114A6A6B6B7E040007F01001270--></AD_COLUMN>
+
 <!--D781BB443D72453A8CB89BE9B210F206--><AD_COLUMN>
 <!--D781BB443D72453A8CB89BE9B210F206-->  <AD_COLUMN_ID><![CDATA[D781BB443D72453A8CB89BE9B210F206]]></AD_COLUMN_ID>
 <!--D781BB443D72453A8CB89BE9B210F206-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_ELEMENT.xml	Fri Mar 01 15:17:06 2013 +0100
+++ b/src-db/database/sourcedata/AD_ELEMENT.xml	Mon Mar 04 18:52:40 2013 +0100
@@ -30643,6 +30643,32 @@
 <!--D6DD1CBB8C5238A2E040007F01004689-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
 <!--D6DD1CBB8C5238A2E040007F01004689--></AD_ELEMENT>
 
+<!--D7192114A6B0B6B7E040007F01001270--><AD_ELEMENT>
+<!--D7192114A6B0B6B7E040007F01001270-->  <AD_ELEMENT_ID><![CDATA[D7192114A6B0B6B7E040007F01001270]]></AD_ELEMENT_ID>
+<!--D7192114A6B0B6B7E040007F01001270-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--D7192114A6B0B6B7E040007F01001270-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--D7192114A6B0B6B7E040007F01001270-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--D7192114A6B0B6B7E040007F01001270-->  <COLUMNNAME><![CDATA[IsGeneric]]></COLUMNNAME>
+<!--D7192114A6B0B6B7E040007F01001270-->  <NAME><![CDATA[Is Generic]]></NAME>
+<!--D7192114A6B0B6B7E040007F01001270-->  <PRINTNAME><![CDATA[Is Generic]]></PRINTNAME>
+<!--D7192114A6B0B6B7E040007F01001270-->  <HELP><![CDATA[Identifies a generic product. A generic product cannot be purchased or sold.]]></HELP>
+<!--D7192114A6B0B6B7E040007F01001270-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--D7192114A6B0B6B7E040007F01001270-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
+<!--D7192114A6B0B6B7E040007F01001270--></AD_ELEMENT>
+
+<!--D7192114A6B1B6B7E040007F01001270--><AD_ELEMENT>
+<!--D7192114A6B1B6B7E040007F01001270-->  <AD_ELEMENT_ID><![CDATA[D7192114A6B1B6B7E040007F01001270]]></AD_ELEMENT_ID>
+<!--D7192114A6B1B6B7E040007F01001270-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--D7192114A6B1B6B7E040007F01001270-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--D7192114A6B1B6B7E040007F01001270-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--D7192114A6B1B6B7E040007F01001270-->  <COLUMNNAME><![CDATA[Generic_Product_ID]]></COLUMNNAME>
+<!--D7192114A6B1B6B7E040007F01001270-->  <NAME><![CDATA[Generic Product]]></NAME>
+<!--D7192114A6B1B6B7E040007F01001270-->  <PRINTNAME><![CDATA[Generic_Product_ID]]></PRINTNAME>
+<!--D7192114A6B1B6B7E040007F01001270-->  <HELP><![CDATA[Generic product related to this product. The product will inherit all the properties defined in the generic product. Such as taxes or price.]]></HELP>
+<!--D7192114A6B1B6B7E040007F01001270-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--D7192114A6B1B6B7E040007F01001270-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
+<!--D7192114A6B1B6B7E040007F01001270--></AD_ELEMENT>
+
 <!--D83B9497015D4097989560C2348969BE--><AD_ELEMENT>
 <!--D83B9497015D4097989560C2348969BE-->  <AD_ELEMENT_ID><![CDATA[D83B9497015D4097989560C2348969BE]]></AD_ELEMENT_ID>
 <!--D83B9497015D4097989560C2348969BE-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_FIELD.xml	Fri Mar 01 15:17:06 2013 +0100
+++ b/src-db/database/sourcedata/AD_FIELD.xml	Mon Mar 04 18:52:40 2013 +0100
@@ -16676,6 +16676,7 @@
 <!--1316-->  <AD_COLUMN_ID><![CDATA[2304]]></AD_COLUMN_ID>
 <!--1316-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
 <!--1316-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--1316-->  <DISPLAYLOGIC><![CDATA[@isgeneric@='N']]></DISPLAYLOGIC>
 <!--1316-->  <DISPLAYLENGTH><![CDATA[13]]></DISPLAYLENGTH>
 <!--1316-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
 <!--1316-->  <SEQNO><![CDATA[210]]></SEQNO>
@@ -265965,6 +265966,61 @@
 <!--D714E3DB6600433F9007DF28F3D9D681-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--D714E3DB6600433F9007DF28F3D9D681--></AD_FIELD>
 
+<!--D71921761B37AFB9E040007F01001265--><AD_FIELD>
+<!--D71921761B37AFB9E040007F01001265-->  <AD_FIELD_ID><![CDATA[D71921761B37AFB9E040007F01001265]]></AD_FIELD_ID>
+<!--D71921761B37AFB9E040007F01001265-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--D71921761B37AFB9E040007F01001265-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--D71921761B37AFB9E040007F01001265-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--D71921761B37AFB9E040007F01001265-->  <NAME><![CDATA[Is Generic]]></NAME>
+<!--D71921761B37AFB9E040007F01001265-->  <HELP><![CDATA[Identifies a generic product. A generic product cannot be purchased or sold.]]></HELP>
+<!--D71921761B37AFB9E040007F01001265-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--D71921761B37AFB9E040007F01001265-->  <AD_TAB_ID><![CDATA[180]]></AD_TAB_ID>
+<!--D71921761B37AFB9E040007F01001265-->  <AD_COLUMN_ID><![CDATA[D7192114A6A5B6B7E040007F01001270]]></AD_COLUMN_ID>
+<!--D71921761B37AFB9E040007F01001265-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--D71921761B37AFB9E040007F01001265-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--D71921761B37AFB9E040007F01001265-->  <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
+<!--D71921761B37AFB9E040007F01001265-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--D71921761B37AFB9E040007F01001265-->  <SEQNO><![CDATA[75]]></SEQNO>
+<!--D71921761B37AFB9E040007F01001265-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--D71921761B37AFB9E040007F01001265-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--D71921761B37AFB9E040007F01001265-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--D71921761B37AFB9E040007F01001265-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--D71921761B37AFB9E040007F01001265-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--D71921761B37AFB9E040007F01001265-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--D71921761B37AFB9E040007F01001265-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--D71921761B37AFB9E040007F01001265-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--D71921761B37AFB9E040007F01001265-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--D71921761B37AFB9E040007F01001265-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--D71921761B37AFB9E040007F01001265--></AD_FIELD>
+
+<!--D71921761B38AFB9E040007F01001265--><AD_FIELD>
+<!--D71921761B38AFB9E040007F01001265-->  <AD_FIELD_ID><![CDATA[D71921761B38AFB9E040007F01001265]]></AD_FIELD_ID>
+<!--D71921761B38AFB9E040007F01001265-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--D71921761B38AFB9E040007F01001265-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--D71921761B38AFB9E040007F01001265-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--D71921761B38AFB9E040007F01001265-->  <NAME><![CDATA[Generic Product]]></NAME>
+<!--D71921761B38AFB9E040007F01001265-->  <HELP><![CDATA[Generic product related to this product. The product will inherit all the properties defined in the generic product. Such as taxes or price.]]></HELP>
+<!--D71921761B38AFB9E040007F01001265-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--D71921761B38AFB9E040007F01001265-->  <AD_TAB_ID><![CDATA[180]]></AD_TAB_ID>
+<!--D71921761B38AFB9E040007F01001265-->  <AD_COLUMN_ID><![CDATA[D7192114A6A6B6B7E040007F01001270]]></AD_COLUMN_ID>
+<!--D71921761B38AFB9E040007F01001265-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--D71921761B38AFB9E040007F01001265-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--D71921761B38AFB9E040007F01001265-->  <DISPLAYLOGIC><![CDATA[@isgeneric@='N']]></DISPLAYLOGIC>
+<!--D71921761B38AFB9E040007F01001265-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
+<!--D71921761B38AFB9E040007F01001265-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--D71921761B38AFB9E040007F01001265-->  <SEQNO><![CDATA[95]]></SEQNO>
+<!--D71921761B38AFB9E040007F01001265-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--D71921761B38AFB9E040007F01001265-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--D71921761B38AFB9E040007F01001265-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--D71921761B38AFB9E040007F01001265-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--D71921761B38AFB9E040007F01001265-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--D71921761B38AFB9E040007F01001265-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--D71921761B38AFB9E040007F01001265-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--D71921761B38AFB9E040007F01001265-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--D71921761B38AFB9E040007F01001265-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--D71921761B38AFB9E040007F01001265-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--D71921761B38AFB9E040007F01001265--></AD_FIELD>
+
 <!--D7232C6F9280422AB790D6A5A9AE952A--><AD_FIELD>
 <!--D7232C6F9280422AB790D6A5A9AE952A-->  <AD_FIELD_ID><![CDATA[D7232C6F9280422AB790D6A5A9AE952A]]></AD_FIELD_ID>
 <!--D7232C6F9280422AB790D6A5A9AE952A-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_REFERENCE.xml	Fri Mar 01 15:17:06 2013 +0100
+++ b/src-db/database/sourcedata/AD_REFERENCE.xml	Mon Mar 04 18:52:40 2013 +0100
@@ -5087,6 +5087,18 @@
 <!--84BD487714B04B838A8D562A30E8792C-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
 <!--84BD487714B04B838A8D562A30E8792C--></AD_REFERENCE>
 
+<!--84ECA724EF074F679DFD69556C6DAF21--><AD_REFERENCE>
+<!--84ECA724EF074F679DFD69556C6DAF21-->  <AD_REFERENCE_ID><![CDATA[84ECA724EF074F679DFD69556C6DAF21]]></AD_REFERENCE_ID>
+<!--84ECA724EF074F679DFD69556C6DAF21-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--84ECA724EF074F679DFD69556C6DAF21-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--84ECA724EF074F679DFD69556C6DAF21-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--84ECA724EF074F679DFD69556C6DAF21-->  <NAME><![CDATA[Generic Product]]></NAME>
+<!--84ECA724EF074F679DFD69556C6DAF21-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--84ECA724EF074F679DFD69556C6DAF21-->  <ISBASEREFERENCE><![CDATA[N]]></ISBASEREFERENCE>
+<!--84ECA724EF074F679DFD69556C6DAF21-->  <PARENTREFERENCE_ID><![CDATA[18]]></PARENTREFERENCE_ID>
+<!--84ECA724EF074F679DFD69556C6DAF21-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
+<!--84ECA724EF074F679DFD69556C6DAF21--></AD_REFERENCE>
+
 <!--86086D70DDBC42B09E2BEB51D25C159F--><AD_REFERENCE>
 <!--86086D70DDBC42B09E2BEB51D25C159F-->  <AD_REFERENCE_ID><![CDATA[86086D70DDBC42B09E2BEB51D25C159F]]></AD_REFERENCE_ID>
 <!--86086D70DDBC42B09E2BEB51D25C159F-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_REF_TABLE.xml	Fri Mar 01 15:17:06 2013 +0100
+++ b/src-db/database/sourcedata/AD_REF_TABLE.xml	Mon Mar 04 18:52:40 2013 +0100
@@ -1234,6 +1234,19 @@
 <!--66E310A87A844A51B8BAD2884E996CD6-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
 <!--66E310A87A844A51B8BAD2884E996CD6--></AD_REF_TABLE>
 
+<!--84ECA724EF074F679DFD69556C6DAF21--><AD_REF_TABLE>
+<!--84ECA724EF074F679DFD69556C6DAF21-->  <AD_REFERENCE_ID><![CDATA[84ECA724EF074F679DFD69556C6DAF21]]></AD_REFERENCE_ID>
+<!--84ECA724EF074F679DFD69556C6DAF21-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--84ECA724EF074F679DFD69556C6DAF21-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--84ECA724EF074F679DFD69556C6DAF21-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--84ECA724EF074F679DFD69556C6DAF21-->  <AD_TABLE_ID><![CDATA[208]]></AD_TABLE_ID>
+<!--84ECA724EF074F679DFD69556C6DAF21-->  <AD_KEY><![CDATA[1402]]></AD_KEY>
+<!--84ECA724EF074F679DFD69556C6DAF21-->  <AD_DISPLAY><![CDATA[1410]]></AD_DISPLAY>
+<!--84ECA724EF074F679DFD69556C6DAF21-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
+<!--84ECA724EF074F679DFD69556C6DAF21-->  <WHERECLAUSE><![CDATA[M_Product.isGeneric = 'Y']]></WHERECLAUSE>
+<!--84ECA724EF074F679DFD69556C6DAF21-->  <HQLWHERECLAUSE><![CDATA[isGeneric = true]]></HQLWHERECLAUSE>
+<!--84ECA724EF074F679DFD69556C6DAF21--></AD_REF_TABLE>
+
 <!--99EC3A7013654794BB52975DAA3B80E6--><AD_REF_TABLE>
 <!--99EC3A7013654794BB52975DAA3B80E6-->  <AD_REFERENCE_ID><![CDATA[99EC3A7013654794BB52975DAA3B80E6]]></AD_REFERENCE_ID>
 <!--99EC3A7013654794BB52975DAA3B80E6-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>