details:   /erp/devel/pi-engdev/rev/8358cc90c6e5
changeset: 6455:8358cc90c6e5
user:      Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
date:      Mon Feb 22 13:26:54 2010 +0100
summary:   Added FIN_ScheduleDetail table.Updated related windows.

diffstat:

 src-db/database/model/functions/FIN_GEN_PAYMENTSCHEDULE_INV.xml |     7 +-
 src-db/database/model/tables/FIN_PAYMENT_DETAIL.xml             |     7 -
 src-db/database/model/tables/FIN_PAYMENT_SCHEDULEDETAIL.xml     |    72 +
 src-db/database/model/views/FIN_PAYMENT_DETAIL_V.xml            |    23 +-
 src-db/database/model/views/FIN_PAYMENT_SCHEDULE_V.xml          |    10 -
 src-db/database/model/views/FIN_PAYMENT_SCHED_INV_V.xml         |    23 +
 src-db/database/model/views/FIN_PAYMENT_SCHED_ORD_V.xml         |    23 +
 src-db/database/sourcedata/AD_COLUMN.xml                        |  1499 
+++++++++-
 src-db/database/sourcedata/AD_ELEMENT.xml                       |   115 +-
 src-db/database/sourcedata/AD_FIELD.xml                         |   261 +
 src-db/database/sourcedata/AD_REFERENCE.xml                     |    44 +
 src-db/database/sourcedata/AD_REF_TABLE.xml                     |    46 +
 src-db/database/sourcedata/AD_TABLE.xml                         |    48 +-
 13 files changed, 1998 insertions(+), 180 deletions(-)

diffs (truncated from 2481 to 300 lines):

diff -r c53b04c85dd4 -r 8358cc90c6e5 
src-db/database/model/functions/FIN_GEN_PAYMENTSCHEDULE_INV.xml
--- a/src-db/database/model/functions/FIN_GEN_PAYMENTSCHEDULE_INV.xml   Thu Feb 
18 16:37:58 2010 +0100
+++ b/src-db/database/model/functions/FIN_GEN_PAYMENTSCHEDULE_INV.xml   Mon Feb 
22 13:26:54 2010 +0100
@@ -184,11 +184,10 @@
       v_count NUMBER;
       v_paymentno VARCHAR2(40);
     BEGIN
-      SELECT count(*), max(p.documentno)
+      SELECT count(*), max(pd.paymentno)
         INTO v_count, v_paymentno
-      FROM fin_payment_schedule ps, fin_payment_detail pd, fin_payment p
-      WHERE ps.fin_payment_schedule_id = pd.fin_payment_schedule_id
-        AND pd.fin_payment_id = p.fin_payment_id
+      FROM fin_payment_schedule ps, fin_payment_detail_v pd
+      WHERE ps.fin_payment_schedule_id = pd.fin_payment_schedule_invoice
         AND ps.c_invoice_id = p_record_id;
       IF (v_count <> 0) THEN
         RAISE_APPLICATION_ERROR(-20000, '@InvoiceWithPayments@' || ' ' || 
v_paymentno);
diff -r c53b04c85dd4 -r 8358cc90c6e5 
src-db/database/model/tables/FIN_PAYMENT_DETAIL.xml
--- a/src-db/database/model/tables/FIN_PAYMENT_DETAIL.xml       Thu Feb 18 
16:37:58 2010 +0100
+++ b/src-db/database/model/tables/FIN_PAYMENT_DETAIL.xml       Mon Feb 22 
13:26:54 2010 +0100
@@ -33,10 +33,6 @@
         <default/>
         <onCreateDefault/>
       </column>
-      <column name="FIN_PAYMENT_SCHEDULE_ID" primaryKey="false" 
required="true" type="VARCHAR" size="32" autoIncrement="false">
-        <default/>
-        <onCreateDefault/>
-      </column>
       <column name="AMOUNT" primaryKey="false" required="true" type="DECIMAL" 
autoIncrement="false">
         <default><![CDATA[0]]></default>
         <onCreateDefault/>
@@ -69,8 +65,5 @@
       <foreign-key foreignTable="C_GLITEM" name="FIN_PAYMENT_DETAIL_C_GLITEM">
         <reference local="C_GLITEM_ID" foreign="C_GLITEM_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="FIN_PAYMENT_SCHEDULE" 
