速达ERP-5000数据库表结构.doc

《速达ERP-5000数据库表结构.doc》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

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_O

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

3、I_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货位调整单

4、PAI_PlaceAdjustI_PlaceAdjustdetail40采购费用分摊PUp_PPurchaseAppp_PPurchaseAppdetail41验收单MFMNF_FinishedMNF_Finisheddetail42加工单MMMNF_ManuOrderMNF_ManuOrderdetail43主生产计划MPMNF_ManuPlanMNF_ManuPlan44MRP运算MRMNF_MrpMNF_Mrpdetail45费用分摊MEMNF_ExpenseMNF_Expensedetail46在制品单MWMNF_ManuWor

5、kMNF_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委托加工领料单C

6、DCm_DrawCm_Drawdetail56委托加工验收单CFCm_FinishedCm_Finisheddetail57委托加工费用单CECm_ExpenseCm_Expensedetail58委托加工费用分摊单CACm_ExpenseAppCm_ExpenseAppdetail61应付款单APA_PayA_Paydetail62应收款单ACA_ChargeA_Chargedetail63往来帐核销ATA_CounteractA_Counteractdetail64开票管理INdetail65汇兑损益AEA_ExchProlosA_

7、ExchProlosDetail71POS零售单SPPOS_SalePOS_Saledetail72POS出入款单SMPos_inoutcashPos_inoutcashdetail73POS日结单SFPos_closePos_closedetail74POS储值卡充值CZpos_savingcardpos_savingcarddetail75POS促销价调整CXpos_adjpricepos_adjpricedetail76请配单QDD_RequestD_Requestdetail77配送单DPD_DistributeD_Distri

8、butedetail78机会报价单QUcrm_chancecrm_chancedetail79行动单XDcrm_activitycrm_activitydetail80员工档案HEL_EmployL_Emp