details: https://code.openbravo.com/erp/devel/pi/rev/adf768df23c5 changeset: 14890:adf768df23c5 user: Unai Martirena <unai.martirena <at> openbravo.com> date: Wed Dec 14 15:31:29 2011 +0100 summary: Fixed Issue:0019154 concatenation too long for v_DocumentNo in c_order_post1
details: https://code.openbravo.com/erp/devel/pi/rev/3994e2e3043a changeset: 14891:3994e2e3043a user: Unai Martirena <unai.martirena <at> openbravo.com> date: Thu Dec 15 10:59:10 2011 +0100 summary: Fixes Issue:0018798 Column posted is missing in S_ExpenseTime table diffstat: src-db/database/model/functions/C_ORDER_POST1.xml | 7 +++- src-db/database/model/tables/S_TIMEEXPENSE.xml | 4 ++ src-db/database/sourcedata/AD_COLUMN.xml | 36 +++++++++++++++++++++++ 3 files changed, 46 insertions(+), 1 deletions(-) diffs (77 lines): diff -r 135bc8ba3ad0 -r 3994e2e3043a src-db/database/model/functions/C_ORDER_POST1.xml --- a/src-db/database/model/functions/C_ORDER_POST1.xml Sun Dec 18 20:58:28 2011 +0100 +++ b/src-db/database/model/functions/C_ORDER_POST1.xml Thu Dec 15 10:59:10 2011 +0100 @@ -1266,7 +1266,12 @@ */ UPDATE C_DEBT_PAYMENT SET IsValid='Y' WHERE C_Order_ID=v_Record_ID; SELECT C_ORDER.PAYMENTRULE, - C_ORDER.DOCUMENTNO||' - '||C_BPARTNER.NAME||' - '||C_ORDER.GRANDTOTAL, + (CASE + WHEN (length(C_ORDER.DOCUMENTNO||' - '||C_BPARTNER.NAME||' - '||C_ORDER.GRANDTOTAL) > 200) + THEN substr(C_ORDER.DOCUMENTNO||' - '||C_BPARTNER.NAME||' - '||C_ORDER.GRANDTOTAL,1,197)||'...' + ELSE + C_ORDER.DOCUMENTNO||' - '||C_BPARTNER.NAME||' - '||C_ORDER.GRANDTOTAL + END) AS CONCATENATION, C_ORDER.GRANDTOTAL, C_ORDER.M_WAREHOUSE_ID INTO v_PaymentRule, diff -r 135bc8ba3ad0 -r 3994e2e3043a src-db/database/model/tables/S_TIMEEXPENSE.xml --- a/src-db/database/model/tables/S_TIMEEXPENSE.xml Sun Dec 18 20:58:28 2011 +0100 +++ b/src-db/database/model/tables/S_TIMEEXPENSE.xml Thu Dec 15 10:59:10 2011 +0100 @@ -65,6 +65,10 @@ <default/> <onCreateDefault/> </column> + <column name="POSTED" primaryKey="false" required="true" type="VARCHAR" size="60" autoIncrement="false"> + <default><![CDATA[N]]></default> + <onCreateDefault><![CDATA['N']]></onCreateDefault> + </column> <foreign-key foreignTable="AD_CLIENT" name="S_TIMEEXPENSE_AD_CLIENT"> <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/> </foreign-key> diff -r 135bc8ba3ad0 -r 3994e2e3043a src-db/database/sourcedata/AD_COLUMN.xml --- a/src-db/database/sourcedata/AD_COLUMN.xml Sun Dec 18 20:58:28 2011 +0100 +++ b/src-db/database/sourcedata/AD_COLUMN.xml Thu Dec 15 10:59:10 2011 +0100 @@ -272726,6 +272726,42 @@ <!--D7915EA89A2941A39C8D2570B0F56FC4--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> <!--D7915EA89A2941A39C8D2570B0F56FC4--></AD_COLUMN> +<!--D831E6C12F934F4AB7B792CCD50D0745--><AD_COLUMN> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <AD_COLUMN_ID><![CDATA[D831E6C12F934F4AB7B792CCD50D0745]]></AD_COLUMN_ID> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <NAME><![CDATA[Posted]]></NAME> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <DESCRIPTION><![CDATA[An accounting status button that indicates if the transaction has already been posted to the general ledger or not.]]></DESCRIPTION> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <HELP><![CDATA[An accounting status button that indicates if the transaction has already been posted to the general ledger or not. When doing the accounting manually this button can be used to post or unpost the transaction from the general ledger by hand.]]></HELP> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <COLUMNNAME><![CDATA[Posted]]></COLUMNNAME> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <AD_TABLE_ID><![CDATA[486]]></AD_TABLE_ID> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <AD_REFERENCE_ID><![CDATA[28]]></AD_REFERENCE_ID> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <AD_REFERENCE_VALUE_ID><![CDATA[234]]></AD_REFERENCE_VALUE_ID> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <FIELDLENGTH><![CDATA[60]]></FIELDLENGTH> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <DEFAULTVALUE><![CDATA[N]]></DEFAULTVALUE> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <ISKEY><![CDATA[N]]></ISKEY> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <SEQNO><![CDATA[33]]></SEQNO> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <AD_ELEMENT_ID><![CDATA[1308]]></AD_ELEMENT_ID> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <POSITION><![CDATA[17]]></POSITION> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--D831E6C12F934F4AB7B792CCD50D0745--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> +<!--D831E6C12F934F4AB7B792CCD50D0745--></AD_COLUMN> + <!--D8C00B0F9EC14D17AEE6EB72D9E871E1--><AD_COLUMN> <!--D8C00B0F9EC14D17AEE6EB72D9E871E1--> <AD_COLUMN_ID><![CDATA[D8C00B0F9EC14D17AEE6EB72D9E871E1]]></AD_COLUMN_ID> <!--D8C00B0F9EC14D17AEE6EB72D9E871E1--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> ------------------------------------------------------------------------------ Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
