gd.sql

一个用VB写的财务软件源码

	[BDQYZJL] [decimal](15, 6) NULL ,
	[BDQZJFF] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDQZY] [char] (40) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_ZCTQYJL] (
	[KPBH] [char] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[DJH] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[TYRQ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[QYRQ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[TYYY] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[BZ] [char] (40) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_ZCYZBD] (
	[KPBH] [char] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BDLX] [smallint] NOT NULL ,
	[DJH] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BDRQ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[JSR] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDYY] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDJE] [decimal](15, 2) NULL ,
	[BDQJCZL] [decimal](15, 4) NULL ,
	[BDHJCZL] [decimal](15, 2) NULL ,
	[BDQYZ] [decimal](15, 2) NULL ,
	[BDQJCZ] [decimal](15, 2) NULL ,
	[BIZ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[HL] [decimal](15, 4) NULL ,
	[ZJLY] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDQYZJE] [decimal](15, 2) NULL ,
	[BDQYZJL] [decimal](15, 6) NULL ,
	[BDQZJFF] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDQZY] [char] (40) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_ZCZJFFTZ] (
	[KPBH] [char] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[DJH] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BDRQ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[JSR] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDYY] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDQZJFF] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDHZJFF] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDQYZJE] [decimal](15, 2) NULL ,
	[BDQYZJL] [decimal](15, 6) NULL ,
	[BDQBJ] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDQZY] [char] (40) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_ZCZJGS] (
	[GSMC] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[YZLZ] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[YZLC] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[YZEZ] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[YZEC] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[FLAG] [char] (2) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_ZCZTBD] (
	[KPBH] [char] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[DJH] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BDRQ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[JSR] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDYY] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDQSYZK] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDHSYZK] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDQSYZKBH] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDHSYZKBH] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDQZY] [char] (40) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_ZDYBB] (
	[ID] [smallint] NOT NULL ,
	[BBMC] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ITEM] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ITEMENG] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[ISFLXM] [smallint] NOT NULL ,
	[SYFLAG] [char] (2) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_ZJFS] (
	[DM] [char] (3) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MC] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[DYRZKM] [char] (40) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_ZJGSXM] (
	[XMMC] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[CODE] [char] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_ZJJT] (
	[KPBH] [char] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[TIME] [char] (7) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[JTYZ] [decimal](15, 2) NULL ,
	[JTJCZ] [decimal](15, 2) NULL ,
	[JTSYNX] [smallint] NULL ,
	[BYZJ] [decimal](15, 2) NULL ,
	[LJZJ] [decimal](15, 2) NULL ,
	[FPBMMC] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZJKMMC] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZCLBMC] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZJRQ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[JSR] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[FPXMMC] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[YZJL] [decimal](15, 2) NULL,
    [DWSJ] [decimal](18, 2) NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_ZJJTYZ] (
	[JTYZ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[SZRQ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];

ALTER TABLE [dbo].[TGD_ASSETSORIGIN] WITH NOCHECK ADD 
	CONSTRAINT [TPK_TGD_ASSETSORIGIN] PRIMARY KEY  CLUSTERED 
	(
		[CCODE]
	)  ON [PRIMARY]; 

ALTER TABLE [dbo].[TGD_BALANCE<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [PK_TGD_BALANCE2004] PRIMARY KEY  CLUSTERED 
	(
		[KPBH]
	)  ON [PRIMARY]; 

ALTER TABLE [dbo].[TGD_DISPLAY] WITH NOCHECK ADD 
	CONSTRAINT [PK_TGD_DISPLAY] PRIMARY KEY  CLUSTERED 
	(
		[VCNAME],
		[VCORDER]
	)  ON [PRIMARY]; 

ALTER TABLE [dbo].[TGD_GDZCKP] WITH NOCHECK ADD 
	CONSTRAINT [PK__TGD_GDZCKP__370627FE] PRIMARY KEY  CLUSTERED 
	(
		[KPBH]
	)  ON [PRIMARY]; 

ALTER TABLE [dbo].[TGD_GZL] WITH NOCHECK ADD 
	CONSTRAINT [PK_TGD_GZL] PRIMARY KEY  CLUSTERED 
	(
		[KPBH],
		[SRYF]
	)  ON [PRIMARY]; 

ALTER TABLE [dbo].[TGD_GZSQ] WITH NOCHECK ADD 
	CONSTRAINT [PK_TGD_GZSQ] PRIMARY KEY  CLUSTERED 
	(
		[QGDBH]
	)  ON [PRIMARY]; 

ALTER TABLE [dbo].[TGD_KPXM] WITH NOCHECK ADD 
	CONSTRAINT [PK_TGD_KPXM] PRIMARY KEY  CLUSTERED 
	(
		[EBIAOM],
		[BMMC],
		[ID]
	)  ON [PRIMARY]; 

ALTER TABLE [dbo].[TGD_LINK] WITH NOCHECK ADD 
	CONSTRAINT [PK_TGD_LINK] PRIMARY KEY  CLUSTERED 
	(
		[VCLINKNAME],
		[IORDERNUM]
	)  ON [PRIMARY]; 

ALTER TABLE [dbo].[TGD_ORIGINCHANGED] WITH NOCHECK ADD 
	CONSTRAINT [PK_TGD_ORIGINCHANGED] PRIMARY KEY  CLUSTERED 
	(
		[KPBH],
		[DJH]
	)  ON [PRIMARY]; 

ALTER TABLE [dbo].[TGD_OTHERMODE] WITH NOCHECK ADD 
	CONSTRAINT [PK_TGD_OTHERMODE] PRIMARY KEY  CLUSTERED 
	(
		[VCFILENAME]
	)  ON [PRIMARY]; 

ALTER TABLE [dbo].[TGD_OTHERXM] WITH NOCHECK ADD 
	CONSTRAINT [PK_TGD_OTHERXM] PRIMARY KEY  CLUSTERED 
	(
		[TENGNAME],
		[BMMC]
	)  ON [PRIMARY]; 

ALTER TABLE [dbo].[TGD_QUERYSET] WITH NOCHECK ADD 
	CONSTRAINT [PK_TGD_QUERYSET] PRIMARY KEY  CLUSTERED 
	(
		[VCQUERYNAME],
		[IORDERNUM]
	)  ON [PRIMARY]; 

ALTER TABLE [dbo].[TGD_SYZK] WITH NOCHECK ADD 
	 PRIMARY KEY  CLUSTERED 
	(
		[DM]
	)  ON [PRIMARY]; 

ALTER TABLE [dbo].[TGD_ZCBMZY] WITH NOCHECK ADD 
	CONSTRAINT [PK_TGD_ZCBMZY] PRIMARY KEY  CLUSTERED 
	(
		[KPBH],
		[DJH]
	)  ON [PRIMARY]; 
 

ALTER TABLE [dbo].[TGD_ZCDXJL] WITH NOCHECK ADD 
	CONSTRAINT [PK_TGD_ZCDXJL] PRIMARY KEY  CLUSTERED 
	(
		[KPBH],
		[DJH]
	)  ON [PRIMARY]; 
 

ALTER TABLE [dbo].[TGD_ZCFL] WITH NOCHECK ADD 
	CONSTRAINT [TPK_TGD_ZCFL] PRIMARY KEY  CLUSTERED 
	(
		[DM]
	)  ON [PRIMARY]; 
 

ALTER TABLE [dbo].[TGD_ZCFSSB] WITH NOCHECK ADD 
	CONSTRAINT [PK_TGD_ZCFSSB] PRIMARY KEY  CLUSTERED 
	(
		[KPBH],
		[SBBH]
	)  ON [PRIMARY]; 
 

ALTER TABLE [dbo].[TGD_ZCGZZLTZ] WITH NOCHECK ADD 
	CONSTRAINT [PK_TGD_ZCGZZLTZ] PRIMARY KEY  CLUSTERED 
	(
		[KPBH],
		[DJH]
	)  ON [PRIMARY]; 
 

ALTER TABLE [dbo].[TGD_ZCJCZLBD] WITH NOCHECK ADD 
	CONSTRAINT [PK_TGD_ZCJCZLBD] PRIMARY KEY  CLUSTERED 
	(
		[KPBH],
		[DJH]
	)  ON [PRIMARY]; 
 

ALTER TABLE [dbo].[TGD_ZCJS] WITH NOCHECK ADD 
	CONSTRAINT [PK__TGD_ZCJS__5D95E53A] PRIMARY KEY  CLUSTERED 
	(
		[KPBH]
	)  ON [PRIMARY]; 
 

ALTER TABLE [dbo].[TGD_ZCJZZB] WITH NOCHECK ADD 
	CONSTRAINT [PK_TGD_ZCJZZB] PRIMARY KEY  CLUSTERED 
	(
		[KPBH],
		[DJH]
	)  ON [PRIMARY]; 
 

ALTER TABLE [dbo].[TGD_ZCLB] WITH NOCHECK ADD 
	CONSTRAINT [PK__TGD_ZCLB__5E8A0973] PRIMARY KEY  CLUSTERED 
	(
		[DM]
	)  ON [PRIMARY]; 
 

ALTER TABLE [dbo].[TGD_ZCLBJS] WITH NOCHECK ADD 
	 PRIMARY KEY  CLUSTERED 
	(
		[JC]
	)  ON [PRIMARY]; 

ALTER TABLE [dbo].[TGD_ZCLBTZ] WITH NOCHECK ADD 
	CONSTRAINT [PK_TGD_ZCLBTZ] PRIMARY KEY  CLUSTERED 
	(
		[KPBH],
		[DJH]
	)  ON [PRIMARY]; 

ALTER TABLE [dbo].[TGD_ZCLJZJTZ] WITH NOCHECK ADD 
	CONSTRAINT [PK__TGD_ZCLJZJTZ__607251E5] PRIMARY KEY  CLUSTERED 
	(
		[KPBH],
		[DJH]
	)  ON [PRIMARY]; 

ALTER TABLE [dbo].[TGD_ZCPG] WITH NOCHECK ADD 
	CONSTRAINT [PK_TGD_ZCPG] PRIMARY KEY  CLUSTERED 
	(
		[KPBH],
		[PGRQ]
	)  ON [PRIMARY]; 

ALTER TABLE [dbo].[TGD_ZCSYNXTZ] WITH NOCHECK ADD 
	CONSTRAINT [PK_TGD_ZCSYNXTZ] PRIMARY KEY  CLUSTERED 
	(
		[KPBH],
		[DJH]
	)  ON [PRIMARY]; 

ALTER TABLE [dbo].[TGD_ZCTQYJL] WITH NOCHECK ADD 
	CONSTRAINT [PK_TGD_ZCTQYJL] PRIMARY KEY  CLUSTERED 
	(