/**Begin C:\PDM_UPGRADE\PDM1\SRC_table.sql **/
 EXEC p_AlterColumn 'T_SRC_SUPPLIERPICK', 'FINVITETYPE', 'CHAR(1)', 'NOT NULL', '0001', '''1''';

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_SUPPLIERPICK' AND KSQL_COL_NAME IN ('FCATEGORYLEVEL')) 
 ALTER TABLE T_SRC_SUPPLIERPICK ADD (FCATEGORYLEVEL INT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_SUPPLIERPICK' AND KSQL_COL_NAME IN ('FPURORGLEVEL')) 
 ALTER TABLE T_SRC_SUPPLIERPICK ADD (FPURORGLEVEL CHAR(1) DEFAULT '2' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_SUPPLIERPICK' AND KSQL_COL_NAME IN ('FISALLCATEGORY')) 
 ALTER TABLE T_SRC_SUPPLIERPICK ADD (FISALLCATEGORY CHAR(1) DEFAULT '1' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SRC_SUPPLIERPICK' AND KSQL_COL_NAME IN ('FISACCURATE')) 
 ALTER TABLE T_SRC_SUPPLIERPICK ADD (FISACCURATE CHAR(1) DEFAULT '0' NOT NULL );

/**End C:\PDM_UPGRADE\PDM1\SRC_table.sql **/
