details: /erp/devel/pi/rev/9c3c9baf0ec8
changeset: 8583:9c3c9baf0ec8
user: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
date: Thu Oct 21 12:45:10 2010 +0200
summary: Fixes bug 0014840: Statement end balance not being imported
diffstat:
src-db/database/model/tables/FIN_FINANCIAL_ACCOUNT.xml | 4 +
src-db/database/sourcedata/AD_COLUMN.xml | 42 ++++++++++++++++-
src-db/database/sourcedata/AD_ELEMENT.xml | 13 +++++
src-db/database/sourcedata/AD_FIELD.xml | 25 ++++++++++-
4 files changed, 79 insertions(+), 5 deletions(-)
diffs (159 lines):
diff -r 14967eced10c -r 9c3c9baf0ec8
src-db/database/model/tables/FIN_FINANCIAL_ACCOUNT.xml
--- a/src-db/database/model/tables/FIN_FINANCIAL_ACCOUNT.xml Thu Oct 21
14:29:55 2010 +0530
+++ b/src-db/database/model/tables/FIN_FINANCIAL_ACCOUNT.xml Thu Oct 21
12:45:10 2010 +0200
@@ -97,6 +97,10 @@
<default><![CDATA[0]]></default>
<onCreateDefault/>
</column>
+ <column name="INITIALBALANCE" primaryKey="false" required="true"
type="DECIMAL" autoIncrement="false">
+ <default><![CDATA[0]]></default>
+ <onCreateDefault/>
+ </column>
<column name="CREDITLIMIT" primaryKey="false" required="true"
type="DECIMAL" autoIncrement="false">
<default><![CDATA[0]]></default>
<onCreateDefault/>
diff -r 14967eced10c -r 9c3c9baf0ec8 src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml Thu Oct 21 14:29:55 2010 +0530
+++ b/src-db/database/sourcedata/AD_COLUMN.xml Thu Oct 21 12:45:10 2010 +0200
@@ -266984,6 +266984,40 @@
<!--4F6FBAF242EE43B98923BAC82AB94165-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
<!--4F6FBAF242EE43B98923BAC82AB94165--></AD_COLUMN>
+<!--515A9DFD91C243D3BECAA9D0149063C4--><AD_COLUMN>
+<!--515A9DFD91C243D3BECAA9D0149063C4-->
<AD_COLUMN_ID><![CDATA[515A9DFD91C243D3BECAA9D0149063C4]]></AD_COLUMN_ID>
+<!--515A9DFD91C243D3BECAA9D0149063C4-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--515A9DFD91C243D3BECAA9D0149063C4--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--515A9DFD91C243D3BECAA9D0149063C4--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--515A9DFD91C243D3BECAA9D0149063C4-->
<NAME><![CDATA[InitialBalance]]></NAME>
+<!--515A9DFD91C243D3BECAA9D0149063C4--> <DESCRIPTION><![CDATA[Initial balance
of the financial account. Amount of the account at the time of registering the
financial account.]]></DESCRIPTION>
+<!--515A9DFD91C243D3BECAA9D0149063C4--> <HELP><![CDATA[Amount of the account
at the time of registering the financial account. This amount is used to
initialize financial account and will be used as last reconciliation amount for
first reconciliation in OB for the given financial account.]]></HELP>
+<!--515A9DFD91C243D3BECAA9D0149063C4-->
<COLUMNNAME><![CDATA[InitialBalance]]></COLUMNNAME>
+<!--515A9DFD91C243D3BECAA9D0149063C4-->
<AD_TABLE_ID><![CDATA[B129E53BC0E747879F7BA17F0AECEC32]]></AD_TABLE_ID>
+<!--515A9DFD91C243D3BECAA9D0149063C4-->
<AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID>
+<!--515A9DFD91C243D3BECAA9D0149063C4-->
<FIELDLENGTH><![CDATA[12]]></FIELDLENGTH>
+<!--515A9DFD91C243D3BECAA9D0149063C4-->
<DEFAULTVALUE><![CDATA[0]]></DEFAULTVALUE>
+<!--515A9DFD91C243D3BECAA9D0149063C4--> <ISKEY><![CDATA[N]]></ISKEY>
+<!--515A9DFD91C243D3BECAA9D0149063C4--> <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--515A9DFD91C243D3BECAA9D0149063C4-->
<ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--515A9DFD91C243D3BECAA9D0149063C4-->
<ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
+<!--515A9DFD91C243D3BECAA9D0149063C4-->
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--515A9DFD91C243D3BECAA9D0149063C4--> <SEQNO><![CDATA[290]]></SEQNO>
+<!--515A9DFD91C243D3BECAA9D0149063C4-->
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--515A9DFD91C243D3BECAA9D0149063C4-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--515A9DFD91C243D3BECAA9D0149063C4-->
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--515A9DFD91C243D3BECAA9D0149063C4-->
<AD_ELEMENT_ID><![CDATA[50574D2DA84B4F3E9ED8272F414D3B1A]]></AD_ELEMENT_ID>
+<!--515A9DFD91C243D3BECAA9D0149063C4-->
<ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--515A9DFD91C243D3BECAA9D0149063C4-->
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--515A9DFD91C243D3BECAA9D0149063C4-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--515A9DFD91C243D3BECAA9D0149063C4-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--515A9DFD91C243D3BECAA9D0149063C4-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--515A9DFD91C243D3BECAA9D0149063C4--> <POSITION><![CDATA[25]]></POSITION>
+<!--515A9DFD91C243D3BECAA9D0149063C4-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--515A9DFD91C243D3BECAA9D0149063C4--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--515A9DFD91C243D3BECAA9D0149063C4-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--515A9DFD91C243D3BECAA9D0149063C4--></AD_COLUMN>
+
<!--521EA21E6E7577ABE040007F010016C0--><AD_COLUMN>
<!--521EA21E6E7577ABE040007F010016C0-->
<AD_COLUMN_ID><![CDATA[521EA21E6E7577ABE040007F010016C0]]></AD_COLUMN_ID>
<!--521EA21E6E7577ABE040007F010016C0-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -301541,7 +301575,7 @@
<!--828EE0AE80535FA1E040007F010067C7-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
<!--828EE0AE80535FA1E040007F010067C7-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
<!--828EE0AE80535FA1E040007F010067C7-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--828EE0AE80535FA1E040007F010067C7--> <POSITION><![CDATA[25]]></POSITION>
+<!--828EE0AE80535FA1E040007F010067C7--> <POSITION><![CDATA[26]]></POSITION>
<!--828EE0AE80535FA1E040007F010067C7-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
<!--828EE0AE80535FA1E040007F010067C7--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
<!--828EE0AE80535FA1E040007F010067C7-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
@@ -301574,7 +301608,7 @@
<!--828EE0AE80545FA1E040007F010067C7-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
<!--828EE0AE80545FA1E040007F010067C7-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
<!--828EE0AE80545FA1E040007F010067C7-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--828EE0AE80545FA1E040007F010067C7--> <POSITION><![CDATA[26]]></POSITION>
+<!--828EE0AE80545FA1E040007F010067C7--> <POSITION><![CDATA[27]]></POSITION>
<!--828EE0AE80545FA1E040007F010067C7-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
<!--828EE0AE80545FA1E040007F010067C7--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
<!--828EE0AE80545FA1E040007F010067C7-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
@@ -301608,7 +301642,7 @@
<!--828EE0AE80555FA1E040007F010067C7-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
<!--828EE0AE80555FA1E040007F010067C7-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
<!--828EE0AE80555FA1E040007F010067C7-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--828EE0AE80555FA1E040007F010067C7--> <POSITION><![CDATA[27]]></POSITION>
+<!--828EE0AE80555FA1E040007F010067C7--> <POSITION><![CDATA[28]]></POSITION>
<!--828EE0AE80555FA1E040007F010067C7-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
<!--828EE0AE80555FA1E040007F010067C7--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
<!--828EE0AE80555FA1E040007F010067C7-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
@@ -308831,7 +308865,7 @@
<!--D160BFBF2CD74DAEB9FF7C425874E282-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
<!--D160BFBF2CD74DAEB9FF7C425874E282-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
<!--D160BFBF2CD74DAEB9FF7C425874E282-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--D160BFBF2CD74DAEB9FF7C425874E282--> <POSITION><![CDATA[28]]></POSITION>
+<!--D160BFBF2CD74DAEB9FF7C425874E282--> <POSITION><![CDATA[29]]></POSITION>
<!--D160BFBF2CD74DAEB9FF7C425874E282-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
<!--D160BFBF2CD74DAEB9FF7C425874E282--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
<!--D160BFBF2CD74DAEB9FF7C425874E282-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
diff -r 14967eced10c -r 9c3c9baf0ec8 src-db/database/sourcedata/AD_ELEMENT.xml
--- a/src-db/database/sourcedata/AD_ELEMENT.xml Thu Oct 21 14:29:55 2010 +0530
+++ b/src-db/database/sourcedata/AD_ELEMENT.xml Thu Oct 21 12:45:10 2010 +0200
@@ -22314,6 +22314,19 @@
<!--4AFD554ABDCB488B87F326A3101B50DE-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--4AFD554ABDCB488B87F326A3101B50DE--></AD_ELEMENT>
+<!--50574D2DA84B4F3E9ED8272F414D3B1A--><AD_ELEMENT>
+<!--50574D2DA84B4F3E9ED8272F414D3B1A-->
<AD_ELEMENT_ID><![CDATA[50574D2DA84B4F3E9ED8272F414D3B1A]]></AD_ELEMENT_ID>
+<!--50574D2DA84B4F3E9ED8272F414D3B1A-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--50574D2DA84B4F3E9ED8272F414D3B1A--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--50574D2DA84B4F3E9ED8272F414D3B1A--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--50574D2DA84B4F3E9ED8272F414D3B1A-->
<COLUMNNAME><![CDATA[InitialBalance]]></COLUMNNAME>
+<!--50574D2DA84B4F3E9ED8272F414D3B1A--> <NAME><![CDATA[Initial
Balance]]></NAME>
+<!--50574D2DA84B4F3E9ED8272F414D3B1A--> <PRINTNAME><![CDATA[Initial
Balance]]></PRINTNAME>
+<!--50574D2DA84B4F3E9ED8272F414D3B1A--> <DESCRIPTION><![CDATA[Initial balance
of the financial account. Amount of the account at the time of registering the
financial account.]]></DESCRIPTION>
+<!--50574D2DA84B4F3E9ED8272F414D3B1A--> <HELP><![CDATA[Amount of the account
at the time of registering the financial account. This amount is used to
initialize financial account and will be used as last reconciliation amount for
first reconciliation in OB for the given financial account.]]></HELP>
+<!--50574D2DA84B4F3E9ED8272F414D3B1A-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--50574D2DA84B4F3E9ED8272F414D3B1A--></AD_ELEMENT>
+
<!--521EA21E6E7777ABE040007F010016C0--><AD_ELEMENT>
<!--521EA21E6E7777ABE040007F010016C0-->
<AD_ELEMENT_ID><![CDATA[521EA21E6E7777ABE040007F010016C0]]></AD_ELEMENT_ID>
<!--521EA21E6E7777ABE040007F010016C0-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff -r 14967eced10c -r 9c3c9baf0ec8 src-db/database/sourcedata/AD_FIELD.xml
--- a/src-db/database/sourcedata/AD_FIELD.xml Thu Oct 21 14:29:55 2010 +0530
+++ b/src-db/database/sourcedata/AD_FIELD.xml Thu Oct 21 12:45:10 2010 +0200
@@ -204257,6 +204257,29 @@
<!--D784EC5346E94D6DA1C349CF289DED36-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--D784EC5346E94D6DA1C349CF289DED36--></AD_FIELD>
+<!--D90513BC049C4CD5A0589E641DAFC4A0--><AD_FIELD>
+<!--D90513BC049C4CD5A0589E641DAFC4A0-->
<AD_FIELD_ID><![CDATA[D90513BC049C4CD5A0589E641DAFC4A0]]></AD_FIELD_ID>
+<!--D90513BC049C4CD5A0589E641DAFC4A0-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--D90513BC049C4CD5A0589E641DAFC4A0--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--D90513BC049C4CD5A0589E641DAFC4A0--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--D90513BC049C4CD5A0589E641DAFC4A0--> <NAME><![CDATA[Initial
Balance]]></NAME>
+<!--D90513BC049C4CD5A0589E641DAFC4A0--> <DESCRIPTION><![CDATA[Initial balance
of the financial account. Amount of the account at the time of registering the
financial account.]]></DESCRIPTION>
+<!--D90513BC049C4CD5A0589E641DAFC4A0--> <HELP><![CDATA[Amount of the account
at the time of registering the financial account. This amount is used to
initialize financial account and will be used as last reconciliation amount for
first reconciliation in OB for the given financial account.]]></HELP>
+<!--D90513BC049C4CD5A0589E641DAFC4A0-->
<ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--D90513BC049C4CD5A0589E641DAFC4A0-->
<AD_TAB_ID><![CDATA[2845D761A8394468BD3BA4710AA888D4]]></AD_TAB_ID>
+<!--D90513BC049C4CD5A0589E641DAFC4A0-->
<AD_COLUMN_ID><![CDATA[515A9DFD91C243D3BECAA9D0149063C4]]></AD_COLUMN_ID>
+<!--D90513BC049C4CD5A0589E641DAFC4A0-->
<ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--D90513BC049C4CD5A0589E641DAFC4A0-->
<DISPLAYLENGTH><![CDATA[12]]></DISPLAYLENGTH>
+<!--D90513BC049C4CD5A0589E641DAFC4A0--> <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--D90513BC049C4CD5A0589E641DAFC4A0--> <SEQNO><![CDATA[220]]></SEQNO>
+<!--D90513BC049C4CD5A0589E641DAFC4A0--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--D90513BC049C4CD5A0589E641DAFC4A0-->
<ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--D90513BC049C4CD5A0589E641DAFC4A0-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--D90513BC049C4CD5A0589E641DAFC4A0-->
<SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--D90513BC049C4CD5A0589E641DAFC4A0-->
<ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--D90513BC049C4CD5A0589E641DAFC4A0-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--D90513BC049C4CD5A0589E641DAFC4A0--></AD_FIELD>
+
<!--D926D7DDA4E54F5491960BB3256D9C74--><AD_FIELD>
<!--D926D7DDA4E54F5491960BB3256D9C74-->
<AD_FIELD_ID><![CDATA[D926D7DDA4E54F5491960BB3256D9C74]]></AD_FIELD_ID>
<!--D926D7DDA4E54F5491960BB3256D9C74-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -204386,7 +204409,7 @@
<!--DCEAB518CBA44FFAA59E886AB5482055--> <DISPLAYLOGIC><![cda...@type@ =
'B']]></DISPLAYLOGIC>
<!--DCEAB518CBA44FFAA59E886AB5482055-->
<DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
<!--DCEAB518CBA44FFAA59E886AB5482055--> <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--DCEAB518CBA44FFAA59E886AB5482055--> <SEQNO><![CDATA[220]]></SEQNO>
+<!--DCEAB518CBA44FFAA59E886AB5482055--> <SEQNO><![CDATA[230]]></SEQNO>
<!--DCEAB518CBA44FFAA59E886AB5482055--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
<!--DCEAB518CBA44FFAA59E886AB5482055-->
<ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
<!--DCEAB518CBA44FFAA59E886AB5482055-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
