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

📄 cs.sql.sql

📁 代码齐全
💻 SQL
📖 第 1 页 / 共 3 页
字号:
🔍
123 
	[InvNO] [char] (15) NOT NULL ,
	[YWY_P] [char] (5) NOT NULL ,
	[SHR_P] [char] (5) NOT NULL ,
	[YSR_P] [char] (5) NOT NULL ,
	[SPR_P] [char] (5) NOT NULL ,
	[FARece] [bit] NOT NULL ,
	[ValiFlag] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Skbd]    Script Date: 00-7-31 16:13:18 ******/
CREATE TABLE [dbo].[Skbd] (
	[BillNO] [char] (15) NOT NULL ,
	[theBillNO] [char] (15) NOT NULL ,
	[ItemCode] [char] (12) NOT NULL ,
	[ItemName] [varchar] (24) NOT NULL ,
	[Unit] [char] (6) NOT NULL ,
	[Specs] [char] (6) NOT NULL ,
	[price] [numeric](12, 4) NOT NULL ,
	[Qty] [numeric](8, 2) NOT NULL ,
	[Total] [numeric](12, 4) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Skhd]    Script Date: 00-7-31 16:13:19 ******/
CREATE TABLE [dbo].[Skhd] (
	[BillNO] [char] (15) NOT NULL ,
	[BillDate] [datetime] NOT NULL ,
	[ClientNO] [char] (8) NOT NULL ,
	[Client] [char] (24) NOT NULL ,
	[Receive] [numeric](12, 2) NOT NULL ,
	[CheckerNO] [char] (5) NOT NULL ,
	[InputerNO] [char] (5) NOT NULL ,
	[InvNO] [char] (15) NOT NULL ,
	[YWY_P] [char] (5) NOT NULL ,
	[SPR_P] [char] (5) NOT NULL ,
	[ValiFlag] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Stock]    Script Date: 00-7-31 16:13:19 ******/
