cf.sql

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

/****** Object:  Table [dbo].[tCF_Item]    ******/
CREATE TABLE [dbo].[tCF_Item] (
	[siYear] [smallint] NOT NULL ,
	[cTypeCode] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cItemCode] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcItemName] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[bFlowIn] [smallint] NULL ,
	[iRow] [int] NULL ,
	[bUsed] [smallint] NULL ,
	[bSysDef] [smallint] NULL ,
	[bMayAppend] [smallint] NULL ,
	[bFormula] [smallint] NULL, 
    [bAllowEdit] [smallint]  NULL
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tCF_OneOne<<YEAR>>]   ******/
CREATE TABLE [dbo].[tCF_OneOne<<YEAR>>] (
	[tiOriginKjqj] [smallint] NOT NULL ,
	[cOriginPzzl] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cOriginPzbh] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[dOriginPzrq] [datetime] NOT NULL ,
	[bSpecial] [smallint] NOT NULL ,
	[siSubId] [smallint] NOT NULL ,
	[siOneOneID] [smallint] NULL ,
	[cFX] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[deJE] [decimal](15, 2) NULL ,
	[cKmdm] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[cKmmc] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[cPzzy] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[cFX2] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[deJE2] [decimal](15, 2) NULL ,
	[cKmdm2] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[cKmmc2] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[cPzzy2] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[cCashDirection] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[cItemCode] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[deItemJe] [decimal](15, 2) NULL ,
	[bSplitFlag] [smallint] NOT NULL ,
	[bRight] [smallint] NULL ,
	[cFhrmCode] [varchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[cFhrmName] [char] (8) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tCF_ReportData]    ******/
CREATE TABLE [dbo].[tCF_ReportData] (
	[siYear] [smallint] NOT NULL ,
	[tiPeriod] [smallint] NOT NULL ,
	[vcCode] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[mValue] [decimal](15, 2) NULL ,
	[iRow] [int] NULL ,
	[vcTypeName] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tCF_Source]    ******/
CREATE TABLE [dbo].[tCF_Source] (
	[siYear] [smallint] NOT NULL ,
	[cTypeCode] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cItemCode] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[tiStep] [smallint] NOT NULL ,
	[cSymbol] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[vcGetMethod] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[vcFormulaName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[vcFormulaNameEng] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[vcComment] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[vcFormula] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[mValue] [decimal](15, 2) NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tCF_SplitResult]   ******/
CREATE TABLE [dbo].[tCF_SplitResult] (
	[id] [varchar] (38) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[siYear] [smallint] NOT NULL ,
	[tiOriginKjqj] [smallint] NOT NULL ,
	[cOriginPzzl] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cOriginPzbh] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[dOriginPzrq] [datetime] NOT NULL ,
	[siSubID] [smallint] NOT NULL ,
	[siOriginJlhm] [smallint] NOT NULL ,
	[cKmdm] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[cKmmc] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[cPzzy] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[cFX] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[deJE] [decimal](15, 2) NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tCF_Type]   ******/
CREATE TABLE [dbo].[tCF_Type] (
	[cTypeCode] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcTypeName] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[bAdditional] [smallint] NULL ,
    [bAllowEdit] [smallint]  NULL
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tCF_VoucherSource]  ******/
CREATE TABLE [dbo].[tCF_VoucherSource] (
	[siYear] [smallint] NOT NULL ,
	[cItemCode] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[tiStep] [smallint] NOT NULL ,
	[cSymbol] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[cKmdm] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[cKmmc] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[siId] [smallint] NOT NULL 
) ON [PRIMARY]
;

ALTER TABLE [dbo].[tCF_Item] WITH NOCHECK ADD 
	CONSTRAINT [DF__tCF_Item__bUsed__1FEDB87C] DEFAULT (0) FOR [bUsed],
	CONSTRAINT [DF__tCF_Item__bSysDe__20E1DCB5] DEFAULT (0) FOR [bSysDef],
	CONSTRAINT [DF__tCF_Item__bMayAp__21D600EE] DEFAULT ((-1)) FOR [bMayAppend],
	CONSTRAINT [DF__tCF_Item__bFormu__22CA2527] DEFAULT (0) FOR [bFormula],
	CONSTRAINT [PK_CF_Item] PRIMARY KEY  CLUSTERED 
	(
		[siYear],
		[cTypeCode],
		[cItemCode]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tCF_OneOne<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF__tCF_OneOne__deJE__30242045] DEFAULT (0) FOR [deJE],
	CONSTRAINT [DF__tCF_OneOn__deJE2__3118447E] DEFAULT (0) FOR [deJE2],
	CONSTRAINT [DF__tCF_OneOn__deIte__320C68B7] DEFAULT (0) FOR [deItemJe],
	CONSTRAINT [DF__tCF_OneOn__bRigh__33008CF0] DEFAULT ((-1)) FOR [bRight]
;

ALTER TABLE [dbo].[tCF_ReportData] WITH NOCHECK ADD 
	CONSTRAINT [DF__tCF_Repor__mValu__25A691D2] DEFAULT (0) FOR [mValue],
	CONSTRAINT [PK_CF_ReportData] PRIMARY KEY  CLUSTERED 
	(
		[siYear],
		[tiPeriod],
		[vcCode]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tCF_Source] WITH NOCHECK ADD 
	CONSTRAINT [DF__tCF_Sourc__cSymb__2882FE7D] DEFAULT ('+') FOR [cSymbol],
	CONSTRAINT [PK_CF_Source] PRIMARY KEY  CLUSTERED 
	(
		[siYear],
		[cTypeCode],
		[cItemCode],
		[tiStep]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tCF_SplitResult] WITH NOCHECK ADD 
	CONSTRAINT [DF__tCF_SplitR__deJE__2B5F6B28] DEFAULT (0) FOR [deJE]
;

ALTER TABLE [dbo].[tCF_Type] WITH NOCHECK ADD 
	CONSTRAINT [DF__tCF_Type__bAddit__2E3BD7D3] DEFAULT (0) FOR [bAdditional],
	 PRIMARY KEY  CLUSTERED 
	(
		[cTypeCode]
	)  ON [PRIMARY] 
;