Fixed some issues on Financial Account window and Payment Method table.
authorGorka Ion Damián <gorkaion.damian@openbravo.com>
Tue, 23 Mar 2010 19:23:43 +0100
changeset 6873 00616c47730b
parent 6872 c4ac0459ec41
child 6874 2874fe456c25
Fixed some issues on Financial Account window and Payment Method table.
src-db/database/model/tables/FIN_FINANCIAL_ACCOUNT.xml
src-db/database/model/tables/FIN_PAYMENTMETHOD.xml
src-db/database/sourcedata/AD_COLUMN.xml
src-db/database/sourcedata/AD_TABLE.xml
--- a/src-db/database/model/tables/FIN_FINANCIAL_ACCOUNT.xml	Tue Mar 23 18:24:37 2010 +0100
+++ b/src-db/database/model/tables/FIN_FINANCIAL_ACCOUNT.xml	Tue Mar 23 19:23:43 2010 +0100
@@ -41,7 +41,7 @@
         <default/>
         <onCreateDefault/>
       </column>
-      <column name="DESCRIPTION" primaryKey="false" required="true" type="NVARCHAR" size="255" autoIncrement="false">
+      <column name="DESCRIPTION" primaryKey="false" required="false" type="NVARCHAR" size="255" autoIncrement="false">
         <default/>
         <onCreateDefault/>
       </column>
--- a/src-db/database/model/tables/FIN_PAYMENTMETHOD.xml	Tue Mar 23 18:24:37 2010 +0100
+++ b/src-db/database/model/tables/FIN_PAYMENTMETHOD.xml	Tue Mar 23 19:23:43 2010 +0100
@@ -41,22 +41,11 @@
         <default/>
         <onCreateDefault/>
       </column>
-      <column name="C_CURRENCY_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
-        <default/>
-        <onCreateDefault/>
-      </column>
-      <column name="PAYMENTRULE" primaryKey="false" required="false" type="VARCHAR" size="60" autoIncrement="false">
-        <default/>
-        <onCreateDefault/>
-      </column>
       <foreign-key foreignTable="AD_CLIENT" name="FIN_AD_CLIENT_PAYMENTMETHOD">
         <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
       </foreign-key>
       <foreign-key foreignTable="AD_ORG" name="FIN_AD_ORG_PAYMENTMETHOD">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="C_CURRENCY" name="FIN_C_CURRENCY_PAYMENTMETHOD">
-        <reference local="C_CURRENCY_ID" foreign="C_CURRENCY_ID"/>
-      </foreign-key>
     </table>
   </database>
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Tue Mar 23 18:24:37 2010 +0100
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Tue Mar 23 19:23:43 2010 +0100
@@ -271017,11 +271017,11 @@
 <!--7891269C840A655DE040007F010155CE-->  <HELP><![CDATA[A description is limited to 255 characters.]]></HELP>
 <!--7891269C840A655DE040007F010155CE-->  <COLUMNNAME><![CDATA[Description]]></COLUMNNAME>
 <!--7891269C840A655DE040007F010155CE-->  <AD_TABLE_ID><![CDATA[B129E53BC0E747879F7BA17F0AECEC32]]></AD_TABLE_ID>
-<!--7891269C840A655DE040007F010155CE-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--7891269C840A655DE040007F010155CE-->  <AD_REFERENCE_ID><![CDATA[14]]></AD_REFERENCE_ID>
 <!--7891269C840A655DE040007F010155CE-->  <FIELDLENGTH><![CDATA[255]]></FIELDLENGTH>
 <!--7891269C840A655DE040007F010155CE-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--7891269C840A655DE040007F010155CE-->  <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--7891269C840A655DE040007F010155CE-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--7891269C840A655DE040007F010155CE-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
 <!--7891269C840A655DE040007F010155CE-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
 <!--7891269C840A655DE040007F010155CE-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
 <!--7891269C840A655DE040007F010155CE-->  <SEQNO><![CDATA[110]]></SEQNO>
@@ -272790,69 +272790,6 @@
 <!--7DC33C4275623636E040007F01001C0B-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
 <!--7DC33C4275623636E040007F01001C0B--></AD_COLUMN>
 
