速達ERP-5000數(shù)據(jù)庫表結構

1、精選優(yōu)質(zhì)文檔-傾情為你奉上精選優(yōu)質(zhì)文檔-傾情為你奉上專心-專注-專業(yè)專心-專注-專業(yè)精選優(yōu)質(zhì)文檔-傾情為你奉上專心-專注-專業(yè)1采購計劃PPP_PurchasePlanP_PurchasePlandetail2采購訂單POP_OrderP_Orderdetail3估價入庫PVP_ValueP_Valuedetail4采購開單PKP_PurchaseP_Purchasedetail5請購單PRP_RequestP_Requestdetail6進口訂單FQF_ImportOrderF_ImportOrderDetail7進口單證FIF_ImportF_ImportDetail11銷售計劃SPS_S

2、alePlanS_SalePlandetail12銷售訂單SOS_OrderS_Orderdetail13委托代銷SDS_DeputeSaleS_DeputeSaledetail14銷售開單SSS_SaleS_Saledetail15發(fā)出商品SGS_SendOutGoodsS_SendOutGoodsdetail16出口訂單FOF_ExportOrderF_ExportOrderDetail17出口單證FEF_ExportF_ExportDetail18裝箱單FLF_ExportLoadF_ExportLoadDetail21出入庫單IOI_IOStoreI_IOStoredetail22其他

3、收貨單OII_OtherInI_OtherIndetail23其他發(fā)貨單OOI_OtherOutI_OtherOutdetail25領料單DRI_DrawI_Drawdetail26調(diào)撥單ALI_AllotI_Allotdetail27組裝單COI_combinI_combindetail28拆卸單DCI_DisCombinI_DisCombindetail29報損單ATI_AttaintI_Attaintdetail30盤點單BAI_BalItemI_BalItemdetail31調(diào)價單ADI_ADJAPI_ADJAPdetail32貨位調(diào)整單PAI_PlaceAdjustI_PlaceAd

4、justdetail40采購費用分攤PUp_PPurchaseAppp_PPurchaseAppdetail41驗收單MFMNF_FinishedMNF_Finisheddetail42加工單MMMNF_ManuOrderMNF_ManuOrderdetail43主生產(chǎn)計劃MPMNF_ManuPlanMNF_ManuPlan44MRP運算MRMNF_MrpMNF_Mrpdetail45費用分攤MEMNF_ExpenseMNF_Expensedetail46在制品單MWMNF_ManuWorkMNF_ManuWorkdetail47工序計劃單WPW_PlanW_Plandetail48工序流程卡

5、WOW_ProcW_Procdetail49工序交接單WAW_PassW_passItem50工序調(diào)度單WDW_DispatchW_Dispatchdetail51銀行存取款BMB_MoveB_Movedetail52費用開支BEB_ExpenseB_Expensedetail53其他收入BIB_InComeB_InComedetail54委托加工單CMCm_MachiningCm_Machiningdetail55委托加工領料單CDCm_DrawCm_Drawdetail56委托加工驗收單CFCm_FinishedCm_Finisheddetail57委托加工費用單CECm_ExpenseC

6、m_Expensedetail58委托加工費用分攤單CACm_ExpenseAppCm_ExpenseAppdetail61應付款單APA_PayA_Paydetail62應收款單ACA_ChargeA_Chargedetail63往來帳核銷ATA_CounteractA_Counteractdetail64開票管理INdetail65匯兌損益AEA_ExchProlosA_ExchProlosDetail71POS零售單SPPOS_SalePOS_Saledetail72POS出入款單SMPos_inoutcashPos_inoutcashdetail73POS日結單SFPos_closeP

7、os_closedetail74POS儲值卡充值CZpos_savingcardpos_savingcarddetail75POS促銷價調(diào)整CXpos_adjpricepos_adjpricedetail76請配單QDD_RequestD_Requestdetail77配送單DPD_DistributeD_Distributedetail78機會報價單QUcrm_chancecrm_chancedetail79行動單XDcrm_activitycrm_activitydetail80員工檔案HEL_EmployL_Employdetail81入職申請單HAHr_AccessionHr_Acce

8、ssiondetail82離職申請單HDHr_DimissionHr_Dimissiondetail83工作調(diào)動HPHr_JobplacementHr_Jobplacementdetail84用工合同HCHr_LaborcontractHr_Laborcontractdetail85薪金調(diào)整HSHr_StipendadjustHr_Stipendadjustdetail90報檢單QBqlt_applyqlt_applydetail91檢驗單QCqlt_checkupqlt_checkupdetail92項目檢驗單QIqlt_itemcheckupqlt_itemcheckupdetail93內(nèi)

