/* （费用报销单、对公报销单，差旅报销单）费用明细分录添加价款字段 */
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_er_expensedetail' AND KSQL_COL_NAME ='fprice') 
 ALTER TABLE t_er_expensedetail ADD (fprice decimal(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_er_pubreimexpdet' AND KSQL_COL_NAME ='fprice') 
 ALTER TABLE t_er_pubreimexpdet ADD (fprice decimal(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_ReimburseEntry' AND KSQL_COL_NAME ='fprice') 
 ALTER TABLE T_ER_ReimburseEntry ADD (fprice decimal(23,10) DEFAULT 0 NOT NULL );