select t1.fid,t2.fnumber,t2.fname_l2,t2.fid,t1.fbiztypeid
from t_scm_transbiztype t1
inner join T_SCM_TransactionType t2 on t1.ftransactiontypeid=t2.fid
where t1.fbiztypeid is null
select * from T_SCM_TransBizType where fid ='iplnz3jlRAuqgl8NqREaVVFkgBY='
and ftransactiontypeid='3NQCJgEdEADgADkrwKgR3bAI3Kc='
select * from t_scm_transbiztype where fbiztypeid is null
select * from t_scm_transbiztype where fbiztypeid='N5d2igEgEADgAABywKg/GiQHQ1w='
跨期入库-待检入库冲销
update t_scm_transbiztype set fbiztypeid='N5d2igEgEADgAABywKg/GiQHQ1w=' where ftransactiontypeid in (select fid from t_scm_transactiontype where fnumber='GP906')
from t_scm_transbiztype t1
inner join T_SCM_TransactionType t2 on t1.ftransactiontypeid=t2.fid
where t1.fbiztypeid is null
select * from T_SCM_TransBizType where fid ='iplnz3jlRAuqgl8NqREaVVFkgBY='
and ftransactiontypeid='3NQCJgEdEADgADkrwKgR3bAI3Kc='
select * from t_scm_transbiztype where fbiztypeid is null
select * from t_scm_transbiztype where fbiztypeid='N5d2igEgEADgAABywKg/GiQHQ1w='
跨期入库-待检入库冲销
update t_scm_transbiztype set fbiztypeid='N5d2igEgEADgAABywKg/GiQHQ1w=' where ftransactiontypeid in (select fid from t_scm_transactiontype where fnumber='GP906')