9、檢費用單QEqlt_expenseqlt_expensedetail94設備校驗單QVqlt_deviceqlt_devicedetail111服務反饋單ASCrm_ServiceCrm_Servicedetail112維修派工單AMCrm_ManuorderCrm_Manuorderdetail113維修驗收單AFCrm_FinishedCrm_Finisheddetail114維修發(fā)貨單AGCrm_ConsignmentCrm_Consignmentdetail8001銀行存取款BMAC_MoveAC_Movedetail8002費用開支BEAC_ExpenseAC_Expensedeta

10、il8003其他收入BIAC_InComeAC_InComedetail2402客戶資料clientlistform2403貨品資料goodslistform2404倉庫資料storelistform2405員工資料employlistform2406部門資料departmentlistform2407出納帳戶bankactlistform2410存貨類型gcmlistform2411 員工類型資料emptypelistform2413結算方式paymethodlistform2416出入庫類型iotypelistform2417往來單位案例tradercaselistform2418產(chǎn)品案例

11、goodscaselistform2419備忘錄todolistform2420到期貨品報警maturegoodsform2421超期應收款duegatheringform2422超期應付款duepaymentform2423初始化貨品庫存goodsinitlistform2424往來單位跟蹤價格settraderpricelistform2425車間資料workshoplistform2427分倉庫存onhandlistform2428設置貨品價格setgoodspriceform2430銀行bankdatalistform2431任務類別tasktypelistform2432項目任務jo

12、btasklistform2433項目資料joblistform2434公告信息informationlistform2435公告欄boardlistform2436POS機器posmachinelistform2438柜臺資料poscounterlistform2439會員卡posviplistform2440儲值卡possavingscardlistform2441儲值卡類型possavingstypelistform2442采購訂單到期報警maturedpurchaseorderform2443銷售訂單到期報警maturedsaleorderform2444貨品庫存報警goodsstoc

13、kwarningform2445分支機構資料shoplistform2446單位組unitgrouplistform2447加工類型machiningtypelistform2448委托加工費用名稱machiningexpenselistform2450供應商資料vendorlistform2451替代品資料subgoodslistform2452機構間業(yè)務核算類型betweenshoplistform2454班組資料workgrouplistform2455工作中心workcenterlistform2456工序資料workproclistform2457工藝路線worklinelistfo

14、rm2458資金儲備報警bankactwarningform2459銷售消息模板salemsnmodellistform2460采購消息模板purchasemsnmodellistform2461合同到期報警contractwarningform2462發(fā)送對帳單報警sendwarningform2464維修類型servicetypelistform2465超期待訂請購單報警OverTimeRequestForm2466檢驗項目chkitemlistform2467檢驗地點chkaddrlistform2468檢驗環(huán)境chkconditionlistform2469檢驗設備chkdevicel

15、istform2470檢驗指標chktargetlistform2471抽檢方案chkschemelistform2472質(zhì)量等級chkqlylevellistform2473不良品處理chkwasterlistform2475樣本量字碼表chkgbqtywordlistform2477自定義抽檢規(guī)則chkudefrulelistform2480自定義資料CountryAreaListForm2481國別地區(qū)CountryAreaListForm2482城市港口CityPortListForm2483保險險種InsuranceKindListForm2484貿(mào)易方式TradeMethodLis

16、tForm2485關區(qū)代碼CustomsCodeListForm2486價格術語PriceTermListForm2487Hs編碼CountryAreaListForm2488包裝資料GoodsPackListForm2489訂單條款OrderClauseListForm2490嘜頭資料MarkListForm2491進口訂單到期報警ImportOrderWarnForm2492出口訂單到期報警ExportOrderWarnForm7201文件審批-我未查看文件oa_archiveslistform7202審批類別oa_archivestypelistform7203審批事項oa_action

17、listform7204審批流程oa_archivesflowlistform7205審批模板oa_archivestemplatelistform7208公告管理oa_placardlistform7209新聞管理oa_newslistform7210 通 訊 錄- 個人通訊錄oa_addresslistform7212留言簿oa_messageboardlistform7213工作日記-我的日記oa_diarylistform生產(chǎn)成本計算表manufacturecostrptform采購計劃匯總表 - 公司計劃mpplanbycompanyrptform采購計劃匯總表 - 部門計劃mppl

