请输入
菜单

重置单据为未提交

下载

一、demo脚本

SET @from14_billno='aaaaaaa';
UPDATE ld_customform14 SET approvestatus='未提交',currentapprover=NULL,currentapprovestepid=NULL,approvesubmitter=NULL,approvesubmittedtime=NULL WHERE customform14_no=@from14_billno;
DELETE FROM ld_approvelog WHERE crmid IN (SELECT customform14id FROM ld_customform14 WHERE customform14_no=@from14_billno);

重置单据为未提交.sql

最近修改: 2025-02-07