--升级余额调节表截止时间
UPDATE T_CAS_BANKBALANCEADJUST T SET FBIZDATE=(SELECT FENDDATE FROM T_BD_PERIOD WHERE FID=T.FPERIODID) WHERE T.FBANKACCOUNTNUMBER='BANKACCOUNTNUMBER' AND T.FPERIODID!=0;
UPDATE T_CAS_BANKBALANCEADJUST T SET FBILLSTATUS='C' WHERE T.FBANKACCOUNTNUMBER='BANKACCOUNTNUMBER' AND T.FPERIODID!=0 AND T.FBILLSTATUS='B';

--银行日记账单据编号升级
UPDATE T_CAS_CASHJOURNAL SET FBILLNO=FSOURCEBILLNUMBER;