bufCategory.append("SELECT  qitems.SUPPLY, qfact.FACTNAME,qitems.GOODSNOS, qitems.GOODSNAME,qitems.PIC,");
			bufCategory.append("qitems.P0  ,qitems.COLORS,qitems.SIZES,qitems.UNIT2,sum( qitems.UNIT10) ,round( max(qitems.P1)*sum(qitems.UNIT10)),");
			bufCategory.append("sum(qitems.UNITPRICE*qitems.UNIT30) ,sum( qitems.UNIT30),");
			bufCategory.append("sum( qitems.UNIT10)-sum( qitems.UNIT30), round(sum( qitems.UNIT30)/ sum( qitems.UNIT10)*100)");
			bufCategory.append(" FROM qitems left join qfact on qitems.SUPPLY=qfact.FACTNO WHERE qitems.GOODSNOS");
			bufCategory.append(" in(select DISTINCT GOODSNOS from qitems where FORMDATE>='"+startDay+"' and FORMDATE<='"+endDay+"'  and UNIT10>0 )");
			bufCategory.append(" group by  qitems.SUPPLY, qitems.GOODSNOS, qitems.GOODSNAME,qitems.P0,qitems.PIC");
			bufCategory.append(" having sum( qitems.UNIT10)-sum( qitems.UNIT30)<10 and");
			bufCategory.append(" sum( qitems.UNIT30)>10 and sum( qitems.UNIT10)>10 and");
			bufCategory.append("  sum( qitems.UNIT30) / sum( qitems.UNIT10)>=0.5 ");
			bufCategory.append(" order by qitems.SUPPLY,GOODSNOS, sum( qitems.UNIT30) desc");


//QHEAD
delete from qhead where QKIND='20';
update qhead  set FINEDATE='' where FINEDATE isnull;
update qhead  set ORDDATE='' where ORDDATE isnull;
update qhead  set ATMDATE='';
update qhead set QKIND='30' where QKIND='31';
update qhead set ATM=0,TRCASH=0,PS='',PS1='',PS2='',BSUM=(ASUM-DISMONEY),DEPTNO='AA'

//QITEMS
delete from qitems where QKIND='20';
update qitems set PS='',ORDDATE='1',FINEDATE='',RATEPRICE=0,REALSUM=0,UNIT=0,DEPTNO='AA';
update qitems set UNIT10=0 where UNIT10 isnull;
update qitems set UNIT20=0 where UNIT20 isnull;
update qitems set UNIT30=0 where UNIT30 isnull;
update qitems set UNIT40=0 where UNIT40 isnull;
update qitems set QKIND='30' where QKIND='31';
update qitems set SOURCENO=replace(SOURCENO,'-','.') where SOURCENO like '%-%';
update qitems set GOODSNOS=GOODSNO ||  '-' || COLOR || '-' || SIZE;

//QDETAIL
update qdetail set PS='',UNIT=1,PICTURE='',BILL='000000000000',ATLIST=INLIST;
update qdetail set SOURCENO=replace(SOURCENO,'-','.') where SOURCENO like '%-%';

//QCUST
//UPDATE  qcust SET DEPTNO='AA'
//QFACT
UPDATE  qfact SET DEPTNO='AA'


Before to Trans File
update DP000 set ARS=0 where ARS is null ;
update DP000 set CASH=0 where CASH is null ;
update DP000 set VISA=0 where VISA is null ;
update DP000 set PAYED=0 where PAYED is null ;
update DP000 set DISMONEY=0 where DISMONEY is null ;