轻易云
注册体验

四化智造MES(WEB)与金蝶云星空对接集成原材料/标准件采购查询(待采购)打通采购订单新增

1 条评论

四化智造MES(WEB)与金蝶云星空对接集成原材料/标准件采购查询(待采购)打通采购订单新增

金蝶云星空接口

源系统:四化智造MES(WEB)

“MES助力智能制造过程控制:MES管理生产订单的整个生产流程,通过对生产过程的所有突发事件实时监控,自动纠正生产过程中的错误或提供决策支持,以实现生产调度要求;在出现异常或与生产计划偏离太大时,及时反馈相关人员使其采取相应的措施。任务派工:MES在生产计划完成后,自动生成任务派工单,根据生产设备实际加工能力的变化,制定并优化生产的具体过程及各设备的详细操作顺序

集成系统:金蝶云星空

金蝶K/3Cloud(金蝶云星空)是移动互联网时代的新型ERP,是基于WEB2.0与云技术的新时代企业管理服务平台。金蝶K/3Cloud围绕着“生态、人人、体验”,旨在帮助企业打造面向新时代的生态互联与协同平台,围绕生态中的每个角色,提供随手可得的云服务,最终实现敏捷协同,智慧运营的企业运营新境界。整个产品采用SOA架构,完全基于BOS平台组建而成,业务架构上贯穿流程驱动与角色驱动思想,结合中国管理模式与中国管理实践积累,精细化支持企业财务管理、供应链管理、生产管理、供应链协同管理、人力资源管理等核心应用。技术架构上该产品采用平台化构建,支持跨数据库应用,支持本地部署、私有云部署与公有云部署三种部署方式,同时还在公有云上开放中国第一款基于ERP的协同开发云平台。任何一家使用金蝶K/3Cloud产品的企业,其拥有的是包含金蝶在内的众多基于同一个平台提供服务的IT服务伙伴。

系统对接接口配置

集成方案是整个轻易云集成平台的核心,每一个集成方案代表一种业务的对接策略(对接方案借鉴可以在轻易云系统数据集成交流社区bbs.qeasy.cloud 中找到相关信息),用户可以根据业务的不同新建多个不同规则的集成方案。比如:采购订单同步,线上销售出库同步,线下销售出库同步。一个集成方案必须要配置源系统:四化智造MES(WEB),源系统 API:原材料/标准件采购查询(待采购),目标系统:金蝶云星空,目标系统 API采购订单新增。在新增集成方案之前需要确定两个系统的连接器都已经配置完成。
泛微对接

四化智造MES(WEB)接口明细

  • 调用接口:mbs/pur/record/purDetailList
  • 接口名称:原材料/标准件采购查询(待采购)
  • 方法:GET

请求参数

字段字段名称类型配置值 pageNum页码string1 pageSize页数string500 BeginTime开始时间string{{LAST_SYNC_TIME datetime}} EndTime结束时间string{{CURRENT_TIME datetime}} purType采购类型string2 updateTime更新时间string purStatus订单状态string filtrationBomStatus显示与影藏string1

响应参数

