UPDATE BILL_DETAIL Set BillStatus ='PENDING'
UPDATE OPENING_BILL_DETAIL Set BillStatus ='PENDING'
UPDATE GREY_PURCHASE Set BillStatus ='PENDING'
UPDATE OPENING_GREY_PURCHASE Set BillStatus ='PENDING'
UPDATE FINISHED_PURCHASE Set BillStatus ='PENDING'
UPDATE OPENING_FINISHED_PURCHASE Set BillStatus ='PENDING'
UPDATE RECEIVED_FROM_JOB Set BillStatus ='PENDING'
UPDATE OPENING_RECEIVED_FROM_JOB Set BillStatus ='PENDING'
UPDATE GP_RECEIVED_FROM_MILL Set GPStatus ='PENDING'
UPDATE OPENING_MILL_GP Set GPStatus ='PENDING'
UPDATE GENERAL_PURCHASE Set BillStatus ='PENDING'
UPDATE OPENING_GENERAL_PURCHASE Set BillStatus ='PENDING'

Update GREY_PURCHASE Set BillStatus = 'PART' FROM (SELECT PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_BANK_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_BANK_BOOK_DETAIL INNER JOIN PAYMENT_BANK_BOOK_ADDLESS_DETAIL ON PAYMENT_BANK_BOOK_DETAIL.BkSrNo = PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_CASH_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_CASH_BOOK_DETAIL INNER JOIN PAYMENT_CASH_BOOK_ADDLESS_DETAIL ON PAYMENT_CASH_BOOK_DETAIL.BkSrNo = PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, GREY_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM GREY_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON GREY_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM FINISHED_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo2 AS F1, MULTI_JOURNAL_ADDLESS_DETAIL.BkDrCrParty AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus2 = 'PART') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo AS F1, MULTI_JOURNAL_DETAIL.BkAccCode AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus = 'PART')) AS T1 Where BillNo=T1.F1 AND WeaverCode COLLATE DATABASE_DEFAULT=T1.F2
                        
Update GENERAL_PURCHASE Set BillStatus = 'PART' FROM (SELECT PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_BANK_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_BANK_BOOK_DETAIL INNER JOIN PAYMENT_BANK_BOOK_ADDLESS_DETAIL ON PAYMENT_BANK_BOOK_DETAIL.BkSrNo = PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_CASH_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_CASH_BOOK_DETAIL INNER JOIN PAYMENT_CASH_BOOK_ADDLESS_DETAIL ON PAYMENT_CASH_BOOK_DETAIL.BkSrNo = PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, GREY_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM GREY_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON GREY_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM FINISHED_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo2 AS F1, MULTI_JOURNAL_ADDLESS_DETAIL.BkDrCrParty AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus2 = 'PART') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo AS F1, MULTI_JOURNAL_DETAIL.BkAccCode AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus = 'PART')) AS T1 Where BillNo=T1.F1 AND SuppCode COLLATE DATABASE_DEFAULT=T1.F2
                        
Update OPENING_GENERAL_PURCHASE Set BillStatus = 'PART' FROM (SELECT PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_BANK_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_BANK_BOOK_DETAIL INNER JOIN PAYMENT_BANK_BOOK_ADDLESS_DETAIL ON PAYMENT_BANK_BOOK_DETAIL.BkSrNo = PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_CASH_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_CASH_BOOK_DETAIL INNER JOIN PAYMENT_CASH_BOOK_ADDLESS_DETAIL ON PAYMENT_CASH_BOOK_DETAIL.BkSrNo = PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, GREY_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM GREY_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON GREY_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM FINISHED_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo2 AS F1, MULTI_JOURNAL_ADDLESS_DETAIL.BkDrCrParty AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus2 = 'PART') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo AS F1, MULTI_JOURNAL_DETAIL.BkAccCode AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus = 'PART')) AS T1 Where BillNo=T1.F1 AND SuppCode COLLATE DATABASE_DEFAULT=T1.F2
                        
