2014-12-14 22:13:13
4、检查科目的辅助核算与凭证的辅助合算是否一致
select bperson,bcus,bsup,bitem,* from code where ccode='101'
select cdept_id,cperson_id,ccus_id,csup_id,citem_id,citem_class,* from gl_accvouch
where ccode='101' and (cdept_id is not null or ccus_id is not null or cperson_id is not null
or csup_id is not null or citem_id is not null or citem_class is not null)
5、检查下辅助总账表里的辅助核算与科目上的辅助核算是否不一致
select bperson,bcus,bsup,bitem,* from code where ccode='101'
select * from gl_accass
where ccode='101' and (cdept_id is not null or cperson_id is not null or csup_id is not null
or citem_id is not null or citem_class is not null)