name="FIN_PAYMENT_SCHEDULE_DETAIL">
-        <reference local="FIN_PAYMENT_SCHEDULE_ID" 
foreign="FIN_PAYMENT_SCHEDULE_ID"/>
-      </foreign-key>
     </table>
   </database>
diff -r c53b04c85dd4 -r 8358cc90c6e5 
src-db/database/model/tables/FIN_PAYMENT_SCHEDULEDETAIL.xml
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/src-db/database/model/tables/FIN_PAYMENT_SCHEDULEDETAIL.xml       Mon Feb 
22 13:26:54 2010 +0100
@@ -0,0 +1,72 @@
+<?xml version="1.0"?>
+  <database name="TABLE FIN_PAYMENT_SCHEDULEDETAIL">
+    <table name="FIN_PAYMENT_SCHEDULEDETAIL" 
primaryKey="FIN_PAYMENT_SCHEDULEDETAIL_KEY">
+      <column name="FIN_PAYMENT_SCHEDULEDETAIL_ID" primaryKey="true" 
required="true" type="VARCHAR" size="32" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
+      <column name="AD_CLIENT_ID" primaryKey="false" required="true" 
type="VARCHAR" size="32" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
+      <column name="AD_ORG_ID" primaryKey="false" required="true" 
type="VARCHAR" size="32" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
+      <column name="CREATED" primaryKey="false" required="true" 
type="TIMESTAMP" size="7" autoIncrement="false">
+        <default><![CDATA[SYSDATE]]></default>
+        <onCreateDefault/>
+      </column>
+      <column name="CREATEDBY" primaryKey="false" required="true" 
type="VARCHAR" size="32" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
+      <column name="UPDATED" primaryKey="false" required="true" 
type="TIMESTAMP" size="7" autoIncrement="false">
+        <default><![CDATA[SYSDATE]]></default>
+        <onCreateDefault/>
+      </column>
+      <column name="UPDATEDBY" primaryKey="false" required="true" 
type="VARCHAR" size="32" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
+      <column name="FIN_PAYMENT_DETAIL_ID" primaryKey="false" required="true" 
type="VARCHAR" size="32" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
+      <column name="FIN_PAYMENT_SCHEDULE_ORDER" primaryKey="false" 
required="true" type="VARCHAR" size="32" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
+      <column name="FIN_PAYMENT_SCHEDULE_INVOICE" primaryKey="false" 
required="true" type="VARCHAR" size="32" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
+      <column name="AMOUNT" primaryKey="false" required="true" type="DECIMAL" 
autoIncrement="false">
+        <default><![CDATA[0]]></default>
+        <onCreateDefault/>
+      </column>
+      <column name="ISACTIVE" primaryKey="false" required="false" type="CHAR" 
size="1" autoIncrement="false">
+        <default><![CDATA[Y]]></default>
+        <onCreateDefault/>
+      </column>
+      <column name="WRITEOFFAMT" primaryKey="false" required="false" 
type="DECIMAL" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
+      <foreign-key foreignTable="AD_CLIENT" 
name="FIN_AD_CLIENT_SCHEDULEDETAIL">
+        <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
+      </foreign-key>
+      <foreign-key foreignTable="AD_ORG" name="FIN_AD_ORG_SCHEDULEDETAIL">
+        <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
+      </foreign-key>
+      <foreign-key foreignTable="FIN_PAYMENT_DETAIL" 
name="FIN_PAYMENT_SCHEDULEDETAIL">
+        <reference local="FIN_PAYMENT_DETAIL_ID" 
foreign="FIN_PAYMENT_DETAIL_ID"/>
+      </foreign-key>
+      <foreign-key foreignTable="FIN_PAYMENT_SCHEDULE" 
name="FIN_PAYMENT_SCHINV_SCHDETAIL">
+        <reference local="FIN_PAYMENT_SCHEDULE_INVOICE" 
foreign="FIN_PAYMENT_SCHEDULE_ID"/>
+      </foreign-key>
+      <foreign-key foreignTable="FIN_PAYMENT_SCHEDULE" 
name="FIN_PAYMENT_SCHORD_SCHDETAIL">
+        <reference local="FIN_PAYMENT_SCHEDULE_ORDER" 
foreign="FIN_PAYMENT_SCHEDULE_ID"/>
+      </foreign-key>
+    </table>
+  </database>
diff -r c53b04c85dd4 -r 8358cc90c6e5 
src-db/database/model/views/FIN_PAYMENT_DETAIL_V.xml
--- a/src-db/database/model/views/FIN_PAYMENT_DETAIL_V.xml      Thu Feb 18 
16:37:58 2010 +0100
+++ b/src-db/database/model/views/FIN_PAYMENT_DETAIL_V.xml      Mon Feb 22 
13:26:54 2010 +0100
@@ -1,6 +1,23 @@
 <?xml version="1.0"?>
   <database name="VIEW FIN_PAYMENT_DETAIL_V">
