
/** 费用分摊单添加字段 **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_EXPENSESHAREWAIT' AND KSQL_COL_NAME ='FPRICE') 
 ALTER TABLE T_ER_EXPENSESHAREWAIT ADD (FPRICE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_EXPENSESHAREWAIT' AND KSQL_COL_NAME ='FENTRYTHISSHAREAMOUNT') 
 ALTER TABLE T_ER_EXPENSESHAREWAIT ADD (FENTRYTHISSHAREAMOUNT DECIMAL(23,10) DEFAULT 0 NOT NULL );
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_EXPENSESHAREDETAIL' AND KSQL_COL_NAME ='FPRICE') 
 ALTER TABLE T_ER_EXPENSESHAREDETAIL ADD (FPRICE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_EXPENSESHAREDETAIL' AND KSQL_COL_NAME ='FENTRYMONTH') 
 ALTER TABLE T_ER_EXPENSESHAREDETAIL ADD (FENTRYMONTH DATETIME );
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_EXPENSESHARERULE' AND KSQL_COL_NAME ='FENTRYMONTH') 
 ALTER TABLE T_ER_EXPENSESHARERULE ADD (FENTRYMONTH DATETIME );