select * from GL_Doc where accountingyear=2020 and accountingperiod=10
select idDocDTO,* from GL_Entry where idDocDTO not in(select id from GL_Doc)
select * from GL_Doc where id not in (select iddocdto from GL_Entry)
745142488 17:02:03
delete from GL_Journal where madedate='20201019' and id in(4235,4236,4237)
select * from GL_Journal where madedate='20210120' and auditorname='苏敏'
delete from GL_Journal where madedate='20210120' and docno in(0010) and auditorname='苏敏'
