Qeasy Cloud
Get Started

金蝶云星空对接外部四化智造MES(WEB)系统

1 comments

金蝶云星空对接外部四化智造MES(WEB)系统

金蝶KIS接口集成

接通系统:四化智造MES(WEB)

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

接入系统:金蝶云星空

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

数据集成方案配置

通过轻易云系统数据集成平台新增创建集成方案,通过轻易云的方案市场可以一键复制,并且可以借鉴其他的方案配置完成方案制作,方案制作只需要两步,第一步先确定好对应的数据来源;源系统:四化智造MES(WEB)接口:业务订单列表查询通过请求调度者配置对应的请求参数即可获取到对应的数据。目标系统:金蝶云星空接口:生产入库单新增,通过写入调度者匹配获取到的数据和写入的映射关系,即可自动生成符合目标系统:金蝶云星空写入的数据自动产生写入队列,通过运行概况,系统会自动帮你诊断方案的运行情况。实时监控到方案的运行情况
系统接口对接

四化智造MES(WEB)接口明细

  • 调用接口:wms/instockConfirm/queryZlConfirmRebackTaskDetail
  • 接口名称:业务订单列表查询
  • 方法:GET

请求参数

字段字段名称类型配置值 pageNum页码string1 pageSize页数string100 rebackStartTime开始时间string{{LAST_SYNC_TIME datetime}} rebackEndTime结束时间string{{CURRENT_TIME datetime}}

响应参数

字段字段名称类型配置值 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

请求参数

接口字段名称预设值 FBillNo单据编号{{backNo}}-{{id}} FPrdOrgId生产组织1 FBillType单据类型SCTK01_SYS FStockOrgId退库组织1 FOwnerTypeId0货主类型BD_OwnerOrg FOwnerId0货主1 FDate日期function NOW() FCurrId本位币PRE001 FDescription备注{{returnReason}} FEntity明细 FEntity.FSrcEntryId源单分录内码_findCollection find FEntity_FEntryId from fd193387-19e7-3d15-bee0-9a71a34faeab where FBillNo={{confrimNo}} FEntity.FIsNew是否新增false FEntity.FMaterialId物料编码{{partNo}} FEntity.FProductType产品类型-1主产品 2联副产品1 FEntity.FInStockType退库类型1 FEntity.FMustQty应退数量{{returnNumb}} FEntity.FRealQty实退数量{{returnNumb}} FEntity.FOwnerTypeId货主类型BD_OwnerOrg FEntity.FOwnerId货主1 FEntity.FStockId仓库F2313A FEntity.FStockLocId仓位H-1 FEntity.FISBACKFLUSH倒冲领料false FEntity.FMoBillNo生产订单编号{{bomNo}} FEntity.FMoId生产订单内码findCollection find FID from e011a156-9fc9-3c76-9114-76006d5e72c9 where FBillNo={{bomNo}} FEntity.FMoEntryId生产订单分录内码_findCollection find FTreeEntity_FEntryId from e011a156-9fc9-3c76-9114-76006d5e72c9 where FBillNo={{bomNo}} FEntity.FSrcBillType源单类型PRD_INSTOCK FEntity.FSrcInterId源单内码findCollection find FID from fd193387-19e7-3d15-bee0-9a71a34faeab where FBillNo={{confrimNo}} FEntity.FSrcBillNo源单编号{{confrimNo}} FEntity.FStockStatusId库存状态_findCollection find DefStockStatusId_Number from 435f6304-1f25-37f2-bf14-b13aec7d9a5d where Number={{warehouseCode}} FEntity.FMOMAINENTRYID生产订单主产品分录findCollection find FTreeEntity_FEntryId from e011a156-9fc9-3c76-9114-76006d5e72c9 where FBillNo={{bomNo}} FEntity.FKeeperTypeId保管者类型BD_KeeperOrg FEntity.F_sh_ywddh四化业务订单号{{orderNo}} FEntity.F_sh_bomNo四化派工案号{{bomNo}} FEntity.F_sh_businessNo四化备料业务号{{businessNo}} FEntity.F_sh_pgNo四化派工单号{{businessNo}} FEntity.FLot批号_function case _findCollection find FIsBatchManage from 80f3f76d-b3eb-3e61-96cd-169790878567 where FNumber={{details.partNo}} endFind when true then '00' else '' end FEntity.FMtoNo计划跟踪号{{bomNo}} FEntity.F_UZMJ_TextMES入库明细行id{{connectUuid}} FEntity.FEntity_Link关联关系表 FEntity.FEntity_Link.FEntity_Link_FRuleId转换规则InStock2ReStockConvert FEntity.FEntity_Link.FEntity_Link_FSTableName源单表T_PRD_INSTOCKENTRY FEntity.FEntity_Link.FEntity_Link_FSBillId源单内码_findCollection find FID from fd193387-19e7-3d15-bee0-9a71a34faeab where FBillNo={{confrimNo}} FEntity.FEntity_Link.FEntity_Link_FSId源单分录内码_findCollection find FEntity_FEntryId from fd193387-19e7-3d15-bee0-9a71a34faeab where FBillNo={{confrimNo}} F_UZMJ_Text3={{connectUuid}} FEntity.F_UZMJ_DateMES退库日期2023-01-01 FEntity.FormId业务对象表单IdPRD_RetStock FEntity.Operation执行的操作BatchSave FEntity.IsAutoSubmitAndAudit提交并审核true FEntity.IsVerifyBaseDataField验证基础资料false

系统打通概况

数据集成中台设计中心Web界面以“拖拽”式交互设计,使用鼠标即可构建设计多异构系统数据集成流程,低代码平台大大降低流程设计者上手门槛。还有丰富的组件库快速满足复杂业务需求,结合不同模块即可生成不同业务流程,提升流程设计效率。平台支持多种高度灵活部署,高并发、高性能、高可用,可以通过多节点组成集群实现性能的横向扩展。适度集群配置其数据集成处理能力可达GB级/秒,为业务流提供更高数据吞吐量。平台已集成数据回压、优先级队列等能力,保障运行稳定性。完善的企业API运营管理机制帮助您构建“API生产者、API管理者、API消费者”三者结合的统一API数字化生态。支持市面上主流厂家软件如:金蝶、用友、SAP、泛微、蓝凌、旺店通、聚水潭、马帮、小满CRM等等。
多套系统之间数据打通
金蝶云星空接口