Update OPENING_GREY_PURCHASE Set BillStatus = 'PART' FROM (SELECT PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_BANK_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_BANK_BOOK_DETAIL INNER JOIN PAYMENT_BANK_BOOK_ADDLESS_DETAIL ON PAYMENT_BANK_BOOK_DETAIL.BkSrNo = PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_CASH_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_CASH_BOOK_DETAIL INNER JOIN PAYMENT_CASH_BOOK_ADDLESS_DETAIL ON PAYMENT_CASH_BOOK_DETAIL.BkSrNo = PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, GREY_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM GREY_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON GREY_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM FINISHED_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo2 AS F1, MULTI_JOURNAL_ADDLESS_DETAIL.BkDrCrParty AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus2 = 'PART') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo AS F1, MULTI_JOURNAL_DETAIL.BkAccCode AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus = 'PART')) AS T1 Where BillNo=T1.F1 AND WeaverCode COLLATE DATABASE_DEFAULT=T1.F2
    
Update FINISHED_PURCHASE Set BillStatus = 'PART' FROM (SELECT PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_BANK_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_BANK_BOOK_DETAIL INNER JOIN PAYMENT_BANK_BOOK_ADDLESS_DETAIL ON PAYMENT_BANK_BOOK_DETAIL.BkSrNo = PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_CASH_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_CASH_BOOK_DETAIL INNER JOIN PAYMENT_CASH_BOOK_ADDLESS_DETAIL ON PAYMENT_CASH_BOOK_DETAIL.BkSrNo = PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, GREY_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM GREY_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON GREY_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM FINISHED_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo2 AS F1, MULTI_JOURNAL_ADDLESS_DETAIL.BkDrCrParty AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus2 = 'PART') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo AS F1, MULTI_JOURNAL_DETAIL.BkAccCode AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus = 'PART')) AS T1 Where BillNo=T1.F1 AND WeaverCode COLLATE DATABASE_DEFAULT=T1.F2
                                
Update OPENING_FINISHED_PURCHASE Set BillStatus = 'PART' FROM (SELECT PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_BANK_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_BANK_BOOK_DETAIL INNER JOIN PAYMENT_BANK_BOOK_ADDLESS_DETAIL ON PAYMENT_BANK_BOOK_DETAIL.BkSrNo = PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_CASH_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_CASH_BOOK_DETAIL INNER JOIN PAYMENT_CASH_BOOK_ADDLESS_DETAIL ON PAYMENT_CASH_BOOK_DETAIL.BkSrNo = PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, GREY_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM GREY_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON GREY_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM FINISHED_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo2 AS F1, MULTI_JOURNAL_ADDLESS_DETAIL.BkDrCrParty AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus2 = 'PART') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo AS F1, MULTI_JOURNAL_DETAIL.BkAccCode AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus = 'PART')) AS T1 Where BillNo=T1.F1 AND WeaverCode COLLATE DATABASE_DEFAULT=T1.F2
        
Update GP_RECEIVED_FROM_MILL Set GPStatus = 'PART' FROM (SELECT PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_BANK_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_BANK_BOOK_DETAIL INNER JOIN PAYMENT_BANK_BOOK_ADDLESS_DETAIL ON PAYMENT_BANK_BOOK_DETAIL.BkSrNo = PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_CASH_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_CASH_BOOK_DETAIL INNER JOIN PAYMENT_CASH_BOOK_ADDLESS_DETAIL ON PAYMENT_CASH_BOOK_DETAIL.BkSrNo = PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, GREY_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM GREY_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON GREY_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM FINISHED_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo2 AS F1, MULTI_JOURNAL_ADDLESS_DETAIL.BkDrCrParty AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus2 = 'PART') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo AS F1, MULTI_JOURNAL_DETAIL.BkAccCode AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus = 'PART')) AS T1 Where GPNo=T1.F1 AND MillCode COLLATE DATABASE_DEFAULT=T1.F2
        
