IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_TRAINBILL' AND KSQL_COL_NAME ='FREIMBURSESTATUS')
 ALTER TABLE T_ER_TRAINBILL ADD ( FREIMBURSESTATUS  CHAR(1) DEFAULT 'A' NOT NULL);

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_er_planebill' AND KSQL_COL_NAME ='FREIMBURSESTATUS')
 ALTER TABLE t_er_planebill ADD ( FREIMBURSESTATUS  CHAR(1) DEFAULT 'A' NOT NULL);

 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_er_hotelbill' AND KSQL_COL_NAME ='FREIMBURSESTATUS')
 ALTER TABLE t_er_hotelbill ADD ( FREIMBURSESTATUS  CHAR(1) DEFAULT 'A' NOT NULL);

 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_er_vehiclebill' AND KSQL_COL_NAME ='FREIMBURSESTATUS')
 ALTER TABLE t_er_vehiclebill ADD ( FREIMBURSESTATUS  CHAR(1) DEFAULT 'A' NOT NULL);



IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_er_traincheckingbill' AND KSQL_COL_NAME ='FREIMBURSESTATUS')
 ALTER TABLE t_er_traincheckingbill ADD ( FREIMBURSESTATUS  CHAR(1) DEFAULT 'A' NOT NULL);

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_er_planecheckingbill' AND KSQL_COL_NAME ='FREIMBURSESTATUS')
 ALTER TABLE t_er_planecheckingbill ADD ( FREIMBURSESTATUS  CHAR(1) DEFAULT 'A' NOT NULL);

 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_er_hotelcheckingbill' AND KSQL_COL_NAME ='FREIMBURSESTATUS')
 ALTER TABLE t_er_hotelcheckingbill ADD ( FREIMBURSESTATUS  CHAR(1) DEFAULT 'A' NOT NULL);

 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_er_vehiclecheckingbill' AND KSQL_COL_NAME ='FREIMBURSESTATUS')
 ALTER TABLE t_er_vehiclecheckingbill ADD ( FREIMBURSESTATUS  CHAR(1) DEFAULT 'A' NOT NULL);






