fixes issue 22459: Define Location Settings for each Country
authorCarlos Aristu <carlos.aristu@openbravo.com>
Wed, 12 Dec 2012 16:41:23 +0100
changeset 19035 894a18fcc6cb
parent 19034 37f673f53540
child 19036 41ca7359b03c
child 19280 48b5fcd11291
fixes issue 22459: Define Location Settings for each Country
src-db/database/model/tables/C_COUNTRY.xml
src-db/database/sourcedata/AD_COLUMN.xml
src-db/database/sourcedata/AD_ELEMENT.xml
src-db/database/sourcedata/AD_FIELD.xml
src-db/database/sourcedata/AD_FIELDGROUP.xml
src-db/database/sourcedata/AD_MESSAGE.xml
src-db/database/sourcedata/AD_REFERENCE.xml
src-db/database/sourcedata/AD_REF_LIST.xml
src/org/openbravo/erpCommon/utility/Utility.java
--- a/src-db/database/model/tables/C_COUNTRY.xml	Wed Dec 12 14:51:47 2012 +0100
+++ b/src-db/database/model/tables/C_COUNTRY.xml	Wed Dec 12 16:41:23 2012 +0100
@@ -93,6 +93,26 @@
         <default/>
         <onCreateDefault/>
       </column>
+      <column name="DECIMALSEPARATOR" primaryKey="false" required="false" type="VARCHAR" size="60" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
+      <column name="GROUPINGSEPARATOR" primaryKey="false" required="false" type="VARCHAR" size="60" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
+      <column name="NUMERICMASK" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
+      <column name="DATEFORMAT" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
+      <column name="DATETIMEFORMAT" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
       <foreign-key foreignTable="AD_LANGUAGE" name="C_COUNTRY_AD_LANGUAGE">
         <reference local="AD_LANGUAGE" foreign="AD_LANGUAGE"/>
       </foreign-key>
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Wed Dec 12 14:51:47 2012 +0100
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Wed Dec 12 16:41:23 2012 +0100
@@ -228814,6 +228814,39 @@
 <!--3AC29C75D39249F39073F6315334D235-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--3AC29C75D39249F39073F6315334D235--></AD_COLUMN>
 
+<!--3AC9F8370DD7406F91E48296293FBDA7--><AD_COLUMN>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <AD_COLUMN_ID><![CDATA[3AC9F8370DD7406F91E48296293FBDA7]]></AD_COLUMN_ID>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <NAME><![CDATA[Numericmask]]></NAME>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <COLUMNNAME><![CDATA[Numericmask]]></COLUMNNAME>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <AD_TABLE_ID><![CDATA[170]]></AD_TABLE_ID>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <SEQNO><![CDATA[51]]></SEQNO>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <AD_ELEMENT_ID><![CDATA[297633BB09944F6098A57C53EA17A4E0]]></AD_ELEMENT_ID>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <POSITION><![CDATA[26]]></POSITION>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--3AC9F8370DD7406F91E48296293FBDA7-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--3AC9F8370DD7406F91E48296293FBDA7--></AD_COLUMN>
+
 <!--3AE62A8262C1481EB0AA36315B026371--><AD_COLUMN>
 <!--3AE62A8262C1481EB0AA36315B026371-->  <AD_COLUMN_ID><![CDATA[3AE62A8262C1481EB0AA36315B026371]]></AD_COLUMN_ID>
 <!--3AE62A8262C1481EB0AA36315B026371-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -281273,6 +281306,40 @@
 <!--9252E75FDFFB4B91A53007F090FC5F0C-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--9252E75FDFFB4B91A53007F090FC5F0C--></AD_COLUMN>
 
+<!--9261B8D64E824C70BE5379DF6511CFB7--><AD_COLUMN>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <AD_COLUMN_ID><![CDATA[9261B8D64E824C70BE5379DF6511CFB7]]></AD_COLUMN_ID>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <NAME><![CDATA[Decimalseparator]]></NAME>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <COLUMNNAME><![CDATA[Decimalseparator]]></COLUMNNAME>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <AD_TABLE_ID><![CDATA[170]]></AD_TABLE_ID>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <AD_REFERENCE_ID><![CDATA[17]]></AD_REFERENCE_ID>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <AD_REFERENCE_VALUE_ID><![CDATA[279F05C514AB40868B83484C11DD4A01]]></AD_REFERENCE_VALUE_ID>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <FIELDLENGTH><![CDATA[60]]></FIELDLENGTH>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <SEQNO><![CDATA[31]]></SEQNO>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <AD_ELEMENT_ID><![CDATA[D1AD99999295450280709FE47BEDDE55]]></AD_ELEMENT_ID>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <POSITION><![CDATA[24]]></POSITION>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--9261B8D64E824C70BE5379DF6511CFB7-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--9261B8D64E824C70BE5379DF6511CFB7--></AD_COLUMN>
+
 <!--926DB31AD14D4A49BE77D6A3E6105987--><AD_COLUMN>
 <!--926DB31AD14D4A49BE77D6A3E6105987-->  <AD_COLUMN_ID><![CDATA[926DB31AD14D4A49BE77D6A3E6105987]]></AD_COLUMN_ID>
 <!--926DB31AD14D4A49BE77D6A3E6105987-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -285653,6 +285720,39 @@
 <!--A0895BE15FC84F7CA2BD4D6B51D8BFD1-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--A0895BE15FC84F7CA2BD4D6B51D8BFD1--></AD_COLUMN>
 
