× Discuss about Archiving, Close of Business, Delivery Setup, Security Management System, Global Processing etc…

WHICH TABLE(S) CONTAIN LD/MM REPAYMENT

  • rsolapade
  • Topic Author
  • Visitor
  • Visitor
15 years 6 months ago #5029 by rsolapade
WHICH TABLE(S) CONTAIN LD/MM REPAYMENT was created by rsolapade
Hi All,
Which table(s) contain either the PRINCIPAL or INTEREST repayment for any contract that is active and paid i.e. in LD/MM which has not gone to PAST DUE. Although it will be in STMT.ENTRY table but it always grows and not advisable to use for reporting. And for sure any contract that has gone to Past Due i.e PD.PAYMENT.DUE when the Client fund his/her repayment account and after the COB the amount will be in PD.REPAYMENT which is a LIVE table.

Please Log in or Create an account to join the conversation.

More
15 years 6 months ago #5031 by deepak111
Replied by deepak111 on topic Re:WHICH TABLE(S) CONTAIN LD/MM REPAYMENT
Hello,

you can find it in LMM.HISTORY.LIST which will have prin/int repayment and other events based on LMM.ACTION.CODES


thanks
Deepak

Please Log in or Create an account to join the conversation.

  • rsolapade
  • Topic Author
  • Visitor
  • Visitor
15 years 6 months ago #5033 by rsolapade
Replied by rsolapade on topic Re:WHICH TABLE(S) CONTAIN LD/MM REPAYMENT
hi,

Thanks for your contribution. I will follow up with your suggestion.

kind rgds always

Please Log in or Create an account to join the conversation.

  • rsolapade
  • Topic Author
  • Visitor
  • Visitor
15 years 5 months ago #5058 by rsolapade
Replied by rsolapade on topic Re:WHICH TABLE(S) CONTAIN LD/MM REPAYMENT
Hi ALL,

Can I have more contributions from others please? Because the ONLY suggestion i got does not lead me to the answer/glue i am expecting.

My Regards to All

Please Log in or Create an account to join the conversation.

More
15 years 5 months ago #5066 by DUBLIN
Replied by DUBLIN on topic Re:WHICH TABLE(S) CONTAIN LD/MM REPAYMENT
LMM.SCHEDULES.PAST and LMM.SCHEDULES.PAST.HIST should help.

First one is for the Live deals that have had PR/IN payments up to today

Second one holds same details but for matured deals

They could be used for LD & MM deals.

Please Log in or Create an account to join the conversation.

Time to create page: 0.029 seconds