-    <view name="FIN_PAYMENT_DETAIL_V"><![CDATA[SELECT pd.fin_payment_detail_id 
AS fin_payment_detail_v_id, pd.ad_client_id, pd.ad_org_id, pd.isactive, 
pd.created, pd.createdby, pd.updated, pd.updatedby, pd.fin_payment_schedule_id 
AS fin_payment_schedule_v_id, p.paymentdate, p.fin_paymentmethod_id, pd.amount, 
p.c_currency_id, p.documentno AS payment
-   FROM fin_payment p, fin_payment_detail pd
-  WHERE pd.fin_payment_id = p.fin_payment_id]]></view>
+    <view name="FIN_PAYMENT_DETAIL_V"><![CDATA[SELECT 
psd.fin_payment_scheduledetail_id AS fin_payment_detail_v_id,
+    psd.ad_client_id, psd.ad_org_id, psd.isactive,
+    psd.created, psd.createdby, psd.updated, psd.updatedby,
+    psi.fin_payment_sched_inv_v_id as fin_payment_sched_inv_v_id, 
+    pso.fin_payment_sched_ord_v_id as fin_payment_sched_ord_v_id,
+    i.documentno AS invoiceno, o.documentno as orderno, p.documentno as 
paymentno,
+    pd.fin_payment_id,
+    COALESCE(psi.duedate, pso.duedate) as duedate,
+    COALESCE(i.grandtotal, o.grandtotal) as invoicedamt,
+    COALESCE(psi.expected, pso.expected) AS expected, psd.amount AS paidamt,
+    p.c_bpartner_id, p.fin_paymentmethod_id, p.fin_financial_account_id,
+    p.c_currency_id, p.paymentdate
+ FROM fin_payment p, fin_payment_detail pd,
+      fin_payment_scheduledetail psd
+          LEFT JOIN fin_payment_sched_inv_v psi ON 
psd.fin_payment_schedule_invoice = psi.fin_payment_sched_inv_v_id
+          LEFT JOIN c_invoice i ON psi.c_invoice_id = i.c_invoice_id
+          LEFT JOIN fin_payment_sched_ord_v pso ON 
psd.fin_payment_schedule_order = pso.fin_payment_sched_ord_v_id
+          LEFT JOIN c_order o ON pso.c_order_id = o.c_order_id
+  WHERE p.fin_payment_id = pd.fin_payment_id
+    AND pd.fin_payment_detail_id = psd.fin_payment_detail_id]]></view>
   </database>
