📄 zw.sql
字号:
[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 + -