IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_PUBREIMEXPDET' AND KSQL_COL_NAME IN ('FCONTRACTITEMID'))
 ALTER TABLE T_ER_PUBREIMEXPDET ADD (FCONTRACTITEMID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_COSTESTIMATEENTRY' AND KSQL_COL_NAME IN ('FENTRYCONTRACTNO'))
 ALTER TABLE T_ER_COSTESTIMATEENTRY ADD (FENTRYCONTRACTNO VARCHAR(200) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_COSTESTIMATEENTRY' AND KSQL_COL_NAME IN ('FENTRYCONTRACTNAME'))
 ALTER TABLE T_ER_COSTESTIMATEENTRY ADD (FENTRYCONTRACTNAME VARCHAR(200) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_COSTESTIMATEENTRY' AND KSQL_COL_NAME IN ('FENTRYPROJECTNO'))
 ALTER TABLE T_ER_COSTESTIMATEENTRY ADD (FENTRYPROJECTNO VARCHAR(200) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_COSTESTIMATEENTRY' AND KSQL_COL_NAME IN ('FWBPAYTYPE'))
 ALTER TABLE T_ER_COSTESTIMATEENTRY ADD (FWBPAYTYPE VARCHAR(100) DEFAULT ' ' NOT NULL );
