poseasy.sql

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

	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[品名] [char] (20) NOT NULL ,
	[牌号] [char] (20) NOT NULL ,
	[条码] [char] (20) NOT NULL ,
	[规格] [char] (20) NOT NULL ,
	[分类] [char] (8) NOT NULL ,
	[等级] [char] (8) NOT NULL ,
	[厂家] [char] (40) NOT NULL ,
	[进价] [money] NOT NULL ,
	[售价] [money] NOT NULL ,
	[销售部门] [char] (8) NOT NULL ,
	[物价员] [char] (10) NOT NULL ,
	[最后更新日期] [datetime] NOT NULL ,
	[经手人] [char] (10) NULL ,
	[备注] [char] (50) NULL ,
	[折扣] [float] NULL 
) ON [PRIMARY]
GO

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

CREATE TABLE [dbo].[purchaserecordbase] (
	[厂家] [char] (50) NULL ,
	[品名] [char] (50) NOT NULL ,
	[条码] [char] (20) NOT NULL ,
	[牌号] [char] (20) NOT NULL ,
	[规格] [char] (20) NOT NULL ,
	[分类编码] [char] (10) NOT NULL ,
	[等级] [char] (10) NOT NULL ,
	[进价] [money] NOT NULL ,
	[售价] [money] NOT NULL ,
	[原库存数量] [int] NOT NULL ,
	[厂家经手人] [char] (10) NOT NULL ,
	[经手人] [char] (10) NOT NULL ,
	[合同号] [char] (20) NOT NULL ,
	[结账日期] [datetime] NULL ,
	[数量] [int] NOT NULL ,
	[进货批次] [char] (10) NULL ,
	[进价折扣] [char] (10) NULL ,
	[进价折扣方式] [char] (10) NULL ,
	[进货日期] [datetime] NULL ,
	[出库单号] [char] (20) NULL ,
	[选择] [bit] NOT NULL ,
	[审核人] [char] (10) NULL 
) ON [PRIMARY]
GO

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

CREATE TABLE [dbo].[saledayreportbase] (
	[isCode] [int] IDENTITY (1, 1) NOT NULL ,
	[Msum] [money] NOT NULL ,
	[Mmonthsum] [money] NOT NULL ,
	[Myearsum] [money] NOT NULL ,
	[ipartment] [char] (20) NOT NULL ,
	[drtime] [char] (10) NOT NULL ,
	[Cmemo] [char] (100) NULL 
) ON [PRIMARY]
GO

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

CREATE TABLE [dbo].[salereportbase] (
	[isCode] [int] IDENTITY (1, 1) NOT NULL ,
	[Mdaysum] [money] NOT NULL ,
	[Mmonthsum] [money] NOT NULL ,
	[Myearsum] [money] NOT NULL ,
	[drtime] [char] (10) NOT NULL ,
	[Cmemo] [char] (100) NULL 
) ON [PRIMARY]
GO

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

CREATE TABLE [dbo].[saleyearepbase] (
	[iyCode] [int] IDENTITY (1, 1) NOT NULL ,
	[ipartment] [int] NULL ,
	[Mmonthsum] [money] NOT NULL ,
	[Myearsum] [money] NOT NULL ,
	[Mlastsum] [money] NOT NULL ,
	[Moldsum] [money] NOT NULL ,
	[rmonth] [char] (10) NOT NULL ,
	[ryear] [char] (10) NOT NULL 
) ON [PRIMARY]
GO

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

