IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_BILLINGPOOL_E' AND KSQL_COL_NAME ='FMODIFIED')
ALTER TABLE T_ER_BILLINGPOOL_E ADD (FMODIFIED CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_BILLINGPOOL' AND KSQL_COL_NAME ='FRELBILLTYPE')
ALTER TABLE T_ER_BILLINGPOOL ADD (FRELBILLTYPE NVARCHAR(200) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_BILLINGPOOL_L' AND KSQL_COL_NAME ='FRELBILLTYPE')
ALTER TABLE T_ER_BILLINGPOOL_L ADD (FRELBILLTYPE NVARCHAR(200) DEFAULT ' ' NOT NULL );