+<!--A0A73EEE290340F0A8920101AC8DC7C5--><AD_COLUMN>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <AD_COLUMN_ID><![CDATA[A0A73EEE290340F0A8920101AC8DC7C5]]></AD_COLUMN_ID>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <NAME><![CDATA[Dateformat]]></NAME>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <COLUMNNAME><![CDATA[Dateformat]]></COLUMNNAME>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <AD_TABLE_ID><![CDATA[170]]></AD_TABLE_ID>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <SEQNO><![CDATA[61]]></SEQNO>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <AD_ELEMENT_ID><![CDATA[70968F793B854BA6ACC1404369C8FFFF]]></AD_ELEMENT_ID>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <POSITION><![CDATA[27]]></POSITION>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--A0A73EEE290340F0A8920101AC8DC7C5-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--A0A73EEE290340F0A8920101AC8DC7C5--></AD_COLUMN>
+
 <!--A0C098361E4C4DC28430235417130B92--><AD_COLUMN>
 <!--A0C098361E4C4DC28430235417130B92-->  <AD_COLUMN_ID><![CDATA[A0C098361E4C4DC28430235417130B92]]></AD_COLUMN_ID>
 <!--A0C098361E4C4DC28430235417130B92-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -288540,6 +288640,39 @@
 <!--AE3FB28F95334421BB3DFAAA5B85307A-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--AE3FB28F95334421BB3DFAAA5B85307A--></AD_COLUMN>
 
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69--><AD_COLUMN>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <AD_COLUMN_ID><![CDATA[AEB2AF758E1A4FD9BCAFB15C2B9BBA69]]></AD_COLUMN_ID>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <NAME><![CDATA[Datetimeformat]]></NAME>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <COLUMNNAME><![CDATA[Datetimeformat]]></COLUMNNAME>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <AD_TABLE_ID><![CDATA[170]]></AD_TABLE_ID>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <SEQNO><![CDATA[71]]></SEQNO>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <AD_ELEMENT_ID><![CDATA[64C7AD5AA499477EB2E51F4FC8A0B6E0]]></AD_ELEMENT_ID>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <POSITION><![CDATA[28]]></POSITION>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--AEB2AF758E1A4FD9BCAFB15C2B9BBA69--></AD_COLUMN>
+
 <!--AECA45F025F14E6DBA669E12DDA55D17--><AD_COLUMN>
 <!--AECA45F025F14E6DBA669E12DDA55D17-->  <AD_COLUMN_ID><![CDATA[AECA45F025F14E6DBA669E12DDA55D17]]></AD_COLUMN_ID>
 <!--AECA45F025F14E6DBA669E12DDA55D17-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -306880,6 +307013,40 @@
 <!--E59D4BB7F1C342619CB4131FE4888FFA-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--E59D4BB7F1C342619CB4131FE4888FFA--></AD_COLUMN>
 
+<!--E644E732A207448EAB7CBE80D616AB6F--><AD_COLUMN>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <AD_COLUMN_ID><![CDATA[E644E732A207448EAB7CBE80D616AB6F]]></AD_COLUMN_ID>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <NAME><![CDATA[Groupingseparator]]></NAME>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <COLUMNNAME><![CDATA[Groupingseparator]]></COLUMNNAME>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <AD_TABLE_ID><![CDATA[170]]></AD_TABLE_ID>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <AD_REFERENCE_ID><![CDATA[17]]></AD_REFERENCE_ID>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <AD_REFERENCE_VALUE_ID><![CDATA[279F05C514AB40868B83484C11DD4A01]]></AD_REFERENCE_VALUE_ID>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <FIELDLENGTH><![CDATA[60]]></FIELDLENGTH>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <SEQNO><![CDATA[41]]></SEQNO>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <AD_ELEMENT_ID><![CDATA[2F2385413E274261B676F03418827B81]]></AD_ELEMENT_ID>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <POSITION><![CDATA[25]]></POSITION>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--E644E732A207448EAB7CBE80D616AB6F-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--E644E732A207448EAB7CBE80D616AB6F--></AD_COLUMN>
+
 <!--E65F829C8E0B420A8B6D42A1A2DC9195--><AD_COLUMN>
 <!--E65F829C8E0B420A8B6D42A1A2DC9195-->  <AD_COLUMN_ID><![CDATA[E65F829C8E0B420A8B6D42A1A2DC9195]]></AD_COLUMN_ID>
 <!--E65F829C8E0B420A8B6D42A1A2DC9195-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_ELEMENT.xml	Wed Dec 12 14:51:47 2012 +0100
+++ b/src-db/database/sourcedata/AD_ELEMENT.xml	Wed Dec 12 16:41:23 2012 +0100
@@ -21110,6 +21110,18 @@
 <!--22A76EB58F264A7BA616198175C3E4C5-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
 <!--22A76EB58F264A7BA616198175C3E4C5--></AD_ELEMENT>
 
+<!--297633BB09944F6098A57C53EA17A4E0--><AD_ELEMENT>
+<!--297633BB09944F6098A57C53EA17A4E0-->  <AD_ELEMENT_ID><![CDATA[297633BB09944F6098A57C53EA17A4E0]]></AD_ELEMENT_ID>
+<!--297633BB09944F6098A57C53EA17A4E0-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--297633BB09944F6098A57C53EA17A4E0-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--297633BB09944F6098A57C53EA17A4E0-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--297633BB09944F6098A57C53EA17A4E0-->  <COLUMNNAME><![CDATA[Numericmask]]></COLUMNNAME>
+<!--297633BB09944F6098A57C53EA17A4E0-->  <NAME><![CDATA[Numeric Mask]]></NAME>
+<!--297633BB09944F6098A57C53EA17A4E0-->  <PRINTNAME><![CDATA[Numeric Mask]]></PRINTNAME>
+<!--297633BB09944F6098A57C53EA17A4E0-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--297633BB09944F6098A57C53EA17A4E0-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
+<!--297633BB09944F6098A57C53EA17A4E0--></AD_ELEMENT>
+
 <!--2D2C180E4B004B76AA0CE7C2ABA651A3--><AD_ELEMENT>
 <!--2D2C180E4B004B76AA0CE7C2ABA651A3-->  <AD_ELEMENT_ID><![CDATA[2D2C180E4B004B76AA0CE7C2ABA651A3]]></AD_ELEMENT_ID>
 <!--2D2C180E4B004B76AA0CE7C2ABA651A3-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -21177,6 +21189,18 @@
 <!--2EB6010EAA174169880C588220EFE7B8-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
 <!--2EB6010EAA174169880C588220EFE7B8--></AD_ELEMENT>
 
