Qeasy Cloud
Get Started

四化智造MES(WEB)和金蝶云星空接口打通对接实战

1 comments

四化智造MES(WEB)和金蝶云星空接口打通对接实战

接口数据集成

数据源系统:四化智造MES(WEB)

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

对接系统:金蝶云星空

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

数据集成方案配置

在轻易云平台进行集成方案的配置时,为了实现快速搭建,轻易云平台还提供了现有的市场方案进行复制参考。用户可以在创建集成方案的时候在第四步选择引用市场方案,参考市场主流所进行的字段配置完成集成方案的自定义化快速配置,即便是第一次使用轻易云平台的用户也能轻松搭建属于自己的数据同步方案。向导式配置,让配置更加清晰,首先确定该方方案的对接内容,第二歩获取筛选数据源平台的数据,第三步数据源与写入目标形成映射关系配置。完成配置后一键启用
用友接口

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

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

请求参数

接口字段字段名称预设值描述 pageNum页码1页码 pageSize页数100页数 beginOutStockDate开始时间{{LAST_SYNC_TIME datetime}}开始时间 endOutStockDate结束时间{{CURRENT_TIME datetime}}结束时间 orderNo订单号订单号 customerName客户名称客户名称 customerOrderNo客户PO号客户PO号 orderType订单类型订单类型 orderStatus订单状态30:编辑中;1:未计划;2:计划中;3:已计划;8:暂停;9:已关单

响应参数

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

金蝶云星空接口明细

  • API:batchSave
  • NAME:销售出库新增
  • METHOD:POST

请求参数

接口字段字段名称预设值描述 FBillTypeID单据类型XSCKD01_SYS单据类型 FBillNo单据编号{{confrimNo}}-{{id}}单据编号 FDate日期{{createTime date}}日期 FSaleOrgId销售组织1组织 FCustomerID客户{{customerUuid}}基础资料 FCarriageNO运输单号文本 FStockOrgId发货组织1组织 FLinkPhone联系电话文本 FLinkMan收货人姓名文本 FReceiveAddress收货方地址文本 FHeadLocationId交货地点{{addressConcatValue}} F_lyzx_Base收货中心{{centerConcatValue}} SubHeadEntity财务信息 SubHeadEntity.FSettleTypeID结算方式JSFS04_SYS基础资料 SubHeadEntity.FReceiverAddress收货人地址文本 SubHeadEntity.FReceiverName收货人文本 SubHeadEntity.FReceiverMobile收货人手机文本 SubHeadEntity.FEntity明细信息 SubHeadEntity.FEntity.FMaterialID物料编码{{partNo}}基础资料 SubHeadEntity.FEntity.FRealQty实发数量{{confirmNumb}}数量 SubHeadEntity.FEntity.FSalBaseQty销售基本数量{{confirmNumb}} SubHeadEntity.FEntity.FPrice单价{{untaxedPrice}} SubHeadEntity.FEntity.FTaxPrice含税单价{{taxPrice}}单价 SubHeadEntity.FEntity.FEntryTaxRate税率function {{taxPoints}}*100 SubHeadEntity.FEntity.FLot批号_function case _findCollection find FIsBatchManage from 5e1c2a3d-1e33-32db-9fdc-9af29dadb99f where FNumber={{partNo}} endFind when true then '00' else '' end批次 SubHeadEntity.FEntity.FStockId仓库F2313A SubHeadEntity.FEntity.FStockLocId仓位H-1 SubHeadEntity.FEntity.FMtoNo计划跟踪号{{bomNo}} SubHeadEntity.FEntity.FSoorDerno订单编号{{orderNo}} SubHeadEntity.FEntity.F_lyzx_Text客户订单号{{customerOrderNo}} SubHeadEntity.FEntity.FIsFree是否赠品_function case '{{orderType}}' when '12' then 'true' else 'false' end SubHeadEntity.FEntity.F_UZMJ_Text5四化出库明细行id{{uuid}} SubHeadEntity.FEntity.FSrcType源单类型SAL_SaleOrder SubHeadEntity.FEntity.FSrcBillNo源单编号{{orderNo}} SubHeadEntity.FEntity.FEntity_Link关联关系表 SubHeadEntity.FEntity.FEntity_Link.FEntity_Link_FRuleId转换规则1f95855e-2f0b-4855-81ec-e59e9b81dfb9SaleOrder-OutStock T_SAL_ORDERENTRY DeliveryNotice-OutStock T_SAL_DELIVERYNOTICEENTRY SubHeadEntity.FEntity.FEntity_Link.FEntity_Link_FSTableName源单表T_SAL_ORDERENTRY SubHeadEntity.FEntity.FEntity_Link.FEntity_Link_FSBillId源单内码findCollection find FID from 94a43f71-475f-36cd-ac61-10db23cf5a99 where FBillNo={{orderNo}} SubHeadEntity.FEntity.FEntity_Link.FEntity_Link_FSId源单分录内码_findCollection find FSaleOrderEntry_FEntryId from 94a43f71-475f-36cd-ac61-10db23cf5a99 where FBillNo={{orderNo}} F_sh_bomNo={{bomNo}} SubHeadEntity.FEntity.FEntity_Link.F_UZMJ_Text6物流单号{{logisticsNo}} SubHeadEntity.FEntity.F_UZMJ_Text3是否核对否 SubHeadEntity.FEntity.FormId业务对象表单IdSAL_OUTSTOCK必须填写金蝶的表单ID如😛UR_PurchaseOrder SubHeadEntity.FEntity.Operation执行的操作Save SubHeadEntity.FEntity.IsAutoSubmitAndAudit提交并审核true SubHeadEntity.FEntity.IsVerifyBaseDataField验证基础资料true是否验证所有的基础资料有效性,布尔类,默认false(非必录) SubHeadEntity.FEntity.SubSystemId系统模块21默认仓库模块

数据对接价值

全面管控企业的API资产,梳理现有业务系统的API。实现API文档的统一管理,建立API的上线、下线、监控的统一管理体系。API低代码开发平台能够实现低代码或零代码一键发布API服务,很好地解决企业用户上面的问题。轻易云应用集成主要解决已有应用系统的无序蔓延现象,减少各业务系统间的维护成本,减少各应用系统的操作系统、开发语言、访问协议、通信技术多而杂、整合难度大的问题,将企业数据平滑对接,减少信息竖井。
ERP如何对接
API数据集成

四化智造MES(WEB)和金蝶云星空接口打通对接实战 | Qeasy Cloud