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

📄 dstar2002-08-17.sql

📁 服装销售系统,VB开发.没有解压密码
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 

/****** Object:  Table [dbo].[分店销售信息]    Script Date: 2002-8-17 20:53:52 ******/
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: 2002-8-17 20:53:52 ******/
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: 2002-8-17 20:53:52 ******/
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: 2002-8-17 20:53:52 ******/
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: 2002-8-17 20:53:52 ******/
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: 2002-8-17 20:53:52 ******/
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: 2002-8-17 20:53:52 ******/
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: 2002-8-17 20:53:52 ******/
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: 2002-8-17 20:53:52 ******/
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: 2002-8-17 20:53:52 ******/
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: 2002-8-17 20:53:52 ******/
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: 2002-8-17 20:53:52 ******/
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: 2002-8-17 20:53:52 ******/
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: 2002-8-17 20:53:52 ******/
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: 2002-8-17 20:53:52 ******/
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: 2002-8-17 20:53:52 ******/
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: 2002-8-17 20:53:52 ******/
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: 2002-8-17 20:53:52 ******/
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: 2002-8-17 20:53:52 ******/
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: 2002-8-17 20:53:52 ******/
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: 2002-8-17 20:53:52 ******/
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: 2002-8-17 20:53:52 ******/
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: 2002-8-17 20:53:52 ******/
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: 2002-8-17 20:53:52 ******/
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: 2002-8-17 20:53:52 ******/
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: 2002-8-17 20:53:52 ******/
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: 2002-8-17 20:53:52 ******/
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: 2002-8-17 20:53:52 ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[月结报表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[月结报表]
GO

/****** Object:  Table [dbo].[bm]    Script Date: 2002-8-17 20:54:05 ******/
CREATE TABLE [dbo].[bm] (
	[Col001] [char] (40) NOT NULL ,
	[Col002] [char] (40) NOT NULL ,
	[Col003] [char] (10) NOT NULL ,
	[Col004] [char] (9) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Client]    Script Date: 2002-8-17 20:54:08 ******/
CREATE TABLE [dbo].[Client] (
	[ClientName] [char] (30) NOT NULL ,
	[ClientAdd] [char] (10) NOT NULL ,
	[ClientTel] [char] (20) NOT NULL ,
	[ClientHTel] [char] (20) NOT NULL ,
	[ClientBp] [char] (20) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[codetemp]    Script Date: 2002-8-17 20:54:08 ******/
CREATE TABLE [dbo].[codetemp] (
	[商品编码] [char] (13) NOT NULL ,
	[商品条码] [char] (13) NOT NULL ,
	[品名] [varchar] (40) NOT NULL ,
	[单位] [char] (6) NOT NULL ,
	[厂商编码] [char] (10) NOT NULL ,
	[进价] [decimal](12, 4) NOT NULL ,
	[税率] [decimal](12, 2) NOT NULL ,
	[零售价] [decimal](12, 2) NOT NULL ,
	[含税进价] [decimal](12, 2) NOT NULL ,
	[废弃标志] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[color]    Script Date: 2002-8-17 20:54:09 ******/
CREATE TABLE [dbo].[color] (
	[colorname] [char] (10) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[GoodsType]    Script Date: 2002-8-17 20:54:10 ******/
CREATE TABLE [dbo].[GoodsType] (
	[类别] [char] (20) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[inf_sys]    Script Date: 2002-8-17 20:54:11 ******/
CREATE TABLE [dbo].[inf_sys] (
	[ParaName] [char] (20) NULL ,
	[Seting] [char] (40) NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[InOutStore]    Script Date: 2002-8-17 20:54:11 ******/
CREATE TABLE [dbo].[InOutStore] (
	[商品编码] [char] (15) NOT NULL ,
	[品名] [char] (40) NOT NULL ,
	[单位] [char] (10) NOT NULL ,
	[颜色] [char] (20) NOT NULL ,
	[尺寸] [char] (20) NOT NULL ,
	[上期结存数量] [numeric](18, 2) NOT NULL ,
	[上期结存金额] [numeric](18, 2) NOT NULL ,
	[本期购进数量] [numeric](18, 2) NOT NULL ,
	[本期购进金额] [numeric](18, 2) NOT NULL ,
	[本期发出数量] [numeric](18, 2) NOT NULL ,
	[本期发出金额] [numeric](18, 2) NOT NULL ,
	[本期结存数量] [numeric](18, 2) NOT NULL ,
	[本期结存金额] [numeric](18, 2) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[istock]    Script Date: 2002-8-17 20:54:12 ******/
CREATE TABLE [dbo].[istock] (
	[purcode] [char] (13) NOT NULL ,
	[purdate] [datetime] NOT NULL ,
	[gcode] [char] (7) NOT NULL ,
	[gname] [char] (30) NOT NULL ,
	[gunit] [char] (10) NOT NULL ,
	[qty] [numeric](18, 0) NOT NULL ,
	[size] [char] (10) NOT NULL ,
	[color] [char] (10) NOT NULL ,
	[sflag] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[LocalMsg]    Script Date: 2002-8-17 20:54:12 ******/
CREATE TABLE [dbo].[LocalMsg] (
	[LCODE] [char] (10) NOT NULL ,
	[LNAME] [char] (40) NOT NULL ,
	[UPLOADPATH] [char] (40) NOT NULL ,
	[LUPLOADPATH] [char] (40) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[LSChainPDD]    Script Date: 2002-8-17 20:54:13 ******/
CREATE TABLE [dbo].[LSChainPDD] (
	[表单号] [char] (15) NOT NULL ,
	[经营公司] [char] (40) NOT NULL ,
	[配送日期] [datetime] NOT NULL ,
	[分店编码] [char] (4) NOT NULL ,
	[分店名称] [char] (40) NOT NULL ,
	[审批人] [char] (20) NOT NULL ,
	[收货人] [char] (20) NOT NULL ,
	[制表人] [char] (20) NOT NULL ,
	[录入员] [char] (20) NOT NULL ,
	[商品编码] [char] (13) NOT NULL ,
	[品名] [char] (40) NOT NULL ,
	[单位] [char] (6) NOT NULL ,
	[颜色] [char] (20) NOT NULL ,
	[尺寸] [char] (10) NOT NULL ,
	[配送数量] [numeric](12, 0) NOT NULL ,
	[进价] [numeric](12, 4) NOT NULL ,
	[零售价] [numeric](12, 2) NOT NULL ,
	[进价金额] [numeric](12, 2) NOT NULL ,
	[售价金额] [numeric](12, 2) NOT NULL ,
	[开发票标志] [bit] NOT NULL ,
	[开发票日期] [datetime] NOT NULL ,
	[确认状态] [bit] NOT NULL ,
	[含税进价] [numeric](18, 2) NOT NULL ,
	[备注] [char] (50) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[LSDBD]    Script Date: 2002-8-17 20:54:13 ******/
CREATE TABLE [dbo].[LSDBD] (
	[表单号] [char] (7) NOT NULL ,
	[制表日期] [datetime] NOT NULL ,
	[调出部门] [char] (40) NOT NULL ,
	[调入部门] [char] (40) NOT NULL ,
	[调出柜长] [char] (5) NOT NULL ,
	[调入柜长] [char] (5) NOT NULL ,
	[制表员] [char] (5) NOT NULL ,
	[录入员] [char] (5) NOT NULL ,
	[供应商] [char] (8) NOT NULL ,
	[商品编码] [char] (13) NOT NULL ,
	[品名] [char] (24) NOT NULL ,
	[单位] [char] (4) NOT NULL ,
	[颜色] [char] (20) NOT NULL ,
	[尺寸] [char] (10) NOT NULL ,
	[数量] [numeric](8, 2) NOT NULL ,
	[调出价] [numeric](12, 4) NOT NULL ,
	[调出金额] [numeric](12, 2) NOT NULL ,
	[调入价] [numeric](12, 2) NOT NULL ,
	[调入金额] [numeric](8, 4) NOT NULL ,
	[零售价] [numeric](18, 2) NOT NULL ,
	[售价金额] [numeric](18, 2) NOT NULL ,
	[确认状态] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[LSDHD]    Script Date: 2002-8-17 20:54:14 ******/
CREATE TABLE [dbo].[LSDHD] (
	[表单号] [char] (15) NOT NULL ,
	[分店编码] [char] (4) NOT NULL ,
	[制表日期] [datetime] NOT NULL ,
	[到货日期] [datetime] NOT NULL ,
	[厂商编码] [char] (3) NOT NULL ,
	[订货员] [char] (5) NOT NULL ,
	[审核员] [char] (5) NOT NULL ,
	[收货员] [char] (5) NOT NULL ,
	[验收员] [char] (5) NOT NULL ,
	[录入员] [char] (5) NOT NULL ,
	[商品编码] [char] (13) NOT NULL ,
	[品名] [char] (40) NOT NULL ,
	[单位] [char] (6) NOT NULL ,
	[颜色] [char] (20) NOT NULL ,
	[尺寸] [char] (10) NOT NULL ,
	[进价] [numeric](12, 4) NOT NULL ,
	[零售价] [numeric](12, 2) NOT NULL ,
	[进价金额] [numeric](12, 2) NOT NULL ,
	[售价金额] [numeric](12, 2) NOT NULL ,
	[进货数量] [numeric](8, 2) NOT NULL ,
	[有效数量] [numeric](8, 2) NOT NULL ,
	[售完日期] [datetime] NOT NULL ,
	[已售数量] [numeric](8, 2) NOT NULL ,
	[售完标志] [bit] NOT NULL ,
	[确认状态] [bit] NOT NULL ,
	[含税进价] [numeric](18, 2) NOT NULL ,
	[含税进价金额] [numeric](18, 2) NOT NULL ,
	[税率] [numeric](18, 2) NOT NULL ,
	[备注] [char] (50) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[LSJHD]    Script Date: 2002-8-17 20:54:15 ******/
CREATE TABLE [dbo].[LSJHD] (
12345

⌨️ 快捷键说明

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