/*付款申请单收款信息分录新增 核定金额  核定金额本位币*/

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_APPLYPAYBILLRECENTRY' AND KSQL_COL_NAME ='faccapproveamount')
ALTER TABLE T_ER_APPLYPAYBILLRECENTRY ADD (faccapproveamount DECIMAL(23,10) DEFAULT 0 NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_APPLYPAYBILLRECENTRY' AND KSQL_COL_NAME ='faccapprovecurramount')
ALTER TABLE T_ER_APPLYPAYBILLRECENTRY ADD (faccapprovecurramount DECIMAL(23,10) DEFAULT 0 NOT NULL );