+<!--2F2385413E274261B676F03418827B81--><AD_ELEMENT>
+<!--2F2385413E274261B676F03418827B81-->  <AD_ELEMENT_ID><![CDATA[2F2385413E274261B676F03418827B81]]></AD_ELEMENT_ID>
+<!--2F2385413E274261B676F03418827B81-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--2F2385413E274261B676F03418827B81-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--2F2385413E274261B676F03418827B81-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--2F2385413E274261B676F03418827B81-->  <COLUMNNAME><![CDATA[Groupingseparator]]></COLUMNNAME>
+<!--2F2385413E274261B676F03418827B81-->  <NAME><![CDATA[Grouping Separator]]></NAME>
+<!--2F2385413E274261B676F03418827B81-->  <PRINTNAME><![CDATA[Grouping Separator]]></PRINTNAME>
+<!--2F2385413E274261B676F03418827B81-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--2F2385413E274261B676F03418827B81-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
+<!--2F2385413E274261B676F03418827B81--></AD_ELEMENT>
+
 <!--2FA505E33C9345DDA6CD104C19F0F8BF--><AD_ELEMENT>
 <!--2FA505E33C9345DDA6CD104C19F0F8BF-->  <AD_ELEMENT_ID><![CDATA[2FA505E33C9345DDA6CD104C19F0F8BF]]></AD_ELEMENT_ID>
 <!--2FA505E33C9345DDA6CD104C19F0F8BF-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -24512,6 +24536,18 @@
 <!--64ADC1DFBF8641A79C9911445253DA0D-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
 <!--64ADC1DFBF8641A79C9911445253DA0D--></AD_ELEMENT>
 
+<!--64C7AD5AA499477EB2E51F4FC8A0B6E0--><AD_ELEMENT>
+<!--64C7AD5AA499477EB2E51F4FC8A0B6E0-->  <AD_ELEMENT_ID><![CDATA[64C7AD5AA499477EB2E51F4FC8A0B6E0]]></AD_ELEMENT_ID>
+<!--64C7AD5AA499477EB2E51F4FC8A0B6E0-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--64C7AD5AA499477EB2E51F4FC8A0B6E0-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--64C7AD5AA499477EB2E51F4FC8A0B6E0-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--64C7AD5AA499477EB2E51F4FC8A0B6E0-->  <COLUMNNAME><![CDATA[Datetimeformat]]></COLUMNNAME>
+<!--64C7AD5AA499477EB2E51F4FC8A0B6E0-->  <NAME><![CDATA[Date Time Format]]></NAME>
+<!--64C7AD5AA499477EB2E51F4FC8A0B6E0-->  <PRINTNAME><![CDATA[Date Time Format]]></PRINTNAME>
+<!--64C7AD5AA499477EB2E51F4FC8A0B6E0-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--64C7AD5AA499477EB2E51F4FC8A0B6E0-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
+<!--64C7AD5AA499477EB2E51F4FC8A0B6E0--></AD_ELEMENT>
+
 <!--64F7ED4E80D511DD9EAB7F0741E062E6--><AD_ELEMENT>
 <!--64F7ED4E80D511DD9EAB7F0741E062E6-->  <AD_ELEMENT_ID><![CDATA[64F7ED4E80D511DD9EAB7F0741E062E6]]></AD_ELEMENT_ID>
 <!--64F7ED4E80D511DD9EAB7F0741E062E6-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -24979,6 +25015,18 @@
 <!--7079E2FD4AA8799EE040007F010104AD-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
 <!--7079E2FD4AA8799EE040007F010104AD--></AD_ELEMENT>
 
+<!--70968F793B854BA6ACC1404369C8FFFF--><AD_ELEMENT>
+<!--70968F793B854BA6ACC1404369C8FFFF-->  <AD_ELEMENT_ID><![CDATA[70968F793B854BA6ACC1404369C8FFFF]]></AD_ELEMENT_ID>
+<!--70968F793B854BA6ACC1404369C8FFFF-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--70968F793B854BA6ACC1404369C8FFFF-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--70968F793B854BA6ACC1404369C8FFFF-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--70968F793B854BA6ACC1404369C8FFFF-->  <COLUMNNAME><![CDATA[Dateformat]]></COLUMNNAME>
+<!--70968F793B854BA6ACC1404369C8FFFF-->  <NAME><![CDATA[Date Format]]></NAME>
+<!--70968F793B854BA6ACC1404369C8FFFF-->  <PRINTNAME><![CDATA[Date Format]]></PRINTNAME>
+<!--70968F793B854BA6ACC1404369C8FFFF-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--70968F793B854BA6ACC1404369C8FFFF-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
+<!--70968F793B854BA6ACC1404369C8FFFF--></AD_ELEMENT>
+
 <!--722EE1A3B4A4660EE040007F01001A37--><AD_ELEMENT>
 <!--722EE1A3B4A4660EE040007F01001A37-->  <AD_ELEMENT_ID><![CDATA[722EE1A3B4A4660EE040007F01001A37]]></AD_ELEMENT_ID>
 <!--722EE1A3B4A4660EE040007F01001A37-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -29995,6 +30043,18 @@
 <!--D190BE6617E04A41BF66468665BA145E-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
 <!--D190BE6617E04A41BF66468665BA145E--></AD_ELEMENT>
 
+<!--D1AD99999295450280709FE47BEDDE55--><AD_ELEMENT>
+<!--D1AD99999295450280709FE47BEDDE55-->  <AD_ELEMENT_ID><![CDATA[D1AD99999295450280709FE47BEDDE55]]></AD_ELEMENT_ID>
+<!--D1AD99999295450280709FE47BEDDE55-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--D1AD99999295450280709FE47BEDDE55-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--D1AD99999295450280709FE47BEDDE55-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--D1AD99999295450280709FE47BEDDE55-->  <COLUMNNAME><![CDATA[Decimalseparator]]></COLUMNNAME>
+<!--D1AD99999295450280709FE47BEDDE55-->  <NAME><![CDATA[Decimal Separator]]></NAME>
+<!--D1AD99999295450280709FE47BEDDE55-->  <PRINTNAME><![CDATA[Decimal Separator]]></PRINTNAME>
+<!--D1AD99999295450280709FE47BEDDE55-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--D1AD99999295450280709FE47BEDDE55-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
+<!--D1AD99999295450280709FE47BEDDE55--></AD_ELEMENT>
+
 <!--D3E4B412F90E4D13A290F5EAA0278261--><AD_ELEMENT>
 <!--D3E4B412F90E4D13A290F5EAA0278261-->  <AD_ELEMENT_ID><![CDATA[D3E4B412F90E4D13A290F5EAA0278261]]></AD_ELEMENT_ID>
 <!--D3E4B412F90E4D13A290F5EAA0278261-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_FIELD.xml	Wed Dec 12 14:51:47 2012 +0100
