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

📄 dstar2002-08-17.sql

📁 服装销售系统,VB开发.没有解压密码
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
	[调出柜长] [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 ,
	[数量] [numeric](8, 2) NOT NULL ,
	[不含税进价] [numeric](12, 4) NOT NULL ,
	[不含税进价金额] [numeric](12, 2) 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].[经销进货单]    Script Date: 2002-8-17 20:54:34 ******/
CREATE TABLE [dbo].[经销进货单] (
	[表单号] [char] (15) NOT NULL ,
	[分店编码] [char] (4) 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 ,
	[进价] [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 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[经销进价调整单]    Script Date: 2002-8-17 20:54:35 ******/
CREATE TABLE [dbo].[经销进价调整单] (
	[表单号] [char] (7) NOT NULL ,
	[制表日期] [datetime] NOT NULL ,
	[厂商编码] [char] (3) NOT NULL ,
	[审核员] [char] (5) NOT NULL ,
	[部门经理] [char] (5) NOT NULL ,
	[录入员] [char] (5) NOT NULL ,
	[商品编码] [char] (13) NOT NULL ,
	[品名] [char] (40) NOT NULL ,
	[单位] [char] (4) NOT NULL ,
	[数量] [decimal](9, 4) NOT NULL ,
	[原进价] [decimal](10, 4) NOT NULL ,
	[现进价] [decimal](10, 4) NOT NULL ,
	[进价差额] [decimal](10, 4) NOT NULL ,
	[确认状态] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[经销退货单]    Script Date: 2002-8-17 20:54:36 ******/
CREATE TABLE [dbo].[经销退货单] (
	[表单号] [char] (14) NOT NULL ,
	[分店编码] [char] (4) 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 ,
	[进价] [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 ,
	[确认状态] [bit] NOT NULL ,
	[含税进价] [numeric](18, 2) NOT NULL ,
	[含税进价金额] [numeric](18, 2) NOT NULL ,
	[税率] [numeric](18, 2) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[经销优惠调价单]    Script Date: 2002-8-17 20:54:36 ******/
CREATE TABLE [dbo].[经销优惠调价单] (
	[表单号] [char] (7) NOT NULL ,
	[制表日期] [datetime] NOT NULL ,
	[优惠部门] [char] (6) NOT NULL ,
	[审核员] [char] (5) NOT NULL ,
	[部门经理] [char] (5) NOT NULL ,
	[录入员] [char] (5) NOT NULL ,
	[商品编码] [char] (13) NOT NULL ,
	[品名] [char] (40) NOT NULL ,
	[单位] [char] (10) NOT NULL ,
	[数量] [numeric](12, 2) NOT NULL ,
	[原进价] [numeric](10, 4) NOT NULL ,
	[现进价] [numeric](10, 4) NOT NULL ,
	[原售价] [numeric](10, 4) NOT NULL ,
	[现售价] [numeric](10, 4) NOT NULL ,
	[进价差额] [numeric](10, 4) NOT NULL ,
	[售价差额] [numeric](10, 4) NOT NULL ,
	[确认状态] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[连锁店销售周报]    Script Date: 2002-8-17 20:54:37 ******/
CREATE TABLE [dbo].[连锁店销售周报] (
	[连锁店编码] [char] (5) NOT NULL ,
	[连锁店] [char] (40) NOT NULL ,
	[本周销售额] [decimal](18, 2) NOT NULL ,
	[累计销售额] [decimal](18, 2) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[盘点盈亏报告单]    Script Date: 2002-8-17 20:54:37 ******/
CREATE TABLE [dbo].[盘点盈亏报告单] (
	[销售方式] [char] (4) NOT NULL ,
	[分店编码] [char] (4) NOT NULL ,
	[表单号] [char] (7) NOT NULL ,
	[制表日期] [datetime] NOT NULL ,
	[盘点部门] [char] (10) NOT NULL ,
	[经理] [char] (5) NOT NULL ,
	[审核员] [char] (5) NOT NULL ,
	[录入员] [char] (5) NOT NULL ,
	[商品编码] [char] (13) NOT NULL ,
	[品名] [char] (40) NOT NULL ,
	[单位] [char] (4) NOT NULL ,
	[进价] [numeric](12, 2) NOT NULL ,
	[零售价] [numeric](6, 2) NOT NULL ,
	[盘亏数量] [numeric](12, 2) NOT NULL ,
	[盘亏金额] [numeric](18, 0) NOT NULL ,
	[确认状态] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[配送中心库存]    Script Date: 2002-8-17 20:54:38 ******/
CREATE TABLE [dbo].[配送中心库存] (
	[商品编码] [char] (13) NOT NULL ,
	[品名] [char] (40) NOT NULL ,
	[数量] [numeric](12, 2) NOT NULL ,
	[进价金额] [numeric](12, 2) NOT NULL ,
	[售价金额] [numeric](12, 2) NOT NULL ,
	[单位] [char] (4) NOT NULL ,
	[颜色] [char] (20) NOT NULL ,
	[尺寸] [char] (10) NOT NULL ,
	[含税进价金额] [numeric](18, 2) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[配送中心盘点轧帐]    Script Date: 2002-8-17 20:54:38 ******/
CREATE TABLE [dbo].[配送中心盘点轧帐] (
	[经营方式] [char] (4) NOT NULL ,
	[商品编码] [char] (13) NOT NULL ,
	[品名] [char] (40) NOT NULL ,
	[单位] [char] (4) NOT NULL ,
	[数量] [numeric](12, 2) NOT NULL ,
	[进价金额] [numeric](12, 2) NOT NULL ,
	[售价金额] [numeric](12, 2) NOT NULL ,
	[轧帐日期] [datetime] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[批发单]    Script Date: 2002-8-17 20:54:39 ******/
CREATE TABLE [dbo].[批发单] (
	[表单号] [char] (7) NOT NULL ,
	[制表日期] [datetime] NOT NULL ,
	[客户] [char] (40) NOT NULL ,
	[审核员] [char] (5) NOT NULL ,
	[部门经理] [char] (5) NOT NULL ,
	[录入员] [char] (5) NOT NULL ,
	[商品编码] [char] (13) NOT NULL ,
	[品名] [char] (40) NOT NULL ,
	[单位] [char] (10) NOT NULL ,
	[数量] [numeric](12, 2) NOT NULL ,
	[原进价] [numeric](10, 4) NOT NULL ,
	[现进价] [numeric](10, 4) NOT NULL ,
	[原售价] [numeric](10, 4) NOT NULL ,
	[批发价] [numeric](10, 4) NOT NULL ,
	[进价差额] [numeric](10, 4) NOT NULL ,
	[售价差额] [numeric](10, 4) NOT NULL ,
	[确认状态] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[人员档案]    Script Date: 2002-8-17 20:54:39 ******/
CREATE TABLE [dbo].[人员档案] (
	[StaffCode] [char] (5) NOT NULL ,
	[Name] [char] (20) NOT NULL ,
	[Password] [char] (20) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[商品分类表]    Script Date: 2002-8-17 20:54:40 ******/
CREATE TABLE [dbo].[商品分类表] (
	[级别] [char] (1) NOT NULL ,
	[父节点名称] [char] (40) NOT NULL ,
	[本节点编码] [char] (3) NOT NULL ,
	[本节点名称] [char] (40) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[商品配送单]    Script Date: 2002-8-17 20:54:41 ******/
CREATE TABLE [dbo].[商品配送单] (
	[表单号] [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 ,
	[配送数量] [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 ,
	[含税进价] [numeric](18, 2) NOT NULL ,
	[备注] [char] (50) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[商品销售单表头]    Script Date: 2002-8-17 20:54:42 ******/
CREATE TABLE [dbo].[商品销售单表头] (
	[单号] [char] (10) NOT NULL ,
	[日期] [datetime] NOT NULL ,
	[录入员] [char] (10) NOT NULL ,
	[客户] [char] (30) NOT NULL ,
	[结账类型] [char] (10) NOT NULL ,
	[会员编码] [char] (13) NOT NULL ,
	[回款标志] [bit] NOT NULL ,
	[确认状态] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[商品销售汇总表]    Script Date: 2002-8-17 20:54:43 ******/
CREATE TABLE [dbo].[商品销售汇总表] (
	[日期] [datetime] NOT NULL ,
	[商品编码] [char] (15) NOT NULL ,
	[商品名称] [char] (40) NOT NULL ,
	[单位] [char] (10) NOT NULL ,
	[数量] [numeric](18, 2) NOT NULL ,
	[金额] [numeric](18, 2) NOT NULL ,
	[冲减标志] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[商品信息]    Script Date: 2002-8-17 20:54:43 ******/
CREATE TABLE [dbo].[商品信息] (
	[商品编码] [char] (13) NOT NULL ,
	[商品名称] [char] (40) NOT NULL ,
	[单位] [char] (10) NOT NULL ,
	[颜色] [char] (20) NOT NULL ,
	[尺寸] [char] (10) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[商品主档]    Script Date: 2002-8-17 20:54:44 ******/
CREATE TABLE [dbo].[商品主档] (
	[商品编码] [char] (13) NOT NULL ,
	[商品条码] [char] (13) NOT NULL ,
	[品名] [varchar] (40) NOT NULL ,
	[单位] [char] (6) NOT NULL ,
	[厂商编码] [char] (10) NOT NULL ,
	[进价] [numeric](12, 4) NOT NULL ,
	[税率] [numeric](12, 2) NOT NULL ,
	[批发价1] [numeric](18, 2) NOT NULL ,
	[批发价2] [numeric](18, 2) NOT NULL ,
	[零售价] [numeric](12, 2) NOT NULL ,
	[含税进价] [numeric](12, 2) NOT NULL ,
	[废弃标志] [bit] NOT NULL ,
	[更新标志] [bit] NOT NULL ,
	[备用标志4] [bit] NOT NULL ,
	[备用标志3] [bit] NOT NULL ,
	[备用标志2] [bit] NOT NULL ,
	[备用标志1] [bit] NOT NULL ,
	[库存上限] [numeric](18, 2) NOT NULL ,
	[库存下限] [numeric](18, 2) NOT NULL ,
	[类别] [char] (20) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[审价单]    Script Date: 2002-8-17 20:54:45 ******/
CREATE TABLE [dbo].[审价单] (
	[表单号] [char] (15) NOT NULL ,
	[制表日期] [datetime] NOT NULL ,
	[申报员] [char] (5) NOT NULL ,
	[审核员] [char] (5) NOT NULL ,
	[录入员] [char] (5) NOT NULL ,
	[商品编码] [char] (13) NOT NULL ,
	[条码] [char] (13) NOT NULL ,
	[品名] [varchar] (40) NOT NULL ,
	[单位] [char] (6) NOT NULL ,
	[厂商编码] [char] (3) NOT NULL ,
	[进价] [numeric](12, 4) NOT NULL ,
	[税率] [numeric](5, 2) NOT NULL ,
	[含税进价] [numeric](12, 4) NOT NULL ,
	[进销差率] [numeric](5, 2) NOT NULL ,
	[倒扣率] [numeric](5, 2) NOT NULL ,
	[批发价1] [numeric](18, 2) NOT NULL ,
	[批发价2] [numeric](18, 2) NOT NULL ,
	[零售价] [numeric](12, 2) NOT NULL ,
	[确认状态] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[收款台分配表]    Script Date: 2002-8-17 20:54:45 ******/
CREATE TABLE [dbo].[收款台分配表] (
	[分店编码] [char] (4)
12345

⌨️ 快捷键说明

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