四化智造MES（WEB）、金蝶云星空通过接口配置数据对接

接入系统：四化智造MES（WEB）

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

写入目标:金蝶云星空

金蝶K/3Cloud在总结百万家客户管理最佳实践的基础上，提供了标准的管理模式；通过标准的业务架构：多会计准则、多币别、多地点、多组织、多税制应用框架等，有效支持企业的运营管理；K/3Cloud提供了标准的业务建模：35种标准ERP领域模型、1046种模型元素、21243种模型元素属性组合，288个业务服务构件，让企业及伙伴可快速构建出行业化及个性化的应用。

数据对接方案

系统对接前期需要通过调研公司的业务，规划出最便捷，效率最高的整体流程。通过流程我们需要建立对应的方案来吧这些流程一一的落地，轻易云集成平台开箱即用的、可视化拖、拉、拽实现接口服务编排与聚合。只需要根据指引设定好对应的参数即可启动使用。设定好源平台：四化智造MES（WEB）的接口参数设置，以及设定好目标平台：金蝶云星空的映射，即可启动方案进行测试数据管道ETL：构建一体化的数据融合平台。高级数据转换：支持公式转换数据格式、支持脚本直接进行数据转换、支持可视化多维度数据处理。高性能实时处理：针对不同数据节点类型提供TB级吞吐量，秒级延迟的增量数据处理能力。自动将旧版web服务转变为基于云端微服务的API，统一接口输出标准。支持接口开放服务，实现内外部能力接入。

四化智造MES（WEB）接口明细

API：wms/outstockConfirm/queryOrderReturnOutstockConfirmTaskDetails
NAME：零件入库(作废)
METHOD：GET

请求参数

接口字段名称预设值 pageNum页码1 pageSize页数100 updBeginTime开始时间{{LAST_SYNC_TIME datetime}} updEndTime结束时间{{CURRENT_TIME datetime}}

响应参数

