金蝶云星空和四化智造MES（WEB）单据接口集成

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

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

集成系统:金蝶云星空

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

数据对接方案

数据集成平台对应的配置四化智造MES（WEB）与金蝶云星空的对接只要三步就能完成两个系统之间的数据对接。第一步根据四化智造MES（WEB）的接口参数要求记录在轻易云集成平台。第二步配置四化智造MES（WEB）与金蝶云星空之间的字段对应关系（更多方案可借鉴轻易云数据集成社区论坛中找到相关方案信息）第三步完成方案的检查参数设置：传递时间、重试次数、是否启动、前置条件等上线运行。数据管道ETL：构建一体化的数据融合平台。高级数据转换：支持公式转换数据格式、支持脚本直接进行数据转换、支持可视化多维度数据处理。高性能实时处理：针对不同数据节点类型提供TB级吞吐量，秒级延迟的增量数据处理能力。自动将旧版web服务转变为基于云端微服务的API，统一接口输出标准。支持接口开放服务，实现内外部能力接入。

四化智造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

金蝶云星空接口明细

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

请求参数

字段字段名称类型配置值 FBillTypeID单据类型stringXXXSTHD FBillNo单据编号string{{id}} FSaleOrgId销售组织stringfindCollection find FSaleOrgId_FNumber from 3114d56b-77cd-3f53-9d51-961c12da0ab3 where FSaleOrderEntry_FEntryID={{details_list.oid}} FDate日期string{{check_time}} FStockOrgId库存组织string101 FRetcustId退货客户string_findCollection find FCustId_FNumber from 3114d56b-77cd-3f53-9d51-961c12da0ab3 where FSaleOrderEntry_FEntryID={{details_list.oid}} FSaledeptid销售部门stringfindCollection find FSaleDeptId_Fnumber from 3114d56b-77cd-3f53-9d51-961c12da0ab3 where FSaleOrderEntry_FEntryID={{details_list.oid}} FHeadNote备注string FEntity明细信息arraydetails_list FEntity.FMaterialId物料编码string{{details_list.spec_no}} FEntity.FBarcode零售条形码string FEntity.FRealQty实退数量string{{details_list.goods_count}} FEntity.FAllAmount价税合计string{{details_list.total_amount}} FEntity.FIsFree是否赠品string FEntity.FEntryTaxRate税率%string FEntity.FReturnType退货类型string FEntity.FOwnerTypeId货主类型string FEntity.FOwnerId货主string FEntity.FStockId仓库stringF2313A FEntity.FStocklocId仓位stringH-1 FEntity.FLot批号string FEntity.FDeliveryDate退货日期string FEntity.FNote备注string FEntity.FSRCTYPE源单类型stringSAL_SaleOrder FEntity.FSRCBillNo源单编号string_findCollection find FBillNo from 3114d56b-77cd-3f53-9d51-961c12da0ab3 where FSaleOrderEntry_FEntryID={{details_list.src_oid}} FEntity.FSoorDerno订单单号stringfindCollection find FBillNo from 3114d56b-77cd-3f53-9d51-961c12da0ab3 where FSaleOrderEntry_FEntryID={{details_list.src_oid}} FEntity.FEntity_Link关联关系表array FEntity.FEntity_Link.FEntity_Link_FRuleId转换规则stringSaleOrder-SalReturnStock FEntity.FEntity_Link.FEntity_Link_FSTableName源单表stringT_SAL_OUTSTOCKENTRY FEntity.FEntity_Link.FEntity_Link_FSBillId源单内码string_findCollection find FID from 3114d56b-77cd-3f53-9d51-961c12da0ab3 where FSaleOrderEntry_FEntryID={{details_list.oid}} FEntity.FEntity_Link.FEntity_Link_FSId源单分录内码string{{oid}} FEntity.SubHeadEntity财务信息object FEntity.SubHeadEntity.FSettleOrgId结算组织string_findCollection find FSaleOrgId_FNumber from 3114d56b-77cd-3f53-9d51-961c12da0ab3 where FSaleOrderEntry_FEntryID={{details_list.oid}} FEntity.SubHeadEntity.FSettleCurrId结算币别stringPRE001 FEntity.SubHeadEntity.FormId业务对象表单IdstringSAL_RETURNSTOCK FEntity.SubHeadEntity.Operation执行的操作stringSave FEntity.SubHeadEntity.IsAutoSubmitAndAudit提交并审核booltrue FEntity.SubHeadEntity.IsVerifyBaseDataField验证基础资料boolfalse FEntity.SubHeadEntity.SubSystemId系统模块string21

数据对接价值

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

金蝶云星空和四化智造MES（WEB）单据接口集成