18、anbydeptrptform采購計劃匯總表 - 業(yè)務員計劃mpplanbyemployrptform采購計劃明細表 - 公司計劃dpplanbycompanyrptform采購計劃明細表 - 部門計劃dpplanbydeptrptform采購計劃明細表 - 業(yè)務員計劃dpplanbyemployrptform采購訂單匯總表 - 按貨品mporderbygoodsrptform采購訂單匯總表 - 按供應商mporderbyvendorrptform采購訂單明細表 - 按貨品dporderbygoodsrptform采購訂單明細表 - 按供應商dporderbyvendorrptform采購開單

19、匯總表 - 按供應商mpbyvendorrptform采購開單匯總表 - 按貨品mpbygoodsrptform采購開單匯總表 - 按倉庫mpbystorerptform采購開單匯總表 - 按業(yè)務員mpbyemployrptform采購開單匯總表 - 按地區(qū)mpbyarearptform采購開單匯總表 - 按貨品類別mpbygoodstyperptform采購開單匯總表 - 按部門mpbydeptrptform采購開單明細表 - 按供應商dpbyvendorrptform采購開單明細表 - 按貨品dpbygoodsrptform采購開單明細表 - 按倉庫dpbystorerptform采購開單

20、明細表 - 按業(yè)務員dpbyemployrptform估價入庫匯總表 - 按供應商mpvaluebyvendorrptform估價入庫匯總表 - 按貨品mpvaluebygoodsrptform估價入庫明細表 - 按供應商dpvaluebyvendorrptform估價入庫明細表 - 按貨品dpvaluebygoodsrptform采購商品折扣匯總表mpgoodsdiscrptform采購商品折扣明細表dpgoodsdiscrptform采購日報表mpdailyrptform流水帳報表timewaterform銷售訂單匯總表 - 按客戶msorderbyclientrptform銷售訂單明細表

21、 - 按客戶dsorderbyclientrptform銷售訂單匯總表 - 按貨品msorderbygoodsrptform銷售訂單明細表 - 按貨品dsorderbygoodsrptform銷售開單匯總表 - 按客戶msbyclientrptform銷售開單明細表-按客戶dsbyclientrptform銷售開單匯總表 - 按貨品msbygoodsrptform銷售開單明細表-按貨品dsbygoodsrptform銷售開單匯總表 - 按業(yè)務員msbyemployrptform銷售開單明細表-按業(yè)務員dsbyemployrptform銷售開單匯總表 - 按倉庫msbystorerptform銷

22、售開單明細表-按倉庫dsbystorerptform銷售毛利匯總表 - 按客戶msprofitbyclientrptform銷售毛利匯總表 - 按業(yè)務員msprofitbyemployrptform銷售毛利匯總表 - 按貨品msprofitbygoodsrptform銷售毛利明細表-按客戶dsprofitbyclientrptform銷售毛利明細表-按業(yè)務員dsprofitbyemployrptform銷售毛利明細表-按貨品dsprofitbygoodsrptform銷售業(yè)績統(tǒng)計表 - 按客戶msgradebyclientrptform銷售業(yè)績統(tǒng)計表 - 按業(yè)務員msgradebyemploy

23、rptform委托代銷匯總表 - 按客戶mastdeputesalebyclientrptform委托代銷匯總表 - 按貨品mastdeputesalebygoodsrptform委托代銷明細表 - 按客戶dsdeputebyclientrptform委托代銷明細表 - 按貨品dsdeputebygoodsrptform委托代銷成本匯總表 - 按貨品mastdeputesalebyapricerptform委托代銷成本明細表 - 按貨品dsdeputebyapricerptform銷售計劃匯總表 - 公司計劃msplanbycompanyrptform銷售計劃匯總表 - 部門計劃msplanb

24、ydeptrptform銷售計劃匯總表 - 業(yè)務員計劃msplanbyemployrptform銷售計劃明細表 - 公司計劃dsplanbycompanyrptform銷售計劃明細表 - 部門計劃dsplanbydeptrptform銷售計劃明細表 - 業(yè)務員計劃dsplanbyemployrptform銷售商品折扣匯總表msgoodsdiscrptform銷售商品折扣明細表dsgoodsdiscrptform銷售開單匯總表 - 按折扣率msbydiscrptform銷售開單明細表-按折扣率dsbydiscrptform銷售開單匯總表 - 按地區(qū)msbyarearptform銷售開單匯總表 -

