速达3000及3000Pro数据库结构说明

速达3000及3000Pro数据库结构分析A10B13C21D11E5F3G8H0I14J0K1L4M7N0O6P15Q0R5S12T1U3V3W2X0Y0Z1帐套信息表表名:ACCINFO描述:记录帐套的详细资料字段名中文描述字段类型/字段长度是否为空说明CORPID公司IDSMALLINTNOTPrimary;Unique;TAXTYPE税务类型VARCHAR(1)STARTDATE启用日期DATECURRYEAR当前年份SMALLINTCURRMON当前月份SMALLINTMUSTCHECK登帐是否审核VARCHAR(1)SAMEUSER审核是否可同人VARCHAR(1)LAWPERSON法人代表VARCHAR(20)BANK开户行VARCHAR(20)ACCOUNTS帐号VARCHAR(20)TAXNUMBER税号VARCHAR(20)BIND进销存财务捆绑VARCHAR(1)STEP0一级科目长度SMALLINTSTEP1二级科目长度SMALLINTSTEP2三级科目长度SMALLINTSTEP3四级科目长度SMALLINTSTEP4五级科目长度SMALLINTSTEP5六级科目长度SMALLINTBACKUPOPTIONSMALLINTLASTDATEDATESTATUS启用状态SMALLINTVERSION帐套版本号VARCHAR(4)MAXLOGRECOUNTSMALLINTMAXLOGDAYSMALLINTADDRESS地址VARCHAR(100)PHONE电话VARCHAR(20)POSYEAR进销存年份SMALLINTPOSMON进销存月份SMALLINTPOSSTOREIDSMALLINT,GUID帐套唯一编号VARCHAR(40)帐套选项表表名:ACCOPTIONS字段名中文描述字段类型/字段长度是否为空说明OPTIONID顺序号SMALLINTNOTNULL,OPTIONNAME名称VARCHAR(20)NOTNULL,OPTIONVALUE值VARCHAR(20),MEMO备注VARCHAR(40)存货调价主表表名:ADJAP描述:记录调价的详细资料字段名中文描述字段类型/字段长度是否为空说明ADJAPID顺序号INTEGERNOTPrimary;Unique;CODE单据编号VARCHAR(25)NOTBILLDATE单据日期DATEFLAG冲红标志INTEGERREFERBILLID冲红单IDINTEGEROPERATOR操作员VARCHAR(10)TOTALAMT总金额DOUBLEPRECISIONMEMO备注VARCHAR(40)UPDATETIME修改日期DATERPTID打印样式IDINTEGERSHOPID分支机构IDSMALLINTSFLAG传输标志SMALLINT仓库调拨主表表名:ALLOT描述:记录货品调拨的详细资料字段名中文描述字段类型/字段长度是否为空说明ALLOTID顺序号INTEGERNOTPrimary;Unique;CODE单据号VARCHAR(25)NOTUnique;BILLDATE单据日期DATEFLAG冲红标志INTEGERREFERBILLID冲红单IDINTEGEROPERATOR操作员VARCHAR(10)OUTSID调出仓库号INTEGERNOTINSID调进仓库号INTEGERNOTTOTALAMT总金额DOUBLEPRECISIONMEMO备注VARCHAR(40)UPDATETIME修改日期DATERPTID打印样式IDINTEGERSHOPID分支机构IDSMALLINTSFLAG传输标志SMALLINT地区资料表表名:AREA描述:记录地区的详细资料字段名中文描述字段类型/字段长度是否为空说明AREAID地区IDINTEGERNOTPrimary;Unique;LCODE地区编号VARCHAR(10)NOTNAME地区名称VARCHAR(12)NOTUPFLAG发送标志ARCHAR(1)固定资产增加表表名:ASSETCARD描述:企业固定资产详细资料字段名中文描述字段类型/字段长度是否为空说明ID顺序号INTEGERNOTPrimary;Unique;CODE编号VARCHAR(10)NOTNAME名称VARCHAR(40)SPECTYPE规格型号VARCHAR(20)ASSETTYPEID类别IDINTEGERDEPTID所属部门IDINTEGERINCRDECRID固定资产增加减少INTEGERLOCATION地址VARCHAR(60)USEDTYPEID使用方式INTEGERDEPRECIATEID折旧IDINTEGERSTARTDATE入帐日期DATEWORKLOAD预计使用月份INTEGERUSEDAGOINTEGERUSEDALL已计使用月份INTEGERUNIT工作量单位VARCHAR(10)RAWVALUE入帐原值DOUBLEPRECISIONUSEDVALUE累计折旧DOUBLEPRECISIONUSEDVALUEAGODOUBLEPRECISIONREMAINRATE预计净残值率DOUBLEPRECISIONREMAINVALUE预计净残值DOUBLEPRECISIONDEPRRATE月折旧率DOUBLEPRECISIONDEPRVALUE月折旧额DOUBLEPRECISIONSUBID折旧科目VARCHAR(18)CLEARFLAG清除标志VARCHAR(1)INITFLAG初始化标志VARCHAR(1)CREDID凭证IDVARCHAR(10)固定资产类别表表名:ASSETTYPE描述:固定资产类别的明细资料字段名中文描述字段类型/字段长度是否为空说明ID顺序号INTEGERNOTPrimary;NAME类别名称VARCHAR(20)NOTUnique;DEPRECIATEID折旧IDSMALLINT,REMAINRATE预计净残值率DOUBLEPRECISION固定资产及累计折旧余额表表名:ASTBALANCE描述:字段名中文描述字段类型/字段长度是否为空说明YEARMON地区IDVARCHAR(6)NOTPrimary；ID顺序号INTEGERNOTPrimary；TOTALWL总工作量INTEGERCURRWL本月工作量INTEGERUSEDVALUE累计折旧DOUBLEPRECISIONDEPRRATE月折旧率DOUBLEPRECISIONDEPRVALUE月折旧额DOUBLEPRECISIONBASTDEBIT(余额方向为借方)|期初余额DOUBLEPRECISIONYASTDEBIT(余额方向为借方)|本年借方余额DOUBLEPRECISIONYASTCREDIT(余额方向为借方)|本年贷方余额DOUBLEPRECISIONASTDEBIT(余额方向为借方)|本期借方余额DOUBLEPRECISIONASTCREDIT(余额方向为借方)|本期贷方余额DOUBLEPRECISIONBDPRCREDIT(余额方向为贷方)|期初余额DOUBLEPRECISIONYDPRDEBIT(余额方向为贷方)|本年借方DOUBLEPRECISIONYDPRCREDIT(余额方向为贷方)|本年贷方DOUBLEPRECISIONDPRDEBIT(余额方向为贷方)|本期借方DOUBLEPRECISIONDPRCREDIT(余额方向为贷方)|本期贷方DOUBLEPRECISION固定资产减少表表名:ASTCLEAR描述:记录被清除固定资产的详细资料字段名中文描述字段类型/字段长度是否为空说明ID顺序号INTEGERNOTPrimary;CLEARDATE清除日期DATE,INCRDECRID增减IDINTEGER,EARINGDOUBLE清理收入PRECISION,PAYOUT清理费用DOUBLEPRECISION,MEMO标志VARCHAR(40)附属设备表表名:ATTACHAST字段名中文描述字段类型/字段长度是否为空说明ID顺序号INTEGERNOTPrimary;ITEMNO明细号INTEGERNOTPrimary;NAME名称VARCHAR(20),SPECTYPE规格VARCHAR(20),UNIT计量单位VARCHAR(10),AMOUNT数量DOUBLEPRECISION,ATTACHSUM金额DOUBLEPRECISION,STARTDATE使用日期DATE,MEMO备注VARCHAR(40)退料从表表名:BACKDETAIL描述:记录所退货品的详细资料字段名中文描述字段类型/字段长度是否为空说明BACKDRAWID主表IDINTEGERNOTPrimary;ITEMNO明细号SMALLINTNOTGOODSID货品IDVARCHAR(20),QUANTITY数量DOUBLEPRECISION,APRICE单价DOUBLEPRECISION退料主表表名:BACKDRAW字段名中文描述字段类型/字段长度是否为空说明BACKDRAWID单据IDINTEGERNOTPrimary;CODE单据号VARCHAR(25)NOTUnique;BILLDATE单据日期DATE,FLAG冲红标志INTEGERREFERBILLID冲红单IDINTEGEROPERATOR操作员VARCHAR(10),BACKMANID退货员INTEGER,INSID退入仓库号INTEGER,TOTALAMT总金额DOUBLEPRECISION,MEMO备注VARCHAR(40),UPDATETIME修改日期DATE,RPTID打印样式IDINTEGERSHOPID分支机构IDSMALLINTSFLAG传输标志SMALLINT试算平衡表表名:BALANCE描述:字段名中文描述字段类型/字段长度是否为空说明YEARMON年月份VARCHAR(6)NOTPrimary;MONEYID货币IDSMALLINTNOTNULL,Primary;SUBID会计科目VARCHAR(18)NOTNULL,RATE汇率DOUBLEPRECISION,YBRAWDEBIT年初借方原币金额DOUBLEPRECISION,YBRAWCREDIT年初贷方原币金额DOUBLEPRECISION,BRAWDEBIT期初借方原币金额DOUBLEPRECISION,BRAWCREDIT期初贷方原币金额DOUBLEPRECISION,RAWDEBIT本期累计借方原币金额DOUBLEPRECISION,RAWCREDIT本期累计贷方原币金额DOUBLEPRECISION,ERAWDEBIT期末借方原币金额DOUBLEPRECISION,ERAWCREDIT期末贷方原币金额DOUBLEPRECISION,YRAWDEBIT本年借方原币金额DOUBLEPRECISION,YRAWCREDIT本年贷方原币金额DOUBLEPRECISION,YBDEBIT本年借方本位币金额DOUBLEPRECISION,YBCREDIT本年贷方本位币金额DOUBLEPRECISION,BDEBIT期初借方本位币金额DOUBLEPRECISION,BCREDIT期初贷方本位币金额DOUBLEPRECISION,DEBIT本期累计借方本位币金额DOUBLEPRECISION,CREDIT本期累计贷方本位币金额DOUBLEPRECISION,EDEBIT期末借方本位币金额DOUBLEPRECISION,ECREDIT期末贷方本位币金额DOUBLEPRECISION,YDEBIT本年借方本位币金额DOUBLEPRECISION,YCREDIT本年贷方本位币金额DOUBLEPRECISION库存盘点从表表名:BALDETAIL字段名中文描述字段类型/字段长度是否为空说明BALITEMID盘点单IDINTEGERNOTPrimary;ITEMNO明细号SMALLINTNOTPrimary;GOODSID货品IDVARCHAR(20),QUANTITY数量DOUBLEPRECI