您的当前位置:首页正文

最新5000ERP数据库对照表

2021-08-29 来源:个人技术集锦
basesourceiddatasetname1l_area2l_tradertype3d_shop4l_trader5l_employ6l_department7l_emptype8l_gcm9l_goodstype10l_goodsunit11l_goods12p_order13L_IOType14l_store15l_chkaql16l_data17l_data18l_data19l_data20l_chkcondition21l_chkdevice22l_chktarget23m_operator24l_trader25i_iostore26mnf_manuplan27I_OtherIn28mnf_workshop29I_OtherOut30mnf_manuorder31l_place32I_Draw33l_trader34l_billtype37i_iostoredetail38I_OtherIndetail39I_OtherOutdetail40mnf_manuorderdetail41mnf_manuordersub42mnf_finished43mnf_finisheditem44mnf_finisheddetail45mnf_finishedbatch46mnf_manuwork47mnf_manuworkitem48mnf_manuworkdetaildatasetcname地区往来类型分支机构供应商员工资料部门资料员工类型存货类型货品类别货品单位货品资料采购订单出入库类型仓库资料AQL值检验项目检验地点质量等级不良品处理方式检验环境检验设备检验指标操作员客户出入库单主生产计划其他收货单车间资料其他发货单加工单货位领料单往来单位单据类型出入库单明细其他收货单明细其他发货单明细加工单明细加工单替代品验收单验收单明细验收单从表验收单用料分配表在制品单在制品单明细在制品单从表4950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939496I_DrawdetailI_AllotI_Allotdetaili_iostoreplacei_iostorebatchmnf_expensemnf_expensedetailam_kindI_combinI_combindetailI_DisCombinI_DisCombindetailI_AttaintI_Attaintdetailp_orderdetailcrm_linkmancm_machiningcm_machiningdetailcm_machiningsubmnf_manuorderprocI_BalItemI_BalItemdetailI_adjapI_adjapdetailI_PlaceAdjustcm_drawcm_drawdetailcm_finishedcm_finisheddetailcm_finishedbatchp_valueoa_actionoa_addressgroupoa_addresslistoa_archivesoa_archivestemplateoa_messageboardoa_newsoa_diaryl_machiningtypeI_PlaceAdjustdetailmnf_workcenterp_valuedetailcrm_tradercm_expensecm_expensedetailcm_expenseapp领料单明细调拨单调拨单明细出入库货位表出入库批号表生产费用分摊生产费用分摊明细运输方式组装单组装单明细拆卸单拆卸单明细报损单报损单明细采购订单明细联系人委托加工单委托加工单明细委托加工替代品加工单工序盘点单盘点单明细调价单调价单明细货位调整单委托加工领料单委托加工领料单明细委托加工验收单委托加工验收单明细委托加工验收用料分配估价入库审批事项通讯录分组通讯录个人信息文件审批审批模板留言薄新闻管理工作日记加工类型货位调整单明细工作中心估价入库明细客户管理委托加工费用单委托加工费用单明细委托加工费用分摊单979899100101103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144cm_expenseappfinishedcm_expenseappexpensecrm_chancecrm_activityl_servicetypep_purchasep_purchasedetaill_machiningexpenseW_PlanW_PlandetailW_Plandetail_divcrm_servicew_procw_procdetailw_procdetail_divw_procdetail_div2w_dispatchw_dispatchdetailCrm_ManuorderCrm_ManuorderdetailCrm_FinishedCrm_FinisheddetailCrm_ConsignmentCrm_Consignmentdetailp_requestd_requestd_requestdetaild_distributed_distributedetailqlt_applyqlt_applydetailqlt_checkupqlt_checkupdetailp_ppurchaseAppp_ppurchaseAppdetailmnf_workgroupp_requestdetailp_purchasePlanp_purchasePlandetails_saleplans_saleplandetails_orders_orderdetaill_chkudefrulecrm_chancedetaill_chkschemel_chkudefruledetail委托加工费用分摊明细委托加工费用分摊从表机会报价单行动单维修类型采购开单采购开单明细委托加工费用名称工序计划单工序计划单明细工序计划单从表服务反馈单工序流程卡工序流程卡明细工序流程卡排产工序流程卡明细工序调度单工序调度单明细维修派工单维修派工单明细维修验收单维修验收材料分配维修发货单维修发货材料请购单请配单请配单明细配送单配送单明细报检单报检单明细检验单检验单明细采购费用分摊采购费用分摊明细班组资料请购单明细采购计划采购计划明细销售计划销售计划明细销售订单销售订单明细自定义抽检规则机会报价单明细抽检方案自定义抽检规则明细145146147148149150151152153154156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192s_deputesales_deputesaledetaill_chkschemedetailqlt_expenseqlt_expensedetails_sendoutgoodss_sendoutgoodsdetails_sales_saledetailqlt_expenseitemqlt_itemcheckupqlt_itemcheckupdetailhr_employsubjoinhr_employeducatehr_employworkexperiencehr_employsocietyhr_jobplacementl_counterl_counterrateB_MoveB_ExpenseB_ExpensedetailB_InComeB_InComedetailA_PayA_PaydetailA_ChargeA_ChargedetailA_CounteractA_Counteractdetailqlt_deviceqlt_devicedetailoa_archivestypeoa_flowtypeoa_archivesoa_archivesdam_kindhr_accessionhr_accessiondetailac_accountal_subjectal_projectal_cashflowal_credtypeal_briefal_brieftypeal_subtype委托代销委托代销明细抽检方案细表内检费用单内检费用单明细发出商品发出商品明细销售开单销售开单明细内检费用单项目检验单项目检验单明细详细信息受教育程度工作经历社会关系工作调动柜台资料柜台提成比率银行存取款费用开支费用开支其他收入其他收入应付款单应付款单单据明细应收款单应收款单单据明细往来帐核销往来帐核销设备检验单设备检验单明细审批类别审批流程文件审批编辑文件审批编辑明细用工形式入职申请单入职申请单明细出纳帐户科目项目现金流量项目凭证字凭证摘要凭证摘要类型科目类别193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239aa_oweagel_unital_bankal_moneyl_paymethodl_ietypeal_wgcountitemtypeal_wgcountitemal_wageitemal_wgfeetypeal_fatypeal_fastatusal_fanewtypeal_fadeltypeal_shoptypel_goodstypel_emptypeal_fadeprmethodcrm_comminfohr_dimissionhr_dimissiondetailaa_credhr_jobplacementdetailhr_stipendadjusthr_stipendadjustdetailhr_LaborContractcrm_countrycrmv_clientstatecrmv_custtypecrmv_clientsourcecrmv_industrytypecrmv_chancetypecrmv_servicetypecrm_Affixinfoam_kindpos_salepos_saledetailpos_savingcardpos_savingcarddetailpos_inoutcashpos_closepos_closedetailpos_adjpricepos_adjpricedetailcrmv_expensecrmv_expensedetailcrm_schedule帐龄区间计量单位银行币种结算方式费用项目计件工种计件工序工资项目定义工资项目类别固定资产类别固定资产使用状况固定资产增加方式固定资产减少方式机构往来货品类型员工类型折旧方法客户信息离职申请单离职申请单明细凭证工作调动明细薪金调整薪金调整明细用工合同国家地区客户状态客户类型客户来源行业类型机会流程服务类型客户图片学历POS零售单POS零售单明细POS储值卡充值POS储值卡充值明细POS出入款单POS日结单POS日结单明细POS促销价调整POS促销价调整明细费用管理费用管理明细日程安排240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269271274275276277278279280281282284285286287288289290crm_email邮件管理crm_emaildetail邮件管理明细crm_emailattachments邮件附件crmv_invoicetype发票类型l_machinePOS机器l_classPOS班次l_savingstype储值卡类型l_savingscard储值卡l_vip会员卡l_chkgoodsinfo货品质检信息fn_purchase货品采购报表fn_B_Expense费用分析fn_AnalysisOfdpturnover各部门人员流动情况分析fn_Sum_Pay供应商、业务员应付款分析fn_Sum_Rece客户、业务员、部门应收款分析fn_AnalyseRecvAmoun应收账龄分析fn_AnalysisOfYearRece年度客户欠款分析fn_AnalysisOfOverTimeReceAcoun超期应收款分析fn_AnalysisOfClientSaleRece销售回款分析fn_futureMoneyRpt未来资金收支预测fn_PurOrderAnalyse采购订单执行情况分析fn_MSProfitByClientRp销售毛利汇总表fn_GoodsPSMonthly货品采购销售月报fn_EverydayMoneyRpt资金日报表fn_goodssale货品销售报表fn_SaleList销售排行榜fn_PurPriceAnalyse采购价格分析fn_YearOrderAnalyse年度货品销售分析fn_EverymonthMoneyRpt资金月报表l_country国别地区l_data城市港口l_data保险险种l_data贸易方式l_data关区代码l_data价格术语l_hsHS编码l_orderclause订单条款am_kind订单类型l_mark唛头资料l_goodspack包装资料am_kind物料监管类型am_kind保税监管类型f_importorder进口订单f_importorderdetail进口订单明细f_importorderclause进口订单其他条款f_exportorder出口订单f_exportorderdetail出口订单明细291292293296297298299300301302303306307308309310312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341f_exportorderclausef_exportloadf_Importf_exportf_exportloaddetailf_importdetailf_exportdetailf_importLoadf_importapplyf_importtaxamtf_exportapplyfn_ImportOrderDetailfromar_customrptmfn_ImportOrderPerfromfn_ImportOrderGoodsPerfromfn_CompRunStateRptfn_ExportOrderDetailfromfn_ExportOrderPerfromfn_ExportOrderGoodsPerfromam_kindcrm_affixinfoa_paychilda_chargechildcrm_emailsetservercrm_servicetracka_exchprolosa_exchprolosdetailcrm_operateinfocrm_finisheditemcrm_smscrm_smsdetailaa_creditemcrm_supplyoa_billflowoa_billarchivesam_kindOA_FlowTypedCrm_Consignmentitemoa_newsdoa_placardam_kindl_goodsunitaa_onhandaa_onhandbatchaa_billflow_deputeaa_billflow出口订单条款出口装箱单进口单证出口单证出口装箱单明细进口单证明细出口单证明细进口单证装箱明细进口单证报关明细进口单证分摊税金明细出口单证报关明细进口订单明细情况表会计报表分类进口订单执行情况明细表进口订单执行情况明细物品表公司经营状况一览表出口订单明细情况表出口订单执行情况明细表出口订单执行情况明细物品表紧急程度货品图片应付款付款明细应收款收款明细邮箱设置服务跟踪汇兑损益汇兑损益明细用户记录维修验收明细单短信管理主表短信管理明细表凭证明细供求产品业务审批定义业务审批开单样式审批流程细表维修发货明细单新闻管理公告管理信息类型货品单位实际库存批次实际库存虚拟仓底稿表底稿342343344345346347348aa_storebalanceaa_billflowbatchl_traderbalanceaa_traderbalancel_goodsbommnf_worklinemnf_worklined库存月结表批次底稿客户往来账款表客户往来月结表物料清单工艺路线主表工艺路线明细

因篇幅问题不能全部显示,请点此查看更多更全内容