details: https://code.openbravo.com/erp/devel/pi/rev/6f6f0534dd25 changeset: 15467:6f6f0534dd25 user: Gorka Ion Damián <gorkaion.damian <at> openbravo.com> date: Wed Feb 01 12:25:16 2012 +0100 summary: Related to issue 19755.Added new canceled_inoutline_id column to relate voided inouts.
details: https://code.openbravo.com/erp/devel/pi/rev/f663c413f0b0 changeset: 15468:f663c413f0b0 user: Gorka Ion Damián <gorkaion.damian <at> openbravo.com> date: Wed Feb 01 12:25:42 2012 +0100 summary: Related to issue 19755.Relate canceled inoutlines with originals. diffstat: src-db/database/model/functions/M_INOUT_POST.xml | 6 ++- src-db/database/model/tables/M_INOUTLINE.xml | 7 ++++ src-db/database/sourcedata/AD_COLUMN.xml | 36 +++++++++++++++++++++++- src-db/database/sourcedata/AD_ELEMENT.xml | 13 ++++++++ src-db/database/sourcedata/AD_REFERENCE.xml | 12 ++++++++ src-db/database/sourcedata/AD_REF_TABLE.xml | 11 +++++++ 6 files changed, 82 insertions(+), 3 deletions(-) diffs (166 lines): diff -r 34aaf22a4ca0 -r f663c413f0b0 src-db/database/model/functions/M_INOUT_POST.xml --- a/src-db/database/model/functions/M_INOUT_POST.xml Tue Feb 14 11:25:09 2012 +0100 +++ b/src-db/database/model/functions/M_INOUT_POST.xml Wed Feb 01 12:25:42 2012 +0100 @@ -661,7 +661,8 @@ CreatedBy, Updated, UpdatedBy, M_Product_ID, M_AttributeSetInstance_ID, C_UOM_ID, M_Locator_ID, MovementQty, Description, IsInvoiced, --MODIFIED BY F.IRIAZABAL - QuantityOrder, M_Product_UOM_ID, IsDescription + QuantityOrder, M_Product_UOM_ID, IsDescription, + canceled_inoutline_id ) VALUES ( @@ -670,7 +671,8 @@ v_User, now(), v_User, Cur_InOutLine.M_Product_ID, Cur_InOutLine.M_AttributeSetInstance_ID, Cur_InOutLine.C_UOM_ID, Cur_InOutLine.M_Locator_ID, Cur_InOutLine.MovementQty * -1, '*R*: ' || COALESCE(TO_CHAR(Cur_InOutLine.Description), ''), Cur_InOutLine.IsInvoiced, --MODIFIED BY F.IRIAZABAL - Cur_InOutLine.QuantityOrder * -1, Cur_InOutLine.M_PRODUCT_UOM_ID, Cur_InOutLine.IsDescription + Cur_InOutLine.QuantityOrder * -1, Cur_InOutLine.M_PRODUCT_UOM_ID, Cur_InOutLine.IsDescription, + Cur_InOutLine.M_InOutLine_ID ) ; INSERT INTO M_MATCHINV diff -r 34aaf22a4ca0 -r f663c413f0b0 src-db/database/model/tables/M_INOUTLINE.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:42 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> diff -r 34aaf22a4ca0 -r f663c413f0b0 src-db/database/sourcedata/AD_COLUMN.xml --- 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:42 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> diff -r 34aaf22a4ca0 -r f663c413f0b0 src-db/database/sourcedata/AD_ELEMENT.xml --- 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:42 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> diff -r 34aaf22a4ca0 -r f663c413f0b0 src-db/database/sourcedata/AD_REFERENCE.xml --- 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:42 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> diff -r 34aaf22a4ca0 -r f663c413f0b0 src-db/database/sourcedata/AD_REF_TABLE.xml --- 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:42 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> ------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
