[Production-Development] Remove Consumption Type
authorrafaeldemiguel <rdm@openbravo.com>
Thu, 29 Sep 2011 18:09:32 +0200
changeset 14990 f2b310e1b65a
parent 14989 ed28c805c700
child 14991 7ea634bb2ed1
[Production-Development] Remove Consumption Type
src-db/database/model/tables/MA_SEQUENCEPRODUCT.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_LIST.xml
--- a/src-db/database/model/tables/MA_SEQUENCEPRODUCT.xml	Thu Sep 29 14:05:13 2011 +0200
+++ b/src-db/database/model/tables/MA_SEQUENCEPRODUCT.xml	Thu Sep 29 18:09:32 2011 +0200
@@ -81,10 +81,6 @@
         <default><![CDATA[N]]></default>
         <onCreateDefault><![CDATA['N']]></onCreateDefault>
       </column>
-      <column name="CONSUMPTIONTYPE" primaryKey="false" required="false" type="VARCHAR" size="60" autoIncrement="false">
-        <default/>
-        <onCreateDefault/>
-      </column>
       <column name="COPYPRODUCT" primaryKey="false" required="false" type="CHAR" size="1" autoIncrement="false">
         <default/>
         <onCreateDefault/>
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Thu Sep 29 14:05:13 2011 +0200
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Thu Sep 29 18:09:32 2011 +0200
@@ -209988,40 +209988,6 @@
 <!--1F13F0F08BC54946A505388B9BF82315-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
 <!--1F13F0F08BC54946A505388B9BF82315--></AD_COLUMN>
 
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13--><AD_COLUMN>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <AD_COLUMN_ID><![CDATA[1F8F8C06AD9F4679AAF9336AE5D14E13]]></AD_COLUMN_ID>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <NAME><![CDATA[Consumptiontype]]></NAME>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <DESCRIPTION><![CDATA[Consumption Type]]></DESCRIPTION>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <HELP><![CDATA[Consumption Type]]></HELP>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <COLUMNNAME><![CDATA[Consumptiontype]]></COLUMNNAME>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <AD_TABLE_ID><![CDATA[800097]]></AD_TABLE_ID>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <AD_REFERENCE_ID><![CDATA[17]]></AD_REFERENCE_ID>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <AD_REFERENCE_VALUE_ID><![CDATA[FF8081813205318F0132055392B20053]]></AD_REFERENCE_VALUE_ID>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <FIELDLENGTH><![CDATA[60]]></FIELDLENGTH>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <ISKEY><![CDATA[N]]></ISKEY>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <SEQNO><![CDATA[320]]></SEQNO>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <AD_ELEMENT_ID><![CDATA[4709AE14493145D9A1F3BB891763C68D]]></AD_ELEMENT_ID>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <POSITION><![CDATA[22]]></POSITION>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
-<!--1F8F8C06AD9F4679AAF9336AE5D14E13--></AD_COLUMN>
-
 <!--1F9C02B7A18448368C4E137F971747BF--><AD_COLUMN>
 <!--1F9C02B7A18448368C4E137F971747BF-->  <AD_COLUMN_ID><![CDATA[1F9C02B7A18448368C4E137F971747BF]]></AD_COLUMN_ID>
 <!--1F9C02B7A18448368C4E137F971747BF-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_ELEMENT.xml	Thu Sep 29 14:05:13 2011 +0200
+++ b/src-db/database/sourcedata/AD_ELEMENT.xml	Thu Sep 29 18:09:32 2011 +0200
@@ -19770,19 +19770,6 @@
 <!--46C995886E534B6BA240599DACD8240B-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--46C995886E534B6BA240599DACD8240B--></AD_ELEMENT>
 
