[Doubtful Debt] Moves field to APRM and creates new one. Fixes cumputed column for Doubtful Debt Amount
authorEduardo Argal Guibert <eduardo.argal@openbravo.com>
Tue, 22 Jan 2013 18:43:28 +0100
changeset 19572 0511cb8b8e4f
parent 19571 28d35fd3cae2
child 19573 c08987499bab
[Doubtful Debt] Moves field to APRM and creates new one. Fixes cumputed column for Doubtful Debt Amount
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml
src-db/database/sourcedata/AD_COLUMN.xml
src-db/database/sourcedata/AD_FIELD.xml
--- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml	Tue Jan 22 17:21:25 2013 +0100
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml	Tue Jan 22 18:43:28 2013 +0100
@@ -11346,6 +11346,35 @@
 <!--A46D79CAA09B4900953831DDF4D33B01-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--A46D79CAA09B4900953831DDF4D33B01--></AD_FIELD>
 
+<!--A4B9E4C5C952409F960726B59E72E24B--><AD_FIELD>
+<!--A4B9E4C5C952409F960726B59E72E24B-->  <AD_FIELD_ID><![CDATA[A4B9E4C5C952409F960726B59E72E24B]]></AD_FIELD_ID>
+<!--A4B9E4C5C952409F960726B59E72E24B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--A4B9E4C5C952409F960726B59E72E24B-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--A4B9E4C5C952409F960726B59E72E24B-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--A4B9E4C5C952409F960726B59E72E24B-->  <NAME><![CDATA[Doubtful Debt Amount]]></NAME>
+<!--A4B9E4C5C952409F960726B59E72E24B-->  <DESCRIPTION><![CDATA[Doubtful Debt Amount]]></DESCRIPTION>
+<!--A4B9E4C5C952409F960726B59E72E24B-->  <HELP><![CDATA[Doubtful Debt Amount]]></HELP>
+<!--A4B9E4C5C952409F960726B59E72E24B-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--A4B9E4C5C952409F960726B59E72E24B-->  <AD_TAB_ID><![CDATA[60825C9E68644DBC9C530DDCABE05A6E]]></AD_TAB_ID>
+<!--A4B9E4C5C952409F960726B59E72E24B-->  <AD_COLUMN_ID><![CDATA[2D56F14A0C524D8F95282389F1A45878]]></AD_COLUMN_ID>
+<!--A4B9E4C5C952409F960726B59E72E24B-->  <IGNOREINWAD><![CDATA[Y]]></IGNOREINWAD>
+<!--A4B9E4C5C952409F960726B59E72E24B-->  <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED>
+<!--A4B9E4C5C952409F960726B59E72E24B-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
+<!--A4B9E4C5C952409F960726B59E72E24B-->  <ISREADONLY><![CDATA[Y]]></ISREADONLY>
+<!--A4B9E4C5C952409F960726B59E72E24B-->  <SEQNO><![CDATA[220]]></SEQNO>
+<!--A4B9E4C5C952409F960726B59E72E24B-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--A4B9E4C5C952409F960726B59E72E24B-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--A4B9E4C5C952409F960726B59E72E24B-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--A4B9E4C5C952409F960726B59E72E24B-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--A4B9E4C5C952409F960726B59E72E24B-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--A4B9E4C5C952409F960726B59E72E24B-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--A4B9E4C5C952409F960726B59E72E24B-->  <GRID_SEQNO><![CDATA[10]]></GRID_SEQNO>
+<!--A4B9E4C5C952409F960726B59E72E24B-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--A4B9E4C5C952409F960726B59E72E24B-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--A4B9E4C5C952409F960726B59E72E24B-->  <ISSHOWNINSTATUSBAR><![CDATA[Y]]></ISSHOWNINSTATUSBAR>
+<!--A4B9E4C5C952409F960726B59E72E24B-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--A4B9E4C5C952409F960726B59E72E24B--></AD_FIELD>
+
 <!--A584E6F401174D8995EEE81F8C27C245--><AD_FIELD>
 <!--A584E6F401174D8995EEE81F8C27C245-->  <AD_FIELD_ID><![CDATA[A584E6F401174D8995EEE81F8C27C245]]></AD_FIELD_ID>
 <!--A584E6F401174D8995EEE81F8C27C245-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -14199,6 +14228,35 @@
 <!--C9767AB5EB9748919F4C569FF6FB3B96-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--C9767AB5EB9748919F4C569FF6FB3B96--></AD_FIELD>
 