+++ b/src-db/database/sourcedata/AD_FIELD.xml	Wed Dec 12 16:41:23 2012 +0100
@@ -190695,6 +190695,34 @@
 <!--511E6563DC9B4054BE97C4E243F40572-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--511E6563DC9B4054BE97C4E243F40572--></AD_FIELD>
 
+<!--512BF3CD6F134EB7B9243A35F4ED1F4B--><AD_FIELD>
+<!--512BF3CD6F134EB7B9243A35F4ED1F4B-->  <AD_FIELD_ID><![CDATA[512BF3CD6F134EB7B9243A35F4ED1F4B]]></AD_FIELD_ID>
+<!--512BF3CD6F134EB7B9243A35F4ED1F4B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--512BF3CD6F134EB7B9243A35F4ED1F4B-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--512BF3CD6F134EB7B9243A35F4ED1F4B-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--512BF3CD6F134EB7B9243A35F4ED1F4B-->  <NAME><![CDATA[Date Time Format]]></NAME>
+<!--512BF3CD6F134EB7B9243A35F4ED1F4B-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--512BF3CD6F134EB7B9243A35F4ED1F4B-->  <AD_TAB_ID><![CDATA[135]]></AD_TAB_ID>
+<!--512BF3CD6F134EB7B9243A35F4ED1F4B-->  <AD_COLUMN_ID><![CDATA[AEB2AF758E1A4FD9BCAFB15C2B9BBA69]]></AD_COLUMN_ID>
+<!--512BF3CD6F134EB7B9243A35F4ED1F4B-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--512BF3CD6F134EB7B9243A35F4ED1F4B-->  <AD_FIELDGROUP_ID><![CDATA[18E9C0CF3E0D4B008744301C2DAEC079]]></AD_FIELDGROUP_ID>
+<!--512BF3CD6F134EB7B9243A35F4ED1F4B-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--512BF3CD6F134EB7B9243A35F4ED1F4B-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
+<!--512BF3CD6F134EB7B9243A35F4ED1F4B-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--512BF3CD6F134EB7B9243A35F4ED1F4B-->  <SEQNO><![CDATA[210]]></SEQNO>
+<!--512BF3CD6F134EB7B9243A35F4ED1F4B-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--512BF3CD6F134EB7B9243A35F4ED1F4B-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--512BF3CD6F134EB7B9243A35F4ED1F4B-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--512BF3CD6F134EB7B9243A35F4ED1F4B-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--512BF3CD6F134EB7B9243A35F4ED1F4B-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--512BF3CD6F134EB7B9243A35F4ED1F4B-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--512BF3CD6F134EB7B9243A35F4ED1F4B-->  <GRID_SEQNO><![CDATA[160]]></GRID_SEQNO>
+<!--512BF3CD6F134EB7B9243A35F4ED1F4B-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--512BF3CD6F134EB7B9243A35F4ED1F4B-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--512BF3CD6F134EB7B9243A35F4ED1F4B-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--512BF3CD6F134EB7B9243A35F4ED1F4B-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--512BF3CD6F134EB7B9243A35F4ED1F4B--></AD_FIELD>
+
 <!--51313EAEE1B140F582530EF98C436C90--><AD_FIELD>
 <!--51313EAEE1B140F582530EF98C436C90-->  <AD_FIELD_ID><![CDATA[51313EAEE1B140F582530EF98C436C90]]></AD_FIELD_ID>
 <!--51313EAEE1B140F582530EF98C436C90-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -207948,6 +207976,34 @@
 <!--7156F99FB9D5456DB8BC104FAF18EBCA-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--7156F99FB9D5456DB8BC104FAF18EBCA--></AD_FIELD>
 
+<!--7162501CB4AF45A19E0A07557D70D3D1--><AD_FIELD>
+<!--7162501CB4AF45A19E0A07557D70D3D1-->  <AD_FIELD_ID><![CDATA[7162501CB4AF45A19E0A07557D70D3D1]]></AD_FIELD_ID>
+<!--7162501CB4AF45A19E0A07557D70D3D1-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--7162501CB4AF45A19E0A07557D70D3D1-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--7162501CB4AF45A19E0A07557D70D3D1-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--7162501CB4AF45A19E0A07557D70D3D1-->  <NAME><![CDATA[Numeric Mask]]></NAME>
+<!--7162501CB4AF45A19E0A07557D70D3D1-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--7162501CB4AF45A19E0A07557D70D3D1-->  <AD_TAB_ID><![CDATA[135]]></AD_TAB_ID>
+<!--7162501CB4AF45A19E0A07557D70D3D1-->  <AD_COLUMN_ID><![CDATA[3AC9F8370DD7406F91E48296293FBDA7]]></AD_COLUMN_ID>
+<!--7162501CB4AF45A19E0A07557D70D3D1-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--7162501CB4AF45A19E0A07557D70D3D1-->  <AD_FIELDGROUP_ID><![CDATA[18E9C0CF3E0D4B008744301C2DAEC079]]></AD_FIELDGROUP_ID>
+<!--7162501CB4AF45A19E0A07557D70D3D1-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--7162501CB4AF45A19E0A07557D70D3D1-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
+<!--7162501CB4AF45A19E0A07557D70D3D1-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--7162501CB4AF45A19E0A07557D70D3D1-->  <SEQNO><![CDATA[200]]></SEQNO>
+<!--7162501CB4AF45A19E0A07557D70D3D1-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--7162501CB4AF45A19E0A07557D70D3D1-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--7162501CB4AF45A19E0A07557D70D3D1-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--7162501CB4AF45A19E0A07557D70D3D1-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--7162501CB4AF45A19E0A07557D70D3D1-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--7162501CB4AF45A19E0A07557D70D3D1-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--7162501CB4AF45A19E0A07557D70D3D1-->  <GRID_SEQNO><![CDATA[150]]></GRID_SEQNO>
+<!--7162501CB4AF45A19E0A07557D70D3D1-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--7162501CB4AF45A19E0A07557D70D3D1-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--7162501CB4AF45A19E0A07557D70D3D1-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--7162501CB4AF45A19E0A07557D70D3D1-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--7162501CB4AF45A19E0A07557D70D3D1--></AD_FIELD>
+
 <!--71635D54140846999169B3024771B783--><AD_FIELD>
 <!--71635D54140846999169B3024771B783-->  <AD_FIELD_ID><![CDATA[71635D54140846999169B3024771B783]]></AD_FIELD_ID>
 <!--71635D54140846999169B3024771B783-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -238671,6 +238727,34 @@
 <!--B1FF6B9E97FCECE0E040A8C028011392-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--B1FF6B9E97FCECE0E040A8C028011392--></AD_FIELD>
 
