 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_SIMULATEFIELDENTRY' AND KSQL_COL_NAME ='FFIELDENTITY') 
 ALTER TABLE T_MRP_SIMULATEFIELDENTRY ADD (FFIELDENTITY NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_SIMULATIONCALCENTRY' AND KSQL_COL_NAME ='FENTRYQTYTYPE') 
 ALTER TABLE T_MRP_SIMULATIONCALCENTRY ADD (FENTRYQTYTYPE NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_SIMULATIONCALCENTRY' AND KSQL_COL_NAME ='FENTRYQTYNUMERATOR') 
 ALTER TABLE T_MRP_SIMULATIONCALCENTRY ADD (FENTRYQTYNUMERATOR DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_SIMULATIONCALCENTRY' AND KSQL_COL_NAME ='FENTRYQTYDENOMINATOR') 
 ALTER TABLE T_MRP_SIMULATIONCALCENTRY ADD (FENTRYQTYDENOMINATOR DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_SIMULATIONCALCENTRY' AND KSQL_COL_NAME ='FWASTAGERATEFORMULA') 
 ALTER TABLE T_MRP_SIMULATIONCALCENTRY ADD (FWASTAGERATEFORMULA NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_SIMULATIONDETAIL' AND KSQL_COL_NAME ='FENTRYQTYTYPE') 
 ALTER TABLE T_MRP_SIMULATIONDETAIL ADD (FENTRYQTYTYPE NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_SIMULATIONDETAIL' AND KSQL_COL_NAME ='FENTRYQTYNUMERATOR') 
 ALTER TABLE T_MRP_SIMULATIONDETAIL ADD (FENTRYQTYNUMERATOR DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_SIMULATIONDETAIL' AND KSQL_COL_NAME ='FENTRYQTYDENOMINATOR') 
 ALTER TABLE T_MRP_SIMULATIONDETAIL ADD (FENTRYQTYDENOMINATOR DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_SIMULATIONDETAIL' AND KSQL_COL_NAME ='FDYNAMICSCRAPRATIO') 
 ALTER TABLE T_MRP_SIMULATIONDETAIL ADD (FDYNAMICSCRAPRATIO DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_SIMULATIONDETAIL' AND KSQL_COL_NAME ='FFIXSCRAP') 
 ALTER TABLE T_MRP_SIMULATIONDETAIL ADD (FFIXSCRAP DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_SIMULATIONDETAIL' AND KSQL_COL_NAME ='FWASTAGERATEFORMULA') 
 ALTER TABLE T_MRP_SIMULATIONDETAIL ADD (FWASTAGERATEFORMULA NVARCHAR(50) DEFAULT ' ' NOT NULL );