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

📄 dstar2002-08-17.sql

📁 服装销售系统,VB开发.没有解压密码
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
	[单位] [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:25 ******/
CREATE TABLE [dbo].[代销付款单] (
	[表单号] [char] (7) NOT NULL ,
	[进货部门] [char] (50) NOT NULL ,
	[厂商编码] [char] (3) NOT NULL ,
	[制表日期] [datetime] 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] (4) NOT NULL ,
	[数量] [numeric](18, 0) NOT NULL ,
	[进价] [numeric](12, 2) NOT NULL ,
	[付款金额] [numeric](12, 2) NOT NULL ,
	[进货单号] [char] (7) NOT NULL ,
	[确认状态] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[代销进货单]    Script Date: 2002-8-17 20:54:25 ******/
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 ,
	[品名] [varchar] (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 ,
	[付完日期] [datetime] NOT NULL ,
	[已售数量] [numeric](8, 2) NOT NULL ,
	[已付数量] [numeric](8, 2) NOT NULL ,
	[售完标志] [bit] 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:26 ******/
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:26 ******/
CREATE TABLE [dbo].[代销退货单] (
	[表单号] [char] (14) NOT NULL ,
	[付款标志] [bit] 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:27 ******/
CREATE TABLE [dbo].[代销应付款] (
	[进货单号] [char] (15) NOT NULL ,
	[厂商编码] [char] (3) NOT NULL ,
	[商品编码] [char] (13) NOT NULL ,
	[品名] [char] (40) NOT NULL ,
	[数量] [numeric](8, 2) NOT NULL ,
	[应付金额] [numeric](12, 2) NOT NULL ,
	[单位] [char] (4) NOT NULL ,
	[进价] [numeric](18, 2) NOT NULL ,
	[汇总日期] [datetime] NOT NULL ,
	[销售未付数量] [numeric](18, 0) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[代销优惠调价单]    Script Date: 2002-8-17 20:54:28 ******/
CREATE TABLE [dbo].[代销优惠调价单] (
	[表单号] [char] (7) NOT NULL ,
	[厂商编码] [char] (3) 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:28 ******/
CREATE TABLE [dbo].[订货单] (
	[表单号] [char] (7) NOT NULL ,
	[厂商编码] [char] (3) NOT NULL ,
	[制表日期] [datetime] 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](18, 0) NOT NULL ,
	[进价] [numeric](18, 0) NOT NULL ,
	[进价金额] [numeric](18, 0) NOT NULL ,
	[预付金额] [numeric](18, 0) NOT NULL ,
	[到货日期] [datetime] NOT NULL ,
	[到货标志] [bit] NOT NULL ,
	[确认状态] [bit] NOT NULL ,
	[在途状态] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[分店返货单]    Script Date: 2002-8-17 20:54:29 ******/
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 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[分店库存]    Script Date: 2002-8-17 20:54:29 ******/
CREATE TABLE [dbo].[分店库存] (
	[分店编码] [char] (10) NOT NULL ,
	[商品编码] [char] (13) NOT NULL ,
	[品名] [char] (40) NOT NULL ,
	[数量] [numeric](12, 2) NOT NULL ,
	[进价金额] [numeric](12, 2) NOT NULL ,
	[售价金额] [numeric](12, 2) NOT NULL ,
	[销售金额] [numeric](18, 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:30 ******/
CREATE TABLE [dbo].[分店盘点轧帐] (
	[经营方式] [char] (4) NOT NULL ,
	[分店编码] [char] (4) NOT NULL ,
	[商品编码] [char] (13) NOT NULL ,
	[品名] [char] (40) NOT NULL ,
	[单位] [char] (4) NOT NULL ,
	[数量] [numeric](18, 0) NOT NULL ,
	[进价金额] [numeric](18, 0) NOT NULL ,
	[售价金额] [numeric](18, 0) NOT NULL ,
	[轧帐日期] [datetime] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[分店商品信息]    Script Date: 2002-8-17 20:54:30 ******/
CREATE TABLE [dbo].[分店商品信息] (
	[分店编码] [char] (5) NOT NULL ,
	[商品编码] [char] (7) NOT NULL ,
	[配送价] [numeric](18, 2) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[分店销售]    Script Date: 2002-8-17 20:54:31 ******/
CREATE TABLE [dbo].[分店销售] (
	[分店编码] [char] (4) NOT NULL ,
	[销售日期] [datetime] NOT NULL ,
	[商品编码] [char] (13) NOT NULL ,
	[品名] [char] (40) NOT NULL ,
	[单位] [char] (4) NOT NULL ,
	[数量] [numeric](18, 0) NOT NULL ,
	[零售价] [numeric](18, 0) NOT NULL ,
	[零售金额] [numeric](18, 0) NOT NULL ,
	[操作员] [char] (5) NOT NULL ,
	[确认状态] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[分店销售信息]    Script Date: 2002-8-17 20:54:31 ******/
CREATE TABLE [dbo].[分店销售信息] (
	[分店编码] [char] (10) NOT NULL ,
	[传输日期] [datetime] NOT NULL ,
	[销售单号] [char] (13) NOT NULL ,
	[销售时间] [datetime] NOT NULL ,
	[操作员] [char] (10) NOT NULL ,
	[商品编码] [char] (10) NOT NULL ,
	[单位] [char] (10) NOT NULL ,
	[商品名称] [char] (40) NOT NULL ,
	[数量] [numeric](18, 2) NOT NULL ,
	[售价] [numeric](18, 2) NOT NULL ,
	[优惠] [numeric](18, 2) NOT NULL ,
	[金额] [numeric](18, 2) NOT NULL ,
	[尺寸] [char] (10) NOT NULL ,
	[颜色] [char] (10) NOT NULL ,
	[冲减标志] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[分店主档]    Script Date: 2002-8-17 20:54:32 ******/
CREATE TABLE [dbo].[分店主档] (
	[分店编码] [char] (4) NOT NULL ,
	[分店名称] [char] (40) NOT NULL ,
	[分店地址] [char] (40) NOT NULL ,
	[负责人] [char] (20) NOT NULL ,
	[电话] [char] (20) NOT NULL ,
	[传真] [char] (20) NOT NULL ,
	[数据路径] [char] (40) NOT NULL 
)
GO

/****** Object:  Table [dbo].[价格维护调整单]    Script Date: 2002-8-17 20:54:32 ******/
CREATE TABLE [dbo].[价格维护调整单] (
	[表单号] [char] (7) NOT NULL ,
	[执行日期] [datetime] NOT NULL ,
	[恢复日期] [datetime] NOT NULL ,
	[部门编码] [char] (6) NOT NULL ,
	[审核员] [char] (5) NOT NULL ,
	[部门经理] [char] (5) NOT NULL ,
	[申报员] [char] (5) NOT NULL ,
	[录入员] [char] (5) NOT NULL ,
	[商品编码] [char] (13) NOT NULL ,
	[商品简称] [varchar] (24) NOT NULL ,
	[单位] [char] (10) NOT NULL ,
	[原零售价] [numeric](9, 2) NOT NULL ,
	[新零售价] [numeric](9, 2) NOT NULL ,
	[调价原因] [varchar] (40) NOT NULL ,
	[确认状态] [bit] NOT NULL ,
	[运行标志] [char] (1) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[进价调整单]    Script Date: 2002-8-17 20:54:33 ******/
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 ,
	[数量] [numeric](9, 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:33 ******/
CREATE TABLE [dbo].[经销调拨单] (
	[表单号] [char] (7) NOT NULL ,
	[制表日期] [datetime] NOT NULL ,
	[调出部门] [char] (40) NOT NULL ,
	[调入部门] [char] (40) NOT NULL ,
12345

⌨️ 快捷键说明

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