速达ERP 5000数据库表结构

1 采购PP P_PurchasePlan P_PurchasePlandetail 2 采购订单PO P_Order P_Orderdetail 3 估价入库PV P_Value P_Valuedetail 4 采购开单PK P_Purchase P_Purchasedetail 5 请购单PR P_Request P_Requestdetail 6 进口订单FQ F_ImportOrder F_ImportOrderDetail 7 进口单证FI F_Import F_ImportDetail 11 销售计划SP S_SalePlan S_SalePlandetail 12 销售订单SO S_Order S_Orderdetail 13 委托代销SD S_DeputeSale S_DeputeSaledetail 14 销售开单SS S_Sale S_Saledetail 15 发出商品SG S_SendOutGoods S_SendOutGoodsdetail 16 出口订单FO F_ExportOrder F_ExportOrderDetail 17 出口单证FE F_Export F_ExportDetail 18 装箱单FL F_ExportLoad F_ExportLoadDetail 21 出入库单IO I_IOStore I_IOStoredetail 22 其他收货单OI I_OtherIn I_OtherIndetail 23 其他发货单OO I_OtherOut I_OtherOutdetail 25 领料单DR I_Draw I_Drawdetail 26 调拨单AL I_Allot I_Allotdetail 27 组装单CO I_combin I_combindetail 28 拆卸单DC I_DisCombin I_DisCombindetail 29 报损单AT I_Attaint I_Attaintdetail 30 盘点单BA I_BalItem I_BalItemdetail 31 调价单AD I_ADJAP I_ADJAPdetail 32 货位调整单PA I_PlaceAdjust I_PlaceAdjustdetail 40 采购费用分摊PU p_PPurchaseApp p_PPurchaseAppdetail 41 验收单MF MNF_Finished MNF_Finisheddetail 42 加工单MM MNF_ManuOrder MNF_ManuOrderdetail 43 主生产计划MP MNF_ManuPlan MNF_ManuPlan 44 MRP运算MR MNF_Mrp MNF_Mrpdetail 45 费用分摊ME MNF_Expense MNF_Expensedetail 46 在制品单MW MNF_ManuWork MNF_ManuWorkdetail 47 工序计划单WP W_Plan W_Plandetail 48 工序卡WO W_Proc W_Procdetail 49 工序交接单WA W_Pass W_passItem 50 工序调度单WD W_Dispatch W_Dispatchdetail 51 银行存取款BM B_Move B_Movedetail 52 费用开支BE B_Expense B_Expensedetail 53 其他收入BI B_InCome B_InComedetail 54 委托加工单CM Cm_Machining Cm_Machiningdetail 55 委托加工领料单CD Cm_Draw Cm_Drawdetail 56 委托加工验收单CF Cm_Finished Cm_Finisheddetail 57 委托加工费用单CE Cm_Expense Cm_Expensedetail 58 委托加工费用分摊单CA Cm_ExpenseApp Cm_ExpenseAppdetail 61 应付款单AP A_Pay A_Paydetail 62 应收款单AC A_Charge A_Chargedetail 63 往来帐核销AT A_Counteract A_Counteractdetail 64 开票管理IN detail 65 汇兑损益AE A_ExchProlos A_ExchProlosDetail 71 POS零售单SP POS_Sale POS_Saledetail 72 POS出入款单SM Pos_inoutcash Pos_inoutcashdetail 73 POS日结单SF Pos_close Pos_closedetail 74 POS储值卡充值CZ pos_savingcard pos_savingcarddetail 75 POS促销价调整CX pos_adjprice pos_adjpricedetail 76 请配单QD D_Request D_Requestdetail 77 配送单DP D_Distribute D_Distributedetail 78 机会报价单QU crm_chance crm_chancedetail 79 行动单XD crm_activity crm_activitydetail 80 员工档案HE L_Employ L_Employdetail 81 入职单HA Hr_Accession Hr_Accessiondetail 82 离职申请单HD Hr_Dimission Hr_Dimissiondetail 83 工作调动HP Hr_Jobplacement Hr_Jobplacementdetail 84 用工合同HC Hr_Laborcontract Hr_Laborcontractdetail 85 薪金调整HS Hr_Stipendadjust Hr_Stipendadjustdetail 90 报检单QB qlt_apply qlt_applydetail 91 检验单QC qlt_checkup qlt_checkupdetail 92 项目检验单QI qlt_itemcheckup qlt_itemcheckupdetail 93 内检费用单QE qlt_expense qlt_expensedetail 94 设备校验单QV qlt_device qlt_devicedetail 111 服务反馈单AS Crm_Service Crm_Servicedetail 112 维修派工单AM Crm_Manuorder Crm_Manuorderdetail 113 维修验收单AF Crm_Finished Crm_Finisheddetail 114 维修发货单AG Crm_Consignment Crm_Consignmentdetail 8001 银行存取款BM AC_Move AC_Movedetail 8002 费用开支BE AC_Expense AC_Expensedetail 8003 其他收入BI AC_InCome AC_InComedetail 2402 客户资料clientlistform 2403 货品资料goodslistform 2404 仓库资料storelistform 2405 员工资料employlistform 2406 部门资料departmentlistform 2407 出纳帐户bankactlistform 2410 存货类型gcmlistform 2411 员工类型资料emptypelistform 2413 结算方式paymethodlistform 2416 出入库类型iotypelistform 2417 往来单位案例tradercaselistform 2418 产品案例goodscaselistform 2419 备忘录todolistform 2420 到期货品报警maturegoodsform 2421 超期应收款duegatheringform 2422 超期应付款duepaymentform 2423 初始化货品库存goodsinitlistform 2424 往来单位跟踪价格settraderpricelistform 2425 车间资料workshoplistform 2427 分仓库存onhandlistform 2428 设置货品价格setgoodspriceform 2430 银行bankdatalistform 2431 任务类别tasktypelistform 2432 项目任务jobtasklistform 2433 项目资料joblistform 2434 公告信息informationlistform 2435 公告栏boardlistform 2436 POS机器posmachinelistform 2438 柜台资料poscounterlistform 2439 会员卡posviplistform 2440 储值卡possavingscardlistform 2441 储值卡类型possavingstypelistform 2442 采购订单到期报警maturedpurchaseorderform 2443 销售订单到期报警maturedsaleorderform 2444 货品库存报警goodsstockwarningform 2445 分支机构资料shoplistform 2446 单位组unitgrouplistform 2447 加工类型machiningtypelistform 2448 委托加工费用名称machiningexpenselistform 2450 供应商资料vendorlistform 2451 替代品资料subgoodslistform 2452 机构间业务核算类型betweenshoplistform 2454 班组资料workgrouplistform 2455 工作中心workcenterlistform 2456 工序资料workproclistform 2457 工艺路线worklinelistform 2458 资金储备报警bankactwarningform 2459 销售消息模板salemsnmodellistform 2460 采购消息模板purchasemsnmodellistform 2461 合同到期报警contractwarningform 2462 发送对帐单报警sendwarningform 2464 维修类型servicetypelistform 2465 超期待订请购单报警OverTimeRequestForm 2466 检验项目chkitemlistform 2467 检验地点chkaddrlistform 2468 检验环境chkconditionlistform 2469 检验设备chkdevicelistform 2470 检验指标chktargetlistform 2471 抽检chkschemelistform 2472 质量等级chkqlylevellistform 2473 不良品处理chkwasterlistform 2475 样本量字码表chkgbqtywordlistform 2477 自定义抽检规则chkudefrulelistform 2480 自定义资料CountryAreaListForm 2481 国别地区CountryAreaListForm 2482 城市港口CityPortListForm 2483 保险险种InsuranceKindListForm 2484 贸易方式TradeMethodListForm 2485 关区代码CustomsCodeListForm 2486 价格术语PriceTermListForm 2487 Hs编码CountryAreaListForm 2488 包装资料GoodsPackListForm 2489 订单条款OrderClauseListForm 2490 唛头资料MarkListForm 2491 进口订单到期报警ImportOrderWarnForm 2492 出口订单到期报警ExportOrderWarnForm 7201 文件审批->我未查看文件oa_archiveslistform 7202 审批类别oa_archivestypelistform 7203 审批事项oa_actionlistform 7204 审批流程oa_archivesflowlistform 7205 审批模板oa_archivestemplatelistform 7208 公告管理oa_placardlistform 7209 新闻管理oa_newslistform 7210 通讯录-> [个人通讯录] oa_addresslistform 7212 留言簿oa_messageboardlistform 7213 工作日记->我的日记oa_diarylistform 102050 生产成本计算表manufacturecostrptform 102501 采购计划汇总表- 公司计划mpplanbycompanyrptform 102502 采购计划汇总表- 部门计划mpplanbydeptrptform 102503 采购计划汇总表- 业务员计划mpplanbyemployrptform 102504 采购计划明细表- 公司计划dpplanbycompanyrptform 102505 采购计划明细表- 部门计划dpplanbydeptrptform 102506 采购计划明细表- 业务员计划dpplanbyemployrptform 102507 采购订单汇总表- 按货品mporderbygoodsrptform 102508 采购订单汇总表- 按供应商mporderbyvendorrptform 102509 采购订单明细表- 按货品dporderbygoodsrptform 102510 采购订单明细表- 按供应商dporderbyvendorrptform 102511 采购开单汇总表- 按供应商mpbyvendorrptform 102512 采购开单汇总表- 按货品mpbygoodsrptform 102513 采购开单汇总表- 按仓库mpbystorerptform 102514 采购开单汇总表- 按业务员mpbyemployrptform 102515 采购开单汇总表- 按地区mpbyarearptform 102516 采购开单汇总表- 按货品类别mpbygoodstyperptform 102517 采购开单汇总表- 按部门mpbydeptrptform 102518 采购开单明细表- 按供应商dpbyvendorrptform 102519 采购开单明细表- 按货品dpbygoodsrptform 102520 采购开单明细表- 按仓库dpbystorerptform 102521 采购开单明细表- 按业务员dpbyemployrptform 102522 估价入库汇总表- 按供应商mpvaluebyvendorrptform 102523 估价入库汇总表- 按货品mpvaluebygoodsrptform 102524 估价入库明细表- 按供应商dpvaluebyvendorrptform 102525 估价入库明细表- 按货品dpvaluebygoodsrptform 102526 采购商品折扣汇总表mpgoodsdiscrptform 102527 采购商品折扣明细表dpgoodsdiscrptform 102528 采购日mpdailyrptform 102529 流水帐报表timewaterform 102530 销售订单汇总表- 按客户msorderbyclientrptform 102531 销售订单明细表- 按客户dsorderbyclientrptform 102532 销售订单汇总表- 按货品msorderbygoodsrptform 102533 销售订单明细表- 按货品dsorderbygoodsrptform 102534 销售开单汇总表- 按客户msbyclientrptform 102535 销售开单明细表--按客户dsbyclientrptform 102536 销售开单汇总表- 按货品msbygoodsrptform 102537 销售开单明细表--按货品dsbygoodsrptform 102538 销售开单汇总表- 按业务员msbyemployrptform 102539 销售开单明细表--按业务员 dsbyemployrptform 102540 销售开单汇总表- 按仓库msbystorerptform 102541 销售开单明细表--按仓库dsbystorerptform 102542 销售毛利汇总表- 按客户msprofitbyclientrptform 102543 销售毛利汇总表- 按业务员msprofitbyemployrptform 102544 销售毛利汇总表- 按货品msprofitbygoodsrptform 102545 销售毛利明细表--按客户dsprofitbyclientrptform 102546 销售毛利明细表--按业务员 dsprofitbyemployrptform 102547 销售毛利明细表--按货品dsprofitbygoodsrptform 102548 销售业绩统计表- 按客户msgradebyclientrptform 102549 销售业绩统计表- 按业务员msgradebyemployrptform 102550 委托代销汇总表- 按客户mastdeputesalebyclientrptform 102551 委托代销汇总表- 按货品mastdeputesalebygoodsrptform 102552 委托代销明细表- 按客户dsdeputebyclientrptform 102553 委托代销明细表- 按货品dsdeputebygoodsrptform 102554 委托代销成本汇总表- 按货品mastdeputesalebyapricerptform 102555 委托代销成本明细表- 按货品dsdeputebyapricerptform