Related to issue 19755.Added new canceled_inoutline_id column to relate voided inouts.
authorGorka Ion Damián <gorkaion.damian@openbravo.com>
Wed, 01 Feb 2012 12:25:16 +0100
changeset 15467 6f6f0534dd25
parent 15466 34aaf22a4ca0
child 15468 f663c413f0b0
Related to issue 19755.Added new canceled_inoutline_id column to relate voided inouts.
src-db/database/model/tables/M_INOUTLINE.xml
src-db/database/sourcedata/AD_COLUMN.xml
src-db/database/sourcedata/AD_ELEMENT.xml
src-db/database/sourcedata/AD_REFERENCE.xml
src-db/database/sourcedata/AD_REF_TABLE.xml
--- a/src-db/database/model/tables/M_INOUTLINE.xml	Tue Feb 14 11:25:09 2012 +0100
+++ b/src-db/database/model/tables/M_INOUTLINE.xml	Wed Feb 01 12:25:16 2012 +0100
@@ -89,6 +89,10 @@
         <default/>
         <onCreateDefault/>
       </column>
+      <column name="CANCELED_INOUTLINE_ID" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
       <foreign-key foreignTable="M_CONDITION_GOODS" name="M_CONDITION_GOODS">
         <reference local="M_CONDITION_GOODS_ID" foreign="M_CONDITION_GOODS_ID"/>
       </foreign-key>
@@ -104,6 +108,9 @@
       <foreign-key foreignTable="C_UOM" name="M_INOUTLINE_C_UOM">
         <reference local="C_UOM_ID" foreign="C_UOM_ID"/>
       </foreign-key>
+      <foreign-key foreignTable="M_INOUTLINE" name="M_INOUTLINE_CANCELED_INOUTLINE">
+        <reference local="CANCELED_INOUTLINE_ID" foreign="M_INOUTLINE_ID"/>
+      </foreign-key>
       <foreign-key foreignTable="M_ATTRIBUTESETINSTANCE" name="M_INOUTLINE_M_ATTRIBUTESETINST">
         <reference local="M_ATTRIBUTESETINSTANCE_ID" foreign="M_ATTRIBUTESETINSTANCE_ID"/>
       </foreign-key>
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Tue Feb 14 11:25:09 2012 +0100
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Wed Feb 01 12:25:16 2012 +0100
@@ -225150,7 +225150,7 @@
 <!--36C6498DB6D14DF78BD812D0FE70FC06-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
 <!--36C6498DB6D14DF78BD812D0FE70FC06-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--36C6498DB6D14DF78BD812D0FE70FC06-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--36C6498DB6D14DF78BD812D0FE70FC06-->  <POSITION><![CDATA[24]]></POSITION>
+<!--36C6498DB6D14DF78BD812D0FE70FC06-->  <POSITION><![CDATA[22]]></POSITION>
 <!--36C6498DB6D14DF78BD812D0FE70FC06-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
 <!--36C6498DB6D14DF78BD812D0FE70FC06-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
 <!--36C6498DB6D14DF78BD812D0FE70FC06-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
@@ -284438,6 +284438,40 @@
 <!--B7D39D63B1734983ABB6829E13A6F46F-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--B7D39D63B1734983ABB6829E13A6F46F--></AD_COLUMN>
 