diff -r c53b04c85dd4 -r 8358cc90c6e5 
src-db/database/model/views/FIN_PAYMENT_SCHEDULE_V.xml
--- a/src-db/database/model/views/FIN_PAYMENT_SCHEDULE_V.xml    Thu Feb 18 
16:37:58 2010 +0100
+++ /dev/null   Thu Jan 01 00:00:00 1970 +0000
@@ -1,10 +0,0 @@
-<?xml version="1.0"?>
-  <database name="VIEW FIN_PAYMENT_SCHEDULE_V">
-    <view name="FIN_PAYMENT_SCHEDULE_V"><![CDATA[SELECT 
ps.fin_payment_schedule_id AS fin_payment_schedule_v_id, ps.ad_client_id, 
ps.ad_org_id, ps.isactive, ps.created, ps.createdby, ps.updated, ps.updatedby, 
ps.c_invoice_id, ps.duedate, ps.fin_paymentmethod_id, ps.amount AS expected, 
ps.paidamt AS received, ps.outstandingamt AS outstanding, ps.c_currency_id, ( 
SELECT max(p.paymentdate) AS max
-           FROM fin_payment p
-      LEFT JOIN fin_payment_detail pd ON pd.fin_payment_id = p.fin_payment_id
-     WHERE pd.fin_payment_schedule_id = ps.fin_payment_schedule_id) AS 
lastpayment, ( SELECT count(*) AS count
-           FROM fin_payment_detail pd
-          WHERE pd.fin_payment_schedule_id = ps.fin_payment_schedule_id) AS 
numberofpayments
-   FROM fin_payment_schedule ps]]></view>
-  </database>
diff -r c53b04c85dd4 -r 8358cc90c6e5 
src-db/database/model/views/FIN_PAYMENT_SCHED_INV_V.xml
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/src-db/database/model/views/FIN_PAYMENT_SCHED_INV_V.xml   Mon Feb 22 
13:26:54 2010 +0100
@@ -0,0 +1,23 @@
+<?xml version="1.0"?>
+  <database name="VIEW FIN_PAYMENT_SCHED_INV_V">
+    <view name="FIN_PAYMENT_SCHED_INV_V"><![CDATA[SELECT 
ps.fin_payment_schedule_id AS fin_payment_sched_inv_v_id,
+    ps.ad_client_id, ps.ad_org_id, ps.isactive,
+    ps.created, ps.createdby, ps.updated, ps.updatedby,
+    ps.c_invoice_id, ps.c_order_id,
+    ps.duedate, ps.fin_paymentmethod_id, ps.amount AS expected, ps.paidamt AS 
received, 
+    ps.outstandingamt AS outstanding, ps.c_currency_id, 
+    (SELECT max(p.paymentdate) AS max
+     FROM fin_payment p
+          LEFT JOIN fin_payment_detail pd ON pd.fin_payment_id = 
p.fin_payment_id
+          LEFT JOIN fin_payment_scheduledetail psd ON pd.fin_payment_detail_id 
= psd.fin_payment_detail_id
+     WHERE ps.c_invoice_id is not null
+       AND psd.fin_payment_schedule_invoice = ps.fin_payment_schedule_id
+     ) AS lastpayment,
+   (SELECT count(*) AS count
+    FROM fin_payment_detail pd, fin_payment_scheduledetail psd
+    WHERE pd.fin_payment_detail_id = psd.fin_payment_detail_id
+      AND ps.c_invoice_id is not null
+      AND psd.fin_payment_schedule_invoice = ps.fin_payment_schedule_id
+    ) AS numberofpayments
+ FROM fin_payment_schedule ps]]></view>
+  </database>
diff -r c53b04c85dd4 -r 8358cc90c6e5 
src-db/database/model/views/FIN_PAYMENT_SCHED_ORD_V.xml
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/src-db/database/model/views/FIN_PAYMENT_SCHED_ORD_V.xml   Mon Feb 22 
13:26:54 2010 +0100
@@ -0,0 +1,23 @@
+<?xml version="1.0"?>
+  <database name="VIEW FIN_PAYMENT_SCHED_ORD_V">
+    <view name="FIN_PAYMENT_SCHED_ORD_V"><![CDATA[SELECT 
ps.fin_payment_schedule_id AS fin_payment_sched_ord_v_id,
+    ps.ad_client_id, ps.ad_org_id, ps.isactive,
+    ps.created, ps.createdby, ps.updated, ps.updatedby,
+    ps.c_invoice_id, ps.c_order_id,
+    ps.duedate, ps.fin_paymentmethod_id, ps.amount AS expected, ps.paidamt AS 
received, 
+    ps.outstandingamt AS outstanding, ps.c_currency_id, 
+    (SELECT max(p.paymentdate) AS max
+     FROM fin_payment p
+          LEFT JOIN fin_payment_detail pd ON pd.fin_payment_id = 
p.fin_payment_id
+          LEFT JOIN fin_payment_scheduledetail psd ON pd.fin_payment_detail_id 
= psd.fin_payment_detail_id
+     WHERE ps.c_order_id is not null 
+       AND psd.fin_payment_schedule_order = ps.fin_payment_schedule_id
+     ) AS lastpayment,
+    (SELECT count(*) AS count
+     FROM fin_payment_detail pd, fin_payment_scheduledetail psd
+     WHERE pd.fin_payment_detail_id = psd.fin_payment_detail_id
+       AND ps.c_order_id is not null 
+       AND psd.fin_payment_schedule_order = ps.fin_payment_schedule_id
+     ) AS numberofpayments
+ FROM fin_payment_schedule ps]]></view>
+  </database>
diff -r c53b04c85dd4 -r 8358cc90c6e5 src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml  Thu Feb 18 16:37:58 2010 +0100
+++ b/src-db/database/sourcedata/AD_COLUMN.xml  Mon Feb 22 13:26:54 2010 +0100
@@ -249103,37 +249103,6 @@
 <!--379FB64EDAE34511BF519A46C721394C-->  
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
 <!--379FB64EDAE34511BF519A46C721394C--></AD_COLUMN>
 
