-- 差旅报销单
update T_ER_ReimburseBill set finvokeinvoicecloud = '1' where fid in (select T.billid from (select T1.fid billid from T_ER_ReimburseBill T1 where exists (select 1 from t_er_invoiceinfo T2 where T2.finvoicefrom = '1' and T2.fid=T1.fid)) T);
-- 费用报销单
update t_er_dailyreimbursebill set finvokeinvoicecloud = '1' where fid in (select T.billid from (select T1.fid billid from t_er_dailyreimbursebill T1 where exists (select 1 from t_er_invoiceinfo T2 where T2.finvoicefrom = '1' and T2.fid=T1.fid)) T);
-- 对公报销单
update t_er_pubreimbill set finvokeinvoicecloud = '1' where fid in (select T.billid from (select T1.fid billid from t_er_pubreimbill T1 where exists (select 1 from t_er_pubreiminvoiceinfo T2 where T2.finvoicefrom = '1' and T2.fid=T1.fid)) T);
-- 商旅付款申请单
update t_er_checkingpay set finvokeinvoicecloud = '1' where fid in (select T.billid from (select T1.fid billid from t_er_checkingpay T1 where exists (select 1 from t_er_invoiceinfocp T2 where T2.finvoicefrom = '1' and T2.fid=T1.fid)) T);