Loan Statements

Hi All,

Im trying to produce loan statement (For AZ Loans) which should include the information as below. Among this, how do i take the Interest changes during the statement period. Also, i would like to know if there is any table apart from AZ.ACCT.BAL where all the transactions related to the AZ Account gets stored so that i can get it from that particular table and display it in the statement below: Please help me out..... !!!



LOGO (CLIENT NAME)
ADDRESS 1
ADDRESS 2 STATEMENT OF ACCOUNT


CUST NAME DATE:
CUST ADDRESS PAGE:
CUST COUNTRY AGREEMENT NO:
CURRENT RATE:
OVERDUE PAYMENTS:

JOINT CUSTOMER:

INTEREST CHANGES DURING STATEMENT PERIOD:

DATE REFERENCE DEBIT CREDIT BALANCE












BALANCE OUTSTANDING:
CHARGES OUTSTANDING:
TOTAL OUTSTANDING:
As at <<Date>>





Thanks in advance,

Lakshmi