速达ERP 5000数据库表结构.docVIP

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