/* 个人额度表 添加 1,2,3,4季度字段 */
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_REIMBURSEAMOUNT' AND KSQL_COL_NAME ='FQUARTER1')
ALTER TABLE T_ER_REIMBURSEAMOUNT ADD (FQUARTER1 DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_REIMBURSEAMOUNT' AND KSQL_COL_NAME ='FQUARTER2')
ALTER TABLE T_ER_REIMBURSEAMOUNT ADD (FQUARTER2 DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_REIMBURSEAMOUNT' AND KSQL_COL_NAME ='FQUARTER3')
ALTER TABLE T_ER_REIMBURSEAMOUNT ADD (FQUARTER3 DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_REIMBURSEAMOUNT' AND KSQL_COL_NAME ='FQUARTER4')
ALTER TABLE T_ER_REIMBURSEAMOUNT ADD (FQUARTER4 DECIMAL(23,10) DEFAULT 0 NOT NULL );


/* 部门额度表 添加 1,2,3,4季度字段 */
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_DEPT_REIMCTL' AND KSQL_COL_NAME ='FQUARTER1')
ALTER TABLE T_ER_DEPT_REIMCTL ADD (FQUARTER1 DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_DEPT_REIMCTL' AND KSQL_COL_NAME ='FQUARTER2')
ALTER TABLE T_ER_DEPT_REIMCTL ADD (FQUARTER2 DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_DEPT_REIMCTL' AND KSQL_COL_NAME ='FQUARTER3')
ALTER TABLE T_ER_DEPT_REIMCTL ADD (FQUARTER3 DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_DEPT_REIMCTL' AND KSQL_COL_NAME ='FQUARTER4')
ALTER TABLE T_ER_DEPT_REIMCTL ADD (FQUARTER4 DECIMAL(23,10) DEFAULT 0 NOT NULL );