IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_EXPENSESHARERULE' AND KSQL_COL_NAME ='FSTDENTRYCOSTCENTERID')
 ALTER TABLE T_ER_EXPENSESHARERULE ADD (FSTDENTRYCOSTCENTERID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_DAILYRESHARERULE' AND KSQL_COL_NAME ='FSTDENTRYCOSTCENTERRULE')
 ALTER TABLE T_ER_DAILYRESHARERULE ADD (FSTDENTRYCOSTCENTERRULE BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_PUBLICRESHARERULE' AND KSQL_COL_NAME ='FSTDENTRYCOSTCENTERID')
 ALTER TABLE T_ER_PUBLICRESHARERULE ADD (FSTDENTRYCOSTCENTERID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_TRIPRESHARERULE' AND KSQL_COL_NAME ='FSTDENTRYCOSTCENTERID')
 ALTER TABLE T_ER_TRIPRESHARERULE ADD (FSTDENTRYCOSTCENTERID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_REIMBCLEARLOANENTRY' AND KSQL_COL_NAME ='FSTDENTRYCOSTCENTERID')
 ALTER TABLE T_ER_REIMBCLEARLOANENTRY ADD (FSTDENTRYCOSTCENTERID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_DAILYAPPLYDETAIL' AND KSQL_COL_NAME ='FSTDENTRYCOSTCENTERID')
 ALTER TABLE T_ER_DAILYAPPLYDETAIL ADD (FSTDENTRYCOSTCENTERID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_EXPENSESHAREDETAIL' AND KSQL_COL_NAME ='FSTDENTRYCOSTCENTERID')
 ALTER TABLE T_ER_EXPENSESHAREDETAIL ADD (FSTDENTRYCOSTCENTERID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_REPAYMENTBILL' AND KSQL_COL_NAME ='FSTDCOSTCENTERID')
 ALTER TABLE T_ER_REPAYMENTBILL ADD (FSTDCOSTCENTERID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_EXPENSESHAREBILL' AND KSQL_COL_NAME ='FSTDCOSTCENTERID')
 ALTER TABLE T_ER_EXPENSESHAREBILL ADD (FSTDCOSTCENTERID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_DAILYAPPLYBILL' AND KSQL_COL_NAME ='FSTDCOSTCENTERID')
 ALTER TABLE T_ER_DAILYAPPLYBILL ADD (FSTDCOSTCENTERID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_DAILYLOANDETAIL' AND KSQL_COL_NAME ='FSTDENTRYCOSTCENTERID')
 ALTER TABLE T_ER_DAILYLOANDETAIL ADD (FSTDENTRYCOSTCENTERID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_EXPENSESHAREWAIT' AND KSQL_COL_NAME ='FSTDENTRYCOSTCENTERID')
 ALTER TABLE T_ER_EXPENSESHAREWAIT ADD (FSTDENTRYCOSTCENTERID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_DAILYLOANBILL' AND KSQL_COL_NAME ='FSTDCOSTCENTERID')
 ALTER TABLE T_ER_DAILYLOANBILL ADD (FSTDCOSTCENTERID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_REIMBURSETRIPENTRY' AND KSQL_COL_NAME ='FSTDENTRYCOSTCENTERID')
 ALTER TABLE T_ER_REIMBURSETRIPENTRY ADD (FSTDENTRYCOSTCENTERID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_WRITEOFFDETAIL' AND KSQL_COL_NAME ='FSTDENTRYCOSTCENTERID')
 ALTER TABLE T_ER_WRITEOFFDETAIL ADD (FSTDENTRYCOSTCENTERID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_DAILYRESHAREDETAIL' AND KSQL_COL_NAME ='FSTDENTRYCOSTCENTERID')
 ALTER TABLE T_ER_DAILYRESHAREDETAIL ADD (FSTDENTRYCOSTCENTERID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_PUBLICRESHAREDETAIL' AND KSQL_COL_NAME ='FSTDENTRYCOSTCENTERID')
 ALTER TABLE T_ER_PUBLICRESHAREDETAIL ADD (FSTDENTRYCOSTCENTERID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_TRIPRESHAREDETAIL' AND KSQL_COL_NAME ='FSTDENTRYCOSTCENTERID')
 ALTER TABLE T_ER_TRIPRESHAREDETAIL ADD (FSTDENTRYCOSTCENTERID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_DAILYREIMBURSEBILL' AND KSQL_COL_NAME ='FSTDCOSTCENTERID')
 ALTER TABLE T_ER_DAILYREIMBURSEBILL ADD (FSTDCOSTCENTERID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_REIMBURSEBILL' AND KSQL_COL_NAME ='FSTDCOSTCENTERID')
 ALTER TABLE T_ER_REIMBURSEBILL ADD (FSTDCOSTCENTERID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_PUBREIMWRIOFFDET' AND KSQL_COL_NAME ='FSTDENTRYCOSTCENTERID')
 ALTER TABLE T_ER_PUBREIMWRIOFFDET ADD (FSTDENTRYCOSTCENTERID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_EXPENSEDETAIL' AND KSQL_COL_NAME ='FSTDENTRYCOSTCENTERID')
 ALTER TABLE T_ER_EXPENSEDETAIL ADD (FSTDENTRYCOSTCENTERID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_REIMBURSEENTRY' AND KSQL_COL_NAME ='FTRAVELCOSTCENTER')
 ALTER TABLE T_ER_REIMBURSEENTRY ADD (FTRAVELCOSTCENTER BIGINT DEFAULT 0 NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_REQBILL' AND KSQL_COL_NAME ='FSTDCOSTCENTERID')
 ALTER TABLE T_ER_REQBILL ADD (FSTDCOSTCENTERID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_REQTRIPENTRY' AND KSQL_COL_NAME ='FSTDENTRYCOSTCENTERID')
 ALTER TABLE T_ER_REQTRIPENTRY ADD (FSTDENTRYCOSTCENTERID BIGINT DEFAULT 0 NOT NULL );
