⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 生产管理系统.sql

📁 这是一个用VS2003平台C#的生产管理系统
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
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].[采购订单o]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[采购订单o]
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].[领料单temp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[领料单temp]
GO

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

CREATE TABLE [dbo].[bom信息状态] (
	[状态代码] [char] (1) NOT NULL ,
	[状态描述] [varchar] (50) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[bom状态] (
	[状态代码] [char] (1) NOT NULL ,
	[状态描述] [varchar] (50) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[jzh每月结转日期表] (
	[月份] [int] NOT NULL ,
	[全称] [char] (4) NULL ,
	[结转日期] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[mrp0] (
	[内部编号] [int] IDENTITY (1, 1) NOT NULL ,
	[物料编号] [char] (20) NULL ,
	[年份] [int] NULL ,
	[计划期] [int] NULL ,
	[期初库存] [decimal](18, 4) NULL ,
	[预计入库] [decimal](18, 4) NULL ,
	[预计采购] [decimal](18, 4) NULL ,
	[预计生产] [decimal](18, 4) NULL ,
	[预计外协] [decimal](18, 4) NULL ,
	[预计出库] [decimal](18, 4) NULL ,
	[需求数量] [decimal](18, 4) NULL ,
	[建议采购] [decimal](18, 4) NULL ,
	[建议生产] [decimal](18, 4) NULL ,
	[建议外协] [decimal](18, 4) NULL ,
	[预计库存] [decimal](18, 4) NULL ,
	[安全库存] [decimal](18, 4) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[mrpcalcd] (
	[内部编号] [int] IDENTITY (1, 1) NOT NULL ,
	[物料编号] [char] (14) NOT NULL ,
	[年份] [int] NOT NULL ,
	[计划期] [int] NOT NULL ,
	[期初库存] [decimal](18, 4) NULL ,
	[毛需求] [decimal](18, 4) NULL ,
	[预计入库] [decimal](18, 4) NULL ,
	[预计出库] [decimal](18, 4) NULL ,
	[预计库存] [decimal](18, 4) NULL ,
	[净需求] [decimal](18, 4) NULL ,
	[计划产出] [decimal](18, 4) NULL ,
	[计划投入] [decimal](18, 4) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[mrpcalcm] (
	[低层码] [int] NULL ,
	[物料编号] [char] (14) NULL ,
	[计划代码] [char] (5) NULL ,
	[当前库存] [decimal](18, 4) NULL ,
	[逾期入库] [decimal](18, 4) NULL ,
	[逾期出库] [decimal](18, 4) NULL ,
	[提前期] [int] NULL ,
	[批量] [decimal](18, 4) NULL ,
	[安全库存] [decimal](18, 4) NULL ,
	[可用库存] [decimal](18, 4) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[mrp历史] (
	[内部编号] [int] IDENTITY (1, 1) NOT NULL ,
	[发布编号] [char] (20) NULL ,
	[物料编号] [char] (14) NOT NULL ,
	[年份] [int] NOT NULL ,
	[计划期] [int] NOT NULL ,
	[期初库存] [decimal](18, 4) NULL ,
	[毛需求] [decimal](18, 4) NULL ,
	[预计入库] [decimal](18, 4) NULL ,
	[预计出库] [char] (10) NULL ,
	[预计库存] [decimal](18, 4) NULL ,
	[净需求] [decimal](18, 4) NULL ,
	[计划产出] [decimal](18, 4) NULL ,
	[计划投入] [decimal](18, 4) NULL ,
	[能力计算标记] [char] (1) NOT NULL ,
	[生产订单标记] [char] (1) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[mrp发布时间] (
	[发布编号] [int] IDENTITY (1, 1) NOT NULL ,
	[年份] [int] NULL ,
	[计划期] [int] NULL ,
	[发布时间] [char] (20) NULL ,
	[发布人] [char] (10) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[mrp正式] (
	[内部编号] [int] IDENTITY (1, 1) NOT NULL ,
	[发布编号] [char] (20) NULL ,
	[物料编号] [char] (14) NOT NULL ,
	[年份] [int] NOT NULL ,
	[计划期] [int] NOT NULL ,
	[期初库存] [decimal](18, 4) NULL ,
	[毛需求] [decimal](18, 4) NULL ,
	[预计入库] [decimal](18, 4) NULL ,
	[预计出库] [char] (10) NULL ,
	[预计库存] [decimal](18, 4) NULL ,
	[净需求] [decimal](18, 4) NULL ,
	[计划产出] [decimal](18, 4) NULL ,
	[计划投入] [decimal](18, 4) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[mrp简单计算] (
	[内部编号] [int] IDENTITY (1, 1) NOT NULL ,
	[年份] [int] NULL ,
	[计划期] [int] NULL ,
	[物料编号] [char] (14) NULL ,
	[用量] [decimal](18, 4) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[mrp试算] (
	[内部编号] [int] IDENTITY (1, 1) NOT NULL ,
	[物料编号] [char] (14) NOT NULL ,
	[年份] [int] NOT NULL ,
	[计划期] [int] NOT NULL ,
	[期初库存] [decimal](18, 4) NULL ,
	[毛需求] [decimal](18, 4) NULL ,
	[预计入库] [decimal](18, 4) NULL ,
	[预计出库] [char] (10) NULL ,
	[预计库存] [decimal](18, 4) NULL ,
	[净需求] [decimal](18, 4) NULL ,
	[计划产出] [decimal](18, 4) NULL ,
	[计划投入] [decimal](18, 4) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[临时生产件资源负荷报表] (
	[资源编号] [char] (14) NOT NULL ,
	[日期] [int] NULL ,
	[年份] [int] NULL ,
	[计划期] [int] NULL ,
	[负荷] [float] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[临时资源负荷报表] (
	[资源编号] [char] (14) NOT NULL ,
	[日期] [int] NULL ,
	[年份] [int] NULL ,
	[计划期] [int] NULL ,
	[负荷] [float] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[临时进销存卡片] (
	[编号] [int] IDENTITY (1, 1) NOT NULL ,
	[部门] [varchar] (20) NOT NULL ,
	[组别] [varchar] (20) NOT NULL ,
	[货位] [varchar] (20) NULL ,
	[货号] [char] (14) NOT NULL ,
	[批号] [varchar] (20) NOT NULL ,
	[摘要] [varchar] (100) NOT NULL ,
	[单据号] [char] (14) NOT NULL ,
	[日期] [int] NULL ,
	[入库数量] [float] NOT NULL ,
	[入库金额] [float] NOT NULL ,
	[出库数量] [float] NOT NULL ,
	[出库金额] [float] NOT NULL ,
	[结存数量] [float] NOT NULL ,
	[结存金额] [float] NOT NULL ,
	[同货号数量] [float] NULL ,
	[同货号金额] [float] NULL ,
	[成本单价] [float] NULL ,
	[影响部门] [varchar] (20) NOT NULL ,
	[影响组别] [varchar] (100) NOT NULL ,
	[影响货位] [varchar] (20) NULL ,
	[接收登记] [binary] (30) NULL ,
	[记帐人] [char] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[主生产计划] (
	[内部编号] [int] IDENTITY (1, 1) NOT NULL ,
	[物料编号] [char] (14) NOT NULL ,
	[编号] [char] (14) NULL ,
	[年份] [int] NOT NULL ,
	[计划期] [int] NOT NULL ,
	[开始日期] [int] NULL ,
	[结束日期] [int] NULL ,
	[期初库存] [float] NULL ,
	[需求数量] [float] NULL ,
	[MPS数量] [float] NULL ,
	[生产单数量] [float] NULL ,
	[预计库存] [float] NULL ,
	[记帐人] [varchar] (10) NULL ,
	[修改日期] [int] NULL ,
	[修改标记] [char] (1) NULL ,
	[审核人] [varchar] (10) NULL ,
	[审核日期] [int] NULL ,
	[接收登记] [binary] (30) NULL ,
	[状态] [char] (10) NOT NULL Default '有效' ,
	[备注] [varchar] (40) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[主生产计划历史] (
	[内部编号] [int] IDENTITY (1, 1) NOT NULL ,
	[物料编号] [char] (14) NOT NULL ,
	[编号] [char] (14) NULL ,
	[年份] [int] NOT NULL ,
	[计划期] [int] NOT NULL ,
	[开始日期] [int] NULL ,
	[结束日期] [int] NULL ,
	[期初库存] [float] NULL ,
	[需求数量] [float] NULL ,
	[MPS数量] [float] NULL ,
	[生产单数量] [float] NULL ,
	[预计库存] [float] NULL ,
	[记帐人] [varchar] (10) NULL ,
	[修改日期] [int] NULL ,
	[修改标记] [char] (1) NULL ,
	[审核人] [varchar] (10) NULL ,
	[审核日期] [int] NULL ,
	[接收登记] [binary] (30) NULL ,
	[状态] [char] (10) NOT NULL ,
	[备注] [varchar] (40) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[主生产计划预排历史] (
	[内部编号] [int] IDENTITY (1, 1) NOT NULL ,
	[物料编号] [char] (14) NOT NULL ,
	[编号] [char] (14) NULL ,
	[年份] [int] NOT NULL ,
	[计划期] [int] NOT NULL ,
	[开始日期] [int] NULL ,
	[结束日期] [int] NULL ,
	[期初库存] [float] NULL ,
	[需求数量] [float] NULL ,
	[MPS数量] [float] NULL ,
	[生产单数量] [float] NULL ,
	[预计库存] [float] NULL ,
	[记帐人] [varchar] (10) NULL ,
	[修改日期] [int] NULL ,
	[修改标记] [char] (1) NULL ,
	[审核人] [varchar] (10) NULL ,
	[审核日期] [int] NULL ,
	[接收登记] [binary] (30) NULL ,
	[状态] [char] (10) NOT NULL ,
	[备注] [varchar] (40) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[主需求计划] (
	[内部编号] [int] IDENTITY (1, 1) NOT NULL ,
	[编号] [char] (14) NULL ,
	[物料编号] [char] (14) NOT NULL ,
	[年份] [int] NOT NULL ,
	[计划期] [int] NOT NULL ,
	[开始日期] [int] NULL ,
	[结束日期] [int] NULL ,
	[需求数量] [float] NULL ,
	[记帐人] [varchar] (10) NULL ,
	[修改日期] [int] NULL ,
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -