速达ERP-5000数据库表结构(共328页).doc

《速达ERP-5000数据库表结构(共328页).doc》由会员分享，可在线阅读，更多相关《速达ERP-5000数据库表结构(共328页).doc（328页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、精选优质文档-倾情为你奉上1采购计划PPP_PurchasePlanP_PurchasePlandetail2采购订单POP_OrderP_Orderdetail3估价入库PVP_ValueP_Valuedetail4采购开单PKP_PurchaseP_Purchasedetail5请购单PRP_RequestP_Requestdetail6进口订单FQF_ImportOrderF_ImportOrderDetail7进口单证FIF_ImportF_ImportDetail11销售计划SPS_SalePlanS_SalePlandetail12销售订单SOS_OrderS_Orderdetai

2、l13委托代销SDS_DeputeSaleS_DeputeSaledetail14销售开单SSS_SaleS_Saledetail15发出商品SGS_SendOutGoodsS_SendOutGoodsdetail16出口订单FOF_ExportOrderF_ExportOrderDetail17出口单证FEF_ExportF_ExportDetail18装箱单FLF_ExportLoadF_ExportLoadDetail21出入库单IOI_IOStoreI_IOStoredetail22其他收货单OII_OtherInI_OtherIndetail23其他发货单OOI_OtherOutI_

3、OtherOutdetail25领料单DRI_DrawI_Drawdetail26调拨单ALI_AllotI_Allotdetail27组装单COI_combinI_combindetail28拆卸单DCI_DisCombinI_DisCombindetail29报损单ATI_AttaintI_Attaintdetail30盘点单BAI_BalItemI_BalItemdetail31调价单ADI_ADJAPI_ADJAPdetail32货位调整单PAI_PlaceAdjustI_PlaceAdjustdetail40采购费用分摊PUp_PPurchaseAppp_PPurchaseAppde

4、tail41验收单MFMNF_FinishedMNF_Finisheddetail42加工单MMMNF_ManuOrderMNF_ManuOrderdetail43主生产计划MPMNF_ManuPlanMNF_ManuPlan44MRP运算MRMNF_MrpMNF_Mrpdetail45费用分摊MEMNF_ExpenseMNF_Expensedetail46在制品单MWMNF_ManuWorkMNF_ManuWorkdetail47工序计划单WPW_PlanW_Plandetail48工序流程卡WOW_ProcW_Procdetail49工序交接单WAW_PassW_passItem50工序调

5、度单WDW_DispatchW_Dispatchdetail51银行存取款BMB_MoveB_Movedetail52费用开支BEB_ExpenseB_Expensedetail53其他收入BIB_InComeB_InComedetail54委托加工单CMCm_MachiningCm_Machiningdetail55委托加工领料单CDCm_DrawCm_Drawdetail56委托加工验收单CFCm_FinishedCm_Finisheddetail57委托加工费用单CECm_ExpenseCm_Expensedetail58委托加工费用分摊单CACm_ExpenseAppCm_Expens

6、eAppdetail61应付款单APA_PayA_Paydetail62应收款单ACA_ChargeA_Chargedetail63往来帐核销ATA_CounteractA_Counteractdetail64开票管理INdetail65汇兑损益AEA_ExchProlosA_ExchProlosDetail71POS零售单SPPOS_SalePOS_Saledetail72POS出入款单SMPos_inoutcashPos_inoutcashdetail73POS日结单SFPos_closePos_closedetail74POS储值卡充值CZpos_savingcardpos_saving

7、carddetail75POS促销价调整CXpos_adjpricepos_adjpricedetail76请配单QDD_RequestD_Requestdetail77配送单DPD_DistributeD_Distributedetail78机会报价单QUcrm_chancecrm_chancedetail79行动单XDcrm_activitycrm_activitydetail80员工档案HEL_EmployL_Employdetail81入职申请单HAHr_AccessionHr_Accessiondetail82离职申请单HDHr_DimissionHr_Dimissiondetail

8、83工作调动HPHr_JobplacementHr_Jobplacementdetail84用工合同HCHr_LaborcontractHr_Laborcontractdetail85薪金调整HSHr_StipendadjustHr_Stipendadjustdetail90报检单QBqlt_applyqlt_applydetail91检验单QCqlt_checkupqlt_checkupdetail92项目检验单QIqlt_itemcheckupqlt_itemcheckupdetail93内检费用单QEqlt_expenseqlt_expensedetail94设备校验单QVqlt_dev

