/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\POM_table.sql **/
--生产组件清单分录 新增工程变更号、工程变更BOM分录ID
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_pom_manustockentry' AND KSQL_COL_NAME ='fecobillno') 
 ALTER TABLE t_pom_manustockentry ADD (fecobillno NVARCHAR(80) DEFAULT ' ' NOT NULL);
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_pom_manustockentry' AND KSQL_COL_NAME ='fecobomentryid') 
 ALTER TABLE t_pom_manustockentry ADD (fecobomentryid BIGINT DEFAULT 0 NOT NULL);
 
 --生产组件清单变更单分录 新增工程变更号、工程变更BOM分录ID
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_pom_xmanustockentry' AND KSQL_COL_NAME ='fecobillno') 
 ALTER TABLE t_pom_xmanustockentry ADD (fecobillno NVARCHAR(80) DEFAULT ' ' NOT NULL);
 
  IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_pom_xmanustockentry' AND KSQL_COL_NAME ='fecobomentryid') 
 ALTER TABLE t_pom_xmanustockentry ADD (fecobomentryid BIGINT DEFAULT 0 NOT NULL);
 
/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\POM_table.sql **/