+<!--CA04BD9C5119499EA6553CE24D7583D9--><AD_FIELD>
+<!--CA04BD9C5119499EA6553CE24D7583D9-->  <AD_FIELD_ID><![CDATA[CA04BD9C5119499EA6553CE24D7583D9]]></AD_FIELD_ID>
+<!--CA04BD9C5119499EA6553CE24D7583D9-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--CA04BD9C5119499EA6553CE24D7583D9-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--CA04BD9C5119499EA6553CE24D7583D9-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--CA04BD9C5119499EA6553CE24D7583D9-->  <NAME><![CDATA[Doubtful Debt Amount]]></NAME>
+<!--CA04BD9C5119499EA6553CE24D7583D9-->  <DESCRIPTION><![CDATA[Doubtful Debt Amount]]></DESCRIPTION>
+<!--CA04BD9C5119499EA6553CE24D7583D9-->  <HELP><![CDATA[Doubtful Debt Amount]]></HELP>
+<!--CA04BD9C5119499EA6553CE24D7583D9-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--CA04BD9C5119499EA6553CE24D7583D9-->  <AD_TAB_ID><![CDATA[15ECCF8974044A81982F57F9F1E1A67B]]></AD_TAB_ID>
+<!--CA04BD9C5119499EA6553CE24D7583D9-->  <AD_COLUMN_ID><![CDATA[2D56F14A0C524D8F95282389F1A45878]]></AD_COLUMN_ID>
+<!--CA04BD9C5119499EA6553CE24D7583D9-->  <IGNOREINWAD><![CDATA[Y]]></IGNOREINWAD>
+<!--CA04BD9C5119499EA6553CE24D7583D9-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--CA04BD9C5119499EA6553CE24D7583D9-->  <DISPLAYLENGTH><![CDATA[22]]></DISPLAYLENGTH>
+<!--CA04BD9C5119499EA6553CE24D7583D9-->  <ISREADONLY><![CDATA[Y]]></ISREADONLY>
+<!--CA04BD9C5119499EA6553CE24D7583D9-->  <SEQNO><![CDATA[115]]></SEQNO>
+<!--CA04BD9C5119499EA6553CE24D7583D9-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--CA04BD9C5119499EA6553CE24D7583D9-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--CA04BD9C5119499EA6553CE24D7583D9-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--CA04BD9C5119499EA6553CE24D7583D9-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--CA04BD9C5119499EA6553CE24D7583D9-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--CA04BD9C5119499EA6553CE24D7583D9-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--CA04BD9C5119499EA6553CE24D7583D9-->  <GRID_SEQNO><![CDATA[21]]></GRID_SEQNO>
+<!--CA04BD9C5119499EA6553CE24D7583D9-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--CA04BD9C5119499EA6553CE24D7583D9-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--CA04BD9C5119499EA6553CE24D7583D9-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--CA04BD9C5119499EA6553CE24D7583D9-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--CA04BD9C5119499EA6553CE24D7583D9--></AD_FIELD>
+
 <!--CA377E70DDF94717A95CDF5390BD0B5A--><AD_FIELD>
 <!--CA377E70DDF94717A95CDF5390BD0B5A-->  <AD_FIELD_ID><![CDATA[CA377E70DDF94717A95CDF5390BD0B5A]]></AD_FIELD_ID>
 <!--CA377E70DDF94717A95CDF5390BD0B5A-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Tue Jan 22 17:21:25 2013 +0100
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Tue Jan 22 18:43:28 2013 +0100
@@ -227580,7 +227580,7 @@
 <!--2D56F14A0C524D8F95282389F1A45878-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
 <!--2D56F14A0C524D8F95282389F1A45878-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
 <!--2D56F14A0C524D8F95282389F1A45878-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
-<!--2D56F14A0C524D8F95282389F1A45878-->  <SQLLOGIC><![CDATA[(SELECT coalesce(sum(psd.doubtfuldebt_amount), 0) FROM fin_payment_scheduledetail psd WHERE psd.fin_payment_schedule_invoice = fin_payment_schedule_id and psd.fin_payment_detail_id is null and psd.iscanceled='N')]]></SQLLOGIC>
+<!--2D56F14A0C524D8F95282389F1A45878-->  <SQLLOGIC><![CDATA[SELECT coalesce(sum(psd.doubtfuldebt_amount),0) FROM fin_payment_scheduledetail psd left join fin_payment_detail pd on psd.fin_payment_detail_id = pd.fin_payment_detail_id left join fin_payment p on pd.fin_payment_id = p.fin_payment_id WHERE psd.fin_payment_schedule_invoice = fin_payment_schedule_id and aprm_ispaymentconfirmed(p.status, psd.fin_payment_scheduledetail_id) = 'N']]></SQLLOGIC>
 <!--2D56F14A0C524D8F95282389F1A45878--></AD_COLUMN>
 
 <!--2D699F3974F64AFD8A48DC90748F4DBE--><AD_COLUMN>
