/**Begin D:\page\rim\pdm\20210724\RIM_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_DOWN_INIT' AND KSQL_COL_NAME ='FMODIFYDATE') 
 ALTER TABLE T_RIM_DOWN_INIT ADD (FMODIFYDATE DATETIME );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_DOWN_LOG' AND KSQL_COL_NAME ='FINVOICE_STARTDATE') 
 ALTER TABLE T_RIM_DOWN_LOG ADD (FINVOICE_STARTDATE DATETIME );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_DOWN_LOG' AND KSQL_COL_NAME ='FINVOICE_ENDDATE') 
 ALTER TABLE T_RIM_DOWN_LOG ADD (FINVOICE_ENDDATE DATETIME );

/**End D:\page\rim\pdm\20210724\RIM_table.sql **/
