Fixes Issue 25427:API Change:Remove M_Storage_Detail_Id in M_Reservation_Stock table
authorGaurav Deshmukh <gaurav.deshmukh@openbravo.com>
Thu, 23 Jan 2014 11:00:46 +0530
changeset 534 eb8d651673a9
parent 533 c8fb5db9f85a
child 535 7e1c242e335f
Fixes Issue 25427:API Change:Remove M_Storage_Detail_Id in M_Reservation_Stock table
java/reference/java.japi.gz
model/src-db/database/model/tables/M_RESERVATION_STOCK.xml
model/src-db/database/sourcedata/AD_COLUMN.xml
Binary file java/reference/java.japi.gz has changed
--- a/model/src-db/database/model/tables/M_RESERVATION_STOCK.xml	Thu Jan 16 12:20:38 2014 +0530
+++ b/model/src-db/database/model/tables/M_RESERVATION_STOCK.xml	Thu Jan 23 11:00:46 2014 +0530
@@ -37,10 +37,6 @@
         <default/>
         <onCreateDefault/>
       </column>
-      <column name="M_STORAGE_DETAIL_ID" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false">
-        <default/>
-        <onCreateDefault/>
-      </column>
       <column name="C_ORDERLINE_ID" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false">
         <default/>
         <onCreateDefault/>
@@ -83,15 +79,9 @@
       <foreign-key foreignTable="M_RESERVATION" name="M_RESERVATION_STOCK_RESERV">
         <reference local="M_RESERVATION_ID" foreign="M_RESERVATION_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="M_STORAGE_DETAIL" name="M_RESERVATION_STOCK_ST_DET">
-        <reference local="M_STORAGE_DETAIL_ID" foreign="M_STORAGE_DETAIL_ID"/>
-      </foreign-key>
       <index name="M_RESERVATION_STOCK_RES" unique="false">
         <index-column name="M_RESERVATION_ID"/>
       </index>
-      <index name="M_RESERVATION_STOCK_SD" unique="false">
-        <index-column name="M_STORAGE_DETAIL_ID"/>
-      </index>
       <index name="M_RESERVSTOCK_ORDERLINE_IDX" unique="false">
         <index-column name="C_ORDERLINE_ID"/>
       </index>
--- a/model/src-db/database/sourcedata/AD_COLUMN.xml	Thu Jan 16 12:20:38 2014 +0530
+++ b/model/src-db/database/sourcedata/AD_COLUMN.xml	Thu Jan 23 11:00:46 2014 +0530
@@ -307338,40 +307338,6 @@
 <!--CA9E5C38D2F27E11E040007F010067A6-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--CA9E5C38D2F27E11E040007F010067A6--></AD_COLUMN>
 
-<!--CA9E5C38D2F37E11E040007F010067A6--><AD_COLUMN>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <AD_COLUMN_ID><![CDATA[CA9E5C38D2F37E11E040007F010067A6]]></AD_COLUMN_ID>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <ISACTIVE><![CDATA[N]]></ISACTIVE>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <NAME><![CDATA[Storage Detail]]></NAME>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <HELP><![CDATA[The Storage Detail identifies a stock in the warehouse by quantity, attributes and storage bin.]]></HELP>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <COLUMNNAME><![CDATA[M_Storage_Detail_ID]]></COLUMNNAME>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <AD_TABLE_ID><![CDATA[D6079A4A6C2542678D9A50114367B967]]></AD_TABLE_ID>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <AD_REFERENCE_ID><![CDATA[35]]></AD_REFERENCE_ID>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <ISKEY><![CDATA[N]]></ISKEY>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <ISIDENTIFIER><![CDATA[Y]]></ISIDENTIFIER>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <SEQNO><![CDATA[100]]></SEQNO>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <AD_ELEMENT_ID><![CDATA[800134]]></AD_ELEMENT_ID>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <DEVELOPMENTSTATUS><![CDATA[NI]]></DEVELOPMENTSTATUS>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <POSITION><![CDATA[10]]></POSITION>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
-<!--CA9E5C38D2F37E11E040007F010067A6-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
-<!--CA9E5C38D2F37E11E040007F010067A6--></AD_COLUMN>
-
 <!--CA9E5C38D2F47E11E040007F010067A6--><AD_COLUMN>
 <!--CA9E5C38D2F47E11E040007F010067A6-->  <AD_COLUMN_ID><![CDATA[CA9E5C38D2F47E11E040007F010067A6]]></AD_COLUMN_ID>
 <!--CA9E5C38D2F47E11E040007F010067A6-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>