科目往来通知的变动

--备份数据

select * into bk0624_accountview from t_bd_accountview

--开启往来通知

一个个科目修改

Update t_bd_accountview set facnotice=1 where fid='获取需要修改科目ID ';

一个个组织修改：

Update t_bd_accountview set facnotice=1 where FCOMPANYID=(SELECT FID FROM T_ORG_BASEUNIT WHERE FNUMBER=’组织编码’) and fnumber IN ('科目编码1 ', '科目编码N ') and faccounttableid=(select fid from t_bd_accounttable where fname_l2=’科目表名称’)

--如何获