DELETE FROM OPENING_PURCHASE_IMAGES_DETAIL WHERE VOUNO IN (SELECT VOUNO FROM OPENING_PURCHASE_DETAIL WHERE VOUCUSTCODE = '22DK001')
DELETE FROM OPENING_PURCHASE_ITEM_DETAIL WHERE VOUNO IN (SELECT VOUNO FROM OPENING_PURCHASE_DETAIL WHERE VOUCUSTCODE = '22DK001')
DELETE FROM OPENING_PURCHASE_TRANSPORT_DETAIL WHERE VOUNO IN (SELECT VOUNO FROM OPENING_PURCHASE_DETAIL WHERE VOUCUSTCODE = '22DK001')
DELETE FROM OPENING_PURCHASE_ADDLESS_DETAIL WHERE VOUNO IN (SELECT VOUNO FROM OPENING_PURCHASE_DETAIL WHERE VOUCUSTCODE = '22DK001')
DELETE FROM OPENING_PURCHASE_DETAIL WHERE VOUNO IN (SELECT VOUNO FROM OPENING_PURCHASE_DETAIL WHERE VOUCUSTCODE = '22DK001')


DELETE FROM RECEIVED_PAYMENT_DETAIL WHERE RecSrNo COLLATE DATABASE_DEFAULT IN (SELECT RECSRNO FROM RECEIVED_DETAIL WHERE RECCUSTCODE = '22DK001') AND LEN(RECSRNO)=10
DELETE FROM RECEIVED_IMAGES_DETAIL WHERE RecSrNo COLLATE DATABASE_DEFAULT IN (SELECT RECSRNO FROM RECEIVED_DETAIL WHERE RECCUSTCODE = '22DK001') AND LEN(RECSRNO)=10
DELETE FROM RECEIVED_ADDLESS_DETAIL WHERE RecSrNo COLLATE DATABASE_DEFAULT IN (SELECT RECSRNO FROM RECEIVED_DETAIL WHERE RECCUSTCODE = '22DK001') AND LEN(RECSRNO)=10
DELETE FROM RECEIVED_DETAIL WHERE RecSrNo COLLATE DATABASE_DEFAULT IN (SELECT RECSRNO FROM RECEIVED_DETAIL WHERE RECCUSTCODE = '22DK001') AND LEN(RECSRNO)=10