生产管理系统.sql

其主要功能是对生产的一些监控

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SF_cg2审核采购订单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SF_cg2审核采购订单]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SF_cg5订货合同计划登记]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SF_cg5订货合同计划登记]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SYS清采购订单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SYS清采购订单]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SYS清采购订单审核]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SYS清采购订单审核]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp计算old]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[mrp计算old]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_KF2批次调拨单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_KF2批次调拨单]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cg1删除全部未用项]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cg1删除全部未用项]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cg1取得采购项]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cg1取得采购项]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cg1填写采购订单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cg1填写采购订单]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cg3修改采购订单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cg3修改采购订单]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cj1填生产订单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cj1填生产订单]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cj2审生产订单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cj2审生产订单]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cj5填完工报告单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cj5填完工报告单]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cj5由MRP生成生产订单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cj5由MRP生成生产订单]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_kf1填成品入库单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_kf1填成品入库单]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mps主生产计划审核]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mps主生产计划审核]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mps主生产计划预排]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mps主生产计划预排]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mps填需求计划]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mps填需求计划]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mrpMpsTest]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrpMpsTest]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mrpTest子项毛需求]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrpTest子项毛需求]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mrpTest计算]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrpTest计算]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mrpmps]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrpmps]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mrp子项毛需求]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrp子项毛需求]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mrp生产件资源负荷]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrp生产件资源负荷]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mrp计算]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrp计算]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mrp试算生产件资源负荷]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrp试算生产件资源负荷]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_sc生成领料单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_sc生成领料单]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_加入进销存卡片]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_加入进销存卡片]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sys生成资源日程表]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sys生成资源日程表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[低层码]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[低层码]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[V物料主文件]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[V物料主文件]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[v商品库存明细]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[v商品库存明细]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[v资源清单]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[v资源清单]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[v资源负荷报表]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[v资源负荷报表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bom信息状态]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bom信息状态]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bom状态]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bom状态]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[jzh每月结转日期表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[jzh每月结转日期表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp0]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[mrp0]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrpcalcd]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[mrpcalcd]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrpcalcm]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[mrpcalcm]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp历史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[mrp历史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp发布时间]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[mrp发布时间]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp正式]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[mrp正式]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp简单计算]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[mrp简单计算]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp试算]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[mrp试算]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[临时生产件资源负荷报表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[临时生产件资源负荷报表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[临时资源负荷报表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[临时资源负荷报表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[临时进销存卡片]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[临时进销存卡片]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[主生产计划]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[主生产计划]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[主生产计划历史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[主生产计划历史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[主生产计划预排历史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[主生产计划预排历史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[主需求计划]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[主需求计划]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[主需求计划历史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[主需求计划历史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[产品入库单]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[产品入库单]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[产品入库单历史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[产品入库单历史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[功能模块]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[功能模块]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[发布项清单]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[发布项清单]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[完工报告单]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[完工报告单]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[完工报告单历史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[完工报告单历史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[客户修改历史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[客户修改历史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[工作中心]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[工作中心]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[工厂日历]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[工厂日历]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[工艺线路主]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[工艺线路主]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[工艺线路细]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[工艺线路细]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[库存库]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[库存库]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[报损报溢历史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[报损报溢历史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[换货单历史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[换货单历史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[效期对照表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[效期对照表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[权限登记]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[权限登记]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[标准工序]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[标准工序]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料主文件]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[物料主文件]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料价值代码]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[物料价值代码]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料入库单]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[物料入库单]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料入库单历史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[物料入库单历史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料反查表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[物料反查表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料展开表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[物料展开表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料归属类别]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[物料归属类别]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料清单]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[物料清单]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料状态类别]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[物料状态类别]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料计划类别]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[物料计划类别]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料需求计划old]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[物料需求计划old]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[生产件资源负荷报表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[生产件资源负荷报表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[生产大纲]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[生产大纲]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[生产大纲历史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[生产大纲历史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[生产订单]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[生产订单]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[生产订单历史]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[生产订单历史]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[生产订单审核]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[生产订单审核]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[系统日志]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[系统日志]
GO


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[职工清单]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[职工清单]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[计划期参数]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[计划期参数]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[计量单位]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[计量单位]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[订货合同]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[订货合同]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[订货合同发布]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[订货合同发布]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[订货合同接收]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[订货合同接收]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[词库]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[词库]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[调拨单]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)