

update T_MRP_PLANPROENTRY set FISMRPOPERAT ='0' where FISMRPOPERAT ='';

update T_MRP_PLANPROGRAM set fisyield ='0' where fisyield ='';

update T_MRP_PLANPROGRAM set fislossrate ='0' where fislossrate ='';

update T_MRP_PLANPROGRAM set fismps ='0' where fismps ='';

update T_MRP_PLANPROGRAM set fismrp ='0' where fismrp ='';

update T_MRP_PLANPROGRAM set fisreorderpoint ='0' where fisreorderpoint ='';

update T_MRP_PLANPROGRAM set fisadjust ='0' where fisadjust ='';

update T_MRP_PLANPROGRAM set fisreplace ='0' where fisreplace ='';

update T_MRP_PLANPROGRAM set fisreserve ='0' where fisreserve ='';

update T_MRP_PLANPROGRAM set fconsiderbatchstr ='0' where fconsiderbatchstr ='';

update T_MRP_PLANPROGRAM set fissafestock ='0' where fissafestock ='';

update T_MRP_PLANPROGRAM set fstockreserve ='0' where fstockreserve ='';

update T_MRP_PLANPROSCENTRY set fisscmrpoperat ='0' where fisscmrpoperat ='';