轻易云
注册体验

四化智造MES(WEB)对接打通金蝶云星空原材料/标准件采购查询(待采购)接口与采购订单新增接口

1 条评论

四化智造MES(WEB)对接打通金蝶云星空原材料/标准件采购查询(待采购)接口与采购订单新增接口

ERP如何对接

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

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

接通系统:金蝶云星空

金蝶K/3Cloud在总结百万家客户管理最佳实践的基础上,提供了标准的管理模式;通过标准的业务架构:多会计准则、多币别、多地点、多组织、多税制应用框架等,有效支持企业的运营管理;K/3Cloud提供了标准的业务建模:35种标准ERP领域模型、1046种模型元素、21243种模型元素属性组合,288个业务服务构件,让企业及伙伴可快速构建出行业化及个性化的应用。

系统对接接口配置

通过可视化界面的拖、拉、拽即可轻松快速构建数据集成流程,将四化智造MES(WEB)、金蝶云星空之间接口数据联通,支持数据在线预览、数据集成流程全过程调试,Web界面追踪调试日志等功能。 平台兼具实时数据处理和数据集成分发功能,用户通过可视化的拖、拽即可完成数据处理逻辑,将数据加工处理后分发到下游业务系统或其他异构存储中。
API数据接口打通

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

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

请求参数

接口字段字段名称预设值描述 pageNum页码1页码 pageSize页数500页数 BeginTime开始时间{{LAST_SYNC_TIME datetime}}开始时间 EndTime结束时间{{CURRENT_TIME datetime}}结束时间 purType采购类型31:标准件2:委外 3:原材料 updateTime更新时间 purStatus订单状态2:已审核;5:已接收;9:已完成; filtrationBomStatus显示与影藏1

响应参数