CREATE TABLE [dbo].[shopdillbase] (
	[票据号] [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].[shopdillmanagerbase]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[shopdillmanagerbase]
GO

CREATE TABLE [dbo].[shopdillmanagerbase] (
	[店内票据号] [char] (30) NOT NULL ,
	[姓名] [char] (8) NOT NULL ,
	[开始日期] [smalldatetime] NOT NULL ,
	[终止日期] [smalldatetime] NOT NULL ,
	[发出金额] [money] NOT NULL ,
	[回收金额] [money] NOT NULL ,
	[录入员] [char] (8) NOT NULL 
) ON [PRIMARY]
GO

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

CREATE TABLE [dbo].[ShopSaleReportBase] (
	[年份] [char] (4) NOT NULL ,
	[月份] [char] (2) NOT NULL ,
	[部门编码] [char] (10) NOT NULL ,
	[当月销售额] [numeric](18, 2) NULL ,
	[当月销项税] [numeric](18, 2) NULL ,
	[当月商品成本] [numeric](18, 2) NULL ,
	[当月毛利润] [numeric](18, 2) NULL ,
	[当月折扣折让金额] [numeric](18, 2) NULL ,
	[去年同期销售额] [numeric](18, 2) NULL ,
	[去年同期毛利润] [numeric](18, 2) NULL ,
	[前年同期销售额] [numeric](18, 2) NULL ,
	[前年同期毛利润] [numeric](18, 2) NULL ,
	[更新日期] [datetime] NULL 
) ON [PRIMARY]
GO

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

CREATE TABLE [dbo].[storebase] (
	[品名] [char] (50) NOT NULL ,
	[供货商] [char] (50) NULL ,
	[合同号] [char] (20) NOT NULL ,
	[牌号] [char] (20) NOT NULL ,
	[条码] [char] (20) NOT NULL ,
	[规格] [char] (20) NULL ,
	[分类] [char] (20) NULL ,
	[等级] [char] (10) NULL ,
	[大库库存] [int] NOT NULL ,
	[更新时间] [datetime] NOT NULL 
) ON [PRIMARY]
GO

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

CREATE TABLE [dbo].[storeoutrecordbase] (
	[品名] [char] (50) NOT NULL ,
	[合同号] [char] (20) NOT NULL ,
	[供货商] [char] (50) NULL ,
	[牌号] [char] (20) NOT NULL ,
	[条码] [char] (20) NOT NULL ,
	[规格] [char] (20) NOT NULL ,
	[分类] [char] (20) NULL ,
	[等级] [char] (10) NULL ,
	[大库库存] [int] NULL ,
	[时间] [datetime] NOT NULL ,
	[提货部门] [char] (10) NOT NULL ,
	[提货人] [char] (10) NOT NULL ,
	[经手人] [char] (10) NOT NULL 
) ON [PRIMARY]
GO

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

CREATE TABLE [dbo].[supplierlistbase] (
	[isCode] [int] IDENTITY (1, 1) NOT NULL ,
	[cname] [varchar] (40) NOT NULL ,
	[cstyle] [varchar] (20) NOT NULL ,
	[caddress] [varchar] (40) NOT NULL ,
	[cconnector] [varchar] (20) NOT NULL ,
	[ccreatedate] [datetime] NOT NULL ,
	[cratifier] [varchar] (10) NOT NULL ,
	[cbooker] [varchar] (10) NOT NULL ,
	[cnote] [varchar] (50) NULL ,
	[deptname] [char] (10) NULL 
) ON [PRIMARY]
GO

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

CREATE TABLE [dbo].[SuppliersSaleReportBase] (
	[供货商] [char] (40) NOT NULL ,
	[当月销售额] [numeric](18, 2) NULL ,
	[当月销项税] [numeric](18, 2) NULL ,
	[当月商品成本] [numeric](18, 2) NULL ,
	[当月毛利润] [numeric](18, 2) NULL ,
	[去年同期销售额] [numeric](18, 2) NULL ,
	[去年同期毛利润] [numeric](18, 2) NULL ,
	[前年同期销售额] [numeric](18, 2) NULL ,
	[前年同期毛利润] [numeric](18, 2) NULL ,
	[更新日期] [datetime] NULL 
) ON [PRIMARY]
GO

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

CREATE TABLE [dbo].[tempcashbase] (
	[凭证号] [char] (10) NULL ,
	[合同号] [char] (20) NOT NULL ,
	[供货商] [char] (40) NOT NULL ,
	[品名] [char] (20) NOT NULL ,
	[单位] [char] (20) NOT NULL ,
	[数量] [real] 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].[tmpclassalebase]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tmpclassalebase]
GO

CREATE TABLE [dbo].[tmpclassalebase] (
	[分类] [char] (15) NOT NULL ,
	[销售额] [money] NOT NULL ,
	[销项税] [money] NOT NULL ,
	[结算金额] [money] NOT NULL ,
	[毛利] [money] NOT NULL ,
	[去年同期销售额] [money] NOT NULL ,
	[去年同期毛利] [money] NOT NULL ,
	[最后更新日期] [datetime] NOT NULL 
) ON [PRIMARY]
GO

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

CREATE TABLE [dbo].[trade] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[op] [char] (1) NOT NULL ,
	[ecr] [char] (4) NOT NULL ,
	[tmpclerk] [char] (4) NULL ,
	[clerk] [char] (4) NOT NULL ,
	[saler] [char] (4) NULL ,
	[saledate] [char] (12) NOT NULL ,
	[saletime] [char] (12) NOT NULL ,
	[sno] [int] NOT NULL ,
	[orgtotal] [money] NULL ,
	[total] [money] NULL ,
	[totaldis] [float] NULL ,
	[totalsub] [money] NULL ,
	[opennum] [int] NULL ,
	[cancelnum] [int] NULL ,
	[disnum] [int] NULL ,
	[pay1] [money] NULL ,
	[pay2] [money] NULL ,
	[pay3] [money] NULL ,
	[pay4] [money] NULL ,
	[pay5] [money] NULL ,
	[pay6] [money] NULL ,
	[cardnum] [char] (30) NULL ,
	[change] [money] NULL ,
	[dept] [char] (20) NULL ,
	[code] [char] (20) NOT NULL ,
	[name] [char] (50) NOT NULL ,
	[unit] [char] (5) NULL ,
	[discount] [float] NULL ,
	[num] [float] NOT NULL ,
	[price] [money] NOT NULL ,
	[amount] [money] NOT NULL ,
	[sub] [money] NOT NULL ,
	[imark] [char] (1) NOT NULL 
) ON [PRIMARY]
GO

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

CREATE TABLE [dbo].[verifytab] (
	[login_id] [int] IDENTITY (1, 1) NOT NULL ,
	[username] [char] (20) NOT NULL ,
	[partment] [char] (20) NULL ,
	[password] [char] (20) NOT NULL ,
	[limit] [tinyint] NOT NULL 
) ON [PRIMARY]
GO

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

CREATE TABLE [dbo].[zjlshtab] (
	[izCode] [int] IDENTITY (1, 1) NOT NULL ,
	[ijcode] [int] NULL ,
	[igoods] [int] 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 ,
	[Isource] [int] NOT NULL ,
	[Caim] [char] (10) NOT NULL ,
	[Ireason] [tinyint] NOT NULL ,
	[Iinhand] [tinyint] NOT NULL ,
	[pzid] [int] NULL ,
	[Cpname] [char] (10) NOT NULL ,
	[Dptime] [datetime] NOT NULL ,
	[Crname] [varchar] (10) NOT NULL ,
	[Drtime] [datetime] NOT NULL ,
	[Cmemo] [char] (100) NULL 
) ON [PRIMARY]
GO