Fixes Issue 22094
authorDavid Miguelez <david.miguelez@openbravo.com>
Wed, 31 Oct 2012 18:32:08 +0100
changeset 429 8738436624e8
parent 428 86fea60fe2b4
child 430 3a7da6ca7a9c
Fixes Issue 22094
model/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml
model/src-db/database/model/tables/FIN_PAYMENT_SCHEDULE.xml
model/src-db/database/sourcedata/AD_COLUMN.xml
--- a/model/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml	Tue Oct 23 12:23:14 2012 +0200
+++ b/model/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml	Wed Oct 31 18:32:08 2012 +0100
@@ -4890,7 +4890,7 @@
 <!--93E0298CEA7A446B863D7D3456A1157E-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--93E0298CEA7A446B863D7D3456A1157E-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--93E0298CEA7A446B863D7D3456A1157E-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--93E0298CEA7A446B863D7D3456A1157E-->  <NAME><![CDATA[Expected Date]]></NAME>
+<!--93E0298CEA7A446B863D7D3456A1157E-->  <NAME><![CDATA[Due Date]]></NAME>
 <!--93E0298CEA7A446B863D7D3456A1157E-->  <DESCRIPTION><![CDATA[The date when a specified request must be carried out by.]]></DESCRIPTION>
 <!--93E0298CEA7A446B863D7D3456A1157E-->  <HELP><![CDATA[Date when the payment is due without deductions or discount]]></HELP>
 <!--93E0298CEA7A446B863D7D3456A1157E-->  <COLUMNNAME><![CDATA[Duedate]]></COLUMNNAME>
--- a/model/src-db/database/model/tables/FIN_PAYMENT_SCHEDULE.xml	Tue Oct 23 12:23:14 2012 +0200
+++ b/model/src-db/database/model/tables/FIN_PAYMENT_SCHEDULE.xml	Wed Oct 31 18:32:08 2012 +0100
@@ -37,9 +37,9 @@
         <default/>
         <onCreateDefault/>
       </column>
-      <column name="DUEDATE" primaryKey="false" required="false" type="TIMESTAMP" size="7" autoIncrement="false">
+      <column name="DUEDATE" primaryKey="false" required="true" type="TIMESTAMP" size="7" autoIncrement="false">
         <default/>
-        <onCreateDefault/>
+        <onCreateDefault><![CDATA[NOW()]]></onCreateDefault>
       </column>
       <column name="FIN_PAYMENTMETHOD_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
         <default/>
--- a/model/src-db/database/sourcedata/AD_COLUMN.xml	Tue Oct 23 12:23:14 2012 +0200
+++ b/model/src-db/database/sourcedata/AD_COLUMN.xml	Wed Oct 31 18:32:08 2012 +0100
@@ -252660,7 +252660,7 @@
 <!--7890366979612CEFE040007F01013334-->  <FIELDLENGTH><![CDATA[19]]></FIELDLENGTH>
 <!--7890366979612CEFE040007F01013334-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--7890366979612CEFE040007F01013334-->  <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--7890366979612CEFE040007F01013334-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--7890366979612CEFE040007F01013334-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
 <!--7890366979612CEFE040007F01013334-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
 <!--7890366979612CEFE040007F01013334-->  <ISIDENTIFIER><![CDATA[Y]]></ISIDENTIFIER>
 <!--7890366979612CEFE040007F01013334-->  <SEQNO><![CDATA[100]]></SEQNO>