IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_BILLINGPOOL' AND KSQL_COL_NAME ='FMODIFIED')
ALTER TABLE T_ER_BILLINGPOOL 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 ='FAPPLIERPOSITIONSTR')
ALTER TABLE T_ER_BILLINGPOOL ADD (FAPPLIERPOSITIONSTR NVARCHAR(10) DEFAULT ' ' NOT NULL);

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_BILLINGPOOL_E' AND KSQL_COL_NAME ='FVINCODE')
ALTER TABLE T_ER_BILLINGPOOL_E ADD (FVINCODE VARCHAR(50) DEFAULT ' ' NOT NULL);