# HG changeset patch
# User Mario Castello <mario.castello@peoplewalking.com>
# Date 1488299182 21600
#      mar feb 28 10:26:22 2017 -0600
# Node ID d2afef777bcb38f5c172107e0a4b1ddea2a6d9ef
# Parent  c04938eafe0f8067af8fcad75f5ea21a7dfacac6
Fixed issue 0035364: [SER-QA 2472] Columns startingcash, totalsales, totalreturns, amounttokeep must by not null and default 0

- Set default value 0 for columns startingcash, totalsales, totalreturns, amounttokeep

diff --git a/src-db/database/model/tables/OBPOS_PAYMENTMETHODCASHUP.xml b/src-db/database/model/tables/OBPOS_PAYMENTMETHODCASHUP.xml
--- a/src-db/database/model/tables/OBPOS_PAYMENTMETHODCASHUP.xml
+++ b/src-db/database/model/tables/OBPOS_PAYMENTMETHODCASHUP.xml
@@ -38,15 +38,15 @@
         <onCreateDefault/>
       </column>
       <column name="STARTINGCASH" primaryKey="false" required="true" type="DECIMAL" autoIncrement="false">
-        <default/>
+        <default><![CDATA[0]]></default>
         <onCreateDefault/>
       </column>
       <column name="TOTALSALES" primaryKey="false" required="true" type="DECIMAL" autoIncrement="false">
-        <default/>
+        <default><![CDATA[0]]></default>
         <onCreateDefault/>
       </column>
       <column name="TOTALRETURNS" primaryKey="false" required="true" type="DECIMAL" autoIncrement="false">
-        <default/>
+        <default><![CDATA[0]]></default>
         <onCreateDefault/>
       </column>
       <column name="RATE" primaryKey="false" required="true" type="DECIMAL" autoIncrement="false">
@@ -61,8 +61,8 @@
         <default/>
         <onCreateDefault/>
       </column>
-      <column name="AMOUNTTOKEEP" primaryKey="false" required="false" type="DECIMAL" autoIncrement="false">
-        <default/>
+      <column name="AMOUNTTOKEEP" primaryKey="false" required="true" type="DECIMAL" autoIncrement="false">
+        <default><![CDATA[0]]></default>
         <onCreateDefault/>
       </column>
       <column name="AD_CLIENT_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
diff --git a/src-db/database/sourcedata/AD_COLUMN.xml b/src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml
+++ b/src-db/database/sourcedata/AD_COLUMN.xml
@@ -3250,6 +3250,7 @@
 <!--258CA86F4480423C8EAFAC55C0655300-->  <AD_TABLE_ID><![CDATA[DBCD072881ED4F6199659347F39645EA]]></AD_TABLE_ID>
 <!--258CA86F4480423C8EAFAC55C0655300-->  <AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID>
 <!--258CA86F4480423C8EAFAC55C0655300-->  <FIELDLENGTH><![CDATA[10]]></FIELDLENGTH>
+<!--258CA86F4480423C8EAFAC55C0655300-->  <DEFAULTVALUE><![CDATA[0]]></DEFAULTVALUE>
 <!--258CA86F4480423C8EAFAC55C0655300-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--258CA86F4480423C8EAFAC55C0655300-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--258CA86F4480423C8EAFAC55C0655300-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
@@ -12699,9 +12700,10 @@
 <!--D77B643C109947C1AEB7B61D5D667CE6-->  <AD_TABLE_ID><![CDATA[DBCD072881ED4F6199659347F39645EA]]></AD_TABLE_ID>
 <!--D77B643C109947C1AEB7B61D5D667CE6-->  <AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID>
 <!--D77B643C109947C1AEB7B61D5D667CE6-->  <FIELDLENGTH><![CDATA[10]]></FIELDLENGTH>
+<!--D77B643C109947C1AEB7B61D5D667CE6-->  <DEFAULTVALUE><![CDATA[0]]></DEFAULTVALUE>
 <!--D77B643C109947C1AEB7B61D5D667CE6-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--D77B643C109947C1AEB7B61D5D667CE6-->  <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--D77B643C109947C1AEB7B61D5D667CE6-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--D77B643C109947C1AEB7B61D5D667CE6-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
 <!--D77B643C109947C1AEB7B61D5D667CE6-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
 <!--D77B643C109947C1AEB7B61D5D667CE6-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
 <!--D77B643C109947C1AEB7B61D5D667CE6-->  <SEQNO><![CDATA[160]]></SEQNO>
@@ -13010,6 +13012,7 @@
 <!--DC439C74106745A1A63B851CCC3F33BA-->  <AD_TABLE_ID><![CDATA[DBCD072881ED4F6199659347F39645EA]]></AD_TABLE_ID>
 <!--DC439C74106745A1A63B851CCC3F33BA-->  <AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID>
 <!--DC439C74106745A1A63B851CCC3F33BA-->  <FIELDLENGTH><![CDATA[10]]></FIELDLENGTH>
+<!--DC439C74106745A1A63B851CCC3F33BA-->  <DEFAULTVALUE><![CDATA[0]]></DEFAULTVALUE>
 <!--DC439C74106745A1A63B851CCC3F33BA-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--DC439C74106745A1A63B851CCC3F33BA-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--DC439C74106745A1A63B851CCC3F33BA-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
@@ -15310,6 +15313,7 @@
 <!--FE365D6C36DD41ECBF0C0738217C14B5-->  <AD_TABLE_ID><![CDATA[DBCD072881ED4F6199659347F39645EA]]></AD_TABLE_ID>
 <!--FE365D6C36DD41ECBF0C0738217C14B5-->  <AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID>
 <!--FE365D6C36DD41ECBF0C0738217C14B5-->  <FIELDLENGTH><![CDATA[10]]></FIELDLENGTH>
+<!--FE365D6C36DD41ECBF0C0738217C14B5-->  <DEFAULTVALUE><![CDATA[0]]></DEFAULTVALUE>
 <!--FE365D6C36DD41ECBF0C0738217C14B5-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--FE365D6C36DD41ECBF0C0738217C14B5-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--FE365D6C36DD41ECBF0C0738217C14B5-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>