/**Begin D:\PDM_UPGRADE\PDM1\MRP_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_RATIVEORDER' AND KSQL_COL_NAME ='FINTER_COLLABORTYPE')
 ALTER TABLE T_MRP_RATIVEORDER ADD (FINTER_COLLABORTYPE BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_RATIVEORDER' AND KSQL_COL_NAME ='FINWARELOCATION')
 ALTER TABLE T_MRP_RATIVEORDER ADD (FINWARELOCATION BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_RATIVEORDER' AND KSQL_COL_NAME ='FINWAREHOUSE')
 ALTER TABLE T_MRP_RATIVEORDER ADD (FINWAREHOUSE BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_RATIVEORDER' AND KSQL_COL_NAME ='FINWARORG')
 ALTER TABLE T_MRP_RATIVEORDER ADD (FINWARORG BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_RATIVEORDER' AND KSQL_COL_NAME ='FPLANSCOPE')
 ALTER TABLE T_MRP_RATIVEORDER ADD (FPLANSCOPE BIGINT DEFAULT 0 NOT NULL );

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