IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_CPS_PLANPRO' AND KSQL_COL_NAME ='FRESULTRESERVE') 
ALTER TABLE T_MRP_CPS_PLANPRO ADD (FRESULTRESERVE NVARCHAR(50) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_CPS_SENTRY' AND KSQL_COL_NAME ='FRESERVETYPE') 
ALTER TABLE T_MRP_CPS_SENTRY ADD (FRESERVETYPE NVARCHAR(50) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_CPS_DETAILENTRY' AND KSQL_COL_NAME ='FISRESEVE') 
ALTER TABLE T_MRP_CPS_DETAILENTRY ADD (FISRESEVE CHAR(1) 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 ='FISRESEVE') 
ALTER TABLE T_MRP_CPS_SHORT_DETAIL ADD (FISRESEVE CHAR(1) DEFAULT '0' NOT NULL );
