金蝶云星空与四化智造MES（WEB）对接集成业务订单列表查询连通生产入库单新增(生产入库确认退货-生产退库单-run)

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

MES建立统一平台上通过物料防错防错、流程防错、生产统计、异常处理、信息采集和全流程追溯等精益生产和精细化管理，帮助企业合理安排生产排程、优化工艺流程、改善产品质量、降低能源损耗、降低制造成本，提高执行效率，全面提升和改善企业制造能力，为企业打造可视化、透明化、数字化、智能化工厂。通过手机移动APP实时的数据查询和分析报表，为企业高层提供快速决策支持，以便针对市场变化快速准确地作出反应，综合提升企业的市场竞争力。

写入目标:金蝶云星空

金蝶K/3Cloud（金蝶云星空）是移动互联网时代的新型ERP，是基于WEB2.0与云技术的新时代企业管理服务平台。金蝶K/3Cloud围绕着“生态、人人、体验”，旨在帮助企业打造面向新时代的生态互联与协同平台，围绕生态中的每个角色，提供随手可得的云服务，最终实现敏捷协同，智慧运营的企业运营新境界。整个产品采用SOA架构，完全基于BOS平台组建而成，业务架构上贯穿流程驱动与角色驱动思想，结合中国管理模式与中国管理实践积累，精细化支持企业财务管理、供应链管理、生产管理、供应链协同管理、人力资源管理等核心应用。技术架构上该产品采用平台化构建，支持跨数据库应用，支持本地部署、私有云部署与公有云部署三种部署方式，同时还在公有云上开放中国第一款基于ERP的协同开发云平台。任何一家使用金蝶K/3Cloud产品的企业，其拥有的是包含金蝶在内的众多基于同一个平台提供服务的IT服务伙伴。

数据集成方案配置

轻易云集成平台的对接是通过一个个对应的对接方案去形成两个系统对接的连线，所以对接方案的配置极其重要，方案可以选择一键复制，轻易云有海量的对接方案可支持一键复制，复制后直接启动使用（对接方案借鉴可以在轻易云系统数据集成交流社区bbs.qeasy.cloud 中找到相关信息。或者可以通过手工配置，配置只要确认源平台：四化智造MES（WEB）的取数逻辑，例如什么时间取什么样的数据。即可完成配置，目标平台：金蝶云星空，把获取的数据组装成目标系统需要的格式进行写入。

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

API：wms/instockConfirm/queryConfirmRebackTaskDetail
NAME：业务订单列表查询
METHOD：GET

请求参数

接口字段字段名称预设值描述 pageNum页码1页码 pageSize页数100页数 rebackStartTime开始时间{{LAST_SYNC_TIME datetime}}开始时间 rebackEndTime结束时间{{CURRENT_TIME datetime}}结束时间 taskType入库类型5客户PO号

响应参数

