Select Code to Download

                
TranID  Date        AccNum   Type    Amount ChequeNo DDNo  
657520  02-07-1999  0181432  Debit   16000  465774     
...
657541  11-07-1999  0181432  Debit   12000  
657525  03-07-1999  0181432  Debit   15000           569999
657533  05-07-1999  0181432  Credit  12500  

#!/usr/bin/perl
use DBI;
...
 print "$rec\n";
}
$dbh->disconnect;

1) Query data from transaction table and calculate the total  balance 
+in each account
2) Query data from transaction table and calculate total amount debite
+d by cheque, dd and by cash for each account.