用友U8单据工作流弃审

select cVoucherType,ExtendField3, * from table_task where ExtendField3='CZJ22021421'  

select VoucherType,FlagCode,PDID,VoucherCode, * from WF_ActiveFlow where VoucherCode ='CZJ22021421'  

select VoucherType,OperatorName,VoucherType,VoucherCode, * from WFAudit where VoucherCode='CZJ22021421'   

--select * into PO_Pomain20180927 from PO_Pomain

delete  from table_task where ExtendField3='CZJ22021421'  
--select * into table_task20180927 from table_task

delete from WF_ActiveFlow  where VoucherCode ='CZJ22021421'  
--select * into WF_ActiveFlow20180927 from WF_ActiveFlow

delete from WFAudit where VoucherCode='CZJ22021421'   
--select * into WFAudit20180927 from WFAudit

--弃审付款申请单
UPDATE AP_ApplyPayVouch SET   iState=0,iverifystate=0   WHERE cVouchID=‘PA20220423005’

 --弃审调价单

 UPDATE PU_PriceJustMain SET iverifystate=0  WHERE ccode='0000034727'

 --弃审销售订单
 SELECT dverifydate,iverifystate,iStatus,cVerifier FROM  SO_SOMain  WHERE cSOCode='CZJ22021421'

 UPDATE SO_SOMain SET dverifydate=NULL,iverifystate=0,iStatus=0,cVerifier=NULL WHERE cSOCode='CZJ22021421'

 --弃审采购订单
 Update PO_Pomain set cAuditTime=NULL,iverifystateex=0,cAuditDate=NULL,cVerifier =NULL,cState=0
from PO_Pomain  where cPOID='0000000006'

---弃审请购单
Update PU_AppVouch set cAuditTime=NULL,iverifystateex=0,cAuditDate=NULL,cVerifier =NULL,cCurrentAuditor=NULL
 where cCode='PR20220110008'