📄 rs.sql

📁 一个用VB写的财务软件源码
💻 SQL
📖 第 1 页 / 共 2 页
字号:
12 下一页
/****** Object:  Table [dbo].[tRS_TBJSJ]    Script Date: 2003-6-2 17:24:40 ******/
CREATE TABLE [dbo].[tRS_TBJSJ] (
	[SYBJ] [smallint] NULL ,
	[HTBJ] [smallint] NULL ,
	[ZSDQ] [smallint] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TBMDYMX]    Script Date: 2003-6-2 17:24:40 ******/
CREATE TABLE [dbo].[tRS_TBMDYMX] (
	[BMDM] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[GWDM] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[RS] [int] NULL ,
	[RERS] [int] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TBXJFBL]    Script Date: 2003-6-2 17:24:41 ******/
CREATE TABLE [dbo].[tRS_TBXJFBL] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[dwJBYL] [decimal](9, 2) NULL ,
	[dwBCYL] [decimal](9, 2) NULL ,
	[dwYL] [decimal](9, 2) NULL ,
	[dwSY] [decimal](9, 2) NULL ,
	[dwSYU] [decimal](9, 2) NULL ,
	[dwGS] [decimal](9, 2) NULL ,
	[dwQT] [decimal](9, 2) NULL ,
	[grJBYL] [decimal](9, 2) NULL ,
	[grBCYL] [decimal](9, 2) NULL ,
	[grYL] [decimal](9, 2) NULL ,
	[grSY] [decimal](9, 2) NULL ,
	[grQT] [decimal](9, 2) NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TBXJFDW]    Script Date: 2003-6-2 17:24:41 ******/
CREATE TABLE [dbo].[tRS_TBXJFDW] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[JBYL] [decimal](9, 2) NULL ,
	[BCYL] [decimal](9, 2) NULL ,
	[YL] [decimal](9, 2) NULL ,
	[SY] [decimal](9, 2) NULL ,
	[SYU] [decimal](9, 2) NULL ,
	[GS] [decimal](9, 2) NULL ,
	[QT] [decimal](9, 2) NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TBXJFDWJ]    Script Date: 2003-6-2 17:24:41 ******/
CREATE TABLE [dbo].[tRS_TBXJFDWJ] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[JS] [decimal](9, 2) NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TBXJFGR]    Script Date: 2003-6-2 17:24:41 ******/
CREATE TABLE [dbo].[tRS_TBXJFGR] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[JBYL] [decimal](9, 2) NULL ,
	[BCYL] [decimal](9, 2) NULL ,
	[YL] [decimal](9, 2) NULL ,
	[SY] [decimal](9, 2) NULL ,
	[QT] [decimal](9, 2) NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TBXJFGRJ]    Script Date: 2003-6-2 17:24:41 ******/
CREATE TABLE [dbo].[tRS_TBXJFGRJ] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[JS] [decimal](9, 2) NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TBZDDY]    Script Date: 2003-6-2 17:24:41 ******/
CREATE TABLE [dbo].[tRS_TBZDDY] (
	[tablename] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[fieldname] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[code] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Style] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TCKD]    Script Date: 2003-6-2 17:24:42 ******/
CREATE TABLE [dbo].[tRS_TCKD] (
	[BMBH] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[Lbmc] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Lbdm] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[Sldw] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Cksl] [int] NULL ,
	[Jsr] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Llr] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Slrq] [datetime] NULL ,
	[Dj] [decimal](18, 0) NULL ,
	[Je] [decimal](18, 0) NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TFLZJSR]    Script Date: 2003-6-2 17:24:42 ******/
CREATE TABLE [dbo].[tRS_TFLZJSR] (
	[fldDate] [datetime] NULL ,
	[FLJJ] [decimal](9, 2) NULL ,
	[LRLC] [decimal](9, 2) NULL ,
	[GHWJF] [decimal](9, 2) NULL ,
	[GLFZC] [decimal](9, 2) NULL ,
	[YYWZC] [decimal](9, 2) NULL ,
	[QTLY] [decimal](9, 2) NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TFLZJZC]    Script Date: 2003-6-2 17:24:42 ******/
CREATE TABLE [dbo].[tRS_TFLZJZC] (
	[fldDate] [datetime] NULL ,
	[JTFLBT] [decimal](9, 2) NULL ,
	[JTFLSS] [decimal](9, 2) NULL ,
	[JHSYBT] [decimal](9, 2) NULL ,
	[SZWXJJ] [decimal](9, 2) NULL ,
	[SHKNBT] [decimal](9, 2) NULL ,
	[WTXC] [decimal](9, 2) NULL ,
	[DJQNBT] [decimal](9, 2) NULL ,
	[JT] [decimal](9, 2) NULL ,
	[XLWS] [decimal](9, 2) NULL ,
	[QTFY] [decimal](9, 2) NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_THTJC]    Script Date: 2003-6-2 17:24:42 ******/
