IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_TripArea' AND KSQL_COL_NAME ='fmulcombofield')
 ALTER TABLE T_ER_TripArea ADD (fmulcombofield VARCHAR(50) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_er_tripstandarddetail' AND KSQL_COL_NAME ='fhighseasonstandardamount')
ALTER TABLE t_er_tripstandarddetail ADD (fhighseasonstandardamount DECIMAL(23,10) DEFAULT 0 NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_ReimburseEntry' AND KSQL_COL_NAME ='fhighseasondaycount')
ALTER TABLE T_ER_ReimburseEntry ADD (fhighseasondaycount DECIMAL(23,10) DEFAULT 0 NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_ReimburseEntry' AND KSQL_COL_NAME ='fhightripstandardamount')
ALTER TABLE T_ER_ReimburseEntry ADD (fhightripstandardamount DECIMAL(23,10) DEFAULT 0 NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_ReimburseEntry' AND KSQL_COL_NAME ='fhighseason')
ALTER TABLE T_ER_ReimburseEntry ADD (fhighseason CHAR(1) DEFAULT '0' NOT NULL);

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_ReimburseEntry' AND KSQL_COL_NAME ='foriginhighseasondays')
ALTER TABLE T_ER_ReimburseEntry ADD (foriginhighseasondays DECIMAL(23,10) DEFAULT 0 NOT NULL );



