速达SQL数据库表结构.docx

1、速达SQL数据库表结构速达 3000 及 3000ProVARCHAR(1)审核是否可同人 VARCHAR(1) 法人代表SAMEUSERLAWPERSONVARCHAR(20)数据库结构分析字段名中文描述字段类型/长度 是否为空说明ID顺序号INTEGER NOTP rimary ;Uniq ue;BILLID单据IDSMAL LINT NOTBILLTIME开单日期DATEGOODSID货品IDVARCHAR(20)AMOUNT数量DOUBLE P RECISIONP RICE单价DOUBLE P RECISIONRETURNTAG退货标志SMAL LINT帐套信息表表名：ACCINFO描

2、述:记录帐套的详细资料字段名中文描述字段类型/字段长度 是否为空说明COR PID公司IDSMALLINT NOTP rimary;U niqueTAXTYPE税务类型VARCHAR(1)STARTDATE启用日期DATECURRYEAR当前年份SMAL LINTCURRMON当前月份SMAL LINT表名：ABNORMALSALE描述:登帐是否审核MUSTCHECKBANK开户行VARCHAR(20)ACCOUNTS帐号VARCHAR(20)TAXNUMBER税号VARCHAR(20)BIND进销存财务捆绑VARCHAR(1)STE P0一级科目长度SMALLINTSTE P1二级科目长度S

3、MALLINTSTE P2三级科目长度SMALLINTSTEP3四级科目长度SMALLINTSTEP4五级科目长度SMALLINTSTEP5六级科目长度SMALLINTBACKU POP TIONSMALLINTDATELASTDATESTATUS启用状态SMAL LINTVERSION帐套版本号VARCHAR(4)MAXLOGRECOUNTSMALLINTMAXLOGDAYSMALLINTADDRESS地址VARCHAR(100)PH ONE电话VARCHAR(20)POSYEAR进销存年份SMALLINTPOSMON进销存月份SMALLINTP OSSTOREIDGUIDSMALLINT,

4、帐套唯一编号VARCHAR(40)表名：ACCOPTIONS字段名中文描述字段类型/字段长度是否为空OP TIONID顺序号SMALLINTNOT NULL,OP TIONNAME名称VARCHAR(20)NOT NULL,OP TIONVALUE值VARCHAR(20),MEMO备注VARCHAR(40)帐套选项表说明表名:ADJAP描述:记录调价的详细资料字段名中文描述字段类型/字段长度ADJA PID顺序号INTEGERNOTCODE单据编号VARCHAR(25)NOTBILLDATE单据日期DATEFLAG冲红标志INTEGERREFERBILLID冲红单IDINTEGEROPERAT

5、OR操作员VARCHAR(10)TOTALAMT总金额DOUBLE P RECISIONMEMO备注VARCHAR(40)UP DATETIME修改日期DATERP TID打印样式ID INTEGERSHOPID分支机构ID SMALLINTSFLAG传输标志SMALLINT调拨单表名：ALLOT描述:记录货品调拨的详细资料字段名中文描述字段类型/字段长度ALLOTID顺序号INTEGERNOTCODE单据号VARCHAR(25)NOTBILLDATE单据日期DATEFLAG冲红标志INTEGERREFERBILLID冲红单IDINTEGEROPERATOR操作员VARCHAR(10)OUTS

6、ID调出仓库号INTEGERNOTINSID调进仓库号INTEGERNOTTOTALAMT总金额DOUBLE P RECISIONMEMO备注VARCHAR(40)调价单是否为空是否为空说明P rimary ;Unique;说明P rimary;U nique;Un ique;UP DATETIME修改日期DATERP TID打印样式IDINTEGERSHOPID分支机构IDSMALLINTSFLAG传输标志SMALLINT地区资料表名：AREA描述:记录地区的详细资料字段名中文描述字段类型/字段长度AREAID地区IDINTEGERNOTLCODE地区编号VARCHAR(10)NOTNAME

