
--物料编码转换增加转换前计量单位
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_TRANSFORM' AND KSQL_COL_NAME ='FUNITBEFORE')
ALTER TABLE T_MDS_TRANSFORM ADD (FUNITBEFORE BIGINT NOT NULL DEFAULT 0);
--物料编码转换增加转换后计量单位
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MDS_TRANSFORM' AND KSQL_COL_NAME ='FUNITAFTER')
ALTER TABLE T_MDS_TRANSFORM ADD (FUNITAFTER BIGINT NOT NULL DEFAULT 0);