CREATE TABLE [dbo].[tRS_THTJC] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[SHBZ] [decimal](18, 0) NULL ,
	[DYQX] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[YLBZ] [decimal](18, 0) NULL ,
	[JJBS] [decimal](18, 0) NULL ,
	[TXRQ] [datetime] NULL ,
	[JBR] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[SJZZRQ] [datetime] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_THTSJ]    Script Date: 2003-6-2 17:24:42 ******/
CREATE TABLE [dbo].[tRS_THTSJ] (
	[HTBH] [char] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[YGWGZ] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[SYQ] [datetime] NULL ,
	[GZ] [decimal](18, 0) NULL ,
	[QDRQ] [datetime] NULL ,
	[SXRQ] [datetime] NULL ,
	[SYQMRQ] [datetime] NULL ,
	[HTNX] [smallint] NULL ,
	[HTZZRQ] [datetime] NULL ,
	[HTZL] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[QQSDW] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[YXBZ] [smallint] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TJLQ]    Script Date: 2003-6-2 17:24:43 ******/
CREATE TABLE [dbo].[tRS_TJLQ] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[YLQ] [smallint] NULL ,
	[YYLQ] [smallint] NULL ,
	[JZRQ] [datetime] NULL ,
	[YLLJ] [smallint] NULL ,
	[YLQMQX] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[SCBXRQ] [datetime] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TLDSJSZ]    Script Date: 2003-6-2 17:24:43 ******/
CREATE TABLE [dbo].[tRS_TLDSJSZ] (
	[LRFS] [smallint] NULL ,
	[KQJLDW] [smallint] NULL ,
	[GSJLDW] [smallint] NULL ,
	[DEJLDW] [smallint] NULL ,
	[HZRQ] [smallint] NULL ,
	[BLYS] [smallint] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TLDZY]    Script Date: 2003-6-2 17:24:43 ******/
CREATE TABLE [dbo].[tRS_TLDZY] (
	[Lx] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Sszgxm] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Ssrdw] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Ssdb] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Jsrdw] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Ssrs] [smallint] NULL ,
	[Sljg] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Clfs] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Ssrq] [datetime] NULL ,
	[Slrq] [datetime] NULL ,
	[Cljsrq] [datetime] NULL ,
	[Ssyy] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Cljg] [char] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TLKD]    Script Date: 2003-6-2 17:24:43 ******/
CREATE TABLE [dbo].[tRS_TLKD] (
	[BMBH] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[Lbmc] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Lbdm] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[Sldw] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Jksl] [int] NULL ,
	[Djje] [decimal](18, 0) NULL ,
	[Ze] [decimal](18, 0) NULL ,
	[Jsr] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Srrq] [datetime] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TQTDM]    Script Date: 2003-6-2 17:24:43 ******/
CREATE TABLE [dbo].[tRS_TQTDM] (
	[CODE] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[NAME] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[USED] [smallint] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TRSCX]    Script Date: 2003-6-2 17:24:43 ******/
CREATE TABLE [dbo].[tRS_TRSCX] (
	[Bt] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Lr] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TYLJL]    Script Date: 2003-6-2 17:24:44 ******/
CREATE TABLE [dbo].[tRS_TYLJL] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[BXKJ] [datetime] NULL ,
	[BXZZ] [datetime] NULL ,
	[LJBXS] [smallint] NULL ,
	[BQZY] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[JRR] [char] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TYPKC]    Script Date: 2003-6-2 17:24:44 ******/
CREATE TABLE [dbo].[tRS_TYPKC] (
	[Lbdm] [char] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Lbmc] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Sldw] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Kcl] [int] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TZGDE]    Script Date: 2003-6-2 17:24:44 ******/
CREATE TABLE [dbo].[tRS_TZGDE] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[XH] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[TH] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[MC] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[GX] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[SJSL] [decimal](9, 2) NULL ,
	[DJGS] [decimal](9, 2) NULL ,
	[DEGS] [decimal](9, 2) NULL ,
	[SZGS] [decimal](9, 2) NULL ,
	[Time] [char] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TZGDEHZ]    Script Date: 2003-6-2 17:24:44 ******/
CREATE TABLE [dbo].[tRS_TZGDEHZ] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[XH] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[TH] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[MC] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[GX] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[SJSL] [decimal](9, 2) NULL ,
	[DJGS] [decimal](9, 2) NULL ,
	[DEGS] [decimal](9, 2) NULL ,
	[SZGS] [decimal](9, 2) NULL ,
	[Month] [char] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TZGGS]    Script Date: 2003-6-2 17:24:44 ******/
CREATE TABLE [dbo].[tRS_TZGGS] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
12 下一页
⌨️ 快捷键说明

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