use T201920

UPDATE PURCHASE_DETAIL Set VouStatus='PENDING'
UPDATE OPENING_PURCHASE_DETAIL Set VouStatus='PENDING'

UPDATE PURCHASE_DETAIL Set VouStatus='PART' FROM ( 
SELECT RECEIVED_DETAIL.RecCustCode AS F1, RECEIVED_DETAIL.RecSuppCode AS F2, RECEIVED_ADDLESS_DETAIL.RecBillNo AS F3, RECEIVED_DETAIL.RecFirmCode AS F4 FROM RECEIVED_ADDLESS_DETAIL INNER JOIN RECEIVED_DETAIL ON RECEIVED_ADDLESS_DETAIL.RecSrNo = RECEIVED_DETAIL.RecSrNo WHERE (RECEIVED_ADDLESS_DETAIL.Status = 'PART') UNION SELECT RETURN_GOODS_DETAIL.RtnCustCode AS F1, RETURN_GOODS_DETAIL.RtnSuppCode AS F2, RETURN_GOODS_ADDLESS_DETAIL.RtnBillNo AS F3, RETURN_GOODS_DETAIL.RtnFirmCode AS F4 FROM RETURN_GOODS_DETAIL INNER JOIN RETURN_GOODS_ADDLESS_DETAIL ON RETURN_GOODS_DETAIL.RtnSrNo = RETURN_GOODS_ADDLESS_DETAIL.RtnSrNo WHERE (RETURN_GOODS_ADDLESS_DETAIL.Status = 'PART') 
) AS T1 WHERE VouCustCode=T1.F1 AND VouSuppCode=T1.F2 AND SuppBillNo=T1.F3 AND FirmCode=T1.F4

UPDATE OPENING_PURCHASE_DETAIL Set VouStatus='PART' FROM ( 
SELECT RECEIVED_DETAIL.RecCustCode AS F1, RECEIVED_DETAIL.RecSuppCode AS F2, RECEIVED_ADDLESS_DETAIL.RecBillNo AS F3, RECEIVED_DETAIL.RecFirmCode AS F4 FROM RECEIVED_ADDLESS_DETAIL INNER JOIN RECEIVED_DETAIL ON RECEIVED_ADDLESS_DETAIL.RecSrNo = RECEIVED_DETAIL.RecSrNo WHERE (RECEIVED_ADDLESS_DETAIL.Status = 'PART') UNION SELECT RETURN_GOODS_DETAIL.RtnCustCode AS F1, RETURN_GOODS_DETAIL.RtnSuppCode AS F2, RETURN_GOODS_ADDLESS_DETAIL.RtnBillNo AS F3, RETURN_GOODS_DETAIL.RtnFirmCode AS F4 FROM RETURN_GOODS_DETAIL INNER JOIN RETURN_GOODS_ADDLESS_DETAIL ON RETURN_GOODS_DETAIL.RtnSrNo = RETURN_GOODS_ADDLESS_DETAIL.RtnSrNo WHERE (RETURN_GOODS_ADDLESS_DETAIL.Status = 'PART') 
) AS T1 WHERE VouCustCode=T1.F1 AND VouSuppCode=T1.F2 AND SuppBillNo=T1.F3 AND FirmCode=T1.F4
UPDATE PURCHASE_DETAIL Set VouStatus='FULL' FROM ( 
SELECT RECEIVED_DETAIL.RecCustCode AS F1, RECEIVED_DETAIL.RecSuppCode AS F2, RECEIVED_ADDLESS_DETAIL.RecBillNo AS F3, RECEIVED_DETAIL.RecFirmCode AS F4 FROM RECEIVED_ADDLESS_DETAIL INNER JOIN RECEIVED_DETAIL ON RECEIVED_ADDLESS_DETAIL.RecSrNo = RECEIVED_DETAIL.RecSrNo WHERE (RECEIVED_ADDLESS_DETAIL.Status = 'FULL') UNION SELECT RETURN_GOODS_DETAIL.RtnCustCode AS F1, RETURN_GOODS_DETAIL.RtnSuppCode AS F2, RETURN_GOODS_ADDLESS_DETAIL.RtnBillNo AS F3, RETURN_GOODS_DETAIL.RtnFirmCode AS F4 FROM RETURN_GOODS_DETAIL INNER JOIN RETURN_GOODS_ADDLESS_DETAIL ON RETURN_GOODS_DETAIL.RtnSrNo = RETURN_GOODS_ADDLESS_DETAIL.RtnSrNo WHERE (RETURN_GOODS_ADDLESS_DETAIL.Status = 'FULL') 
) AS T1 WHERE VouCustCode=T1.F1 AND VouSuppCode=T1.F2 AND SuppBillNo=T1.F3 AND FirmCode=T1.F4

UPDATE OPENING_PURCHASE_DETAIL Set VouStatus='FULL' FROM ( 
SELECT RECEIVED_DETAIL.RecCustCode AS F1, RECEIVED_DETAIL.RecSuppCode AS F2, RECEIVED_ADDLESS_DETAIL.RecBillNo AS F3, RECEIVED_DETAIL.RecFirmCode AS F4 FROM RECEIVED_ADDLESS_DETAIL INNER JOIN RECEIVED_DETAIL ON RECEIVED_ADDLESS_DETAIL.RecSrNo = RECEIVED_DETAIL.RecSrNo WHERE (RECEIVED_ADDLESS_DETAIL.Status = 'FULL') UNION SELECT RETURN_GOODS_DETAIL.RtnCustCode AS F1, RETURN_GOODS_DETAIL.RtnSuppCode AS F2, RETURN_GOODS_ADDLESS_DETAIL.RtnBillNo AS F3, RETURN_GOODS_DETAIL.RtnFirmCode AS F4 FROM RETURN_GOODS_DETAIL INNER JOIN RETURN_GOODS_ADDLESS_DETAIL ON RETURN_GOODS_DETAIL.RtnSrNo = RETURN_GOODS_ADDLESS_DETAIL.RtnSrNo WHERE (RETURN_GOODS_ADDLESS_DETAIL.Status = 'FULL') 
) AS T1 WHERE VouCustCode=T1.F1 AND VouSuppCode=T1.F2 AND SuppBillNo=T1.F3 AND FirmCode=T1.F4