25、 按貨品類別msbygoodstyperptform銷售開單匯總表 - 按部門msbydeptrptform銷售日報表msdailyrptform采購費用分攤匯總表 - 按供應商mpchargebyvendorrptform采購費用分攤匯總表 - 按倉庫mpchargebystorerptform采購費用分攤匯總表 - 按貨品mpchargebygoodsrptform采購費用分攤明細表 - 按供應商dpchargebyvendorrptform采購費用分攤明細表 - 按倉庫dpchargebystorerptform采購費用分攤明細表 - 按貨品dpchargebygoodsrptform帳

26、面庫存匯總表-按貨品類別MastStockByGoodsTypeRptForm帳面庫存匯總表maststockrptform帳面庫存明細表detailstockrptform實際庫存匯總表maststockqtyrptform實際庫存明細表 - 按基本單位統(tǒng)計detailstockqtyrptform庫存分類匯總表maststockinoutsortarptform倉庫開單匯總表maststockinoutsortbrptform倉庫開單明細表detailstockinoutsortrptform倉庫貨位綜合報表-橫向統(tǒng)計maststockplace_x_rptform庫存報警明細表masts

27、tockwarningrptform個別計價貨品帳面庫存匯總表mastbatchstockrptform個別計價貨品帳面庫存明細表detailbatchstockrptform批次貨品保質(zhì)期清單mastbatchstockvalidaterptform分倉庫存數(shù)量金額表-橫向MastStoreQtyAmtRptForm批號貨品管理匯總表mastbatchnumbergoodsrptform批號貨品管理明細表 - 按基本單位統(tǒng)計detailbatchnumbergoodsrptform帳面庫存數(shù)量匯總表maststoreqtyrptform帳面庫存數(shù)量明細表 - 按基本單位統(tǒng)計detailsto

28、rerptform分倉庫存數(shù)量金額表 - 縱向統(tǒng)計maststoreqtyamt_y_rptform倉庫貨位綜合報表-縱向統(tǒng)計maststockplacerptform帳面庫存數(shù)量明細表 - 按業(yè)務單位統(tǒng)計detailpstorerptform實際庫存明細表 - 按業(yè)務單位統(tǒng)計detailpstockqtyrptform批號貨品管理明細表 - 按業(yè)務單位統(tǒng)計detailpbatchnumbergoodsrptform主生產(chǎn)計劃匯總表mastmanufactureform主生產(chǎn)計劃明細表detailmanufacturerptform加工驗收匯總表mastmanufacturingorderrp

29、tform加工單明細表detailmanufacturingorderrptform直接材料領用匯總表mastdrawitemrptform直接材料領用明細表 - 貨品直接材料領用明細表detaildrawitemrptform委托加工成本計算表MachiningCostRptForm委托加工匯總表-按產(chǎn)品mdeputemanurptform委托加工匯總表-按供應商mdeputemanubyvendorrptform委托加工明細表-按產(chǎn)品ddeputemanurptform委托加工明細表-按供應商ddeputemanubyvendorrptform委托加工綜合匯總表-按產(chǎn)品mddeputema

30、nurptform委托加工綜合匯總表-按供應商mddeputemanubyvendorrptform委托加工領料匯總表-按產(chǎn)品mdrawrptform委托加工領料明細表-按產(chǎn)品ddrawrptform委托加工驗收匯總表-按產(chǎn)品mfinishedrptform委托加工驗收匯總表-按供應商mfinishedbyvendorrptform委托加工驗收明細表-按產(chǎn)品dfinishedrptform委托加工驗收明細表-按供應商dfinishedbyvendorrptform委托加工費用匯總表-按供應商mexpenserptform委托加工費用匯總表-按費用名稱mexpensebyexpenserptfo

31、rm委托加工費用明細表-按供應商dexpenserptform委托加工費用明細表-按費用名稱dexpensebyexpenserptform在制品成本計算表manuworkcostrptform在制品數(shù)量匯總表mastmanuworkrptform在制品數(shù)量明細表-在制品數(shù)量明細detailmanuworkrptform生產(chǎn)日報表ManuDailyRptForm采購價格分析-按貨品analysepurchasepricerptform年度采購比率分析analyseyearpurchaseraterptform采購結構分析-按貨品analysepurstuctrptform年采購量分析-按貨品a

