UPDATE T_CAS_BANKJOURNAL SET FSOURCEBILLTYPE='cas_manualbankjournal' WHERE FSOURCEBILLTYPE='CAS_MANUALBANKJOURNAL' or FSOURCEBILLTYPE='cas_mbankbill';
UPDATE T_CAS_CASHJOURNAL SET FSOURCEBILLTYPE='cas_manualcashjournal' WHERE FSOURCEBILLTYPE='CAS_MANUALCASHJOURNAL' or FSOURCEBILLTYPE='cas_mcashbill';
UPDATE T_CAS_BANKJOURNAL SET FBILLSTATUS='C' WHERE FBILLSTATUS!='C';
UPDATE T_CAS_CASHJOURNAL SET FBILLSTATUS='C' WHERE FBILLSTATUS!='C';