接口字段名称预设值 mchIdmchId createBycreateBy createNamecreateName checkLabelcheckLabel createTimecreateTime updateByupdateBy updateNameupdateName updateTimeupdateTime remarkremark companyCodecompanyCode currentUserBycurrentUserBy currentUserNamecurrentUserName currentTimecurrentTime filtrationBomStatusfiltrationBomStatus idid orderUuidorderUuid orderNoorderNo customerUuidcustomerUuid customerNamecustomerName orderTypeorderType urgentLevelurgentLevel orderDateorderDate orderStatusorderStatus customerOrderNocustomerOrderNo leaderleader leaderNameleaderName processingTypeprocessingType picSourcepicSource orderPriceorderPrice paymentTypepaymentType orderDeliveryDateorderDeliveryDate saleOrgsaleOrg isAnalyseisAnalyse mbsOrderBomListmbsOrderBomList mbsOrderBomList.mchIdmchId mbsOrderBomList.createBycreateBy mbsOrderBomList.createNamecreateName mbsOrderBomList.checkLabelcheckLabel mbsOrderBomList.createTimecreateTime mbsOrderBomList.updateByupdateBy mbsOrderBomList.updateNameupdateName mbsOrderBomList.updateTimeupdateTime mbsOrderBomList.remarkremark mbsOrderBomList.companyCodecompanyCode mbsOrderBomList.currentUserBycurrentUserBy mbsOrderBomList.currentUserNamecurrentUserName mbsOrderBomList.currentTimecurrentTime mbsOrderBomList.filtrationBomStatusfiltrationBomStatus mbsOrderBomList.bomIdbomId mbsOrderBomList.bomUuidbomUuid mbsOrderBomList.bomNobomNo mbsOrderBomList.orderUuidorderUuid mbsOrderBomList.orderNoorderNo mbsOrderBomList.partNopartNo mbsOrderBomList.gradeNamegradeName mbsOrderBomList.picNopicNo mbsOrderBomList.orderNumorderNum mbsOrderBomList.giftsNumgiftsNum mbsOrderBomList.expectProductNumexpectProductNum mbsOrderBomList.unitNameunitName mbsOrderBomList.unitNounitNo mbsOrderBomList.wholeDeliveryDatewholeDeliveryDate mbsOrderBomList.deliveryDatedeliveryDate mbsOrderBomList.customerDeliveryDatecustomerDeliveryDate mbsOrderBomList.bomStatusbomStatus mbsOrderBomList.taxPricetaxPrice mbsOrderBomList.taxPointstaxPoints mbsOrderBomList.untaxedPriceuntaxedPrice mbsOrderBomList.priceUnitNamepriceUnitName mbsOrderBomList.customerPartNocustomerPartNo mbsOrderBomList.projectNoprojectNo mbsOrderBomList.bomRemarkbomRemark mbsOrderBomList.patterNopatterNo mbsOrderBomList.isBomAnalyseisBomAnalyse mbsOrderBomList.planNumplanNum mbsOrderBomList.planedNumplanedNum mbsOrderBomList.totalTaxPricetotalTaxPrice mbsOrderBomList.totalUntaxedPricetotalUntaxedPrice mbsOrderBomList.fileName2dfileName2d mbsOrderBomList.fileName3dfileName3d mbsOrderBomList.filePath2dfilePath2d mbsOrderBomList.filePath3dfilePath3d mbsOrderBomList.fileNamefileName mbsOrderBomList.filePathfilePath mbsOrderBomList.fileSuffixfileSuffix mbsOrderBomList.stockNumbstockNumb mbsOrderBomList.onLineNumonLineNum mbsOrderBomList.priceprice mbsOrderBomList.picVersionpicVersion mbsOrderBomList.shipmentPlaceshipmentPlace mbsOrderBomList.stagestage mbsOrderBomList.mbsOrderBomUuidmbsOrderBomUuid mbsOrderBomList.materialInfoNomaterialInfoNo mbsOrderBomList.processingTypeprocessingType mbsOrderBomList.bomVersionbomVersion mbsOrderBomList.projectCodeprojectCode mbsOrderBomList.projectNameprojectName mbsOrderBomList.outNumboutNumb mbsOrderBomList.outStatusoutStatus mbsOrderBomList.replaceBomNoreplaceBomNo mbsOrderBomList.bomItembomItem mbsOrderBomList.bomContractNobomContractNo mbsOrderBomList.workNoworkNo mbsOrderBomList.singleBomNumsingleBomNum mbsOrderBomList.cycleNumcycleNum mbsOrderBomList.urgentNeedNourgentNeedNo mbsOrderBomList.internalSpNuminternalSpNum mbsOrderBomList.customerSpNumcustomerSpNum mbsOrderBomList.urgentLevelurgentLevel mbsOrderBomList.customerOrderNocustomerOrderNo mbsOrderBomList.leaderleader mbsOrderBomList.leaderNameleaderName mbsOrderBomList.centerConcatIdcenterConcatId mbsOrderBomList.centerConcatValuecenterConcatValue mbsOrderBomList.addressConcatIdaddressConcatId mbsOrderBomList.addressConcatValueaddressConcatValue mbsOrderBomList.addrContactCodeaddrContactCode mbsOrderBomList.addrLocationCodeaddrLocationCode mbsOrderBomList.contactCodecontactCode mbsOrderBomList.locationCodelocationCode mbsOrderBomList.jobStatusjobStatus mbsOrderBomList.customerGradeNamecustomerGradeName mbsOrderBomList.selectionCertificateselectionCertificate mbsOrderBomList.pendingOrderNumpendingOrderNum mbsOrderBomList.replaceBomIdreplaceBomId mbsOrderBomList.receiptsTimereceiptsTime mbsOrderBomList.isBomConfirmisBomConfirm mbsOrderBomList.shipOrgshipOrg mbsOrderBomList.custorMoldVercustorMoldVer mbsOrderBomList.analyseNoanalyseNo mbsOrderBomList.planNoplanNo mbsOrderBomList.planUuidplanUuid mbsOrderBomList.projectCodeprojectCode mbsOrderBomList.projectNameprojectName mbsOrderBomList.machiningTypemachiningType mbsOrderBomList.businessUuidbusinessUuid mbsOrderBomList.omsOrderBomListomsOrderBomList mbsOrderBomList.bomUuidbomUuid mbsOrderBomList.deleteBomListdeleteBomList mbsOrderBomList.itemCategoryitemCategory mbsOrderBomList.outStatusoutStatus mbsOrderBomList.isUnifiedisUnified mbsOrderBomList.filePathListfilePathList mbsOrderBomList.totalNumtotalNum mbsOrderBomList.originalOrderNooriginalOrderNo mbsOrderBomList.productTypeproductType mbsOrderBomList.auditStatusauditStatus mbsOrderBomList.applyByapplyBy mbsOrderBomList.applyTimeapplyTime mbsOrderBomList.auditByauditBy mbsOrderBomList.auditTimeauditTime mbsOrderBomList.instructinstruct mbsOrderBomList.auditNameauditName mbsOrderBomList.applyNameapplyName mbsOrderBomList.actUseractUser mbsOrderBomList.serialserial mbsOrderBomList.currencyTypecurrencyType mbsOrderBomList.listOrderIdlistOrderId mbsOrderBomList.confrimNo出库单号

