sf.sql

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

/****** Object:  Table [dbo].[tYSYF_BadAccountKm<<YEAR>>]    Script Date: 2003-5-30 15:30:12 ******/
CREATE TABLE [dbo].[tYSYF_BadAccountKm<<YEAR>>] (
	[kmdm] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[kmmc] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[kmType] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tYSYF_BillType]    Script Date: 2003-5-30 15:30:12 ******/
CREATE TABLE [TYSYF_BILLTYPE] (
	[CCODE] [char] (6) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CNAME] [char] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CNUMBER] [numeric](38, 0) NOT NULL ,
	[CYEAR] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ISDQR] [smallint]  default 0 NOT NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tYSYF_Pzsj<<YEAR>>]    Script Date: 2003-5-30 15:30:12 ******/
CREATE TABLE [dbo].[tYSYF_Pzsj<<YEAR>>] (
	[cKind] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[dDate] [datetime] NOT NULL ,
	[AccessoryNum] [smallint] NULL ,
	[cYsyfId] [varchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cBrief] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[cJDPZ] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cKmdm] [char] (18) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[JE] [decimal](15, 2) NULL ,
	[SL] [decimal](15, 4) NULL ,
	[WB] [decimal](15, 2) NULL ,
	[cZDName] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[cSHName] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[cBillType] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[cBillCode] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[cXmdm] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[cBmdm] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[cWorkCode] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[cCusCode] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[cVenCode] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[HxFlag] [smallint] NULL ,
	[HL] [decimal](15, 8) NULL ,
	[cPersonCode] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[cBillDate] [datetime] NULL ,
	[cPZCode] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cKmmc] [char] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[recordCode] [smallint] NOT NULL ,
	[kjqj] [int] NOT NULL ,
	[modifyFlag] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[HxDate] [datetime] NULL ,
	[cMaturity] [datetime] NULL ,
	[QcFlag] [smallint] NULL ,
        [MATURITY] [datetime]
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tYsYf_FZ<<YEAR>>]    Script Date: 2003-5-30 15:30:13 ******/
CREATE TABLE [dbo].[tYsYf_FZ<<YEAR>>] (
	[ID] [int] NOT NULL ,
	[kmdm] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Grwl_Code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Khwl_Code] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[Gyswl_Code] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[bmdm] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[xmdm] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[ljjsl00] [decimal](15, 3) default 0 not null ,
	[ljjwb00] [decimal](15, 2) default 0 not null ,
	[ljj00] [decimal](15, 2) default 0 not null ,
	[ljdsl00] [decimal](15, 3) default 0 not null ,
	[ljdwb00] [decimal](15, 2) default 0 not null ,
	[ljd00] [decimal](15, 2) default 0 not null ,
	[ljjsl01] [decimal](15, 3) default 0 not null ,
	[ljjwb01] [decimal](15, 2) default 0 not null ,
	[ljj01] [decimal](15, 2) default 0 not null ,
	[ljdsl01] [decimal](15, 3) default 0 not null ,
	[ljdwb01] [decimal](15, 2) default 0 not null ,
	[ljd01] [decimal](15, 2) default 0 not null ,
	[ljjsl02] [decimal](15, 3) default 0 not null ,
	[ljjwb02] [decimal](15, 2) default 0 not null ,
	[ljj02] [decimal](15, 2) default 0 not null ,
	[ljdsl02] [decimal](15, 3) default 0 not null ,
	[ljdwb02] [decimal](15, 2) default 0 not null ,
	[ljd02] [decimal](15, 2) default 0 not null ,
	[ljjsl03] [decimal](15, 3) default 0 not null ,
	[ljjwb03] [decimal](15, 2) default 0 not null ,
	[ljj03] [decimal](15, 2) default 0 not null ,
	[ljdsl03] [decimal](15, 3) default 0 not null ,
	[ljdwb03] [decimal](15, 2) default 0 not null ,
	[ljd03] [decimal](15, 2) default 0 not null ,
	[ljjsl04] [decimal](15, 3) default 0 not null ,
	[ljjwb04] [decimal](15, 2) default 0 not null ,
	[ljj04] [decimal](15, 2) default 0 not null ,
	[ljdsl04] [decimal](15, 3) default 0 not null ,
	[ljdwb04] [decimal](15, 2) default 0 not null ,
	[ljd04] [decimal](15, 2) default 0 not null ,
	[ljjsl05] [decimal](15, 3) default 0 not null ,
	[ljjwb05] [decimal](15, 2) default 0 not null ,
	[ljj05] [decimal](15, 2) default 0 not null ,
	[ljdsl05] [decimal](15, 3) default 0 not null ,
	[ljdwb05] [decimal](15, 2) default 0 not null ,
	[ljd05] [decimal](15, 2) default 0 not null ,
	[ljjsl06] [decimal](15, 3) default 0 not null ,
	[ljjwb06] [decimal](15, 2) default 0 not null ,
	[ljj06] [decimal](15, 2) default 0 not null ,
	[ljdsl06] [decimal](15, 3) default 0 not null ,
	[ljdwb06] [decimal](15, 2) default 0 not null ,
	[ljd06] [decimal](15, 2) default 0 not null ,
	[ljjsl07] [decimal](15, 3) default 0 not null ,
	[ljjwb07] [decimal](15, 2) default 0 not null ,
	[ljj07] [decimal](15, 2) default 0 not null ,
	[ljdsl07] [decimal](15, 3) default 0 not null ,
	[ljdwb07] [decimal](15, 2) default 0 not null ,
	[ljd07] [decimal](15, 2) default 0 not null ,
	[ljjsl08] [decimal](15, 3) default 0 not null ,
	[ljjwb08] [decimal](15, 2) default 0 not null ,
	[ljj08] [decimal](15, 2) default 0 not null ,
	[ljdsl08] [decimal](15, 3) default 0 not null ,
	[ljdwb08] [decimal](15, 2) default 0 not null ,
	[ljd08] [decimal](15, 2) default 0 not null ,
	[ljjsl09] [decimal](15, 3) default 0 not null ,
	[ljjwb09] [decimal](15, 2) default 0 not null ,
	[ljj09] [decimal](15, 2) default 0 not null ,
	[ljdsl09] [decimal](15, 3) default 0 not null ,
	[ljdwb09] [decimal](15, 2) default 0 not null ,
	[ljd09] [decimal](15, 2) default 0 not null ,
	[ljjsl10] [decimal](15, 3) default 0 not null ,
	[ljjwb10] [decimal](15, 2) default 0 not null ,
	[ljj10] [decimal](15, 2) default 0 not null ,
	[ljdsl10] [decimal](15, 3) default 0 not null ,
	[ljdwb10] [decimal](15, 2) default 0 not null ,
	[ljd10] [decimal](15, 2) default 0 not null ,
	[ljjsl11] [decimal](15, 3) default 0 not null ,
	[ljjwb11] [decimal](15, 2) default 0 not null ,
	[ljj11] [decimal](15, 2) default 0 not null ,
	[ljdsl11] [decimal](15, 3) default 0 not null ,
	[ljdwb11] [decimal](15, 2) default 0 not null ,
	[ljd11] [decimal](15, 2) default 0 not null ,
	[ljjsl12] [decimal](15, 3) default 0 not null ,
	[ljjwb12] [decimal](15, 2) default 0 not null ,
	[ljj12] [decimal](15, 2) default 0 not null ,
	[ljdsl12] [decimal](15, 3) default 0 not null ,
	[ljdwb12] [decimal](15, 2) default 0 not null ,
	[ljd12] [decimal](15, 2) default 0 not null 
) ON [PRIMARY]
;
ALTER TABLE dbo.tYsYf_FZ<<YEAR>> ADD CONSTRAINT
	PK_tYsYf_FZ<<YEAR>> PRIMARY KEY CLUSTERED 
	(
	ID
	) ON [PRIMARY]
;
ALTER TABLE dbo.tYSYF_Pzsj<<YEAR>> ADD CONSTRAINT
	PK_tYSYF_Pzsj<<YEAR>> PRIMARY KEY CLUSTERED 
	(
	cKind,
    kjqj, 
	cPZCode,
	recordCode,
	cYsyfId	
	) ON [PRIMARY]
;
ALTER TABLE [dbo].[tYSYF_Pzsj<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF__tYSYF_Pzsj20__JE__1446FBA6] DEFAULT (0) FOR [JE],
	CONSTRAINT [DF__tYSYF_Pzsj20__SL__153B1FDF] DEFAULT (0) FOR [SL],
	CONSTRAINT [DF__tYSYF_Pzsj20__WB__162F4418] DEFAULT (0) FOR [WB],
	CONSTRAINT [DF__tYSYF_Pzs__HxFla__17236851] DEFAULT (0) FOR [HxFlag],
	CONSTRAINT [DF__tYSYF_Pzs__modif__18178C8A] DEFAULT (' ') FOR [modifyFlag],
	CONSTRAINT [DF__tYSYF_Pzs__QcFla__190BB0C3] DEFAULT (0) FOR [QcFlag]
;