-- 单据模板调整后，单据状态中的 F 和 G 要调换。先换成别的值，再改成跟模板一致。（新：F-已废弃，G-待重新提交；旧的与之相反）
update t_hpdi_bizdatabill set fbillstatus='FF' where fbillstatus='F'  and fcreatetime < {ts'2022-08-25  00:00:00'};
update t_hpdi_bizdatabill set fbillstatus='GG' where fbillstatus='G'  and fcreatetime < {ts'2022-08-25  00:00:00'};

update t_hpdi_bizdatabill set fbillstatus='G', fdescription  = 'old data update for F TO G'  where fbillstatus='FF' and fcreatetime < {ts'2022-08-25  00:00:00'};
update t_hpdi_bizdatabill set fbillstatus='F', fdescription  = 'old data update for G TO F'  where fbillstatus='GG' and fcreatetime < {ts'2022-08-25  00:00:00'};