fx.sql

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

/****** Object:  Table [dbo].[tFX_Rate]    ******/
CREATE TABLE [dbo].[tFX_Rate] (
	[cYear] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[TypeCode] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[RateCode] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[RateName] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[Unit] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Formula] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsSysDef] [smallint] NULL ,
	[QSFormula] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tFX_RateType]    ******/
CREATE TABLE [dbo].[tFX_RateType] (
	[cYear] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[TypeCode] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[TypeName] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsSysDef] [smallint] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tFX_RateUnit]   ******/
CREATE TABLE [dbo].[tFX_RateUnit] (
	[cYear] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[UnitName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IsSysDef] [smallint] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tfx_Area]    ******/
CREATE TABLE [dbo].[tfx_Area] (
	[cYear] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcReportCode] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[siStartRow] [smallint] NOT NULL ,
	[siStartCol] [smallint] NOT NULL ,
	[siEndRow] [smallint] NOT NULL ,
	[siEndCol] [smallint] NOT NULL ,
	[cAreaType] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tfx_Formula]    ******/
CREATE TABLE [dbo].[tfx_Formula] (
	[cYear] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcReportCode] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[siRowLabel] [smallint] NOT NULL ,
	[siColLabel] [smallint] NOT NULL ,
	[vcFormula] [varchar] (2000) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tfx_Head]   ******/
CREATE TABLE [dbo].[tfx_Head] (
	[cYear] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcReportCode] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[siColLabel] [smallint] NOT NULL ,
	[siBanister] [smallint] NOT NULL ,
	[siColSerial] [smallint] NOT NULL ,
	[vcColName] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cDataType] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[bGetDataCol] [smallint] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tfx_Item]    ******/
CREATE TABLE [dbo].[tfx_Item] (
	[cYear] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcReportCode] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[siRowLabel] [smallint] NOT NULL ,
	[siColLabel] [smallint] NOT NULL ,
	[vcItemName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[bMerge] [smallint] NULL ,
	[bAnalysis] [smallint] NULL ,
	[siItemClass] [smallint] NULL ,
	[vcItemBm] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tfx_Report]   ******/
CREATE TABLE [dbo].[tfx_Report] (
	[cyear] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[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] [smallint] NULL ,
	[bCollect] [smallint] NULL ,
	[bMerge] [smallint] NULL ,
	[bAnalysis] [smallint] NULL ,
	[siSerial] [smallint] NOT NULL ,
	[ID] [smallint] NULL ,
        [Typecode] [char](2) default '00',
	[babsoluteness] [smallint] NULL ,
	[bbase] [smallint] NULL ,
	[bcircle] [smallint] NULL ,
	[bcompare] [smallint] NULL ,
	[bstructrue] [smallint] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tfx_constant]   ******/
CREATE TABLE [dbo].[tfx_constant] (
	[cyear] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcname] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cmonthfrom] [char] (7) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cmonthto] [char] (7) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vccomment] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[mvalue] [decimal](15, 2) NULL ,
	[siusetimes] [smallint] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tfx_factorinit]    ******/
CREATE TABLE [dbo].[tfx_factorinit] (
	[cyear] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[factorname] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[formula] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[issysdef] [smallint] NULL ,
	[banalysis] [smallint] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tfx_reportdata<<YEAR>>]   ******/
CREATE TABLE [dbo].[tfx_reportdata<<YEAR>>] (
	[reportcode] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[entercode] [varchar] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[month] [smallint] NOT NULL ,
	[irowlabel] [int] NOT NULL ,
	[collabel] [int] NOT NULL ,
	[celldata] [decimal](15, 4)  NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tfx_reportmode]    ******/
CREATE TABLE [dbo].[tfx_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] [int] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

/****** Object:  Table [dbo].[tfx_subject]   ******/
CREATE TABLE [dbo].[tfx_subject] (
	[cyear] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[subjectcode] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[subjectname] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[formula] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tfx_xjkm]    ******/
CREATE TABLE [dbo].[tfx_xjkm] (
	[cyear] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[kmcode] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[kmname] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[yefx] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[direction] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

ALTER TABLE [dbo].[tFX_Rate] WITH NOCHECK ADD 
	CONSTRAINT [DF__tFX_Rate__IsSysD__5A846E65] DEFAULT (0) FOR [IsSysDef],
	CONSTRAINT [PK_FX_Rate] PRIMARY KEY  NONCLUSTERED 
	(
		[cYear],
		[TypeCode],
		[RateCode]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tFX_RateType] WITH NOCHECK ADD 
	CONSTRAINT [DF__tFX_RateT__IsSys__5D60DB10] DEFAULT (0) FOR [IsSysDef],
	CONSTRAINT [PK_FX_RateType] PRIMARY KEY  NONCLUSTERED 
	(
		[cYear],
		[TypeCode]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tFX_RateUnit] WITH NOCHECK ADD 
	CONSTRAINT [DF__tFX_RateU__IsSys__603D47BB] DEFAULT (0) FOR [IsSysDef],
	CONSTRAINT [PK_FX_RateUnit] PRIMARY KEY  NONCLUSTERED 
	(
		[cYear],
		[UnitName]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tfx_Area] WITH NOCHECK ADD 
	CONSTRAINT [PK_fx_Area] PRIMARY KEY  CLUSTERED 
	(
		[cYear],
		[vcReportCode],
		[siStartRow],
		[siStartCol],
		[siEndRow],
		[siEndCol]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tfx_Formula] WITH NOCHECK ADD 
	CONSTRAINT [PK_fx_Formula] PRIMARY KEY  CLUSTERED 
	(
		[cYear],
		[vcReportCode],