金蝶云星空与四化智造MES（WEB）对接集成业务订单列表查询连通销售出库新增(物料调配-组装拆卸单-TEST)

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

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

目标系统:金蝶云星空

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

数据对接方案

使用系统数据集成平台对应的模块：数据集成方案。然后选择开始创建数据集成方案。在方案配置表单中选择对应的源业务系统：四化智造MES（WEB），然后选择对应的连接器。选择对应的业务订单列表查询作为数据对接来源。然后再通过写入目标平台配置目标系统为金蝶云星空,并且选择对应连接器（关于金蝶云星空的接口如何配置可以在轻易云数据集成社区论坛中找到相关信息,选择好对应的销售出库新增接口作为数据写入动作，既可以完成第一步的数据对接配置。

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

API：wms/warehouseStock/warehouseTransListJdNotEq
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单据类型stringZZCX01_SYS FOwnerTypeIdHead成品货主类型stringBD_OwnerOrg FOwnerIdHead成品货主string1 FAffairType事务类型stringAssembly FDeptID申请部门stringYA032 FSubProOwnTypeIdH子件货主类型stringBD_OwnerOrg FSubProOwnerIdH子件货主string1 F_lyzx_Base物料负责人stringYZ000472 F_UZMJ_Base仓管员stringYZ000314 FDate日期string{{createTime}} FNote备注string FEntity成品表-后array FEntity.FMaterialId物料编码string{{afterPartNo}} FEntity.FQty数量string{{stockNumb}} FEntity.FStockId仓库stringF2313A FEntity.FStockLocId仓位stringH-1 FEntity.FMTONO计划跟踪号string{{modeNoAfter}} FEntity.FStockStatusID库存状态stringKCZT01_SYS 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 FEntity.FSubEntity子件表-前array FEntity.FSubEntity.FMaterialIDSETY物料编码string{{partNo}} FEntity.FSubEntity.FQtySETY数量string{{stockNumb}} FEntity.FSubEntity.FStockIDSETY仓库stringF2313A FEntity.FSubEntity.FStockLocIdSETY仓位stringH-1 FEntity.FSubEntity.FMTONOSETY计划跟踪号string{{modeNo}} FEntity.FSubEntity.FStockStatusIDSETY库存状态stringKCZT01_SYS FEntity.FSubEntity.FLOTSETY批号string_function case _findCollection find FIsBatchManage from 80f3f76d-b3eb-3e61-96cd-169790878567 where FNumber={{details.partNo}} _endFind when true then '00' else '' end FEntity.FSubEntity.FKeeperTypeIDSETY货主类型stringBD_KeeperOrg FEntity.FSubEntity.FKeeperIDSETYFKeeperIDSETYstring1 FEntity.FSubEntity.FOwnerTypeIDSETYFOwnerTypeIDSETYstringBD_OwnerOrg FEntity.FSubEntity.FOwnerIDSETYFOwnerIDSETYstring1 FEntity.FSubEntity.FormId业务对象表单IdstringSTK_AssembledApp FEntity.FSubEntity.IsAutoSubmitAndAudit提交并审核booltrue FEntity.FSubEntity.IsVerifyBaseDataField验证基础资料booltrue FEntity.FSubEntity.Operation执行的操作stringSave

系统数据对接

通过无代码的数据集成与数据建模的智能数据管道技术，帮助企业将所有应用程序、数据库、事件和文件等数据信息提取到数据仓库中，并快速将分散的数据转化为数据集、API、自动化流程等开箱即用的数据服务。配置接口的模式对接四化智造MES（WEB）和金蝶云星空，使得单据无缝互通。打造企业内部数据一体化，让企业日常运营管理实现敏捷数据化运营。实现供应链业务信息流的互通，同时支持供应链数据分析流程自动化，结果推送，推进相关供应链问题优化。及时打通供应链孤岛，实现数据驱动供应链协同，进一步提升企业竞争力。

金蝶云星空与四化智造MES（WEB）对接集成业务订单列表查询连通销售出库新增(物料调配-组装拆卸单-TEST)