-<!--4709AE14493145D9A1F3BB891763C68D--><AD_ELEMENT>
-<!--4709AE14493145D9A1F3BB891763C68D-->  <AD_ELEMENT_ID><![CDATA[4709AE14493145D9A1F3BB891763C68D]]></AD_ELEMENT_ID>
-<!--4709AE14493145D9A1F3BB891763C68D-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--4709AE14493145D9A1F3BB891763C68D-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--4709AE14493145D9A1F3BB891763C68D-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--4709AE14493145D9A1F3BB891763C68D-->  <COLUMNNAME><![CDATA[Consumptiontype]]></COLUMNNAME>
-<!--4709AE14493145D9A1F3BB891763C68D-->  <NAME><![CDATA[Consumption Type]]></NAME>
-<!--4709AE14493145D9A1F3BB891763C68D-->  <PRINTNAME><![CDATA[Consumption Type]]></PRINTNAME>
-<!--4709AE14493145D9A1F3BB891763C68D-->  <DESCRIPTION><![CDATA[Consumption Type]]></DESCRIPTION>
-<!--4709AE14493145D9A1F3BB891763C68D-->  <HELP><![CDATA[Consumption Type]]></HELP>
-<!--4709AE14493145D9A1F3BB891763C68D-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--4709AE14493145D9A1F3BB891763C68D--></AD_ELEMENT>
-
 <!--4823F0304FFC4CBF84A17244F0431117--><AD_ELEMENT>
 <!--4823F0304FFC4CBF84A17244F0431117-->  <AD_ELEMENT_ID><![CDATA[4823F0304FFC4CBF84A17244F0431117]]></AD_ELEMENT_ID>
 <!--4823F0304FFC4CBF84A17244F0431117-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_FIELD.xml	Thu Sep 29 14:05:13 2011 +0200
+++ b/src-db/database/sourcedata/AD_FIELD.xml	Thu Sep 29 18:09:32 2011 +0200
@@ -166781,34 +166781,6 @@
 <!--496692F1E30A400DB2C448F97AA8A9C1-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
 <!--496692F1E30A400DB2C448F97AA8A9C1--></AD_FIELD>
 
-<!--4A36D0E48E8F488D92C12C34F9EC3676--><AD_FIELD>
-<!--4A36D0E48E8F488D92C12C34F9EC3676-->  <AD_FIELD_ID><![CDATA[4A36D0E48E8F488D92C12C34F9EC3676]]></AD_FIELD_ID>
-<!--4A36D0E48E8F488D92C12C34F9EC3676-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--4A36D0E48E8F488D92C12C34F9EC3676-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--4A36D0E48E8F488D92C12C34F9EC3676-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--4A36D0E48E8F488D92C12C34F9EC3676-->  <NAME><![CDATA[Consumption Type]]></NAME>
-<!--4A36D0E48E8F488D92C12C34F9EC3676-->  <DESCRIPTION><![CDATA[Consumption Type]]></DESCRIPTION>
-<!--4A36D0E48E8F488D92C12C34F9EC3676-->  <HELP><![CDATA[Consumption Type]]></HELP>
-<!--4A36D0E48E8F488D92C12C34F9EC3676-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
-<!--4A36D0E48E8F488D92C12C34F9EC3676-->  <AD_TAB_ID><![CDATA[800110]]></AD_TAB_ID>
-<!--4A36D0E48E8F488D92C12C34F9EC3676-->  <AD_COLUMN_ID><![CDATA[1F8F8C06AD9F4679AAF9336AE5D14E13]]></AD_COLUMN_ID>
-<!--4A36D0E48E8F488D92C12C34F9EC3676-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
-<!--4A36D0E48E8F488D92C12C34F9EC3676-->  <DISPLAYLOGIC><![CDATA[@Productiontype@='-']]></DISPLAYLOGIC>
-<!--4A36D0E48E8F488D92C12C34F9EC3676-->  <DISPLAYLENGTH><![CDATA[60]]></DISPLAYLENGTH>
-<!--4A36D0E48E8F488D92C12C34F9EC3676-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--4A36D0E48E8F488D92C12C34F9EC3676-->  <SEQNO><![CDATA[45]]></SEQNO>
-<!--4A36D0E48E8F488D92C12C34F9EC3676-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
-<!--4A36D0E48E8F488D92C12C34F9EC3676-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
-<!--4A36D0E48E8F488D92C12C34F9EC3676-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--4A36D0E48E8F488D92C12C34F9EC3676-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
-<!--4A36D0E48E8F488D92C12C34F9EC3676-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
-<!--4A36D0E48E8F488D92C12C34F9EC3676-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--4A36D0E48E8F488D92C12C34F9EC3676-->  <GRID_SEQNO><![CDATA[45]]></GRID_SEQNO>
-<!--4A36D0E48E8F488D92C12C34F9EC3676-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
-<!--4A36D0E48E8F488D92C12C34F9EC3676-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
-<!--4A36D0E48E8F488D92C12C34F9EC3676-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
-<!--4A36D0E48E8F488D92C12C34F9EC3676--></AD_FIELD>
-
 <!--4A91B7362CFA4F7582FA703C760BD0C8--><AD_FIELD>
 <!--4A91B7362CFA4F7582FA703C760BD0C8-->  <AD_FIELD_ID><![CDATA[4A91B7362CFA4F7582FA703C760BD0C8]]></AD_FIELD_ID>
 <!--4A91B7362CFA4F7582FA703C760BD0C8-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_REFERENCE.xml	Thu Sep 29 14:05:13 2011 +0200
