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

📄 mr.sql

📁 一个用VB写的财务软件源码
💻 SQL
📖 第 1 页 / 共 2 页
字号:
🔍
12 
CREATE TABLE [dbo].[TMR_BILLPARAMETER] (
	[CODE] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[NAME] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[TMR_COLLATEFORMULA] (
	[CODE] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[JF] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[DF] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[TMR_COMPANY] (
	[CYEAR] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCCODE] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCNAME] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CTYPE] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BMERGE] [numeric](38, 0) NOT NULL ,
	[STOCK] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[TMR_DRAFT<<YEAR>>] (
	[ID] [numeric](38, 0) NOT NULL ,
	[VCREPORTCODE] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MONTH] [varchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MERGECOLID] [numeric](38, 0) NOT NULL ,
	[OFFSETITEMID] [numeric](38, 0) NOT NULL ,
	[REPORTITEMNAME] [char] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[TOTAL] [float] NOT NULL ,
	[JF] [float] NOT NULL ,
	[DF] [float] NOT NULL ,
	[GQ] [float] NOT NULL ,
	[MERGE] [float] NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[TMR_DRAFTASSISTANT<<YEAR>>] (
	[ID] [numeric](38, 0) NOT NULL ,
	[DRAFTID] [numeric](38, 0) NOT NULL ,
	[MANUSCRIPTCOLID] [numeric](38, 0) NOT NULL ,
	[MANUSCRIPTCOLNAME] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[DATA] [float] NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[TMR_LOCKREPORT] (
	[VCREPORTCODE] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IMONTH] [numeric](38, 0) NOT NULL ,
	[IYEAR] [numeric](38, 0) NOT NULL ,
	[COMPANYCODE] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[TMR_MANUSCRIPTDESIGN] (
	[ID] [numeric](38, 0) NOT NULL ,
	[VCYEAR] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ICOL] [numeric](38, 0) NOT NULL ,
	[VCWORD] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[TMR_MERGECOL] (
	[ID] [numeric](38, 0) NOT NULL ,
	[VCREPORTCODE] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCYEAR] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCNAME] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCCOL] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCFORMULA] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[TMR_OFFSET<<YEAR>>] (
	[CMONTH] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CNUMBER] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCREPORTCODE] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[DMAKEDATE] [datetime] NOT NULL ,
	[CUSERID] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CUSERNAME] [varchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCCOMMENT] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ID] [numeric](38, 0) NOT NULL ,
	[COWNER] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CCOMPANY] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BAUTO] [numeric](38, 0) NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[TMR_OFFSETBILL] (
	[ID] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[KJNF] [numeric](38, 0) NOT NULL ,
	[KJQJ] [numeric](38, 0) NOT NULL ,
	[XMBH] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[XMMC] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[DWBH] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[DWMC] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[DFDWBH] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[DFDWMC] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PM] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[SL] [numeric](15, 3) NULL ,
	[JE] [numeric](15, 2) NOT NULL ,
	[QRJE] [numeric](15, 2) NOT NULL ,
	[DZKM] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BZ] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[BH] [varchar](4) NOT NULL ,
	[JLHM] [numeric](38, 0) NOT NULL ,
	[XGBZ] [numeric](38, 0) NOT NULL ,
	[DZKMMC] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[PROFIT] [numeric](38, 0) NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[TMR_OFFSETBILLMODEL] (
	[VCCODE] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCNAME] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCTYPE] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCITEM] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCYEAR] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[TMR_OFFSETDATA<<YEAR>>] (
	[ID] [numeric](38, 0) NOT NULL ,
	[COID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[OFFSETITEMID] [numeric](38, 0) NOT NULL ,
	[CUSTOMERCOID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[DATA] [float] NOT NULL ,
	[MONTH] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BUSED] [numeric](38, 0) NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[TMR_OFFSETEQUAL<<YEAR>>] (
	[ID] [numeric](38, 0) NOT NULL ,
	[VCREPORTCODE] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ISORTID] [numeric](38, 0) NOT NULL ,
	[EQUALFORMULA] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[EQUALRESULT] [numeric](38, 0) NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[TMR_OFFSETITEM<<YEAR>>] (
	[ID] [numeric](38, 0) NOT NULL IDENTITY (1, 1) ,
	[ITEMNAME] [varchar] (234) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCREPORTCODE] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCREPORTITEM] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SIROWLABEL] [numeric](38, 0) NOT NULL ,
	[SICOLLABEL] [numeric](38, 0) NOT NULL ,
	[MERGECOLID] [numeric](38, 0) NOT NULL ,
	[TYPE] [numeric](38, 0) NOT NULL ,
	[BEXPORT] [numeric](38, 0) NOT NULL ,
	[BENTER] [numeric](38, 0) NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[TMR_OFFSETSUB<<YEAR>>] (
	[ID] [numeric](38, 0) NOT NULL ,
	[SISERIAL] [numeric](38, 0) NOT NULL ,
	[VCSUMMARY] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CFX] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[DEJE] [numeric](15, 2) NOT NULL ,
	[VCREPORTITEM] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IITEMROW] [numeric](38, 0) NOT NULL ,
	[ITEMID] [numeric](38, 0) NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[TMR_PARAMETER] (
	[ID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[COMPANYCODE] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CYEAR] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CNAME] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CVALUE] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[TMR_REPORT<<YEAR>>] (
	[VCREPORTCODE] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCREPORTNAME] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CREPORTTYPE] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BTOTAL] [numeric](38, 0) NULL ,
	[BCOLLECT] [numeric](38, 0) NULL ,
	[BMERGE] [numeric](38, 0) NULL ,
	[BANALYSIS] [numeric](38, 0) NULL ,
	[SISERIAL] [numeric](38, 0) NOT NULL ,
	[ID] [numeric](38, 0) NULL ,
	[BACCESSORY] [numeric](38, 0) NOT NULL ,
	[PARENTCODE] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[TMR_REPORTAREA] (
	[CYEAR] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCREPORTCODE] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SISTARTROW] [numeric](38, 0) NOT NULL ,
	[SISTARTCOL] [numeric](38, 0) NOT NULL ,
	[SIENDROW] [numeric](38, 0) NOT NULL ,
	[SIENDCOL] [numeric](38, 0) NOT NULL ,
	[CAREATYPE] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[TMR_REPORTDATA<<YEAR>>] (
	[REPORTCODE] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ENTERCODE] [varchar] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MONTH] [numeric](38, 0) NOT NULL ,
	[IROWLABEL] [numeric](38, 0) NOT NULL ,
	[COLLABEL] [numeric](38, 0) NOT NULL ,
	[CELLDATA] [numeric](15, 4) NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[TMR_REPORTEQUALIN] (
	[CYEAR] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCREPORTCODE] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ISORTID] [numeric](38, 0) NOT NULL ,
	[SIROWLABEL] [numeric](38, 0) NOT NULL ,
	[SICOLLABEL] [numeric](38, 0) NOT NULL ,
	[CCALCULATESIGN] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SISTARTROWLABEL] [numeric](38, 0) NOT NULL ,
	[SIENDROWLABEL] [numeric](38, 0) NOT NULL ,
	[SISTARTCOLLABEL] [numeric](38, 0) NOT NULL ,
	[SIENDCOLLABEL] [numeric](38, 0) NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[TMR_REPORTEQUALOUT] (
	[CYEAR] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCREPORTCODE] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ISORTID] [numeric](38, 0) NOT NULL ,
	[SIROWLABEL] [numeric](38, 0) NOT NULL ,
	[SICOLLABEL] [numeric](38, 0) NOT NULL ,
	[CCALCULATESIGN] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCREPORTCODE2] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCGETTIME] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SIROWLABEL2] [numeric](38, 0) NOT NULL ,
	[SICOLLABEL2] [numeric](38, 0) NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[TMR_REPORTFORMULA] (
	[CYEAR] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCREPORTCODE] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SIROWLABEL] [numeric](38, 0) NOT NULL ,
	[SICOLLABEL] [numeric](38, 0) NOT NULL ,
	[VCFORMULA] [varchar] (2000) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[TMR_REPORTHEAD] (
	[CYEAR] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCREPORTCODE] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SICOLLABEL] [numeric](38, 0) NOT NULL ,
	[SIBANISTER] [numeric](38, 0) NOT NULL ,
	[SICOLSERIAL] [numeric](38, 0) NOT NULL ,
	[VCCOLNAME] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CDATATYPE] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BGETDATACOL] [numeric](38, 0) NULL ,
	[MERGECOLID] [numeric](38, 0) NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[TMR_REPORTITEM] (
	[CYEAR] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCREPORTCODE] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SIROWLABEL] [numeric](38, 0) NOT NULL ,
	[SICOLLABEL] [numeric](38, 0) NOT NULL ,
	[VCITEMNAME] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BMERGE] [numeric](38, 0) NULL ,
	[BANALYSIS] [numeric](38, 0) NULL ,
	[SIITEMCLASS] [numeric](38, 0) NULL ,
	[VCITEMBM] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[TMR_REPORTMODE] (
	[CYEAR] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CMONTH] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCREPORTCODE] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LCONTENT] [image] NULL ,
	[LENGTH] [numeric](10, 0) NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

