[levelPricing] create new field
authorGuillermo Alvarez de Eulate <guillermo.alvarez@openbravo.com>
Mon, 14 Oct 2013 11:15:06 +0200
changeset 21274 3938e222ce19
parent 21273 c2976ed10888
child 21275 38ab65d07468
[levelPricing] create new field
src-db/database/model/tables/M_PRODUCTPRICE.xml
src-db/database/sourcedata/AD_AUXILIARINPUT.xml
src-db/database/sourcedata/AD_COLUMN.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/M_PRODUCTPRICE.xml	Thu Oct 03 12:31:10 2013 +0530
+++ b/src-db/database/model/tables/M_PRODUCTPRICE.xml	Mon Oct 14 11:15:06 2013 +0200
@@ -57,6 +57,10 @@
         <default><![CDATA[0]]></default>
         <onCreateDefault/>
       </column>
+      <column name="ALGORITHM" primaryKey="false" required="true" type="VARCHAR" size="60" autoIncrement="false">
+        <default><![CDATA[S]]></default>
+        <onCreateDefault/>
+      </column>
       <foreign-key foreignTable="AD_CLIENT" name="M_PRODUCTPRICE_AD_CLIENT">
         <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
       </foreign-key>
--- a/src-db/database/sourcedata/AD_AUXILIARINPUT.xml	Thu Oct 03 12:31:10 2013 +0530
+++ b/src-db/database/sourcedata/AD_AUXILIARINPUT.xml	Mon Oct 14 11:15:06 2013 +0200
@@ -1963,6 +1963,17 @@
 <!--6BDE684AC58045218FAEB2A11221911B-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--6BDE684AC58045218FAEB2A11221911B--></AD_AUXILIARINPUT>
 
+<!--6DD1F4E5833C453988901A926575130D--><AD_AUXILIARINPUT>
+<!--6DD1F4E5833C453988901A926575130D-->  <AD_AUXILIARINPUT_ID><![CDATA[6DD1F4E5833C453988901A926575130D]]></AD_AUXILIARINPUT_ID>
+<!--6DD1F4E5833C453988901A926575130D-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--6DD1F4E5833C453988901A926575130D-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--6DD1F4E5833C453988901A926575130D-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--6DD1F4E5833C453988901A926575130D-->  <AD_TAB_ID><![CDATA[192]]></AD_TAB_ID>
+<!--6DD1F4E5833C453988901A926575130D-->  <NAME><![CDATA[numberOfAlgorithms]]></NAME>
+<!--6DD1F4E5833C453988901A926575130D-->  <CODE><![CDATA[@SQL=select count(*) from ad_ref_list where ad_reference_id = '5B988E35236D404B8210801472E363CE']]></CODE>
+<!--6DD1F4E5833C453988901A926575130D-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--6DD1F4E5833C453988901A926575130D--></AD_AUXILIARINPUT>
+
 <!--6DDE5291DEB245BAB84FFD042AE66D4C--><AD_AUXILIARINPUT>
 <!--6DDE5291DEB245BAB84FFD042AE66D4C-->  <AD_AUXILIARINPUT_ID><![CDATA[6DDE5291DEB245BAB84FFD042AE66D4C]]></AD_AUXILIARINPUT_ID>
 <!--6DDE5291DEB245BAB84FFD042AE66D4C-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Thu Oct 03 12:31:10 2013 +0530
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Mon Oct 14 11:15:06 2013 +0200
@@ -229562,6 +229562,40 @@
 <!--35D2E70BF3924621A4A20CC1AB0DB0F6-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--35D2E70BF3924621A4A20CC1AB0DB0F6--></AD_COLUMN>
 
+<!--35DCE951EEE34604911411B71ABE1A35--><AD_COLUMN>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <AD_COLUMN_ID><![CDATA[35DCE951EEE34604911411B71ABE1A35]]></AD_COLUMN_ID>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <NAME><![CDATA[Algorithm]]></NAME>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <COLUMNNAME><![CDATA[Algorithm]]></COLUMNNAME>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <AD_TABLE_ID><![CDATA[251]]></AD_TABLE_ID>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <AD_REFERENCE_ID><![CDATA[17]]></AD_REFERENCE_ID>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <AD_REFERENCE_VALUE_ID><![CDATA[5B988E35236D404B8210801472E363CE]]></AD_REFERENCE_VALUE_ID>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <FIELDLENGTH><![CDATA[60]]></FIELDLENGTH>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <DEFAULTVALUE><![CDATA[S]]></DEFAULTVALUE>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <SEQNO><![CDATA[22]]></SEQNO>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <POSITION><![CDATA[15]]></POSITION>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--35DCE951EEE34604911411B71ABE1A35-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--35DCE951EEE34604911411B71ABE1A35--></AD_COLUMN>
+
 <!--35DF1D3CE32C43A397D9F00279FF11F7--><AD_COLUMN>
 <!--35DF1D3CE32C43A397D9F00279FF11F7-->  <AD_COLUMN_ID><![CDATA[35DF1D3CE32C43A397D9F00279FF11F7]]></AD_COLUMN_ID>
 <!--35DF1D3CE32C43A397D9F00279FF11F7-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_FIELD.xml	Thu Oct 03 12:31:10 2013 +0530