字段字段名称类型配置值 mchIdmchIdstring createBycreateBystring createNamecreateNamestring checkLabelcheckLabelstring createTimecreateTimestring updateByupdateBystring updateNameupdateNamestring updateTimeupdateTimestring remarkremarkstring companyCodecompanyCodestring currentUserBycurrentUserBystring currentUserNamecurrentUserNamestring currentTimecurrentTimestring filtrationBomStatusfiltrationBomStatusstring ididstring recordIdrecordIdstring detailIddetailIdstring purIdpurIdstring coefficientcoefficientstring haveDeliveryNumhaveDeliveryNumstring supplierUuidsupplierUuidstring patterNopatterNostring customerDeliveryDatecustomerDeliveryDatestring supplierNamesupplierNamestring supplierFullNamesupplierFullNamestring purRecordUuidpurRecordUuidstring purRecordDetailUuidpurRecordDetailUuidstring purTaskUuidpurTaskUuidstring takeApartDetailUuidtakeApartDetailUuidstring orderUuidorderUuidstring bomUuidbomUuidstring planBomUuidplanBomUuidstring partNopartNostring processNameprocessNamestring gradeNamegradeNamestring picNopicNostring qualityqualitystring purTypepurTypestring outsourcedTypeoutsourcedTypestring outProcessCodeoutProcessCodestring heatTreatmentheatTreatmentstring bomNobomNostring keyNokeyNostring locationCodelocationCodestring barcodebarcodestring purchaseNumpurchaseNumstring purPricepurPricestring purTotalPricepurTotalPricestring reqDatereqDatestring productUuidproductUuidstring outsourcedWayoutsourcedWaystring outsourcedWayListoutsourcedWayListstring locationUuidlocationUuidstring stockNumstockNumstring deliveryDatedeliveryDatestring reqNoreqNostring deptNamedeptNamestring totalDemandNumtotalDemandNumstring productNoproductNostring productNameproductNamestring orderNoorderNostring orderTypeorderTypestring customerNamecustomerNamestring projectCodeprojectCodestring purNopurNostring purReasonpurReasonstring purStatuspurStatusstring backStatusbackStatusstring customerOrderNocustomerOrderNostring deptIddeptIdstring receiveByreceiveBystring receiveTimereceiveTimestring receiveNamereceiveNamestring takeApartTypetakeApartTypestring specspecstring brandbrandstring materialInfoNomaterialInfoNostring craftIdcraftIdstring rawPurchaseWeightrawPurchaseWeightstring rawMaterialInfoNorawMaterialInfoNostring purTaskTypepurTaskTypestring ifMoldifMoldstring taxPricetaxPricestring taxTotalPricetaxTotalPricestring untaxedPriceuntaxedPricestring untaxedTotalPriceuntaxedTotalPricestring taxRatetaxRatestring customerPartNocustomerPartNostring stockTimestockTimestring purchaseUnitNopurchaseUnitNostring purchaseUnitNamepurchaseUnitNamestring returnsNumberreturnsNumberstring replaceModeNoreplaceModeNostring secondPurTypesecondPurTypestring isSecondPurisSecondPurstring checkedNumcheckedNumstring processingFeeprocessingFeestring itemCategoryitemCategorystring stagestagestring projectNameprojectNamestring rawMaterialInforawMaterialInfostring rawPartNorawPartNostring rawGradeNamerawGradeNamestring rawSpecrawSpecstring rawBrandrawBrandstring rawQualityrawQualitystring rawQuantityrawQuantitystring nuclearPriceTaskUuidnuclearPriceTaskUuidstring detailBackStatusdetailBackStatusstring unitNameunitNamestring processingTypeprocessingTypestring beginReqDatebeginReqDatestring endReqDateendReqDatestring beginReceiveTimebeginReceiveTimestring endReceiveTimeendReceiveTimestring beginReplyTimebeginReplyTimestring endReplyTimeendReplyTimestring isAbnormalisAbnormalstring bomVersionbomVersionstring orderNumorderNumstring workNoworkNostring bomContractNobomContractNostring urgentNeedNourgentNeedNostring bomRemarkbomRemarkstring distributeNumdistributeNumstring distributeDatedistributeDatestring purRevokeUuidpurRevokeUuidstring businessUuidbusinessUuidstring filePathfilePathstring fileNamefileNamestring fileSuffixfileSuffixstring fileName2dfileName2dstring filePath2dfilePath2dstring fileName3dfileName3dstring filePath3dfilePath3dstring changeRemarkchangeRemarkstring changeColorchangeColorstring invTypeNameinvTypeNamestring rawUnitNamerawUnitNamestring bomStatusbomStatusstring bomClosebomClosestring shipmentPlaceshipmentPlacestring realNamerealNamestring procuredNumprocuredNumstring taskPurTypetaskPurTypestring moldNomoldNostring purCreateNamepurCreateNamestring uploadFileTimeuploadFileTimestring replyTimereplyTimestring beginPurchaseTimebeginPurchaseTimestring endPurchaseTimeendPurchaseTimestring dispatchNodispatchNostring orderGradeNameorderGradeNamestring orderPartNoorderPartNostring parentMaterialInfoNoparentMaterialInfoNostring closeReasoncloseReasonstring closeUsercloseUserstring closeTimecloseTimestring revokeReasonrevokeReasonstring revokeNamerevokeNamestring revokeTimerevokeTimestring detailStatusdetailStatusstring customerAndUrgentcustomerAndUrgentstring orderNoBomorderNoBomstring singleSetNumsingleSetNumstring receiveNumreceiveNumstring minPurchaseNumminPurchaseNumstring

金蝶云星空接口明细

  • API:batchSave
  • NAME:采购订单新增
  • METHOD:POST

请求参数

