日志查询

删除-采购单收货记录

-- 删除采购单收货记录【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