关于用友GRP-U8Cloud新国标2022资产类别升级说明【东莞用友GRP-U8软件】

select * from fa_kp kp where not exists(select 1 from fa_gdlb lb where lb.gsdm=kp.gsdm and lb.lbdm=kp.lbdm and lb.lbmc=kp.lbmc)

如上图，查出的这些卡片里的lbdm+lbmc存在问题，需先处理。 

select lbdm from (select lbdm,lbmc from fa_kp where gsdm not like 'a%' group by lbdm,lbmc) a group by lbdm having count(*)>1

此类数据也需处理。

select * from fa_kp kp where
not exists(select 1 from
(select gsdm,lbdm from fa_gdlb a where (select count(*) from fa_gdlb b where b.gsdm=a.gsdm and b.lbdm like a.lbdm+'%')=1) mxlb where mxlb.gsdm=kp.gsdm and mxlb.lbdm=kp.lbdm);

delete from fa_xjlbdzb where

gsdm<>'99999999999999999999';

insert into

fa_xjlbdzb(gsdm,lbdm_old,lbmc_old,lbdm_new,lbmc_new)
select a.gsdm,a.lbdm,a.lbmc,b.lbdm_new,c.lbmc

from
(select gsdm,lbdm,lbmc from fa_kp group by gsdm,lbdm,lbmc) a
left outer join (select * from fa_xjlbdzb where gsdm='99999999999999999999' --and ysgx in ('一对一','多对一')
and lbdm_old in (select lbdm_old from fa_xjlbdzb

where gsdm='99999999999999999999' and

lbdm_old is not null group by lbdm_old having

count(*)=1) --旧类别代码不能一对多

 ) b on b.lbdm_old=a.lbdm
left outer join (select * from fa_gdlb where

gsdm='99999999999999999999') c on

c.lbdm=b.lbdm_new
order by a.gsdm,a.lbdm;

select * from fa_xjlbdzb  where

gsdm<>'99999999999999999999' and lbdm_new

is null;
补充其中的lbdm_new和lbmc_new

执行脚本《FA_XJLBUpdateSet.sql》。FA_XJLBUpdateSet表中定义了需要更新的表和字段，可根据实际环境配置。
执行脚本《FA_XJLBUpdate.sql》。
执行存储过程：exec FA_XJLBUpdate。

delete from fa_gdlb where

gsdm<>'99999999999999999999';
INSERT INTO fa_gdlb (gsdm, lbdm, lbmc, yjnx, cjl,

jldw, jtss, zjff, kpys, Sjly, XEKZ, CYLBBZ,

MRSLWYBZ, ZCLX_DM, dylbdm, dylbmc, ZJM,

SYQDM)
select gs.gsdm, lbdm, lbmc, yjnx, cjl, jldw, jtss,

zjff, kpys, Sjly, XEKZ, CYLBBZ, MRSLWYBZ,

ZCLX_DM, dylbdm, dylbmc, ZJM, SYQDM from

fa_gdlb,
(select gsdm from PubModSetup where

modname='FAQC' and IsStart='1') gs

where fa_gdlb.gsdm='99999999999999999999';
update fa_ztcs set gdfj='3-2-2-2';