32、nalyseyearpurquantityrptform采購增長分析analysepurchaseincreaseraterptform銷售價格分析-按貨品analysesalepricerptform年度銷售比率分析analyseyearsaleraterptform銷售結構分析-按貨品analysesalestuctrptform年銷售量分析-按貨品analyseyearsalequantityrptform銷售增長分析analysesaleincreaseraterptform年度銷售毛利分析analyseyearsaleprofitrptform邊際庫存量分析analysebounds

33、toreqtyrptform庫存結構分析analysestorestuctrptform庫存貨品周轉(zhuǎn)分析AnalyseYearStoreTurnoverRptForm庫存增長分析analysestoreincreaseraterptform庫存貨品周轉(zhuǎn)分析AnalyseYearStoreTurnoverRptForm應收賬款賬齡分析NULL客戶應收款分析analyseschargerptform應收款周轉(zhuǎn)分析analyseschargeturnoverrptform回款比例分析analysechargestuctrptform回款預測分析analysechargeforecastrptform

34、應付賬款賬齡分析NULL供應商應付款分析analysespayrptform應付款周轉(zhuǎn)分析analysespayturnoverrptform付款比例分析analysepaystuctrptform付款預測分析analysepayforecastrptform采購結構分析-按供應商analysepurstuctbyvendorrptform采購結構分析-按業(yè)務員analysepurstuctbyemployrptform采購結構分析-按分支機構analysepurstuctbyshoprptform銷售結構分析-按客戶analysesalestuctbyclientrptform銷售結構分析-

35、按業(yè)務員analysesalestuctbyemployrptform銷售結構分析-按分支機構analysesalestuctbyshoprptform年采購量分析-按供應商analyseyearpurquantitybyvendorrptform年采購量分析-按業(yè)務員analyseyearpurquantitybyemployrptform年采購量分析-按分支機構analyseyearpurquantitybyshoprptform年銷售量分析-按客戶analyseyearsalequantitybyclientrptform年銷售量分析-按業(yè)務員analyseyearsalequantit

36、ybyemployrptform年銷售量分析-按分支機構analyseyearsalequantitybyshoprptform年度銷售毛利分析-按客戶analyseyearsaleprofitbyclientrptform年度銷售毛利分析-按業(yè)務員analyseyearsaleprofitbyemployrptform年度銷售毛利分析-按分支機構analyseyearsaleprofitbyshoprptform采購價格分析-按供應商analysepurchasepricebyvendorrptform采購價格分析-按分支機構analysepurchasepricebyshoprptform

37、銷售價格分析-按客戶analysesalepricebyclientrptform銷售價格分析-按分支機構analysesalepricebyshoprptform應收款單匯總表mastchargerptform應收款單明細表detailchargerptform應付款單匯總表mastpayedrptform應付款單明細表detailpayedrptform應收款超信用額度報表creditcharge應付款超信用額度報表creditpay采購綜合匯總表-按供應商mdpbyvendorrptform采購綜合匯總表-按貨品mdpbygoodsrptform銷售綜合匯總表-按客戶mdsbyclien

38、trptform銷售綜合匯總表-按貨品mdsbygoodsrptform材料消耗匯總表MastDrawGoodsTypeForm倉庫積壓貨品分析analyseoverstockrptform年度應收款分析MastYearChargeRptForm年度應付款分析MastYearPayRptForm待打印單據(jù)noprintbill待出入庫開單匯總表 - 按貨品msdoutinstorerptform待出入庫開單明細表-按貨品dsdoutinstorerptform待執(zhí)行采購訂單匯總表 - 按供應商mpdealorderbyvendorrptform待執(zhí)行采購訂單匯總表 - 按貨品mpdealord

39、erbygoodsrptform待執(zhí)行采購訂單明細表-按供應商dpdealorderbyvendorrptform待執(zhí)行采購訂單明細表 - 按貨品dpdealorderbygoodsrptform待執(zhí)行銷售訂單匯總表 - 按客戶msdealorderbyclientrptform待執(zhí)行銷售訂單匯總表 - 按貨品msdealorderbygoodsrptform待執(zhí)行銷售訂單明細表 - 按客戶dsdealorderbyclientrptform待執(zhí)行銷售訂單明細表 - 按貨品dsdealorderbygoodsrptform待開采購開單入庫匯總表 - 按貨品mpinbygoodsrptform待