CREATE TABLE [dbo].[Stock] (
	[Stock] [char] (1) NOT NULL ,
	[InCode] [char] (12) NOT NULL ,
	[ShortName] [varchar] (24) NOT NULL ,
	[Unit] [char] (6) NOT NULL ,
	[Specs] [char] (6) NOT NULL ,
	[Qty] [numeric](8, 2) NOT NULL ,
	[Cost] [numeric](12, 2) NOT NULL ,
	[TaxCost] [numeric](12, 2) NOT NULL ,
	[Saleroom] [numeric](12, 2) NOT NULL ,
	[ZQty] [numeric](8, 2) NOT NULL ,
	[ZCost] [numeric](12, 2) NOT NULL ,
	[ZTaxCost] [numeric](12, 2) NOT NULL ,
	[ZSaleroom] [numeric](12, 2) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[tempTab]    Script Date: 00-7-31 16:13:19 ******/
CREATE TABLE [dbo].[tempTab] (
	[Code] [char] (10) NOT NULL ,
	[Data] [numeric](18, 0) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Voubd]    Script Date: 00-7-31 16:13:19 ******/
CREATE TABLE [dbo].[Voubd] (
	[BillNO] [char] (15) NOT NULL ,
	[ItemCode] [char] (12) NOT NULL ,
	[ItemName] [varchar] (24) NOT NULL ,
	[Specs] [char] (6) NOT NULL ,
	[Unit] [char] (6) NOT NULL ,
	[Agio] [numeric](12, 4) NOT NULL ,
	[Qty] [numeric](8, 2) NOT NULL ,
	[ReceQty] [numeric](8, 0) NOT NULL ,
	[Total] [numeric](12, 4) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Vouhd]    Script Date: 00-7-31 16:13:20 ******/
CREATE TABLE [dbo].[Vouhd] (
	[BillNO] [char] (15) NOT NULL ,
	[BillNO_Send] [char] (15) NOT NULL ,
	[BillDate] [datetime] NOT NULL ,
	[ClientNO] [char] (8) NOT NULL ,
	[Client] [char] (24) NOT NULL ,
	[Total] [numeric](12, 2) NOT NULL ,
	[Receive] [numeric](12, 2) NOT NULL ,
	[CheckerNO] [char] (5) NOT NULL ,
	[InputerNO] [char] (5) NOT NULL ,
	[InvNO] [char] (15) NOT NULL ,
	[业务员] [char] (5) NOT NULL ,
	[审批人] [char] (5) NOT NULL ,
	[ValiFlag] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[部门主档]    Script Date: 00-7-31 16:13:20 ******/
CREATE TABLE [dbo].[部门主档] (
	[部门编码] [char] (2) NOT NULL ,
	[部门名称] [char] (20) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[储运出库明细]    Script Date: 00-7-31 16:13:21 ******/
CREATE TABLE [dbo].[储运出库明细] (
	[表单号] [char] (7) NOT NULL ,
	[商品编码] [char] (5) NOT NULL ,
	[商品名称] [char] (40) NOT NULL ,
	[单位] [char] (4) NOT NULL ,
	[出库数量] [numeric](9, 2) NOT NULL ,
	[规格] [char] (10) NOT NULL ,
	[备注] [varchar] (50) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[储运库存表头]    Script Date: 00-7-31 16:13:22 ******/
CREATE TABLE [dbo].[储运库存表头] (
	[表单号] [char] (7) NOT NULL ,
	[部门] [char] (2) NOT NULL ,
	[日期] [datetime] NOT NULL ,
	[审核人] [char] (5) NOT NULL ,
	[录入员] [char] (5) NOT NULL ,
	[入库人] [char] (5) NOT NULL ,
	[出入库标志] [bit] NOT NULL ,
	[确认标志] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[储运库存主档]    Script Date: 00-7-31 16:13:22 ******/
CREATE TABLE [dbo].[储运库存主档] (
	[商品编码] [char] (5) NOT NULL ,
	[商品名称] [char] (40) NOT NULL ,
	[单位] [char] (4) NOT NULL ,
	[日期] [datetime] NOT NULL ,
	[昨日库存] [numeric](9, 2) NOT NULL ,
	[今日入库] [numeric](9, 2) NOT NULL ,
	[今日出库] [numeric](9, 2) NOT NULL ,
	[今日库存] [numeric](9, 2) NOT NULL ,
	[规格] [char] (10) NOT NULL ,
	[确认标志] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[储运入库明细]    Script Date: 00-7-31 16:13:25 ******/
CREATE TABLE [dbo].[储运入库明细] (
	[表单号] [char] (7) NOT NULL ,
	[商品编码] [char] (5) NOT NULL ,
	[商品名称] [char] (40) NOT NULL ,
	[单位] [char] (4) NOT NULL ,
	[入库数量] [numeric](9, 2) NOT NULL ,
	[规格] [char] (10) NOT NULL ,
	[备注] [varchar] (50) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[合同档案]    Script Date: 00-7-31 16:13:25 ******/
CREATE TABLE [dbo].[合同档案] (
	[编号] [char] (13) NOT NULL ,
	[客户编码] [char] (4) NOT NULL ,
	[签订日期] [datetime] NOT NULL ,
	[签订地点] [char] (16) NOT NULL ,
	[商品规格] [char] (20) NOT NULL ,
	[包装] [char] (10) NOT NULL ,
	[交货日期] [datetime] NOT NULL ,
	[交货地点] [char] (20) NOT NULL ,
	[费用负担] [char] (10) NOT NULL ,
	[质量标准] [char] (20) NOT NULL ,
	[付款方式] [varchar] (50) NOT NULL ,
	[终止日期] [datetime] NOT NULL ,
	[确认标志] [bit] NOT NULL ,
	[终止标志] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[合同商品明细]    Script Date: 00-7-31 16:13:26 ******/
CREATE TABLE [dbo].[合同商品明细] (
	[合同编号] [char] (13) NOT NULL ,
	[商品编码] [char] (5) NOT NULL ,
	[商品名称] [char] (20) NOT NULL ,
	[数量] [numeric](9, 2) NOT NULL ,
	[单位] [char] (8) NOT NULL ,
	[单价] [numeric](9, 2) NOT NULL ,
	[税率] [numeric](4, 2) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[客户明细表]    Script Date: 00-7-31 16:13:26 ******/
CREATE TABLE [dbo].[客户明细表] (
	[表单号] [char] (7) NOT NULL ,
	[地区] [char] (8) NOT NULL ,
	[客户编码] [char] (4) NOT NULL ,
	[客户全称] [char] (50) NOT NULL ,
	[所在地区] [char] (10) NOT NULL ,
	[详细地址] [varchar] (50) NOT NULL ,
	[邮编] [char] (6) NOT NULL ,
	[开户行] [char] (40) NOT NULL ,
	[帐号] [char] (20) NOT NULL ,
	[税号] [char] (15) NOT NULL ,
	[法人] [char] (12) NOT NULL ,
	[电话] [char] (20) NOT NULL ,
	[传真] [char] (20) NOT NULL ,
	[电报挂号] [char] (14) NOT NULL ,
	[联系人] [char] (10) NOT NULL ,
	[联系电话] [char] (20) NOT NULL ,
	[传呼] [char] (20) NOT NULL ,
	[手机] [char] (20) NOT NULL ,
	[电子信箱] [char] (30) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[客户审批单]    Script Date: 00-7-31 16:13:27 ******/
CREATE TABLE [dbo].[客户审批单] (
	[表单号] [char] (7) NOT NULL ,
	[制表日期] [datetime] NOT NULL ,
	[部门编码] [char] (2) NOT NULL ,
	[审批人] [char] (5) NOT NULL ,
	[申报人] [char] (5) NOT NULL ,
	[录入员] [char] (5) NOT NULL ,
	[确认状态] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[客户帐户表头]    Script Date: 00-7-31 16:13:27 ******/
CREATE TABLE [dbo].[客户帐户表头] (
	[客户编码] [char] (4) NOT NULL ,
	[建立日期] [datetime] NOT NULL ,
	[审核人] [char] (5) NOT NULL ,
	[录入员] [char] (5) NOT NULL ,
	[确认状态] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[客户帐户明细]    Script Date: 00-7-31 16:13:27 ******/
CREATE TABLE [dbo].[客户帐户明细] (
	[客户编码] [char] (4) NOT NULL ,
	[信誉度等级] [char] (1) NOT NULL ,
	[放帐额度] [numeric](9, 0) NOT NULL ,
	[放帐期限] [char] (2) NOT NULL ,
	[折扣率] [numeric](4, 2) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[客户主档]    Script Date: 00-7-31 16:13:28 ******/
CREATE TABLE [dbo].[客户主档] (
	[客户编码] [char] (4) NOT NULL ,
	[地区] [char] (8) NOT NULL ,
	[客户全称] [char] (50) NOT NULL ,
	[所在地区] [char] (10) NOT NULL ,
	[详细地址] [char] (70) NOT NULL ,
	[邮编] [char] (6) NOT NULL ,
	[开户行] [char] (40) NOT NULL ,
	[帐号] [char] (20) NOT NULL ,
	[税号] [char] (15) NOT NULL ,
	[法人] [char] (12) NOT NULL ,
	[电话] [char] (20) NOT NULL ,
	[传真] [char] (20) NOT NULL ,
	[电报挂号] [char] (14) NOT NULL ,
	[联系人] [char] (10) NOT NULL ,
	[联系电话] [char] (20) NOT NULL ,
	[传呼] [char] (20) NOT NULL ,
	[手机] [char] (20) NOT NULL ,
	[电子信箱] [char] (30) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[人员档案]    Script Date: 00-7-31 16:13:28 ******/
CREATE TABLE [dbo].[人员档案] (
	[编码] [char] (5) NOT NULL ,
	[姓名] [char] (10) NOT NULL ,
	[部门编码] [char] (2) NOT NULL ,
	[职务] [char] (20) NOT NULL ,
	[权限] [char] (10) NOT NULL ,
	[口令] [char] (10) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[商品编码表]    Script Date: 00-7-31 16:13:29 ******/
CREATE TABLE [dbo].[商品编码表] (
	[表单号] [char] (7) NOT NULL ,
	[日期] [datetime] NOT NULL ,
	[部门编码] [char] (2) NOT NULL ,
	[审报人] [char] (5) NOT NULL ,
	[审批人] [char] (5) NOT NULL ,
	[录入员] [char] (5) NOT NULL ,
	[确认状态] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[商品编码明细]    Script Date: 00-7-31 16:13:29 ******/
CREATE TABLE [dbo].[商品编码明细] (
	[表单号] [char] (7) NOT NULL ,
	[商品编码] [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].[商品主档]    Script Date: 00-7-31 16:13:29 ******/
CREATE TABLE [dbo].[商品主档] (
	[商品编码] [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

ALTER TABLE [dbo].[R人员档案] WITH NOCHECK ADD 
	CONSTRAINT [DF_R人员档案_编码] DEFAULT (0) FOR [编码],
	CONSTRAINT [DF_R人员档案_姓名] DEFAULT (0) FOR [姓名],
	CONSTRAINT [DF_R人员档案_部门编码] DEFAULT (0) FOR [部门编码],
	CONSTRAINT [DF_R人员档案_职务] DEFAULT (0) FOR [职务]
GO

ALTER TABLE [dbo].[R商品主档] WITH NOCHECK ADD 
	CONSTRAINT [DF__R商品主档__商品编码] DEFAULT (0) FOR [商品编码],
	CONSTRAINT [DF__R商品主档__商品名称] DEFAULT (0) FOR [商品名称],
	CONSTRAINT [DF__R商品主档__商品简称] DEFAULT (0) FOR [商品简称],
	CONSTRAINT [DF__R商品主档__商品条码] DEFAULT (0) FOR [商品条码],
	CONSTRAINT [DF__R商品主档__规格__03F0984C] DEFAULT (0) FOR [规格],
	CONSTRAINT [DF__R商品主档__型号__04E4BC85] DEFAULT (0) FOR [型号],
	CONSTRAINT [DF__R商品主档__确认日期__05D8E0BE] DEFAULT (0) FOR [确认日期],
	CONSTRAINT [DF__R商品主档__修改日期__06CD04F7] DEFAULT (0) FOR [修改日期],
	CONSTRAINT [DF__R商品主档__单位] DEFAULT (0) FOR [单位],
	CONSTRAINT [DF__R商品主档__零售价] DEFAULT (0) FOR [零售价],
	CONSTRAINT [DF__R商品主档__税率__09A971A2] DEFAULT (0) FOR [税率],
	CONSTRAINT [DF__R商品主档__批发价] DEFAULT (0) FOR [批发价]
GO

ALTER TABLE [dbo].[部门主档] WITH NOCHECK ADD 
	CONSTRAINT [DF_部门主档_部门名称] DEFAULT (0) FOR [部门名称],
	CONSTRAINT [PK_部门主档] PRIMARY KEY  NONCLUSTERED 
	(
		[部门编码]
	)  ON [PRIMARY] 
GO
123

⌨️ 快捷键说明

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