| 解决方案： |
--修复科目表中的辅助核算标志与凭证表不相应的记录。
update gl_accvouch set cperson_id = null where ccode in (SELECT ccode FROM code WHERE (bperson = 0)) and cperson_id is not null
update gl_accvouch set ccus_id = null where ccode in (SELECT ccode FROM code WHERE (bcus = 0)) and ccus_id is not null
update gl_accvouch set csup_id = null where ccode in (SELECT ccode FROM code WHERE (bsup = 0)) and csup_id is not null
update gl_accvouch set cdept_id = null where ccode in (SELECT ccode FROM code WHERE (bdept = 0)) and cdept_id is not null
update gl_accvouch set citem_id = null where ccode in (SELECT ccode FROM code WHERE (bitem = 0)) and citem_id is not null
update gl_accvouch set citem_class = null where ccode in (SELECT ccode FROM code WHERE (bitem = 0)) and citem_class is not null |