-<!--7DC33C4275633636E040007F01001C0B--><AD_COLUMN>
-<!--7DC33C4275633636E040007F01001C0B-->  <AD_COLUMN_ID><![CDATA[7DC33C4275633636E040007F01001C0B]]></AD_COLUMN_ID>
-<!--7DC33C4275633636E040007F01001C0B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--7DC33C4275633636E040007F01001C0B-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--7DC33C4275633636E040007F01001C0B-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--7DC33C4275633636E040007F01001C0B-->  <NAME><![CDATA[Currency]]></NAME>
-<!--7DC33C4275633636E040007F01001C0B-->  <DESCRIPTION><![CDATA[An accepted medium of monetary exchange that may vary across countries.]]></DESCRIPTION>
-<!--7DC33C4275633636E040007F01001C0B-->  <HELP><![CDATA[Indicates the currency to be used when processing this document.]]></HELP>
-<!--7DC33C4275633636E040007F01001C0B-->  <COLUMNNAME><![CDATA[C_Currency_ID]]></COLUMNNAME>
-<!--7DC33C4275633636E040007F01001C0B-->  <AD_TABLE_ID><![CDATA[0B44DF7A2A854784BF34AD49C58647D7]]></AD_TABLE_ID>
-<!--7DC33C4275633636E040007F01001C0B-->  <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
-<!--7DC33C4275633636E040007F01001C0B-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
-<!--7DC33C4275633636E040007F01001C0B-->  <ISKEY><![CDATA[N]]></ISKEY>
-<!--7DC33C4275633636E040007F01001C0B-->  <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--7DC33C4275633636E040007F01001C0B-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
-<!--7DC33C4275633636E040007F01001C0B-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
-<!--7DC33C4275633636E040007F01001C0B-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
-<!--7DC33C4275633636E040007F01001C0B-->  <SEQNO><![CDATA[110]]></SEQNO>
-<!--7DC33C4275633636E040007F01001C0B-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
-<!--7DC33C4275633636E040007F01001C0B-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--7DC33C4275633636E040007F01001C0B-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
-<!--7DC33C4275633636E040007F01001C0B-->  <AD_ELEMENT_ID><![CDATA[193]]></AD_ELEMENT_ID>
-<!--7DC33C4275633636E040007F01001C0B-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
-<!--7DC33C4275633636E040007F01001C0B-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
-<!--7DC33C4275633636E040007F01001C0B-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
-<!--7DC33C4275633636E040007F01001C0B-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
-<!--7DC33C4275633636E040007F01001C0B-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--7DC33C4275633636E040007F01001C0B-->  <POSITION><![CDATA[11]]></POSITION>
-<!--7DC33C4275633636E040007F01001C0B-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
-<!--7DC33C4275633636E040007F01001C0B--></AD_COLUMN>
-
-<!--7DC33C4275643636E040007F01001C0B--><AD_COLUMN>
-<!--7DC33C4275643636E040007F01001C0B-->  <AD_COLUMN_ID><![CDATA[7DC33C4275643636E040007F01001C0B]]></AD_COLUMN_ID>
-<!--7DC33C4275643636E040007F01001C0B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--7DC33C4275643636E040007F01001C0B-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--7DC33C4275643636E040007F01001C0B-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--7DC33C4275643636E040007F01001C0B-->  <NAME><![CDATA[Form of Payment]]></NAME>
-<!--7DC33C4275643636E040007F01001C0B-->  <DESCRIPTION><![CDATA[The method used for payment of this transaction.]]></DESCRIPTION>
-<!--7DC33C4275643636E040007F01001C0B-->  <HELP><![CDATA[Form of Payment indicates the method of payment used for this transaction (eg. cash, wire transfer, etc.)]]></HELP>
-<!--7DC33C4275643636E040007F01001C0B-->  <COLUMNNAME><![CDATA[Paymentrule]]></COLUMNNAME>
-<!--7DC33C4275643636E040007F01001C0B-->  <AD_TABLE_ID><![CDATA[0B44DF7A2A854784BF34AD49C58647D7]]></AD_TABLE_ID>
-<!--7DC33C4275643636E040007F01001C0B-->  <AD_REFERENCE_ID><![CDATA[17]]></AD_REFERENCE_ID>
-<!--7DC33C4275643636E040007F01001C0B-->  <AD_REFERENCE_VALUE_ID><![CDATA[195]]></AD_REFERENCE_VALUE_ID>
-<!--7DC33C4275643636E040007F01001C0B-->  <FIELDLENGTH><![CDATA[60]]></FIELDLENGTH>
-<!--7DC33C4275643636E040007F01001C0B-->  <ISKEY><![CDATA[N]]></ISKEY>
-<!--7DC33C4275643636E040007F01001C0B-->  <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--7DC33C4275643636E040007F01001C0B-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
-<!--7DC33C4275643636E040007F01001C0B-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
-<!--7DC33C4275643636E040007F01001C0B-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
-<!--7DC33C4275643636E040007F01001C0B-->  <SEQNO><![CDATA[120]]></SEQNO>
-<!--7DC33C4275643636E040007F01001C0B-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
-<!--7DC33C4275643636E040007F01001C0B-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--7DC33C4275643636E040007F01001C0B-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
-<!--7DC33C4275643636E040007F01001C0B-->  <AD_ELEMENT_ID><![CDATA[1143]]></AD_ELEMENT_ID>
-<!--7DC33C4275643636E040007F01001C0B-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
-<!--7DC33C4275643636E040007F01001C0B-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
-<!--7DC33C4275643636E040007F01001C0B-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
-<!--7DC33C4275643636E040007F01001C0B-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
-<!--7DC33C4275643636E040007F01001C0B-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--7DC33C4275643636E040007F01001C0B-->  <POSITION><![CDATA[12]]></POSITION>
-<!--7DC33C4275643636E040007F01001C0B-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
-<!--7DC33C4275643636E040007F01001C0B--></AD_COLUMN>
-
 <!--7DC34559B3F1B45BE040007F0100784A--><AD_COLUMN>
 <!--7DC34559B3F1B45BE040007F0100784A-->  <AD_COLUMN_ID><![CDATA[7DC34559B3F1B45BE040007F0100784A]]></AD_COLUMN_ID>
 <!--7DC34559B3F1B45BE040007F0100784A-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -277804,7 +277741,7 @@
 <!--8189F49FFEA96E56E040007F01003E83-->  <NAME><![CDATA[Account]]></NAME>
 <!--8189F49FFEA96E56E040007F01003E83-->  <COLUMNNAME><![CDATA[FIN_Financial_Account_ID]]></COLUMNNAME>
 <!--8189F49FFEA96E56E040007F01003E83-->  <AD_TABLE_ID><![CDATA[D4C23A17190649E7B78F55A05AF3438C]]></AD_TABLE_ID>
