Total interest earned from MM contract

Hi

I have a doubt in MM module.

I have created a MM contract and rolled over frequently with auto roll over and auto capitalisation option. Finally my contract will get matured and during that time or before maturity I want to know how much interest my contact has been earned at the time of maturity or earlier.

Do we have any table where system update accrual interest (which is not hit on account as we have auto capitalisation)?


Eg:

Contract id Principal Amt Interest Amt Value date Maturity Date auto roll over auto capitalisation
MMXXXXX1 1000 100 01 Jan 2013 01 Jan 2014 Yes Yes
MMXXXXX1 1000+100 110 01 Jan 2014 01 Jan 2015 Yes Yes
MMXXXXX1 1000+100+110 120 01 Jan 2015 01 Jan 2016 No No


The above case, interest 120 will hit on account but remaining interest 100 and 110 will hit on account along with principal amount.

Where do I check my contact has been earned totally interest amount 330 (100 + 110 + 120) ?

You can get it using below command:

LIST FXXX.LMM.ACCOUNT.BALANCES WITH @ID EQ 'MMXXXXXXXXXX00' EVAL "SUM(INT.AMT.TODATE)"