cs.sql.sql

代码齐全

/****** Object:  View dbo.V库存日报    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[V库存日报]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[V库存日报]
GO

/****** Object:  View dbo.V销售明细    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[V销售明细]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[V销售明细]
GO

/****** Object:  View dbo.CKBill    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[CKBill]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[CKBill]
GO

/****** Object:  View dbo.RKBill    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[RKBill]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[RKBill]
GO

/****** Object:  View dbo.VR_Stock    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[VR_Stock]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[VR_Stock]
GO

/****** Object:  View dbo.回款明细    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[回款明细]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[回款明细]
GO

/****** Object:  View dbo.商品主档View    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[商品主档View]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[商品主档View]
GO

/****** Object:  View dbo.销售明细    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[销售明细]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[销售明细]
GO

/****** Object:  Table [dbo].[Ckbd]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Ckbd]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Ckbd]
GO

/****** Object:  Table [dbo].[Ckhd]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Ckhd]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Ckhd]
GO

/****** Object:  Table [dbo].[clerk]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[clerk]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[clerk]
GO

/****** Object:  Table [dbo].[R_stock]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[R_stock]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[R_stock]
GO

/****** Object:  Table [dbo].[Rkbd]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Rkbd]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Rkbd]
GO

/****** Object:  Table [dbo].[Rkhd]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Rkhd]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Rkhd]
GO

/****** Object:  Table [dbo].[R人员档案]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[R人员档案]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[R人员档案]
GO

/****** Object:  Table [dbo].[R商品主档]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[R商品主档]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[R商品主档]
GO

/****** Object:  Table [dbo].[Sendbd]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Sendbd]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Sendbd]
GO

/****** Object:  Table [dbo].[Sendhd]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Sendhd]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Sendhd]
GO

/****** Object:  Table [dbo].[Skbd]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Skbd]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Skbd]
GO

/****** Object:  Table [dbo].[Skhd]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Skhd]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Skhd]
GO

/****** Object:  Table [dbo].[Stock]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Stock]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Stock]
GO

/****** Object:  Table [dbo].[tempTab]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[tempTab]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tempTab]
GO

/****** Object:  Table [dbo].[Voubd]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Voubd]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Voubd]
GO

/****** Object:  Table [dbo].[Vouhd]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[Vouhd]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Vouhd]
GO

/****** Object:  Table [dbo].[部门主档]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[部门主档]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[部门主档]
GO

/****** Object:  Table [dbo].[储运出库明细]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[储运出库明细]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[储运出库明细]
GO

/****** Object:  Table [dbo].[储运库存表头]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[储运库存表头]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[储运库存表头]
GO

/****** Object:  Table [dbo].[储运库存主档]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[储运库存主档]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[储运库存主档]
GO

/****** Object:  Table [dbo].[储运入库明细]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[储运入库明细]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[储运入库明细]
GO

/****** Object:  Table [dbo].[合同档案]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[合同档案]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[合同档案]
GO

/****** Object:  Table [dbo].[合同商品明细]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[合同商品明细]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[合同商品明细]
GO

/****** Object:  Table [dbo].[客户明细表]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[客户明细表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[客户明细表]
GO

/****** Object:  Table [dbo].[客户审批单]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[客户审批单]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[客户审批单]
GO

/****** Object:  Table [dbo].[客户帐户表头]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[客户帐户表头]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[客户帐户表头]
GO

/****** Object:  Table [dbo].[客户帐户明细]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[客户帐户明细]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[客户帐户明细]
GO

/****** Object:  Table [dbo].[客户主档]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[客户主档]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[客户主档]
GO

/****** Object:  Table [dbo].[人员档案]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[人员档案]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[人员档案]
GO

/****** Object:  Table [dbo].[商品编码表]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[商品编码表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[商品编码表]
GO

/****** Object:  Table [dbo].[商品编码明细]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[商品编码明细]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[商品编码明细]
GO

/****** Object:  Table [dbo].[商品主档]    Script Date: 00-7-31 16:12:55 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[商品主档]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[商品主档]
GO

/****** Object:  Table [dbo].[Ckbd]    Script Date: 00-7-31 16:13:06 ******/
CREATE TABLE [dbo].[Ckbd] (
	[BillNO] [char] (15) NOT NULL ,
	[InCode] [char] (12) NOT NULL ,
	[ShortName] [varchar] (24) NOT NULL ,
	[Unit] [char] (6) NOT NULL ,
	[Specs] [char] (6) NOT NULL ,
	[Price] [numeric](12, 2) NOT NULL ,
	[Qty] [numeric](8, 2) NOT NULL ,
	[Saleroom] [numeric](12, 2) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Ckhd]    Script Date: 00-7-31 16:13:12 ******/