40、開采購開單入庫明細表-按貨品dpinbygoodsrptform待開銷售開單出庫匯總表 - 按貨品msoutbygoodsrptform待開銷售開單出庫明細表 - 按貨品dsoutbygoodsrptform待開采購退貨單出庫匯總表 - 按貨品mpoutbygoodsrptform待開采購退貨單出庫明細表 - 按貨品dpoutbygoodsrptform待開銷售退貨單入庫匯總表 - 按貨品msinbygoodsrptform待開銷售退貨單入庫明細表 - 按貨品dsinbygoodsrptform現(xiàn)金銀行匯總表mastcashrptform現(xiàn)金銀行明細表detailcashrptform驗收單匯

41、總表 - 按生產(chǎn)車間mastfinishedbydeptrptform驗收單匯總表 - 按生產(chǎn)工人mastfinishedbyemprptform驗收單匯總表 - 按產(chǎn)品名稱mastfinishedbyprodrptform驗收單匯總表 - 按加工單號mastfinishedbyrefrptform驗收單明細表 - 按生產(chǎn)車間dfinishedbyworkshoprptform驗收單明細表 - 按生產(chǎn)工人dfinishedbyemprptform驗收單明細表 - 按產(chǎn)品名稱detailfinishedprdimportrptform驗收單明細表 - 按加工單號dfinishedbyrefrpt

42、form應付帳款匯總表sum_payaccountform應付帳款明細帳payaccountform應收帳款匯總表sum_receaccountform應收帳款明細帳receaccountform銷售開單收款情況一覽表salerecedlistrptform采購開單付款情況一覽表purpayedlistrptform收入費用匯總表purpayedlistrptform收入費用明細表purpayedlistrptform待出入庫開單明細表-按往來單位dsdoutintraderrptform待開采購開單入庫明細表 - 按供應商dpinbytraderrptform待開銷售開單出庫明細表 - 按客

43、戶dsoutbytraderrptform待開采購退貨單出庫明細表 - 按供應商dpoutbytraderrptform待開銷售退貨單入庫明細表 - 按客戶dsinbytraderrptform待出入庫開單匯總表 - 按往來單位msdoutintraderrptform待開采購開單入庫匯總表 - 按供應商mpinbytraderrptform待開銷售開單出庫匯總表 - 按客戶msoutbytraderrptform待開采購退貨單出庫匯總表 - 按供應商mpoutbytraderrptformPOS銷售明細表-按儲值卡posdsalebysavecardrptformPOS銷售明細表-按貨品po

44、sdsalebygoodsrptformPOS銷售明細表-按業(yè)務員posdsalebyemployrptformPOS銷售明細表-按柜臺posdsalebycounterrptformPOS銷售明細表-按會員卡posdsalebyviprptform儲值卡銷售匯總表posmsavecardsalerptform儲值卡銷售明細表posdsavecardsalerptform會員卡銷售明細表posdvipsalerptformPOS銷售收款匯總表BaseSQL_POS_RptFormPOS銷售收款明細表BaseSQL_POS_RptForm收銀員出入款匯總表posinoutcashform收銀員出

45、入款明細表posinoutcashdetailformPOS銷售流水賬possalewaterform開票匯總表invoicemastrptform往來單位貨品開票匯總invoicetrgoodsmastrptform往來單位貨品開票明細invoicetrgoodsdetailrptform采購開單開票匯總表invoicempurrptform采購開單開票明細表invoicedpurrptform銷售開單開票匯總表invoicemsalerptform銷售開單開票明細表invoicedsalerptform待開銷售退貨單入庫匯總表 - 按客戶msinbytraderrptform柜臺貨品銷售匯

46、總表-按貨品posmcountersalebygoodsrptform柜臺貨品銷售匯總表-按柜臺posmcountersalebycounterrptform柜臺貨品銷售明細表-按貨品posdcountersalebygoodsrptform柜臺貨品銷售明細表-按柜臺posdcountersalebycounterrptformPOS銷售明細表-按折扣率posdsalebydiscrptform柜臺貨品銷售匯總表-按業(yè)務員posmcountersalebyemployrptform柜臺貨品銷售明細表-按業(yè)務員posdcountersalebyemployrptform柜臺貨品銷售匯總表-業(yè)務員