+<!--B215830BCED14BB2BB7C5529170E27C5--><AD_FIELD>
+<!--B215830BCED14BB2BB7C5529170E27C5-->  <AD_FIELD_ID><![CDATA[B215830BCED14BB2BB7C5529170E27C5]]></AD_FIELD_ID>
+<!--B215830BCED14BB2BB7C5529170E27C5-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--B215830BCED14BB2BB7C5529170E27C5-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--B215830BCED14BB2BB7C5529170E27C5-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--B215830BCED14BB2BB7C5529170E27C5-->  <NAME><![CDATA[Date Format]]></NAME>
+<!--B215830BCED14BB2BB7C5529170E27C5-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--B215830BCED14BB2BB7C5529170E27C5-->  <AD_TAB_ID><![CDATA[135]]></AD_TAB_ID>
+<!--B215830BCED14BB2BB7C5529170E27C5-->  <AD_COLUMN_ID><![CDATA[A0A73EEE290340F0A8920101AC8DC7C5]]></AD_COLUMN_ID>
+<!--B215830BCED14BB2BB7C5529170E27C5-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--B215830BCED14BB2BB7C5529170E27C5-->  <AD_FIELDGROUP_ID><![CDATA[18E9C0CF3E0D4B008744301C2DAEC079]]></AD_FIELDGROUP_ID>
+<!--B215830BCED14BB2BB7C5529170E27C5-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--B215830BCED14BB2BB7C5529170E27C5-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
+<!--B215830BCED14BB2BB7C5529170E27C5-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--B215830BCED14BB2BB7C5529170E27C5-->  <SEQNO><![CDATA[220]]></SEQNO>
+<!--B215830BCED14BB2BB7C5529170E27C5-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--B215830BCED14BB2BB7C5529170E27C5-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--B215830BCED14BB2BB7C5529170E27C5-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--B215830BCED14BB2BB7C5529170E27C5-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--B215830BCED14BB2BB7C5529170E27C5-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--B215830BCED14BB2BB7C5529170E27C5-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--B215830BCED14BB2BB7C5529170E27C5-->  <GRID_SEQNO><![CDATA[170]]></GRID_SEQNO>
+<!--B215830BCED14BB2BB7C5529170E27C5-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--B215830BCED14BB2BB7C5529170E27C5-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--B215830BCED14BB2BB7C5529170E27C5-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--B215830BCED14BB2BB7C5529170E27C5-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--B215830BCED14BB2BB7C5529170E27C5--></AD_FIELD>
+
 <!--B21E042CE2E740B79EA8D6E29283298E--><AD_FIELD>
 <!--B21E042CE2E740B79EA8D6E29283298E-->  <AD_FIELD_ID><![CDATA[B21E042CE2E740B79EA8D6E29283298E]]></AD_FIELD_ID>
 <!--B21E042CE2E740B79EA8D6E29283298E-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -238730,6 +238814,34 @@
 <!--B21F84FFDF2E4A7B88C7D60ED9E1F16D-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--B21F84FFDF2E4A7B88C7D60ED9E1F16D--></AD_FIELD>
 
+<!--B231A1B105C14589A17C800948150F83--><AD_FIELD>
+<!--B231A1B105C14589A17C800948150F83-->  <AD_FIELD_ID><![CDATA[B231A1B105C14589A17C800948150F83]]></AD_FIELD_ID>
+<!--B231A1B105C14589A17C800948150F83-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--B231A1B105C14589A17C800948150F83-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--B231A1B105C14589A17C800948150F83-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--B231A1B105C14589A17C800948150F83-->  <NAME><![CDATA[Grouping Separator]]></NAME>
+<!--B231A1B105C14589A17C800948150F83-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--B231A1B105C14589A17C800948150F83-->  <AD_TAB_ID><![CDATA[135]]></AD_TAB_ID>
+<!--B231A1B105C14589A17C800948150F83-->  <AD_COLUMN_ID><![CDATA[E644E732A207448EAB7CBE80D616AB6F]]></AD_COLUMN_ID>
+<!--B231A1B105C14589A17C800948150F83-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--B231A1B105C14589A17C800948150F83-->  <AD_FIELDGROUP_ID><![CDATA[18E9C0CF3E0D4B008744301C2DAEC079]]></AD_FIELDGROUP_ID>
+<!--B231A1B105C14589A17C800948150F83-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--B231A1B105C14589A17C800948150F83-->  <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
+<!--B231A1B105C14589A17C800948150F83-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--B231A1B105C14589A17C800948150F83-->  <SEQNO><![CDATA[190]]></SEQNO>
+<!--B231A1B105C14589A17C800948150F83-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--B231A1B105C14589A17C800948150F83-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--B231A1B105C14589A17C800948150F83-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--B231A1B105C14589A17C800948150F83-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--B231A1B105C14589A17C800948150F83-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--B231A1B105C14589A17C800948150F83-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--B231A1B105C14589A17C800948150F83-->  <GRID_SEQNO><![CDATA[140]]></GRID_SEQNO>
+<!--B231A1B105C14589A17C800948150F83-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--B231A1B105C14589A17C800948150F83-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--B231A1B105C14589A17C800948150F83-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--B231A1B105C14589A17C800948150F83-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--B231A1B105C14589A17C800948150F83--></AD_FIELD>
+
 <!--B241EA039AA039E9E040007F01005C90--><AD_FIELD>
 <!--B241EA039AA039E9E040007F01005C90-->  <AD_FIELD_ID><![CDATA[B241EA039AA039E9E040007F01005C90]]></AD_FIELD_ID>
 <!--B241EA039AA039E9E040007F01005C90-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -242334,6 +242446,34 @@
 <!--BBE2987ED6E44909A5DE9517AC029D29-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--BBE2987ED6E44909A5DE9517AC029D29--></AD_FIELD>
 