9、iceqlt_devicedetail111服务反馈单ASCrm_ServiceCrm_Servicedetail112维修派工单AMCrm_ManuorderCrm_Manuorderdetail113维修验收单AFCrm_FinishedCrm_Finisheddetail114维修发货单AGCrm_ConsignmentCrm_Consignmentdetail8001银行存取款BMAC_MoveAC_Movedetail8002费用开支BEAC_ExpenseAC_Expensedetail8003其他收入BIAC_InComeAC_InComedetail2402客户资料client

10、listform2403货品资料goodslistform2404仓库资料storelistform2405员工资料employlistform2406部门资料departmentlistform2407出纳帐户bankactlistform2410存货类型gcmlistform2411 员工类型资料emptypelistform2413结算方式paymethodlistform2416出入库类型iotypelistform2417往来单位案例tradercaselistform2418产品案例goodscaselistform2419备忘录todolistform2420到期货品报警matu

11、regoodsform2421超期应收款duegatheringform2422超期应付款duepaymentform2423初始化货品库存goodsinitlistform2424往来单位跟踪价格settraderpricelistform2425车间资料workshoplistform2427分仓库存onhandlistform2428设置货品价格setgoodspriceform2430银行bankdatalistform2431任务类别tasktypelistform2432项目任务jobtasklistform2433项目资料joblistform2434公告信息informatio

12、nlistform2435公告栏boardlistform2436POS机器posmachinelistform2438柜台资料poscounterlistform2439会员卡posviplistform2440储值卡possavingscardlistform2441储值卡类型possavingstypelistform2442采购订单到期报警maturedpurchaseorderform2443销售订单到期报警maturedsaleorderform2444货品库存报警goodsstockwarningform2445分支机构资料shoplistform2446单位组unitgroup

13、listform2447加工类型machiningtypelistform2448委托加工费用名称machiningexpenselistform2450供应商资料vendorlistform2451替代品资料subgoodslistform2452机构间业务核算类型betweenshoplistform2454班组资料workgrouplistform2455工作中心workcenterlistform2456工序资料workproclistform2457工艺路线worklinelistform2458资金储备报警bankactwarningform2459销售消息模板salemsnmod

14、ellistform2460采购消息模板purchasemsnmodellistform2461合同到期报警contractwarningform2462发送对帐单报警sendwarningform2464维修类型servicetypelistform2465超期待订请购单报警OverTimeRequestForm2466检验项目chkitemlistform2467检验地点chkaddrlistform2468检验环境chkconditionlistform2469检验设备chkdevicelistform2470检验指标chktargetlistform2471抽检方案chkschemel

15、istform2472质量等级chkqlylevellistform2473不良品处理chkwasterlistform2475样本量字码表chkgbqtywordlistform2477自定义抽检规则chkudefrulelistform2480自定义资料CountryAreaListForm2481国别地区CountryAreaListForm2482城市港口CityPortListForm2483保险险种InsuranceKindListForm2484贸易方式TradeMethodListForm2485关区代码CustomsCodeListForm2486价格术语PriceTermL

16、istForm2487Hs编码CountryAreaListForm2488包装资料GoodsPackListForm2489订单条款OrderClauseListForm2490唛头资料MarkListForm2491进口订单到期报警ImportOrderWarnForm2492出口订单到期报警ExportOrderWarnForm7201文件审批-我未查看文件oa_archiveslistform7202审批类别oa_archivestypelistform7203审批事项oa_actionlistform7204审批流程oa_archivesflowlistform7205审批模板oa_

17、archivestemplatelistform7208公告管理oa_placardlistform7209新闻管理oa_newslistform7210 通 讯 录- 个人通讯录oa_addresslistform7212留言簿oa_messageboardlistform7213工作日记-我的日记oa_diarylistform生产成本计算表manufacturecostrptform采购计划汇总表 - 公司计划mpplanbycompanyrptform采购计划汇总表 - 部门计划mpplanbydeptrptform采购计划汇总表 - 业务员计划mpplanbyemployrptfor

18、m采购计划明细表 - 公司计划dpplanbycompanyrptform采购计划明细表 - 部门计划dpplanbydeptrptform采购计划明细表 - 业务员计划dpplanbyemployrptform采购订单汇总表 - 按货品mporderbygoodsrptform采购订单汇总表 - 按供应商mporderbyvendorrptform采购订单明细表 - 按货品dporderbygoodsrptform采购订单明细表 - 按供应商dporderbyvendorrptform采购开单汇总表 - 按供应商mpbyvendorrptform采购开单汇总表 - 按货品mpbygoodsr

