FDT = DATE(2015,4,1)
TDT = DATE(2016,3,31)

DCONDI = "VOUCHER.ACCODE = 650 AND VOUCHER.ACHEAD IN(4351,4353,4354) AND BILLMAST.DT >= FDT AND BILLMAST.DT <= TDT"




SELECT  VOUCHER.ACCODE,VOUCHER.ACHEAD,VOUCHER.ACNO,;
SUM(Voucher.DR) AS DR FROM VOUCHER INNER JOIN BILLMAST ;
ON VOUCHER.LP = BILLMAST.LP ;
WHERE  voucher.elink=0 and voucher.ck1=0 and voucher.ck2=0 and ;
&DCONDI GROUP BY VOUCHER.acno ORDER BY VOUCHER.acno INTO CURSOR TEMPSTP

SELECT TEMPSTP.ACNO, TEMPSTP.DR, deposit.intlamt ;
FROM TEMPSTP INNER JOIN DEPOSIT ON TEMPSTP.ACNO = DEPOSIT.ACCODE ;
ORDER BY TEMPSTP.ACNO INTO CURSOR TEMPSTP1


***WITHOUT MNO

SELECT ACNO , SUM(DR) AS DR,SUM(intlamt) AS DPAMT ;
FROM TEMPSTP1 GROUP BY ACNO  into cursor stp

select acmast.account as mno, acmast.name,acmast.prelation,acmast.pname,;
acmast.add,acmast.add1,acmast.add2,acmast.add3,acmast.add4,acmast.add5,;
acmast.phone,acmast.mobile,acmast.pan, stp.dr as totint,stp.dpamt as totdeposit;
from acmast inner join stp ;
on acmast.accode = stp.ACNO ;
WHERE ACMAST.MNO = 0 ;
order by acmast.pfix,acmast.vcno,acmast.sfix;
into cursor stpoint


RETURN 




SELECT ACMAST.ACCODE,TEMPSTP1.DR, TEMPSTP1.intlamt AS DPAMT , ACMAST.MEMHEAD,ACMAST.MNO ;
FROM TEMPSTP1 INNER JOIN ACMAST  ON TEMPSTP1.ACNO = ACMAST.ACCODE ;
WHERE ACMAST.MNO <> 0 ;
ORDER BY TEMPSTP1.ACNO INTO CURSOR TEMPSTP2


SELECT MNO , SUM(DR) AS DR,SUM(DPAMT ) AS DPAMT ;
FROM TEMPSTP2 GROUP BY MNO into cursor stp


select acmast.account as mno, acmast.name,acmast.prelation,acmast.pname,;
acmast.add,acmast.add1,acmast.add2,acmast.add3,acmast.add4,acmast.add5,;
acmast.phone,acmast.mobile,acmast.pan, stp.dr as totint,stp.dpamt as totdeposit;
from acmast inner join stp ;
on acmast.accode = stp.mno ;
where stp.dr >=50000 ;
order by acmast.pfix,acmast.vcno,acmast.sfix;
into cursor stpoint