diff --git a/src-db/database/model/tables/FIN_PAYMENT_PROP_DETAIL.xml b/src-db/database/model/tables/FIN_PAYMENT_PROP_DETAIL.xml
--- a/src-db/database/model/tables/FIN_PAYMENT_PROP_DETAIL.xml
+++ b/src-db/database/model/tables/FIN_PAYMENT_PROP_DETAIL.xml
@@ -68,5 +68,8 @@
       <foreign-key foreignTable="FIN_PAYMENT_SCHEDULEDETAIL" name="FIN_PAYMENTSCHDET_PROP_DETAIL">
         <reference local="FIN_PAYMENT_SCHEDULEDETAIL_ID" foreign="FIN_PAYMENT_SCHEDULEDETAIL_ID"/>
       </foreign-key>
+      <index name="FIN_PAYMENT_PROP_DETAIL_SCDET" unique="false">
+        <index-column name="FIN_PAYMENT_SCHEDULEDETAIL_ID"/>
+      </index>
     </table>
   </database>
