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

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

MES系统是集成生产管理、品质管理、设备管理、BI数据中心、库存管理、工时管理、数据采集、看板管理等为一体的综合性生产管理系统。通过强调制造过程的透明化，帮助企业由粗放式向精益化管理模式升级。

集成系统:金蝶云星空

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

数据接口配置方案

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

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

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

请求参数

字段名称类型 updBeginTime开始时间string pageSize页数string pageNum页码string updEndTime结束时间string

响应参数

字段名称类型描述 mchIdmchIdstringautoFillResponse createBycreateBystring_autoFillResponse createNamecreateNamestringautoFillResponse checkLabelcheckLabelstring_autoFillResponse createTimecreateTimestringautoFillResponse updateByupdateBystring_autoFillResponse updateNameupdateNamestringautoFillResponse updateTimeupdateTimestring_autoFillResponse remarkremarkstringautoFillResponse companyCodecompanyCodestring_autoFillResponse currentUserBycurrentUserBystringautoFillResponse currentUserNamecurrentUserNamestring_autoFillResponse currentTimecurrentTimestringautoFillResponse filtrationBomStatusfiltrationBomStatusstring_autoFillResponse ididstringautoFillResponse orderUuidorderUuidstring_autoFillResponse orderNoorderNostringautoFillResponse customerUuidcustomerUuidstring_autoFillResponse customerNamecustomerNamestringautoFillResponse orderTypeorderTypestring_autoFillResponse urgentLevelurgentLevelstringautoFillResponse orderDateorderDatestring_autoFillResponse orderStatusorderStatusstringautoFillResponse customerOrderNocustomerOrderNostring_autoFillResponse leaderleaderstringautoFillResponse leaderNameleaderNamestring_autoFillResponse processingTypeprocessingTypestringautoFillResponse picSourcepicSourcestring_autoFillResponse orderPriceorderPricestringautoFillResponse paymentTypepaymentTypestring_autoFillResponse orderDeliveryDateorderDeliveryDatestringautoFillResponse saleOrgsaleOrgstring_autoFillResponse isAnalyseisAnalysestringautoFillResponse mbsOrderBomListmbsOrderBomListarray_autoFillResponse mbsOrderBomList.mchIdmchIdstringautoFillResponse mbsOrderBomList.createBycreateBystring_autoFillResponse mbsOrderBomList.createNamecreateNamestringautoFillResponse mbsOrderBomList.checkLabelcheckLabelstring_autoFillResponse mbsOrderBomList.createTimecreateTimestringautoFillResponse mbsOrderBomList.updateByupdateBystring_autoFillResponse mbsOrderBomList.updateNameupdateNamestringautoFillResponse mbsOrderBomList.updateTimeupdateTimestring_autoFillResponse mbsOrderBomList.remarkremarkstringautoFillResponse mbsOrderBomList.companyCodecompanyCodestring_autoFillResponse mbsOrderBomList.currentUserBycurrentUserBystringautoFillResponse mbsOrderBomList.currentUserNamecurrentUserNamestring_autoFillResponse mbsOrderBomList.currentTimecurrentTimestringautoFillResponse mbsOrderBomList.filtrationBomStatusfiltrationBomStatusstring_autoFillResponse mbsOrderBomList.bomIdbomIdstringautoFillResponse mbsOrderBomList.bomUuidbomUuidstring_autoFillResponse mbsOrderBomList.bomNobomNostringautoFillResponse mbsOrderBomList.orderUuidorderUuidstring_autoFillResponse mbsOrderBomList.orderNoorderNostringautoFillResponse mbsOrderBomList.partNopartNostring_autoFillResponse mbsOrderBomList.gradeNamegradeNamestringautoFillResponse mbsOrderBomList.picNopicNostring_autoFillResponse mbsOrderBomList.orderNumorderNumstringautoFillResponse mbsOrderBomList.giftsNumgiftsNumstring_autoFillResponse mbsOrderBomList.expectProductNumexpectProductNumstringautoFillResponse mbsOrderBomList.unitNameunitNamestring_autoFillResponse mbsOrderBomList.unitNounitNostringautoFillResponse mbsOrderBomList.wholeDeliveryDatewholeDeliveryDatestring_autoFillResponse mbsOrderBomList.deliveryDatedeliveryDatestringautoFillResponse mbsOrderBomList.customerDeliveryDatecustomerDeliveryDatestring_autoFillResponse mbsOrderBomList.bomStatusbomStatusstringautoFillResponse mbsOrderBomList.taxPricetaxPricestring_autoFillResponse mbsOrderBomList.taxPointstaxPointsstringautoFillResponse mbsOrderBomList.untaxedPriceuntaxedPricestring_autoFillResponse mbsOrderBomList.priceUnitNamepriceUnitNamestringautoFillResponse mbsOrderBomList.customerPartNocustomerPartNostring_autoFillResponse mbsOrderBomList.projectNoprojectNostringautoFillResponse mbsOrderBomList.bomRemarkbomRemarkstring_autoFillResponse mbsOrderBomList.patterNopatterNostringautoFillResponse mbsOrderBomList.isBomAnalyseisBomAnalysestring_autoFillResponse mbsOrderBomList.planNumplanNumstringautoFillResponse mbsOrderBomList.planedNumplanedNumstring_autoFillResponse mbsOrderBomList.totalTaxPricetotalTaxPricestringautoFillResponse mbsOrderBomList.totalUntaxedPricetotalUntaxedPricestring_autoFillResponse mbsOrderBomList.fileName2dfileName2dstringautoFillResponse mbsOrderBomList.fileName3dfileName3dstring_autoFillResponse mbsOrderBomList.filePath2dfilePath2dstringautoFillResponse mbsOrderBomList.filePath3dfilePath3dstring_autoFillResponse mbsOrderBomList.fileNamefileNamestringautoFillResponse mbsOrderBomList.filePathfilePathstring_autoFillResponse mbsOrderBomList.fileSuffixfileSuffixstringautoFillResponse mbsOrderBomList.stockNumbstockNumbstring_autoFillResponse mbsOrderBomList.onLineNumonLineNumstringautoFillResponse mbsOrderBomList.pricepricestring_autoFillResponse mbsOrderBomList.picVersionpicVersionstringautoFillResponse mbsOrderBomList.shipmentPlaceshipmentPlacestring_autoFillResponse mbsOrderBomList.stagestagestringautoFillResponse mbsOrderBomList.mbsOrderBomUuidmbsOrderBomUuidstring_autoFillResponse mbsOrderBomList.materialInfoNomaterialInfoNostringautoFillResponse mbsOrderBomList.processingTypeprocessingTypestring_autoFillResponse mbsOrderBomList.bomVersionbomVersionstringautoFillResponse mbsOrderBomList.projectCodeprojectCodestring_autoFillResponse mbsOrderBomList.projectNameprojectNamestringautoFillResponse mbsOrderBomList.outNumboutNumbstring_autoFillResponse mbsOrderBomList.outStatusoutStatusstringautoFillResponse mbsOrderBomList.replaceBomNoreplaceBomNostring_autoFillResponse mbsOrderBomList.bomItembomItemstringautoFillResponse mbsOrderBomList.bomContractNobomContractNostring_autoFillResponse mbsOrderBomList.workNoworkNostringautoFillResponse mbsOrderBomList.singleBomNumsingleBomNumstring_autoFillResponse mbsOrderBomList.cycleNumcycleNumstringautoFillResponse mbsOrderBomList.urgentNeedNourgentNeedNostring_autoFillResponse mbsOrderBomList.internalSpNuminternalSpNumstringautoFillResponse mbsOrderBomList.customerSpNumcustomerSpNumstring_autoFillResponse mbsOrderBomList.urgentLevelurgentLevelstringautoFillResponse mbsOrderBomList.customerOrderNocustomerOrderNostring_autoFillResponse mbsOrderBomList.leaderleaderstringautoFillResponse mbsOrderBomList.leaderNameleaderNamestring_autoFillResponse mbsOrderBomList.centerConcatIdcenterConcatIdstringautoFillResponse mbsOrderBomList.centerConcatValuecenterConcatValuestring_autoFillResponse mbsOrderBomList.addressConcatIdaddressConcatIdstringautoFillResponse mbsOrderBomList.addressConcatValueaddressConcatValuestring_autoFillResponse mbsOrderBomList.addrContactCodeaddrContactCodestringautoFillResponse mbsOrderBomList.addrLocationCodeaddrLocationCodestring_autoFillResponse mbsOrderBomList.contactCodecontactCodestringautoFillResponse mbsOrderBomList.locationCodelocationCodestring_autoFillResponse mbsOrderBomList.jobStatusjobStatusstringautoFillResponse mbsOrderBomList.customerGradeNamecustomerGradeNamestring_autoFillResponse mbsOrderBomList.selectionCertificateselectionCertificatestringautoFillResponse mbsOrderBomList.pendingOrderNumpendingOrderNumstring_autoFillResponse mbsOrderBomList.replaceBomIdreplaceBomIdstringautoFillResponse mbsOrderBomList.receiptsTimereceiptsTimestring_autoFillResponse mbsOrderBomList.isBomConfirmisBomConfirmstringautoFillResponse mbsOrderBomList.shipOrgshipOrgstring_autoFillResponse mbsOrderBomList.custorMoldVercustorMoldVerstringautoFillResponse mbsOrderBomList.analyseNoanalyseNostring_autoFillResponse mbsOrderBomList.planNoplanNostringautoFillResponse mbsOrderBomList.planUuidplanUuidstring_autoFillResponse mbsOrderBomList.projectCodeprojectCodestringautoFillResponse mbsOrderBomList.projectNameprojectNamestring_autoFillResponse mbsOrderBomList.machiningTypemachiningTypestringautoFillResponse mbsOrderBomList.businessUuidbusinessUuidstring_autoFillResponse mbsOrderBomList.omsOrderBomListomsOrderBomListstringautoFillResponse mbsOrderBomList.bomUuidbomUuidstring_autoFillResponse mbsOrderBomList.deleteBomListdeleteBomListstringautoFillResponse mbsOrderBomList.itemCategoryitemCategorystring_autoFillResponse mbsOrderBomList.outStatusoutStatusstringautoFillResponse mbsOrderBomList.isUnifiedisUnifiedstring_autoFillResponse mbsOrderBomList.filePathListfilePathListstringautoFillResponse mbsOrderBomList.totalNumtotalNumstring_autoFillResponse mbsOrderBomList.originalOrderNooriginalOrderNostringautoFillResponse mbsOrderBomList.productTypeproductTypestring_autoFillResponse mbsOrderBomList.auditStatusauditStatusstringautoFillResponse mbsOrderBomList.applyByapplyBystring_autoFillResponse mbsOrderBomList.applyTimeapplyTimestringautoFillResponse mbsOrderBomList.auditByauditBystring_autoFillResponse mbsOrderBomList.auditTimeauditTimestringautoFillResponse mbsOrderBomList.instructinstructstring_autoFillResponse mbsOrderBomList.auditNameauditNamestringautoFillResponse mbsOrderBomList.applyNameapplyNamestring_autoFillResponse mbsOrderBomList.actUseractUserstringautoFillResponse mbsOrderBomList.serialserialstring_autoFillResponse mbsOrderBomList.currencyTypecurrencyTypestringautoFillResponse mbsOrderBomList.listOrderIdlistOrderIdstring_autoFillResponse mbsOrderBomList.confrimNo出库单号string

