/**Begin D:\PDM\pdm_upgrade\pdm_dev\ER_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_CHECKINGPAY' AND KSQL_COL_NAME IN ('FVOUCHERNUM'))
ALTER TABLE T_ER_CHECKINGPAY ADD (FVOUCHERNUM VARCHAR(80) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_CHECKINGPAY' AND KSQL_COL_NAME IN ('FHASVOUCHER'))
ALTER TABLE T_ER_CHECKINGPAY ADD (FHASVOUCHER CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_CHECKINGPAY' AND KSQL_COL_NAME IN ('FBOOKEDDATE'))
ALTER TABLE T_ER_CHECKINGPAY ADD (FBOOKEDDATE DATETIME );

/**End D:\PDM\pdm_upgrade\pdm_dev\ER_table.sql **/