47、綜合匯總表posmdcountersalebyemployrptform請配單匯總表 - 按貨品mrequestbygoodsrptform請配單匯總表 - 按分支機構貨品mrequestbyshopgoodsrptform請配單匯總表 - 按貨品分支機構mrequestbygoodsshoprptform請配單明細表 - 按貨品drequestbygoodsrptform請配單明細表 - 按分支機構貨品drequestbyshopgoodsrptform請配單明細表 - 按貨品分支機構drequestbygoodsshoprptform配送單收貨匯總表 - 按貨品mdisrbygoodsrp

48、tform配送單收貨匯總表 - 按機構貨品mdisrbyshopgoodsrptform配送單收貨明細表 - 按日期ddisrbygoodsrptform配送單收貨明細表 - 按機構貨品ddisrbyshopgoodsrptform配送單收貨明細表 - 按貨品機構ddisrbygoodsshoprptform配送單明細-按開單日期ddistributerptform配送單發(fā)貨匯總表 - 按貨品mdissbygoodsrptform配送單發(fā)貨匯總表 - 按機構貨品mdissbyshopgoodsrptform配送單發(fā)貨明細表 - 按日期ddissbygoodsrptform配送單發(fā)貨明細表 -

49、按機構貨品ddissbyshopgoodsrptform配送單發(fā)貨明細表 - 按貨品機構ddissbygoodsshoprptform采購開單匯總表 - 按分支機構mpbyshoprptform采購開單明細表 - 按分支機構dpbyshoprptform估價入庫匯總表 - 按分支機構mpvaluebyshoprptform估價入庫明細表 - 按分支機構dpvaluebyshoprptform采購費用分攤匯總表 - 按分支機構mpchargebyshoprptform采購費用分攤明細表 - 按分支機構dpchargebyshoprptform采購綜合匯總表-按分支機構mdpbyshoprptfo

50、rm采購計劃匯總表 - 分支機構計劃mpplanbyshoprptform采購計劃明細表 - 分支機構計劃dpplanbyshoprptform采購訂單匯總表 - 按分支機構mporderbyshoprptform采購訂單明細表 - 按分支機構dporderbyshoprptform銷售計劃匯總表 - 分支機構計劃msplanbyshoprptform銷售計劃明細表 - 分支機構計劃dsplanbyshoprptform銷售訂單匯總表 - 按分支機構msorderbyshoprptform銷售訂單明細表 - 按分支機構dsorderbyshoprptform銷售開單匯總表 - 按分支機構msb

51、yshoprptform銷售開單明細表-按分支機構dsbyshoprptform銷售綜合匯總表-按分支機構mdsbyshoprptform委托代銷匯總表 - 按分支機構mastdeputesalebyshoprptform委托代銷明細表 - 按分支機構dsdeputebyshoprptform銷售毛利匯總表 - 按分支機構msprofitbyshoprptform銷售毛利明細表-按分支機構dsprofitbyshoprptform發(fā)出商品匯總表 - 按分支機構mssendoutbyshoprptform發(fā)出商品明細表 - 按分支機構dssendoutbyshoprptform銷售業(yè)績統(tǒng)計表 -

52、 按分支機構msgradebyshoprptform銷售毛利匯總表 - 按部門msprofitbydeprptform銷售毛利明細表-按部門ssprofitbydeprptform工序計劃匯總表-部門工序計劃匯總表mswplandeptrptform工序計劃匯總表-按工序工序計劃匯總表mswplanworprptform工序計劃匯總表-車間工序計劃匯總表mswplanwosprptform工序計劃匯總表-工作中心工序計劃匯總表mswplanwoctrptform工序計劃匯總表-班組工序計劃匯總表mswplanteamrptform工序計劃明細表dswplandeptrptform工序流程卡匯總

53、表-部門工序流程卡匯總表mswprocdeptrptform工序流程卡匯總表-車間工序流程卡匯總表mswprocwosprptform工序流程卡明細表dswprocdeptrptform產(chǎn)品交接單匯總表-部門工序交接匯總表mswpassdeptrptform產(chǎn)品交接單匯總表-車間工序交接匯總表mswpasswosprptform產(chǎn)品交接單匯總表-按工序交接匯總表mswpassworprptform產(chǎn)品交接單明細表dswpassdeptrptform工序生產(chǎn)情況分析dswprocworkingrptform工序直接材料領用明細表detaildrawworpitemrptform材料消耗明細表-縱

