📄 zw.sql

📁 一个用VB写的财务软件源码
💻 SQL
📖 第 1 页 / 共 2 页
字号:
12 下一页
/****** Object:  Table [dbo].[TZW_BUDGET<<YEAR>>]    Script Date: 2003-5-30 15:31:34 ******/
CREATE TABLE [dbo].[TZW_BUDGET<<YEAR>>] (
	[ID] [smallint] NOT NULL ,
	[KMDM] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ITEMCLASS] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[ITEM] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[BMDM] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[GRDM] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[GYSDM] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[KHDM] [char] (12) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[TZW_BUDGETCONTROL<<YEAR>>]    Script Date: 2003-5-30 15:31:35 ******/
CREATE TABLE [dbo].[TZW_BUDGETCONTROL<<YEAR>>] (
	[ID] [smallint] NOT NULL ,
	[CONTROLFLAG] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[CONTROLFORMULA] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[ALERTFLAG] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[ALERTFORMULA] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[TZW_PLAN<<YEAR>>]    Script Date: 2003-5-30 15:31:35 ******/
CREATE TABLE [dbo].[TZW_PLAN<<YEAR>>] (
	[ID] [smallint] NOT NULL ,
	[BSELE] [smallint] NULL ,
	[DLMONPLAN1] [decimal](15, 2) NULL ,
	[DLMONPLUS1] [decimal](15, 2) NULL ,
	[DLMONPLAN2] [decimal](15, 2) NULL ,
	[DLMONPLUS2] [decimal](15, 2) NULL ,
	[DLMONPLAN3] [decimal](15, 2) NULL ,
	[DLMONPLUS3] [decimal](15, 2) NULL ,
	[DLMONPLAN4] [decimal](15, 2) NULL ,
	[DLMONPLUS4] [decimal](15, 2) NULL ,
	[DLMONPLAN5] [decimal](15, 2) NULL ,
	[DLMONPLUS5] [decimal](15, 2) NULL ,
	[DLMONPLAN6] [decimal](15, 2) NULL ,
	[DLMONPLUS6] [decimal](15, 2) NULL ,
	[DLMONPLAN7] [decimal](15, 2) NULL ,
	[DLMONPLUS7] [decimal](15, 2) NULL ,
	[DLMONPLAN8] [decimal](15, 2) NULL ,
	[DLMONPLUS8] [decimal](15, 2) NULL ,
	[DLMONPLAN9] [decimal](15, 2) NULL ,
	[DLMONPLUS9] [decimal](15, 2) NULL ,
	[DLMONPLAN10] [decimal](15, 2) NULL ,
	[DLMONPLUS10] [decimal](15, 2) NULL ,
	[DLMONPLAN11] [decimal](15, 2) NULL ,
	[DLMONPLUS11] [decimal](15, 2) NULL ,
	[DLMONPLAN12] [decimal](15, 2) NULL ,
	[DLMONPLUS12] [decimal](15, 2) NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[TZW_PLUS<<YEAR>>]    Script Date: 2003-5-30 15:31:35 ******/
CREATE TABLE [dbo].[TZW_PLUS<<YEAR>>] (
	[ID] [smallint] NOT NULL ,
	[IACCOUNTPERIOD] [smallint] NULL ,
	[DMAKEDATE] [datetime] NOT NULL ,
	[CSUMMARY] [varchar] (60) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[DEPLUS] [decimal](15, 2) NULL ,
	[ISTATE] [smallint] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tZW_AccountAge<<YEAR>>]    Script Date: 2003-5-30 15:31:35 ******/
CREATE TABLE [dbo].[tZW_AccountAge<<YEAR>>] (
	[cCode] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[iNum] [int] NULL ,
	[iLength] [int] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tZW_BadAccountAge<<YEAR>>]    Script Date: 2003-5-30 15:31:36 ******/
CREATE TABLE [dbo].[tZW_BadAccountAge<<YEAR>>] (
	[cCode] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[iNum] [int] NULL ,
	[iLength] [int] NULL ,
	[iRate] [decimal](18, 4) NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tZW_Check<<YEAR>>]    Script Date: 2003-5-30 15:31:36 ******/
CREATE TABLE [dbo].[tZW_Check<<YEAR>>] (
	[kmdm] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[checkNo] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[usedate] [datetime] NULL ,
	[DepartCode] [varchar] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[PersonCode] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[money] [decimal](15, 2) NULL ,
	[usertext] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[outdate] [datetime] NULL ,
	[text] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tZW_Customer<<YEAR>>]    Script Date: 2003-5-30 15:31:36 ******/
CREATE TABLE [dbo].[tZW_Customer<<YEAR>>] (
	[cCusCode] [char] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cCusName] [char] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[cCusAbbName] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[cCCCode] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[cCDCode] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[cCusHeadCode] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[cTrade] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[cCusRegCode] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ,
	[cCusLPerson] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[cCusBank] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[cCusAccount] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[cCusAddress] [char] (80) COLLATE Chinese_PRC_CI_AS NULL ,
	[cCusPostCode] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[cCusPerson] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[cCusEmail] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[cCusPhone] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[cCusFax] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[cCusBP] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[cCusHand] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[cCusOAddress] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[cCusOType] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[cCusWhCode] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[iARmoney] [decimal](9, 2) NULL ,
	[iCusDisRate] [decimal](9, 2) NULL ,
	[cCusCreGrade] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[iCusCreLine] [decimal](9, 1) NULL ,
	[iCusCreDate] [decimal](9, 1) NULL ,
	[cCusPayCond] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[dLastDate] [datetime] NULL ,
	[iLastmoney] [decimal](9, 2) NULL ,
	[dLRDate] [datetime] NULL ,
	[iLRmoney] [decimal](9, 2) NULL ,
	[cCusDepart] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[cCusPPerson] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[dCusDevDate] [datetime] NULL ,
	[dEndDate] [datetime] NULL ,
	[iFrequency] [int] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tZW_CustomerClass<<YEAR>>]    Script Date: 2003-5-30 15:31:36 ******/
CREATE TABLE [dbo].[tZW_CustomerClass<<YEAR>>] (
	[cCCCode] [char] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cCCName] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[iCCGrade] [int] NULL ,
	[bCCEnd] [smallint] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tZW_CustomerShowSet<<YEAR>>]    Script Date: 2003-5-30 15:31:36 ******/
