⬅ Back DELETE AGENCY ENTRIES.txt
use T22N001

DELETE FROM PAYMENT_BANK_BOOK_ADDLESS_DETAIL WHERE LEN(BkSrNo)= 5
DELETE FROM PAYMENT_BANK_BOOK_DETAIL WHERE LEN(BkSrNo)= 5
        
DELETE FROM PAYMENT_CASH_BOOK_ADDLESS_DETAIL WHERE LEN(BkSrNo)= 5
DELETE FROM PAYMENT_CASH_BOOK_DETAIL WHERE LEN(BkSrNo)= 5
        
DELETE FROM RECEIVED_BANK_BOOK_ADDLESS_DETAIL WHERE LEN(BkSrNo)= 5
DELETE FROM RECEIVED_BANK_BOOK_DETAIL WHERE LEN(BkSrNo)= 5
        
DELETE FROM RECEIVED_CASH_BOOK_ADDLESS_DETAIL WHERE LEN(BkSrNo)= 5
DELETE FROM RECEIVED_CASH_BOOK_DETAIL WHERE LEN(BkSrNo)= 5
        
DELETE FROM RECEIVED_RETURN_GOODS_TAKA_DETAIL WHERE LEN(BkSrNo)= 5
DELETE FROM RECEIVED_RETURN_GOODS_ITEM_DETAIL WHERE LEN(BkSrNo)= 5
DELETE FROM RECEIVED_RETURN_GOODS_ADDLESS_DETAIL WHERE LEN(BkSrNo)= 5
DELETE FROM RECEIVED_RETURN_GOODS_DETAIL WHERE LEN(BkSrNo)= 5
        
DELETE FROM GREY_PURCHASE_RETURN_GOODS_YARN_TAKA_DETAIL WHERE LEN(BkSrNo)= 5
DELETE FROM GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL WHERE LEN(BkSrNo)= 5
DELETE FROM GREY_PURCHASE_RETURN_GOODS_TAKA_DETAIL WHERE LEN(BkSrNo)= 5
DELETE FROM GREY_PURCHASE_RETURN_GOODS_DETAIL WHERE LEN(BkSrNo)= 5
               
DELETE FROM FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL WHERE LEN(BkSrNo)= 5
DELETE FROM FINISHED_PURCHASE_RETURN_GOODS_DETAIL WHERE LEN(BkSrNo)= 5
        
DELETE FROM MULTI_JOURNAL_ADDLESS_DETAIL WHERE LEN(BkSrNo)= 5
DELETE FROM MULTI_JOURNAL_DETAIL WHERE LEN(BkSrNo)= 5