trade.txt

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

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