-<!--386B15D6252B4CA4A64A0B086A6573B2--><AD_COLUMN>
-<!--386B15D6252B4CA4A64A0B086A6573B2-->  
<AD_COLUMN_ID><![CDATA[386B15D6252B4CA4A64A0B086A6573B2]]></AD_COLUMN_ID>
-<!--386B15D6252B4CA4A64A0B086A6573B2-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--386B15D6252B4CA4A64A0B086A6573B2-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--386B15D6252B4CA4A64A0B086A6573B2-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--386B15D6252B4CA4A64A0B086A6573B2-->  
<NAME><![CDATA[Fin_Payment_Schedule_V_ID]]></NAME>
-<!--386B15D6252B4CA4A64A0B086A6573B2-->  <DESCRIPTION><![CDATA[Set of payments 
planned to be collected/paid]]></DESCRIPTION>
-<!--386B15D6252B4CA4A64A0B086A6573B2-->  <HELP><![CDATA[Set of payments 
planned to be collected/paid]]></HELP>
-<!--386B15D6252B4CA4A64A0B086A6573B2-->  
<COLUMNNAME><![CDATA[Fin_Payment_Schedule_V_ID]]></COLUMNNAME>
-<!--386B15D6252B4CA4A64A0B086A6573B2-->  
<AD_TABLE_ID><![CDATA[DC63963AB3F1489BAAB5A9A7EFD1B407]]></AD_TABLE_ID>
-<!--386B15D6252B4CA4A64A0B086A6573B2-->  
<AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
-<!--386B15D6252B4CA4A64A0B086A6573B2-->  
<FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
-<!--386B15D6252B4CA4A64A0B086A6573B2-->  <ISKEY><![CDATA[N]]></ISKEY>
-<!--386B15D6252B4CA4A64A0B086A6573B2-->  <ISPARENT><![CDATA[Y]]></ISPARENT>
-<!--386B15D6252B4CA4A64A0B086A6573B2-->  
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
-<!--386B15D6252B4CA4A64A0B086A6573B2-->  
<ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
-<!--386B15D6252B4CA4A64A0B086A6573B2-->  
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
-<!--386B15D6252B4CA4A64A0B086A6573B2-->  <SEQNO><![CDATA[160]]></SEQNO>
-<!--386B15D6252B4CA4A64A0B086A6573B2-->  
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
-<!--386B15D6252B4CA4A64A0B086A6573B2-->  
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--386B15D6252B4CA4A64A0B086A6573B2-->  
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
-<!--386B15D6252B4CA4A64A0B086A6573B2-->  
<AD_ELEMENT_ID><![CDATA[78B98ED04531560FE040007F0101777C]]></AD_ELEMENT_ID>
-<!--386B15D6252B4CA4A64A0B086A6573B2-->  
<ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
-<!--386B15D6252B4CA4A64A0B086A6573B2-->  
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
-<!--386B15D6252B4CA4A64A0B086A6573B2-->  
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
-<!--386B15D6252B4CA4A64A0B086A6573B2-->  
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
-<!--386B15D6252B4CA4A64A0B086A6573B2-->  
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--386B15D6252B4CA4A64A0B086A6573B2-->  <POSITION><![CDATA[9]]></POSITION>
-<!--386B15D6252B4CA4A64A0B086A6573B2-->  
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
-<!--386B15D6252B4CA4A64A0B086A6573B2--></AD_COLUMN>
-
 <!--390B5858EEB44D1CA30EE290D277118A--><AD_COLUMN>
 <!--390B5858EEB44D1CA30EE290D277118A-->  