CREATE TABLE [dbo].[TMR_TEMPLETDETAIL<<YEAR>>] (
	[CCODE] [char] (3) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[JLHM] [numeric](38, 0) NOT NULL ,
	[PZZY] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[KMDM] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[KMMC] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[JFGS] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[DFGS] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[TMR_TEMPLETMAIN<<YEAR>>] (
	[CCODE] [char] (3) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCCOMMENT] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CPZZL] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[TIFJZS] [numeric](38, 0) NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[TMR_WBHL] (
	[ID] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[KJNF] [numeric](38, 0) NOT NULL ,
	[KJQJ] [numeric](38, 0) NOT NULL ,
	[WBBZ] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[HLDM] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[HLMC] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[HL] [numeric](10, 6) NOT NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[TMR_ZYWH] (
	[DMID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[NAME] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[KMDM] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

ALTER TABLE [dbo].[TMR_BILLPARAMETER] WITH NOCHECK ADD 
	CONSTRAINT [PK_TMR_BILLPARAMETER] PRIMARY KEY  CLUSTERED 
	(
		[CODE]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TMR_COLLATEFORMULA] WITH NOCHECK ADD 
	CONSTRAINT [PK_TMR_COLLATEFORMULA] PRIMARY KEY  CLUSTERED 
	(
		[CODE]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TMR_COMPANY] WITH NOCHECK ADD 
	CONSTRAINT [PK_TMR_COMPANY] PRIMARY KEY  CLUSTERED 
	(
		[CYEAR],
12

⌨️ 快捷键说明

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