new.sql

这是个很好比较齐全的合同管理系统大家可以下载有很多用途

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

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

if exists (select * from sysobjects where id = object_id(N'[dbo].[VIEW_购货合同]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[VIEW_购货合同]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[VIEW_销货合同]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[VIEW_销货合同]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[收款情况报表]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[收款情况报表]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[收款情况报表清单]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[收款情况报表清单]
GO

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

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

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

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

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

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

if exists (select * from sysobjects where id = object_id(N'[dbo].[工程进度和人员配置情况]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[工程进度和人员配置情况]
GO

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

if exists (select * from sysobjects where id = object_id(N'[dbo].[交货情况记录表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[交货情况记录表]
GO

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

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

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

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

if exists (select * from sysobjects where id = object_id(N'[dbo].[设备交款情况]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[设备交款情况]
GO

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

if exists (select * from sysobjects where id = object_id(N'[dbo].[销售合同收款审定单]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[销售合同收款审定单]
GO

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

CREATE TABLE [dbo].[帮助表] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[帮助] [text] NULL ,
	[窗口] [varchar] (20) NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[报表索引] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[报表显示名] [char] (10) NULL ,
	[报表文件名] [char] (10) NULL ,
	[文件类型] [char] (10) NULL ,
	[检索条件] [text] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[币种信息] (
	[币种] [varchar] (10) NOT NULL ,
	[汇率] [real] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[付款方式信息] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[付款方式] [varchar] (10) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[付款类别信息] (
	[付款类别] [char] (10) NOT NULL ,
	[说明] [char] (10) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[付款申请表] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[合同号] [varchar] (10) NULL ,
	[项目编号] [varchar] (10) NULL ,
	[项目名称] [varchar] (20) NULL ,
	[日期] [datetime] NULL ,
	[收款单位] [varchar] (20) NULL ,
	[付款类型] [varchar] (10) NULL ,
	[付款比例] [varchar] (10) NULL ,
	[银行帐号] [varchar] (10) NULL ,
	[金额] [money] NULL ,
	[原因] [varchar] (50) NULL ,
	[核定会计] [varchar] (10) NULL ,
	[会计] [varchar] (10) NULL ,
	[出纳] [varchar] (10) NULL ,
	[总经理审批] [varchar] (10) NULL ,
	[部门经理] [varchar] (10) NULL ,
	[申请人] [varchar] (10) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[工程进度和人员配置情况] (
	[项目编号] [varchar] (10) NOT NULL ,
	[工程负责人] [varchar] (10) NULL ,
	[施工图纸] [varchar] (100) NULL ,
	[联动条件] [text] NULL ,
	[施工配合] [text] NULL ,
	[工程调试] [text] NULL ,
	[验收] [bit] NULL ,
	[日期] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[供应商信息] (
	[供应商编号] [varchar] (10) NOT NULL ,
	[单位名称] [varchar] (20) NULL ,
	[单位地址] [varchar] (50) NULL ,
	[邮政编码] [varchar] (10) NULL ,
	[电子邮件] [varchar] (50) NULL ,
	[联系人] [varchar] (20) NULL ,
	[地区] [varchar] (10) NULL ,
	[电话] [varchar] (20) NULL ,
	[寻呼] [varchar] (20) NULL ,
	[银行] [varchar] (20) NULL ,
	[户名] [varchar] (20) NULL ,
	[帐号] [varchar] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[购货合同] (
	[公司合同号] [varchar] (10) NOT NULL ,
	[项目编号] [varchar] (10) NULL ,
	[合同号] [varchar] (10) NULL ,
	[甲方] [varchar] (50) NULL ,
	[乙方] [varchar] (50) NULL ,
	[设备总价] [money] NULL ,
	[合同总价] [money] NULL ,
	[签约金额] [money] NULL ,
	[签约币种] [varchar] (10) NULL ,
	[报价时间] [datetime] NULL ,
	[职员编号] [varchar] (10) NULL ,
	[供应商编号] [varchar] (10) NULL ,
	[合同正文] [image] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[购货合同到货情况] (
	[公司合同号] [varchar] (10) NOT NULL ,
	[到货类型] [varchar] (10) NULL ,
	[日期] [datetime] NULL ,
	[应付数] [real] NULL ,
	[实付数] [real] NULL ,
	[金额] [money] NULL ,
	[币种] [varchar] (10) NULL ,
	[比例] [real] NULL ,