/***合同台账分录增加 超期、付款进度字段  合同台账单头增加 超期 、付款异常 **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_CONTRACTBILL_S' AND KSQL_COL_NAME ='FISOVERPAY')
ALTER TABLE T_ER_CONTRACTBILL_S ADD (FISOVERPAY CHAR(1) DEFAULT '0' NOT NULL);


IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_CONTRACTENTRY_S' AND KSQL_COL_NAME ='FEXPISOVERPAY')
ALTER TABLE T_ER_CONTRACTENTRY_S ADD (FEXPISOVERPAY CHAR(1) DEFAULT '0' NOT NULL);


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


IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_CONTRACTBILL_S' AND KSQL_COL_NAME ='FABNORMALPAY')
ALTER TABLE T_ER_CONTRACTBILL_S ADD (FABNORMALPAY CHAR(1) DEFAULT '0' NOT NULL);