IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_mrp_simulationcalcentry' AND KSQL_COL_NAME ='fworkcenter')
 ALTER TABLE t_mrp_simulationcalcentry ADD (fworkcenter BIGINT DEFAULT 0 NOT NULL );
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_mrp_caldetailentry' AND KSQL_COL_NAME ='fworkcenter')
 ALTER TABLE t_mrp_caldetailentry ADD (fworkcenter BIGINT DEFAULT 0 NOT NULL );
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_mrp_cps_detailentry' AND KSQL_COL_NAME ='fworkcenter')
 ALTER TABLE t_mrp_cps_detailentry ADD (fworkcenter BIGINT DEFAULT 0 NOT NULL );
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_mrp_cps_short_detail' AND KSQL_COL_NAME ='fworkcenter')
 ALTER TABLE t_mrp_cps_short_detail ADD (fworkcenter BIGINT DEFAULT 0 NOT NULL );