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

📄 zw.sql

📁 一个用VB写的财务软件源码
💻 SQL
📖 第 1 页 / 共 2 页
字号:
	[cVCName] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[iVCGrade] [int] NULL ,
	[bVCEnd] [smallint] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tZW_VendorShowSet<<YEAR>>]    Script Date: 2003-5-30 15:31:38 ******/
CREATE TABLE [dbo].[tZW_VendorShowSet<<YEAR>>] (
	[ID] [int] NULL ,
	[Field] [char] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Detials] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Show] [smallint] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tZW_Yhdzd<<YEAR>>]    Script Date: 2003-5-30 15:31:38 ******/
CREATE TABLE [dbo].[tZW_Yhdzd<<YEAR>>] (
	[ID] [int] NOT NULL ,
	[rq] [datetime] NULL ,
	[kmdm] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[JsfsCode] [char] (3) COLLATE Chinese_PRC_CI_AS NULL ,
	[jsfsName] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[bill] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[fx] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[je] [decimal](15, 2) NULL ,
	[lqbz] [smallint] NULL ,
	[qcbz] [smallint] NULL ,
	[hxbz] [smallint] NULL ,
	[zy] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tZW_Yhdzqyrq]    Script Date: 2003-5-30 15:31:39 ******/
CREATE TABLE [dbo].[tZW_Yhdzqyrq] (
	[kmdm] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[qyrq] [datetime] NOT NULL ,
	[jzrq] [datetime] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tZW_Zywh]    Script Date: 2003-5-30 15:31:39 ******/
CREATE TABLE [dbo].[tZW_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]
;

/****** Object:  Table [dbo].[tZW_Zzhdset<<YEAR>>]    Script Date: 2003-5-30 15:31:39 ******/
CREATE TABLE [dbo].[tZW_Zzhdset<<YEAR>>] (
	[ID] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Pzlb] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[sykmdm] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[sykmmc] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[sskmdm] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[sskmmc] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[zy] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[thzq] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[schdrq] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[jlfl] [smallint] NOT NULL ,
	[kmdm] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[kmmc] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Fx] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[bz] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tZW_ZzpzSet<<YEAR>>]    Script Date: 2003-5-30 15:31:39 ******/
