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

 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_REIMBURSETRIPENTRY' AND KSQL_COL_NAME IN ('FTRIPVEHICLEOVER'))
 ALTER TABLE T_ER_REIMBURSETRIPENTRY ADD (FTRIPVEHICLEOVER char(1) DEFAULT '0' NOT NULL );

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

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

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

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

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_REIMBURSETRIPENTRY' AND KSQL_COL_NAME IN ('FTRIPAPPNOTTAXAMOUNT'))
 ALTER TABLE T_ER_REIMBURSETRIPENTRY ADD (FTRIPAPPNOTTAXAMOUNT 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 IN ('FSTDEXPQUOTETYPE'))
 ALTER TABLE T_ER_REIMBURSEENTRY ADD (FSTDEXPQUOTETYPE 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 IN ('FSTDENTRYCURRENCY'))
 ALTER TABLE T_ER_REIMBURSEENTRY ADD (FSTDENTRYCURRENCY BIGINT DEFAULT 0 NOT NULL );

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