金蝶云星空接口明细

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日期{{createTime}} FStockOrgId库存组织1 FRetcustId退货客户{{customerUuid}} FSaledeptid销售部门 FHeadNote备注 SubHeadEntity财务信息 SubHeadEntity.FSettleOrgId结算组织1 SubHeadEntity.FSettleCurrId结算币别PRE001 SubHeadEntity.FEntity明细信息details SubHeadEntity.FEntity.FMaterialId物料编码{{details.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仓库{{warehouseCode}} SubHeadEntity.FEntity.FStockLocId仓位_function case '{{locationCode}}' when 1 then '' else '{{locationCode}}' end 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.FReturnType退货类型THLX02_SYS SubHeadEntity.FEntity.FDeliveryDate退货日期{{createTime}} SubHeadEntity.FEntity.FNote备注 SubHeadEntity.FEntity.FSRCTYPE源单类型SAL_OUTSTOCK SubHeadEntity.FEntity.FSRCBillNo源单编号{{confrimNo}}-{{id}} SubHeadEntity.FEntity.FSoorDerno订单单号{{orderNo}} SubHeadEntity.FEntity.F_lyzx_Text客户订单号{{customerOrderNo}} SubHeadEntity.FEntity.FMtoNo计划跟踪号{{bomNo}} SubHeadEntity.FEntity.F_UZMJ_Text1四化入库明细行id{{connectUuid}} SubHeadEntity.FEntity.FEntity_Link关联关系表 SubHeadEntity.FEntity.FEntity_Link.FEntity_Link_FRuleId转换规则OutStock-SalReturnStock SubHeadEntity.FEntity.FEntity_Link.FEntity_Link_FSTableName源单表T_SAL_OUTSTOCKENTRY SubHeadEntity.FEntity.FEntity_Link.FEntity_Link_FSBillId源单内码_findCollection find FID from 850967d0-913d-388f-8d9c-bd554adce7b7 where F_UZMJ_Text5={{connectUuid}} SubHeadEntity.FEntity.FEntity_Link.FEntity_Link_FSId源单分录内码_findCollection find FEntity_FENTRYID from 850967d0-913d-388f-8d9c-bd554adce7b7 where F_UZMJ_Text5={{connectUuid}} SubHeadEntity.FEntity.FormId业务对象表单IdSAL_RETURNSTOCK SubHeadEntity.FEntity.Operation执行的操作Save SubHeadEntity.FEntity.IsAutoSubmitAndAudit提交并审核true SubHeadEntity.FEntity.IsVerifyBaseDataField验证基础资料true SubHeadEntity.FEntity.SubSystemId系统模块21

系统打通概况

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