+++ b/src-db/database/sourcedata/AD_FIELD.xml	Mon Oct 14 11:15:06 2013 +0200
@@ -175146,6 +175146,33 @@
 <!--0157DD4316594C6CBC58F2AACC7EBCAB-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--0157DD4316594C6CBC58F2AACC7EBCAB--></AD_FIELD>
 
+<!--015C441F5CA14135910507DABFB3CED8--><AD_FIELD>
+<!--015C441F5CA14135910507DABFB3CED8-->  <AD_FIELD_ID><![CDATA[015C441F5CA14135910507DABFB3CED8]]></AD_FIELD_ID>
+<!--015C441F5CA14135910507DABFB3CED8-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--015C441F5CA14135910507DABFB3CED8-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--015C441F5CA14135910507DABFB3CED8-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--015C441F5CA14135910507DABFB3CED8-->  <NAME><![CDATA[Algorithm]]></NAME>
+<!--015C441F5CA14135910507DABFB3CED8-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--015C441F5CA14135910507DABFB3CED8-->  <AD_TAB_ID><![CDATA[192]]></AD_TAB_ID>
+<!--015C441F5CA14135910507DABFB3CED8-->  <AD_COLUMN_ID><![CDATA[35DCE951EEE34604911411B71ABE1A35]]></AD_COLUMN_ID>
+<!--015C441F5CA14135910507DABFB3CED8-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--015C441F5CA14135910507DABFB3CED8-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--015C441F5CA14135910507DABFB3CED8-->  <DISPLAYLOGIC><![CDATA[(@numberOfAlgorithms@>1)]]></DISPLAYLOGIC>
+<!--015C441F5CA14135910507DABFB3CED8-->  <DISPLAYLENGTH><![CDATA[60]]></DISPLAYLENGTH>
+<!--015C441F5CA14135910507DABFB3CED8-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--015C441F5CA14135910507DABFB3CED8-->  <SEQNO><![CDATA[60]]></SEQNO>
+<!--015C441F5CA14135910507DABFB3CED8-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--015C441F5CA14135910507DABFB3CED8-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--015C441F5CA14135910507DABFB3CED8-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--015C441F5CA14135910507DABFB3CED8-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--015C441F5CA14135910507DABFB3CED8-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--015C441F5CA14135910507DABFB3CED8-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--015C441F5CA14135910507DABFB3CED8-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--015C441F5CA14135910507DABFB3CED8-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--015C441F5CA14135910507DABFB3CED8-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--015C441F5CA14135910507DABFB3CED8-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--015C441F5CA14135910507DABFB3CED8--></AD_FIELD>
+
 <!--01834799FA424582A1BB3C6DB62533DF--><AD_FIELD>
 <!--01834799FA424582A1BB3C6DB62533DF-->  <AD_FIELD_ID><![CDATA[01834799FA424582A1BB3C6DB62533DF]]></AD_FIELD_ID>
 <!--01834799FA424582A1BB3C6DB62533DF-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_REFERENCE.xml	Thu Oct 03 12:31:10 2013 +0530
+++ b/src-db/database/sourcedata/AD_REFERENCE.xml	Mon Oct 14 11:15:06 2013 +0200
@@ -4987,6 +4987,18 @@
 <!--5AD08D5DF85549E0BCC0DEBDE4C0D340-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
 <!--5AD08D5DF85549E0BCC0DEBDE4C0D340--></AD_REFERENCE>
 
