⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 gd.sql

📁 一个用VB写的财务软件源码
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
CREATE TABLE [dbo].[TGD_ASSETSORIGIN] (
	[CCODE] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCNAME] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_BALANCE<<YEAR>>] (
	[KPBH] [char] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LJJYZ00] [numeric](15, 2) NULL ,
	[LJDYZ00] [numeric](15, 2) NULL ,
	[LJJZJ00] [numeric](15, 2) NULL ,
	[LJDZJ00] [numeric](15, 2) NULL ,
	[LJJJZ00] [numeric](15, 2) NULL ,
	[LJDJZ00] [numeric](15, 2) NULL ,
	[LJJXF00] [numeric](15, 2) NULL ,
	[LJDXF00] [numeric](15, 2) NULL ,
	[LJJYZ01] [numeric](15, 2) NULL ,
	[LJDYZ01] [numeric](15, 2) NULL ,
	[LJJZJ01] [numeric](15, 2) NULL ,
	[LJDZJ01] [numeric](15, 2) NULL ,
	[LJJJZ01] [numeric](15, 2) NULL ,
	[LJDJZ01] [numeric](15, 2) NULL ,
	[LJJXF01] [numeric](15, 2) NULL ,
	[LJDXF01] [numeric](15, 2) NULL ,
	[LJJYZ02] [numeric](15, 2) NULL ,
	[LJDYZ02] [numeric](15, 2) NULL ,
	[LJJZJ02] [numeric](15, 2) NULL ,
	[LJDZJ02] [numeric](15, 2) NULL ,
	[LJJJZ02] [numeric](15, 2) NULL ,
	[LJDJZ02] [numeric](15, 2) NULL ,
	[LJJXF02] [numeric](15, 2) NULL ,
	[LJDXF02] [numeric](15, 2) NULL ,
	[LJJYZ03] [numeric](15, 2) NULL ,
	[LJDYZ03] [numeric](15, 2) NULL ,
	[LJJZJ03] [numeric](15, 2) NULL ,
	[LJDZJ03] [numeric](15, 2) NULL ,
	[LJJJZ03] [numeric](15, 2) NULL ,
	[LJDJZ03] [numeric](15, 2) NULL ,
	[LJJXF03] [numeric](15, 2) NULL ,
	[LJDXF03] [numeric](15, 2) NULL ,
	[LJJYZ04] [numeric](15, 2) NULL ,
	[LJDYZ04] [numeric](15, 2) NULL ,
	[LJJZJ04] [numeric](15, 2) NULL ,
	[LJDZJ04] [numeric](15, 2) NULL ,
	[LJJJZ04] [numeric](15, 2) NULL ,
	[LJDJZ04] [numeric](15, 2) NULL ,
	[LJJXF04] [numeric](15, 2) NULL ,
	[LJDXF04] [numeric](15, 2) NULL ,
	[LJJYZ05] [numeric](15, 2) NULL ,
	[LJDYZ05] [numeric](15, 2) NULL ,
	[LJJZJ05] [numeric](15, 2) NULL ,
	[LJDZJ05] [numeric](15, 2) NULL ,
	[LJJJZ05] [numeric](15, 2) NULL ,
	[LJDJZ05] [numeric](15, 2) NULL ,
	[LJJXF05] [numeric](15, 2) NULL ,
	[LJDXF05] [numeric](15, 2) NULL ,
	[LJJYZ06] [numeric](15, 2) NULL ,
	[LJDYZ06] [numeric](15, 2) NULL ,
	[LJJZJ06] [numeric](15, 2) NULL ,
	[LJDZJ06] [numeric](15, 2) NULL ,
	[LJJJZ06] [numeric](15, 2) NULL ,
	[LJDJZ06] [numeric](15, 2) NULL ,
	[LJJXF06] [numeric](15, 2) NULL ,
	[LJDXF06] [numeric](15, 2) NULL ,
	[LJJYZ07] [numeric](15, 2) NULL ,
	[LJDYZ07] [numeric](15, 2) NULL ,
	[LJJZJ07] [numeric](15, 2) NULL ,
	[LJDZJ07] [numeric](15, 2) NULL ,
	[LJJJZ07] [numeric](15, 2) NULL ,
	[LJDJZ07] [numeric](15, 2) NULL ,
	[LJJXF07] [numeric](15, 2) NULL ,
	[LJDXF07] [numeric](15, 2) NULL ,
	[LJJYZ08] [numeric](15, 2) NULL ,
	[LJDYZ08] [numeric](15, 2) NULL ,
	[LJJZJ08] [numeric](15, 2) NULL ,
	[LJDZJ08] [numeric](15, 2) NULL ,
	[LJJJZ08] [numeric](15, 2) NULL ,
	[LJDJZ08] [numeric](15, 2) NULL ,
	[LJJXF08] [numeric](15, 2) NULL ,
	[LJDXF08] [numeric](15, 2) NULL ,
	[LJJYZ09] [numeric](15, 2) NULL ,
	[LJDYZ09] [numeric](15, 2) NULL ,
	[LJJZJ09] [numeric](15, 2) NULL ,
	[LJDZJ09] [numeric](15, 2) NULL ,
	[LJJJZ09] [numeric](15, 2) NULL ,
	[LJDJZ09] [numeric](15, 2) NULL ,
	[LJJXF09] [numeric](15, 2) NULL ,
	[LJDXF09] [numeric](15, 2) NULL ,
	[LJJYZ10] [numeric](15, 2) NULL ,
	[LJDYZ10] [numeric](15, 2) NULL ,
	[LJJZJ10] [numeric](15, 2) NULL ,
	[LJDZJ10] [numeric](15, 2) NULL ,
	[LJJJZ10] [numeric](15, 2) NULL ,
	[LJDJZ10] [numeric](15, 2) NULL ,
	[LJJXF10] [numeric](15, 2) NULL ,
	[LJDXF10] [numeric](15, 2) NULL ,
	[LJJYZ11] [numeric](15, 2) NULL ,
	[LJDYZ11] [numeric](15, 2) NULL ,
	[LJJZJ11] [numeric](15, 2) NULL ,
	[LJDZJ11] [numeric](15, 2) NULL ,
	[LJJJZ11] [numeric](15, 2) NULL ,
	[LJDJZ11] [numeric](15, 2) NULL ,
	[LJJXF11] [numeric](15, 2) NULL ,
	[LJDXF11] [numeric](15, 2) NULL ,
	[LJJYZ12] [numeric](15, 2) NULL ,
	[LJDYZ12] [numeric](15, 2) NULL ,
	[LJJZJ12] [numeric](15, 2) NULL ,
	[LJDZJ12] [numeric](15, 2) NULL ,
	[LJJJZ12] [numeric](15, 2) NULL ,
	[LJDJZ12] [numeric](15, 2) NULL ,
	[LJJXF12] [numeric](15, 2) NULL ,
	[LJDXF12] [numeric](15, 2) NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_DEPARTMENT<<YEAR>>] (
	[CDEPCODE] [char] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CDEPNAME] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IDEPGRADE] [smallint] NULL ,
	[BDEPEND] [smallint] NULL ,
	[CDEPPERSON] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[CDEPPHONE] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[CDEPMEMO] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[BOTHERUSE] [smallint] NULL ,
	[CGDKM] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[ISHAVEZD] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[XFDFKM] [char] (40) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_DEPARTMENTKM] (
	[CDEPCODE] [char] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CDEPNAME] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CGDKM] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[XFDFKM] [char] (40) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_DISPLAY] (
	[VCNAME] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCCHINAME] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[VCENGNAME] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[VCDISNAME] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[VCUSE] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[VCORDER] [int] NOT NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_GDZCKP] (
	[KPBH] [char] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[GDZCBH] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[GDZCMC] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[BMBH] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[BMMC] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[CFDD] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[LBBH] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[LBMC] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[WBYZ] [decimal](15, 2) NULL ,
	[YZ] [decimal](15, 2) NULL ,
	[CGZ] [decimal](15, 2) NULL ,
	[JCZ] [decimal](15, 2) NULL ,
	[JCZL] [decimal](15, 4) NULL ,
	[JZ] [decimal](15, 2) NULL ,
	[KSSYRQ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[YZJE] [decimal](15, 2) NULL ,
	[YZJL] [decimal](15, 4) NULL ,
	[ZJFF] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[LJZJ] [decimal](15, 2) NULL ,
	[YJTYF] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[SYNX] [smallint] NULL ,
	[SYZK] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[BIZ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BZDW] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZCKM] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[DYZJKM] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[GZLDW] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[GZZL] [decimal](15, 4) NULL ,
	[LJGZL] [decimal](15, 4) NULL ,
	[DWZJ] [decimal](15, 4) NULL ,
	[ZJFS] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[JSFS] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZXR] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZXRQ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[LRR] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[LRRQ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[XMBH] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[GGXH] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[HL] [decimal](15, 4) NULL ,
	[JZS] [smallint] NULL ,
	[DJSL] [smallint] NULL ,
	[DJGR] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[JZMJ] [decimal](15, 4) NULL ,
	[BJ] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[KPYS] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[SYZKBH] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZJKM] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[BMFS] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[TXQ] [smallint] NULL ,
	[YTXFL] [decimal](15, 4) NULL ,
	[YTFY] [decimal](15, 4) NULL ,
	[ZJLYBM] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZJLYMC] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZCFLDM] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZCFLMC] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[LJJZZB] [decimal](15, 2) NULL ,
	[BQJZZB] [decimal](15, 2) NULL ,
	[JZZBKM] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[XFKM] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[XFDFKM] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[FPXMMC] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[GZRQ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BXDH] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[JZCBS] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[SCCS] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[CCRQ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[CPZH] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[JLDW] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BXDBH] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[QGDBH] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[YSDBH] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZY] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[QCYZ] [decimal](15, 2) NULL ,
	[QCLJZJ] [decimal](15, 2) NULL ,
	[QCLJJZZB] [decimal](15, 2) NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_GZL] (
	[KPBH] [char] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SRYF] [char] (7) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[GZL] [decimal](15, 4) NULL ,
	[SQGZL] [decimal](15, 4) NULL ,
	[LRR] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[LRRQ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDQZJE] [decimal](15, 2) NULL ,
	[BDQZJL] [decimal](15, 6) NULL ,
	[BDQLJGZL] [decimal](15, 4) NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_GZSQ] (
	[QGDBH] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BMBH] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BMMC] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[TBR] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[SQSJ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[SBMC] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[GGXH] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[SCCJ] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[SGSL] [int] NULL ,
	[SXZJ] [decimal](18, 0) NULL ,
	[LYYT] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[SBTJ] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[RYTJ] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[JJXY] [decimal](15, 2) NULL ,
	[SBSYL] [decimal](15, 2) NULL ,
	[NHS] [decimal](15, 2) NULL ,
	[YSBQK] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZRYJ] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SBKYJ] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[LDSP] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PZWH] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[BZ] [char] (50) COLLATE Chinese_PRC_CI_AS NULL,
    [KPBH][char] (25) COLLATE Chinese_PRC_CI_AS NULL   
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_KPMODE] (
	[VCFILENAME] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LCONTENT] [image] NULL ,
	[LENGTH] [int] NOT NULL ,
	[HGZL] [smallint] NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_KPXM] (
	[ID] [int] NOT NULL ,
	[EBIAOM] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CBIAOM] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[XMMC] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[LX] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[BMMC] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ZSCD] [smallint] NULL ,
	[XSCD] [smallint] NULL ,
	[XT] [smallint] NULL ,
	[BB] [smallint] NULL ,
	[KXG] [smallint] NULL ,
	[CXXM] [char] (3) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_KPYS] (
	[YSMC] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[WJMXH] [smallint] NULL ,
	[HGZL] [smallint] NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_LINK] (
	[VCLINKNAME] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCRELATION] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[VCLEFT] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[VCCHINAME1] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[VCTABLENAME1] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[VCITEMCHI1] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[VCITEMENG1] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCCOMPARE] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCCHINAME2] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[VCTABLENAME2] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[VCITEMCHI2] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[VCITEMENG2] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[VCRIGHT] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[VCUSE] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[IORDERNUM] [varchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_OPTION] (
12345

⌨️ 快捷键说明

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