select
	 convert(varchar,ftr.ftrtime,120) ftrtime
	,dsr.descr dsr_descr
	,ftr.tradecode
	,ftr.totlamount
	,ptr.codeid ptr_id
	,ptr.descr ptr_descr
	,cus.code cus_code
	,cus.name cus_name
from 
	fintrade ftr
	left join customer cus on ftr.cusid=cus.id and ftr.comid=cus.comid
	left join paymentterms ptr on ftr.ptrid=ptr.codeid and ftr.comid=ptr.comid
	left join docseries dsr on ftr.dsrid=dsr.codeid and ftr.comid=dsr.comid and ftr.braid=dsr.braid
where
	ftr.ftrdate=:ftrdate
	and ftr.braid=:braid
	and ftr.ftridpayment is null
	and ftr.source=5
	and ftr.ptrid is not null
	and ftr.lamount > 1
	and dsr.dsridpmt is not null
	and ftr.comid=:comid
	and iscancelled=0