四化智造MES（WEB）对接打通金蝶云星空业务订单列表查询接口与销售出库新增接口

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

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

写入目标:金蝶云星空

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

配置集成方案

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

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

API：wms/outstockConfirm/queryOrderHadOutstockConfirmTaskDetails
NAME：业务订单列表查询
METHOD：GET

请求参数

接口字段名称预设值 pageNum页码1 pageSize页数100 updBeginTime开始时间 updEndTime结束时间 orderNo订单号 customerName客户名称 customerOrderNo客户PO号 orderType订单类型 orderStatus订单状态3

响应参数

接口字段名称预设值 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

金蝶云星空接口明细

调用接口：batchSave
接口名称：销售出库新增
方法：POST

请求参数

字段字段名称类型配置值 FBillNo编号stringXSCKD01_SYS FBillNo单据编号string{{confrimNo}} FDocumentStatus单据状态string{{createTime date}} FDate日期string1 FSaleOrgId销售组织string{{supplierUuid}} FSourceBillNo原订单编号string FCustId客户string FReceiveId收货方string FChangeReason变更原因string FSettleCurrId结算币别string1 FBillTypeID单据类型string FSalerId销售员string FSaleDeptId销售部门string FSaleOrderEntry明细信息array FSaleOrderEntry.FMaterialId物料编码string{{partNo}} FSaleOrderEntry.FChangeType变更类型string{{confirmNumb}} FSaleOrderEntry.FOPrice原单价stringfunction case '{{locationCode}}' when 1 then '' else '{{locationCode}}' end FSaleOrderEntry.FNPrice新单价string_function case '{{locationCode}}' when 1 then '' else '{{locationCode}}' end FSaleOrderEntry.FOQty原销售数量stringfunction case '{{locationCode}}' when 1 then '' else '{{locationCode}}' end FSaleOrderEntry.FSumInQty累计入库数量string_function case '{{locationCode}}' when 1 then '' else '{{locationCode}}' end FSaleOrderEntry.FNQty新销售数量stringfunction case '{{locationCode}}' when 1 then '' else '{{locationCode}}' end FSaleOrderEntry.FSaleOrderEntry_Link关联关系表array FSaleOrderEntry.FSaleOrderEntry_Link.FSaleOrderEntry_Link_FRuleId转换规则string1f95855e-2f0b-4855-81ec-e59e9b81dfb9 FSaleOrderEntry.FSaleOrderEntry_Link.FSaleOrderEntry_Link_FSTableName源单表stringT_SAL_ORDERENTRY FSaleOrderEntry.FSaleOrderEntry_Link.FSaleOrderEntry_Link_FSBillId源单内码string_findCollection find FID from 71208117-e45f-3106-a939-54b021b298c3 where FBillNo={{businessNo}} FSaleOrderEntry.FSaleOrderEntry_Link.FSaleOrderEntry_Link_FSId源单分录内码string_findCollection find FTreeEntity_FEntryId from 71208117-e45f-3106-a939-54b021b298c3 where FBillNo={{businessNo}} FSaleOrderEntry.FormId业务对象表单IdstringSAL_SaleOrderChange FSaleOrderEntry.Operation执行的操作stringSave FSaleOrderEntry.IsAutoSubmitAndAudit提交并审核booltrue FSaleOrderEntry.IsVerifyBaseDataField验证基础资料boolfalse FSaleOrderEntry.SubSystemId系统模块string21

系统数据对接

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

四化智造MES（WEB）对接打通金蝶云星空业务订单列表查询接口与销售出库新增接口