19、ptform采购开单汇总表 - 按仓库mpbystorerptform采购开单汇总表 - 按业务员mpbyemployrptform采购开单汇总表 - 按地区mpbyarearptform采购开单汇总表 - 按货品类别mpbygoodstyperptform采购开单汇总表 - 按部门mpbydeptrptform采购开单明细表 - 按供应商dpbyvendorrptform采购开单明细表 - 按货品dpbygoodsrptform采购开单明细表 - 按仓库dpbystorerptform采购开单明细表 - 按业务员dpbyemployrptform估价入库汇总表 - 按供应商mpvalueby

20、vendorrptform估价入库汇总表 - 按货品mpvaluebygoodsrptform估价入库明细表 - 按供应商dpvaluebyvendorrptform估价入库明细表 - 按货品dpvaluebygoodsrptform采购商品折扣汇总表mpgoodsdiscrptform采购商品折扣明细表dpgoodsdiscrptform采购日报表mpdailyrptform流水帐报表timewaterform销售订单汇总表 - 按客户msorderbyclientrptform销售订单明细表 - 按客户dsorderbyclientrptform销售订单汇总表 - 按货品msorderby

21、goodsrptform销售订单明细表 - 按货品dsorderbygoodsrptform销售开单汇总表 - 按客户msbyclientrptform销售开单明细表-按客户dsbyclientrptform销售开单汇总表 - 按货品msbygoodsrptform销售开单明细表-按货品dsbygoodsrptform销售开单汇总表 - 按业务员msbyemployrptform销售开单明细表-按业务员dsbyemployrptform销售开单汇总表 - 按仓库msbystorerptform销售开单明细表-按仓库dsbystorerptform销售毛利汇总表 - 按客户msprofitbyc

22、lientrptform销售毛利汇总表 - 按业务员msprofitbyemployrptform销售毛利汇总表 - 按货品msprofitbygoodsrptform销售毛利明细表-按客户dsprofitbyclientrptform销售毛利明细表-按业务员dsprofitbyemployrptform销售毛利明细表-按货品dsprofitbygoodsrptform销售业绩统计表 - 按客户msgradebyclientrptform销售业绩统计表 - 按业务员msgradebyemployrptform委托代销汇总表 - 按客户mastdeputesalebyclientrptform委

23、托代销汇总表 - 按货品mastdeputesalebygoodsrptform委托代销明细表 - 按客户dsdeputebyclientrptform委托代销明细表 - 按货品dsdeputebygoodsrptform委托代销成本汇总表 - 按货品mastdeputesalebyapricerptform委托代销成本明细表 - 按货品dsdeputebyapricerptform销售计划汇总表 - 公司计划msplanbycompanyrptform销售计划汇总表 - 部门计划msplanbydeptrptform销售计划汇总表 - 业务员计划msplanbyemployrptform销售

24、计划明细表 - 公司计划dsplanbycompanyrptform销售计划明细表 - 部门计划dsplanbydeptrptform销售计划明细表 - 业务员计划dsplanbyemployrptform销售商品折扣汇总表msgoodsdiscrptform销售商品折扣明细表dsgoodsdiscrptform销售开单汇总表 - 按折扣率msbydiscrptform销售开单明细表-按折扣率dsbydiscrptform销售开单汇总表 - 按地区msbyarearptform销售开单汇总表 - 按货品类别msbygoodstyperptform销售开单汇总表 - 按部门msbydeptrpt

25、form销售日报表msdailyrptform采购费用分摊汇总表 - 按供应商mpchargebyvendorrptform采购费用分摊汇总表 - 按仓库mpchargebystorerptform采购费用分摊汇总表 - 按货品mpchargebygoodsrptform采购费用分摊明细表 - 按供应商dpchargebyvendorrptform采购费用分摊明细表 - 按仓库dpchargebystorerptform采购费用分摊明细表 - 按货品dpchargebygoodsrptform帐面库存汇总表-按货品类别MastStockByGoodsTypeRptForm帐面库存汇总表mast

26、stockrptform帐面库存明细表detailstockrptform实际库存汇总表maststockqtyrptform实际库存明细表 - 按基本单位统计detailstockqtyrptform库存分类汇总表maststockinoutsortarptform仓库开单汇总表maststockinoutsortbrptform仓库开单明细表detailstockinoutsortrptform仓库货位综合报表-横向统计maststockplace_x_rptform库存报警明细表maststockwarningrptform个别计价货品帐面库存汇总表mastbatchstockrptfo