+<!--BBF2784489D54D70B8EB72FCBF0934B4--><AD_FIELD>
+<!--BBF2784489D54D70B8EB72FCBF0934B4-->  <AD_FIELD_ID><![CDATA[BBF2784489D54D70B8EB72FCBF0934B4]]></AD_FIELD_ID>
+<!--BBF2784489D54D70B8EB72FCBF0934B4-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--BBF2784489D54D70B8EB72FCBF0934B4-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--BBF2784489D54D70B8EB72FCBF0934B4-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--BBF2784489D54D70B8EB72FCBF0934B4-->  <NAME><![CDATA[Decimal Separator]]></NAME>
+<!--BBF2784489D54D70B8EB72FCBF0934B4-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--BBF2784489D54D70B8EB72FCBF0934B4-->  <AD_TAB_ID><![CDATA[135]]></AD_TAB_ID>
+<!--BBF2784489D54D70B8EB72FCBF0934B4-->  <AD_COLUMN_ID><![CDATA[9261B8D64E824C70BE5379DF6511CFB7]]></AD_COLUMN_ID>
+<!--BBF2784489D54D70B8EB72FCBF0934B4-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--BBF2784489D54D70B8EB72FCBF0934B4-->  <AD_FIELDGROUP_ID><![CDATA[18E9C0CF3E0D4B008744301C2DAEC079]]></AD_FIELDGROUP_ID>
+<!--BBF2784489D54D70B8EB72FCBF0934B4-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--BBF2784489D54D70B8EB72FCBF0934B4-->  <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
+<!--BBF2784489D54D70B8EB72FCBF0934B4-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--BBF2784489D54D70B8EB72FCBF0934B4-->  <SEQNO><![CDATA[180]]></SEQNO>
+<!--BBF2784489D54D70B8EB72FCBF0934B4-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--BBF2784489D54D70B8EB72FCBF0934B4-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--BBF2784489D54D70B8EB72FCBF0934B4-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--BBF2784489D54D70B8EB72FCBF0934B4-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--BBF2784489D54D70B8EB72FCBF0934B4-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--BBF2784489D54D70B8EB72FCBF0934B4-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--BBF2784489D54D70B8EB72FCBF0934B4-->  <GRID_SEQNO><![CDATA[130]]></GRID_SEQNO>
+<!--BBF2784489D54D70B8EB72FCBF0934B4-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--BBF2784489D54D70B8EB72FCBF0934B4-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--BBF2784489D54D70B8EB72FCBF0934B4-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--BBF2784489D54D70B8EB72FCBF0934B4-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--BBF2784489D54D70B8EB72FCBF0934B4--></AD_FIELD>
+
 <!--BC0A0ACE451A421CA2BC3DDD4FE76CD0--><AD_FIELD>
 <!--BC0A0ACE451A421CA2BC3DDD4FE76CD0-->  <AD_FIELD_ID><![CDATA[BC0A0ACE451A421CA2BC3DDD4FE76CD0]]></AD_FIELD_ID>
 <!--BC0A0ACE451A421CA2BC3DDD4FE76CD0-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_FIELDGROUP.xml	Wed Dec 12 14:51:47 2012 +0100
+++ b/src-db/database/sourcedata/AD_FIELDGROUP.xml	Wed Dec 12 16:41:23 2012 +0100
@@ -378,6 +378,15 @@
 <!--186B6172A38941CCA6F85C0852D82D18-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--186B6172A38941CCA6F85C0852D82D18--></AD_FIELDGROUP>
 
+<!--18E9C0CF3E0D4B008744301C2DAEC079--><AD_FIELDGROUP>
+<!--18E9C0CF3E0D4B008744301C2DAEC079-->  <AD_FIELDGROUP_ID><![CDATA[18E9C0CF3E0D4B008744301C2DAEC079]]></AD_FIELDGROUP_ID>
+<!--18E9C0CF3E0D4B008744301C2DAEC079-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--18E9C0CF3E0D4B008744301C2DAEC079-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--18E9C0CF3E0D4B008744301C2DAEC079-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--18E9C0CF3E0D4B008744301C2DAEC079-->  <NAME><![CDATA[Location Settings]]></NAME>
+<!--18E9C0CF3E0D4B008744301C2DAEC079-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--18E9C0CF3E0D4B008744301C2DAEC079--></AD_FIELDGROUP>
+
 <!--1F959EBBBFF64AA18E975D1AD70C1588--><AD_FIELDGROUP>
 <!--1F959EBBBFF64AA18E975D1AD70C1588-->  <AD_FIELDGROUP_ID><![CDATA[1F959EBBBFF64AA18E975D1AD70C1588]]></AD_FIELDGROUP_ID>
 <!--1F959EBBBFF64AA18E975D1AD70C1588-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_MESSAGE.xml	Wed Dec 12 14:51:47 2012 +0100
+++ b/src-db/database/sourcedata/AD_MESSAGE.xml	Wed Dec 12 16:41:23 2012 +0100
@@ -18149,6 +18149,17 @@
 <!--7E3E5C3B752A4026A78ADDFA826E4A1C-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--7E3E5C3B752A4026A78ADDFA826E4A1C--></AD_MESSAGE>
 
+<!--7F28FD8C7EDA46D2A2816407790740F9--><AD_MESSAGE>
+<!--7F28FD8C7EDA46D2A2816407790740F9-->  <AD_MESSAGE_ID><![CDATA[7F28FD8C7EDA46D2A2816407790740F9]]></AD_MESSAGE_ID>
+<!--7F28FD8C7EDA46D2A2816407790740F9-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--7F28FD8C7EDA46D2A2816407790740F9-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--7F28FD8C7EDA46D2A2816407790740F9-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--7F28FD8C7EDA46D2A2816407790740F9-->  <VALUE><![CDATA[InvalidDateTimeFormat]]></VALUE>
+<!--7F28FD8C7EDA46D2A2816407790740F9-->  <MSGTEXT><![CDATA[Invalid Date Time Format.]]></MSGTEXT>
+<!--7F28FD8C7EDA46D2A2816407790740F9-->  <MSGTYPE><![CDATA[E]]></MSGTYPE>
+<!--7F28FD8C7EDA46D2A2816407790740F9-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--7F28FD8C7EDA46D2A2816407790740F9--></AD_MESSAGE>
+
 <!--7FD28F8FE35B492FA9200FF14D0A7749--><AD_MESSAGE>
 <!--7FD28F8FE35B492FA9200FF14D0A7749-->  <AD_MESSAGE_ID><![CDATA[7FD28F8FE35B492FA9200FF14D0A7749]]></AD_MESSAGE_ID>
 <!--7FD28F8FE35B492FA9200FF14D0A7749-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -19564,6 +19575,17 @@
 <!--ADAF53CF368D4956BDFF326A9361C750-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--ADAF53CF368D4956BDFF326A9361C750--></AD_MESSAGE>
 
