use t22m001

DELETE FROM PAYMENT_BANK_BOOK_ADDLESS_DETAIL WHERE LEN(BkSrNo)= 5 and left(right(bksrno,5),1)<>'0'
DELETE FROM PAYMENT_BANK_BOOK_DETAIL WHERE LEN(BkSrNo)= 5 and left(right(bksrno,5),1)<>'0'
        
DELETE FROM PAYMENT_CASH_BOOK_ADDLESS_DETAIL WHERE LEN(BkSrNo)= 5 and left(right(bksrno,5),1)<>'0'
DELETE FROM PAYMENT_CASH_BOOK_DETAIL WHERE LEN(BkSrNo)= 5 and left(right(bksrno,5),1)<>'0'
        
DELETE FROM RECEIVED_BANK_BOOK_ADDLESS_DETAIL WHERE LEN(BkSrNo)= 5 and left(right(bksrno,5),1)<>'0'
DELETE FROM RECEIVED_BANK_BOOK_DETAIL WHERE LEN(BkSrNo)= 5 and left(right(bksrno,5),1)<>'0'
        
DELETE FROM RECEIVED_CASH_BOOK_ADDLESS_DETAIL WHERE LEN(BkSrNo)= 5 and left(right(bksrno,5),1)<>'0'
DELETE FROM RECEIVED_CASH_BOOK_DETAIL WHERE LEN(BkSrNo)= 5 and left(right(bksrno,5),1)<>'0'
        
DELETE FROM RECEIVED_RETURN_GOODS_TAKA_DETAIL WHERE LEN(BkSrNo)= 5 and left(right(bksrno,5),1)<>'0'
DELETE FROM RECEIVED_RETURN_GOODS_ITEM_DETAIL WHERE LEN(BkSrNo)= 5 and left(right(bksrno,5),1)<>'0'
DELETE FROM RECEIVED_RETURN_GOODS_ADDLESS_DETAIL WHERE LEN(BkSrNo)= 5 and left(right(bksrno,5),1)<>'0'
DELETE FROM RECEIVED_RETURN_GOODS_DETAIL WHERE LEN(BkSrNo)= 5 and left(right(bksrno,5),1)<>'0'
        
DELETE FROM GREY_PURCHASE_RETURN_GOODS_YARN_TAKA_DETAIL WHERE LEN(BkSrNo)= 5 and left(right(bksrno,5),1)<>'0'
DELETE FROM GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL WHERE LEN(BkSrNo)= 5 and left(right(bksrno,5),1)<>'0'
DELETE FROM GREY_PURCHASE_RETURN_GOODS_TAKA_DETAIL WHERE LEN(BkSrNo)= 5 and left(right(bksrno,5),1)<>'0'
DELETE FROM GREY_PURCHASE_RETURN_GOODS_DETAIL WHERE LEN(BkSrNo)= 5 and left(right(bksrno,5),1)<>'0'
               
DELETE FROM FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL WHERE LEN(BkSrNo)= 5 and left(right(bksrno,5),1)<>'0'
DELETE FROM FINISHED_PURCHASE_RETURN_GOODS_DETAIL WHERE LEN(BkSrNo)= 5 and left(right(bksrno,5),1)<>'0'
        
DELETE FROM MULTI_JOURNAL_ADDLESS_DETAIL WHERE LEN(BkSrNo)= 5 and left(right(bksrno,5),1)<>'0'
DELETE FROM MULTI_JOURNAL_DETAIL WHERE LEN(BkSrNo)= 5 and left(right(bksrno,5),1)<>'0'