Update OPENING_MILL_GP Set GPStatus = 'PART' FROM (SELECT PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_BANK_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_BANK_BOOK_DETAIL INNER JOIN PAYMENT_BANK_BOOK_ADDLESS_DETAIL ON PAYMENT_BANK_BOOK_DETAIL.BkSrNo = PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_CASH_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_CASH_BOOK_DETAIL INNER JOIN PAYMENT_CASH_BOOK_ADDLESS_DETAIL ON PAYMENT_CASH_BOOK_DETAIL.BkSrNo = PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, GREY_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM GREY_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON GREY_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM FINISHED_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo2 AS F1, MULTI_JOURNAL_ADDLESS_DETAIL.BkDrCrParty AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus2 = 'PART') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo AS F1, MULTI_JOURNAL_DETAIL.BkAccCode AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus = 'PART')) AS T1 Where GPNo=T1.F1 AND MillCode COLLATE DATABASE_DEFAULT=T1.F2
    
Update RECEIVED_FROM_JOB Set BillStatus = 'PART' FROM (SELECT PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_BANK_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_BANK_BOOK_DETAIL INNER JOIN PAYMENT_BANK_BOOK_ADDLESS_DETAIL ON PAYMENT_BANK_BOOK_DETAIL.BkSrNo = PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_CASH_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_CASH_BOOK_DETAIL INNER JOIN PAYMENT_CASH_BOOK_ADDLESS_DETAIL ON PAYMENT_CASH_BOOK_DETAIL.BkSrNo = PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, GREY_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM GREY_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON GREY_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM FINISHED_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo2 AS F1, MULTI_JOURNAL_ADDLESS_DETAIL.BkDrCrParty AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus2 = 'PART') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo AS F1, MULTI_JOURNAL_DETAIL.BkAccCode AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus = 'PART')) AS T1 Where BillNo=T1.F1 AND JobCode COLLATE DATABASE_DEFAULT=T1.F2
        
Update OPENING_RECEIVED_FROM_JOB Set BillStatus = 'PART' FROM (SELECT PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_BANK_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_BANK_BOOK_DETAIL INNER JOIN PAYMENT_BANK_BOOK_ADDLESS_DETAIL ON PAYMENT_BANK_BOOK_DETAIL.BkSrNo = PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_CASH_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_CASH_BOOK_DETAIL INNER JOIN PAYMENT_CASH_BOOK_ADDLESS_DETAIL ON PAYMENT_CASH_BOOK_DETAIL.BkSrNo = PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, GREY_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM GREY_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON GREY_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM FINISHED_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo2 AS F1, MULTI_JOURNAL_ADDLESS_DETAIL.BkDrCrParty AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus2 = 'PART') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo AS F1, MULTI_JOURNAL_DETAIL.BkAccCode AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus = 'PART')) AS T1 Where BillNo=T1.F1 AND JobCode COLLATE DATABASE_DEFAULT=T1.F2
    
