首页 速达ERP 5000数据库表结构

速达ERP 5000数据库表结构

举报
开通vip

速达ERP 5000数据库表结构1采购计划PPP_PurchasePlanP_PurchasePlandetail2采购订单POP_OrderP_Orderdetail3估价入库PVP_ValueP_Valuedetail4采购开单PKP_PurchaseP_Purchasedetail5请购单PRP_RequestP_Requestdetail6进口订单FQF_ImportOrderF_ImportOrderDetail7进口单证FIF_ImportF_ImportDetail11销售计划SPS_SalePlanS_SalePlandetail...

速达ERP 5000数据库表结构
1 采购 采购部分工政府采购法87号令广东省政府采购政府采购法及采购员下一步工作计划 计划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_Orderdetail13委托代销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_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_PPurchaseAppdetail41验收单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工序调度单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_ExpenseAppdetail61应付款单APA_PayA_Paydetail62应收款单ACA_ChargeA_Chargedetail63往来帐核销ATA_CounteractA_Counteractdetail64开票管理INdetail65汇兑损益AEA_ExchProlosA_ExchProlosDetail71POS零售单SPPOS_SalePOS_Saledetail72POS出入款单SMPos_inoutcashPos_inoutcashdetail73POS日结单SFPos_closePos_closedetail74POS储值卡充值CZpos_savingcardpos_savingcarddetail75POS促销价调整CXpos_adjpricepos_adjpricedetail76请配单QDD_RequestD_Requestdetail77配送单DPD_DistributeD_Distributedetail78机会报价单QUcrm_chancecrm_chancedetail79行动单XDcrm_activitycrm_activitydetail80员工档案HEL_EmployL_Employdetail81入职申请单HAHr_AccessionHr_Accessiondetail82离职申请单HDHr_DimissionHr_Dimissiondetail83工作调动HPHr_JobplacementHr_Jobplacementdetail84用工合同HCHr_LaborcontractHr_Laborcontractdetail85薪金调整HSHr_StipendadjustHr_Stipendadjustdetail90报检单QBqlt_applyqlt_applydetail91检验单QCqlt_checkupqlt_checkupdetail92项目检验单QIqlt_itemcheckupqlt_itemcheckupdetail93内检费用单QEqlt_expenseqlt_expensedetail94设备校验单QVqlt_deviceqlt_devicedetail111服务反馈单ASCrm_ServiceCrm_Servicedetail112维修派工单AMCrm_ManuorderCrm_Manuorderdetail113维修验收单AFCrm_FinishedCrm_Finisheddetail114维修发货单AGCrm_ConsignmentCrm_Consignmentdetail8001银行存取款BMAC_MoveAC_Movedetail8002费用开支BEAC_ExpenseAC_Expensedetail8003其他收入BIAC_InComeAC_InComedetail2402客户资料clientlistform2403货品资料goodslistform2404仓库资料storelistform2405员工资料employlistform2406部门资料departmentlistform2407出纳帐户bankactlistform2410存货类型gcmlistform2411员工类型资料emptypelistform2413结算方式paymethodlistform2416出入库类型iotypelistform2417往来单位案例tradercaselistform2418产品案例goodscaselistform2419备忘录todolistform2420到期货品报警maturegoodsform2421超期应收款duegatheringform2422超期应付款duepaymentform2423初始化货品库存goodsinitlistform2424往来单位跟踪价格settraderpricelistform2425车间资料workshoplistform2427分仓库存onhandlistform2428设置货品价格setgoodspriceform2430银行bankdatalistform2431任务类别tasktypelistform2432项目任务jobtasklistform2433项目资料joblistform2434公告信息informationlistform2435公告栏boardlistform2436POS机器posmachinelistform2438柜台资料poscounterlistform2439会员卡posviplistform2440储值卡possavingscardlistform2441储值卡类型possavingstypelistform2442采购订单到期报警maturedpurchaseorderform2443销售订单到期报警maturedsaleorderform2444货品库存报警goodsstockwarningform2445分支机构资料shoplistform2446单位组unitgrouplistform2447加工类型machiningtypelistform2448委托加工费用名称machiningexpenselistform2450供应商资料vendorlistform2451替代品资料subgoodslistform2452机构间业务核算类型betweenshoplistform2454班组资料workgrouplistform2455工作中心workcenterlistform2456工序资料workproclistform2457工艺路线worklinelistform2458资金储备报警bankactwarningform2459销售消息模板salemsnmodellistform2460采购消息模板purchasemsnmodellistform2461合同到期报警contractwarningform2462发送对帐单报警sendwarningform2464维修类型servicetypelistform2465超期待订请购单报警OverTimeRequestForm2466检验项目chkitemlistform2467检验地点chkaddrlistform2468检验环境chkconditionlistform2469检验设备chkdevicelistform2470检验指标chktargetlistform2471抽检方案chkschemelistform2472质量等级chkqlylevellistform2473不良品处理chkwasterlistform2475样本量字码 关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf chkgbqtywordlistform2477自定义抽检规则chkudefrulelistform2480自定义资料CountryAreaListForm2481国别地区CountryAreaListForm2482城市港口CityPortListForm2483保险险种InsuranceKindListForm2484贸易方式TradeMethodListForm2485关区代码CustomsCodeListForm2486价格术语PriceTermListForm2487Hs编码CountryAreaListForm2488包装资料GoodsPackListForm2489订单条款OrderClauseListForm2490唛头资料MarkListForm2491进口订单到期报警ImportOrderWarnForm2492出口订单到期报警ExportOrderWarnForm7201文件审批->我未查看文件oa_archiveslistform7202审批类别oa_archivestypelistform7203审批事项oa_actionlistform7204审批流程oa_archivesflowlistform7205审批模板oa_archivestemplatelistform7208公告管理oa_placardlistform7209新闻管理oa_newslistform7210通讯录->[个人通讯录]oa_addresslistform7212留言簿oa_messageboardlistform7213工作日记->我的日记oa_diarylistform102050生产成本计算表manufacturecostrptform102501采购计划汇总表-公司计划mpplanbycompanyrptform102502采购计划汇总表-部门计划mpplanbydeptrptform102503采购计划汇总表-业务员计划mpplanbyemployrptform102504采购计划 明细 学校医务室常备药销售费用明细科目收入支出明细办公用品库存明细企业会计科目明细设置 表-公司计划dpplanbycompanyrptform102505采购计划明细表-部门计划dpplanbydeptrptform102506采购计划明细表-业务员计划dpplanbyemployrptform102507采购订单汇总表-按货品mporderbygoodsrptform102508采购订单汇总表-按供应商mporderbyvendorrptform102509采购订单明细表-按货品dporderbygoodsrptform102510采购订单明细表-按供应商dporderbyvendorrptform102511采购开单汇总表-按供应商mpbyvendorrptform102512采购开单汇总表-按货品mpbygoodsrptform102513采购开单汇总表-按仓库mpbystorerptform102514采购开单汇总表-按业务员mpbyemployrptform102515采购开单汇总表-按地区mpbyarearptform102516采购开单汇总表-按货品类别mpbygoodstyperptform102517采购开单汇总表-按部门mpbydeptrptform102518采购开单明细表-按供应商dpbyvendorrptform102519采购开单明细表-按货品dpbygoodsrptform102520采购开单明细表-按仓库dpbystorerptform102521采购开单明细表-按业务员dpbyemployrptform102522估价入库汇总表-按供应商mpvaluebyvendorrptform102523估价入库汇总表-按货品mpvaluebygoodsrptform102524估价入库明细表-按供应商dpvaluebyvendorrptform102525估价入库明细表-按货品dpvaluebygoodsrptform102526采购商品折扣汇总表mpgoodsdiscrptform102527采购商品折扣明细表dpgoodsdiscrptform102528采购日报表mpdailyrptform102529流水帐报表timewaterform102530销售订单汇总表-按客户msorderbyclientrptform102531销售订单明细表-按客户dsorderbyclientrptform102532销售订单汇总表-按货品msorderbygoodsrptform102533销售订单明细表-按货品dsorderbygoodsrptform102534销售开单汇总表-按客户msbyclientrptform102535销售开单明细表--按客户dsbyclientrptform102536销售开单汇总表-按货品msbygoodsrptform102537销售开单明细表--按货品dsbygoodsrptform102538销售开单汇总表-按业务员msbyemployrptform102539销售开单明细表--按业务员dsbyemployrptform102540销售开单汇总表-按仓库msbystorerptform102541销售开单明细表--按仓库dsbystorerptform102542销售毛利汇总表-按客户msprofitbyclientrptform102543销售毛利汇总表-按业务员msprofitbyemployrptform102544销售毛利汇总表-按货品msprofitbygoodsrptform102545销售毛利明细表--按客户dsprofitbyclientrptform102546销售毛利明细表--按业务员dsprofitbyemployrptform102547销售毛利明细表--按货品dsprofitbygoodsrptform102548销售业绩统计表-按客户msgradebyclientrptform102549销售业绩统计表-按业务员msgradebyemployrptform102550委托代销汇总表-按客户mastdeputesalebyclientrptform102551委托代销汇总表-按货品mastdeputesalebygoodsrptform102552委托代销明细表-按客户dsdeputebyclientrptform102553委托代销明细表-按货品dsdeputebygoodsrptform102554委托代销成本汇总表-按货品mastdeputesalebyapricerptform102555委托代销成本明细表-按货品dsdeputebyapricerptform102556销售计划汇总表-公司计划msplanbycompanyrptform102557销售计划汇总表-部门计划msplanbydeptrptform102558销售计划汇总表-业务员计划msplanbyemployrptform102559销售计划明细表-公司计划dsplanbycompanyrptform102560销售计划明细表-部门计划dsplanbydeptrptform102561销售计划明细表-业务员计划dsplanbyemployrptform102562销售商品折扣汇总表msgoodsdiscrptform102563销售商品折扣明细表dsgoodsdiscrptform102564销售开单汇总表-按折扣率msbydiscrptform102565销售开单明细表--按折扣率dsbydiscrptform102566销售开单汇总表-按地区msbyarearptform102567销售开单汇总表-按货品类别msbygoodstyperptform102568销售开单汇总表-按部门msbydeptrptform102572销售日报表msdailyrptform102581采购费用分摊汇总表-按供应商mpchargebyvendorrptform102582采购费用分摊汇总表-按仓库mpchargebystorerptform102583采购费用分摊汇总表-按货品mpchargebygoodsrptform102584采购费用分摊明细表-按供应商dpchargebyvendorrptform102585采购费用分摊明细表-按仓库dpchargebystorerptform102586采购费用分摊明细表-按货品dpchargebygoodsrptform102600帐面库存汇总表--按货品类别MastStockByGoodsTypeRptForm102601帐面库存汇总表maststockrptform102602帐面库存明细表detailstockrptform102603实际库存汇总表maststockqtyrptform102604实际库存明细表-按基本单位统计detailstockqtyrptform102605库存分类汇总表maststockinoutsortarptform102606仓库开单汇总表maststockinoutsortbrptform102607仓库开单明细表detailstockinoutsortrptform102608仓库货位综合报表--横向统计maststockplace_x_rptform102609库存报警明细表maststockwarningrptform102610个别计价货品帐面库存汇总表mastbatchstockrptform102611个别计价货品帐面库存明细表detailbatchstockrptform102612批次货品保质期清单mastbatchstockvalidaterptform102613分仓库存数量金额表--横向MastStoreQtyAmtRptForm102614批号货品管理汇总表mastbatchnumbergoodsrptform102615批号货品管理明细表-按基本单位统计detailbatchnumbergoodsrptform102616帐面库存数量汇总表maststoreqtyrptform102617帐面库存数量明细表-按基本单位统计detailstorerptform102620分仓库存数量金额表-纵向统计maststoreqtyamt_y_rptform102621仓库货位综合报表--纵向统计maststockplacerptform102622帐面库存数量明细表-按业务单位统计detailpstorerptform102623实际库存明细表-按业务单位统计detailpstockqtyrptform102624批号货品管理明细表-按业务单位统计detailpbatchnumbergoodsrptform102651主生产计划汇总表mastmanufactureform102652主生产计划明细表detailmanufacturerptform102653加工验收汇总表mastmanufacturingorderrptform102654加工单明细表detailmanufacturingorderrptform102656直接材料领用汇总表mastdrawitemrptform102657直接材料领用明细表-货品直接材料领用明细表detaildrawitemrptform102658委托加工成本计算表MachiningCostRptForm102659委托加工汇总表--按产品mdeputemanurptform102660委托加工汇总表--按供应商mdeputemanubyvendorrptform102661委托加工明细表--按产品ddeputemanurptform102662委托加工明细表--按供应商ddeputemanubyvendorrptform102663委托加工综合汇总表--按产品mddeputemanurptform102664委托加工综合汇总表--按供应商mddeputemanubyvendorrptform102665委托加工领料汇总表--按产品mdrawrptform102667委托加工领料明细表--按产品ddrawrptform102669委托加工验收汇总表--按产品mfinishedrptform102670委托加工验收汇总表--按供应商mfinishedbyvendorrptform102671委托加工验收明细表--按产品dfinishedrptform102672委托加工验收明细表--按供应商dfinishedbyvendorrptform102673委托加工费用汇总表--按供应商mexpenserptform102674委托加工费用汇总表--按费用名称mexpensebyexpenserptform102675委托加工费用明细表--按供应商dexpenserptform102676委托加工费用明细表--按费用名称dexpensebyexpenserptform102677在制品成本计算表manuworkcostrptform102678在制品数量汇总表mastmanuworkrptform102679在制品数量明细表--在制品数量明细detailmanuworkrptform102680生产日报表ManuDailyRptForm102701采购价格 分析 定性数据统计分析pdf销售业绩分析模板建筑结构震害分析销售进度分析表京东商城竞争战略分析 --按货品analysepurchasepricerptform102702年度采购比率分析analyseyearpurchaseraterptform102703采购结构分析--按货品analysepurstuctrptform102704年采购量分析--按货品analyseyearpurquantityrptform102705采购增长分析analysepurchaseincreaseraterptform102706销售价格分析--按货品analysesalepricerptform102707年度销售比率分析analyseyearsaleraterptform102708销售结构分析--按货品analysesalestuctrptform102709年销售量分析--按货品analyseyearsalequantityrptform102710销售增长分析analysesaleincreaseraterptform102711年度销售毛利分析analyseyearsaleprofitrptform102712边际库存量分析analyseboundstoreqtyrptform102713库存结构分析analysestorestuctrptform102714库存货品周转分析AnalyseYearStoreTurnoverRptForm102715库存增长分析analysestoreincreaseraterptform102716库存货品周转分析AnalyseYearStoreTurnoverRptForm102717应收账款账龄分析NULL102719客户应收款分析analyseschargerptform102720应收款周转分析analyseschargeturnoverrptform102721回款比例分析analysechargestuctrptform102722回款预测分析analysechargeforecastrptform102723应付账款账龄分析NULL102724供应商应付款分析analysespayrptform102725应付款周转分析analysespayturnoverrptform102726付款比例分析analysepaystuctrptform102727付款预测分析analysepayforecastrptform102728采购结构分析--按供应商analysepurstuctbyvendorrptform102729采购结构分析--按业务员analysepurstuctbyemployrptform102730采购结构分析--按分支机构analysepurstuctbyshoprptform102731销售结构分析--按客户analysesalestuctbyclientrptform102732销售结构分析--按业务员analysesalestuctbyemployrptform102733销售结构分析--按分支机构analysesalestuctbyshoprptform102734年采购量分析--按供应商analyseyearpurquantitybyvendorrptform102735年采购量分析--按业务员analyseyearpurquantitybyemployrptform102736年采购量分析--按分支机构analyseyearpurquantitybyshoprptform102737年销售量分析--按客户analyseyearsalequantitybyclientrptform102738年销售量分析--按业务员analyseyearsalequantitybyemployrptform102739年销售量分析--按分支机构analyseyearsalequantitybyshoprptform102740年度销售毛利分析--按客户analyseyearsaleprofitbyclientrptform102741年度销售毛利分析--按业务员analyseyearsaleprofitbyemployrptform102742年度销售毛利分析--按分支机构analyseyearsaleprofitbyshoprptform102743采购价格分析--按供应商analysepurchasepricebyvendorrptform102744采购价格分析--按分支机构analysepurchasepricebyshoprptform102745销售价格分析--按客户analysesalepricebyclientrptform102746销售价格分析--按分支机构analysesalepricebyshoprptform102751应收款单汇总表mastchargerptform102752应收款单明细表detailchargerptform102753应付款单汇总表mastpayedrptform102754应付款单明细表detailpayedrptform102755应收款超信用额度报表creditcharge102756应付款超信用额度报表creditpay102757采购综合汇总表--按供应商mdpbyvendorrptform102758采购综合汇总表--按货品mdpbygoodsrptform102759销售综合汇总表--按客户mdsbyclientrptform102760销售综合汇总表--按货品mdsbygoodsrptform102761材料消耗汇总表MastDrawGoodsTypeForm102762仓库积压货品分析analyseoverstockrptform102763年度应收款分析MastYearChargeRptForm102764年度应付款分析MastYearPayRptForm102765待打印单据noprintbill102766待出入库开单汇总表-按货品msdoutinstorerptform102767待出入库开单明细表--按货品dsdoutinstorerptform102768待执行采购订单汇总表-按供应商mpdealorderbyvendorrptform102769待执行采购订单汇总表-按货品mpdealorderbygoodsrptform102770待执行采购订单明细表--按供应商dpdealorderbyvendorrptform102771待执行采购订单明细表-按货品dpdealorderbygoodsrptform102772待执行销售订单汇总表-按客户msdealorderbyclientrptform102773待执行销售订单汇总表-按货品msdealorderbygoodsrptform102774待执行销售订单明细表-按客户dsdealorderbyclientrptform102775待执行销售订单明细表-按货品dsdealorderbygoodsrptform102776待开采购开单入库汇总表-按货品mpinbygoodsrptform102777待开采购开单入库明细表--按货品dpinbygoodsrptform102778待开销售开单出库汇总表-按货品msoutbygoodsrptform102779待开销售开单出库明细表-按货品dsoutbygoodsrptform102780待开采购退货单出库汇总表-按货品mpoutbygoodsrptform102781待开采购退货单出库明细表-按货品dpoutbygoodsrptform102782待开销售退货单入库汇总表-按货品msinbygoodsrptform102783待开销售退货单入库明细表-按货品dsinbygoodsrptform102784现金银行汇总表mastcashrptform102785现金银行明细表detailcashrptform102793验收单汇总表-按生产车间mastfinishedbydeptrptform102794验收单汇总表-按生产工人mastfinishedbyemprptform102795验收单汇总表-按产品名称mastfinishedbyprodrptform102796验收单汇总表-按加工单号mastfinishedbyrefrptform102797验收单明细表-按生产车间dfinishedbyworkshoprptform102798验收单明细表-按生产工人dfinishedbyemprptform102799验收单明细表-按产品名称detailfinishedprdimportrptform102800验收单明细表-按加工单号dfinishedbyrefrptform102801应付帐款汇总表sum_payaccountform102802应付帐款明细帐payaccountform102803应收帐款汇总表sum_receaccountform102804应收帐款明细帐receaccountform102805销售开单收款情况一览表salerecedlistrptform102806采购开单付款情况一览表purpayedlistrptform102807收入费用汇总表purpayedlistrptform102808收入费用明细表purpayedlistrptform102811待出入库开单明细表--按往来单位dsdoutintraderrptform102812待开采购开单入库明细表-按供应商dpinbytraderrptform102813待开销售开单出库明细表-按客户dsoutbytraderrptform102814待开采购退货单出库明细表-按供应商dpoutbytraderrptform102815待开销售退货单入库明细表-按客户dsinbytraderrptform102816待出入库开单汇总表-按往来单位msdoutintraderrptform102817待开采购开单入库汇总表-按供应商mpinbytraderrptform102818待开销售开单出库汇总表-按客户msoutbytraderrptform102819待开采购退货单出库汇总表-按供应商mpoutbytraderrptform102820POS销售明细表--按储值卡posdsalebysavecardrptform102822POS销售明细表--按货品posdsalebygoodsrptform102823POS销售明细表--按业务员posdsalebyemployrptform102824POS销售明细表--按柜台posdsalebycounterrptform102825POS销售明细表--按会员卡posdsalebyviprptform102826储值卡销售汇总表posmsavecardsalerptform102827储值卡销售明细表posdsavecardsalerptform102828会员卡销售明细表posdvipsalerptform102829POS销售收款汇总表BaseSQL_POS_RptForm102830POS销售收款明细表BaseSQL_POS_RptForm102831收银员出入款汇总表posinoutcashform102832收银员出入款明细表posinoutcashdetailform102833POS销售流水账possalewaterform102834开票汇总表invoicemastrptform102835往来单位货品开票汇总invoicetrgoodsmastrptform102836往来单位货品开票明细invoicetrgoodsdetailrptform102837采购开单开票汇总表invoicempurrptform102838采购开单开票明细表invoicedpurrptform102839销售开单开票汇总表invoicemsalerptform102840销售开单开票明细表invoicedsalerptform102848待开销售退货单入库汇总表-按客户msinbytraderrptform102864柜台货品销售汇总表--按货品posmcountersalebygoodsrptform102865柜台货品销售汇总表--按柜台posmcountersalebycounterrptform102866柜台货品销售明细表--按货品posdcountersalebygoodsrptform102867柜台货品销售明细表--按柜台posdcountersalebycounterrptform102868POS销售明细表--按折扣率posdsalebydiscrptform102869柜台货品销售汇总表--按业务员posmcountersalebyemployrptform102870柜台货品销售明细表--按业务员posdcountersalebyemployrptform102871柜台货品销售汇总表--业务员综合汇总表posmdcountersalebyemployrptform102951请配单汇总表-按货品mrequestbygoodsrptform102952请配单汇总表-按分支机构货品mrequestbyshopgoodsrptform102953请配单汇总表-按货品分支机构mrequestbygoodsshoprptform102954请配单明细表-按货品drequestbygoodsrptform102955请配单明细表-按分支机构货品drequestbyshopgoodsrptform102956请配单明细表-按货品分支机构drequestbygoodsshoprptform102957配送单收货汇总表-按货品mdisrbygoodsrptform102958配送单收货汇总表-按机构货品mdisrbyshopgoodsrptform102959配送单收货明细表-按日期ddisrbygoodsrptform102960配送单收货明细表-按机构货品ddisrbyshopgoodsrptform102961配送单收货明细表-按货品机构ddisrbygoodsshoprptform102962配送单明细--按开单日期ddistributerptform102963配送单发货汇总表-按货品mdissbygoodsrptform102964配送单发货汇总表-按机构货品mdissbyshopgoodsrptform102965配送单发货明细表-按日期ddissbygoodsrptform102966配送单发货明细表-按机构货品ddissbyshopgoodsrptform102967配送单发货明细表-按货品机构ddissbygoodsshoprptform103001采购开单汇总表-按分支机构mpbyshoprptform103002采购开单明细表-按分支机构dpbyshoprptform103003估价入库汇总表-按分支机构mpvaluebyshoprptform103004估价入库明细表-按分支机构dpvaluebyshoprptform103005采购费用分摊汇总表-按分支机构mpchargebyshoprptform103006采购费用分摊明细表-按分支机构dpchargebyshoprptform103007采购综合汇总表--按分支机构mdpbyshoprptform103008采购计划汇总表-分支机构计划mpplanbyshoprptform103009采购计划明细表-分支机构计划dpplanbyshoprptform103010采购订单汇总表-按分支机构mporderbyshoprptform103011采购订单明细表-按分支机构dporderbyshoprptform103030销售计划汇总表-分支机构计划msplanbyshoprptform103031销售计划明细表-分支机构计划dsplanbyshoprptform103032销售订单汇总表-按分支机构msorderbyshoprptform103033销售订单明细表-按分支机构dsorderbyshoprptform103034销售开单汇总表-按分支机构msbyshoprptform103035销售开单明细表--按分支机构dsbyshoprptform103036销售综合汇总表--按分支机构mdsbyshoprptform103037委托代销汇总表-按分支机构mastdeputesalebyshoprptform103038委托代销明细表-按分支机构dsdeputebyshoprptform103039销售毛利汇总表-按分支机构msprofitbyshoprptform103040销售毛利明细表--按分支机构dsprofitbyshoprptform103041发出商品汇总表-按分支机构mssendoutbyshoprptform103042发出商品明细表-按分支机构dssendoutbyshoprptform103043销售业绩统计表-按分支机构msgradebyshoprptform103044销售毛利汇总表-按部门msprofitbydeprptform103045销售毛利明细表--按部门ssprofitbydeprptform103060工序计划汇总表--部门工序计划汇总表mswplandeptrptform103061工序计划汇总表--按工序工序计划汇总表mswplanworprptform103062工序计划汇总表--车间工序计划汇总表mswplanwosprptform103063工序计划汇总表--工作中心工序计划汇总表mswplanwoctrptform103064工序计划汇总表--班组工序计划汇总表mswplanteamrptform103065工序计划明细表dswplandeptrptform103066工序流程卡汇总表--部门工序流程卡汇总表mswprocdeptrptform103067工序流程卡汇总表--车间工序流程卡汇总表mswprocwosprptform103068工序流程卡明细表dswprocdeptrptform103069产品交接单汇总表--部门工序交接汇总表mswpassdeptrptform103070产品交接单汇总表--车间工序交接汇总表mswpasswosprptform103071产品交接单汇总表--按工序交接汇总表mswpassworprptform103072产品交接单明细表dswpassdeptrptform103073工序生产情况分析dswprocworkingrptform103074工序直接材料领用明细表detaildrawworpitemrptform103075材料消耗明细表--纵向按工序detaildrawworpform103076加工单完成情况分析汇总表BaseSQL_POS_RptForm103077加工单完成情况分析明细表DetailFinishedanalyseRptForm103078按单统计生产成本-加工单生产成本计算manufactureordercostrptform103079按单统计生产成本-验收单生产成本计算manufacturefinedcostrptform103080主生产计划生产情况跟踪表manupalnanywayrptform103112调拨单汇总表-按调出仓库iallotoutsumrptform103113调拨单汇总表-按调入仓库iallotinsumrptform103114组装单汇总表-按组装主件icombinmrptform103115组装单汇总表-按组装原件icombindrptform103116拆卸单汇总表-按拆卸主件idiscombinmrptform103117拆卸单汇总表-按拆卸原件idiscombindrptform103118调拨单明细表-按调出仓库iallotdetailrptform103119调拨单明细表-按调入仓库iallotindetailrptform103120组装单明细表-按组装主件icombinmdetailrptform103121组装单明细表-按组装原件icombinddetailrptform103122拆卸单明细表-按拆卸主件idiscombinmdetailrptform103123拆卸单明细表-按拆卸原件idiscombinddetailrptform103124材料消耗明细表--横向按货品detaildrawtypeform103125材料消耗明细表--纵向按原料detaildrawgoodsform103126材料消耗明细表--纵向按产品detaildrawtypeform103127年度累计成本计算单manuyearcostrptform103128费用支出综合统计表ExpenseOutRptForm103129采购退换货汇总表-按货品mpexcpurbygoodsrptform103130采购退换货汇总表-按供应商mpexcpurbyvendorrptform103131采购退换货汇总表-按地区mpexcpurbyarearptform103132采购退换货汇总表-按部门mpexcpurbydeptrptform103133采购退换货汇总表-按业务员mpexcpurbyemployrptform103134采购退换货汇总表-按货品类别mpexcpurbygoodstyperptform103135采购退换货汇总表-按分支机构mpexcpurbyshoprptform103136采购退换货汇总表-按仓库mpexcpurbystorerptform103137销售退换货汇总表-按货品msexcpurbygoodsrptform103138销售退换货汇总表-按客户msexcpurbyvendorrptform103139销售退换货汇总表-按地区msexcpurbyarearptform103140销售退换货汇总表-按部门msexcpurbydeptrptform103141销售退换货汇总表-按业务员msexcpurbyemployrptform103142销售退换货汇总表-按货品类别msexcpurbygoodstyperptform103143销售退换货汇总表-按分支机构msexcpurbyshoprptform103144销售退换货汇总表-按仓库msexcpurbystorerptform103146客户信用额度分析analysecreditbyclientrptform103150待订请购单明细表dpinrequestrptform103151请购单明细表dprequestrptform103153服务反馈明细表dpservicerptform103154维修派工明细表dpmanuorderrptform103155请购单汇总表-按货品mprequestbygoodsrptform103156请购单汇总表-按部门mprequestbydeptrptform103157请购单汇总表-按到货日期mprequestbydaterptform103158待订请购单汇总表mpinrequestrptform103159服务反馈汇总表--按货品mpservicebygoodsrptform103160服务反馈汇总表--按客户mpservicebyclientrptform103161服务反馈汇总表--按地区mpservicebyarearptform103162服务反馈汇总表--按服务人mpservicebyemployrptform103163服务反馈汇总表--按维修类型mpservicebyrepairtyperptform103164服务反馈汇总表--按服务类型mpservicebyservicetyperptform103165服务反馈汇总表--按分支机构mpservicebyshoprptform103166维修派工汇总表--按货品mpmanuorderbygoodsrptform103167维修派工汇总表--按生产车间mpmanuorderbydptrptform103168维修派工汇总表--按生产工人mpmanuorderbyemployrptform103169维修派工汇总表--按往来单位mpmanuorderbyvendorrptform103170维修派工汇总表--按分支机构mpmanuorderbyshoprptform103171维修领料汇总表mprepair_i_drawrptform103172销售毛利明细表-按单据dspr
本文档为【速达ERP 5000数据库表结构】,请使用软件OFFICE或WPS软件打开。作品中的文字与图均可以修改和编辑, 图片更改请在作品中右键图片并更换,文字修改请直接点击文字进行修改,也可以新增和删除文档中的内容。
该文档来自用户分享,如有侵权行为请发邮件ishare@vip.sina.com联系网站客服,我们会及时删除。
[版权声明] 本站所有资料为用户分享产生,若发现您的权利被侵害,请联系客服邮件isharekefu@iask.cn,我们尽快处理。
本作品所展示的图片、画像、字体、音乐的版权可能需版权方额外授权,请谨慎使用。
网站提供的党政主题相关内容(国旗、国徽、党徽..)目的在于配合国家政策宣传,仅限个人学习分享使用,禁止用于任何广告和商用目的。
下载需要: 免费 已有0 人下载
最新资料
资料动态
专题动态
个人认证用户
老张师傅
20余年电工实际工作经验,目前在国企担任电工工程师
格式:doc
大小:1MB
软件:Word
页数:654
分类:管理学
上传时间:2023-03-13
浏览量:31