Related to Issue 0021802. Added Supplier Reference to Payment Proposal.
authorDavid Miguelez <david.miguelez@openbravo.com>
Thu, 15 Nov 2012 12:13:23 +0100
changeset 18553 f3a08810b2a9
parent 18552 ae4bf9ced9d3
child 18554 2c39d6a6c546
Related to Issue 0021802. Added Supplier Reference to Payment Proposal.
modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_PAYMENT_PROP_PICK_EDIT.xml
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml
--- a/modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_PAYMENT_PROP_PICK_EDIT.xml	Thu Nov 15 11:15:07 2012 +0100
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_PAYMENT_PROP_PICK_EDIT.xml	Thu Nov 15 12:13:23 2012 +0100
@@ -1,4 +1,4 @@
 <?xml version="1.0"?>
   <database name="VIEW APRM_PAYMENT_PROP_PICK_EDIT">
-    <view name="APRM_PAYMENT_PROP_PICK_EDIT"><![CDATA[SELECT psd.fin_payment_scheduledetail_id AS aprm_payment_prop_pick_edit_id, psd.ad_client_id, psd.ad_org_id, psd.isactive, psd.created, psd.updated, psd.createdby, psd.updatedby, psd.fin_payment_scheduledetail_id, ppd.fin_payment_proposal_id, o.documentno AS order_documentno, i.documentno AS invoice_documentno, COALESCE(i.fin_paymentmethod_id, o.fin_paymentmethod_id) AS fin_paymentmethod_id, COALESCE(i.c_bpartner_id, o.c_bpartner_id) AS c_bpartner_id, COALESCE(psi.duedate, pso.duedate) AS duedate, COALESCE(psi.expecteddate, pso.expecteddate) AS expecteddate, i.grandtotal AS invoiced, COALESCE(psi.amount, pso.amount) AS expected, psd.amount AS outstanding, COALESCE(ppd.amount, 0) AS payment, COALESCE(psd.amount - ppd.amount, psd.amount) AS difference,  CASE WHEN ppd.writeoffamt <> 0 THEN 'Y' ELSE 'N' END AS writeoff,  CASE WHEN ppd.fin_payment_scheduledetail_id IS NULL THEN 'N' ELSE 'Y' END AS ob_selected, COALESCE(psi.fin_payment_priority_id, pso.fin_payment_priority_id) AS fin_payment_priority_id, COALESCE(i.c_currency_id, o.c_currency_id) AS c_currency_id, COALESCE(i.issotrx, o.issotrx) AS issotrx FROM fin_payment_scheduledetail psd LEFT JOIN fin_payment_prop_detail ppd ON psd.fin_payment_scheduledetail_id = ppd.fin_payment_scheduledetail_id LEFT JOIN fin_payment_schedule psi ON psd.fin_payment_schedule_invoice = psi.fin_payment_schedule_id LEFT JOIN fin_payment_schedule pso ON psd.fin_payment_schedule_order = pso.fin_payment_schedule_id LEFT JOIN c_invoice i ON psi.c_invoice_id = i.c_invoice_id LEFT JOIN c_order o ON pso.c_order_id = o.c_order_id WHERE psd.fin_payment_detail_id IS NULL]]></view>
+    <view name="APRM_PAYMENT_PROP_PICK_EDIT"><![CDATA[SELECT psd.fin_payment_scheduledetail_id AS aprm_payment_prop_pick_edit_id, psd.ad_client_id, psd.ad_org_id, psd.isactive, psd.created, psd.updated, psd.createdby, psd.updatedby, psd.fin_payment_scheduledetail_id, ppd.fin_payment_proposal_id, o.documentno AS order_documentno, i.documentno AS invoice_documentno, i.poreference AS supplier_reference, COALESCE(i.fin_paymentmethod_id, o.fin_paymentmethod_id) AS fin_paymentmethod_id, COALESCE(i.c_bpartner_id, o.c_bpartner_id) AS c_bpartner_id, COALESCE(psi.duedate, pso.duedate) AS duedate, COALESCE(psi.expecteddate, pso.expecteddate) AS expecteddate, i.grandtotal AS invoiced, COALESCE(psi.amount, pso.amount) AS expected, psd.amount AS outstanding, COALESCE(ppd.amount, 0) AS payment, COALESCE(psd.amount - ppd.amount, psd.amount) AS difference,  CASE WHEN ppd.writeoffamt <> 0 THEN 'Y' ELSE 'N' END AS writeoff,  CASE WHEN ppd.fin_payment_scheduledetail_id IS NULL THEN 'N' ELSE 'Y' END AS ob_selected, COALESCE(psi.fin_payment_priority_id, pso.fin_payment_priority_id) AS fin_payment_priority_id, COALESCE(i.c_currency_id, o.c_currency_id) AS c_currency_id, COALESCE(i.issotrx, o.issotrx) AS issotrx FROM fin_payment_scheduledetail psd LEFT JOIN fin_payment_prop_detail ppd ON psd.fin_payment_scheduledetail_id = ppd.fin_payment_scheduledetail_id LEFT JOIN fin_payment_schedule psi ON psd.fin_payment_schedule_invoice = psi.fin_payment_schedule_id LEFT JOIN fin_payment_schedule pso ON psd.fin_payment_schedule_order = pso.fin_payment_schedule_id LEFT JOIN c_invoice i ON psi.c_invoice_id = i.c_invoice_id LEFT JOIN c_order o ON pso.c_order_id = o.c_order_id WHERE psd.fin_payment_detail_id IS NULL]]></view>
   </database>
--- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml	Thu Nov 15 11:15:07 2012 +0100
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml	Thu Nov 15 12:13:23 2012 +0100
@@ -2889,6 +2889,41 @@
 <!--806198F4784445109D9067A0C868701C-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--806198F4784445109D9067A0C868701C--></AD_COLUMN>
 
+<!--8071EA28ABEA4E1E919AD14F3EE5B033--><AD_COLUMN>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <AD_COLUMN_ID><![CDATA[8071EA28ABEA4E1E919AD14F3EE5B033]]></AD_COLUMN_ID>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <NAME><![CDATA[Supplier Reference]]></NAME>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <DESCRIPTION><![CDATA[A reference or document order number as listed in business partner application.]]></DESCRIPTION>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <HELP><![CDATA[This can be used to input a reference for this specific transaction. For example, a Purchase Order number can be input on a Sales Order for easier reference.]]></HELP>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <COLUMNNAME><![CDATA[Supplier_Reference]]></COLUMNNAME>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <AD_TABLE_ID><![CDATA[DC814AB3BC84486CA5411131724BC95A]]></AD_TABLE_ID>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <FIELDLENGTH><![CDATA[30]]></FIELDLENGTH>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <SEQNO><![CDATA[270]]></SEQNO>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <AD_ELEMENT_ID><![CDATA[952]]></AD_ELEMENT_ID>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <POSITION><![CDATA[13]]></POSITION>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--8071EA28ABEA4E1E919AD14F3EE5B033--></AD_COLUMN>
+
 <!--82EFB8E4043C19C9E040007F01003778--><AD_COLUMN>
 <!--82EFB8E4043C19C9E040007F01003778-->  <AD_COLUMN_ID><![CDATA[82EFB8E4043C19C9E040007F01003778]]></AD_COLUMN_ID>
 <!--82EFB8E4043C19C9E040007F01003778-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml	Thu Nov 15 11:15:07 2012 +0100
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml	Thu Nov 15 12:13:23 2012 +0100
@@ -2261,6 +2261,34 @@
 <!--324A4EA312D5489887BCD0B6F2C6A065-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--324A4EA312D5489887BCD0B6F2C6A065--></AD_FIELD>
 
+<!--3287F4B82C964ADAA98CF144A21719E2--><AD_FIELD>
+<!--3287F4B82C964ADAA98CF144A21719E2-->  <AD_FIELD_ID><![CDATA[3287F4B82C964ADAA98CF144A21719E2]]></AD_FIELD_ID>
+<!--3287F4B82C964ADAA98CF144A21719E2-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--3287F4B82C964ADAA98CF144A21719E2-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--3287F4B82C964ADAA98CF144A21719E2-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--3287F4B82C964ADAA98CF144A21719E2-->  <NAME><![CDATA[Supplier Reference]]></NAME>
+<!--3287F4B82C964ADAA98CF144A21719E2-->  <DESCRIPTION><![CDATA[A reference or document order number as listed in business partner application.]]></DESCRIPTION>
+<!--3287F4B82C964ADAA98CF144A21719E2-->  <HELP><![CDATA[This can be used to input a reference for this specific transaction. For example, a Purchase Order number can be input on a Sales Order for easier reference.]]></HELP>
+<!--3287F4B82C964ADAA98CF144A21719E2-->  <ISCENTRALLYMAINTAINED><![CDATA[N]]></ISCENTRALLYMAINTAINED>
+<!--3287F4B82C964ADAA98CF144A21719E2-->  <AD_TAB_ID><![CDATA[81644A22CC4D4B879AA71C33C30E00A4]]></AD_TAB_ID>
+<!--3287F4B82C964ADAA98CF144A21719E2-->  <AD_COLUMN_ID><![CDATA[8071EA28ABEA4E1E919AD14F3EE5B033]]></AD_COLUMN_ID>
+<!--3287F4B82C964ADAA98CF144A21719E2-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--3287F4B82C964ADAA98CF144A21719E2-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--3287F4B82C964ADAA98CF144A21719E2-->  <DISPLAYLENGTH><![CDATA[30]]></DISPLAYLENGTH>
+<!--3287F4B82C964ADAA98CF144A21719E2-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--3287F4B82C964ADAA98CF144A21719E2-->  <SEQNO><![CDATA[25]]></SEQNO>
+<!--3287F4B82C964ADAA98CF144A21719E2-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--3287F4B82C964ADAA98CF144A21719E2-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--3287F4B82C964ADAA98CF144A21719E2-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--3287F4B82C964ADAA98CF144A21719E2-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--3287F4B82C964ADAA98CF144A21719E2-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--3287F4B82C964ADAA98CF144A21719E2-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--3287F4B82C964ADAA98CF144A21719E2-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--3287F4B82C964ADAA98CF144A21719E2-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--3287F4B82C964ADAA98CF144A21719E2-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--3287F4B82C964ADAA98CF144A21719E2-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--3287F4B82C964ADAA98CF144A21719E2--></AD_FIELD>
+
 <!--331964ADAD6F4182BCB88287F89DBFE5--><AD_FIELD>
 <!--331964ADAD6F4182BCB88287F89DBFE5-->  <AD_FIELD_ID><![CDATA[331964ADAD6F4182BCB88287F89DBFE5]]></AD_FIELD_ID>
 <!--331964ADAD6F4182BCB88287F89DBFE5-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>