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

📄 dstar2002-08-17.sql

📁 服装销售系统,VB开发.没有解压密码
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
	[表单号] [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 ,
	[颜色] [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 ,
	[订单号] [char] (15) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[LSPDD]    Script Date: 2002-8-17 20:54:16 ******/
CREATE TABLE [dbo].[LSPDD] (
	[表单号] [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 ,
	[颜色] [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].[LSXSD]    Script Date: 2002-8-17 20:54:16 ******/
CREATE TABLE [dbo].[LSXSD] (
	[表单号] [char] (15) NOT NULL ,
	[制表日期] [datetime] NOT NULL ,
	[客户名称] [char] (50) 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](18, 2) NOT NULL ,
	[单价] [numeric](12, 4) NOT NULL ,
	[金额] [numeric](12, 2) NOT NULL ,
	[确认状态] [bit] NOT NULL ,
	[备注] [char] (50) NOT NULL ,
	[业务员] [char] (20) NOT NULL 
) ON [PRIMARY]
GO

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

/****** Object:  Table [dbo].[PayType]    Script Date: 2002-8-17 20:54:17 ******/
CREATE TABLE [dbo].[PayType] (
	[付款方式] [char] (20) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[pb]    Script Date: 2002-8-17 20:54:18 ******/
CREATE TABLE [dbo].[pb] (
	[pbvalues] [char] (20) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[POS多重付款]    Script Date: 2002-8-17 20:54:18 ******/
CREATE TABLE [dbo].[POS多重付款] (
	[收款台] [char] (3) NOT NULL ,
	[操作员] [char] (5) NOT NULL ,
	[流水号] [numeric](6, 0) NOT NULL ,
	[实收金额] [numeric](12, 2) NOT NULL ,
	[付款类型] [char] (2) NOT NULL ,
	[卡号1] [varchar] (20) NOT NULL ,
	[卡号2] [varchar] (20) NOT NULL ,
	[日期] [datetime] NOT NULL ,
	[时间] [char] (8) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[POS汇总]    Script Date: 2002-8-17 20:54:18 ******/
CREATE TABLE [dbo].[POS汇总] (
	[收款台] [char] (3) NOT NULL ,
	[操作员] [char] (5) NOT NULL ,
	[营业员] [char] (5) NOT NULL ,
	[分店编码] [char] (6) NOT NULL ,
	[流水号] [numeric](6, 0) NOT NULL ,
	[金额] [numeric](9, 2) NOT NULL ,
	[会员金额] [numeric](9, 2) NOT NULL ,
	[折扣额] [numeric](9, 2) NOT NULL ,
	[实收金额] [numeric](9, 2) NOT NULL ,
	[子流水号] [numeric](2, 0) NOT NULL ,
	[日期] [datetime] NOT NULL ,
	[时间] [char] (8) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[POS销售明细]    Script Date: 2002-8-17 20:54:19 ******/
CREATE TABLE [dbo].[POS销售明细] (
	[收款台] [char] (3) NOT NULL ,
	[操作员] [char] (5) NOT NULL ,
	[营业员] [char] (5) NOT NULL ,
	[分店编码] [char] (6) NOT NULL ,
	[流水号] [int] NOT NULL ,
	[商品编码] [char] (13) NOT NULL ,
	[数量] [numeric](6, 2) NOT NULL ,
	[单价] [numeric](9, 2) NOT NULL ,
	[金额] [numeric](9, 2) NOT NULL ,
	[会员卡号] [varchar] (6) NOT NULL ,
	[会员优惠额] [numeric](9, 2) NOT NULL ,
	[会员应收额] [numeric](9, 2) NOT NULL ,
	[折扣额] [numeric](9, 2) NOT NULL ,
	[实收金额] [numeric](9, 2) NOT NULL ,
	[日期] [datetime] NOT NULL ,
	[时间] [char] (8) NOT NULL ,
	[多单号] [tinyint] NOT NULL ,
	[子流水号] [tinyint] NOT NULL ,
	[退货标志] [char] (1) NOT NULL ,
	[汇总标志] [char] (1) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[PSD]    Script Date: 2002-8-17 20:54:19 ******/
CREATE TABLE [dbo].[PSD] (
	[表单号] [char] (15) NOT NULL ,
	[经营公司] [char] (40) NOT NULL ,
	[付款方式] [char] (20) 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](18, 0) 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 ,
	[订单号] [char] (20) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[RecChainStore]    Script Date: 2002-8-17 20:54:20 ******/
CREATE TABLE [dbo].[RecChainStore] (
	[日期] [datetime] NOT NULL ,
	[分店编码] [char] (4) 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].[RecMainStore]    Script Date: 2002-8-17 20:54:20 ******/
CREATE TABLE [dbo].[RecMainStore] (
	[日期] [datetime] 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 ,
	[单位] [char] (4) NOT NULL ,
	[颜色] [char] (20) NOT NULL ,
	[尺寸] [char] (10) NOT NULL ,
	[含税进价金额] [numeric](18, 2) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[rstock]    Script Date: 2002-8-17 20:54:21 ******/
CREATE TABLE [dbo].[rstock] (
	[gcode] [char] (7) NOT NULL ,
	[gname] [char] (30) NOT NULL ,
	[qty] [numeric](18, 0) NOT NULL ,
	[sflag] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[ssize]    Script Date: 2002-8-17 20:54:21 ******/
CREATE TABLE [dbo].[ssize] (
	[sizename] [char] (10) NOT NULL ,
	[size] [char] (10) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[stock]    Script Date: 2002-8-17 20:54:21 ******/
CREATE TABLE [dbo].[stock] (
	[gcode] [char] (7) NOT NULL ,
	[gname] [char] (30) NOT NULL ,
	[qty] [numeric](18, 0) NOT NULL ,
	[sflag] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[store]    Script Date: 2002-8-17 20:54:22 ******/
CREATE TABLE [dbo].[store] (
	[gcode] [char] (7) NOT NULL ,
	[gname] [char] (30) NOT NULL ,
	[gunit] [char] (10) NOT NULL ,
	[qty] [numeric](18, 0) NOT NULL ,
	[sizename] [char] (10) NOT NULL ,
	[size] [char] (10) NOT NULL ,
	[color] [char] (10) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[SYSLOG]    Script Date: 2002-8-17 20:54:22 ******/
CREATE TABLE [dbo].[SYSLOG] (
	[SEQUENCE] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[OPERATOR] [char] (20) NOT NULL ,
	[TERMINAL] [char] (10) NOT NULL ,
	[SYSTIME] [datetime] NOT NULL ,
	[OPERATIONTYPE] [char] (40) NOT NULL ,
	[DESCRIPTION] [varchar] (50) NOT NULL ,
	[UNITCODE] [char] (10) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[UPLOAD]    Script Date: 2002-8-17 20:54:23 ******/
CREATE TABLE [dbo].[UPLOAD] (
	[DCODE] [char] (12) NOT NULL ,
	[SELLDAY] [char] (10) NOT NULL ,
	[GCODE] [char] (20) NOT NULL ,
	[DNAME] [char] (40) NOT NULL ,
	[GNAME] [char] (40) NOT NULL ,
	[SELLQUANTITY] [numeric](18, 0) NOT NULL ,
	[SELLSUM] [numeric](18, 0) NOT NULL ,
	[STOCKQUANTITY] [numeric](18, 0) NOT NULL ,
	[STOCKSUM] [numeric](18, 0) NOT NULL ,
	[OTHERQUANTITY] [numeric](18, 0) NOT NULL ,
	[OTHERSUM] [numeric](18, 0) NOT NULL ,
	[STOREQUANTITY] [numeric](18, 0) NOT NULL ,
	[STORESUM] [numeric](18, 0) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[厂商主档]    Script Date: 2002-8-17 20:54:23 ******/
CREATE TABLE [dbo].[厂商主档] (
	[厂商编码] [char] (3) NOT NULL ,
	[厂商名称] [varchar] (50) NOT NULL ,
	[地区] [char] (10) NOT NULL ,
	[地址] [varchar] (70) NOT NULL ,
	[邮编] [char] (6) NOT NULL ,
	[性质] [char] (2) NOT NULL ,
	[开户行] [varchar] (40) NOT NULL ,
	[帐号] [char] (20) NOT NULL ,
	[税号] [char] (15) NOT NULL ,
	[法人] [varchar] (20) NOT NULL ,
	[电话] [varchar] (20) NOT NULL ,
	[传真] [varchar] (20) NOT NULL ,
	[电报挂号] [varchar] (20) NOT NULL ,
	[联系人] [varchar] (20) NOT NULL ,
	[联系人电话] [varchar] (20) NOT NULL ,
	[联系人寻呼] [varchar] (20) NOT NULL ,
	[联系人手机] [varchar] (20) NOT NULL ,
	[电子邮件] [varchar] (30) NOT NULL ,
	[确认状态] [bit] NOT NULL 
)
GO

/****** Object:  Table [dbo].[代销调拨单]    Script Date: 2002-8-17 20:54:24 ******/
CREATE TABLE [dbo].[代销调拨单] (
	[表单号] [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 ,
12345

⌨️ 快捷键说明

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