金蝶系统组织架构封存sql使用

select FIsSealUp from  t_org_admin where fnumber in ('XXXX')
select FIsSealUp from  T_ORG_CostCenter where fnumber in ('XXXX')
select FIsOUSealUp from  T_ORG_BaseUnit where fnumber in ('XXX')

update t_org_admin set FIsSealUp=1  where fnumber in ('XXXX');
update T_ORG_CostCenter set FIsSealUp=1  where fnumber in ('XXXX');
update T_ORG_BaseUnit set FIsOUSealUp=1  where fnumber in ('XXX');

select fnumber,fname_l2,flongnumber from t_org_admin where fnumber not in (select deptcode from tj_hr_department where eff_status='A') 
and FIsSealUp=0 
and fnumber not in (select fnumber from t_org_company)
and fname_l2 not like '%公共%'
order by flongnumber