enquiry on overdraft.

Hi ALL,
Can anyone help me out with this. i need to create a enquiry which will have a list of overdraft account number and with total no of overdraft account.
2. the debt remain outstanding for 30 day or more beyond the schedule payment or maturity but less than 90 day.
3. the account fail to show debit balance.
4. the account has been inactive for more than 30 day but less than 30 day.

the only thing i need to from which application i can get all these detail.

Thanks,

If I were you I'd start with ACCOUNT.OVERDRAWN table.

DATE.FIRST.OD field contains the date the account went into OD. You can use that to calculate the number of days the account has been in OD since (use CDD)
Number 2 sounds more like a loan issue than an overdraft issue. But still, with CDD you can cluster the account by number of days OD
3. I don't understand the requirement
4. Check ACCOUNT.INACTIVE file and use CDD to calculate the days

Could you provide following info?

What is the application used for overdraft accounts? AC or AA
Which release of T24?