details: https://code.openbravo.com/erp/devel/pi/rev/f3a08810b2a9
changeset: 18553:f3a08810b2a9
user: David Miguelez <david.miguelez <at> openbravo.com>
date: Thu Nov 15 12:13:23 2012 +0100
summary: Related to Issue 0021802. Added Supplier Reference to Payment
Proposal.
diffstat:
modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_PAYMENT_PROP_PICK_EDIT.xml
| 2 +-
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml
| 35 ++++++++++
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml
| 28 ++++++++
3 files changed, 64 insertions(+), 1 deletions(-)
diffs (92 lines):
diff -r ae4bf9ced9d3 -r f3a08810b2a9
modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_PAYMENT_PROP_PICK_EDIT.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>
diff -r ae4bf9ced9d3 -r f3a08810b2a9
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml
---
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>
diff -r ae4bf9ced9d3 -r f3a08810b2a9
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml
---
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>
------------------------------------------------------------------------------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
