×
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
-
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.
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.
- deepak111
- Offline
- New Member
-
Less
More
- Posts: 11
- Thank you received: 0
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
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
-
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
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
-
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
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.
- DUBLIN
- Offline
- Elite Member
-
Less
More
- Posts: 202
- Thank you received: 29
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.
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