| 解决方案： |
--经检查发现升级后ap_detail表中的部分科目丢失了，将821数据库(UFDATA_002_2006)中的ap_detail表导入到861版本中的数据库（UFDATA_001_2006）中另存为ap_detail1，根据对应关系更新即可。 select * into UFDATA_001_2006..ap_detail1 from UFDATA_002_2006..ap_detail where iperiod=0 and cflag='ar'
use UFDATA_001_2006
update ap_detail set ccode=ap_detail1.ccode from ap_detail1, ap_detail where ap_detail.auto_id=ap_detail1.auto_id and ap_detail.iperiod=0 and ap_detail.cflag='ar'
update ap_detail set idamount=ap_detail1.idamount,idamount_f=ap_detail1.idamount_f,icamount=ap_detail1.icamount,icamount_f =ap_detail1.icamount_f from ap_detail1, ap_detail where ap_detail.auto_id=ap_detail1.auto_id and ap_detail.iperiod=0 and ap_detail.cflag='ar'
drop table ap_detail1 |