Update BILL_DETAIL Set BillStatus = 'PART' FROM (SELECT RECEIVED_BANK_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, RECEIVED_BANK_BOOK_DETAIL.BkAccCode AS F2 FROM RECEIVED_BANK_BOOK_DETAIL INNER JOIN RECEIVED_BANK_BOOK_ADDLESS_DETAIL ON RECEIVED_BANK_BOOK_DETAIL.BkSrNo = RECEIVED_BANK_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (RECEIVED_BANK_BOOK_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT RECEIVED_CASH_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, RECEIVED_CASH_BOOK_DETAIL.BkAccCode AS F2 FROM RECEIVED_CASH_BOOK_DETAIL INNER JOIN RECEIVED_CASH_BOOK_ADDLESS_DETAIL ON RECEIVED_CASH_BOOK_DETAIL.BkSrNo = RECEIVED_CASH_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (RECEIVED_CASH_BOOK_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT RECEIVED_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, RECEIVED_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM RECEIVED_RETURN_GOODS_DETAIL INNER JOIN RECEIVED_RETURN_GOODS_ADDLESS_DETAIL ON RECEIVED_RETURN_GOODS_DETAIL.BkSrNo = RECEIVED_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (RECEIVED_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo2 AS F1, MULTI_JOURNAL_ADDLESS_DETAIL.BkDrCrParty AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus2 = 'PART') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo AS F1, MULTI_JOURNAL_DETAIL.BkAccCode AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus = 'PART')) AS T1 Where BillNo=T1.F1 AND CustCode COLLATE DATABASE_DEFAULT=T1.F2
                        
Update OPENING_BILL_DETAIL Set BillStatus = 'PART' FROM (SELECT RECEIVED_BANK_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, RECEIVED_BANK_BOOK_DETAIL.BkAccCode AS F2 FROM RECEIVED_BANK_BOOK_DETAIL INNER JOIN RECEIVED_BANK_BOOK_ADDLESS_DETAIL ON RECEIVED_BANK_BOOK_DETAIL.BkSrNo = RECEIVED_BANK_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (RECEIVED_BANK_BOOK_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT RECEIVED_CASH_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, RECEIVED_CASH_BOOK_DETAIL.BkAccCode AS F2 FROM RECEIVED_CASH_BOOK_DETAIL INNER JOIN RECEIVED_CASH_BOOK_ADDLESS_DETAIL ON RECEIVED_CASH_BOOK_DETAIL.BkSrNo = RECEIVED_CASH_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (RECEIVED_CASH_BOOK_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT RECEIVED_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, RECEIVED_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM RECEIVED_RETURN_GOODS_DETAIL INNER JOIN RECEIVED_RETURN_GOODS_ADDLESS_DETAIL ON RECEIVED_RETURN_GOODS_DETAIL.BkSrNo = RECEIVED_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (RECEIVED_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'PART') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo2 AS F1, MULTI_JOURNAL_ADDLESS_DETAIL.BkDrCrParty AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus2 = 'PART') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo AS F1, MULTI_JOURNAL_DETAIL.BkAccCode AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus = 'PART')) AS T1 Where BillNo=T1.F1 AND CustCode COLLATE DATABASE_DEFAULT=T1.F2

Update GREY_PURCHASE Set BillStatus = 'FULL' FROM (SELECT PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_BANK_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_BANK_BOOK_DETAIL INNER JOIN PAYMENT_BANK_BOOK_ADDLESS_DETAIL ON PAYMENT_BANK_BOOK_DETAIL.BkSrNo = PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_CASH_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_CASH_BOOK_DETAIL INNER JOIN PAYMENT_CASH_BOOK_ADDLESS_DETAIL ON PAYMENT_CASH_BOOK_DETAIL.BkSrNo = PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, GREY_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM GREY_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON GREY_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM FINISHED_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo2 AS F1, MULTI_JOURNAL_ADDLESS_DETAIL.BkDrCrParty AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus2 = 'FULL') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo AS F1, MULTI_JOURNAL_DETAIL.BkAccCode AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus = 'FULL')) AS T1 Where BillNo=T1.F1 AND WeaverCode COLLATE DATABASE_DEFAULT=T1.F2
                        
Update GENERAL_PURCHASE Set BillStatus = 'FULL' FROM (SELECT PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_BANK_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_BANK_BOOK_DETAIL INNER JOIN PAYMENT_BANK_BOOK_ADDLESS_DETAIL ON PAYMENT_BANK_BOOK_DETAIL.BkSrNo = PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_CASH_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_CASH_BOOK_DETAIL INNER JOIN PAYMENT_CASH_BOOK_ADDLESS_DETAIL ON PAYMENT_CASH_BOOK_DETAIL.BkSrNo = PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, GREY_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM GREY_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON GREY_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM FINISHED_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo2 AS F1, MULTI_JOURNAL_ADDLESS_DETAIL.BkDrCrParty AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus2 = 'FULL') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo AS F1, MULTI_JOURNAL_DETAIL.BkAccCode AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus = 'FULL')) AS T1 Where BillNo=T1.F1 AND SuppCode COLLATE DATABASE_DEFAULT=T1.F2
                        