27、rm个别计价货品帐面库存明细表detailbatchstockrptform批次货品保质期清单mastbatchstockvalidaterptform分仓库存数量金额表-横向MastStoreQtyAmtRptForm批号货品管理汇总表mastbatchnumbergoodsrptform批号货品管理明细表 - 按基本单位统计detailbatchnumbergoodsrptform帐面库存数量汇总表maststoreqtyrptform帐面库存数量明细表 - 按基本单位统计detailstorerptform分仓库存数量金额表 - 纵向统计maststoreqtyamt_y_rptform

28、仓库货位综合报表-纵向统计maststockplacerptform帐面库存数量明细表 - 按业务单位统计detailpstorerptform实际库存明细表 - 按业务单位统计detailpstockqtyrptform批号货品管理明细表 - 按业务单位统计detailpbatchnumbergoodsrptform主生产计划汇总表mastmanufactureform主生产计划明细表detailmanufacturerptform加工验收汇总表mastmanufacturingorderrptform加工单明细表detailmanufacturingorderrptform直接材料领用汇总

29、表mastdrawitemrptform直接材料领用明细表 - 货品直接材料领用明细表detaildrawitemrptform委托加工成本计算表MachiningCostRptForm委托加工汇总表-按产品mdeputemanurptform委托加工汇总表-按供应商mdeputemanubyvendorrptform委托加工明细表-按产品ddeputemanurptform委托加工明细表-按供应商ddeputemanubyvendorrptform委托加工综合汇总表-按产品mddeputemanurptform委托加工综合汇总表-按供应商mddeputemanubyvendorrptform

30、委托加工领料汇总表-按产品mdrawrptform委托加工领料明细表-按产品ddrawrptform委托加工验收汇总表-按产品mfinishedrptform委托加工验收汇总表-按供应商mfinishedbyvendorrptform委托加工验收明细表-按产品dfinishedrptform委托加工验收明细表-按供应商dfinishedbyvendorrptform委托加工费用汇总表-按供应商mexpenserptform委托加工费用汇总表-按费用名称mexpensebyexpenserptform委托加工费用明细表-按供应商dexpenserptform委托加工费用明细表-按费用名称dexp

31、ensebyexpenserptform在制品成本计算表manuworkcostrptform在制品数量汇总表mastmanuworkrptform在制品数量明细表-在制品数量明细detailmanuworkrptform生产日报表ManuDailyRptForm采购价格分析-按货品analysepurchasepricerptform年度采购比率分析analyseyearpurchaseraterptform采购结构分析-按货品analysepurstuctrptform年采购量分析-按货品analyseyearpurquantityrptform采购增长分析analysepurchasei

32、ncreaseraterptform销售价格分析-按货品analysesalepricerptform年度销售比率分析analyseyearsaleraterptform销售结构分析-按货品analysesalestuctrptform年销售量分析-按货品analyseyearsalequantityrptform销售增长分析analysesaleincreaseraterptform年度销售毛利分析analyseyearsaleprofitrptform边际库存量分析analyseboundstoreqtyrptform库存结构分析analysestorestuctrptform库存货品周转

33、分析AnalyseYearStoreTurnoverRptForm库存增长分析analysestoreincreaseraterptform库存货品周转分析AnalyseYearStoreTurnoverRptForm应收账款账龄分析NULL客户应收款分析analyseschargerptform应收款周转分析analyseschargeturnoverrptform回款比例分析analysechargestuctrptform回款预测分析analysechargeforecastrptform应付账款账龄分析NULL供应商应付款分析analysespayrptform应付款周转分析analy

34、sespayturnoverrptform付款比例分析analysepaystuctrptform付款预测分析analysepayforecastrptform采购结构分析-按供应商analysepurstuctbyvendorrptform采购结构分析-按业务员analysepurstuctbyemployrptform采购结构分析-按分支机构analysepurstuctbyshoprptform销售结构分析-按客户analysesalestuctbyclientrptform销售结构分析-按业务员analysesalestuctbyemployrptform销售结构分析-按分支机构ana

35、lysesalestuctbyshoprptform年采购量分析-按供应商analyseyearpurquantitybyvendorrptform年采购量分析-按业务员analyseyearpurquantitybyemployrptform年采购量分析-按分支机构analyseyearpurquantitybyshoprptform年销售量分析-按客户analyseyearsalequantitybyclientrptform年销售量分析-按业务员analyseyearsalequantitybyemployrptform年销售量分析-按分支机构analyseyearsalequantit

