poseasy.sql

PosEasy收银系统源码,Pos机前后台管理代码

if exists (select * from sysobjects where id = object_id(N'[dbo].[accountrecordbase]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[accountrecordbase]
GO

CREATE TABLE [dbo].[accountrecordbase] (
	[凭证号] [int] IDENTITY (1, 1) NOT NULL ,
	[供货商] [char] (50) NOT NULL ,
	[结账金额] [money] NOT NULL ,
	[合同号] [char] (20) NULL ,
	[品名] [char] (20) NULL ,
	[条码] [char] (20) NULL ,
	[付款方式] [char] (12) NOT NULL ,
	[日期] [char] (16) NOT NULL ,
	[经手人] [char] (12) NOT NULL ,
	[备注] [char] (50) NULL 
) ON [PRIMARY]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[casher]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[casher]
GO

CREATE TABLE [dbo].[casher] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[receiver] [char] (4) NOT NULL ,
	[giver] [char] (4) NULL ,
	[date] [char] (16) NOT NULL ,
	[total] [money] NULL ,
	[pay1] [money] NULL ,
	[pay2] [money] NULL ,
	[pay3] [money] NULL ,
	[pay4] [money] NULL ,
	[pay5] [money] NULL ,
	[pay6] [money] NULL 
) ON [PRIMARY]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[checkbase]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[checkbase]
GO

CREATE TABLE [dbo].[checkbase] (
	[支票号] [varchar] (20) NOT NULL ,
	[日期] [smalldatetime] NOT NULL ,
	[金额] [money] NOT NULL ,
	[划拨状态] [int] NOT NULL 
) ON [PRIMARY]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[ClerkBase]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ClerkBase]
GO

CREATE TABLE [dbo].[ClerkBase] (
	[Cname] [char] (30) NOT NULL ,
	[Ccode] [char] (8) NOT NULL ,
	[Cpass] [char] (8) NOT NULL ,
	[Depcode] [char] (8) NOT NULL ,
	[Clevel] [char] (1) NOT NULL 
) ON [PRIMARY]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[copebalancebase]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[copebalancebase]
GO

CREATE TABLE [dbo].[copebalancebase] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[供货商] [char] (50) NOT NULL ,
	[销售结算金额] [money] NOT NULL ,
	[已结算金额] [money] NOT NULL ,
	[库存结算金额] [money] NOT NULL ,
	[欠款金额] [money] NOT NULL ,
	[进货金额] [money] NOT NULL ,
	[应付金额] [money] NOT NULL ,
	[进货平衡金额] [money] NOT NULL ,
	[更新日期] [datetime] NOT NULL ,
	[经手人] [char] (10) NOT NULL ,
	[备注] [char] (50) NULL 
) ON [PRIMARY]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[creditbase]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[creditbase]
GO

CREATE TABLE [dbo].[creditbase] (
	[卡号] [varchar] (20) NOT NULL ,
	[日期] [smalldatetime] NOT NULL ,
	[金额] [money] NOT NULL ,
	[划拨状态] [int] NOT NULL 
) ON [PRIMARY]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[DeptNameBase]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[DeptNameBase]
GO

CREATE TABLE [dbo].[DeptNameBase] (
	[部门名称] [char] (20) NOT NULL ,
	[更新人] [char] (10) NULL ,
	[日期] [datetime] NULL 
) ON [PRIMARY]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[goodcashbase]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[goodcashbase]
GO

CREATE TABLE [dbo].[goodcashbase] (
	[凭证号] [int] NOT NULL ,
	[合同号] [char] (20) NOT NULL ,
	[供货商] [char] (20) NOT NULL ,
	[品名] [char] (20) NOT NULL ,
	[单位] [char] (20) NOT NULL ,
	[数量] [int] NOT NULL ,
	[商品成本] [money] NOT NULL ,
	[进项税额] [money] NOT NULL ,
	[结账金额] [money] NOT NULL ,
	[帐余金额] [money] NOT NULL ,
	[实结金额] [money] NULL ,
	[销售金额] [money] NOT NULL ,
	[销项税额] [money] NOT NULL ,
	[毛利] [money] NOT NULL ,
	[折扣] [real] NULL ,
	[销售部门] [char] (10) NOT NULL 
) ON [PRIMARY]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[goodclassingbase]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[goodclassingbase]
GO

