delete from OPENING_FINISHED_PURCHASE 
delete from OPENING_GENERAL_PURCHASE 
delete from OPENING_BILL_DETAIL 
delete from OPENING_GREY_SEND_TO_MILL 
delete from OPENING_GREY_SEND_TO_MILL_TAKA_DETAIL 
delete from OPENING_MILL_GP 
delete from OPENING_GREY_PURCHASE 
delete from OPENING_SEND_TO_JOB 
delete from OPENING_SEND_TO_JOB_ITEM_DETAIL 
delete from OPENING_SEND_TO_JOB_TAKA_DETAIL 
delete from OPENING_SEND_TO_JOB_FINISHED_TAKA_DETAIL 
delete from OPENING_FINISHED_RECEIVED_FROM_MILL 
delete from OPENING_FINISHED_RECEIVED_FROM_MILL_CHALLAN_DETAIL 
delete from OPENING_CHALLAN_RECEIVED_FROM_JOB 
delete from OPENING_CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL 
delete from OPENING_CHALLAN_RECEIVED_FROM_JOB_TAKA_DETAIL 
delete from OPENING_CHALLAN_RECEIVED_FROM_JOB_FINISHED_TAKA_DETAIL 
delete from OPENING_ITEM_SCREEN_COSTING 
    
delete from OPENING_CHALLAN_RECEIVED_FOR_JOB_BILL 
delete from OPENING_CHALLAN_RECEIVED_FOR_JOB_BILL_CHALLAN_DETAIL 
    
delete from OPENING_FOR_ITEM_FINALIZATION 
    
delete from OPENING_RECEIVED_FROM_JOB 
delete from OPENING_GREY_AT_SHOP 
delete from OPENING_GREY_AT_SHOP_ITEM_DETAIL 
delete from OPENING_GREY_AT_SHOP_TAKA_DETAIL 

delete from OPENING_FINISHED_PURCHASE_ORDER_FORM 
delete from OPENING_FINISHED_PURCHASE_ORDER_FORM_ITEM_DETAIL 
    
delete from OPENING_RECEIVED_FROM_JOB 
delete from OPENING_JOB_ORDER_FORM 
delete from OPENING_JOB_ORDER_FORM_ITEM_DETAIL 
        
delete from OPENING_ORDER_BILL_DETAIL 
delete from OPENING_ORDER_BILL_ITEM_DETAIL 
delete from OPENING_ORDER_BILL_ITEM_TAKA_DETAIL 

delete from OPENING_GREY_PURCHASE_ORDER_FORM 
delete from OPENING_GREY_PURCHASE_ORDER_FORM_ITEM_DETAIL 
delete from OPENING_SCAN_FINISHED_STOCK 

delete from OPENING_WITHOUT_WORK_STOCK 
delete from OPENING_LR_GREY_PURCHASE 
delete from OPENING_LR_GREY_PURCHASE_ITEM_DETAIL 
delete from OPENING_LR_GREY_PURCHASE_ITEM_TAKA_DETAIL 





delete from OPENING_SEND_TO_JOB WHERE LEN(BKSRNO)=6
delete from OPENING_SEND_TO_JOB_ITEM_DETAIL WHERE LEN(BKSRNO)=6
delete from OPENING_SEND_TO_JOB_TAKA_DETAIL WHERE LEN(BKSRNO)=6
delete from OPENING_SEND_TO_JOB_FINISHED_TAKA_DETAIL WHERE LEN(BKSRNO)=6


DELETE FROM RECEIVED_BANK_BOOK_DETAIL WHERE LEN(BKSRNO)=5
DELETE FROM RECEIVED_BANK_BOOK_ADDLESS_DETAIL WHERE LEN(BKSRNO)=5
DELETE FROM RECEIVED_CASH_BOOK_DETAIL WHERE LEN(BKSRNO)=5
DELETE FROM RECEIVED_CASH_BOOK_ADDLESS_DETAIL WHERE LEN(BKSRNO)=5

DELETE FROM PAYMENT_BANK_BOOK_DETAIL WHERE LEN(BKSRNO)=5
DELETE FROM PAYMENT_BANK_BOOK_ADDLESS_DETAIL WHERE LEN(BKSRNO)=5
DELETE FROM PAYMENT_CASH_BOOK_DETAIL WHERE LEN(BKSRNO)=5
DELETE FROM PAYMENT_CASH_BOOK_ADDLESS_DETAIL WHERE LEN(BKSRNO)=5


DELETE FROM MULTI_JOURNAL_DETAIL WHERE LEN(BKSRNO)=5
DELETE FROM MULTI_JOURNAL_ADDLESS_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_ADDLESS_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