use T25S001

UPDATE COMMON.DBO.COMPANY_DETAIL SET COMPSTATUS='OPEN' WHERE COMPSTATUS IS NULL


SELECT * FROM ACCOUNT_MASTER WHERE acctype='CAPITAL ACCOUNT'