DELETE FROM OPENING_PURCHASE_IMAGES_DETAIL where VouNo in (SELECT VouNo FROM OPENING_PURCHASE_DETAIL WHERE VouSuppCode='22CM012' AND VouCustCode='22DI001')
DELETE FROM OPENING_PURCHASE_ITEM_DETAIL where VouNo in (SELECT VouNo FROM OPENING_PURCHASE_DETAIL WHERE VouSuppCode='22CM012' AND VouCustCode='22DI001')
DELETE FROM OPENING_PURCHASE_ADDLESS_DETAIL where VouNo in (SELECT VouNo FROM OPENING_PURCHASE_DETAIL WHERE VouSuppCode='22CM012' AND VouCustCode='22DI001')
DELETE FROM OPENING_PURCHASE_TRANSPORT_DETAIL where VouNo in (SELECT VouNo FROM OPENING_PURCHASE_DETAIL WHERE VouSuppCode='22CM012' AND VouCustCode='22DI001')
DELETE FROM OPENING_PURCHASE_DETAIL WHERE VouSuppCode='22CM012' AND VouCustCode='22DI001'




DELETE from dbo.RECEIVED_PAYMENT_DETAIL where len(recsrno)=10 AND RECSRNO IN (select RecSrNo from RECEIVED_DETAIL WHERE RecSuppCode='22CM012' AND RecCustCode='22DI001' AND len(recsrno)=10)
DELETE from dbo.RECEIVED_ADDLESS_DETAIL where len(recsrno)=10  AND RECSRNO IN (select RecSrNo from RECEIVED_DETAIL WHERE RecSuppCode='22CM012' AND RecCustCode='22DI001' AND len(recsrno)=10)
DELETE from dbo.RECEIVED_IMAGES_DETAIL where len(recsrno)=10  AND RECSRNO IN (select RecSrNo from RECEIVED_DETAIL WHERE RecSuppCode='22CM012' AND RecCustCode='22DI001' AND len(recsrno)=10)
DELETE from dbo.RECEIVED_DETAIL where len(recsrno)=10  AND RecSuppCode='22CM012' AND RecCustCode='22DI001'





USE T202526


SELECT SUM(RecAmt) from dbo.RECEIVED_DETAIL where len(recsrno)<>10  AND RecSuppCode='22CM012' AND RecCustCode='22DI001' ORDER BY RecDate


SELECT * from dbo.RECEIVED_DETAIL where len(recsrno)<>10  AND RecSuppCode='22CM012' AND RecCustCode='22DI001' ORDER BY RecDate

SELECT SUM(VouNetAmt) from dbo.OPENING_PURCHASE_DETAIL where VouSuppCode='22CM012' AND VouCustCode='22DI001' ORDER BY SuppBillDate

SELECT * from dbo.RETURN_GOODS_DETAIL where len(RtnSrNo)=10  AND RtnSuppCode='22CM012' AND RtnCustCode='22DI001' ORDER BY RtnDate


DELETE RETURN_GOODS_ADDLESS_DETAIL  WHERE RTNSRNO IN (SELECT RtnSrNo from dbo.RETURN_GOODS_DETAIL where len(RtnSrNo)=10  AND RtnSuppCode='22CM012' AND RtnCustCode='22DI001')
DELETE RETURN_GOODS_ITEM_DETAIL  WHERE RTNSRNO IN (SELECT RtnSrNo from dbo.RETURN_GOODS_DETAIL where len(RtnSrNo)=10  AND RtnSuppCode='22CM012' AND RtnCustCode='22DI001')
DELETE RETURN_GOODS_IMAGES_DETAIL  WHERE RTNSRNO IN (SELECT RtnSrNo from dbo.RETURN_GOODS_DETAIL where len(RtnSrNo)=10  AND RtnSuppCode='22CM012' AND RtnCustCode='22DI001')
DELETE RETURN_GOODS_DETAIL  WHERE RTNSRNO IN (SELECT RtnSrNo from dbo.RETURN_GOODS_DETAIL where len(RtnSrNo)=10  AND RtnSuppCode='22CM012' AND RtnCustCode='22DI001')