Update OPENING_GENERAL_PURCHASE Set BillStatus = 'FULL' FROM (SELECT PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_BANK_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_BANK_BOOK_DETAIL INNER JOIN PAYMENT_BANK_BOOK_ADDLESS_DETAIL ON PAYMENT_BANK_BOOK_DETAIL.BkSrNo = PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_CASH_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_CASH_BOOK_DETAIL INNER JOIN PAYMENT_CASH_BOOK_ADDLESS_DETAIL ON PAYMENT_CASH_BOOK_DETAIL.BkSrNo = PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, GREY_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM GREY_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON GREY_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM FINISHED_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo2 AS F1, MULTI_JOURNAL_ADDLESS_DETAIL.BkDrCrParty AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus2 = 'FULL') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo AS F1, MULTI_JOURNAL_DETAIL.BkAccCode AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus = 'FULL')) AS T1 Where BillNo=T1.F1 AND SuppCode COLLATE DATABASE_DEFAULT=T1.F2
                        
Update OPENING_GREY_PURCHASE Set BillStatus = 'FULL' FROM (SELECT PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_BANK_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_BANK_BOOK_DETAIL INNER JOIN PAYMENT_BANK_BOOK_ADDLESS_DETAIL ON PAYMENT_BANK_BOOK_DETAIL.BkSrNo = PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_CASH_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_CASH_BOOK_DETAIL INNER JOIN PAYMENT_CASH_BOOK_ADDLESS_DETAIL ON PAYMENT_CASH_BOOK_DETAIL.BkSrNo = PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, GREY_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM GREY_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON GREY_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM FINISHED_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo2 AS F1, MULTI_JOURNAL_ADDLESS_DETAIL.BkDrCrParty AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus2 = 'FULL') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo AS F1, MULTI_JOURNAL_DETAIL.BkAccCode AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus = 'FULL')) AS T1 Where BillNo=T1.F1 AND WeaverCode COLLATE DATABASE_DEFAULT=T1.F2
    
Update FINISHED_PURCHASE Set BillStatus = 'FULL' FROM (SELECT PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_BANK_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_BANK_BOOK_DETAIL INNER JOIN PAYMENT_BANK_BOOK_ADDLESS_DETAIL ON PAYMENT_BANK_BOOK_DETAIL.BkSrNo = PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_CASH_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_CASH_BOOK_DETAIL INNER JOIN PAYMENT_CASH_BOOK_ADDLESS_DETAIL ON PAYMENT_CASH_BOOK_DETAIL.BkSrNo = PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, GREY_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM GREY_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON GREY_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM FINISHED_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo2 AS F1, MULTI_JOURNAL_ADDLESS_DETAIL.BkDrCrParty AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus2 = 'FULL') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo AS F1, MULTI_JOURNAL_DETAIL.BkAccCode AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus = 'FULL')) AS T1 Where BillNo=T1.F1 AND WeaverCode COLLATE DATABASE_DEFAULT=T1.F2
                                
Update OPENING_FINISHED_PURCHASE Set BillStatus = 'FULL' FROM (SELECT PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_BANK_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_BANK_BOOK_DETAIL INNER JOIN PAYMENT_BANK_BOOK_ADDLESS_DETAIL ON PAYMENT_BANK_BOOK_DETAIL.BkSrNo = PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_CASH_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_CASH_BOOK_DETAIL INNER JOIN PAYMENT_CASH_BOOK_ADDLESS_DETAIL ON PAYMENT_CASH_BOOK_DETAIL.BkSrNo = PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, GREY_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM GREY_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON GREY_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM FINISHED_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo2 AS F1, MULTI_JOURNAL_ADDLESS_DETAIL.BkDrCrParty AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus2 = 'FULL') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo AS F1, MULTI_JOURNAL_DETAIL.BkAccCode AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus = 'FULL')) AS T1 Where BillNo=T1.F1 AND WeaverCode COLLATE DATABASE_DEFAULT=T1.F2
        
