-----RUN IN ALL FIRM


USE T24A001
UPDATE ACCOUNT_MASTER SET ACCTYPE='UNSECURED LOAN' WHERE acctype = 'BANK ACCOUNT' AND ACCCODE COLLATE DATABASE_DEFAULT NOT IN (SELECT creditacc FROM TMP_SCAN_BALANCE_SHEET UNION SELECT DEBITACC FROM TMP_SCAN_BALANCE_SHEET)