接口字段字段名称预设值描述 mchIdmchIdautoFillResponse createBycreateBy_autoFillResponse createNamecreateNameautoFillResponse checkLabelcheckLabel_autoFillResponse createTimecreateTimeautoFillResponse updateByupdateBy_autoFillResponse updateNameupdateNameautoFillResponse updateTimeupdateTime_autoFillResponse remarkremarkautoFillResponse companyCodecompanyCode_autoFillResponse currentUserBycurrentUserByautoFillResponse currentUserNamecurrentUserName_autoFillResponse currentTimecurrentTimeautoFillResponse filtrationBomStatusfiltrationBomStatus_autoFillResponse ididautoFillResponse recordIdrecordId_autoFillResponse detailIddetailIdautoFillResponse purIdpurId_autoFillResponse coefficientcoefficientautoFillResponse haveDeliveryNumhaveDeliveryNum_autoFillResponse supplierUuidsupplierUuidautoFillResponse patterNopatterNo_autoFillResponse customerDeliveryDatecustomerDeliveryDateautoFillResponse supplierNamesupplierName_autoFillResponse supplierFullNamesupplierFullNameautoFillResponse purRecordUuidpurRecordUuid_autoFillResponse purRecordDetailUuidpurRecordDetailUuidautoFillResponse purTaskUuidpurTaskUuid_autoFillResponse takeApartDetailUuidtakeApartDetailUuidautoFillResponse orderUuidorderUuid_autoFillResponse bomUuidbomUuidautoFillResponse planBomUuidplanBomUuid_autoFillResponse partNopartNoautoFillResponse processNameprocessName_autoFillResponse gradeNamegradeNameautoFillResponse picNopicNo_autoFillResponse qualityqualityautoFillResponse purTypepurType_autoFillResponse outsourcedTypeoutsourcedTypeautoFillResponse outProcessCodeoutProcessCode_autoFillResponse heatTreatmentheatTreatmentautoFillResponse bomNobomNo_autoFillResponse keyNokeyNoautoFillResponse locationCodelocationCode_autoFillResponse barcodebarcodeautoFillResponse purchaseNumpurchaseNum_autoFillResponse purPricepurPriceautoFillResponse purTotalPricepurTotalPrice_autoFillResponse reqDatereqDateautoFillResponse productUuidproductUuid_autoFillResponse outsourcedWayoutsourcedWayautoFillResponse outsourcedWayListoutsourcedWayList_autoFillResponse locationUuidlocationUuidautoFillResponse stockNumstockNum_autoFillResponse deliveryDatedeliveryDateautoFillResponse reqNoreqNo_autoFillResponse deptNamedeptNameautoFillResponse totalDemandNumtotalDemandNum_autoFillResponse productNoproductNoautoFillResponse productNameproductName_autoFillResponse orderNoorderNoautoFillResponse orderTypeorderType_autoFillResponse customerNamecustomerNameautoFillResponse projectCodeprojectCode_autoFillResponse purNopurNoautoFillResponse purReasonpurReason_autoFillResponse purStatuspurStatusautoFillResponse backStatusbackStatus_autoFillResponse customerOrderNocustomerOrderNoautoFillResponse deptIddeptId_autoFillResponse receiveByreceiveByautoFillResponse receiveTimereceiveTime_autoFillResponse receiveNamereceiveNameautoFillResponse takeApartTypetakeApartType_autoFillResponse specspecautoFillResponse brandbrand_autoFillResponse materialInfoNomaterialInfoNoautoFillResponse craftIdcraftId_autoFillResponse rawPurchaseWeightrawPurchaseWeightautoFillResponse rawMaterialInfoNorawMaterialInfoNo_autoFillResponse purTaskTypepurTaskTypeautoFillResponse ifMoldifMold_autoFillResponse taxPricetaxPriceautoFillResponse taxTotalPricetaxTotalPrice_autoFillResponse untaxedPriceuntaxedPriceautoFillResponse untaxedTotalPriceuntaxedTotalPrice_autoFillResponse taxRatetaxRateautoFillResponse customerPartNocustomerPartNo_autoFillResponse stockTimestockTimeautoFillResponse purchaseUnitNopurchaseUnitNo_autoFillResponse purchaseUnitNamepurchaseUnitNameautoFillResponse returnsNumberreturnsNumber_autoFillResponse replaceModeNoreplaceModeNoautoFillResponse secondPurTypesecondPurType_autoFillResponse isSecondPurisSecondPurautoFillResponse checkedNumcheckedNum_autoFillResponse processingFeeprocessingFeeautoFillResponse itemCategoryitemCategory_autoFillResponse stagestageautoFillResponse projectNameprojectName_autoFillResponse rawMaterialInforawMaterialInfoautoFillResponse rawPartNorawPartNo_autoFillResponse rawGradeNamerawGradeNameautoFillResponse rawSpecrawSpec_autoFillResponse rawBrandrawBrandautoFillResponse rawQualityrawQuality_autoFillResponse rawQuantityrawQuantityautoFillResponse nuclearPriceTaskUuidnuclearPriceTaskUuid_autoFillResponse detailBackStatusdetailBackStatusautoFillResponse unitNameunitName_autoFillResponse processingTypeprocessingTypeautoFillResponse beginReqDatebeginReqDate_autoFillResponse endReqDateendReqDateautoFillResponse beginReceiveTimebeginReceiveTime_autoFillResponse endReceiveTimeendReceiveTimeautoFillResponse beginReplyTimebeginReplyTime_autoFillResponse endReplyTimeendReplyTimeautoFillResponse isAbnormalisAbnormal_autoFillResponse bomVersionbomVersionautoFillResponse orderNumorderNum_autoFillResponse workNoworkNoautoFillResponse bomContractNobomContractNo_autoFillResponse urgentNeedNourgentNeedNoautoFillResponse bomRemarkbomRemark_autoFillResponse distributeNumdistributeNumautoFillResponse distributeDatedistributeDate_autoFillResponse purRevokeUuidpurRevokeUuidautoFillResponse businessUuidbusinessUuid_autoFillResponse filePathfilePathautoFillResponse fileNamefileName_autoFillResponse fileSuffixfileSuffixautoFillResponse fileName2dfileName2d_autoFillResponse filePath2dfilePath2dautoFillResponse fileName3dfileName3d_autoFillResponse filePath3dfilePath3dautoFillResponse changeRemarkchangeRemark_autoFillResponse changeColorchangeColorautoFillResponse invTypeNameinvTypeName_autoFillResponse rawUnitNamerawUnitNameautoFillResponse bomStatusbomStatus_autoFillResponse bomClosebomCloseautoFillResponse shipmentPlaceshipmentPlace_autoFillResponse realNamerealNameautoFillResponse procuredNumprocuredNum_autoFillResponse taskPurTypetaskPurTypeautoFillResponse moldNomoldNo_autoFillResponse purCreateNamepurCreateNameautoFillResponse uploadFileTimeuploadFileTime_autoFillResponse replyTimereplyTimeautoFillResponse beginPurchaseTimebeginPurchaseTime_autoFillResponse endPurchaseTimeendPurchaseTimeautoFillResponse dispatchNodispatchNo_autoFillResponse orderGradeNameorderGradeNameautoFillResponse orderPartNoorderPartNo_autoFillResponse parentMaterialInfoNoparentMaterialInfoNoautoFillResponse closeReasoncloseReason_autoFillResponse closeUsercloseUserautoFillResponse closeTimecloseTime_autoFillResponse revokeReasonrevokeReasonautoFillResponse revokeNamerevokeName_autoFillResponse revokeTimerevokeTimeautoFillResponse detailStatusdetailStatus_autoFillResponse customerAndUrgentcustomerAndUrgentautoFillResponse orderNoBomorderNoBom_autoFillResponse singleSetNumsingleSetNumautoFillResponse receiveNumreceiveNum_autoFillResponse minPurchaseNumminPurchaseNum_autoFillResponse