CREATE TABLE [dbo].[goodclassingbase] (
	[商品名称] [char] (30) NOT NULL ,
	[更新人] [char] (10) NULL ,
	[日期] [datetime] NULL 
) ON [PRIMARY]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[goodsalereportbase]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[goodsalereportbase]
GO

CREATE TABLE [dbo].[goodsalereportbase] (
	[品名] [char] (20) NOT NULL ,
	[牌号] [char] (20) NOT NULL ,
	[规格] [char] (20) NOT NULL ,
	[分类] [char] (20) NOT NULL ,
	[供货商] [char] (40) NOT NULL ,
	[销售额] [money] NOT NULL ,
	[销售数量] [int] NOT NULL ,
	[结算金额] [money] NOT NULL ,
	[销项税] [money] NOT NULL ,
	[毛利] [money] NOT NULL ,
	[平均进价] [money] NOT NULL ,
	[平均售价] [money] NOT NULL ,
	[去年同期销售额] [money] NOT NULL ,
	[去年同期毛利] [money] NOT NULL ,
	[销售部门] [char] (20) NOT NULL ,
	[最后更新日期] [datetime] NOT NULL ,
	[折扣折让] [money] NOT NULL 
) ON [PRIMARY]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[goodsbase]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[goodsbase]
GO

CREATE TABLE [dbo].[goodsbase] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[品名] [char] (20) NOT NULL ,
	[牌号] [char] (20) NOT NULL ,
	[条码] [char] (18) NOT NULL ,
	[规格] [char] (20) NOT NULL ,
	[分类] [char] (12) NOT NULL ,
	[等级] [char] (8) NOT NULL ,
	[厂家] [char] (40) NOT NULL ,
	[供货商] [char] (40) NOT NULL ,
	[进价] [money] NOT NULL ,
	[售价] [money] NOT NULL ,
	[销售部门] [char] (8) NOT NULL ,
	[新增商品通知单来源] [char] (16) NULL ,
	[进货上限] [real] NULL ,
	[进货数量] [real] NULL ,
	[当前库存] [real] NULL ,
	[库存损耗数量] [real] NULL ,
	[结账方式] [char] (8) NULL ,
	[损耗限额比] [float] NULL ,
	[物价员] [char] (8) NULL ,
	[最后更新日期] [datetime] NULL ,
	[专利号] [char] (10) NULL ,
	[检测报告编号] [char] (10) NULL ,
	[商标代码] [char] (10) NULL ,
	[厂家经手人] [char] (8) NULL ,
	[经手人] [char] (8) NULL ,
	[合同号] [char] (20) NULL ,
	[结账日期] [datetime] NULL ,
	[销售数量] [real] NULL ,
	[销售结算金额] [money] NULL ,
	[库存结算金额] [money] NULL ,
	[库存损耗金额] [money] NULL ,
	[应结算金额] [money] NULL ,
	[交易更新时间] [datetime] NULL ,
	[已结算金额] [money] NULL ,
	[备注] [char] (50) NULL ,
	[折扣标志] [int] NULL ,
	[计量单位] [char] (10) NOT NULL ,
	[销售更新标志] [int] NULL ,
	[税率] [float] NOT NULL ,
	[结算数量] [real] NULL ,
	[折扣] [float] NULL ,
	[折扣折让] [money] NULL ,
	[倒扣比例] [float] NULL ,
	[进价扣率] [float] NULL ,
	[售价扣率] [float] NULL ,
	[销售金额] [money] NULL ,
	[选择] [bit] NOT NULL ,
	[审核人] [char] (10) NULL ,
	[进货金额] [money] NULL 
) ON [PRIMARY]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[GoodsCheckBase]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[GoodsCheckBase]
GO