接口字段字段名称预设值描述 mchIdmchIdautoFillResponse createBycreateBy_autoFillResponse createNamecreateNameautoFillResponse checkLabelcheckLabel_autoFillResponse createTimecreateTimeautoFillResponse updateByupdateBy_autoFillResponse updateNameupdateNameautoFillResponse updateTimeupdateTime_autoFillResponse remarkremarkautoFillResponse companyCodecompanyCode_autoFillResponse currentUserBycurrentUserByautoFillResponse currentUserNamecurrentUserName_autoFillResponse currentTimecurrentTimeautoFillResponse filtrationBomStatusfiltrationBomStatus_autoFillResponse ididautoFillResponse orderUuidorderUuid_autoFillResponse orderNoorderNoautoFillResponse customerUuidcustomerUuid_autoFillResponse customerNamecustomerNameautoFillResponse orderTypeorderType_autoFillResponse urgentLevelurgentLevelautoFillResponse orderDateorderDate_autoFillResponse orderStatusorderStatusautoFillResponse customerOrderNocustomerOrderNo_autoFillResponse leaderleaderautoFillResponse leaderNameleaderName_autoFillResponse processingTypeprocessingTypeautoFillResponse picSourcepicSource_autoFillResponse orderPriceorderPriceautoFillResponse paymentTypepaymentType_autoFillResponse orderDeliveryDateorderDeliveryDateautoFillResponse saleOrgsaleOrg_autoFillResponse isAnalyseisAnalyseautoFillResponse mbsOrderBomListmbsOrderBomList_autoFillResponse mbsOrderBomList.mchIdmchIdautoFillResponse mbsOrderBomList.createBycreateBy_autoFillResponse mbsOrderBomList.createNamecreateNameautoFillResponse mbsOrderBomList.checkLabelcheckLabel_autoFillResponse mbsOrderBomList.createTimecreateTimeautoFillResponse mbsOrderBomList.updateByupdateBy_autoFillResponse mbsOrderBomList.updateNameupdateNameautoFillResponse mbsOrderBomList.updateTimeupdateTime_autoFillResponse mbsOrderBomList.remarkremarkautoFillResponse mbsOrderBomList.companyCodecompanyCode_autoFillResponse mbsOrderBomList.currentUserBycurrentUserByautoFillResponse mbsOrderBomList.currentUserNamecurrentUserName_autoFillResponse mbsOrderBomList.currentTimecurrentTimeautoFillResponse mbsOrderBomList.filtrationBomStatusfiltrationBomStatus_autoFillResponse mbsOrderBomList.bomIdbomIdautoFillResponse mbsOrderBomList.bomUuidbomUuid_autoFillResponse mbsOrderBomList.bomNobomNoautoFillResponse mbsOrderBomList.orderUuidorderUuid_autoFillResponse mbsOrderBomList.orderNoorderNoautoFillResponse mbsOrderBomList.partNopartNo_autoFillResponse mbsOrderBomList.gradeNamegradeNameautoFillResponse mbsOrderBomList.picNopicNo_autoFillResponse mbsOrderBomList.orderNumorderNumautoFillResponse mbsOrderBomList.giftsNumgiftsNum_autoFillResponse mbsOrderBomList.expectProductNumexpectProductNumautoFillResponse mbsOrderBomList.unitNameunitName_autoFillResponse mbsOrderBomList.unitNounitNoautoFillResponse mbsOrderBomList.wholeDeliveryDatewholeDeliveryDate_autoFillResponse mbsOrderBomList.deliveryDatedeliveryDateautoFillResponse mbsOrderBomList.customerDeliveryDatecustomerDeliveryDate_autoFillResponse mbsOrderBomList.bomStatusbomStatusautoFillResponse mbsOrderBomList.taxPricetaxPrice_autoFillResponse mbsOrderBomList.taxPointstaxPointsautoFillResponse mbsOrderBomList.untaxedPriceuntaxedPrice_autoFillResponse mbsOrderBomList.priceUnitNamepriceUnitNameautoFillResponse mbsOrderBomList.customerPartNocustomerPartNo_autoFillResponse mbsOrderBomList.projectNoprojectNoautoFillResponse mbsOrderBomList.bomRemarkbomRemark_autoFillResponse mbsOrderBomList.patterNopatterNoautoFillResponse mbsOrderBomList.isBomAnalyseisBomAnalyse_autoFillResponse mbsOrderBomList.planNumplanNumautoFillResponse mbsOrderBomList.planedNumplanedNum_autoFillResponse mbsOrderBomList.totalTaxPricetotalTaxPriceautoFillResponse mbsOrderBomList.totalUntaxedPricetotalUntaxedPrice_autoFillResponse mbsOrderBomList.fileName2dfileName2dautoFillResponse mbsOrderBomList.fileName3dfileName3d_autoFillResponse mbsOrderBomList.filePath2dfilePath2dautoFillResponse mbsOrderBomList.filePath3dfilePath3d_autoFillResponse mbsOrderBomList.fileNamefileNameautoFillResponse mbsOrderBomList.filePathfilePath_autoFillResponse mbsOrderBomList.fileSuffixfileSuffixautoFillResponse mbsOrderBomList.stockNumbstockNumb_autoFillResponse mbsOrderBomList.onLineNumonLineNumautoFillResponse mbsOrderBomList.priceprice_autoFillResponse mbsOrderBomList.picVersionpicVersionautoFillResponse mbsOrderBomList.shipmentPlaceshipmentPlace_autoFillResponse mbsOrderBomList.stagestageautoFillResponse mbsOrderBomList.mbsOrderBomUuidmbsOrderBomUuid_autoFillResponse mbsOrderBomList.materialInfoNomaterialInfoNoautoFillResponse mbsOrderBomList.processingTypeprocessingType_autoFillResponse mbsOrderBomList.bomVersionbomVersionautoFillResponse mbsOrderBomList.projectCodeprojectCode_autoFillResponse mbsOrderBomList.projectNameprojectNameautoFillResponse mbsOrderBomList.outNumboutNumb_autoFillResponse mbsOrderBomList.outStatusoutStatusautoFillResponse mbsOrderBomList.replaceBomNoreplaceBomNo_autoFillResponse mbsOrderBomList.bomItembomItemautoFillResponse mbsOrderBomList.bomContractNobomContractNo_autoFillResponse mbsOrderBomList.workNoworkNoautoFillResponse mbsOrderBomList.singleBomNumsingleBomNum_autoFillResponse mbsOrderBomList.cycleNumcycleNumautoFillResponse mbsOrderBomList.urgentNeedNourgentNeedNo_autoFillResponse mbsOrderBomList.internalSpNuminternalSpNumautoFillResponse mbsOrderBomList.customerSpNumcustomerSpNum_autoFillResponse mbsOrderBomList.urgentLevelurgentLevelautoFillResponse mbsOrderBomList.customerOrderNocustomerOrderNo_autoFillResponse mbsOrderBomList.leaderleaderautoFillResponse mbsOrderBomList.leaderNameleaderName_autoFillResponse mbsOrderBomList.centerConcatIdcenterConcatIdautoFillResponse mbsOrderBomList.centerConcatValuecenterConcatValue_autoFillResponse mbsOrderBomList.addressConcatIdaddressConcatIdautoFillResponse mbsOrderBomList.addressConcatValueaddressConcatValue_autoFillResponse mbsOrderBomList.addrContactCodeaddrContactCodeautoFillResponse mbsOrderBomList.addrLocationCodeaddrLocationCode_autoFillResponse mbsOrderBomList.contactCodecontactCodeautoFillResponse mbsOrderBomList.locationCodelocationCode_autoFillResponse mbsOrderBomList.jobStatusjobStatusautoFillResponse mbsOrderBomList.customerGradeNamecustomerGradeName_autoFillResponse mbsOrderBomList.selectionCertificateselectionCertificateautoFillResponse mbsOrderBomList.pendingOrderNumpendingOrderNum_autoFillResponse mbsOrderBomList.replaceBomIdreplaceBomIdautoFillResponse mbsOrderBomList.receiptsTimereceiptsTime_autoFillResponse mbsOrderBomList.isBomConfirmisBomConfirmautoFillResponse mbsOrderBomList.shipOrgshipOrg_autoFillResponse mbsOrderBomList.custorMoldVercustorMoldVerautoFillResponse mbsOrderBomList.analyseNoanalyseNo_autoFillResponse mbsOrderBomList.planNoplanNoautoFillResponse mbsOrderBomList.planUuidplanUuid_autoFillResponse mbsOrderBomList.projectCodeprojectCodeautoFillResponse mbsOrderBomList.projectNameprojectName_autoFillResponse mbsOrderBomList.machiningTypemachiningTypeautoFillResponse mbsOrderBomList.businessUuidbusinessUuid_autoFillResponse mbsOrderBomList.omsOrderBomListomsOrderBomListautoFillResponse mbsOrderBomList.bomUuidbomUuid_autoFillResponse mbsOrderBomList.deleteBomListdeleteBomListautoFillResponse mbsOrderBomList.itemCategoryitemCategory_autoFillResponse mbsOrderBomList.outStatusoutStatusautoFillResponse mbsOrderBomList.isUnifiedisUnified_autoFillResponse mbsOrderBomList.filePathListfilePathListautoFillResponse mbsOrderBomList.totalNumtotalNum_autoFillResponse mbsOrderBomList.originalOrderNooriginalOrderNoautoFillResponse mbsOrderBomList.productTypeproductType_autoFillResponse mbsOrderBomList.auditStatusauditStatusautoFillResponse mbsOrderBomList.applyByapplyBy_autoFillResponse mbsOrderBomList.applyTimeapplyTimeautoFillResponse mbsOrderBomList.auditByauditBy_autoFillResponse mbsOrderBomList.auditTimeauditTimeautoFillResponse mbsOrderBomList.instructinstruct_autoFillResponse mbsOrderBomList.auditNameauditNameautoFillResponse mbsOrderBomList.applyNameapplyName_autoFillResponse mbsOrderBomList.actUseractUserautoFillResponse mbsOrderBomList.serialserial_autoFillResponse mbsOrderBomList.currencyTypecurrencyTypeautoFillResponse mbsOrderBomList.listOrderIdlistOrderId_autoFillResponse