+<!--B7E494705B883B25E040007F0100742F--><AD_COLUMN>
+<!--B7E494705B883B25E040007F0100742F-->  <AD_COLUMN_ID><![CDATA[B7E494705B883B25E040007F0100742F]]></AD_COLUMN_ID>
+<!--B7E494705B883B25E040007F0100742F-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--B7E494705B883B25E040007F0100742F-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--B7E494705B883B25E040007F0100742F-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--B7E494705B883B25E040007F0100742F-->  <NAME><![CDATA[Canceled Inout line]]></NAME>
+<!--B7E494705B883B25E040007F0100742F-->  <HELP><![CDATA[Shipment/Receipt line that it is canceled by this line]]></HELP>
+<!--B7E494705B883B25E040007F0100742F-->  <COLUMNNAME><![CDATA[Canceled_Inoutline_ID]]></COLUMNNAME>
+<!--B7E494705B883B25E040007F0100742F-->  <AD_TABLE_ID><![CDATA[320]]></AD_TABLE_ID>
+<!--B7E494705B883B25E040007F0100742F-->  <AD_REFERENCE_ID><![CDATA[18]]></AD_REFERENCE_ID>
+<!--B7E494705B883B25E040007F0100742F-->  <AD_REFERENCE_VALUE_ID><![CDATA[54AC2749F26440F3AEA33378858569E4]]></AD_REFERENCE_VALUE_ID>
+<!--B7E494705B883B25E040007F0100742F-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--B7E494705B883B25E040007F0100742F-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--B7E494705B883B25E040007F0100742F-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--B7E494705B883B25E040007F0100742F-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--B7E494705B883B25E040007F0100742F-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--B7E494705B883B25E040007F0100742F-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--B7E494705B883B25E040007F0100742F-->  <SEQNO><![CDATA[24]]></SEQNO>
+<!--B7E494705B883B25E040007F0100742F-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--B7E494705B883B25E040007F0100742F-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--B7E494705B883B25E040007F0100742F-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--B7E494705B883B25E040007F0100742F-->  <AD_ELEMENT_ID><![CDATA[B7E494705B893B25E040007F0100742F]]></AD_ELEMENT_ID>
+<!--B7E494705B883B25E040007F0100742F-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--B7E494705B883B25E040007F0100742F-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--B7E494705B883B25E040007F0100742F-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--B7E494705B883B25E040007F0100742F-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--B7E494705B883B25E040007F0100742F-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--B7E494705B883B25E040007F0100742F-->  <POSITION><![CDATA[23]]></POSITION>
+<!--B7E494705B883B25E040007F0100742F-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--B7E494705B883B25E040007F0100742F-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--B7E494705B883B25E040007F0100742F-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--B7E494705B883B25E040007F0100742F-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--B7E494705B883B25E040007F0100742F--></AD_COLUMN>
+
 <!--B7ED22A39C674AA0B00C1E8440C0A980--><AD_COLUMN>
 <!--B7ED22A39C674AA0B00C1E8440C0A980-->  <AD_COLUMN_ID><![CDATA[B7ED22A39C674AA0B00C1E8440C0A980]]></AD_COLUMN_ID>
 <!--B7ED22A39C674AA0B00C1E8440C0A980-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_ELEMENT.xml	Tue Feb 14 11:25:09 2012 +0100
+++ b/src-db/database/sourcedata/AD_ELEMENT.xml	Wed Feb 01 12:25:16 2012 +0100
@@ -27972,6 +27972,19 @@
 <!--B4D4121446D847EA91B262AEDA567798-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
 <!--B4D4121446D847EA91B262AEDA567798--></AD_ELEMENT>
 
+<!--B7E494705B893B25E040007F0100742F--><AD_ELEMENT>
+<!--B7E494705B893B25E040007F0100742F-->  <AD_ELEMENT_ID><![CDATA[B7E494705B893B25E040007F0100742F]]></AD_ELEMENT_ID>
+<!--B7E494705B893B25E040007F0100742F-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--B7E494705B893B25E040007F0100742F-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--B7E494705B893B25E040007F0100742F-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--B7E494705B893B25E040007F0100742F-->  <COLUMNNAME><![CDATA[Canceled_Inoutline_ID]]></COLUMNNAME>
+<!--B7E494705B893B25E040007F0100742F-->  <NAME><![CDATA[Canceled Inout line]]></NAME>
+<!--B7E494705B893B25E040007F0100742F-->  <PRINTNAME><![CDATA[Canceled Inout line]]></PRINTNAME>
+<!--B7E494705B893B25E040007F0100742F-->  <HELP><![CDATA[Shipment/Receipt line that it is canceled by this line]]></HELP>
+<!--B7E494705B893B25E040007F0100742F-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--B7E494705B893B25E040007F0100742F-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
+<!--B7E494705B893B25E040007F0100742F--></AD_ELEMENT>
+
 <!--B7E8DC4F085C46F3842E1AF96300D78B--><AD_ELEMENT>
 <!--B7E8DC4F085C46F3842E1AF96300D78B-->  <AD_ELEMENT_ID><![CDATA[B7E8DC4F085C46F3842E1AF96300D78B]]></AD_ELEMENT_ID>
 <!--B7E8DC4F085C46F3842E1AF96300D78B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_REFERENCE.xml	Tue Feb 14 11:25:09 2012 +0100
