四化智造MES（WEB）对接打通金蝶云星空原材料/标准件采购查询（待采购）接口与采购退货新增接口

对接系统四化智造MES（WEB）

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

对接系统：金蝶云星空

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

数据接口配置方案

系统对接前期需要通过调研公司的业务，规划出最便捷，效率最高的整体流程。通过流程我们需要建立对应的方案来吧这些流程一一的落地，轻易云集成平台开箱即用的、可视化拖、拉、拽实现接口服务编排与聚合。只需要根据指引设定好对应的参数即可启动使用。设定好源平台：四化智造MES（WEB）的接口参数设置，以及设定好目标平台：金蝶云星空的映射，即可启动方案进行测试

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

API：wms/instockConfirm/queryConfirmRebackTaskDetailJd
NAME：原材料/标准件采购查询（待采购）
METHOD：GET

请求参数

接口字段名称预设值 pageNum页码1 pageSize页数100 rebackStartTime开始时间{{LAST_SYNC_TIME datetime}} rebackEndTime结束时间{{CURRENT_TIME datetime}} taskType采购类型1

响应参数

接口字段名称预设值 mchIdmchId createBycreateBy createNamecreateName checkLabelcheckLabel createTimecreateTime updateByupdateBy updateNameupdateName updateTimeupdateTime remarkremark companyCodecompanyCode currentUserBycurrentUserBy currentUserNamecurrentUserName currentTimecurrentTime filtrationBomStatusfiltrationBomStatus idid backTaskUuidbackTaskUuid backNumbbackNumb returnNumbreturnNumb backWeightbackWeight connectUuidconnectUuid bomNobomNo dispatchPrefixdispatchPrefix receiveMainTaskUuidreceiveMainTaskUuid statusstatus receiveStatusreceiveStatus receiveNumbreceiveNumb waitReceiveNumbwaitReceiveNumb currentReceiveNumbcurrentReceiveNumb warehouseUuidwarehouseUuid warehouseNamewarehouseName partNopartNo gradeNamegradeName qualityquality brandbrand specspec picNopicNo picVersionpicVersion unitNounitNo instockNumbinstockNumb processCodeprocessCode classifyIdclassifyId classifyNameclassifyName delFlagdelFlag returnReasonreturnReason ynReceiveynReceive matterialTypematterialType okNumbokNumb ngNumbngNumb hadBackNumbhadBackNumb preProcessInstockTypepreProcessInstockType preProcessCodepreProcessCode currentProcessCodecurrentProcessCode currentProcessInstockTypecurrentProcessInstockType nextProcessCodenextProcessCode planDateplanDate businessNobusinessNo warehouseAdministorIdwarehouseAdministorId supplierNamesupplierName supplierUuidsupplierUuid taskTypetaskType cuttingSizecuttingSize customerOrderNocustomerOrderNo modeNomodeNo outTypeoutType serCodeserCode outContentoutContent processContentprocessContent locationUuidlocationUuid locationNolocationNo caiGouNumbcaiGouNumb taskResourcetaskResource patterNopatterNo oneWeightoneWeight receiveWeightreceiveWeight planWeightplanWeight projectCodeprojectCode stagestage itemCategoryitemCategory filePathfilePath fileNamefileName fileSuffixfileSuffix fileName2dfileName2d filePath2dfilePath2d fileName3dfileName3d filePath3dfilePath3d weightweight priceNumbpriceNumb instockConfirmNumbinstockConfirmNumb processNameprocessName purchaseUnitNopurchaseUnitNo purchaseUnitNamepurchaseUnitName instockNoinstockNo caigouNocaigouNo instockTimeinstockTime workNoworkNo urgentNeedNourgentNeedNo bomContractNobomContractNo keyNokeyNo ifGiveawayifGiveaway orderNoorderNo sendCheckNosendCheckNo wholeDeliveryDatewholeDeliveryDate deliveryDatedeliveryDate customerPartNocustomerPartNo shipmentPlaceshipmentPlace customerGradeNamecustomerGradeName checkBycheckBy checkNamecheckName ynCheckynCheck checkTimecheckTime productNameproductName productPartNoproductPartNo caigouTimecaigouTime orderTypeorderType checkNumbcheckNumb rebackTyperebackType backNobackNo customerUuidcustomerUuid customerNamecustomerName customerFullNamecustomerFullName supplierFullNamesupplierFullName connectMainUuidconnectMainUuid connectUuid明细行-id

