速达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_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样本量字码表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采购计划汇