-- 更新历史客户银行账户性质，客户伙伴类型为个人4的，账户性质为个人1
update T_BD_CUSTOMERBANK set FACCOUNTPROPERTY = '1' where fid in (select fid from t_bd_customer where ftype = '4');
-- 更新历史供应商银行账户性质，供应商伙伴类型为个人4的，账户性质为个人1
update t_bd_supplierbank set FACCOUNTPROPERTY = '1' where fid in (select fid from t_bd_supplier where ftype = '4');

