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

对接系统四化智造MES（WEB）

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

接通系统：金蝶云星空

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

接口方案配置

异构系统具有非常丰富的业务流程、复杂的系统架构和服务接口。在很多情况下，这两个系统都是分别独立部署和运行的，各自拥有不同的技术栈和编程模型，甚至两者在系统平台、技术平台和编程语言上是完全异构的。那么对接就需要根据接口配置对应的规则，例如取数就要根据查询接口获取四化智造MES（WEB）的数据，并且根据对应的条件进行取数，目标系统就必须根据目标系统的格式，以及获取的数据进行加工处理后进行写入到金蝶云星空中。轻易云集成平台的可视化配置轻松实现。

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

调用接口：wms/outstockConfirm/queryOrderReturnOutstockConfirmTaskDetails
接口名称：业务订单列表查询
方法：GET

请求参数

字段字段名称类型配置值 pageNum页码string1 pageSize页数string100 updBeginTime开始时间string updEndTime结束时间string orderNo订单号string customerName客户名称string customerOrderNo客户PO号string orderType订单类型string orderStatus订单状态string3

响应参数

字段字段名称类型配置值 mchIdmchIdstring createBycreateBystring createNamecreateNamestring checkLabelcheckLabelstring createTimecreateTimestring updateByupdateBystring updateNameupdateNamestring updateTimeupdateTimestring remarkremarkstring companyCodecompanyCodestring currentUserBycurrentUserBystring currentUserNamecurrentUserNamestring currentTimecurrentTimestring filtrationBomStatusfiltrationBomStatusstring ididstring orderUuidorderUuidstring orderNoorderNostring customerUuidcustomerUuidstring customerNamecustomerNamestring orderTypeorderTypestring urgentLevelurgentLevelstring orderDateorderDatestring orderStatusorderStatusstring customerOrderNocustomerOrderNostring leaderleaderstring leaderNameleaderNamestring processingTypeprocessingTypestring picSourcepicSourcestring orderPriceorderPricestring paymentTypepaymentTypestring orderDeliveryDateorderDeliveryDatestring saleOrgsaleOrgstring isAnalyseisAnalysestring mbsOrderBomListmbsOrderBomListarray mbsOrderBomList.mchIdmchIdstring mbsOrderBomList.createBycreateBystring mbsOrderBomList.createNamecreateNamestring mbsOrderBomList.checkLabelcheckLabelstring mbsOrderBomList.createTimecreateTimestring mbsOrderBomList.updateByupdateBystring mbsOrderBomList.updateNameupdateNamestring mbsOrderBomList.updateTimeupdateTimestring mbsOrderBomList.remarkremarkstring mbsOrderBomList.companyCodecompanyCodestring mbsOrderBomList.currentUserBycurrentUserBystring mbsOrderBomList.currentUserNamecurrentUserNamestring mbsOrderBomList.currentTimecurrentTimestring mbsOrderBomList.filtrationBomStatusfiltrationBomStatusstring mbsOrderBomList.bomIdbomIdstring mbsOrderBomList.bomUuidbomUuidstring mbsOrderBomList.bomNobomNostring mbsOrderBomList.orderUuidorderUuidstring mbsOrderBomList.orderNoorderNostring mbsOrderBomList.partNopartNostring mbsOrderBomList.gradeNamegradeNamestring mbsOrderBomList.picNopicNostring mbsOrderBomList.orderNumorderNumstring mbsOrderBomList.giftsNumgiftsNumstring mbsOrderBomList.expectProductNumexpectProductNumstring mbsOrderBomList.unitNameunitNamestring mbsOrderBomList.unitNounitNostring mbsOrderBomList.wholeDeliveryDatewholeDeliveryDatestring mbsOrderBomList.deliveryDatedeliveryDatestring mbsOrderBomList.customerDeliveryDatecustomerDeliveryDatestring mbsOrderBomList.bomStatusbomStatusstring mbsOrderBomList.taxPricetaxPricestring mbsOrderBomList.taxPointstaxPointsstring mbsOrderBomList.untaxedPriceuntaxedPricestring mbsOrderBomList.priceUnitNamepriceUnitNamestring mbsOrderBomList.customerPartNocustomerPartNostring mbsOrderBomList.projectNoprojectNostring mbsOrderBomList.bomRemarkbomRemarkstring mbsOrderBomList.patterNopatterNostring mbsOrderBomList.isBomAnalyseisBomAnalysestring mbsOrderBomList.planNumplanNumstring mbsOrderBomList.planedNumplanedNumstring mbsOrderBomList.totalTaxPricetotalTaxPricestring mbsOrderBomList.totalUntaxedPricetotalUntaxedPricestring mbsOrderBomList.fileName2dfileName2dstring mbsOrderBomList.fileName3dfileName3dstring mbsOrderBomList.filePath2dfilePath2dstring mbsOrderBomList.filePath3dfilePath3dstring mbsOrderBomList.fileNamefileNamestring mbsOrderBomList.filePathfilePathstring mbsOrderBomList.fileSuffixfileSuffixstring mbsOrderBomList.stockNumbstockNumbstring mbsOrderBomList.onLineNumonLineNumstring mbsOrderBomList.pricepricestring mbsOrderBomList.picVersionpicVersionstring mbsOrderBomList.shipmentPlaceshipmentPlacestring mbsOrderBomList.stagestagestring mbsOrderBomList.mbsOrderBomUuidmbsOrderBomUuidstring mbsOrderBomList.materialInfoNomaterialInfoNostring mbsOrderBomList.processingTypeprocessingTypestring mbsOrderBomList.bomVersionbomVersionstring mbsOrderBomList.projectCodeprojectCodestring mbsOrderBomList.projectNameprojectNamestring mbsOrderBomList.outNumboutNumbstring mbsOrderBomList.outStatusoutStatusstring mbsOrderBomList.replaceBomNoreplaceBomNostring mbsOrderBomList.bomItembomItemstring mbsOrderBomList.bomContractNobomContractNostring mbsOrderBomList.workNoworkNostring mbsOrderBomList.singleBomNumsingleBomNumstring mbsOrderBomList.cycleNumcycleNumstring mbsOrderBomList.urgentNeedNourgentNeedNostring mbsOrderBomList.internalSpNuminternalSpNumstring mbsOrderBomList.customerSpNumcustomerSpNumstring mbsOrderBomList.urgentLevelurgentLevelstring mbsOrderBomList.customerOrderNocustomerOrderNostring mbsOrderBomList.leaderleaderstring mbsOrderBomList.leaderNameleaderNamestring mbsOrderBomList.centerConcatIdcenterConcatIdstring mbsOrderBomList.centerConcatValuecenterConcatValuestring mbsOrderBomList.addressConcatIdaddressConcatIdstring mbsOrderBomList.addressConcatValueaddressConcatValuestring mbsOrderBomList.addrContactCodeaddrContactCodestring mbsOrderBomList.addrLocationCodeaddrLocationCodestring mbsOrderBomList.contactCodecontactCodestring mbsOrderBomList.locationCodelocationCodestring mbsOrderBomList.jobStatusjobStatusstring mbsOrderBomList.customerGradeNamecustomerGradeNamestring mbsOrderBomList.selectionCertificateselectionCertificatestring mbsOrderBomList.pendingOrderNumpendingOrderNumstring mbsOrderBomList.replaceBomIdreplaceBomIdstring mbsOrderBomList.receiptsTimereceiptsTimestring mbsOrderBomList.isBomConfirmisBomConfirmstring mbsOrderBomList.shipOrgshipOrgstring mbsOrderBomList.custorMoldVercustorMoldVerstring mbsOrderBomList.analyseNoanalyseNostring mbsOrderBomList.planNoplanNostring mbsOrderBomList.planUuidplanUuidstring mbsOrderBomList.projectCodeprojectCodestring mbsOrderBomList.projectNameprojectNamestring mbsOrderBomList.machiningTypemachiningTypestring mbsOrderBomList.businessUuidbusinessUuidstring mbsOrderBomList.omsOrderBomListomsOrderBomListstring mbsOrderBomList.bomUuidbomUuidstring mbsOrderBomList.deleteBomListdeleteBomListstring mbsOrderBomList.itemCategoryitemCategorystring mbsOrderBomList.outStatusoutStatusstring mbsOrderBomList.isUnifiedisUnifiedstring mbsOrderBomList.filePathListfilePathListstring mbsOrderBomList.totalNumtotalNumstring mbsOrderBomList.originalOrderNooriginalOrderNostring mbsOrderBomList.productTypeproductTypestring mbsOrderBomList.auditStatusauditStatusstring mbsOrderBomList.applyByapplyBystring mbsOrderBomList.applyTimeapplyTimestring mbsOrderBomList.auditByauditBystring mbsOrderBomList.auditTimeauditTimestring mbsOrderBomList.instructinstructstring mbsOrderBomList.auditNameauditNamestring mbsOrderBomList.applyNameapplyNamestring mbsOrderBomList.actUseractUserstring mbsOrderBomList.serialserialstring mbsOrderBomList.currencyTypecurrencyTypestring mbsOrderBomList.listOrderIdlistOrderIdstring

