--协同计划新增配置号，跟踪号，单据类型
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_RATIVEORDER' AND KSQL_COL_NAME ='FCONFIGUREDCODE') 
 ALTER TABLE T_MRP_RATIVEORDER ADD (FCONFIGUREDCODE BIGINT DEFAULT 0 NOT NULL );
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_RATIVEORDER' AND KSQL_COL_NAME ='FTRACKNUMBER') 
 ALTER TABLE T_MRP_RATIVEORDER ADD (FTRACKNUMBER BIGINT DEFAULT 0 NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_RATIVEORDER' AND KSQL_COL_NAME ='FBILLTYPEID') 
 ALTER TABLE T_MRP_RATIVEORDER ADD (FBILLTYPEID BIGINT DEFAULT 0 NOT NULL );