+++ b/src-db/database/sourcedata/AD_REFERENCE.xml	Thu Sep 29 18:09:32 2011 +0200
@@ -5107,20 +5107,6 @@
 <!--FF80818130217A35013021A672400035-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
 <!--FF80818130217A35013021A672400035--></AD_REFERENCE>
 
-<!--FF8081813205318F0132055392B20053--><AD_REFERENCE>
-<!--FF8081813205318F0132055392B20053-->  <AD_REFERENCE_ID><![CDATA[FF8081813205318F0132055392B20053]]></AD_REFERENCE_ID>
-<!--FF8081813205318F0132055392B20053-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--FF8081813205318F0132055392B20053-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--FF8081813205318F0132055392B20053-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--FF8081813205318F0132055392B20053-->  <NAME><![CDATA[Consumption Type]]></NAME>
-<!--FF8081813205318F0132055392B20053-->  <DESCRIPTION><![CDATA[Order of consumption in production]]></DESCRIPTION>
-<!--FF8081813205318F0132055392B20053-->  <HELP><![CDATA[Order of consumption in production]]></HELP>
-<!--FF8081813205318F0132055392B20053-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--FF8081813205318F0132055392B20053-->  <ISBASEREFERENCE><![CDATA[N]]></ISBASEREFERENCE>
-<!--FF8081813205318F0132055392B20053-->  <PARENTREFERENCE_ID><![CDATA[17]]></PARENTREFERENCE_ID>
-<!--FF8081813205318F0132055392B20053-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
-<!--FF8081813205318F0132055392B20053--></AD_REFERENCE>
-
 <!--FF808181321576F301321587CBB4004A--><AD_REFERENCE>
 <!--FF808181321576F301321587CBB4004A-->  <AD_REFERENCE_ID><![CDATA[FF808181321576F301321587CBB4004A]]></AD_REFERENCE_ID>
 <!--FF808181321576F301321587CBB4004A-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_REF_LIST.xml	Thu Sep 29 14:05:13 2011 +0200
+++ b/src-db/database/sourcedata/AD_REF_LIST.xml	Thu Sep 29 18:09:32 2011 +0200
@@ -10813,45 +10813,6 @@
 <!--FF80818131FFD8CE0131FFE55A360025-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--FF80818131FFD8CE0131FFE55A360025--></AD_REF_LIST>
 