--- a/src-db/database/sourcedata/AD_FIELD.xml	Tue Jan 22 17:21:25 2013 +0100
+++ b/src-db/database/sourcedata/AD_FIELD.xml	Tue Jan 22 18:43:28 2013 +0100
@@ -229735,35 +229735,6 @@
 <!--A4B393C7CFD541BB8529F4FDFD00315C-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--A4B393C7CFD541BB8529F4FDFD00315C--></AD_FIELD>
 
-<!--A4B9E4C5C952409F960726B59E72E24B--><AD_FIELD>
-<!--A4B9E4C5C952409F960726B59E72E24B-->  <AD_FIELD_ID><![CDATA[A4B9E4C5C952409F960726B59E72E24B]]></AD_FIELD_ID>
-<!--A4B9E4C5C952409F960726B59E72E24B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--A4B9E4C5C952409F960726B59E72E24B-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--A4B9E4C5C952409F960726B59E72E24B-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--A4B9E4C5C952409F960726B59E72E24B-->  <NAME><![CDATA[Doubtful Debt Amount]]></NAME>
-<!--A4B9E4C5C952409F960726B59E72E24B-->  <DESCRIPTION><![CDATA[Doubtful Debt Amount]]></DESCRIPTION>
-<!--A4B9E4C5C952409F960726B59E72E24B-->  <HELP><![CDATA[Doubtful Debt Amount]]></HELP>
-<!--A4B9E4C5C952409F960726B59E72E24B-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
-<!--A4B9E4C5C952409F960726B59E72E24B-->  <AD_TAB_ID><![CDATA[60825C9E68644DBC9C530DDCABE05A6E]]></AD_TAB_ID>
-<!--A4B9E4C5C952409F960726B59E72E24B-->  <AD_COLUMN_ID><![CDATA[2D56F14A0C524D8F95282389F1A45878]]></AD_COLUMN_ID>
-<!--A4B9E4C5C952409F960726B59E72E24B-->  <IGNOREINWAD><![CDATA[Y]]></IGNOREINWAD>
-<!--A4B9E4C5C952409F960726B59E72E24B-->  <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED>
-<!--A4B9E4C5C952409F960726B59E72E24B-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
-<!--A4B9E4C5C952409F960726B59E72E24B-->  <ISREADONLY><![CDATA[Y]]></ISREADONLY>
-<!--A4B9E4C5C952409F960726B59E72E24B-->  <SEQNO><![CDATA[220]]></SEQNO>
-<!--A4B9E4C5C952409F960726B59E72E24B-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
-<!--A4B9E4C5C952409F960726B59E72E24B-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
-<!--A4B9E4C5C952409F960726B59E72E24B-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--A4B9E4C5C952409F960726B59E72E24B-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
-<!--A4B9E4C5C952409F960726B59E72E24B-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
-<!--A4B9E4C5C952409F960726B59E72E24B-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--A4B9E4C5C952409F960726B59E72E24B-->  <GRID_SEQNO><![CDATA[10]]></GRID_SEQNO>
-<!--A4B9E4C5C952409F960726B59E72E24B-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
-<!--A4B9E4C5C952409F960726B59E72E24B-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
-<!--A4B9E4C5C952409F960726B59E72E24B-->  <ISSHOWNINSTATUSBAR><![CDATA[Y]]></ISSHOWNINSTATUSBAR>
-<!--A4B9E4C5C952409F960726B59E72E24B-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
-<!--A4B9E4C5C952409F960726B59E72E24B--></AD_FIELD>
-
 <!--A4BD6663B8DC4D448871790166C27AB8--><AD_FIELD>
 <!--A4BD6663B8DC4D448871790166C27AB8-->  <AD_FIELD_ID><![CDATA[A4BD6663B8DC4D448871790166C27AB8]]></AD_FIELD_ID>
 <!--A4BD6663B8DC4D448871790166C27AB8-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>