details: https://code.openbravo.com/erp/devel/pi/rev/49418524d9af changeset: 28047:49418524d9af user: Mark <markmm82 <at> gmail.com> date: Tue Nov 24 18:38:19 2015 +0000 summary: Fixes issue 31551: Removed the a.createdby and a.updatedby fields from the Cur_Defaults query in the m_product_trg trigger.
details: https://code.openbravo.com/erp/devel/pi/rev/dd544299a728 changeset: 28048:dd544299a728 user: Mark <markmm82 <at> gmail.com> date: Wed Nov 25 10:54:55 2015 +0000 summary: Issue 31352: Change for the updatable flag to N Change for the updatable flag to N for the AD_Org_ID column of the M_Requisition table. diffstat: src-db/database/model/triggers/M_PRODUCT_TRG.xml | 2 +- src-db/database/sourcedata/AD_COLUMN.xml | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diffs (24 lines): diff -r 84be0e682396 -r dd544299a728 src-db/database/model/triggers/M_PRODUCT_TRG.xml --- a/src-db/database/model/triggers/M_PRODUCT_TRG.xml Wed Nov 25 16:09:11 2015 +0100 +++ b/src-db/database/model/triggers/M_PRODUCT_TRG.xml Wed Nov 25 10:54:55 2015 +0000 @@ -193,7 +193,7 @@ SELECT distinct AD_IsOrgIncluded(:new.AD_ORG_ID, a.AD_Org_ID, :new.AD_Client_ID), a.ad_sequence_pr_id,a.isprnewaccount,a.acct_length,a.subacct_length, d.ad_client_id, d.p_revenue_acct, d.p_def_revenue_acct, d.p_expense_acct, d.p_def_expense_acct, d.p_asset_acct, d.p_cogs_acct, d.P_PurchasePriceVariance_Acct, d.P_InvoicePriceVariance_Acct, - d.P_TradeDiscountRec_Acct, d.P_TradeDiscountGrant_Acct, d.P_COGS_Return_Acct, d.P_Revenue_Return_Acct, a.createdby, a.updatedby, a.C_AcctSchema_ID, d.ISACTIVE + d.P_TradeDiscountRec_Acct, d.P_TradeDiscountGrant_Acct, d.P_COGS_Return_Acct, d.P_Revenue_Return_Acct, a.C_AcctSchema_ID, d.ISACTIVE FROM M_Product_Category_Acct d, ad_Org_AcctSchema a WHERE d.M_Product_Category_ID=:new.M_Product_Category_ID AND d.C_AcctSchema_ID = a.C_AcctSchema_ID diff -r 84be0e682396 -r dd544299a728 src-db/database/sourcedata/AD_COLUMN.xml --- a/src-db/database/sourcedata/AD_COLUMN.xml Wed Nov 25 16:09:11 2015 +0100 +++ b/src-db/database/sourcedata/AD_COLUMN.xml Wed Nov 25 10:54:55 2015 +0000 @@ -197355,7 +197355,7 @@ <!--803531--> <ISKEY><![CDATA[N]]></ISKEY> <!--803531--> <ISPARENT><![CDATA[N]]></ISPARENT> <!--803531--> <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> -<!--803531--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--803531--> <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE> <!--803531--> <READONLYLOGIC><![CDATA[@DocStatus@='CO'|@DocStatus@='CL']]></READONLYLOGIC> <!--803531--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> <!--803531--> <SEQNO><![CDATA[30]]></SEQNO> ------------------------------------------------------------------------------ Go from Idea to Many App Stores Faster with Intel(R) XDK Give your users amazing mobile app experiences with Intel(R) XDK. Use one codebase in this all-in-one HTML5 development environment. Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs. http://pubads.g.doubleclick.net/gampad/clk?id=254741551&iu=/4140 _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits