金蝶K3转T3然后升级T+19.0

用友软件（15209

exec('update UFDATA_003_2023..gl_mend set bflag=0 where iperiod<>0')
go
exec('delete from UFDATA_003_2023..gl_accsum')
go
exec('delete from UFDATA_003_2023..gl_accass')
go
exec('delete from UFDATA_003_2023..gl_accvouch')
go
exec('delete from UFDATA_003_2023..ForeignCurrency where cexch_name<>''人民币''')
go
exec('insert into UFDATA_003_2023..ForeignCurrency(cexch_name,cexch_code,bcal,idec,nerror)select FName as cexch_name,FNumber as cexch_code,case FOperator when ''*'' then 1 when ''/'' then 0 end as bcal,FScale as idec,0.00001 as nerror from a..t_Currency where FNumber<>''*'' and FCurrencyID not like (select FValue from a..t_SystemProfile where FDescription like ''本位币'')')
go

使用转换工具提示截断字符

yuwen007cn

金蝶K3转T3，提示截断数据，是某些字段内容过长，比如摘要，不影响数据的