删除-采购单收货记录
-- 删除采购单收货记录【PuRvTrx】
-- 删除采购单收货记录-明细【PuRvTrx2】
DELETE FROM PuRvTrx WHERE (SysID='78216')
DELETE FROM PuRvTrx2 WHERE (SysID='78216')
DELETE FROM PuRvJAlc WHERE (SysID='78216')
DELETE FROM PuRvA1c2 WHERE (SysID='78216' )
DELETE FROM PURVITM WHERE (SysID='78216' )
-- 更新采购单主表【PUOITEM】(收货数量为0并且状态为'')
-- 更新采购单物料明细/价格表【PUIASM】
UPDATE PUOITEM SET RcvQty=0 , Status='' WHERE PuOrderNo=' 淘宝2307-00002' AND ItemNo=l
UPDATE PUIASM SET RcvQty=0 WHERE PuOrderNo= '淘宝2307-000021' AND ItemNo=1 AND SegNo=1
标签:收货,--,78216,查询,SysID,日志,WHERE,DELETE From: https://www.cnblogs.com/loveDonkey/p/17602474.html