details: http://code.openbravo.com/erp/devel/pi/rev/b64bc48ad35b
changeset: 3268:b64bc48ad35b
user: Eduardo Argal Guibert <eduardo.ar...@openbravo.com>
date: Mon Mar 02 10:39:24 2009 +0100
description:
Fixes bug 0007837: In defaults accounts of schema, combo 'status' should be
removed
diffs (125 lines):
diff -r a035ff1a077e -r b64bc48ad35b
src-db/database/model/functions/C_ACCTSCHEMA_DEFAULT_COPY.xml
--- a/src-db/database/model/functions/C_ACCTSCHEMA_DEFAULT_COPY.xml Fri Feb
27 17:33:20 2009 +0100
+++ b/src-db/database/model/functions/C_ACCTSCHEMA_DEFAULT_COPY.xml Mon Mar
02 10:39:24 2009 +0100
@@ -171,8 +171,7 @@
NotInvoicedRevenue_Acct=Cur_Acct.NotInvoicedRevenue_Acct,
NotInvoicedReceivables_Acct=Cur_Acct.NotInvoicedReceivables_Acct,
Updated=now(),
- UpdatedBy='0',
- Status=Cur_Acct.Status
+ UpdatedBy='0'
WHERE C_BP_Group_Acct.C_AcctSchema_ID=Cur_Acct.C_AcctSchema_ID
AND EXISTS
(SELECT *
@@ -192,7 +191,7 @@
V_Liability_Services_Acct, V_PrePayment_Acct, PayDiscount_Exp_Acct,
PayDiscount_Rev_Acct,
WriteOff_Acct, UnRealizedGain_Acct, UnRealizedLoss_Acct,
RealizedGain_Acct,
RealizedLoss_Acct, NotInvoicedReceipts_Acct, UnEarnedRevenue_Acct,
NotInvoicedRevenue_Acct,
- NotInvoicedReceivables_Acct, Status
+ NotInvoicedReceivables_Acct
)
SELECT get_uuid(), x.C_BP_Group_ID,
Cur_Acct.C_AcctSchema_ID, x.AD_Client_ID, x.AD_Org_ID, 'Y',
@@ -200,8 +199,7 @@
Cur_Acct.C_Receivable_Acct, Cur_Acct.C_PrePayment_Acct,
Cur_Acct.V_Liability_Acct, Cur_Acct.V_Liability_Services_Acct,
Cur_Acct.V_PrePayment_Acct, Cur_Acct.PayDiscount_Exp_Acct,
Cur_Acct.PayDiscount_Rev_Acct, Cur_Acct.WriteOff_Acct,
Cur_Acct.UnRealizedGain_Acct, Cur_Acct.UnRealizedLoss_Acct,
Cur_Acct.RealizedGain_Acct, Cur_Acct.RealizedLoss_Acct,
- Cur_Acct.NotInvoicedReceipts_Acct, Cur_Acct.UnEarnedRevenue_Acct,
Cur_Acct.NotInvoicedRevenue_Acct, Cur_Acct.NotInvoicedReceivables_Acct,
- Cur_Acct.Status
+ Cur_Acct.NotInvoicedReceipts_Acct, Cur_Acct.UnEarnedRevenue_Acct,
Cur_Acct.NotInvoicedRevenue_Acct, Cur_Acct.NotInvoicedReceivables_Acct
FROM C_BP_Group x
WHERE AD_Client_ID=Cur_Acct.AD_Client_ID
AND NOT EXISTS
diff -r a035ff1a077e -r b64bc48ad35b src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml Fri Feb 27 17:33:20 2009 +0100
+++ b/src-db/database/sourcedata/AD_COLUMN.xml Mon Mar 02 10:39:24 2009 +0100
@@ -209603,38 +209603,6 @@
<!--802962--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
<!--802962--></AD_COLUMN>
-<!--802963--><AD_COLUMN>
-<!--802963--> <AD_COLUMN_ID><![CDATA[802963]]></AD_COLUMN_ID>
-<!--802963--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--802963--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--802963--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--802963--> <NAME><![CDATA[Status]]></NAME>
-<!--802963--> <DESCRIPTION><![CDATA[A defined state or position of a
payment.]]></DESCRIPTION>
-<!--802963--> <HELP><![CDATA[Status for the debt payment]]></HELP>
-<!--802963--> <COLUMNNAME><![CDATA[Status]]></COLUMNNAME>
-<!--802963--> <AD_TABLE_ID><![CDATA[315]]></AD_TABLE_ID>
-<!--802963--> <AD_REFERENCE_ID><![CDATA[17]]></AD_REFERENCE_ID>
-<!--802963-->
<AD_REFERENCE_VALUE_ID><![CDATA[800070]]></AD_REFERENCE_VALUE_ID>
-<!--802963--> <FIELDLENGTH><![CDATA[60]]></FIELDLENGTH>
-<!--802963--> <ISKEY><![CDATA[N]]></ISKEY>
-<!--802963--> <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--802963--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
-<!--802963--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
-<!--802963--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
-<!--802963--> <SEQNO><![CDATA[11]]></SEQNO>
-<!--802963--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
-<!--802963--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--802963--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
-<!--802963--> <AD_ELEMENT_ID><![CDATA[800630]]></AD_ELEMENT_ID>
-<!--802963--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
-<!--802963--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
-<!--802963--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
-<!--802963--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
-<!--802963--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--802963--> <POSITION><![CDATA[72]]></POSITION>
-<!--802963--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
-<!--802963--></AD_COLUMN>
-
<!--802964--><AD_COLUMN>
<!--802964--> <AD_COLUMN_ID><![CDATA[802964]]></AD_COLUMN_ID>
<!--802964--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff -r a035ff1a077e -r b64bc48ad35b src-db/database/sourcedata/AD_FIELD.xml
--- a/src-db/database/sourcedata/AD_FIELD.xml Fri Feb 27 17:33:20 2009 +0100
+++ b/src-db/database/sourcedata/AD_FIELD.xml Mon Mar 02 10:39:24 2009 +0100
@@ -22765,7 +22765,7 @@
<!--2145--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
<!--2145--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
<!--2145--> <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
-<!--2145--> <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--2145--> <ISFIRSTFOCUSEDFIELD><![CDATA[Y]]></ISFIRSTFOCUSEDFIELD>
<!--2145--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--2145--></AD_FIELD>
@@ -22933,7 +22933,7 @@
<!--2156--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
<!--2156--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
<!--2156--> <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
-<!--2156--> <ISFIRSTFOCUSEDFIELD><![CDATA[Y]]></ISFIRSTFOCUSEDFIELD>
+<!--2156--> <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
<!--2156--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--2156--></AD_FIELD>
@@ -155819,29 +155819,6 @@
<!--803271--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--803271--></AD_FIELD>
-<!--803272--><AD_FIELD>
-<!--803272--> <AD_FIELD_ID><![CDATA[803272]]></AD_FIELD_ID>
-<!--803272--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--803272--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--803272--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--803272--> <NAME><![CDATA[Status]]></NAME>
-<!--803272--> <DESCRIPTION><![CDATA[A defined state or position of a
payment.]]></DESCRIPTION>
-<!--803272--> <HELP><![CDATA[Status for the debt payment]]></HELP>
-<!--803272--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
-<!--803272--> <AD_TAB_ID><![CDATA[252]]></AD_TAB_ID>
-<!--803272--> <AD_COLUMN_ID><![CDATA[802963]]></AD_COLUMN_ID>
-<!--803272--> <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
-<!--803272--> <DISPLAYLENGTH><![CDATA[21]]></DISPLAYLENGTH>
-<!--803272--> <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--803272--> <SEQNO><![CDATA[640]]></SEQNO>
-<!--803272--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
-<!--803272--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
-<!--803272--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--803272--> <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
-<!--803272--> <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
-<!--803272--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--803272--></AD_FIELD>
-
<!--803273--><AD_FIELD>
<!--803273--> <AD_FIELD_ID><![CDATA[803273]]></AD_FIELD_ID>
<!--803273--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
