ERP数据库详细设计说明书

ERP数据库详细设计说明书数据库设计说明书XXXXXXX技术有限公司1、数据库设计 错误!未定义书签。1、1、命名规则 21、2、共用表 91、3、基础数据 21、4、库存子系统 1、5、销售子系统 错误!未定义书签。1、6、采购子系统 ERP数据库详细设计说明书见数据库表名与字段名命名规范2.1、物料类别<Materieltype>(设计人:XXX)就是否为空就是否为空主键外键默认1不标识就是否删除删除,0:删除Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(2000)varchar2(50)varchar2(50)number字段名matypeidmatypenamematypeengnamematyperemarksafetyonesafetytwoenables物料类别编号物料类别名称备注保留字段保留字段默认值【表说明】【主键说明】【外键说明】【索引说明】【字段补充说明】2.2、仓库表<Storage>(设计人:XXX)仓库编号仓库名称仓库简称联系人联系电话Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)stoidstonamestosimplenamestoconnectperstoempidstophonenoyes默认值字段名ERP数据库详细设计说明书stoaddressstoaddressVarchar2(50)yesstoremarkVarchar2(2000)yessafetyonevarchar2(50)yessafetytwovarchar2(50)yesenablesnumber仓库地址备注No保留字段No保留字段【主键说明】【外键说明】【索引说明】【字段补充说明】2.3、物料主文件<Materiel>(设计人:XXX)字段名matidmatnamematspecmattypeidmattypenamematadvicepricematadvicepriceAmatadvicepriceBmatadvicepriceCmatadvicepriceDmatadvicepriceEmatstandardpricematshapematifdutymatdutyratematstockaheaddatematmainaffordmatmainaffordidmatgawpdatematstopdatematremarkmatunitsafetyonesafetytwoVarchar2(50)Varchar2(50)Varchar2(50)Varchar2(20)Varchar2(50)number(19,4)number(19,4)number(19,4)number(19,4)number(19,4)number(19,4)number(19,4)Varchar(50)Number(9)number(19,4)number(9)Varchar2(50)Varchar2(50)number(9)dateVarchar2(2000)Varchar2(50)varchar2(50)varchar2(50)否为空YesYesYesYes默认值0:否0、170物料编号物料名称规格型号物料类别(伪外键)物料类别名称建议售价售价A售价B售价C售价D售价E标准进价物料型态就是否含税税率采购提前期主供应商呆滞起计天数停用日期备注计量单位保留字段保留字段ERP数据库详细设计说明书EnableEnableNumber(9)NoNoNoNo标识就是否删除【主键说明】【外键说明】【索引说明】【字段补充说明】2.4、客户主文件<client>(设计人:XXX)字段名Varchar2(50)字段名Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)datedatedatedateVarchar2(50)Varchar2(50)datedate默认值空cliidclitypeidclinameclishortnamecliidclitypeidclinameclishortnamecliaddresscliareaclienameclieshortname基本资料cliprincipalclilinkmancliphoneonecliphonetwocliphonethreeclibankaccountscliopenbankempidclimobilephonecliemailcliwebclifaxes销售信息clioldoutdateclioldintodateclinewoutdateclinewintodateclidiscountclipricestepclicreatedateclistopdate客户编号YNN客户全称客户简称地方(具体)地区联系人联系电话一联系电话二联系电话三银行帐号开户银行NN移动电话传真号码最初销售出货日最初销售退货日最近销售出货日最近销售退货日折数(%)售价等级客户建立日终止交易日收款信息ERP数据库详细设计说明书clizhangkuaneduVarchar2(50)账款额度cliremaineduVarchar2(50)剩余额度cliconditionVarchar2(50)收款条件(天)climonthreckoningdate每月结账日clicreditstepVarchar2(50)信用等级cliqcpremoneynumber(19,4)期初预收款cliqcdealmoneynumber(19,4)期初应收款cliqmpremoneynumber(19,4)期末预收款cliqmdealmoneynumber(19,4)期末应收款cliotherremarkVarchar2(2000)备注clitrashNumber(4,0)就是否废码safetyonevarchar2(50)保留字段safetytwovarchar2(50)保留字段enablesnumber【主键说明】【外键说明】【索引说明】【字段补充说明】2.5、客户类别表<clienttype>(设计人:XXX)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(500)Number(4,0)varchar2(50)varchar2(50)Number(9)备注就是否废码保留字段保留字段标识就是否删除clitypeidclitypenameclitypeenamecliremarkclitypetrashsafetyonesafetytwo就是否为空NNNY默认值字段名0N【主键说明】【外键说明】【索引说明】【字段补充说明】ERP数据库详细设计说明书2.6、人员表<employee>(设计人:XXX)字段名empidempnameempenamedepidempcard基本资料empstateempdutyempphoneoneempphonetwoempphonethreeempbankaccountsempbirthdayempjobEmpemailempwebempfaxesempopenbank其它信息emptopempdegreeempgotimeempgraduatetimeemppactstarttimeemppactendtime通讯资料empnowmailidempfamilyphoneempfamilyplaceempnowphoneempnowplaceempexigencemanempfamilymailidempremarkemptrashVarchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)dateVarchar2(50)datedateVarchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)varchar2(2000)Number(4,0)就是否为空NNNNNN默认值Y人员编号Y人员姓名性别(默认男)职务(改字段名)联系电话一联系电话二联系电话三银行账号出生日期(修改数据类型)电子邮件(一个邮箱)传真号码开户银行合同起始日期合同终止日期现邮编现电话现住址备注0就是否废码0ERP数据库详细设计说明书保留字段保留字段保留字段默认1不删除,0:标识就是否删除varchar2(50)varchar2(50)numbersafetyonesafetytwoenables【主键说明】【外键说明】【索引说明】【字段补充说明】2.7、供应商类型表<providetype>(设计人:XXX)类别英文名称备注就是否废码保留字段保留字段Varchar2(50)Varhcar2(50)Varchar2(50)Varchar2(2000)Number(4,0)varchar2(50)varchar2(50)numberNNY字段名peenamepeeEnamepeeremarkpeetrashsafetyonesafetytwoenables0【主键说明】【外键说明】【索引说明】【字段补充说明】2.8、供应商主文件表<provideInfo>(设计人:XXX)供应商编号供应商全称供应商简称帐款归属供应商类型表名称(新增)地区联系人联系电话一联系电话二字段名peoidpeonamepeoshortnamepeoascriptionpeopeeidpeopeenamepeoareapeoprincipalpeolinkmanpeophoneonepeophonetwoVarchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Y默认值NNNERP数据库详细设计说明书peomobilephoneVarchar2(50)移动电话peobankaccountsVarchar2(50)银行帐号peoopenbankVarchar2(50)开户银行PeoempidVarchar2(50)PeoempnameVarchar2(50)peocallingVarchar2(50)行业别peoemailVarchar2(50)Varchar2(50)peofaxesVarchar2(50)传真号码peocreatedateVarchar2(50)建立日期peocreditclassVarchar2(50)信用等级peozhangkuanedunumber(19,4)帐款额度peoremainedunumber(19,4)剩余额度peomonthreckoningnumber(19,4)每月结帐日Peoqcprepaymoneynumber(19,4)期初预付款peoqcdealmoneynumber(19,4)期初应付款peoqmprepaymoneynumber(19,4)期末预付款peoqmdealmoneynumber(19,4)期末应付款peoremarkVarchar2(2000)备注peotrashNumber(4,0)0就是否废码safetyonevarchar2(50)保留字段safetytwovarchar2(50)保留字段enablesnumber默认1不删除,0:标识就是否删除【主键说明】【外键说明】【索引说明】【字段补充说明】2.9、部门表<depttab>(设计人:XXX)部门编号部门名称备注就是否废码保留字段保留字段Varchar2(50)Varchar2(50)Varchar2(2000)Varchar2(50)varchar2(50)varchar2(50)number字段名depiddepnamedepremarkdeptrashsafetyonesafetytwoenablesNNYNERP数据库详细设计说明书【主键说明】【外键说明】【索引说明】【字段补充说明】3.1、库存总账表<generalledger>(设计人:黄健)字段名GenidgenmaterielidgenstoragenogenstoragenamegenexpectstartqtygenstandarcostgenallcostgenexpectstartallcgensafetyqtyGenavgcostGenqtyGennowavgcostGenstandardcostallGennowcostsafetyonesafetytwoenablesVarchar2(50)Varchar2(50)Varchar2(20)Varchar2(20)Number(9)number(19,4)number(19,4)number(19,4)Number(9)Number(19,4)Number(9)Number(19,4)Number(19,4)Number(19,4)varchar2(50)varchar2(50)number就是否Yes物料编号仓库编号(伪外键)仓库期初总数量标准成本标准总成本期初总成本安全数量平均成本现有总数量现行平均成本标准总成本(改名字)现行总成本保留字段保留字段【主键说明】【外键说明】【索引说明】【字段补充说明】3.2、库存进出明细表<minusandadddetail>(设计人:XXX)字段名字段名类型就是否为主键外键默认值中文说明空ERP数据库详细设计说明书MinusaddidMinusdateMatypeidMatypenameMinusaddUnitpriceMoneysstoragedateStoidStonameOrigintypeOriginidAftermathenablesNumber(9)dateVarchar2(20)Varchar2(50)Number(9)Number(19,4)Number(19,4)Varchar2(50)Varchar2(50)Varchar2(20)Varchar2(20)Number(9)numberSafetytonevarchar2(50)Safetytwovarchar2(50)【主键说明】【外键说明】【索引说明】【字段补充说明】Nnnnn单据日期物料编号物料名称数量(+,-)金额仓库名称来源单别来源单号期末结存保留字段1保留字段23.3、采购账款明细表<AccountMoneyDetail>(XXX)storageidNumber(9)storagedatedateorigintypesVarchar2(50)originidVarchar2(20)nowdateatdateclientsupplyVarchar2(50)citationidVarchar2(50)formerlymoneysNumber(19,4)nowadaysmoneysNumber(19,4)enablesnumbersafetytonevarchar2(50)safetytwovarchar2(50)单据日期来源单别来源单号供货商名称原单金额现行余额n保留字段n保留字段Nnyyyyyyy默认1不删除,0:删标识就是否删除除YYyERP数据库详细设计说明书记录每个仓库每次数量与金额的改变量【主键说明】【外键说明】单据类别【索引说明】时间字段加索引【字段补充说明】4.1、盘点主表<checked>(设计人:XXX)盘点单的流水号盘点的仓库编号Storage(stoid)盘点的仓库名称盘点的日期盘点人名称部门名称制单人-当前登录人审核人-当前登录人保留字段保留字段Sysdate除,0:删除Varchar2(50)Varchar2(50)Varchar2(50)dateVarchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Number(2)varchar2(50)varchar2(50)numbercheidchestoragenochestoragenamechedatechemanchedeptnamecherestrictmancheauditingmanchestatusafetyonesafetytwoenables就是否为空YesYes字段名【主键说明】【外键说明】【索引说明】【字段补充说明】4.2、盘点明细表<Checkdetail>(设计人:XXX)盘点单的流水号check(cheid)栏号cheidVarchar2(50)chelineidNumber(9)就是否为空YesNoYesYes字段名ERP数据库详细设计说明书chematerielidchematerielidVarchar2(50)No物料的编号Materiel(matid)chematerielnameVarchar2(50)No物料的名称cheunitnameVarchar2(50)cheaccountqtyNumber(9)No账面数量checheckqtyNumber(9)No盘点数量cheprofitandlosNumber(9)No盈亏数量cheprofitandlosNumber(19,4)No盈亏金额chepriceNumber(19,4)cheremarkVarchar2(2000)YesNo备注safetyonevarchar2(50)No保留字段safetytwovarchar2(50)No保留字段enablesnumber默认1不删除,0:标识就是否删除【主键说明】AltertablecheckdetailAddconstraintcheckdetail_PK_1primarykey(cheid,chelineid);【外键说明】altertablecheckdetailaddconstraintcheckdetail_FK_1foreignkey(cheid)referencecheck(cheid)【索引说明】【字段补充说明】按数量与金额4.3、其它出库主表<otheroutmain>(设计人:刘XXX)Y单据号码(系统自带)单据日期仓库所属部门制单人员就是否废码保留字段保留字段默认1不删除,0:标识就是否删除OthidOthdateothouttypeidothstoreOthoutnameOthdeptOthmakemanidOthrepeatuseridclitrashsafetyonesafetytwoenablesvarchar2(50)varchar2(50)varchar2(50)varchar2(50)varchar2(50)varchar2(50)varchar2(50)Number(4,0)varchar2(50)varchar2(50)number就是否为空字段名ERP数据库详细设计说明书【主键说明】【外键说明】【索引说明】【字段补充说明】4.4、其它出库明细表<otheroutdetail>(设计人:XXX)栏号物料编号物料名称规格型号数量备注就是否废码保留字段保留字段otheroutidOthoutlinenoOthoutmertialsidOthoutmertialnameOthouttypesOthoutunitsOthoutamountothoutremarkclitrashsafetyonesafetytwoenablesvarchar2(50)varchar2(50)varchar2(50)varchar2(50)varchar2(50)varchar2(50)number(9)varchar2(2000)Number(4,0)varchar2(50)varchar2(50)number就是否为空字段名YY0Y【主键说明】【外键说明】【索引说明】【字段补充说明】4.5、其它入库主表<othercome>(设计人:XXX)单据号码(系统自带)单据日期入库类型仓库入库人员所属部门制单人员OthcomeidOthcomedateothcometypeidOthcomestoreOthcomenameOthcomedeptOthcomemakemanidvarchar2(50)varchar2(50)varchar2(50)varchar2(50)varchar2(50)varchar2(50)就是否为空NNN默认值字段名yERP数据库详细设计说明书就是否废码保留字段保留字段varchar2(50)Number(4,0)varchar2(50)varchar2(50)numberclitrashsafetyonesafetytwoenablesOthcomerepeatuseY【主键说明】【外键说明】【索引说明】【字段补充说明】4.6、其它入库明细表<othercomedetail>(设计人:XXX)栏号物料编号物料名称规格型号数量备注就是否废码保留字段保留字段varchar2(50)varchar2(50)varchar2(50)varchar2(50)varchar2(50)varchar2(50)number(9)varchar2(2000)Number(4,0)varchar2(50)varchar2(50)numberOthcomeidOthcomenoOthcomemertialsidOthcomemertialnameOthcometypesOthcomeunitsOthcomeamountothcomeremarkclitrashsafetyonesafetytwoenables就是否为空字段名YY0Y【主键说明】【外键说明】【索引说明】【字段补充说明】4.7、调价主表<MovePrice>(设计人:XXX)字段名字段名类型就是否为主键外键默认值中文说明空movedatedateNN单据日期ERP数据库详细设计说明书单据号码单据号码调整方式仓库编号制单人员复核人员备注No保留字段No保留字段moveorderNoVarchar2(50)moveadjustVarchar2(50)movestorageNoVarchar2(50)movemakeVarchar2(50)movecheckVarchar2(50)moveremarkVarchar2(2000)moveAuditingStaNumber(9)safetyonevarchar2(50)yessafetytwovarchar2(50)yesenablesnumberYNNNNNN【主键说明】【外键说明】【索引说明】【字段补充说明】4.8、调价明细表<MovePriceDetail>(设计人:XXX)单据号码物料编号物料名称规格型号库存量现行平均成本单价(自己填)调价金额保留字段保留字段moveorderNoVarchar2(50)MovematerielnoVarchar2(50)MovematerielnameVarchar2(50)MovespectypeVarchar2(50)MoveunitVarchar2(50)MovestocksNumber(9)moveaveragecostNumber(19,4)movepriceNumber(19,4)movemovepriceNumber(19,4)safetyonevarchar2(50)safetytwovarchar2(50)enablesnumber就是否为空字段名YYNN【主键说明】【外键说明】【索引说明】【字段补充说明】ERP数据库详细设计说明书4.9、调拨单主表<movestorage>(设计人:XXX)单据号码(单号)单据日期入库仓(仓库编号)制作人备注就是否可用保留字段1保留字段1MsenomsedateMseoutstoragemseinsertstormseemployeemesAuditingempMesremarkmesstateMestrashMespreservingonemespreservingtwoenablesVarchar2(50)dateVarchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(2000)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)number默认1不删除,0:NNNNNN0:未审核Y字段名【主键说明】【外键说明】【索引说明】【字段补充说明】4.10、调拨单明细表<movedetails>(设计人:XXX)单据号码(单号)物料编号物料名称物料规格数量现行平均成本(出库)总现行平均成本备注保留字段1保留字段1MdsnoMdsmsenomdsmaterieltypemdsmaterielnamemdsmaterielspecsmdsmaterielunitmdsmaterielnumMdsavgcostmdscostMdsremarkMespreservingonemespreservingtwoenablesVarchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(2000)Varchar2(50)Varchar2(50)numberNNNNYY字段名NNNY【主键说明】ERP数据库详细设计说明书【外键说明】【索引说明】【字段补充说明】5.1、销售报价主表<sellquote>(设计人:XXX)字段名billDatesinNamecliid字段名billDatesinNamecliidclishortnamecliplaceidCliplaceeffectdatecurrencyTypepriceWhetherTaxempidempNamedepiddepNamemakeEmpNameAuditingEmpNamecheckstatetotalMoneytotalTaxtotalTaxMoneyenablesSafetyonesafetytowvarchar2(20)number(9)Varchar(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)varchar2(20)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Number(9)Number(19,4)Number(19,4)Number(19,4)varchar2(2000)numbervarchar2(50)varchar2(50)单据号码单据日期YYsingleType(sinId)单据名称客户编号单据名称客户编号client(cliid)客户简称地址编号地址有效日期单价就是否含税业务人员编号,也就就是人员编号employee(empid)部门编号depttab(depid)所属部门制单人员合计金额合计税额合计含税金额备注Null默认0默认0未审核,1:审核默认默认1不删除,0:删除保留字段保留字段保留字段保留字段销售报价主表ERP数据库详细设计说明书【主键说明】【外键说明】【索引说明】【字段补充说明】Safetyone与safetytwo就是一个保留字段Enable就是一个标识就是否删除,默认1不删除,0:删除5.2、销售报价明细表<quotedetails>(设计人:XXX)sellquote(billId)Notnull物料编号Materiel(matid)Notnull含税金额默认1不删标识就是否删除除,0:删除safetyonesafetytwovarchar2(20)Varchar2(50)varchar2(50)varchar2(50)varchar2(50)numbervarchar2(50)varchar2(50)字段名matidmatnamematspecmatunitquonumberenables保留字段保留字段【主键说明】【外键说明】【索引说明】【字段补充说明】5.3、销售订单主表<sellOrder>(设计人:XXX)ERP数据库详细设计说明书billDatesinNamecliidclishortnamecliplaceidCliplaceorderStatusvarchar2(20)number(9)Varchar(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)number(2)currencyTypepriceWhetherTaxempidempNamedepiddepNamemakeEmpNameAuditingEmpNamecheckstatetotalMoneytotalTaxtotalTaxMoneyenablesVarchar2(50)varchar2(20)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Number(9)varchar2(2000)Number(19,4)Number(19,4)Number(19,4)numbersafetyonevarchar2(50)safetytwovarchar2(50)【主键说明】【外键说明】【索引说明】【字段补充说明】Y效`默认0未审核,1:审核默认1不删除,0:删除单据号码单据日期singleType(sinId)单据名称客户编号client(cliid)客户简称地址编号地址订单状况单价就是否含税业务人员编号,也就就是人员编号employee(empid)部门编号depttab(depid)所属部门制单人员备注合计金额合计税额合计含税金额标识就是否删除保留字段保留字段5.4、销售订单明细表<orderDetails>(设计人:XXX)字段名varchar2(20)默认值码ERP数据库详细设计说明书nullsellOrder(billId)matidmatnamematspecmatunitmatidmatnamematspecmatunitVarchar2(50)Not物料编号Materiel(matid)varchar2(50)Not物料名称varchar2(50)null规格型号varchar2(50)Not单位名称number(19,4)NotsinNameenablessafetyonesafetytwoNumber(19,4)Notnumber(19,4)NotVarchar(50)Null来源单别varchar2(20)来源单号number默认1不删标识就是否删除除,0:删除varchar2(50)Null保留字段varchar2(50)Null保留字段【主键说明】【外键说明】ERP数据库详细设计说明书【索引说明】【字段补充说明】5.5、销售出库主表<sellissueorder>(设计人:XXX)字段名默认值varchar2(20)Y单据号码billDate单据日期number(9)singleType(sinId)SinnameVarchar(50)单据名称cliidVarchar2(50)客户编号client(cliid)clishortnameVarchar2(50)客户简称cliplaceidVarchar2(50)地址编号CliplaceVarchar2(50)地址effectdateNull有效日期currencyTypeVarchar2(50)priceWhetherTaxvarchar2(20)单价就是否含税Varchar2(50)仓库编号stonamevarchar2(50)仓库名称empidempNamedepiddepNamemakeEmpNameAuditingEmpNamecheckstatetotalMoneytotalTaxtotalTaxMoneyenablesVarchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Number(9)varchar2(2000)Number(19,4)Number(19,4)Number(19,4)numbersafetyonevarchar2(50)safetytwovarchar2(50)销售报价主表【主键说明】业务人员编号,也就就是人员编号employee(empid)部门编号depttab(depid)所属部门制单人员核,1:审核备注合计金额合计税额合计含税金额默认1不删标识就是否删除除,0:删除保留字段保留字段ERP数据库详细设计说明书【外键说明】【索引说明】【字段补充说明】Safetyone与safetytwo就是一个保留字段Enable就是一个标识就是否删除,默认1不删除,0:删除5.6、销售出库明细表<sellissueorderdetails>(设计人:XXX)字段名matidmatname字段名matidmatnamematspecmatunit默认值varchar2(20)sellissueorder(billId)物料编号物料编号Materiel(matid)含税金额YVarchar2(50)varchar2(50)varchar2(50)varchar2(50)varchar2(50)Varchar(50)sinName来源单别ERP数据库详细设计说明书默认1不删标识就是否删除除,0:删除保留字段保留字段enablessafetyonesafetytwovarchar2(20)numbervarchar2(50)varchar2(50)【主键说明】【外键说明】【索引说明】【字段补充说明】5.7、销售退货主表<sellcancel>(设计人:XXX)键billDatecliidclishortnamecliplaceidCliplaceeffectdatebillDatecliidclishortnamecliplaceidCliplaceeffectdatecurrencyTypepriceWhetherTaxstonameDateNotnull单据日期singleType(sinId)Varchar2(50)Notnull客户编号client(cliid)Varchar2(50)Notnull客户简称Varchar2(50)Null地址编号Varchar2(50)Null地址DateNull有效日期Varchar2(50)Notnull币别varchar2(20)Notnull单价就是否含税Varchar2(50)Notnull仓库编号varchar2(50)Notnull仓库名称whetheranewenterstoragenumber(2)Notnull就是否重新入库empidVarchar2(50)Notnull业务人员编号,也就就是人员编号employee(empid)empNameVarchar2(50)Notnull`depidVarchar2(50)Notnull部门编号depttab(depid)depNameVarchar2(50)Notnull所属部门makeEmpNameVarchar2(50)Notnull制单人员AuditingEmpNameVarchar2(50)nullcheckstateNumber(9)Notnull默认0未审核,1:审核Number(9)Notnull默认1不删除,0:删除标识就是否删除ERP数据库详细设计说明书varchar2(2000)备注totalMoneyNumber(19,4)合计金额totalTaxNumber(19,4)合计税额totalTaxMoneyNumber(19,4)合计含税金额enablesnumber默认1不删标识就是否删除除,0:删除safetyonevarchar2(50)保留字段safetytwovarchar2(50)保留字段销售退货主表【主键说明】【外键说明】【索引说明】【字段补充说明】Safetyone与safetytwo就是一个保留字段Enable就是一个标识就是否删除,默认1不删除,0:删除5.8、销售退货明细表<sellcanceldetails>(设计人:XXX)sellcancel(billId)物料编号Materiel(matid)varchar2(20)Varchar2(20)varchar2(50)varchar2(50)varchar2(50))))))字段名matidmatnamematspecmatunit默认值YERP数据库详细设计说明书)))含税金额))sinNameVarchar(50)来源单别varchar2(20)enablesnumber默认1不删标识就是否删除除,0:删除safetyonevarchar2(50)保留字段safetytwovarchar2(50)保留字段【主键说明】【外键说明】【索引说明】【字段补充说明】5.9、账款明细表<shouldgatheringdetails>(设计人:XXX)字段名字段名minusaddidsinNamenowdatecliidNumber(9)number(9)Varchar(50)varchar2(20)atdateVarchar2(50)originoddMoneyNumber(1currentlybalanceNumber(19,来源单别名称来源单据日期客户编号client(cliid)Y默认值ERP数据库详细设计说明书remarkremarkVarchar2(2000null)enablesnumbersafetyonevarchar2(50)Nullsafetytwovarchar2(50)Null默认1不删标识就是否删除除,0:删除保留字段保留字段5.10、预收款主表<Advancegather>(设计人:XXX)键billDateDateNotnull单据日期sinIdnumber(9)nullY单据类型singleTCliidVarchar2(50)Notnull客户编号client(cliid)clishortnameVarchar2(50)Notnull客户简称currencyTypeVarchar2(50)Notnull币别ReckonTypeFVarchar(50)Notnull结算方式一ReckonTypeSVarchar(50)Notnull结算方式一ReckonTypeTVarchar(50)Notnull结算方式一ReckonMoneyFnumber(19,4)Notnull0、00金额ReckonMoneySnumber(19,4)Notnull0、00金额ReckonMoneyTnumber(19,4)Notnull0、00金额GatherDiscountnumber(19,4)Notnull0、00%折扣率GatherendaccountMonthDateNotnull终止帐月EmpidVarchar2(50)Notnull业务人员编号,也就就是人员编号employee(empid)empNameVarchar2(50)Notnull`业务人员DepidVarchar2(50)Notnull部门编号depttab(depid)depNameVarchar2(50)Notnull所属部门makeEmpNameVarchar2(50)Notnull制单人员AuditingEmpNameVarchar2(50)null复核人员checkstateNumber(9)Notnull默认0未审核,1:审核状态Remarkvarchar2(2000Null备注)enablesnumbersafetyonevarchar2(50)Null保留字段safetytwovarchar2(50)Null保留字段预收账款主表ERP数据库详细设计说明书【主键说明】【外键说明】【索引说明】【字段补充说明】Safetyone与safetytwo就是一个保留字段Enable就是一个标识就是否删除,默认1不删除,0:删除5.11、预收款明细表<Advancegatherdetails>(设计人:XXX)预收金额预收余额来源单别摘要默认1不删标识就是否删除除,0:删除保留字段保留字段字段名sinNameenablessafetyonesafetytwovarchar2(20)Number(19,4)Number(19,4)Varchar(50)varchar2(20)varchar2(2000)numbervarchar2(50)varchar2(50)5.12、收款冲款主表<clashfund>(设计人:XXX)键Y单据号码单据日期singleType(sinId)客户编号client(cliid)客户简称结算方式一结算方式一结算方式一金额varchar2(20)number(9)Varchar2(50)Varchar2(50)Varchar2(50)Varchar(50)Varchar(50)Varchar(50)number(19,4)字段名billDatecliidclishortnamecurrencyTypeReckonTypeFReckonTypeSReckonTypeTReckonMoneyFERP数据库详细设计说明书ReckonMoneySReckonMoneyTGatherDiscountGatherendaccountMonthempidempNamedepiddepNamemakeEmpNameAuditingEmpNamecheckstateenablessafetyonesafetytwo5.13、0、000、00number(19,4)number(19,4)Numeric(19,4)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Number(9)折扣率业务人员编号,也就就是人员编号employee(empid)部门编号depttab(depid)默认默认0未审核,1:审核制单人员varchar2(2000)numbervarchar2(50)varchar2(50)备注默认1不删标识就是否删除除,0:删除保留字段保留字段冲款款明细表1<clashfundDetailsOne>(设计人:XXX)字段名字段名varchar2(20)NotnullYY单据号码Varchar(50)varchar2(20)Number(19,4)Number(19,4)Number(19,4)Number(19,4)numbervarchar2(50)varchar2(50)来源单别(销售订单)默认1不删标识就是否删除除,0:删除保留字段保留字段sinNameenablessafetyonesafetytwoY【主键说明】【外键说明】ERP数据库详细设计说明书【索引说明】【字段补充说明】5.14、冲款款明细表2<clashfundDetailsTwo>(设计人:XXX)字段名字段名sinNamevarchar2(20)Varchar(50)varchar2(20)enablesnumbersafetyonevarchar2(50)safetytwovarchar2(50)来源单别(销售订单)来源单号(销售订单号)来源单号(行号)预收金额预收余额取用预收金额除,0:删除保留字段保留字段Y栏号Y预收款单单号【主键说明】【外键说明】【索引说明】【字段补充说明】6.1、采购请购主表<stockapply>(设计人:XXX)Varchar2(20)就是否为空NNNNYNERP数据库详细设计说明书默认1不删除,0:保存(“采购请购”)保留字段保存(“采购请购”)保留字段appauditingstockapplynameenablessafetyonesafetytwovarchar2(50)varchar2(50)varchar2(50)numberVarchar2(50)Varchar2(50)NNNNN【主键说明】当前日期+流水账号(2【外键说明】【索引说明】【字段补充说明】enable:默认1不删除,0:删除;6.2、采购请购明细表<stockapplydetails>(设计人:XXX)字段名Varchar2(20)就是否为空NNNNNNNNNNNNN默认值YYYERP数据库详细设计说明书Varchar2(2000Varchar2(2000)numberVarchar2(50)Varchar2(50)除保留字段保留字段enablessafetyonesafetytwo【主键说明】请购单编号与行号组成联合主键【外键说明】【索引说明】【字段补充说明】enable:默认1不删除,0:删除;apdstockdate:需求日期-采购提前期;6.3、采购请购类型表<stockapplytype>(设计人:XXX)enableVarchar2(20)Varchar2(50)Varchar2(50)Varchar2(2000)就是否为空NN字段名YN【主键说明】【外键说明】【索引说明】【字段补充说明】enable:默认1不删除,0:删除;6.4、采购询价主表<stockinquire>(设计人:杨为)就是就是否为空NN供应商默认值字段名ERP数据库详细设计说明书StockinquirenameenablessafetyonesafetytwoVarchar2(100)Varchar2(100)varchar2(50)varchar2(50)varchar2(50)Nvarchar2(50)NnumberVarchar2(50)Varchar2(50)NNNNNNNN供应商地址保存(“采购询价单”)默认1不删除,0:标识就是否删除保留字段保留字段【主键说明】当前日期+流水账号(2)【外键说明】【索引说明】【字段补充说明】enable:默认1不删除,0:删除;6.5、采购询价明细表<stockinquiredetails>(设计人:XXX)字段名字段名Varchar2(20)Varchar2(50)Varchar2(50)Varchar2(50)金额税率(%)含税金额就是否为空NNNNNNNNNNNNN默认值YYYERP数据库详细设计说明书保留字段保留字段Varchar2(20)Varchar2(2000)numberVarchar2(50)Varchar2(50)enablessafetyonesafetytwosdaislargess默认1不删除,0:【主键说明】询价单编号与行号组成联合主键【外键说明】【索引说明】【字段补充说明】enable:默认1不删除,0:删除;6.6、采购订单主表<stockorder>(设计人:XXX)varchar2(20)dateVarchar2(50)Varchar2(50)Varchar2(50)varchar2(20)Number(9)Varchar2(50)Varchar2(50)varchar2(50)Varchar2(50)varchar2(50)Varchar2(50)Varchar2(50)就是否为空Varchar2(2000)Number(9)YesNot单据号供货商供货商编号供货商地址单价就是否含税:1-含税,2-未税单况:1-未结案,2-已结案,3-无效送货地址采购人员采购部门制单人员备注stodatestopeonamestopeoidstopeoadressstoistaxstostatestoadressstoempstockStodeptstodeptidstoempnamestoempcheckstomarkcheckstateERP数据库详细设计说明书保存(“采购订单”)默认1不删除,0:标识就是否删除保留字段保留字段stockordernameenablessafetyonesafetytwovarchar2(50)numberVarchar2(50)Varchar2(50)采购订单主表:【主键说明】PK(stoid)【外键说明】【索引说明】【字段补充说明】sodidvarchar2(20)sodlineidnumber(9)sodmaterielidVarchar2(50)sodmatidVarchar2(20)sodspecVarchar2(50)sodamountnumber(9)sodprepricenumber(19,4)sodagionumber(9)sodpricenumber(19,4)sodsumnumber(19,4)sodcessnumber(9)sodsumcessnumber(19,4)sodsumpricenumber(19,4)esodpresentVarchar2(4)sodorigintypeVarchar2(20)sodoriginvarchar2(20)enablesnumbersafetyoneVarchar2(50)safetytwoVarchar2(50)就是否赠品:1-就就是否赠品是,0-否默认1不删除,0:标识就是否删除保留字段保留字段yes栏号物料编号数量折扣前单价折数(%)金额税率(%)预入库日就是否为空ERP数据库详细设计说明书采购订单明细表【主键说明】PK(sodid,sodlineid)【外键说明】【索引说明】【字段补充说明】6.8、采购入库主表<stockstoragetable>(设计人:XXX)字段名stockstoragenostoragedatepurveynamepurveyaddressdepotiddepotnamepricerevenuestopersonstodeptstodeptidaudituseridrepeatuseridestatestockstoragetablenenablessafetyonesafetytwoVarchar2(20)dateVarchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(20)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(50)Varchar2(2000)Number(9)varchar2(50)numberVarchar2(50)Varchar2(50)就是否为主键外键默认值空NNNYNnNNnNYYYNDefaule(0)Y默认1不删除,0:单号(自动生成)单据日期供货商名称供货商地址仓库名称单价就是否含税采购人员采购人员所属部门名称备注单据状态(就是否以审核)保存(“采购入库单”)保留字段保留字段【主键说明】【外键说明】【索引说明】【字段补充说明】ERP数据库详细设计说明书6.9、采购入库明细表(stockstoragedetails--XXX)字段名sto