IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_APPLYPROJECTENTRY' AND KSQL_COL_NAME ='FCURPRICE')
 ALTER TABLE T_ER_APPLYPROJECTENTRY ADD (FCURPRICE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_APPLYPROJECTENTRY' AND KSQL_COL_NAME ='FCHANGEPRICE')
 ALTER TABLE T_ER_APPLYPROJECTENTRY ADD (FCHANGEPRICE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_APPLYPROJECTENTRY' AND KSQL_COL_NAME ='FCHANGECURPRICE')
 ALTER TABLE T_ER_APPLYPROJECTENTRY ADD (FCHANGECURPRICE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_APPLYPROJECTENTRY' AND KSQL_COL_NAME ='FACPRICE')
 ALTER TABLE T_ER_APPLYPROJECTENTRY ADD (FACPRICE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_APPLYPROJECTENTRY' AND KSQL_COL_NAME ='FACCURPRICE')
 ALTER TABLE T_ER_APPLYPROJECTENTRY ADD (FACCURPRICE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_COSTESTIMATEENTRY' AND KSQL_COL_NAME ='FCURPRICE')
 ALTER TABLE T_ER_COSTESTIMATEENTRY ADD (FCURPRICE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_COSTESTIMATEENTRY' AND KSQL_COL_NAME ='FCHANGEPRICE')
 ALTER TABLE T_ER_COSTESTIMATEENTRY ADD (FCHANGEPRICE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_COSTESTIMATEENTRY' AND KSQL_COL_NAME ='FCHANGECURPRICE')
 ALTER TABLE T_ER_COSTESTIMATEENTRY ADD (FCHANGECURPRICE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_COSTESTIMATEENTRY' AND KSQL_COL_NAME ='FACPRICE')
 ALTER TABLE T_ER_COSTESTIMATEENTRY ADD (FACPRICE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_COSTESTIMATEENTRY' AND KSQL_COL_NAME ='FACCURPRICE')
 ALTER TABLE T_ER_COSTESTIMATEENTRY ADD (FACCURPRICE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_DAILYRESHAREDETAIL' AND KSQL_COL_NAME ='FCURPRICE')
 ALTER TABLE T_ER_DAILYRESHAREDETAIL ADD (FCURPRICE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_PUBLICRESHAREDETAIL' AND KSQL_COL_NAME ='FCURPRICE')
 ALTER TABLE T_ER_PUBLICRESHAREDETAIL ADD (FCURPRICE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_TRIPRESHAREDETAIL' AND KSQL_COL_NAME ='FCURPRICE')
 ALTER TABLE T_ER_TRIPRESHAREDETAIL ADD (FCURPRICE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_EXPENSESHAREDETAIL' AND KSQL_COL_NAME ='FCURPRICE')
 ALTER TABLE T_ER_EXPENSESHAREDETAIL ADD (FCURPRICE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_EXPENSESHAREWAIT' AND KSQL_COL_NAME ='FCURPRICE')
 ALTER TABLE T_ER_EXPENSESHAREWAIT ADD (FCURPRICE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_EXPENSESHAREWAIT' AND KSQL_COL_NAME ='FTHISCURPRICE')
 ALTER TABLE T_ER_EXPENSESHAREWAIT ADD (FTHISCURPRICE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_WITHHOLDINGENTRY' AND KSQL_COL_NAME ='FCURPRICE')
 ALTER TABLE T_ER_WITHHOLDINGENTRY ADD (FCURPRICE DECIMAL(23,10) DEFAULT 0 NOT NULL );