+<!--ADF79F75D79A4556900B1C1C8F86BCBA--><AD_MESSAGE>
+<!--ADF79F75D79A4556900B1C1C8F86BCBA-->  <AD_MESSAGE_ID><![CDATA[ADF79F75D79A4556900B1C1C8F86BCBA]]></AD_MESSAGE_ID>
+<!--ADF79F75D79A4556900B1C1C8F86BCBA-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--ADF79F75D79A4556900B1C1C8F86BCBA-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--ADF79F75D79A4556900B1C1C8F86BCBA-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--ADF79F75D79A4556900B1C1C8F86BCBA-->  <VALUE><![CDATA[InvalidNumericMask]]></VALUE>
+<!--ADF79F75D79A4556900B1C1C8F86BCBA-->  <MSGTEXT><![CDATA[Numeric Mask contains illegal values.]]></MSGTEXT>
+<!--ADF79F75D79A4556900B1C1C8F86BCBA-->  <MSGTYPE><![CDATA[E]]></MSGTYPE>
+<!--ADF79F75D79A4556900B1C1C8F86BCBA-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--ADF79F75D79A4556900B1C1C8F86BCBA--></AD_MESSAGE>
+
 <!--ADF8BF150C894C2D94A6A0AFE89E2843--><AD_MESSAGE>
 <!--ADF8BF150C894C2D94A6A0AFE89E2843-->  <AD_MESSAGE_ID><![CDATA[ADF8BF150C894C2D94A6A0AFE89E2843]]></AD_MESSAGE_ID>
 <!--ADF8BF150C894C2D94A6A0AFE89E2843-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -20105,6 +20127,17 @@
 <!--BDBAEDC585EA4D06BACC9E2469003E4F-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--BDBAEDC585EA4D06BACC9E2469003E4F--></AD_MESSAGE>
 
+<!--BEE3D8398A804644A3298F2D7F1E23F1--><AD_MESSAGE>
+<!--BEE3D8398A804644A3298F2D7F1E23F1-->  <AD_MESSAGE_ID><![CDATA[BEE3D8398A804644A3298F2D7F1E23F1]]></AD_MESSAGE_ID>
+<!--BEE3D8398A804644A3298F2D7F1E23F1-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--BEE3D8398A804644A3298F2D7F1E23F1-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--BEE3D8398A804644A3298F2D7F1E23F1-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--BEE3D8398A804644A3298F2D7F1E23F1-->  <VALUE><![CDATA[InvalidDateFormat]]></VALUE>
+<!--BEE3D8398A804644A3298F2D7F1E23F1-->  <MSGTEXT><![CDATA[Invalid Date Format.]]></MSGTEXT>
+<!--BEE3D8398A804644A3298F2D7F1E23F1-->  <MSGTYPE><![CDATA[E]]></MSGTYPE>
+<!--BEE3D8398A804644A3298F2D7F1E23F1-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--BEE3D8398A804644A3298F2D7F1E23F1--></AD_MESSAGE>
+
 <!--BF4C881E6E67457BA335A07AE90627F5--><AD_MESSAGE>
 <!--BF4C881E6E67457BA335A07AE90627F5-->  <AD_MESSAGE_ID><![CDATA[BF4C881E6E67457BA335A07AE90627F5]]></AD_MESSAGE_ID>
 <!--BF4C881E6E67457BA335A07AE90627F5-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_REFERENCE.xml	Wed Dec 12 14:51:47 2012 +0100
+++ b/src-db/database/sourcedata/AD_REFERENCE.xml	Wed Dec 12 16:41:23 2012 +0100
@@ -4352,6 +4352,19 @@
 <!--22F546D49D3A48E1B2B4F50446A8DE58-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
 <!--22F546D49D3A48E1B2B4F50446A8DE58--></AD_REFERENCE>
 
+<!--279F05C514AB40868B83484C11DD4A01--><AD_REFERENCE>
+<!--279F05C514AB40868B83484C11DD4A01-->  <AD_REFERENCE_ID><![CDATA[279F05C514AB40868B83484C11DD4A01]]></AD_REFERENCE_ID>
+<!--279F05C514AB40868B83484C11DD4A01-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--279F05C514AB40868B83484C11DD4A01-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--279F05C514AB40868B83484C11DD4A01-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--279F05C514AB40868B83484C11DD4A01-->  <NAME><![CDATA[Decimal Separator]]></NAME>
+<!--279F05C514AB40868B83484C11DD4A01-->  <DESCRIPTION><![CDATA[Decimal separator values]]></DESCRIPTION>
+<!--279F05C514AB40868B83484C11DD4A01-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--279F05C514AB40868B83484C11DD4A01-->  <ISBASEREFERENCE><![CDATA[N]]></ISBASEREFERENCE>
+<!--279F05C514AB40868B83484C11DD4A01-->  <PARENTREFERENCE_ID><![CDATA[17]]></PARENTREFERENCE_ID>
+<!--279F05C514AB40868B83484C11DD4A01-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
+<!--279F05C514AB40868B83484C11DD4A01--></AD_REFERENCE>
+
 <!--27A729423DEE4023B8B799377CB19D11--><AD_REFERENCE>
 <!--27A729423DEE4023B8B799377CB19D11-->  <AD_REFERENCE_ID><![CDATA[27A729423DEE4023B8B799377CB19D11]]></AD_REFERENCE_ID>
 <!--27A729423DEE4023B8B799377CB19D11-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_REF_LIST.xml	Wed Dec 12 14:51:47 2012 +0100
+++ b/src-db/database/sourcedata/AD_REF_LIST.xml	Wed Dec 12 16:41:23 2012 +0100
@@ -8817,6 +8817,17 @@
 <!--427088D82ABA49D484FC3B90AD82F59F-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--427088D82ABA49D484FC3B90AD82F59F--></AD_REF_LIST>
 