7、地区名称VARCHAR(12)NOTUP FLAG发送标志ARCHAR(1)是否为空说明P rimary ;Unique;字段名中文描述字段类型/字段长度ID顺序号INTEGER NOTCODE编号VARCHAR(10) NOTNAME名称VARCHAR(40)SPECTYPE规格型号VARCHAR(20)ASSETT YP EID类别IDINTEGERDEP TID所属部门IDINTEGERINCRDECRID固定资产增加减少INTEGERLOCATION地址VARCHAR(60)USEDT YP EID使用方式INTEGERDEP RECIATEID折旧IDINTEGERSTARTDATE

8、入帐日期DATEWORKLOAD预计使用月份INTEGERUSEDAGOINTEGERUSEDALL已计使用月份INTEGERUNIT工作量单位VARCHAR(10)RAWVALUE入帐原值DOUBLE P RECISIONUSEDVALUE累计折旧DOUBLE P RECISIONUSEDVALUEAGODOUBLE P RECISIONREMAINRATE预计净残值率DOUBLE P RECISIONREMAINVALUE预计净残值DOUBLE P RECISIONDEPRRATE月折旧率DOUBLE P RECISIONDEPRVALUE月折旧额DOUBLE P RECISIONSUBI

9、D折旧科目VARCHAR(18)CLEARFLAG清除标志VARCHAR(1)INITFLAG初始化标志VARCHAR(1)CREDID凭证IDVARCHAR(10)固定资产卡片表名：ASSETCARD描述:企业固定资产详细资料是否为空说明P rimary ;Unique;固定资产类别表名：ASSETTYPE字段名 中文描述描述:固定资产类别的明细资料字段类型/字段长度 是否为空说明ID顺序号INTEGERNOTNAME 类别名称DEPRECIATEID 折旧 IDVARCHAR(20)SMALLINT,NOTP rimary;Un ique;REMAINRATE 预计净残值率DOUBLE P

10、 RECISION表名：ASTBALANCE 描述:字段名中文描述字段类型/字段长度YEARMON地区IDVARCHAR(6) NOID顺序号INTEGER NOTOTALWL总工作量INTEGERCURRWL本月工作量INTEGERUSEDVALUE累计折旧DOUBLE P RECISIONDEPRRATE月折旧率DOUBLE P RECISIONDEPRVALUE月折旧额DOUBLE P RECISIONBASTDEBIT（余额方向为借方)|期初余额DOUBLE P RECISIONYASTDEBIT（余额方向为借方)|本年借方余额DOUBLE P RECISIONYASTCREDIT（余

11、额方向为借方)|本年贷方余额DOUBLE P RECISIONASTDEBIT（余额方向为借方)|本期借方余额DOUBLE P RECISIONASTCREDIT（余额方向为借方)|本期贷方余额DOUBLE P RECISIONBDP RCREDIT（余额方向为贷方)|期初余额DOUBLE P RECISIONYDP RDEBIT（余额方向为贷方)|本年借方DOUBLE P RECISIONYDP RCREDIT（余额方向为贷方)|本年贷方DOUBLE P RECISIONDP RDEBIT（余额方向为贷方)|本期借方DOUBLE P RECISIONDP RCREDIT（余额方向为贷方)|本

12、期贷方DOUBLE P RECISION固定资产及累计折旧余额表是否为空说明Primary ;Primary ;固定资产清除表名：ASTCLEAR描述：记录被清除固定资产的详细资料字段名中文描述字段类型/字段长度 是否为空说明ID顺序号INTEGERNOTP rimary;CLEARDATE清除日期DATE,INCRDECRID增减IDINTEGER,EARING DOUBLE# 理收入P RECISION,PAYOUT清理费用DOUBLE P RECISION,MEMO标志VARCHAR(40)附属设备表表名:ATTACHAST字段名中文描述字段类型/字段长度 是否为空说明ID顺序号INTE

13、GERNOTP rimary;ITEMNO明细号INTEGERNOTP rimary;NAME名称VARCHAR(20),SPECTYPE规格VARCHAR(20),UNIT计量单位VARCHAR(10),AMOUNT数量DOUBLE P RECISION,ATTACHSUM金额DOUBLE P RECISION,STARTDATE使用日期DATE,MEMO备注VARCHAR(40)退货明细表（从表）表名：BACKDETAIL描述:记录所退货品的详细资料字段名中文描述字段类型/字段长度 是否为空说明BACKDRAWID主表IDINTEGER NOTP rimary;ITEMNO明细号SMALL

