
--用量概率计算方案定义:物料转换
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_PROBABILITYCALDEF' AND KSQL_COL_NAME ='FMATERIALCHANGE')
ALTER TABLE T_MDS_PROBABILITYCALDEF ADD (FMATERIALCHANGE CHAR(1) NOT NULL DEFAULT '0');