IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_CONTRACTBILL_S' AND KSQL_COL_NAME ='FAVAILABLEAMOUNT')
ALTER TABLE T_ER_CONTRACTBILL_S ADD (FAVAILABLEAMOUNT 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 ='FNONPAYAMOUNT')
ALTER TABLE T_ER_CONTRACTBILL_S ADD (FNONPAYAMOUNT DECIMAL(23,10) DEFAULT 0 NOT NULL);

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_PUBREIMCONTRACT' AND KSQL_COL_NAME ='FCONTRACTNONPAYAMOUNT')
ALTER TABLE T_ER_PUBREIMCONTRACT ADD (FCONTRACTNONPAYAMOUNT 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 ='FORIAVAILABLEAMOUNT')
ALTER TABLE T_ER_CONTRACTBILL_S ADD (FORIAVAILABLEAMOUNT 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 ='FORINONPAYAMOUNT')
ALTER TABLE T_ER_CONTRACTBILL_S ADD (FORINONPAYAMOUNT DECIMAL(23,10) DEFAULT 0 NOT NULL);

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

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