<AD_COLUMN_ID><![CDATA[390B5858EEB44D1CA30EE290D277118A]]></AD_COLUMN_ID>
 <!--390B5858EEB44D1CA30EE290D277118A-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -270493,35 +270462,6 @@
 <!--7891269C83F9655DE040007F010155CE-->  
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
 <!--7891269C83F9655DE040007F010155CE--></AD_COLUMN>
 
-<!--7891269C83FA655DE040007F010155CE--><AD_COLUMN>
-<!--7891269C83FA655DE040007F010155CE-->  
<AD_COLUMN_ID><![CDATA[7891269C83FA655DE040007F010155CE]]></AD_COLUMN_ID>
-<!--7891269C83FA655DE040007F010155CE-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--7891269C83FA655DE040007F010155CE-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--7891269C83FA655DE040007F010155CE-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--7891269C83FA655DE040007F010155CE-->  
<NAME><![CDATA[Fin_Payment_Schedule_ID]]></NAME>
-<!--7891269C83FA655DE040007F010155CE-->  
<COLUMNNAME><![CDATA[Fin_Payment_Schedule_ID]]></COLUMNNAME>
-<!--7891269C83FA655DE040007F010155CE-->  
<AD_TABLE_ID><![CDATA[5C77283492354D759049C14C9D4B7769]]></AD_TABLE_ID>
-<!--7891269C83FA655DE040007F010155CE-->  
<AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
-<!--7891269C83FA655DE040007F010155CE-->  
<FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
-<!--7891269C83FA655DE040007F010155CE-->  <ISKEY><![CDATA[N]]></ISKEY>
-<!--7891269C83FA655DE040007F010155CE-->  <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--7891269C83FA655DE040007F010155CE-->  
<ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
-<!--7891269C83FA655DE040007F010155CE-->  
<ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
-<!--7891269C83FA655DE040007F010155CE-->  
<ISIDENTIFIER><![CDATA[Y]]></ISIDENTIFIER>
-<!--7891269C83FA655DE040007F010155CE-->  <SEQNO><![CDATA[90]]></SEQNO>
-<!--7891269C83FA655DE040007F010155CE-->  
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
-<!--7891269C83FA655DE040007F010155CE-->  
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--7891269C83FA655DE040007F010155CE-->  
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
-<!--7891269C83FA655DE040007F010155CE-->  
<AD_ELEMENT_ID><![CDATA[78903669796E2CEFE040007F01013334]]></AD_ELEMENT_ID>
-<!--7891269C83FA655DE040007F010155CE-->  
<ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
-<!--7891269C83FA655DE040007F010155CE-->  
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
-<!--7891269C83FA655DE040007F010155CE-->  
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
-<!--7891269C83FA655DE040007F010155CE-->  
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
-<!--7891269C83FA655DE040007F010155CE-->  
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--7891269C83FA655DE040007F010155CE-->  <POSITION><![CDATA[9]]></POSITION>
-<!--7891269C83FA655DE040007F010155CE-->  
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
-<!--7891269C83FA655DE040007F010155CE--></AD_COLUMN>
-
 <!--7891269C83FB655DE040007F010155CE--><AD_COLUMN>
 <!--7891269C83FB655DE040007F010155CE-->  
<AD_COLUMN_ID><![CDATA[7891269C83FB655DE040007F010155CE]]></AD_COLUMN_ID>
 <!--7891269C83FB655DE040007F010155CE-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -271535,10 +271475,10 @@
 <!--78D10D5CC289A0ADE040007F010152E6-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--78D10D5CC289A0ADE040007F010152E6-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--78D10D5CC289A0ADE040007F010152E6-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--78D10D5CC289A0ADE040007F010152E6-->  
<NAME><![CDATA[Fin_Payment_Schedule_V_ID]]></NAME>
-<!--78D10D5CC289A0ADE040007F010152E6-->  <DESCRIPTION><![CDATA[Set of payments 
planned to be collected/paid]]></DESCRIPTION>
-<!--78D10D5CC289A0ADE040007F010152E6-->  <HELP><![CDATA[Set of payments 
planned to be collected/paid]]></HELP>
-<!--78D10D5CC289A0ADE040007F010152E6-->  
<COLUMNNAME><![CDATA[Fin_Payment_Schedule_V_ID]]></COLUMNNAME>

------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to