+<!--5B988E35236D404B8210801472E363CE--><AD_REFERENCE>
+<!--5B988E35236D404B8210801472E363CE-->  <AD_REFERENCE_ID><![CDATA[5B988E35236D404B8210801472E363CE]]></AD_REFERENCE_ID>
+<!--5B988E35236D404B8210801472E363CE-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--5B988E35236D404B8210801472E363CE-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--5B988E35236D404B8210801472E363CE-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--5B988E35236D404B8210801472E363CE-->  <NAME><![CDATA[LevelPricingAlgorithms]]></NAME>
+<!--5B988E35236D404B8210801472E363CE-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--5B988E35236D404B8210801472E363CE-->  <ISBASEREFERENCE><![CDATA[N]]></ISBASEREFERENCE>
+<!--5B988E35236D404B8210801472E363CE-->  <PARENTREFERENCE_ID><![CDATA[17]]></PARENTREFERENCE_ID>
+<!--5B988E35236D404B8210801472E363CE-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
+<!--5B988E35236D404B8210801472E363CE--></AD_REFERENCE>
+
 <!--5BBEA02A7BCE441A81BC546DF034162E--><AD_REFERENCE>
 <!--5BBEA02A7BCE441A81BC546DF034162E-->  <AD_REFERENCE_ID><![CDATA[5BBEA02A7BCE441A81BC546DF034162E]]></AD_REFERENCE_ID>
 <!--5BBEA02A7BCE441A81BC546DF034162E-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_REF_LIST.xml	Thu Oct 03 12:31:10 2013 +0530
+++ b/src-db/database/sourcedata/AD_REF_LIST.xml	Mon Oct 14 11:15:06 2013 +0200
@@ -7816,6 +7816,17 @@
 <!--01920B83AE144535BF95CDB43012A76D-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--01920B83AE144535BF95CDB43012A76D--></AD_REF_LIST>
 
+<!--0244CAE760E942F597842177ABE0A88D--><AD_REF_LIST>
+<!--0244CAE760E942F597842177ABE0A88D-->  <AD_REF_LIST_ID><![CDATA[0244CAE760E942F597842177ABE0A88D]]></AD_REF_LIST_ID>
+<!--0244CAE760E942F597842177ABE0A88D-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--0244CAE760E942F597842177ABE0A88D-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--0244CAE760E942F597842177ABE0A88D-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--0244CAE760E942F597842177ABE0A88D-->  <VALUE><![CDATA[S]]></VALUE>
+<!--0244CAE760E942F597842177ABE0A88D-->  <NAME><![CDATA[Standard]]></NAME>
+<!--0244CAE760E942F597842177ABE0A88D-->  <AD_REFERENCE_ID><![CDATA[5B988E35236D404B8210801472E363CE]]></AD_REFERENCE_ID>
+<!--0244CAE760E942F597842177ABE0A88D-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--0244CAE760E942F597842177ABE0A88D--></AD_REF_LIST>
+
 <!--02DF846DDB7C4B4E8C2E483B38A977B7--><AD_REF_LIST>
 <!--02DF846DDB7C4B4E8C2E483B38A977B7-->  <AD_REF_LIST_ID><![CDATA[02DF846DDB7C4B4E8C2E483B38A977B7]]></AD_REF_LIST_ID>
 <!--02DF846DDB7C4B4E8C2E483B38A977B7-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -8612,6 +8623,17 @@
 <!--2D27A7C27FED42499D5F028CC49967F8-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--2D27A7C27FED42499D5F028CC49967F8--></AD_REF_LIST>
 
+<!--2D760DB77BFB4EF5A1EB140BE5198561--><AD_REF_LIST>
+<!--2D760DB77BFB4EF5A1EB140BE5198561-->  <AD_REF_LIST_ID><![CDATA[2D760DB77BFB4EF5A1EB140BE5198561]]></AD_REF_LIST_ID>
+<!--2D760DB77BFB4EF5A1EB140BE5198561-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--2D760DB77BFB4EF5A1EB140BE5198561-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--2D760DB77BFB4EF5A1EB140BE5198561-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--2D760DB77BFB4EF5A1EB140BE5198561-->  <VALUE><![CDATA[O]]></VALUE>
+<!--2D760DB77BFB4EF5A1EB140BE5198561-->  <NAME><![CDATA[Other]]></NAME>
+<!--2D760DB77BFB4EF5A1EB140BE5198561-->  <AD_REFERENCE_ID><![CDATA[5B988E35236D404B8210801472E363CE]]></AD_REFERENCE_ID>
+<!--2D760DB77BFB4EF5A1EB140BE5198561-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--2D760DB77BFB4EF5A1EB140BE5198561--></AD_REF_LIST>
+
 <!--2F98263E2FDA44D9B435E2028463077C--><AD_REF_LIST>
 <!--2F98263E2FDA44D9B435E2028463077C-->  <AD_REF_LIST_ID><![CDATA[2F98263E2FDA44D9B435E2028463077C]]></AD_REF_LIST_ID>
 <!--2F98263E2FDA44D9B435E2028463077C-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>