CREATE TABLE [dbo].[tZW_CustomerShowSet<<YEAR>>] (
	[ID] [int] NOT 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_Exch<<YEAR>>]    Script Date: 2003-5-30 15:31:36 ******/
CREATE TABLE [dbo].[tZW_Exch<<YEAR>>] (
	[cExch_Name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[iPeriod] [smallint] NOT NULL ,
	[iType] [smallint] NULL ,
	[cDate] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[nFlat_HL] [decimal](15, 8) NULL ,
	[nFlat_TZ] [decimal](15, 8) NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tZW_ForeignCurrency<<YEAR>>]    Script Date: 2003-5-30 15:31:36 ******/
CREATE TABLE [dbo].[tZW_ForeignCurrency<<YEAR>>] (
	[cExch_Name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[bCAL] [smallint] NULL ,
	[iDEC] [smallint] NULL ,
	[mERROR] [decimal](9, 8) NULL ,
	[OtherUse] [smallint] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tZW_Item<<YEAR>>]    Script Date: 2003-5-30 15:31:37 ******/
CREATE TABLE [dbo].[tZW_Item<<YEAR>>] (
	[cCode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cName] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[cDirect] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[bCash] [smallint] NULL ,
	[cClsCode] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[bCarry] [smallint] NULL ,
	[bUse] [smallint] NULL ,
	[dBudget] [decimal](15, 2) NULL ,
	[bOver] [smallint] NULL ,
	[dOverDate] [varchar] (12) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tZW_ItemClass<<YEAR>>]    Script Date: 2003-5-30 15:31:37 ******/
CREATE TABLE [dbo].[tZW_ItemClass<<YEAR>>] (
	[cClsCode] [char] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cClsName] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[iGrade] [int] NULL ,
	[bUse] [smallint] NULL, 
    [nType] [smallint] NOT NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tZW_Jsfs<<YEAR>>]    Script Date: 2003-5-30 15:31:37 ******/
CREATE TABLE [dbo].[tZW_Jsfs<<YEAR>>] (
	[cCode] [char] (3) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cName] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[bFlag] [smallint] NULL ,
	[iGrade] [smallint] NULL ,
	[bEnd] [smallint] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tZW_Pzsj<<YEAR>>]    Script Date: 2003-5-30 15:31:37 ******/