+<!--42AAAC5E8DF04DBFB74127A1753833B9--><AD_REF_LIST>
+<!--42AAAC5E8DF04DBFB74127A1753833B9-->  <AD_REF_LIST_ID><![CDATA[42AAAC5E8DF04DBFB74127A1753833B9]]></AD_REF_LIST_ID>
+<!--42AAAC5E8DF04DBFB74127A1753833B9-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--42AAAC5E8DF04DBFB74127A1753833B9-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--42AAAC5E8DF04DBFB74127A1753833B9-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--42AAAC5E8DF04DBFB74127A1753833B9-->  <VALUE><![CDATA[D]]></VALUE>
+<!--42AAAC5E8DF04DBFB74127A1753833B9-->  <NAME><![CDATA[.]]></NAME>
+<!--42AAAC5E8DF04DBFB74127A1753833B9-->  <AD_REFERENCE_ID><![CDATA[279F05C514AB40868B83484C11DD4A01]]></AD_REFERENCE_ID>
+<!--42AAAC5E8DF04DBFB74127A1753833B9-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--42AAAC5E8DF04DBFB74127A1753833B9--></AD_REF_LIST>
+
 <!--433A48943CF34C978A7E5759A35B4D88--><AD_REF_LIST>
 <!--433A48943CF34C978A7E5759A35B4D88-->  <AD_REF_LIST_ID><![CDATA[433A48943CF34C978A7E5759A35B4D88]]></AD_REF_LIST_ID>
 <!--433A48943CF34C978A7E5759A35B4D88-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -10947,6 +10958,17 @@
 <!--C102A96C20C44BA6BAAD322E999633A3-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--C102A96C20C44BA6BAAD322E999633A3--></AD_REF_LIST>
 
+<!--C1168BDB1F1D44FC91A20F13888B237A--><AD_REF_LIST>
+<!--C1168BDB1F1D44FC91A20F13888B237A-->  <AD_REF_LIST_ID><![CDATA[C1168BDB1F1D44FC91A20F13888B237A]]></AD_REF_LIST_ID>
+<!--C1168BDB1F1D44FC91A20F13888B237A-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--C1168BDB1F1D44FC91A20F13888B237A-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--C1168BDB1F1D44FC91A20F13888B237A-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--C1168BDB1F1D44FC91A20F13888B237A-->  <VALUE><![CDATA[C]]></VALUE>
+<!--C1168BDB1F1D44FC91A20F13888B237A-->  <NAME><![CDATA[,]]></NAME>
+<!--C1168BDB1F1D44FC91A20F13888B237A-->  <AD_REFERENCE_ID><![CDATA[279F05C514AB40868B83484C11DD4A01]]></AD_REFERENCE_ID>
+<!--C1168BDB1F1D44FC91A20F13888B237A-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--C1168BDB1F1D44FC91A20F13888B237A--></AD_REF_LIST>
+
 <!--C25D4CC0A8A6492EBA94B7992DF77F71--><AD_REF_LIST>
 <!--C25D4CC0A8A6492EBA94B7992DF77F71-->  <AD_REF_LIST_ID><![CDATA[C25D4CC0A8A6492EBA94B7992DF77F71]]></AD_REF_LIST_ID>
 <!--C25D4CC0A8A6492EBA94B7992DF77F71-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src/org/openbravo/erpCommon/utility/Utility.java	Wed Dec 12 14:51:47 2012 +0100
+++ b/src/org/openbravo/erpCommon/utility/Utility.java	Wed Dec 12 16:41:23 2012 +0100
@@ -85,6 +85,9 @@
 import org.openbravo.model.ad.ui.Window;
 import org.openbravo.model.ad.utility.Image;
 import org.openbravo.model.common.enterprise.Organization;
+import org.openbravo.model.common.enterprise.OrganizationInformation;
+import org.openbravo.model.common.geography.Country;
+import org.openbravo.model.common.geography.Location;
 import org.openbravo.uiTranslation.TranslationHandler;
 import org.openbravo.utils.FileUtility;
 import org.openbravo.utils.FormatUtilities;
@@ -2500,4 +2503,62 @@
     final String ua = request.getHeader("User-Agent").toLowerCase();
     return (ua.matches(MOBILE_VENDORS) || ua.substring(0, 4).matches(MOBILE_VERSION));
   }
+
+  /**
+   * Gets the date format for the organization country.
+   * 
+   * 
+   * @return date with the country format string applied. In case is not defined, a default format
+   *         is applied
+   */
+  public static String applyCountryDateFormat(Date date, String orgid) {
+    try {
+      OBContext.setAdminMode(true);
+      Organization organization = (Organization) OBDal.getInstance().get(Organization.ENTITY_NAME,
+          orgid);
+      List<OrganizationInformation> orgInfoList = organization.getOrganizationInformationList();
+      OrganizationInformation orginfo = orgInfoList.get(0);
+      Location location = orginfo.getLocationAddress();
+      Country country = location.getCountry();
+      String dateFormat = (country.getDateformat() == null) ? "dd-MM-yyyy" : country
+          .getDateformat();
+      SimpleDateFormat df = new SimpleDateFormat(dateFormat);
+      return df.format(date);
+    } finally {
+      OBContext.restorePreviousMode();
+    }
+  }
+
+  /**
+   * Gets the number format for the organization country.
+   * 
+   * 
+   * @return DecimalFormat for the number representation defined for the country.
+   */
+  public static DecimalFormat getCountryNumberFormat(String orgid,
+      DecimalFormat defaultDecimalFormat) {
+    try {
+      OBContext.setAdminMode(true);
+      Organization organization = (Organization) OBDal.getInstance().get(Organization.ENTITY_NAME,
+          orgid);
+      List<OrganizationInformation> orgInfoList = organization.getOrganizationInformationList();
+      OrganizationInformation orginfo = orgInfoList.get(0);
+      Location location = orginfo.getLocationAddress();
+      Country country = location.getCountry();
+      if (country.getNumericmask() != null) {
+        DecimalFormatSymbols symbols = new DecimalFormatSymbols();
+        if (country.getDecimalseparator() != null)
+          symbols.setDecimalSeparator(country.getDecimalseparator().equals("C") ? ',' : '.');
+        if (country.getGroupingseparator() != null)
+          symbols.setGroupingSeparator(country.getGroupingseparator().equals("C") ? ',' : '.');
+        DecimalFormat numberFormat = new DecimalFormat(country.getNumericmask());
+        numberFormat.setDecimalFormatSymbols(symbols);
+        return numberFormat;
+      } else {
+        return defaultDecimalFormat;
+      }
+    } finally {
+      OBContext.restorePreviousMode();
+    }
+  }
 }