36、ybyshoprptform年度销售毛利分析-按客户analyseyearsaleprofitbyclientrptform年度销售毛利分析-按业务员analyseyearsaleprofitbyemployrptform年度销售毛利分析-按分支机构analyseyearsaleprofitbyshoprptform采购价格分析-按供应商analysepurchasepricebyvendorrptform采购价格分析-按分支机构analysepurchasepricebyshoprptform销售价格分析-按客户analysesalepricebyclientrptform销售价格分析-按分

37、支机构analysesalepricebyshoprptform应收款单汇总表mastchargerptform应收款单明细表detailchargerptform应付款单汇总表mastpayedrptform应付款单明细表detailpayedrptform应收款超信用额度报表creditcharge应付款超信用额度报表creditpay采购综合汇总表-按供应商mdpbyvendorrptform采购综合汇总表-按货品mdpbygoodsrptform销售综合汇总表-按客户mdsbyclientrptform销售综合汇总表-按货品mdsbygoodsrptform材料消耗汇总表MastDra

38、wGoodsTypeForm仓库积压货品分析analyseoverstockrptform年度应收款分析MastYearChargeRptForm年度应付款分析MastYearPayRptForm待打印单据noprintbill待出入库开单汇总表 - 按货品msdoutinstorerptform待出入库开单明细表-按货品dsdoutinstorerptform待执行采购订单汇总表 - 按供应商mpdealorderbyvendorrptform待执行采购订单汇总表 - 按货品mpdealorderbygoodsrptform待执行采购订单明细表-按供应商dpdealorderbyvendor

39、rptform待执行采购订单明细表 - 按货品dpdealorderbygoodsrptform待执行销售订单汇总表 - 按客户msdealorderbyclientrptform待执行销售订单汇总表 - 按货品msdealorderbygoodsrptform待执行销售订单明细表 - 按客户dsdealorderbyclientrptform待执行销售订单明细表 - 按货品dsdealorderbygoodsrptform待开采购开单入库汇总表 - 按货品mpinbygoodsrptform待开采购开单入库明细表-按货品dpinbygoodsrptform待开销售开单出库汇总表 - 按货品m

40、soutbygoodsrptform待开销售开单出库明细表 - 按货品dsoutbygoodsrptform待开采购退货单出库汇总表 - 按货品mpoutbygoodsrptform待开采购退货单出库明细表 - 按货品dpoutbygoodsrptform待开销售退货单入库汇总表 - 按货品msinbygoodsrptform待开销售退货单入库明细表 - 按货品dsinbygoodsrptform现金银行汇总表mastcashrptform现金银行明细表detailcashrptform验收单汇总表 - 按生产车间mastfinishedbydeptrptform验收单汇总表 - 按生产工人m

41、astfinishedbyemprptform验收单汇总表 - 按产品名称mastfinishedbyprodrptform验收单汇总表 - 按加工单号mastfinishedbyrefrptform验收单明细表 - 按生产车间dfinishedbyworkshoprptform验收单明细表 - 按生产工人dfinishedbyemprptform验收单明细表 - 按产品名称detailfinishedprdimportrptform验收单明细表 - 按加工单号dfinishedbyrefrptform应付帐款汇总表sum_payaccountform应付帐款明细帐payaccountform

42、应收帐款汇总表sum_receaccountform应收帐款明细帐receaccountform销售开单收款情况一览表salerecedlistrptform采购开单付款情况一览表purpayedlistrptform收入费用汇总表purpayedlistrptform收入费用明细表purpayedlistrptform待出入库开单明细表-按往来单位dsdoutintraderrptform待开采购开单入库明细表 - 按供应商dpinbytraderrptform待开销售开单出库明细表 - 按客户dsoutbytraderrptform待开采购退货单出库明细表 - 按供应商dpoutbytra

43、derrptform待开销售退货单入库明细表 - 按客户dsinbytraderrptform待出入库开单汇总表 - 按往来单位msdoutintraderrptform待开采购开单入库汇总表 - 按供应商mpinbytraderrptform待开销售开单出库汇总表 - 按客户msoutbytraderrptform待开采购退货单出库汇总表 - 按供应商mpoutbytraderrptformPOS销售明细表-按储值卡posdsalebysavecardrptformPOS销售明细表-按货品posdsalebygoodsrptformPOS销售明细表-按业务员posdsalebyemployrptformPOS销售明细表-按柜台posdsalebycounterrptformPOS销售明细表-按会员卡posdsalebyviprptform储值卡销售汇总表posmsavecardsalerptform储值卡销售明细表posdsavecardsalerptform会员卡销售明细表posdvipsalerptformPOS销售收款汇总表BaseSQL_POS_RptFormPOS销售收款明细表BaseSQL_POS_RptForm收银员出入款汇总表posinoutcashfor