接口字段字段名称预设值描述 FBillNo单据编号{{purNo}} FDate采购日期{{createTime}} FPurchaseOrgId采购组织1 FSupplierId供应商{{supplierUuid}} FPurchaserGroupId采购组 FPurchaserId采购员 FBillTypeID单据类型ZZJPO FBusinessType业务类型CG FPOOrderEntry明细信息details FPOOrderEntry.FMaterialId物料编码{{details.partNo}} FPOOrderEntry.FQty采购数量{{details.purchaseNum}} FPOOrderEntry.FEntryDiscountRate折扣率% FPOOrderEntry.FEntryTaxRate税率%function {{details.taxRate}}*100 FPOOrderEntry.FTaxNetPrice净价 FPOOrderEntry.FEntryAmount金额 FPOOrderEntry.FAllAmount价税合计 FPOOrderEntry.FEntryNote备注 FPOOrderEntry.FTaxPrice含税单价{{details.purPrice}} FPOOrderEntry.FEntryTaxAmount税额 FPOOrderEntry.FRowCost行费用 FPOOrderEntry.FDeliveryDate交货日期{{details.reqDate}} FPOOrderEntry.FMtoNo计划跟踪号{{details.bomNo}} FPOOrderEntry.FGiveAway是否赠品_function case '{{details.ifFreebie}}' when '0' then 'true' when '1' then 'false' endtrue false FPOOrderEntry.F_lyzx_Text4模号{{details.patterNo}} FPOOrderEntry.F_lyzx_Text5阶段{{details.stage}} FPOOrderEntry.F_lyzx_Text6客户订单号{{details.customerOrderNo}} FPOOrderEntry.F_lyzx_Text7紧急需求单号{{details.urgentNeedNo}} FPOOrderEntry.F_lyzx_Text8发包单号{{details.bomContractNo}} FPOOrderEntry.F_lyzx_Text9工令单号{{details.workNo}} FPOOrderEntry.F_lyzx_Text10收货城市{{details.shipmentPlace}} FPOOrderEntry.F_lyzx_Text3订单类型function case '{{details.orderType}}' when '11' then '无PO订单' when '1' then '客户订单' when '2' then '备货订单' when '10' then '返修订单' when '12' then '免费打样' when '3' then '异常订单' when '13' then '备货转销售订单' when '14' then '售后维修' when '18' then '直接出库订单' when '22' then '转换订单A' when '23' then '转换订单B' when '24' then '紧急订单' end FPOOrderEntry.F_UZMJ_Text四化明细行id{{details.purRecordDetailUuid}} FPOOrderEntry.F_UZMJ_Text47项目_function case '{{details.itemCategory}}' when '1' then '耳机' when '2' then '手机' when '3' then '散件' when '4' then '设备' end FPOOrderEntry.F_UZMJ_Text8订单号{{details.orderNo}} FPOOrderEntry.F_UZMJ_Text1专案{{details.projectName}} FPOOrderEntry.F_UZMJ_Text2派工案号{{details.bomNo}} FPOOrderEntry.F_UZMJ_Text17件号{{details.keyNo}} FPOOrderEntry.F_UZMJ_Text3单据来源{{details.takeApartType}} FPOOrderEntry.F_UZMJ_Text16回货状态function case '{{details.detailBackStatus}}' when '1' then '未回货' when '2' then '部分回货' when '3' then '已回货' when '4' then '已送货' end FPOOrderEntry.F_UZMJ_Text4替换派工案号 FPOOrderEntry.F_UZMJ_Qty需求数{{details.totalDemandNum}} FPOOrderEntry.F_UZMJ_Text29未税总价{{details.untaxedTotalPrice}} FPOOrderEntry.F_UZMJ_Text30含税总价{{details.purTotalPrice}} FPOOrderEntry.F_UZMJ_Text26条码{{details.barcode}} FPOOrderEntry.F_UZMJ_Text42采购申请人{{details.createName}} FPOOrderEntry.F_UZMJ_Text15业务备注{{details.bomRemark}} FPOOrderEntry.F_UZMJ_Text44客户{{details.customerName}} FPOOrderEntry.F_UZMJ_Text21委外类型_function case '{{details.outsourcedType}}' when '1' then '' when '2' then '包工包料' end FPOOrderEntry.F_UZMJ_Text22委外工序{{details.outProcessCode}} FPOOrderEntry.F_UZMJ_Text23热处理{{details.heatTreatment}} FPOOrderEntry.F_UZMJ_Text24已委外内容{{details.outsourcedWay}} FPOOrderEntry.F_UZMJ_Qty1用量比{{details.singleSetNum}} FPOOrderEntry.F_UZMJ_Text48零件规格{{details.spec}} FPOOrderEntry.F_UZMJ_Text31拒签原因{{details.purReason}} FPOOrderEntry.F_UZMJ_Text11产品名称{{details.orderGradeName}} FPOOrderEntry.F_UZMJ_Text10产品编码{{details.orderPartNo}} FPOOrderEntry.F_sh_id四化采购订单id{{purRecordUuid}} FPOOrderEntry.F_UZMJ_Text18是否核对否 FPOOrderEntry.F_UZMJ_Text50MES订单类型委外采购 FPOOrderEntry.FormId业务对象表单IdPUR_PurchaseOrder必须填写金蝶的表单ID如😛UR_PurchaseOrder FPOOrderEntry.Operation执行的操作BatchSave FPOOrderEntry.IsAutoSubmitAndAudit提交并审核true FPOOrderEntry.IsVerifyBaseDataField验证基础资料true是否验证所有的基础资料有效性,布尔类,默认false(非必录)

数据对接效果

使用全界面可视化配置集成流,快速应对企业的集成需求使得四化智造MES(WEB)与金蝶云星空之间的数据接口一站式的快速集成能力,构建企业数据通道,解决数据孤岛问题。快速构建企业元数据标准、主数据标准、业财数据标准,完成数据的采集、统一、分发、清洗、归集等,帮助企业建立高质量的数据中台。目前轻易云平台已经支持300+系统,同时具备快速适配新系统的能力,集成海量接口数据。无论是对接ERP还是MES、OA、CRM、WMS、OMS等等系统,都可以通过接口相互集成。
轻易云数据集成中台