CREATE TABLE [dbo].[tZW_ZzpzSet<<YEAR>>] (
	[ID] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[siJlhm] [smallint] NOT NULL ,
	[cPzlb] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cZzsm] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cKmdm] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
        [Bmdm] [varchar] (12) NULL,
        [Bmmc] [varchar] (20) NULL,
	[Xmdm] [varchar] (30) NULL,
	[Xmmc] [varchar] (50) NULL,
	[cFx] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cJegs] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cZy] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[zzrq] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[cPzType] [varchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

ALTER TABLE [dbo].[TZW_BUDGET<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [PK_ZW_tZW_BUDGET<<YEAR>>] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TZW_BUDGETCONTROL<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF__TZW_BUDGE__CONTR__0F2D40CE] DEFAULT ('0') FOR [CONTROLFLAG],
	CONSTRAINT [DF__TZW_BUDGE__ALERT__10216507] DEFAULT ('0') FOR [ALERTFLAG],
	CONSTRAINT [PK_ZW_tZW_BUDGETCONTROL<<YEAR>>] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TZW_PLAN<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF__TZW_PLAN2__BSELE__13F1F5EB] DEFAULT (0) FOR [BSELE],
	CONSTRAINT [DF__TZW_PLAN2__DLMON__14E61A24] DEFAULT (0) FOR [DLMONPLAN1],
	CONSTRAINT [DF__TZW_PLAN2__DLMON__15DA3E5D] DEFAULT (0) FOR [DLMONPLUS1],
	CONSTRAINT [DF__TZW_PLAN2__DLMON__16CE6296] DEFAULT (0) FOR [DLMONPLAN2],
	CONSTRAINT [DF__TZW_PLAN2__DLMON__17C286CF] DEFAULT (0) FOR [DLMONPLUS2],
	CONSTRAINT [DF__TZW_PLAN2__DLMON__18B6AB08] DEFAULT (0) FOR [DLMONPLAN3],
	CONSTRAINT [DF__TZW_PLAN2__DLMON__19AACF41] DEFAULT (0) FOR [DLMONPLUS3],
	CONSTRAINT [DF__TZW_PLAN2__DLMON__1A9EF37A] DEFAULT (0) FOR [DLMONPLAN4],
	CONSTRAINT [DF__TZW_PLAN2__DLMON__1B9317B3] DEFAULT (0) FOR [DLMONPLUS4],
	CONSTRAINT [DF__TZW_PLAN2__DLMON__1C873BEC] DEFAULT (0) FOR [DLMONPLAN5],
	CONSTRAINT [DF__TZW_PLAN2__DLMON__1D7B6025] DEFAULT (0) FOR [DLMONPLUS5],
	CONSTRAINT [DF__TZW_PLAN2__DLMON__1E6F845E] DEFAULT (0) FOR [DLMONPLAN6],
	CONSTRAINT [DF__TZW_PLAN2__DLMON__1F63A897] DEFAULT (0) FOR [DLMONPLUS6],
	CONSTRAINT [DF__TZW_PLAN2__DLMON__2057CCD0] DEFAULT (0) FOR [DLMONPLAN7],
	CONSTRAINT [DF__TZW_PLAN2__DLMON__214BF109] DEFAULT (0) FOR [DLMONPLUS7],
	CONSTRAINT [DF__TZW_PLAN2__DLMON__22401542] DEFAULT (0) FOR [DLMONPLAN8],
	CONSTRAINT [DF__TZW_PLAN2__DLMON__2334397B] DEFAULT (0) FOR [DLMONPLUS8],
	CONSTRAINT [DF__TZW_PLAN2__DLMON__24285DB4] DEFAULT (0) FOR [DLMONPLAN9],
	CONSTRAINT [DF__TZW_PLAN2__DLMON__251C81ED] DEFAULT (0) FOR [DLMONPLUS9],
	CONSTRAINT [DF__TZW_PLAN2__DLMON__2610A626] DEFAULT (0) FOR [DLMONPLAN10],
	CONSTRAINT [DF__TZW_PLAN2__DLMON__2704CA5F] DEFAULT (0) FOR [DLMONPLUS10],
	CONSTRAINT [DF__TZW_PLAN2__DLMON__27F8EE98] DEFAULT (0) FOR [DLMONPLAN11],
	CONSTRAINT [DF__TZW_PLAN2__DLMON__28ED12D1] DEFAULT (0) FOR [DLMONPLUS11],
	CONSTRAINT [DF__TZW_PLAN2__DLMON__29E1370A] DEFAULT (0) FOR [DLMONPLAN12],
	CONSTRAINT [DF__TZW_PLAN2__DLMON__2AD55B43] DEFAULT (0) FOR [DLMONPLUS12],
	 PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TZW_PLUS<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF__TZW_PLUS2__IACCO__2DB1C7EE] DEFAULT (1) FOR [IACCOUNTPERIOD],
	CONSTRAINT [DF__TZW_PLUS2__DEPLU__2EA5EC27] DEFAULT (0) FOR [DEPLUS],
	CONSTRAINT [DF__TZW_PLUS2__ISTAT__2F9A1060] DEFAULT (0) FOR [ISTATE],
	 PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tZW_Check<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF__tZW_Check__money__3E1D39E1] DEFAULT (0) FOR [money],
	CONSTRAINT [PK_ZW_Check<<YEAR>>] PRIMARY KEY  NONCLUSTERED 
	(
		[kmdm],
		[checkNo]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tZW_Customer<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF__tZW_Custo__iCusD__41EDCAC5] DEFAULT (0) FOR [iCusDisRate],
	CONSTRAINT [DF__tZW_Custo__iLRmo__42E1EEFE] DEFAULT (0) FOR [iLRmoney],
	 PRIMARY KEY  CLUSTERED 
	(
		[cCusCode]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tZW_CustomerClass<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF__tZW_Custo__bCCEn__45BE5BA9] DEFAULT (0) FOR [bCCEnd],
	 PRIMARY KEY  CLUSTERED 
	(
		[cCCCode]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tZW_CustomerShowSet<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF__tZW_Custom__Show__47A6A41B] DEFAULT (0) FOR [Show]
;

