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

源系统:四化智造MES（WEB）

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

接通系统：金蝶云星空

金蝶K/3Cloud结合当今先进管理理论和数十万家国内客户最佳应用实践，面向事业部制、多地点、多工厂等运营协同与管控型企业及集团公司，提供一个通用的ERP服务平台。K/3Cloud支持的协同应用包括但不限于：集中/分散销售、集中/分散采购、B2B电商管理、B2C电商中心、供应商协同、多工厂计划、跨工厂领料、跨工厂加工、工厂间调拨、内部交易及结算、集团财务管理、阿米巴经营等。

多系统对接方案配置

通过数据集成平台新增创建集成方案，然后在数据源平台中选择对应的源平台为：四化智造MES（WEB），并且选择对应的连接器（关于四化智造MES（WEB）的接口连接器如何配置可以在轻易云系统数据集成交流社区bbs.qeasy.cloud 中找到相关信息）。选择对应的业务订单列表查询接口作为数据对接来源。然后再通过写入目标平台配置目标系统为金蝶云星空，并且选择对应连接器。选择对应的销售退货新增接口作为数据写入动作，既可以完成第一步的数据对接配置；打破跨系统连接，让数据轻易互通成为现实。

四化智造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出库单号

金蝶云星空接口明细

调用接口：batchSave
接口名称：销售退货新增
方法：POST

请求参数

字段字段名称类型配置值 FBillTypeID单据类型stringXSTHD01_SYS FBillNo单据编号string{{backNo}}-{{id}} FSaleOrgId销售组织stringfindCollection find FSaleOrgId_FNumber from 3114d56b-77cd-3f53-9d51-961c12da0ab3 where FSaleOrderEntry_FEntryID={{details_list.oid}} FDate日期string{{check_time}} FStockOrgId库存组织string1 FRetcustId退货客户string{{customerUuid}} FSaledeptid销售部门string{{}} FHeadNote备注string SubHeadEntity财务信息object SubHeadEntity.FSettleOrgId结算组织string1 SubHeadEntity.FSettleCurrId结算币别stringPRE001 SubHeadEntity.FEntity明细信息array SubHeadEntity.FEntity.FMaterialId物料编码string{{partNo}} SubHeadEntity.FEntity.FBarcode零售条形码string SubHeadEntity.FEntity.FRealQty实退数量string{{returnNumb}} SubHeadEntity.FEntity.FPrice单价string{{untaxedPrice}} SubHeadEntity.FEntity.FTaxPrice含税单价string{{taxPrice}} SubHeadEntity.FEntity.FAllAmount价税合计string SubHeadEntity.FEntity.FIsFree是否赠品string_function case '{{details.orderType}}' when '12' then 'true' else 'false' end SubHeadEntity.FEntity.FEntryTaxRate税率%stringfunction {{taxPoints}}*100 SubHeadEntity.FEntity.FOwnerTypeId货主类型stringBD_OwnerOrg SubHeadEntity.FEntity.FOwnerId货主string1 SubHeadEntity.FEntity.FStockId仓库stringF2313A SubHeadEntity.FEntity.FStockLocId仓位stringH-1 SubHeadEntity.FEntity.FLot批号string_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退货日期string{{createTime}} SubHeadEntity.FEntity.FNote备注string SubHeadEntity.FEntity.FSRCTYPE源单类型stringSAL_OUTSTOCK SubHeadEntity.FEntity.FSRCBillNo源单编号string{{confrimNo}} SubHeadEntity.FEntity.FSoorDerno订单单号string{{orderNo}} SubHeadEntity.FEntity.F_lyzx_Text客户订单号string{{customerOrderNo}} SubHeadEntity.FEntity.FMtoNo计划跟踪号string{{bomNo}} SubHeadEntity.FEntity.FEntity_Link关联关系表array SubHeadEntity.FEntity.FEntity_Link.FEntity_Link_FRuleId转换规则stringOutStock-SalReturnStock SubHeadEntity.FEntity.FEntity_Link.FEntity_Link_FSTableName源单表stringT_SAL_RETURNSTOCKENTRY SubHeadEntity.FEntity.FEntity_Link.FEntity_Link_FSBillId源单内码string_findCollection find FID from 01c90804-5d30-3647-84e5-4b293c9ef8d9 where FSoorDerno={{orderNo}} FMtoNo={{bomNo}} SubHeadEntity.FEntity.FEntity_Link.FEntity_Link_FSId源单分录内码string_findCollection find FEntity_FENTRYID from 01c90804-5d30-3647-84e5-4b293c9ef8d9 where FSoorDerno={{orderNo}} FMtoNo={{bomNo}} SubHeadEntity.FEntity.FormId业务对象表单IdstringSAL_RETURNSTOCK SubHeadEntity.FEntity.Operation执行的操作stringSave SubHeadEntity.FEntity.IsAutoSubmitAndAudit提交并审核booltrue SubHeadEntity.FEntity.IsVerifyBaseDataField验证基础资料booltrue SubHeadEntity.FEntity.SubSystemId系统模块string21

数据对接价值

全面支持数据集成操作可视化、拖拽流式开发，无代码完成多套异构系统集成，降低使用门槛，提升交付速度。特别是在面向四化智造MES（WEB）、金蝶云星空间API接口集成时，通过对API的设计、创建、测试、部署、集成、管理、运维、下线等全生命周期管理，帮助企业洞察运营状况，进一步优化流程，提高企业商业价值。基于Web图形界面，通过拖拽、连接、配置完成流程设计，数据整合和集成，高效打通业务系统，通过面向运营的统计报表，直观查看API各项指标，实现对全局和项目层级双维度的监控管理。再通过轻易云数据集成中台通过统一门户注册管理，将业务以API的方式对外开放，实现业务创新、能力输出。

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