金蝶云星空接口明细

API：batchSave
NAME：采购入库新增
METHOD：POST

请求参数

接口字段名称预设值 FBillTypeID单据类型XSTHD01_SYS FBillNo单据编号{{backNo}}-{{id}} FSaleOrgId销售组织findCollection find FSaleOrgId_FNumber from 3114d56b-77cd-3f53-9d51-961c12da0ab3 where FSaleOrderEntry_FEntryID={{details_list.oid}} FDate日期{{check_time}} FStockOrgId库存组织1 FRetcustId退货客户{{customerUuid}} FSaledeptid销售部门{{}} FHeadNote备注 SubHeadEntity财务信息 SubHeadEntity.FSettleOrgId结算组织1 SubHeadEntity.FSettleCurrId结算币别PRE001 SubHeadEntity.FEntity明细信息 SubHeadEntity.FEntity.FMaterialId物料编码{{partNo}} SubHeadEntity.FEntity.FBarcode零售条形码 SubHeadEntity.FEntity.FRealQty实退数量{{returnNumb}} SubHeadEntity.FEntity.FPrice单价{{untaxedPrice}} SubHeadEntity.FEntity.FTaxPrice含税单价{{taxPrice}} SubHeadEntity.FEntity.FAllAmount价税合计 SubHeadEntity.FEntity.FIsFree是否赠品_function case '{{details.orderType}}' when '12' then 'true' else 'false' end SubHeadEntity.FEntity.FEntryTaxRate税率%function {{taxPoints}}*100 SubHeadEntity.FEntity.FOwnerTypeId货主类型BD_OwnerOrg SubHeadEntity.FEntity.FOwnerId货主1 SubHeadEntity.FEntity.FStockId仓库F2313A SubHeadEntity.FEntity.FStocklocId仓位H-1 SubHeadEntity.FEntity.FLot批号_function case _findCollection find FIsBatchManage from 80f3f76d-b3eb-3e61-96cd-169790878567 where FNumber={{details.partNo}} endFind when true then '00' else '' end SubHeadEntity.FEntity.FDeliveryDate退货日期{{createTime}} SubHeadEntity.FEntity.FNote备注 SubHeadEntity.FEntity.FSRCTYPE源单类型SAL_OUTSTOCK SubHeadEntity.FEntity.FSRCBillNo源单编号{{confrimNo}} SubHeadEntity.FEntity.FSoorDerno订单单号{{orderNo}} SubHeadEntity.FEntity.F_lyzx_Text客户订单号{{customerOrderNo}} SubHeadEntity.FEntity.FMtoNo计划跟踪号{{bomNo}} SubHeadEntity.FEntity.FEntity_Link关联关系表 SubHeadEntity.FEntity.FEntity_Link.FEntity_Link_FRuleId转换规则OutStock-SalReturnStock SubHeadEntity.FEntity.FEntity_Link.FEntity_Link_FSTableName源单表T_SAL_RETURNSTOCKENTRY SubHeadEntity.FEntity.FEntity_Link.FEntity_Link_FSBillId源单内码_findCollection find FID from 01c90804-5d30-3647-84e5-4b293c9ef8d9 where FSoorDerno={{orderNo}} FMtoNo={{bomNo}} SubHeadEntity.FEntity.FEntity_Link.FEntity_Link_FSId源单分录内码_findCollection find FEntity_FENTRYID from 01c90804-5d30-3647-84e5-4b293c9ef8d9 where FSoorDerno={{orderNo}} FMtoNo={{bomNo}} SubHeadEntity.FEntity.FormId业务对象表单IdSAL_RETURNSTOCK SubHeadEntity.FEntity.Operation执行的操作Save SubHeadEntity.FEntity.IsAutoSubmitAndAudit提交并审核true SubHeadEntity.FEntity.IsVerifyBaseDataField验证基础资料true SubHeadEntity.FEntity.SubSystemId系统模块21

数据对接效果

通过数据集成平台可视化的快速配置调用接口打通四化智造MES（WEB）与金蝶云星空之间的数据接口，使得两个系统之间的对接更加快捷、稳定。轻易云数据集成平台打破信息孤岛、适配多种场景、降低运营成本、缩短开发周期、灵活调度配置是这种多系统数据打通时的特性优势。采用元数据模型驱动的低代码集成工具，基于系统预置的数据模型、映射、编排、日志、脚本等集成核心引擎，通过可视化配置，快速实现客户灵活多变的动态集成需求，让集成开发简单、执行过程可靠、问题风险可控。

四化智造MES（WEB）、金蝶云星空通过接口配置数据对接