14、INT NOTGOODSID货品IDVARCHAR(20),QUANTITY数量DOUBLE P RECISION,AP RICE单价DOUBLE P RECISION退货单（主表）表名：BACKDRAW字段名中文描述字段类型/字段长度 是否为空说明BACKDRAWID单据IDINTEGER NOTP rimary;CODE单据号VARCHAR(25) NOTUn ique;BILLDATE单据日期DATE,FLAG冲红标志INTEGERREFERBILLID冲红单IDINTEGEROPERATOR操作员VARCHAR(10),BACKMANID退货员INTEGER,INSID退入仓库号INT

15、EGER,TOTALAMT总金额DOUBLE P RECISION,MEMO备注VARCHAR(40),UP DATETIME修改日期DATE,RP TID打印样式IDINTEGERSHOPID分支机构IDSMALLINTSFLAG传输标志SMALLINT表名:BALANCE描述字段名中文描述字段类型/字段长度 是否为空说明YEARMON年月份VARCHAR(6) NOT P rimaryMONEYID货币IDSMALLINTNOT NULL, Primary;SUBID会计科目VARCHAR(18)NOT NULL,RATE汇率DOUBLE P RECISION,年初借方原币金额YBRAWD

16、EBITDOUBLE P RECISION,BRAWDEBIT期初借方原币金额DOUBLE P RECISION,BRAWCREDIT期初贷方原币金额DOUBLE P RECISION,RAWDEBIT本期累计借方原币金额DOUBLE P RECISION,RAWCREDIT本期累计贷方原币金额DOUBLE P RECISION,ERAWDEBIT期末借方原币金额DOUBLE P RECISION,ERAWCREDIT期末贷方原币金额DOUBLE P RECISION,YRAWDEBIT本年借方原币金额DOUBLE P RECISION,YRAWCREDIT本年贷方原币金额DOUBLE P R

17、ECISION,YBDEBIT本年借方本位币金额DOUBLE P RECISION,YBCREDIT本年贷方本位币金额DOUBLE P RECISION,BDEBIT期初借方本位币金额DOUBLE P RECISION,BCREDIT期初贷方本位币金额DOUBLE P RECISION,DEBIT本期累计借方本位币金额DOUBLE P RECISION,CREDIT本期累计贷方本位币金额DOUBLE P RECISION,EDEBIT期末借方本位币金额DOUBLE P RECISION,ECREDIT期末贷方本位币金额DOUBLE P RECISION,YDEBIT本年借方本位币金额DOUBL

18、E P RECISION,YCREDIT本年贷方本位币金额DOUBLE P RECISION仓库盘点单（明细）表名：BALDETAIL字段名中文描述字段类型/字段长度BALITEMID盘点单IDINTEGER NOTITEMNO明细号SMALLINT NOTGOODSID货品IDVARCHAR(20),QUANTITY数量DOUBLE P RECISION,AP RICE单价DOUBLE P RECISION仓库盘点单表名：BALITEM字段名中文描述字段类型/字段长度BALITEMID盘点单IDINTEGER NOTCODE单据编号VARCHAR(25) NOTBILLDATE单据日期DAT

19、E,FLAG冲红标志INTEGERREFERBILLID冲红单IDINTEGERBALSID仓库IDINTEGEROPERATOR操作员VARCHAR(10),TOTALAMT总金额DOUBLE P RECISION,MEMO备注VARCHAR(40),UP DATETIME修改日期DATE,RP TID打印样式ID INTEGERSHOPID分支机构ID SMALLINTSFLAG传输标志SMALLINT是否为空是否为空说明P rimary;P rimary;说明P rimary;Un ique现金银行表名：BANK字段名中文描述BANKID银行编号NAME名称SUBID会计科目编号BANK