Update GP_RECEIVED_FROM_MILL Set GPStatus = 'FULL' FROM (SELECT PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_BANK_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_BANK_BOOK_DETAIL INNER JOIN PAYMENT_BANK_BOOK_ADDLESS_DETAIL ON PAYMENT_BANK_BOOK_DETAIL.BkSrNo = PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_CASH_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_CASH_BOOK_DETAIL INNER JOIN PAYMENT_CASH_BOOK_ADDLESS_DETAIL ON PAYMENT_CASH_BOOK_DETAIL.BkSrNo = PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, GREY_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM GREY_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON GREY_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM FINISHED_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo2 AS F1, MULTI_JOURNAL_ADDLESS_DETAIL.BkDrCrParty AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus2 = 'FULL') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo AS F1, MULTI_JOURNAL_DETAIL.BkAccCode AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus = 'FULL')) AS T1 Where GPNo=T1.F1 AND MillCode COLLATE DATABASE_DEFAULT=T1.F2
        
Update OPENING_MILL_GP Set GPStatus = 'FULL' FROM (SELECT PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_BANK_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_BANK_BOOK_DETAIL INNER JOIN PAYMENT_BANK_BOOK_ADDLESS_DETAIL ON PAYMENT_BANK_BOOK_DETAIL.BkSrNo = PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_CASH_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_CASH_BOOK_DETAIL INNER JOIN PAYMENT_CASH_BOOK_ADDLESS_DETAIL ON PAYMENT_CASH_BOOK_DETAIL.BkSrNo = PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, GREY_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM GREY_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON GREY_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM FINISHED_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo2 AS F1, MULTI_JOURNAL_ADDLESS_DETAIL.BkDrCrParty AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus2 = 'FULL') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo AS F1, MULTI_JOURNAL_DETAIL.BkAccCode AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus = 'FULL')) AS T1 Where GPNo=T1.F1 AND MillCode COLLATE DATABASE_DEFAULT=T1.F2
    
Update RECEIVED_FROM_JOB Set BillStatus = 'FULL' FROM (SELECT PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_BANK_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_BANK_BOOK_DETAIL INNER JOIN PAYMENT_BANK_BOOK_ADDLESS_DETAIL ON PAYMENT_BANK_BOOK_DETAIL.BkSrNo = PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_CASH_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_CASH_BOOK_DETAIL INNER JOIN PAYMENT_CASH_BOOK_ADDLESS_DETAIL ON PAYMENT_CASH_BOOK_DETAIL.BkSrNo = PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, GREY_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM GREY_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON GREY_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM FINISHED_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo2 AS F1, MULTI_JOURNAL_ADDLESS_DETAIL.BkDrCrParty AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus2 = 'FULL') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo AS F1, MULTI_JOURNAL_DETAIL.BkAccCode AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus = 'FULL')) AS T1 Where BillNo=T1.F1 AND JobCode COLLATE DATABASE_DEFAULT=T1.F2
        
Update OPENING_RECEIVED_FROM_JOB Set BillStatus = 'FULL' FROM (SELECT PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_BANK_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_BANK_BOOK_DETAIL INNER JOIN PAYMENT_BANK_BOOK_ADDLESS_DETAIL ON PAYMENT_BANK_BOOK_DETAIL.BkSrNo = PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, PAYMENT_CASH_BOOK_DETAIL.BkAccCode AS F2 FROM PAYMENT_CASH_BOOK_DETAIL INNER JOIN PAYMENT_CASH_BOOK_ADDLESS_DETAIL ON PAYMENT_CASH_BOOK_DETAIL.BkSrNo = PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_CASH_BOOK_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, GREY_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM GREY_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON GREY_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM FINISHED_PURCHASE_RETURN_GOODS_DETAIL INNER JOIN FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL ON FINISHED_PURCHASE_RETURN_GOODS_DETAIL.BkSrNo = FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo2 AS F1, MULTI_JOURNAL_ADDLESS_DETAIL.BkDrCrParty AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus2 = 'FULL') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo AS F1, MULTI_JOURNAL_DETAIL.BkAccCode AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus = 'FULL')) AS T1 Where BillNo=T1.F1 AND JobCode COLLATE DATABASE_DEFAULT=T1.F2
    
