IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_CHECKINGPAYENTRY' AND KSQL_COL_NAME IN ('FFROMCITY'))
ALTER TABLE T_ER_CHECKINGPAYENTRY ADD (FFROMCITY NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_CHECKINGPAYENTRY' AND KSQL_COL_NAME IN ('FTOCITY'))
ALTER TABLE T_ER_CHECKINGPAYENTRY ADD (FTOCITY NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_CHECKINGPAYENTRY' AND KSQL_COL_NAME IN ('FDEPARTTIME'))
ALTER TABLE T_ER_CHECKINGPAYENTRY ADD (FDEPARTTIME DATETIME );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_CHECKINGPAYENTRY' AND KSQL_COL_NAME IN ('FARRIVETIME'))
ALTER TABLE T_ER_CHECKINGPAYENTRY ADD (FARRIVETIME DATETIME );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_CHECKINGPAYENTRY' AND KSQL_COL_NAME IN ('FVENDORNAME'))
ALTER TABLE T_ER_CHECKINGPAYENTRY ADD (FVENDORNAME VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_INVOICEINFOCP' AND KSQL_COL_NAME IN ('FFLIGHTTRAINNUMS'))
ALTER TABLE T_ER_INVOICEINFOCP ADD (FFLIGHTTRAINNUMS VARCHAR(50) DEFAULT ' ' NOT NULL );