/**Begin D:\PDM_UPGRADE\PDM1\POM_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_MFTORDERENTRY_E' AND KSQL_COL_NAME ='FISINSPECTION') 
 ALTER TABLE T_POM_MFTORDERENTRY_E ADD (FISINSPECTION CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_MFTORDERENTRY_E' AND KSQL_COL_NAME ='FACCEPTQTY') 
 ALTER TABLE T_POM_MFTORDERENTRY_E ADD (FACCEPTQTY DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_MFTORDERENTRY_E' AND KSQL_COL_NAME ='FISCONREPORTQTY') 
 ALTER TABLE T_POM_MFTORDERENTRY_E ADD (FISCONREPORTQTY CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_MFTORDERENTRY_E' AND KSQL_COL_NAME ='FREPMAXQTY') 
 ALTER TABLE T_POM_MFTORDERENTRY_E ADD (FREPMAXQTY DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_MFTORDERENTRY_E' AND KSQL_COL_NAME ='FREPMAXRATE') 
 ALTER TABLE T_POM_MFTORDERENTRY_E ADD (FREPMAXRATE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_MFTORDERENTRY_E' AND KSQL_COL_NAME ='FREPMINQTY') 
 ALTER TABLE T_POM_MFTORDERENTRY_E ADD (FREPMINQTY DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_MFTORDERENTRY_E' AND KSQL_COL_NAME ='FREPMINRATE') 
 ALTER TABLE T_POM_MFTORDERENTRY_E ADD (FREPMINRATE DECIMAL(23,10) DEFAULT 0 NOT NULL );
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_XMFTORDERENTRY_E' AND KSQL_COL_NAME ='FISINSPECTION') 
 ALTER TABLE T_POM_XMFTORDERENTRY_E ADD (FISINSPECTION CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_XMFTORDERENTRY_E' AND KSQL_COL_NAME ='FACCEPTQTY') 
 ALTER TABLE T_POM_XMFTORDERENTRY_E ADD (FACCEPTQTY DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_XMFTORDERENTRY_E' AND KSQL_COL_NAME ='FISCONREPORTQTY') 
 ALTER TABLE T_POM_XMFTORDERENTRY_E ADD (FISCONREPORTQTY CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_XMFTORDERENTRY_E' AND KSQL_COL_NAME ='FREPMAXQTY') 
 ALTER TABLE T_POM_XMFTORDERENTRY_E ADD (FREPMAXQTY DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_XMFTORDERENTRY_E' AND KSQL_COL_NAME ='FREPMAXRATE') 
 ALTER TABLE T_POM_XMFTORDERENTRY_E ADD (FREPMAXRATE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_XMFTORDERENTRY_E' AND KSQL_COL_NAME ='FREPMINQTY') 
 ALTER TABLE T_POM_XMFTORDERENTRY_E ADD (FREPMINQTY DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_XMFTORDERENTRY_E' AND KSQL_COL_NAME ='FREPMINRATE') 
 ALTER TABLE T_POM_XMFTORDERENTRY_E ADD (FREPMINRATE DECIMAL(23,10) DEFAULT 0 NOT NULL );

/**End D:\PDM_UPGRADE\PDM1\POM_table.sql **/