金蝶云星空接口明细

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

请求参数

接口字段字段名称预设值描述 FBillNo单据编号{{purNo}} FDate采购日期{{createTime}} FPurchaseOrgId采购组织1 FSupplierId供应商{{supplierUuid}} FPurchaserGroupId采购组 FPurchaserId采购员 FBillTypeID单据类型ZZJPO FBusinessType业务类型CG F_sh_id四化采购订单id{{purRecordUuid}} FPOOrderEntry明细信息details FPOOrderEntry.FMaterialId物料编码{{details.rawPartNo}} FPOOrderEntry.FQty采购数量{{details.purchaseNum}} FPOOrderEntry.FEntryDiscountRate折扣率% FPOOrderEntry.FEntryTaxRate税率%function {{details.taxRate}}*100 FPOOrderEntry.FTaxNetPrice净价 FPOOrderEntry.FEntryAmount金额 FPOOrderEntry.FAllAmount价税合计 FPOOrderEntry.FEntryNote备注 FPOOrderEntry.FTaxPrice含税单价{{details.rawSubtotal}} FPOOrderEntry.FEntryTaxAmount税额 FPOOrderEntry.FRowCost行费用 FPOOrderEntry.FDeliveryDate交货日期_function case when '{{details.reqDate}}'>'{{createTime date}}' then '{{details.reqDate}}' else '{{createTime date}}' end FPOOrderEntry.FMtoNo计划跟踪号{{details.bomNo}} FPOOrderEntry.FGiveAway是否赠品function case '{{details.ifFreebie}}' when '0' then 'true' when '1' then 'false' endtrue false FPOOrderEntry.F_lyzx_Text4模号{{details.patterNo}} FPOOrderEntry.F_lyzx_Text5阶段{{details.stage}} FPOOrderEntry.F_lyzx_Text6客户订单号{{details.customerOrderNo}} FPOOrderEntry.F_lyzx_Text7紧急需求单号{{details.urgentNeedNo}} FPOOrderEntry.F_lyzx_Text8发包单号{{details.bomContractNo}} FPOOrderEntry.F_lyzx_Text9工令单号{{details.workNo}} FPOOrderEntry.F_lyzx_Text10收货城市{{details.shipmentPlace}} FPOOrderEntry.F_lyzx_Text3订单类型_function case '{{details.orderType}}' when '11' then '无PO订单' when '1' then '客户订单' when '2' then '备货订单' when '10' then '返修订单' when '12' then '免费打样' when '3' then '异常订单' when '13' then '备货转销售订单' when '14' then '售后维修' when '18' then '直接出库订单' when '22' then '转换订单A' when '23' then '转换订单B' when '24' then '紧急订单' end FPOOrderEntry.F_lyzx_Text13下料尺寸{{details.rawSpec}} FPOOrderEntry.F_UZMJ_Text四化明细行id{{details.purRecordDetailUuid}} FPOOrderEntry.F_UZMJ_Text四化采购订单id{{details.purRecordDetailUuid}} FPOOrderEntry.F_UZMJ_Text47项目function case '{{details.itemCategory}}' when '1' then '耳机' when '2' then '手机' when '3' then '散件' when '4' then '设备' end FPOOrderEntry.F_UZMJ_Text8订单号{{details.orderNo}} FPOOrderEntry.F_UZMJ_Text1专案{{details.projectName}} FPOOrderEntry.F_UZMJ_Text2派工案号{{details.bomNo}} FPOOrderEntry.F_UZMJ_Base8计价料号{{details.parentPartNo}} FPOOrderEntry.F_UZMJ_Base9规格料号{{details.rawPartNo}} FPOOrderEntry.F_UZMJ_Text17件号{{details.keyNo}} FPOOrderEntry.F_UZMJ_Text3单据来源{{details.takeApartType}} FPOOrderEntry.F_UZMJ_Text16回货状态_function case '{{details.detailBackStatus}}' when '1' then '未回货' when '2' then '部分回货' when '3' then '已回货' when '4' then '已送货' end FPOOrderEntry.F_UZMJ_Text4替换派工案号 FPOOrderEntry.F_UZMJ_Text19采购重量{{details.rawPurchaseWeight}} FPOOrderEntry.F_UZMJ_Qty需求数{{details.totalDemandNum}} FPOOrderEntry.F_UZMJ_Text29未税总价{{details.untaxedTotalPrice}} FPOOrderEntry.F_UZMJ_Text30含税总价{{details.purTotalPrice}} FPOOrderEntry.F_UZMJ_Text31拒签原因{{details.purReason}} FPOOrderEntry.F_UZMJ_Base10零件编码{{details.productNo}} FPOOrderEntry.F_UZMJ_Text26条码{{details.barcode}} FPOOrderEntry.F_UZMJ_Text43申请部门{{details.deptName}} FPOOrderEntry.F_UZMJ_Text42采购申请人{{details.createName}} FPOOrderEntry.F_UZMJ_Text15业务备注{{details.bomRemark}} FPOOrderEntry.F_UZMJ_Text44客户{{details.customerName}} FPOOrderEntry.F_UZMJ_Base2加工费料号{{details.processPartNo}} FPOOrderEntry.F_UZMJ_Qty2小计{{details.subtotal}} FPOOrderEntry.F_UZMJ_Text18是否核对否 FPOOrderEntry.F_UZMJ_Text50MES订单类型原材料采购 FPOOrderEntry.FormId业务对象表单IdPUR_PurchaseOrder必须填写金蝶的表单ID如😛UR_PurchaseOrder FPOOrderEntry.Operation执行的操作BatchSave FPOOrderEntry.IsAutoSubmitAndAudit提交并审核true FPOOrderEntry.IsVerifyBaseDataField验证基础资料true是否验证所有的基础资料有效性,布尔类,默认false(非必录)

数据对接效果

从API服务总线层面解决企业烟囱式业务系统集成现状 相互连接企业各业务系统,实现流程端到端打通,复用已有的业务系统能力,让集成架构、服务关系更清晰 使用统一的API管理平台,对API进行显性化、可视化,使所有API服务成为企业的数字资产,提升API利用率,发挥业务系统价值,实现企业IT资产的可插拔、可复用、可组成。
系统接口打通
API数据集成