--制造BOM的联副产品分录增加工程变更单号
--工程变更单编码
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PDM_MFTBOMCOPENTRY' AND KSQL_COL_NAME ='FCOPENTRYECNNO')
ALTER TABLE T_PDM_MFTBOMCOPENTRY ADD (FCOPENTRYECNNO NVARCHAR(80)   DEFAULT  ' '  NOT NULL);


--制造BOM的联副产品分录增加顺序号
--顺序号
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PDM_MFTBOMCOPENTRY' AND KSQL_COL_NAME ='FCOPENTRYSEQ')
ALTER TABLE T_PDM_MFTBOMCOPENTRY ADD (FCOPENTRYSEQ  BIGINT DEFAULT 0 NOT NULL);