-<!--8189F49FFEA96E56E040007F01003E83-->  <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--8189F49FFEA96E56E040007F01003E83-->  <AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID>
 <!--8189F49FFEA96E56E040007F01003E83-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
 <!--8189F49FFEA96E56E040007F01003E83-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--8189F49FFEA96E56E040007F01003E83-->  <ISPARENT><![CDATA[Y]]></ISPARENT>
@@ -277989,7 +277926,7 @@
 <!--8189F49FFEAF6E56E040007F01003E83-->  <AD_TABLE_ID><![CDATA[D4C23A17190649E7B78F55A05AF3438C]]></AD_TABLE_ID>
 <!--8189F49FFEAF6E56E040007F01003E83-->  <AD_REFERENCE_ID><![CDATA[15]]></AD_REFERENCE_ID>
 <!--8189F49FFEAF6E56E040007F01003E83-->  <FIELDLENGTH><![CDATA[19]]></FIELDLENGTH>
-<!--8189F49FFEAF6E56E040007F01003E83-->  <DEFAULTVALUE><![CDATA[SYSDATE]]></DEFAULTVALUE>
+<!--8189F49FFEAF6E56E040007F01003E83-->  <DEFAULTVALUE><![CDATA[@#Date@]]></DEFAULTVALUE>
 <!--8189F49FFEAF6E56E040007F01003E83-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--8189F49FFEAF6E56E040007F01003E83-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--8189F49FFEAF6E56E040007F01003E83-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
@@ -278021,7 +277958,7 @@
 <!--8189F49FFEB06E56E040007F01003E83-->  <AD_TABLE_ID><![CDATA[D4C23A17190649E7B78F55A05AF3438C]]></AD_TABLE_ID>
 <!--8189F49FFEB06E56E040007F01003E83-->  <AD_REFERENCE_ID><![CDATA[15]]></AD_REFERENCE_ID>
 <!--8189F49FFEB06E56E040007F01003E83-->  <FIELDLENGTH><![CDATA[19]]></FIELDLENGTH>
-<!--8189F49FFEB06E56E040007F01003E83-->  <DEFAULTVALUE><![CDATA[SYSDATE]]></DEFAULTVALUE>
+<!--8189F49FFEB06E56E040007F01003E83-->  <DEFAULTVALUE><![CDATA[@#Date@]]></DEFAULTVALUE>
 <!--8189F49FFEB06E56E040007F01003E83-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--8189F49FFEB06E56E040007F01003E83-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--8189F49FFEB06E56E040007F01003E83-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
@@ -278403,10 +278340,10 @@
 <!--8189F49FFEC16E56E040007F01003E83-->  <HELP><![CDATA[Bank statements loaded for the given financial account]]></HELP>
 <!--8189F49FFEC16E56E040007F01003E83-->  <COLUMNNAME><![CDATA[FIN_Bankstatement_ID]]></COLUMNNAME>
 <!--8189F49FFEC16E56E040007F01003E83-->  <AD_TABLE_ID><![CDATA[84203CBEBDA349C38319C0E549751546]]></AD_TABLE_ID>
-<!--8189F49FFEC16E56E040007F01003E83-->  <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--8189F49FFEC16E56E040007F01003E83-->  <AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID>
 <!--8189F49FFEC16E56E040007F01003E83-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
 <!--8189F49FFEC16E56E040007F01003E83-->  <ISKEY><![CDATA[N]]></ISKEY>
-<!--8189F49FFEC16E56E040007F01003E83-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--8189F49FFEC16E56E040007F01003E83-->  <ISPARENT><![CDATA[Y]]></ISPARENT>
 <!--8189F49FFEC16E56E040007F01003E83-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
 <!--8189F49FFEC16E56E040007F01003E83-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
 <!--8189F49FFEC16E56E040007F01003E83-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
@@ -278499,7 +278436,7 @@
 <!--8189F49FFEC46E56E040007F01003E83-->  <AD_TABLE_ID><![CDATA[84203CBEBDA349C38319C0E549751546]]></AD_TABLE_ID>
 <!--8189F49FFEC46E56E040007F01003E83-->  <AD_REFERENCE_ID><![CDATA[15]]></AD_REFERENCE_ID>
 <!--8189F49FFEC46E56E040007F01003E83-->  <FIELDLENGTH><![CDATA[19]]></FIELDLENGTH>
-<!--8189F49FFEC46E56E040007F01003E83-->  <DEFAULTVALUE><![CDATA[SYSDATE]]></DEFAULTVALUE>
+<!--8189F49FFEC46E56E040007F01003E83-->  <DEFAULTVALUE><![CDATA[@#Date@]]></DEFAULTVALUE>
 <!--8189F49FFEC46E56E040007F01003E83-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--8189F49FFEC46E56E040007F01003E83-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--8189F49FFEC46E56E040007F01003E83-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
@@ -278941,7 +278878,7 @@
 <!--8189F49FFEDC6E56E040007F01003E83-->  <NAME><![CDATA[Account]]></NAME>
 <!--8189F49FFEDC6E56E040007F01003E83-->  <COLUMNNAME><![CDATA[FIN_Financial_Account_ID]]></COLUMNNAME>
 <!--8189F49FFEDC6E56E040007F01003E83-->  <AD_TABLE_ID><![CDATA[B1B7075C46934F0A9FD4C4D0F1457B42]]></AD_TABLE_ID>
-<!--8189F49FFEDC6E56E040007F01003E83-->  <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--8189F49FFEDC6E56E040007F01003E83-->  <AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID>
 <!--8189F49FFEDC6E56E040007F01003E83-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
 <!--8189F49FFEDC6E56E040007F01003E83-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--8189F49FFEDC6E56E040007F01003E83-->  <ISPARENT><![CDATA[Y]]></ISPARENT>
--- a/src-db/database/sourcedata/AD_TABLE.xml	Tue Mar 23 18:24:37 2010 +0100
+++ b/src-db/database/sourcedata/AD_TABLE.xml	Tue Mar 23 19:23:43 2010 +0100
@@ -10341,7 +10341,7 @@
 <!--6F98C7AB59D3410CB828DB25D638DE2C-->  <TABLENAME><![CDATA[FIN_Financial_Account_Acct]]></TABLENAME>
 <!--6F98C7AB59D3410CB828DB25D638DE2C-->  <CLASSNAME><![CDATA[FIN_FinancialAccountAccounting]]></CLASSNAME>
 <!--6F98C7AB59D3410CB828DB25D638DE2C-->  <ISVIEW><![CDATA[N]]></ISVIEW>
-<!--6F98C7AB59D3410CB828DB25D638DE2C-->  <ACCESSLEVEL><![CDATA[3]]></ACCESSLEVEL>
+<!--6F98C7AB59D3410CB828DB25D638DE2C-->  <ACCESSLEVEL><![CDATA[1]]></ACCESSLEVEL>
 <!--6F98C7AB59D3410CB828DB25D638DE2C-->  <ISSECURITYENABLED><![CDATA[N]]></ISSECURITYENABLED>
 <!--6F98C7AB59D3410CB828DB25D638DE2C-->  <ISDELETEABLE><![CDATA[Y]]></ISDELETEABLE>
 <!--6F98C7AB59D3410CB828DB25D638DE2C-->  <ISHIGHVOLUME><![CDATA[N]]></ISHIGHVOLUME>