IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_MFTREPORTSUMMARY' AND KSQL_COL_NAME ='FBASEUNIT') 
 ALTER TABLE T_POM_MFTREPORTSUMMARY ADD (FBASEUNIT BIGINT DEFAULT 0 NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_MFTREPORTSUMMARY' AND KSQL_COL_NAME ='FCOMPLETBSQTY') 
 ALTER TABLE T_POM_MFTREPORTSUMMARY ADD (FCOMPLETBSQTY DECIMAL(23,10) DEFAULT 0 NOT NULL);
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_MFTREPORTSUMMARY' AND KSQL_COL_NAME ='FQUALIFYBSQTY') 
 ALTER TABLE T_POM_MFTREPORTSUMMARY ADD (FQUALIFYBSQTY DECIMAL(23,10) DEFAULT 0 NOT NULL);
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_MFTREPORTSUMMARY' AND KSQL_COL_NAME ='FWORKWASTEBSQTY') 
 ALTER TABLE T_POM_MFTREPORTSUMMARY ADD (FWORKWASTEBSQTY DECIMAL(23,10) DEFAULT 0 NOT NULL);
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_MFTREPORTSUMMARY' AND KSQL_COL_NAME ='FSCRAPBSQTY') 
 ALTER TABLE T_POM_MFTREPORTSUMMARY ADD (FSCRAPBSQTY DECIMAL(23,10) DEFAULT 0 NOT NULL);
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_MFTREPORTSUMMARY' AND KSQL_COL_NAME ='FSCRAPPEDBSQTY') 
 ALTER TABLE T_POM_MFTREPORTSUMMARY ADD (FSCRAPPEDBSQTY DECIMAL(23,10) DEFAULT 0 NOT NULL);
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_MFTREPORTSUMMARY' AND KSQL_COL_NAME ='FREWORKBSQTY') 
 ALTER TABLE T_POM_MFTREPORTSUMMARY ADD (FREWORKBSQTY DECIMAL(23,10) DEFAULT 0 NOT NULL);