-<!--FF8081813205318F0132055489DC0057--><AD_REF_LIST>
-<!--FF8081813205318F0132055489DC0057-->  <AD_REF_LIST_ID><![CDATA[FF8081813205318F0132055489DC0057]]></AD_REF_LIST_ID>
-<!--FF8081813205318F0132055489DC0057-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--FF8081813205318F0132055489DC0057-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--FF8081813205318F0132055489DC0057-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--FF8081813205318F0132055489DC0057-->  <VALUE><![CDATA[FIFO]]></VALUE>
-<!--FF8081813205318F0132055489DC0057-->  <NAME><![CDATA[FIFO]]></NAME>
-<!--FF8081813205318F0132055489DC0057-->  <DESCRIPTION><![CDATA[First In First Out]]></DESCRIPTION>
-<!--FF8081813205318F0132055489DC0057-->  <AD_REFERENCE_ID><![CDATA[FF8081813205318F0132055392B20053]]></AD_REFERENCE_ID>
-<!--FF8081813205318F0132055489DC0057-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--FF8081813205318F0132055489DC0057-->  <SEQNO><![CDATA[1]]></SEQNO>
-<!--FF8081813205318F0132055489DC0057--></AD_REF_LIST>
-
-<!--FF8081813205318F01320554FE65005B--><AD_REF_LIST>
-<!--FF8081813205318F01320554FE65005B-->  <AD_REF_LIST_ID><![CDATA[FF8081813205318F01320554FE65005B]]></AD_REF_LIST_ID>
-<!--FF8081813205318F01320554FE65005B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--FF8081813205318F01320554FE65005B-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--FF8081813205318F01320554FE65005B-->  <ISACTIVE><![CDATA[N]]></ISACTIVE>
-<!--FF8081813205318F01320554FE65005B-->  <VALUE><![CDATA[LIFO]]></VALUE>
-<!--FF8081813205318F01320554FE65005B-->  <NAME><![CDATA[LIFO]]></NAME>
-<!--FF8081813205318F01320554FE65005B-->  <DESCRIPTION><![CDATA[Last In First Out]]></DESCRIPTION>
-<!--FF8081813205318F01320554FE65005B-->  <AD_REFERENCE_ID><![CDATA[FF8081813205318F0132055392B20053]]></AD_REFERENCE_ID>
-<!--FF8081813205318F01320554FE65005B-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--FF8081813205318F01320554FE65005B-->  <SEQNO><![CDATA[2]]></SEQNO>
-<!--FF8081813205318F01320554FE65005B--></AD_REF_LIST>
-
-<!--FF8081813205318F01320555E4FD005F--><AD_REF_LIST>
-<!--FF8081813205318F01320555E4FD005F-->  <AD_REF_LIST_ID><![CDATA[FF8081813205318F01320555E4FD005F]]></AD_REF_LIST_ID>
-<!--FF8081813205318F01320555E4FD005F-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--FF8081813205318F01320555E4FD005F-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--FF8081813205318F01320555E4FD005F-->  <ISACTIVE><![CDATA[N]]></ISACTIVE>
-<!--FF8081813205318F01320555E4FD005F-->  <VALUE><![CDATA[FEFO]]></VALUE>
-<!--FF8081813205318F01320555E4FD005F-->  <NAME><![CDATA[FEFO]]></NAME>
-<!--FF8081813205318F01320555E4FD005F-->  <DESCRIPTION><![CDATA[First Expire First Out]]></DESCRIPTION>
-<!--FF8081813205318F01320555E4FD005F-->  <AD_REFERENCE_ID><![CDATA[FF8081813205318F0132055392B20053]]></AD_REFERENCE_ID>
-<!--FF8081813205318F01320555E4FD005F-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--FF8081813205318F01320555E4FD005F-->  <SEQNO><![CDATA[3]]></SEQNO>
-<!--FF8081813205318F01320555E4FD005F--></AD_REF_LIST>
-
 <!--FF808181322476640132249F0AD90033--><AD_REF_LIST>
 <!--FF808181322476640132249F0AD90033-->  <AD_REF_LIST_ID><![CDATA[FF808181322476640132249F0AD90033]]></AD_REF_LIST_ID>
 <!--FF808181322476640132249F0AD90033-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>