CREATE TABLE [dbo].[GoodsCheckBase] (
	[条码] [char] (20) NULL ,
	[品名] [char] (20) NOT NULL ,
	[牌号] [char] (20) NOT NULL ,
	[规格] [char] (20) NOT NULL ,
	[售价] [money] NULL ,
	[分类编码] [char] (12) NULL ,
	[损耗限额比] [real] NULL ,
	[部门编码] [char] (20) NULL ,
	[库存数量] [int] NULL ,
	[进货数量] [int] NULL ,
	[销售数量] [int] NULL ,
	[盘库结果] [int] NULL ,
	[盘库差额] [int] NULL ,
	[操作日期] [datetime] NULL ,
	[经手人] [char] (30) NULL ,
	[备注] [char] (100) NULL 
) ON [PRIMARY]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[GoodsCheckTempBase]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[GoodsCheckTempBase]
GO

CREATE TABLE [dbo].[GoodsCheckTempBase] (
	[条码] [char] (20) NULL ,
	[品名] [char] (20) NOT NULL ,
	[牌号] [char] (20) NOT NULL ,
	[规格] [char] (20) NOT NULL ,
	[售价] [money] NULL ,
	[分类编码] [char] (12) NULL ,
	[损耗限额比] [real] NULL ,
	[部门编码] [char] (20) NULL ,
	[库存数量] [int] NULL ,
	[进货数量] [int] NULL ,
	[销售数量] [int] NULL ,
	[盘库结果] [int] NULL ,
	[盘库差额] [int] NULL ,
	[操作日期] [datetime] NULL ,
	[经手人] [char] (30) NULL ,
	[备注] [char] (100) NULL 
) ON [PRIMARY]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[goodsflowbase]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[goodsflowbase]
GO

CREATE TABLE [dbo].[goodsflowbase] (
	[fid] [int] IDENTITY (1, 1) NOT NULL ,
	[品名] [char] (20) NOT NULL ,
	[牌号] [char] (20) NOT NULL ,
	[规格] [char] (18) NOT NULL ,
	[分类编码] [char] (18) NULL ,
	[等级] [char] (10) NULL ,
	[物流方向标记] [char] (10) NULL ,
	[物流来源] [char] (10) NULL ,
	[物流目标] [char] (10) NULL ,
	[数量] [real] NULL ,
	[单位] [char] (10) NULL ,
	[成本单价] [money] NULL ,
	[销售单价] [money] NULL ,
	[成本金额] [money] NULL ,
	[销售金额] [money] NULL ,
	[支付方式] [char] (10) NULL ,
	[操作员] [char] (10) NULL ,
	[操作日期] [datetime] NULL ,
	[备注] [char] (20) NULL ,
	[部门编码] [char] (20) NULL ,
	[条码] [char] (20) NULL ,
	[修改纪录时间] [datetime] NULL ,
	[修改纪录日期] [datetime] NULL ,
	[折扣折让] [money] NULL 
) ON [PRIMARY]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[jkdtab]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[jkdtab]
GO

CREATE TABLE [dbo].[jkdtab] (
	[ijCode] [int] IDENTITY (1, 1) NOT NULL ,
	[Msum] [money] NOT NULL ,
	[Mcashsum] [money] NOT NULL ,
	[Mbillsum] [money] NOT NULL ,
	[Mcardsum] [money] NOT NULL ,
	[mshopsum] [money] NOT NULL ,
	[mhungsum] [money] NOT NULL ,
	[Mothsum] [money] NOT NULL ,
	[Ipart] [varchar] (4) NOT NULL ,
	[Cpname] [varchar] (20) NOT NULL ,
	[Dptime] [datetime] NOT NULL ,
	[Crname] [varchar] (20) NULL ,
	[Drtime] [datetime] NULL ,
	[Cmemo] [varchar] (200) NULL 
) ON [PRIMARY]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[postab]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[postab]
GO

CREATE TABLE [dbo].[postab] (
	[cposnum] [char] (4) NOT NULL ,
	[cdepnum] [char] (4) NOT NULL ,
	[Cdepname] [char] (20) NOT NULL ,
	[Cmemo] [char] (20) NULL 
) ON [PRIMARY]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[Pricebase]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Pricebase]
GO

CREATE TABLE [dbo].[Pricebase] (