ALTER TABLE [dbo].[tZW_Exch<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF__tZW_Exch2__iType__498EEC8D] DEFAULT (0) FOR [iType],
	CONSTRAINT [PK_ZW_Exch<<YEAR>>] PRIMARY KEY  NONCLUSTERED 
	(
		[cExch_Name],
		[iPeriod]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tZW_ForeignCurrency<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF__tZW_Foreig__bCAL__4D5F7D71] DEFAULT (0) FOR [bCAL],
	CONSTRAINT [DF__tZW_Foreig__iDEC__4E53A1AA] DEFAULT (4) FOR [iDEC],
	CONSTRAINT [DF__tZW_Forei__mERRO__4F47C5E3] DEFAULT (0.0001) FOR [mERROR],
	CONSTRAINT [DF__tZW_Forei__Other__503BEA1C] DEFAULT (0) FOR [OtherUse],
	 PRIMARY KEY  CLUSTERED 
	(
		[cExch_Name]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tZW_Item<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF__tZW_Item2__bCash__531856C7] DEFAULT (0) FOR [bCash],
	CONSTRAINT [DF__tZW_Item2__bCarr__540C7B00] DEFAULT (0) FOR [bCarry],
	CONSTRAINT [DF__tZW_Item20__bUse__55009F39] DEFAULT (0) FOR [bUse],
	CONSTRAINT [DF__tZW_Item2__dBudg__55F4C372] DEFAULT (0) FOR [dBudget],
	CONSTRAINT [DF__tZW_Item2__bOver__56E8E7AB] DEFAULT (0) FOR [bOver],
	 PRIMARY KEY  CLUSTERED 
	(
		[cCode]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tZW_ItemClass<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF__tZW_ItemCl__bUse__59C55456] DEFAULT (0) FOR [bUse],
    CONSTRAINT [DF__tZW_ItemCl__nType__59C55457] DEFAULT (0) FOR [nType],
	 PRIMARY KEY  CLUSTERED 
	(
		[cClsCode]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tZW_Jsfs<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF__tZW_Jsfs2__bFlag__5CA1C101] DEFAULT (0) FOR [bFlag],
	CONSTRAINT [DF__tZW_Jsfs20__bEnd__5D95E53A] DEFAULT (0) FOR [bEnd],
	 PRIMARY KEY  CLUSTERED 
	(
		[cCode]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tZW_Pzsj<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF__tZW_Pzsj20__fjzs__5F7E2DAC] DEFAULT (0) FOR [fjzs],
	CONSTRAINT [DF__tZW_Pzsj2__bSpec__607251E5] DEFAULT (0) FOR [bSpecial],
	CONSTRAINT [DF__tZW_Pzsj2__bCash__6166761E] DEFAULT (0) FOR [bCashFlow],
	CONSTRAINT [DF__tZW_Pzsj2__bSpli__625A9A57] DEFAULT (0) FOR [bSplitRec],
	CONSTRAINT [DF__tZW_Pzsj<<YEAR>>__je__634EBE90] DEFAULT (0) FOR [je],
	CONSTRAINT [DF__tZW_Pzsj<<YEAR>>__sl__6442E2C9] DEFAULT (0) FOR [sl],
	CONSTRAINT [DF__tZW_Pzsj<<YEAR>>__dj__65370702] DEFAULT (0) FOR [dj],
	CONSTRAINT [DF__tZW_Pzsj<<YEAR>>__wb__662B2B3B] DEFAULT (0) FOR [wb],
	CONSTRAINT [DF__tZW_Pzsj2__yhdz___671F4F74] DEFAULT (0) FOR [yhdz_hxbz],
	CONSTRAINT [PK_ZW_Pzsj<<YEAR>>] PRIMARY KEY  NONCLUSTERED 
	(
		[kjqj],
		[pzzl],
		[pzbh],
		[jlhm]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tZW_TempletDetail<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF__tZW_TempletD__je__7E02B4CC] DEFAULT (0) FOR [je],
	CONSTRAINT [DF__tZW_TempletD__sl__7EF6D905] DEFAULT (0) FOR [sl],
	CONSTRAINT [DF__tZW_TempletD__dj__7FEAFD3E] DEFAULT (0) FOR [dj],
	CONSTRAINT [DF__tZW_TempletD__wb__00DF2177] DEFAULT (0) FOR [wb],
	CONSTRAINT [DF__tZW_Templ__yhdz___01D345B0] DEFAULT (0) FOR [yhdz_hxbz],
	CONSTRAINT [DF__tZW_Templ__Grwl___02C769E9] DEFAULT (0) FOR [Grwl_Qcflg],
	CONSTRAINT [DF__tZW_Templ__Khwl___03BB8E22] DEFAULT (0) FOR [Khwl_Qcflg],
	CONSTRAINT [DF__tZW_Templ__Gyswl__04AFB25B] DEFAULT (0) FOR [Gyswl_Qcflg],
	CONSTRAINT [PK_ZW_TempletDetail<<YEAR>>] PRIMARY KEY  NONCLUSTERED 
	(
		[cCode],
		[Jlhm]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tZW_TempletMain<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF__tZW_Templ__tiFjz__7C1A6C5A] DEFAULT (0) FOR [tiFjzs],
	 PRIMARY KEY  CLUSTERED 
	(
		[cCode]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tZW_Type<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF__tZW_Type2__Other__6AEFE058] DEFAULT (0) FOR [OtherUse],
	 PRIMARY KEY  CLUSTERED 
	(
		[signID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tZW_Vendor<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF__tZW_Vendo__bVenT__6DCC4D03] DEFAULT (0) FOR [bVenTax],
	 PRIMARY KEY  CLUSTERED 
	(
		[cVenCode]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tZW_VendorClass<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF__tZW_Vendo__bVCEn__70A8B9AE] DEFAULT (0) FOR [bVCEnd],
	 PRIMARY KEY  CLUSTERED 
	(
		[cVCCode]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tZW_VendorShowSet<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF__tZW_Vendor__Show__72910220] DEFAULT (0) FOR [Show]
;

ALTER TABLE [dbo].[tZW_Yhdzd<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF__tZW_Yhdzd2__hxbz__756D6ECB] DEFAULT (0) FOR [hxbz],
	 PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tZW_Yhdzqyrq] WITH NOCHECK ADD 
	 PRIMARY KEY  CLUSTERED 
	(
		[kmdm]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tZW_Zywh] WITH NOCHECK ADD 
	 PRIMARY KEY  CLUSTERED 
	(
		[DmID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tZW_Zzhdset<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [PK_ZW_tZW_Zzhdset<<YEAR>>] PRIMARY KEY  CLUSTERED 
	(
		[ID],
		[jlfl]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tZW_ZzpzSet<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [PK_ZW_ZzpzSet<<YEAR>>] PRIMARY KEY  CLUSTERED 
	(
		[cPzType],
		[ID],
		[siJlhm]
	)  ON [PRIMARY] 
;
insert into TZW_JSFS<<YEAR>> (CCODE, CNAME, BFLAG, IGRADE, BEND)
values ('01 ', '支票', 1, 1, 0);
insert into TZW_JSFS<<YEAR>> (CCODE, CNAME, BFLAG, IGRADE, BEND)
values ('011', '现金支票', 0, 2, -1);
insert into TZW_JSFS<<YEAR>> (CCODE, CNAME, BFLAG, IGRADE, BEND)
values ('012', '转账支票', 0, 2, -1);
insert into TZW_JSFS<<YEAR>> (CCODE, CNAME, BFLAG, IGRADE, BEND)
values ('02 ', '银行本票', -1, 1, -1);
insert into TZW_JSFS<<YEAR>> (CCODE, CNAME, BFLAG, IGRADE, BEND)
values ('03 ', '商业汇票', 1, 1, 0);
insert into TZW_JSFS<<YEAR>> (CCODE, CNAME, BFLAG, IGRADE, BEND)
values ('04 ', '银行汇票', -1, 1, -1);
insert into TZW_JSFS<<YEAR>> (CCODE, CNAME, BFLAG, IGRADE, BEND)
values ('031', '商业承兑汇票', -1, 2, -1);
insert into TZW_JSFS<<YEAR>> (CCODE, CNAME, BFLAG, IGRADE, BEND)
values ('032', '银行承兑汇票', -1, 2, -1);
insert into TZW_JSFS<<YEAR>> (CCODE, CNAME, BFLAG, IGRADE, BEND)
values ('05 ', '汇兑', 0, 1, 0);
insert into TZW_JSFS<<YEAR>> (CCODE, CNAME, BFLAG, IGRADE, BEND)
values ('051', '信汇', 0, 2, -1);
insert into TZW_JSFS<<YEAR>> (CCODE, CNAME, BFLAG, IGRADE, BEND)
values ('052', '电汇', 0, 2, -1);
insert into TZW_JSFS<<YEAR>> (CCODE, CNAME, BFLAG, IGRADE, BEND)
values ('06 ', '委托收款', 0, 1, 0);
insert into TZW_JSFS<<YEAR>> (CCODE, CNAME, BFLAG, IGRADE, BEND)
values ('061', '委收邮划', 0, 2, -1);
insert into TZW_JSFS<<YEAR>> (CCODE, CNAME, BFLAG, IGRADE, BEND)
values ('062', '委收电划', 0, 2, -1);
insert into TZW_JSFS<<YEAR>> (CCODE, CNAME, BFLAG, IGRADE, BEND)
values ('07 ', '托收承付', 0, 1, 0);
insert into TZW_JSFS<<YEAR>> (CCODE, CNAME, BFLAG, IGRADE, BEND)
values ('071', '托收邮划', 0, 2, -1);
insert into TZW_JSFS<<YEAR>> (CCODE, CNAME, BFLAG, IGRADE, BEND)
values ('072', '托收电划', 0, 2, -1);
insert into TZW_JSFS<<YEAR>> (CCODE, CNAME, BFLAG, IGRADE, BEND)
values ('08 ', '现金交款单', 0, 1, -1);

⌨️ 快捷键说明

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