54、向按工序detaildrawworpform加工單完成情況分析匯總表BaseSQL_POS_RptForm加工單完成情況分析明細表DetailFinishedanalyseRptForm按單統(tǒng)計生產(chǎn)成本 - 加工單生產(chǎn)成本計算manufactureordercostrptform按單統(tǒng)計生產(chǎn)成本 - 驗收單生產(chǎn)成本計算manufacturefinedcostrptform主生產(chǎn)計劃生產(chǎn)情況跟蹤表manupalnanywayrptform調(diào)撥單匯總表 - 按調(diào)出倉庫iallotoutsumrptform調(diào)撥單匯總表 - 按調(diào)入倉庫iallotinsumrptform組裝單匯總表 - 按組裝主件i

55、combinmrptform組裝單匯總表 - 按組裝原件icombindrptform拆卸單匯總表 - 按拆卸主件idiscombinmrptform拆卸單匯總表 - 按拆卸原件idiscombindrptform調(diào)撥單明細表 - 按調(diào)出倉庫iallotdetailrptform調(diào)撥單明細表 - 按調(diào)入倉庫iallotindetailrptform組裝單明細表 - 按組裝主件icombinmdetailrptform組裝單明細表 - 按組裝原件icombinddetailrptform拆卸單明細表 - 按拆卸主件idiscombinmdetailrptform拆卸單明細表 - 按拆卸原件idi

56、scombinddetailrptform材料消耗明細表-橫向按貨品detaildrawtypeform材料消耗明細表-縱向按原料detaildrawgoodsform材料消耗明細表-縱向按產(chǎn)品detaildrawtypeform年度累計成本計算單manuyearcostrptform費用支出綜合統(tǒng)計表ExpenseOutRptForm采購退換貨匯總表 - 按貨品mpexcpurbygoodsrptform采購退換貨匯總表 - 按供應商mpexcpurbyvendorrptform采購退換貨匯總表 - 按地區(qū)mpexcpurbyarearptform采購退換貨匯總表 - 按部門mpexcpur

57、bydeptrptform采購退換貨匯總表 - 按業(yè)務員mpexcpurbyemployrptform采購退換貨匯總表 - 按貨品類別mpexcpurbygoodstyperptform采購退換貨匯總表 - 按分支機構mpexcpurbyshoprptform采購退換貨匯總表 - 按倉庫mpexcpurbystorerptform銷售退換貨匯總表 - 按貨品msexcpurbygoodsrptform銷售退換貨匯總表 - 按客戶msexcpurbyvendorrptform銷售退換貨匯總表 - 按地區(qū)msexcpurbyarearptform銷售退換貨匯總表 - 按部門msexcpurbyde

58、ptrptform銷售退換貨匯總表 - 按業(yè)務員msexcpurbyemployrptform銷售退換貨匯總表 - 按貨品類別msexcpurbygoodstyperptform銷售退換貨匯總表 - 按分支機構msexcpurbyshoprptform銷售退換貨匯總表 - 按倉庫msexcpurbystorerptform客戶信用額度分析analysecreditbyclientrptform待訂請購單明細表dpinrequestrptform請購單明細表dprequestrptform服務反饋明細表dpservicerptform維修派工明細表dpmanuorderrptform請購單匯總表

59、 - 按貨品mprequestbygoodsrptform請購單匯總表 - 按部門mprequestbydeptrptform請購單匯總表 - 按到貨日期mprequestbydaterptform待訂請購單匯總表mpinrequestrptform服務反饋匯總表-按貨品mpservicebygoodsrptform服務反饋匯總表-按客戶mpservicebyclientrptform服務反饋匯總表-按地區(qū)mpservicebyarearptform服務反饋匯總表-按服務人mpservicebyemployrptform服務反饋匯總表-按維修類型mpservicebyrepairtyperpt

60、form服務反饋匯總表-按服務類型mpservicebyservicetyperptform服務反饋匯總表-按分支機構mpservicebyshoprptform維修派工匯總表-按貨品mpmanuorderbygoodsrptform維修派工匯總表-按生產(chǎn)車間mpmanuorderbydptrptform維修派工匯總表-按生產(chǎn)工人mpmanuorderbyemployrptform維修派工匯總表-按往來單位mpmanuorderbyvendorrptform維修派工匯總表-按分支機構mpmanuorderbyshoprptform維修領料匯總表mprepair_i_drawrptform銷售毛