20、NAME银行全称BANKCODE银行帐户BALANCE开帐金额BALINIT存款余额FLAG存款类别UP FLAG发送标志基本资料查询（主表）表名：BCFIND字段类型/字段长度 是否为空SMALLINTNOTVARCHAR(20)VARCHAR(18),VARCHAR(40),VARCHAR(20),NOTDOUBLE P RECISION,DOUBLE P RECISION,VARCHAR(1),VARCHAR(1)说明P rimary;Un ique;字段名中文描述字段类型/字段长度 是否为空说明TABLEIDTABLECNAME表ID表中文名SMALLINTNOTP rimary;TA

21、BLENAME表英文名基本资料查询（从表）表名：BCFINDDETAIL字段名中文描述TABLEIDFIELDIDFIELDENAMEFIELDCNAMEFIELDT YPEISLOOKU PLOOKU PTBLNAMEVARCHAR(50),VARCHAR(20) NOT字段类型/字段长度是否为空说明表ID字段名IDSMALLINTSMAL LINTNOTNOTP rimary;Primary ；字段英文名字段中文名字段类型是否LookUpLookUp表名LOOKU PRESULTFIELDLOOKU PKEYFIELDVARCHAR(20)VARCHAR(40),SMALLINTVARCH

22、AR(1)VARCHAR(20),VARCHAR(20),VARCHAR(20)NOTNOTDEFAULT 0DEFAULT F,字段名中文描述字段类型/字段长度ID顺序号INTEGERNOTBILLDATE单据日期DATENOTBILLT YPE单据类型SMALLINTNOTBILLID单据IDINTEGERNOTBILLCODE单据编号VARCHAR(25)NOTITEMNO明细号INTEGERNOTGOODSID货品IDVARCHAR(20)NOT表名：BILLFLOWQUEUE（不用）是否为空 说明P rimary;说明ID顺序号INTEGERNOTP rimary;QUEUEINDE

23、X INTEGER NOT NULL,INQTY DOUBLE P RECISION,INP RICE DOUBLE P RECISION,OUTQTY DOUBLE P RECISION,OUT PRICE DOUBLE P RECISION,EQTY DOUBLE P RECISION,EP RICE DOUBLE P RECISION,STOREID INTEGER,CACULATEFLAG VARCHAR(I) NOT NULL,INOUTFLAG INTEGER,VALIDQUEUE VARCHAR(1)表名：BILLFLOWQUEUE_TMP（不用）字段名 中文描述 字段类型/字段

24、长度 是否为空BILLDATE DATE NOT NULL,BILLT YPE SMALLINT NOT NULL,BIL LID INTEGER NOT NULL,BILLCODE VARCHAR(25) NOT NULL,ITEMNO INTEGER NOT NULL,GOODSID VARCHAR(20) NOT NULL,QUEUEINDEX INTEGER NOT NULL,INQTY DOUBLE P RECISION,INP RICE DOUBLE P RECISION,OUTQTY DOUBLE P RECISION,OUT PRICE DOUBLE P RECISION,EQ

25、TY DOUBLE P RECISION,EP RICE DOUBLE P RECISION,STOREID INTEGER,CACULATEFLAG VARCHAR(1) NOT NULL,INOUTFLAG INTEGER表名：BILL PRINT描述:单据打印设置表字段名中文描述字段类型/字段BILLID单据类型SMALLINT NONAME单据名称VARCHAR(10)OLDNAME原单据名称VARCHAR(10)MASTNAME单据正标题VARCHAR(40)OLDMASTNAME原单据正标题VARCHAR(40)ROWHIGHT行高SMALLINTDETAILNAME单据副标题VARCHAR(40)OLDDETAILNAME原单据副标题VARCHAR(40)单据打印是否为空说明P rimary;Unique;MASTFONTNAME单据正标题字体名称VARCHAR (20)OLDMASTFONTNAME原单据正标题字体名称VARCHAR(20)MASTFONTSTYLE单据正标题字体字形VARCHAR(1)OLDMASTFONTSTYLE原单据正标题字体字形VARCHAR (1)MASTFONTSIZE单据正标题字体大小SMAL LINTOLDMASTFONTSIZE原单据正标题字体大小SMALLINT