Update BILL_DETAIL Set BillStatus = 'FULL' FROM (SELECT RECEIVED_BANK_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, RECEIVED_BANK_BOOK_DETAIL.BkAccCode AS F2 FROM RECEIVED_BANK_BOOK_DETAIL INNER JOIN RECEIVED_BANK_BOOK_ADDLESS_DETAIL ON RECEIVED_BANK_BOOK_DETAIL.BkSrNo = RECEIVED_BANK_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (RECEIVED_BANK_BOOK_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT RECEIVED_CASH_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, RECEIVED_CASH_BOOK_DETAIL.BkAccCode AS F2 FROM RECEIVED_CASH_BOOK_DETAIL INNER JOIN RECEIVED_CASH_BOOK_ADDLESS_DETAIL ON RECEIVED_CASH_BOOK_DETAIL.BkSrNo = RECEIVED_CASH_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (RECEIVED_CASH_BOOK_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT RECEIVED_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, RECEIVED_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM RECEIVED_RETURN_GOODS_DETAIL INNER JOIN RECEIVED_RETURN_GOODS_ADDLESS_DETAIL ON RECEIVED_RETURN_GOODS_DETAIL.BkSrNo = RECEIVED_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (RECEIVED_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo2 AS F1, MULTI_JOURNAL_ADDLESS_DETAIL.BkDrCrParty AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus2 = 'FULL') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo AS F1, MULTI_JOURNAL_DETAIL.BkAccCode AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus = 'FULL')) AS T1 Where BillNo=T1.F1 AND CustCode COLLATE DATABASE_DEFAULT=T1.F2
                        
Update OPENING_BILL_DETAIL Set BillStatus = 'FULL' FROM (SELECT RECEIVED_BANK_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, RECEIVED_BANK_BOOK_DETAIL.BkAccCode AS F2 FROM RECEIVED_BANK_BOOK_DETAIL INNER JOIN RECEIVED_BANK_BOOK_ADDLESS_DETAIL ON RECEIVED_BANK_BOOK_DETAIL.BkSrNo = RECEIVED_BANK_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (RECEIVED_BANK_BOOK_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT RECEIVED_CASH_BOOK_ADDLESS_DETAIL.BkBillNo AS F1, RECEIVED_CASH_BOOK_DETAIL.BkAccCode AS F2 FROM RECEIVED_CASH_BOOK_DETAIL INNER JOIN RECEIVED_CASH_BOOK_ADDLESS_DETAIL ON RECEIVED_CASH_BOOK_DETAIL.BkSrNo = RECEIVED_CASH_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (RECEIVED_CASH_BOOK_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT RECEIVED_RETURN_GOODS_ADDLESS_DETAIL.BkBillNo AS F1, RECEIVED_RETURN_GOODS_DETAIL.BkAccCode AS F2 FROM RECEIVED_RETURN_GOODS_DETAIL INNER JOIN RECEIVED_RETURN_GOODS_ADDLESS_DETAIL ON RECEIVED_RETURN_GOODS_DETAIL.BkSrNo = RECEIVED_RETURN_GOODS_ADDLESS_DETAIL.BkSrNo WHERE (RECEIVED_RETURN_GOODS_ADDLESS_DETAIL.BkStatus = 'FULL') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo2 AS F1, MULTI_JOURNAL_ADDLESS_DETAIL.BkDrCrParty AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus2 = 'FULL') UNION 
                        SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkBillNo AS F1, MULTI_JOURNAL_DETAIL.BkAccCode AS F2 FROM MULTI_JOURNAL_DETAIL INNER JOIN MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus = 'FULL')) AS T1 Where BillNo=T1.F1 AND CustCode COLLATE DATABASE_DEFAULT=T1.F2
                        
UPDATE BILL_DETAIL Set BillStatus ='FULL' WHERE CustCode IN (SELECT AccCode FROM ACCOUNT_MASTER WHERE AccType IN (SELECT AccTypes FROM ACCOUNT_TYPES WHERE FinalApplicable='CASH'))
UPDATE OPENING_BILL_DETAIL Set BillStatus ='FULL' WHERE CustCode IN (SELECT AccCode FROM ACCOUNT_MASTER WHERE AccType IN (SELECT AccTypes FROM ACCOUNT_TYPES WHERE FinalApplicable='CASH'))
UPDATE GREY_PURCHASE Set BillStatus ='FULL' WHERE WeaverCode IN (SELECT AccCode FROM ACCOUNT_MASTER WHERE AccType IN (SELECT AccTypes FROM ACCOUNT_TYPES WHERE FinalApplicable='CASH'))
UPDATE OPENING_GREY_PURCHASE Set BillStatus ='FULL' WHERE WeaverCode IN (SELECT AccCode FROM ACCOUNT_MASTER WHERE AccType IN (SELECT AccTypes FROM ACCOUNT_TYPES WHERE FinalApplicable='CASH'))
UPDATE FINISHED_PURCHASE Set BillStatus ='FULL' WHERE WeaverCode IN (SELECT AccCode FROM ACCOUNT_MASTER WHERE AccType IN (SELECT AccTypes FROM ACCOUNT_TYPES WHERE FinalApplicable='CASH'))
UPDATE OPENING_FINISHED_PURCHASE Set BillStatus ='FULL' WHERE WeaverCode IN (SELECT AccCode FROM ACCOUNT_MASTER WHERE AccType IN (SELECT AccTypes FROM ACCOUNT_TYPES WHERE FinalApplicable='CASH'))
UPDATE RECEIVED_FROM_JOB Set BillStatus ='FULL' WHERE JobCode IN (SELECT AccCode FROM ACCOUNT_MASTER WHERE AccType IN (SELECT AccTypes FROM ACCOUNT_TYPES WHERE FinalApplicable='CASH'))
UPDATE OPENING_RECEIVED_FROM_JOB Set BillStatus ='FULL' WHERE JobCode IN (SELECT AccCode FROM ACCOUNT_MASTER WHERE AccType IN (SELECT AccTypes FROM ACCOUNT_TYPES WHERE FinalApplicable='CASH'))
UPDATE GP_RECEIVED_FROM_MILL Set GPStatus ='FULL' WHERE MillCode IN (SELECT AccCode FROM ACCOUNT_MASTER WHERE AccType IN (SELECT AccTypes FROM ACCOUNT_TYPES WHERE FinalApplicable='CASH'))
UPDATE OPENING_MILL_GP Set GPStatus ='FULL' WHERE MillCode IN (SELECT AccCode FROM ACCOUNT_MASTER WHERE AccType IN (SELECT AccTypes FROM ACCOUNT_TYPES WHERE FinalApplicable='CASH'))
UPDATE GENERAL_PURCHASE Set BillStatus ='FULL' WHERE SuppCode IN (SELECT AccCode FROM ACCOUNT_MASTER WHERE AccType IN (SELECT AccTypes FROM ACCOUNT_TYPES WHERE FinalApplicable='CASH'))
UPDATE OPENING_GENERAL_PURCHASE Set BillStatus ='FULL' WHERE SuppCode IN (SELECT AccCode FROM ACCOUNT_MASTER WHERE AccType IN (SELECT AccTypes FROM ACCOUNT_TYPES WHERE FinalApplicable='CASH'))