1.凭证表:gl_accvouch
--查询表中内容是否正确
select * from gl_accvouch where iyperiod in('202010','202011','202012') order by dbill_date
--更新表中审核人名称
update gl_accvouch set ccheck='XXX' where dbill_date='2020-11-10' and csign='转' and ino_id=3
2.签字标记表:Gl_ltdata1
-- 查询表中内容
select * from Gl_ltdata1 where iyperiod in('202010','202011','202012') order by iYPeriod
--更新签字审批人
update Gl_ltdata1 set cMaster='XXX' where iyperiod in('202010','202011','202012')
如果还有其他关联表未写到,欢迎大家指正,谢谢
标签:凭证,U8,--,ltdata1,签字,表中,gl,where,accvouch From: https://www.cnblogs.com/ccnlc/p/17000998.html