
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_INVOICEINFOCP' AND KSQL_COL_NAME IN ('FNODEDUCTIONREASON'))
 ALTER TABLE T_ER_INVOICEINFOCP ADD (FNODEDUCTIONREASON VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_INVOICEINFO' AND KSQL_COL_NAME IN ('FNODEDUCTIONREASON'))
 ALTER TABLE T_ER_INVOICEINFO ADD (FNODEDUCTIONREASON VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_PUBREIMINVOICEINFO' AND KSQL_COL_NAME IN ('FNODEDUCTIONREASON'))
 ALTER TABLE T_ER_PUBREIMINVOICEINFO ADD (FNODEDUCTIONREASON VARCHAR(2) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_PUBREIMEXPDET' AND KSQL_COL_NAME IN ('FITEMNODEDUCTIONREASON'))
 ALTER TABLE T_ER_PUBREIMEXPDET ADD (FITEMNODEDUCTIONREASON VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_REIMBURSEENTRY' AND KSQL_COL_NAME IN ('FITEMNODEDUCTIONREASON'))
 ALTER TABLE T_ER_REIMBURSEENTRY ADD (FITEMNODEDUCTIONREASON VARCHAR(2) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_EXPENSEDETAIL' AND KSQL_COL_NAME IN ('FITEMNODEDUCTIONREASON'))
 ALTER TABLE T_ER_EXPENSEDETAIL ADD (FITEMNODEDUCTIONREASON VARCHAR(2) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_BILLINGPOOL' AND KSQL_COL_NAME IN ('FNODEDUCTIONREASON'))
 ALTER TABLE T_ER_BILLINGPOOL ADD (FNODEDUCTIONREASON VARCHAR(2) DEFAULT ' ' NOT NULL );