CREATE TABLE [dbo].[tZW_Pzsj<<YEAR>>] (
	[id] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[kjqj] [smallint] NOT NULL ,
	[pzzl] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[pzbh] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[jlhm] [smallint] NOT NULL ,
	[pzrq] [datetime] NULL ,
	[fjzs] [smallint] NULL ,
	[zdrmCode] [varchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[zdrm] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[fhrmCode] [varchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[fhrm] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[zgrmCode] [varchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[zgrm] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[xgbz] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[bSpecial] [smallint] NULL ,
	[bCashFlow] [smallint] NULL ,
	[bSplitRec] [smallint] NULL ,
	[pzzy] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[kmdm] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[kmmc] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[fx] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[je] [decimal](15, 2) NULL ,
	[sl] [decimal](15, 4) NULL ,
	[dj] [decimal](15, 2) NULL ,
	[wb] [decimal](15, 2) NULL ,
	[hl] [decimal](15, 8) NULL ,
	[bz] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[yhdz_jsfsCode] [char] (3) COLLATE Chinese_PRC_CI_AS NULL ,
	[yhdz_jsfs] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[yhdz_Bill] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[yhdz_Date] [datetime] NULL ,
	[yhdz_lqbz] [smallint] NULL ,
	[yhdz_hxbz] [smallint] NULL ,
	[yhdz_id] [int] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tZW_TempletDetail<<YEAR>>]    Script Date: 2003-5-30 15:31:37 ******/
CREATE TABLE [dbo].[tZW_TempletDetail<<YEAR>>] (
	[cCode] [char] (3) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Jlhm] [smallint] NOT NULL ,
	[pzzy] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[kmdm] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[kmmc] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[fx] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[je] [decimal](15, 2) NULL ,
	[sl] [decimal](15, 4) NULL ,
	[dj] [decimal](15, 2) NULL ,
	[wb] [decimal](15, 2) NULL ,
	[hl] [decimal](15, 8) NULL ,
	[yhdz_jsfsCode] [char] (3) COLLATE Chinese_PRC_CI_AS NULL ,
	[yhdz_jsfs] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[yhdz_Bill] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[yhdz_Date] [datetime] NULL ,
	[yhdz_lqbz] [smallint] NULL ,
	[yhdz_hxbz] [smallint] NULL ,
	[yhdz_id] [int] NULL ,
	[Grwl_Code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Grwl_Name] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Grwl_Bill] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[Grwl_Date] [datetime] NULL ,
	[Grwl_Lqflg] [smallint] NULL ,
	[Grwl_Qcflg] [smallint] NULL ,
	[Khwl_Code] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[Khwl_Name] [char] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[Khwl_Bill] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[Khwl_Date] [datetime] NULL ,
	[Khwl_CBDcode] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Khwl_CBDname] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Khwl_Lqflg] [smallint] NULL ,
	[Khwl_Qcflg] [smallint] NULL ,
	[Gyswl_Code] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[Gyswl_Name] [char] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[Gyswl_Bill] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[Gyswl_Date] [datetime] NULL ,
	[Gyswl_CBDcode] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Gyswl_CBDname] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Gyswl_Lqflg] [smallint] NULL ,
	[Gyswl_Qcflg] [smallint] NULL ,
	[bmdm] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[bmmc] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[xmdm] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[xmmc] [char] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tZW_TempletMain<<YEAR>>]    Script Date: 2003-5-30 15:31:38 ******/
CREATE TABLE [dbo].[tZW_TempletMain<<YEAR>>] (
	[cCode] [char] (3) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcComment] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[cPzzl] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[tiFjzs] [smallint] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tZW_Type<<YEAR>>]    Script Date: 2003-5-30 15:31:38 ******/
CREATE TABLE [dbo].[tZW_Type<<YEAR>>] (
	[signID] [smallint] NOT NULL ,
	[sign] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[signtext] [char] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[jfbykm] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[jfbwkm] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[dfbykm] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[dfbwkm] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[pzbykm] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[pzbwkm] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[OtherUse] [smallint] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tZW_Vendor<<YEAR>>]    Script Date: 2003-5-30 15:31:38 ******/
CREATE TABLE [dbo].[tZW_Vendor<<YEAR>>] (
	[cVenCode] [char] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cVenName] [char] (60) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cVenAbbName] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[cVCCode] [char] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cDCCode] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[cVenHeadCode] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[cTrade] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[cVenRegCode] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ,
	[cVenLPerson] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[cVenBank] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[cVenAccount] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[cVenAddress] [char] (80) COLLATE Chinese_PRC_CI_AS NULL ,
	[cVenPostCode] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[cVenPerson] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[cVenPhone] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[cVenFax] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[cVenEmail] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[cVenBP] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[cVenHand] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[cVenIAddress] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[cVenIType] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[cVenWhCode] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[iARmoney] [decimal](9, 2) NULL ,
	[iVenDisRate] [decimal](5, 2) NULL ,
	[cVenCreGrade] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[cVenPayCond] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[iVenCreLine] [decimal](9, 2) NULL ,
	[iVenCreDate] [decimal](9, 2) NULL ,
	[dLastDate] [datetime] NULL ,
	[iLastmoney] [decimal](9, 2) NULL ,
	[dLRDate] [datetime] NULL ,
	[iLRmoney] [decimal](9, 2) NULL ,
	[bVenTax] [smallint] NULL ,
	[cVenDepart] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[cVenPPerson] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[dVenDevDate] [datetime] NULL ,
	[dEndDate] [datetime] NULL ,
	[iFrequency] [int] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tZW_VendorClass<<YEAR>>]    Script Date: 2003-5-30 15:31:38 ******/
CREATE TABLE [dbo].[tZW_VendorClass<<YEAR>>] (
	[cVCCode] [char] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
12 下一页
⌨️ 快捷键说明

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