金蝶云星空接口明细

API：batchSave
NAME：采购退货新增
METHOD：POST

请求参数

接口字段名称预设值 FBillNo单据编号{{backNo}} FDate退料日期2023-01-01 FSupplierID供应商{{supplierUuid}} FStockOrgId退料组织1 FSettleOrgId结算组织1 FSETTLETYPEID结算方式JSFS04_SYS FSettleCurrId结算币别PRE001 FPayOrgId付款组织1 FOwnerTypeIdHead货主类型BD_OwnerOrg FOwnerIdHead货主1 F_UZMJ_Base第二级审批人YZ000436 F_lyzx_Base1质检员N0000911 F_UZMJ_Text退料原因{{returnReason}} F_UZMJ_Text1是否核对否 FPURMRBENTRY明细信息details FPURMRBENTRY.FMaterialId物料编码{{details.partNo}} FPURMRBENTRY.FRMREALQTY实退数量{{details.returnNumb}} FPURMRBENTRY.FStockId仓库F2313A FPURMRBENTRY.FStockLocId仓位H-1 FPURMRBENTRY.FLot批号_function case _findCollection find FIsBatchManage from 80f3f76d-b3eb-3e61-96cd-169790878567 where FNumber={{details.partNo}} endFind when true then '00' else '' end FPURMRBENTRY.FTAXPRICE含税单价_findCollection find FTaxPrice from 24e696ed-eba8-3a76-ae50-08b496fb4093 where F_UZMJ_Text={{details.purRecordDetailUuid}} FPURMRBENTRY.FSRCBillNo源单编号{{details.confrimNo}} FPURMRBENTRY.FSRCBillTypeId源单类型STK_InStock FPURMRBENTRY.FMtoNo计划跟踪号{{details.bomNo}} FPURMRBENTRY.FGiveAway是否赠品findCollection find FGiveAway from 0833bd60-7a9a-3573-ba30-f121da4e820a where FBillNo={{confrimNo}} F_UZMJ_Text9={{details.connectUuid}} FPURMRBENTRY.FORDERNO订单号{{details.caigouNo}} FPURMRBENTRY.F_UZMJ_Text2MES入库明细行id{{details.connectUuid}} FPURMRBENTRY.FPURMRBENTRY_Link关联关系表 FPURMRBENTRY.FPURMRBENTRY_Link.FPURMRBENTRY_Link_FRuleId转换规则d5dd2b3d-57d5-45e2-b7e2-e53a04ebecaf FPURMRBENTRY.FPURMRBENTRY_Link.FPURMRBENTRY_Link_FSTableName源单表T_STK_INSTOCKENTRY FPURMRBENTRY.FPURMRBENTRY_Link.FPURMRBENTRY_Link_FSBillId源单内码_findCollection find FID from 0833bd60-7a9a-3573-ba30-f121da4e820a where FBillNo={{confrimNo}} FPURMRBENTRY.FPURMRBENTRY_Link.FPURMRBENTRY_Link_FSId源单分录内码_findCollection find FInStockEntry_FEntryId from 0833bd60-7a9a-3573-ba30-f121da4e820a where FBillNo={{confrimNo}} F_UZMJ_Text9={{details.connectUuid}} FPURMRBENTRY.FormId业务对象表单IdPUR_MRB FPURMRBENTRY.Operation执行的操作batchSave FPURMRBENTRY.IsAutoSubmitAndAudit提交并审核true FPURMRBENTRY.IsVerifyBaseDataField验证基础资料false FPURMRBENTRY.SubSystemId系统模块21

系统打通概况

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

四化智造MES（WEB）对接打通金蝶云星空原材料/标准件采购查询（待采购）接口与采购退货新增接口