金蝶云星空接口明细

API：batchSave
NAME：销售退货新增
METHOD：POST

请求参数

接口字段字段名称预设值描述 FBillTypeID单据类型XXXSTHD单据类型 FBillNo单据编号{{id}}单据编号 FSaleOrgId销售组织findCollection find FSaleOrgId_FNumber from 3114d56b-77cd-3f53-9d51-961c12da0ab3 where FSaleOrderEntry_FEntryID={{details_list.oid}}组织 FDate日期{{check_time}}日期 FStockOrgId库存组织101组织 FRetcustId退货客户_findCollection find FCustId_FNumber from 3114d56b-77cd-3f53-9d51-961c12da0ab3 where FSaleOrderEntry_FEntryID={{details_list.oid}}基础资料 FSaledeptid销售部门findCollection find FSaleDeptId_Fnumber from 3114d56b-77cd-3f53-9d51-961c12da0ab3 where FSaleOrderEntry_FEntryID={{details_list.oid}}基础资料 FHeadNote备注多行文本 FEntity明细信息details_list FEntity.FMaterialId物料编码{{details_list.spec_no}}基础资料 FEntity.FBarcode零售条形码文本 FEntity.FRealQty实退数量{{details_list.goods_count}}数量 FEntity.FAllAmount价税合计{{details_list.total_amount}}单价 FEntity.FIsFree是否赠品复选框 FEntity.FEntryTaxRate税率%小数 FEntity.FReturnType退货类型单选辅助资料列表 FEntity.FOwnerTypeId货主类型多类别基础资料列表 FEntity.FOwnerId货主多类别基础资料 FEntity.FStockId仓库F2313A基础资料 FEntity.FStocklocId仓位H-1维度关联字段 FEntity.FLot批号批次 FEntity.FDeliveryDate退货日期长日期 FEntity.FNote备注文本 FEntity.FSRCTYPE源单类型SAL_SaleOrder FEntity.FSRCBillNo源单编号_findCollection find FBillNo from 3114d56b-77cd-3f53-9d51-961c12da0ab3 where FSaleOrderEntry_FEntryID={{details_list.src_oid}} FEntity.FSoorDerno订单单号findCollection find FBillNo from 3114d56b-77cd-3f53-9d51-961c12da0ab3 where FSaleOrderEntry_FEntryID={{details_list.src_oid}}文本 FEntity.FEntity_Link关联关系表 FEntity.FEntity_Link.FEntity_Link_FRuleId转换规则SaleOrder-SalReturnStock FEntity.FEntity_Link.FEntity_Link_FSTableName源单表T_SAL_OUTSTOCKENTRY FEntity.FEntity_Link.FEntity_Link_FSBillId源单内码_findCollection find FID from 3114d56b-77cd-3f53-9d51-961c12da0ab3 where FSaleOrderEntry_FEntryID={{details_list.oid}} FEntity.FEntity_Link.FEntity_Link_FSId源单分录内码{{oid}} FEntity.SubHeadEntity财务信息 FEntity.SubHeadEntity.FSettleOrgId结算组织_findCollection find FSaleOrgId_FNumber from 3114d56b-77cd-3f53-9d51-961c12da0ab3 where FSaleOrderEntry_FEntryID={{details_list.oid}}组织 FEntity.SubHeadEntity.FSettleCurrId结算币别PRE001基础资料 FEntity.SubHeadEntity.FormId业务对象表单IdSAL_RETURNSTOCK必须填写金蝶的表单ID如😛UR_PurchaseOrder FEntity.SubHeadEntity.Operation执行的操作Save FEntity.SubHeadEntity.IsAutoSubmitAndAudit提交并审核true FEntity.SubHeadEntity.IsVerifyBaseDataField验证基础资料false是否验证所有的基础资料有效性，布尔类，默认false（非必录） FEntity.SubHeadEntity.SubSystemId系统模块21默认仓库模块

系统对接概况

随着企业数字化业务的深入发展，对于企业的 IT 或者 CIO 来讲，正在面临一个愈发重要的问题——系统的结构太复杂了，尤其是头部企业，至少有十多套系统，这些系统之间的蛛网状的接口如果经常出问题。企业内部以及企业内部与外部建立起越来越多的业务应用系统，如何整合企业的现有IT资源，使企业中计算机孤岛式的应用向集体协作的方向发展，发挥资源效益的最大化，降低企业成本，正在逐渐成为企业关注的重要问题。用户希望企业内所有系统集成在一个平台上，操作统一，以节省培训时间。使用在轻易云应用集成平台 + MDM基础数据平台的解决方案中，轻易云应用集成平台负责实现异构、分布式系统之间互联互通，实现服务API治理以及数据传输交换。通过轻易云预置的各种适配器组件，连接现有各孤立应用系统，以图形化、拖拽方式构建集成流程和服务，提高应用系统集成工作效率，降低异构系统集成风险。针对未来可能出现的业务需求变更，在应用集成平台上进行动态调整，实现各应用系统之间的集成策略平滑升级。

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