Qeasy Cloud
Get Started

从四化智造MES(WEB)到金蝶云星空通过接口集成数据

1 comments

从四化智造MES(WEB)到金蝶云星空通过接口集成数据

数据集成平台

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

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

写入目标:金蝶云星空

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

数据对接方案

通过系统数据集成平台:数据集成方案。选择开始创建数据集成方案菜单。在方案配置表单中选择对应的源业务系统:四化智造MES(WEB),然后选择对应的连接器。选择对应的mbs/pur/record/toBePurList作为数据对接来源。然后再写入目标平台配置目标系统为金蝶云星空,并且选择对应连接器。选择好对应的batchSave接口作为数据写入动作完成第一步的接口配置。通过该系统数据集成平台的能力,可以集成的应用系统包括CRM、ERP、钉钉、企业微信、MES、飞书、用友、金蝶等 177 个不同应用系统之间的无代码接口集成,并且每周都在增加新的应用系统接入。
多套系统之间数据打通
系统接口对接

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

  • API:mbs/pur/record/purDetailList
  • NAME:原材料/标准件采购查询(待采购)
  • METHOD:GET

请求参数

接口字段名称预设值 pageNum页码1 pageSize页数100 updBeginTime开始时间{{LAST_SYNC_TIME datetime}} updEndTime结束时间{{CURRENT_TIME datetime}} purType采购类型1 updateTime修改时间{{LAST_SYNC_TIME datetime}}

响应参数

接口字段名称预设值 mchIdmchId createBycreateBy createNamecreateName checkLabelcheckLabel createTimecreateTime updateByupdateBy updateNameupdateName updateTimeupdateTime remarkremark companyCodecompanyCode currentUserBycurrentUserBy currentUserNamecurrentUserName currentTimecurrentTime filtrationBomStatusfiltrationBomStatus idid recordIdrecordId detailIddetailId purIdpurId coefficientcoefficient haveDeliveryNumhaveDeliveryNum supplierUuidsupplierUuid patterNopatterNo customerDeliveryDatecustomerDeliveryDate supplierNamesupplierName supplierFullNamesupplierFullName purRecordUuidpurRecordUuid purRecordDetailUuidpurRecordDetailUuid purTaskUuidpurTaskUuid takeApartDetailUuidtakeApartDetailUuid orderUuidorderUuid bomUuidbomUuid planBomUuidplanBomUuid partNopartNo processNameprocessName gradeNamegradeName picNopicNo qualityquality purTypepurType outsourcedTypeoutsourcedType outProcessCodeoutProcessCode heatTreatmentheatTreatment bomNobomNo keyNokeyNo locationCodelocationCode barcodebarcode purchaseNumpurchaseNum purPricepurPrice purTotalPricepurTotalPrice reqDatereqDate productUuidproductUuid outsourcedWayoutsourcedWay outsourcedWayListoutsourcedWayList locationUuidlocationUuid stockNumstockNum deliveryDatedeliveryDate reqNoreqNo deptNamedeptName totalDemandNumtotalDemandNum productNoproductNo productNameproductName orderNoorderNo orderTypeorderType customerNamecustomerName projectCodeprojectCode purNopurNo purReasonpurReason purStatuspurStatus backStatusbackStatus customerOrderNocustomerOrderNo deptIddeptId receiveByreceiveBy receiveTimereceiveTime receiveNamereceiveName takeApartTypetakeApartType specspec brandbrand materialInfoNomaterialInfoNo craftIdcraftId rawPurchaseWeightrawPurchaseWeight rawMaterialInfoNorawMaterialInfoNo purTaskTypepurTaskType ifMoldifMold taxPricetaxPrice taxTotalPricetaxTotalPrice untaxedPriceuntaxedPrice untaxedTotalPriceuntaxedTotalPrice taxRatetaxRate customerPartNocustomerPartNo stockTimestockTime purchaseUnitNopurchaseUnitNo purchaseUnitNamepurchaseUnitName returnsNumberreturnsNumber replaceModeNoreplaceModeNo secondPurTypesecondPurType isSecondPurisSecondPur checkedNumcheckedNum processingFeeprocessingFee itemCategoryitemCategory stagestage projectNameprojectName rawMaterialInforawMaterialInfo rawPartNorawPartNo rawGradeNamerawGradeName rawSpecrawSpec rawBrandrawBrand rawQualityrawQuality rawQuantityrawQuantity nuclearPriceTaskUuidnuclearPriceTaskUuid detailBackStatusdetailBackStatus unitNameunitName processingTypeprocessingType beginReqDatebeginReqDate endReqDateendReqDate beginReceiveTimebeginReceiveTime endReceiveTimeendReceiveTime beginReplyTimebeginReplyTime endReplyTimeendReplyTime isAbnormalisAbnormal bomVersionbomVersion orderNumorderNum workNoworkNo bomContractNobomContractNo urgentNeedNourgentNeedNo bomRemarkbomRemark distributeNumdistributeNum distributeDatedistributeDate purRevokeUuidpurRevokeUuid businessUuidbusinessUuid filePathfilePath fileNamefileName fileSuffixfileSuffix fileName2dfileName2d filePath2dfilePath2d fileName3dfileName3d filePath3dfilePath3d changeRemarkchangeRemark changeColorchangeColor invTypeNameinvTypeName rawUnitNamerawUnitName bomStatusbomStatus bomClosebomClose shipmentPlaceshipmentPlace realNamerealName procuredNumprocuredNum taskPurTypetaskPurType moldNomoldNo purCreateNamepurCreateName uploadFileTimeuploadFileTime replyTimereplyTime beginPurchaseTimebeginPurchaseTime endPurchaseTimeendPurchaseTime dispatchNodispatchNo orderGradeNameorderGradeName orderPartNoorderPartNo parentMaterialInfoNoparentMaterialInfoNo closeReasoncloseReason closeUsercloseUser closeTimecloseTime revokeReasonrevokeReason revokeNamerevokeName revokeTimerevokeTime detailStatusdetailStatus customerAndUrgentcustomerAndUrgent orderNoBomorderNoBom singleSetNumsingleSetNum receiveNumreceiveNum minPurchaseNumminPurchaseNum