CREATE TABLE [dbo].[Ckhd] (
	[BillNO] [char] (15) NOT NULL ,
	[BillType] [char] (10) NOT NULL ,
	[theBillNO] [char] (15) NOT NULL ,
	[Depot] [char] (2) NOT NULL ,
	[BillDate] [datetime] NOT NULL ,
	[Total] [numeric](12, 4) NOT NULL ,
	[ClientNO] [char] (8) NOT NULL ,
	[CheckerNO] [char] (5) NOT NULL ,
	[SHR_P] [char] (5) NOT NULL ,
	[YWY_P] [char] (5) NOT NULL ,
	[InputerNO] [char] (5) NOT NULL ,
	[ValiFlag] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[clerk]    Script Date: 00-7-31 16:13:13 ******/
CREATE TABLE [dbo].[clerk] (
	[ucode] [char] (5) NOT NULL ,
	[uname] [char] (20) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[R_stock]    Script Date: 00-7-31 16:13:13 ******/
CREATE TABLE [dbo].[R_stock] (
	[Stock] [char] (2) NOT NULL ,
	[theDate] [datetime] NOT NULL ,
	[Incode] [char] (7) NOT NULL ,
	[Shortname] [char] (20) NOT NULL ,
	[Unit] [char] (4) NOT NULL ,
	[Qty_Y] [numeric](12, 0) NOT NULL ,
	[Cost_Y] [numeric](12, 0) NOT NULL ,
	[SR_Y] [numeric](12, 0) NOT NULL ,
	[Qty_T] [numeric](12, 0) NOT NULL ,
	[Cost_T] [numeric](12, 0) NOT NULL ,
	[SR_T] [numeric](12, 0) NOT NULL ,
	[Qty_TI] [numeric](12, 0) NOT NULL ,
	[Cost_TI] [numeric](12, 0) NOT NULL ,
	[SR_TI] [numeric](12, 0) NOT NULL ,
	[Qty_TO] [numeric](12, 0) NOT NULL ,
	[Cost_TO] [numeric](12, 0) NOT NULL ,
	[SR_TO] [numeric](12, 0) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Rkbd]    Script Date: 00-7-31 16:13:13 ******/
CREATE TABLE [dbo].[Rkbd] (
	[BillNO] [char] (15) NOT NULL ,
	[InCode] [char] (12) NOT NULL ,
	[ShortName] [varchar] (24) NOT NULL ,
	[Unit] [char] (6) NOT NULL ,
	[InPrice] [numeric](12, 4) NOT NULL ,
	[Price] [numeric](12, 2) NOT NULL ,
	[Cost] [numeric](12, 2) NOT NULL ,
	[Saleroom] [numeric](12, 2) NOT NULL ,
	[Specs] [char] (6) NOT NULL ,
	[Qty] [numeric](8, 2) NOT NULL ,
	[AvaiQty] [numeric](8, 2) NOT NULL ,
	[DateAllSale] [datetime] NOT NULL ,
	[DateAllPay] [datetime] NOT NULL ,
	[SaledQty] [numeric](8, 2) NOT NULL ,
	[PayedQty] [numeric](8, 2) NOT NULL ,
	[FlagAllSale] [bit] NOT NULL ,
	[FlagAllPay] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Rkhd]    Script Date: 00-7-31 16:13:14 ******/
CREATE TABLE [dbo].[Rkhd] (
	[BillNO] [char] (15) NOT NULL ,
	[BillDate] [datetime] NOT NULL ,
	[Depot] [char] (2) NOT NULL ,
	[SupplierNO] [char] (8) NOT NULL ,
	[CheckerNO] [char] (5) NOT NULL ,
	[YSY_P] [char] (5) NOT NULL ,
	[InputerNO] [char] (5) NOT NULL ,
	[Total] [numeric](12, 4) NOT NULL ,
	[Payed] [numeric](12, 4) NOT NULL ,
	[ValiFlag] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[R人员档案]    Script Date: 00-7-31 16:13:14 ******/
CREATE TABLE [dbo].[R人员档案] (
	[编码] [char] (3) NOT NULL ,
	[姓名] [char] (10) NOT NULL ,
	[部门编码] [char] (1) NOT NULL ,
	[职务] [char] (20) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[R商品主档]    Script Date: 00-7-31 16:13:14 ******/
CREATE TABLE [dbo].[R商品主档] (
	[商品编码] [char] (5) NOT NULL ,
	[商品名称] [char] (40) NOT NULL ,
	[商品简称] [char] (20) NOT NULL ,
	[商品条码] [char] (13) NOT NULL ,
	[规格] [char] (10) NOT NULL ,
	[型号] [char] (10) NOT NULL ,
	[确认日期] [datetime] NOT NULL ,
	[修改日期] [datetime] NOT NULL ,
	[单位] [char] (4) NOT NULL ,
	[零售价] [decimal](9, 2) NOT NULL ,
	[税率] [numeric](4, 2) NOT NULL ,
	[批发价] [decimal](9, 2) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Sendbd]    Script Date: 00-7-31 16:13:17 ******/
CREATE TABLE [dbo].[Sendbd] (
	[BillNO] [char] (15) NOT NULL ,
	[InCode] [char] (12) NOT NULL ,
	[ShortName] [varchar] (24) NOT NULL ,
	[Unit] [char] (6) NOT NULL ,
	[Specs] [char] (6) NOT NULL ,
	[Price] [numeric](12, 4) NOT NULL ,
	[Saleroom] [numeric](12, 2) NOT NULL ,
	[Qty] [numeric](12, 2) NOT NULL ,
	[AvaiQty] [numeric](12, 2) NOT NULL ,
	[ReceQty] [numeric](12, 2) NOT NULL ,
	[FAllRece] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Sendhd]    Script Date: 00-7-31 16:13:18 ******/
CREATE TABLE [dbo].[Sendhd] (
	[BillNO] [char] (15) NOT NULL ,
	[BillType] [bit] NOT NULL ,
	[BillDate] [datetime] NOT NULL ,
	[ClientNO] [char] (8) NOT NULL ,
	[Client] [char] (24) NOT NULL ,
	[Stock] [char] (2) NOT NULL ,
	[Total] [numeric](12, 0) NOT NULL ,
	[Receive] [numeric](12, 2) NOT NULL ,
	[CheckerNO] [char] (5) NOT NULL ,
	[InputerNO] [char] (5) NOT NULL ,
	[Item1] [char] (20) NOT NULL ,
	[Item2] [char] (20) NOT NULL ,
	[Item3] [char] (20) NOT NULL ,