金蝶云星空接口明细

调用接口：batchSave
接口名称：生产入库单新增
方法：POST

请求参数

字段字段名称类型配置值 FBillNo单据编号string{{backNo}}-{{id}} FPrdOrgId生产组织string1 FBillType单据类型stringSCTK01_SYS FStockOrgId退库组织string1 FOwnerTypeId0货主类型stringBD_OwnerOrg FOwnerId0货主string1 FDate日期stringfunction NOW() FCurrId本位币stringPRE001 FDescription备注string{{returnReason}} FEntity明细array FEntity.FSrcEntryId源单分录内码string_findCollection find FEntity_FEntryId from 65c215b8-ca25-3341-85c3-f2939968ad5a where FBillNo={{confrimNo}} FEntity.FIsNew是否新增stringfalse FEntity.FMaterialId物料编码string{{partNo}} FEntity.FProductType产品类型-1主产品 2联副产品string1 FEntity.FInStockType退库类型string1 FEntity.FMustQty应退数量string{{returnNumb}} FEntity.FRealQty实退数量string{{returnNumb}} FEntity.FOwnerTypeId货主类型stringBD_OwnerOrg FEntity.FOwnerId货主string1 FEntity.FStockId仓库stringF2313A FEntity.FStockLocId仓位stringH-1 FEntity.FISBACKFLUSH倒冲领料stringfalse FEntity.FMoBillNo生产订单编号string{{dispatchPrefix}} FEntity.FMoId生产订单内码stringfindCollection find FID from c2d95458-d5a6-367e-a745-3b56e0db614c where FBillNo={{dispatchPrefix}} FEntity.FMoEntryId生产订单分录内码string_findCollection find FTreeEntity_FEntryId from c2d95458-d5a6-367e-a745-3b56e0db614c where FBillNo={{dispatchPrefix}} FEntity.FSrcBillType源单类型stringPRD_INSTOCK FEntity.FSrcInterId源单内码stringfindCollection find FID from 65c215b8-ca25-3341-85c3-f2939968ad5a where FBillNo={{confrimNo}} FEntity.FSrcBillNo源单编号string{{confrimNo}} FEntity.FStockStatusId库存状态string_findCollection find DefStockStatusId_Number from 435f6304-1f25-37f2-bf14-b13aec7d9a5d where Number={{warehouseCode}} FEntity.FMOMAINENTRYID生产订单主产品分录stringfindCollection find FTreeEntity_FEntryId from c2d95458-d5a6-367e-a745-3b56e0db614c where FBillNo={{dispatchPrefix}} FEntity.FKeeperTypeId保管者类型stringBD_KeeperOrg FEntity.F_sh_ywddh四化业务订单号string{{orderNo}} FEntity.F_sh_bomNo四化派工案号string{{bomNo}} FEntity.F_sh_businessNo四化备料业务号string{{businessNo}} FEntity.F_sh_pgNo四化派工单号string{{businessNo}} FEntity.FLot批号string_function case _findCollection find FIsBatchManage from 5e1c2a3d-1e33-32db-9fdc-9af29dadb99f where FNumber={{details.partNo}} endFind when true then '00' else '' end FEntity.FMtoNo计划跟踪号string{{bomNo}} FEntity.F_UZMJ_TextMES入库明细行idstring{{connectUuid}} FEntity.FEntity_Link关联关系表array FEntity.FEntity_Link.FEntity_Link_FRuleId转换规则stringInStock2ReStockConvert FEntity.FEntity_Link.FEntity_Link_FSTableName源单表stringT_PRD_MOENTRY FEntity.FEntity_Link.FEntity_Link_FSBillId源单内码string_findCollection find FID from 65c215b8-ca25-3341-85c3-f2939968ad5a where FBillNo={{confrimNo}} FEntity.FEntity_Link.FEntity_Link_FSId源单分录内码string_findCollection find FEntity_FEntryId from 65c215b8-ca25-3341-85c3-f2939968ad5a where FBillNo={{confrimNo}} F_UZMJ_Text3={{connectUuid}} FEntity.FEntity_Link.FWorkShopId1生产车间stringYA032 FEntity.F_UZMJ_DateMES退库日期string{{createTime}} FEntity.FormId业务对象表单IdstringPRD_RetStock FEntity.Operation执行的操作stringBatchSave FEntity.IsAutoSubmitAndAudit提交并审核booltrue FEntity.IsVerifyBaseDataField验证基础资料booltrue

数据对接价值

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

金蝶云星空与四化智造MES（WEB）对接集成业务订单列表查询连通生产入库单新增(生产入库确认退货-生产退库单-run)