金蝶云星空接口明细

  • API:batchSave
  • NAME:采购订单新增
  • METHOD:POST

请求参数

接口字段名称预设值 FIDFIDfindCollection find FID from dfdc7780-aeb2-375a-89fd-ef3cac00cd48 where FBillNo={{purNo}} FPurchaseOrgId采购组织1 FPOOrderEntry明细信息details FPOOrderEntry.FEntryId明细-id_findCollection find FPOOrderEntry_FEntryId from dfdc7780-aeb2-375a-89fd-ef3cac00cd48 where F_UZMJ_Text={{details.purRecordDetailUuid}} FMaterialId_FNumber={{details.partNo}} FPOOrderEntry.FMaterialId物料编码{{details.rawPartNo}} FPOOrderEntry.FQty采购数量{{details.purchaseNum}} FPOOrderEntry.FPrice单价{{details.untaxedPrice}} FPOOrderEntry.FEntryDiscountRate折扣率% FPOOrderEntry.FEntryNote备注 FPOOrderEntry.FTaxPrice含税单价{{details.purPrice}} FPOOrderEntry.FEntryTaxAmount税额 FPOOrderEntry.FRowCost行费用 FPOOrderEntry.FDeliveryDate交货日期{{details.reqDate}} FPOOrderEntry.F_sh_id四化采购订单id{{purRecordUuid}} FPOOrderEntry.FormId业务对象表单IdPUR_PurchaseOrder FPOOrderEntry.Operation执行的操作BatchSave FPOOrderEntry.IsAutoSubmitAndAudit提交并审核false FPOOrderEntry.IsVerifyBaseDataField验证基础资料true

系统打通概况

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