
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_NREQTRIPENTRY' AND KSQL_COL_NAME ='FFROMADM')
ALTER TABLE T_ER_NREQTRIPENTRY ADD (FFROMADM BIGINT DEFAULT 0 NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_NREQTRIPENTRY' AND KSQL_COL_NAME ='FTOADM')
ALTER TABLE T_ER_NREQTRIPENTRY ADD (FTOADM BIGINT DEFAULT 0 NOT NULL );



IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_NREIMBURSETRIPENTRY' AND KSQL_COL_NAME ='FFROMADM')
ALTER TABLE T_ER_NREIMBURSETRIPENTRY ADD (FFROMADM BIGINT DEFAULT 0 NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_NREIMBURSETRIPENTRY' AND KSQL_COL_NAME ='FTOADM')
ALTER TABLE T_ER_NREIMBURSETRIPENTRY ADD (FTOADM BIGINT DEFAULT 0 NOT NULL );


IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_CGRID_TRIPREIMBURSE_A' AND KSQL_COL_NAME ='FCOUNTRY')
ALTER TABLE T_ER_CGRID_TRIPREIMBURSE_A ADD (FCOUNTRY BIGINT DEFAULT 0 NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_NREQBILL_A' AND KSQL_COL_NAME ='FCOUNTRY')
ALTER TABLE T_ER_NREQBILL_A ADD (FCOUNTRY BIGINT DEFAULT 0 NOT NULL );



