 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_MROORDERENTRY_S' AND KSQL_COL_NAME ='FPARTNUMBER') 
 ALTER TABLE T_POM_MROORDERENTRY_S ADD (FPARTNUMBER NVARCHAR(255) DEFAULT ' ' NOT NULL);
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_MROORDERENTRY_S' AND KSQL_COL_NAME ='FPARTNAME') 
 ALTER TABLE T_POM_MROORDERENTRY_S ADD (FPARTNAME NVARCHAR(255) DEFAULT ' ' NOT NULL);
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_MROORDERENTRY_P' AND KSQL_COL_NAME ='FPARTNUMBER') 
 ALTER TABLE T_POM_MROORDERENTRY_P ADD (FPARTNUMBER NVARCHAR(255) DEFAULT ' ' NOT NULL);
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_MROORDERENTRY_P' AND KSQL_COL_NAME ='FPARTNAME') 
 ALTER TABLE T_POM_MROORDERENTRY_P ADD (FPARTNAME NVARCHAR(255) DEFAULT ' ' NOT NULL);