Related to issue
19755.Added new canceled_inoutline_id column to relate voided inouts.
--- 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>