+++ b/src-db/database/sourcedata/AD_REFERENCE.xml	Wed Feb 01 12:25:16 2012 +0100
@@ -4438,6 +4438,18 @@
 <!--4EFC9773F30B4ACE97D225BD13CFF8CB-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
 <!--4EFC9773F30B4ACE97D225BD13CFF8CB--></AD_REFERENCE>
 
+<!--54AC2749F26440F3AEA33378858569E4--><AD_REFERENCE>
+<!--54AC2749F26440F3AEA33378858569E4-->  <AD_REFERENCE_ID><![CDATA[54AC2749F26440F3AEA33378858569E4]]></AD_REFERENCE_ID>
+<!--54AC2749F26440F3AEA33378858569E4-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--54AC2749F26440F3AEA33378858569E4-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--54AC2749F26440F3AEA33378858569E4-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--54AC2749F26440F3AEA33378858569E4-->  <NAME><![CDATA[M_InoutLine]]></NAME>
+<!--54AC2749F26440F3AEA33378858569E4-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--54AC2749F26440F3AEA33378858569E4-->  <ISBASEREFERENCE><![CDATA[N]]></ISBASEREFERENCE>
+<!--54AC2749F26440F3AEA33378858569E4-->  <PARENTREFERENCE_ID><![CDATA[18]]></PARENTREFERENCE_ID>
+<!--54AC2749F26440F3AEA33378858569E4-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
+<!--54AC2749F26440F3AEA33378858569E4--></AD_REFERENCE>
+
 <!--556C6580590E4D53AEE10AD0CC2EFC77--><AD_REFERENCE>
 <!--556C6580590E4D53AEE10AD0CC2EFC77-->  <AD_REFERENCE_ID><![CDATA[556C6580590E4D53AEE10AD0CC2EFC77]]></AD_REFERENCE_ID>
 <!--556C6580590E4D53AEE10AD0CC2EFC77-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_REF_TABLE.xml	Tue Feb 14 11:25:09 2012 +0100
+++ b/src-db/database/sourcedata/AD_REF_TABLE.xml	Wed Feb 01 12:25:16 2012 +0100
@@ -1120,6 +1120,17 @@
 <!--22F546D49D3A48E1B2B4F50446A8DE58-->  <ORDERBYCLAUSE><![CDATA[C_DocType.isdefault DESC, C_DocType.Name]]></ORDERBYCLAUSE>
 <!--22F546D49D3A48E1B2B4F50446A8DE58--></AD_REF_TABLE>
 
+<!--54AC2749F26440F3AEA33378858569E4--><AD_REF_TABLE>
+<!--54AC2749F26440F3AEA33378858569E4-->  <AD_REFERENCE_ID><![CDATA[54AC2749F26440F3AEA33378858569E4]]></AD_REFERENCE_ID>
+<!--54AC2749F26440F3AEA33378858569E4-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--54AC2749F26440F3AEA33378858569E4-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--54AC2749F26440F3AEA33378858569E4-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--54AC2749F26440F3AEA33378858569E4-->  <AD_TABLE_ID><![CDATA[320]]></AD_TABLE_ID>
+<!--54AC2749F26440F3AEA33378858569E4-->  <AD_KEY><![CDATA[3529]]></AD_KEY>
+<!--54AC2749F26440F3AEA33378858569E4-->  <AD_DISPLAY><![CDATA[3539]]></AD_DISPLAY>
+<!--54AC2749F26440F3AEA33378858569E4-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
+<!--54AC2749F26440F3AEA33378858569E4--></AD_REF_TABLE>
+
 <!--595E4FB3F743477BA5A670452556C3DF--><AD_REF_TABLE>
 <!--595E4FB3F743477BA5A670452556C3DF-->  <AD_REFERENCE_ID><![CDATA[595E4FB3F743477BA5A670452556C3DF]]></AD_REFERENCE_ID>
 <!--595E4FB3F743477BA5A670452556C3DF-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>