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

来源系统:四化智造MES(WEB)
MES系统是集成生产管理、品质管理、设备管理、BI数据中心、库存管理、工时管理、数据采集、看板管理等为一体的综合性生产管理系统。通过强调制造过程的透明化,帮助企业由粗放式向精益化管理模式升级。
写入目标:金蝶云星空
金蝶K/3Cloud(金蝶云星空)是移动互联网时代的新型ERP,是基于WEB2.0与云技术的新时代企业管理服务平台。金蝶K/3Cloud围绕着“生态、人人、体验”,旨在帮助企业打造面向新时代的生态互联与协同平台,围绕生态中的每个角色,提供随手可得的云服务,最终实现敏捷协同,智慧运营的企业运营新境界。整个产品采用SOA架构,完全基于BOS平台组建而成,业务架构上贯穿流程驱动与角色驱动思想,结合中国管理模式与中国管理实践积累,精细化支持企业财务管理、供应链管理、生产管理、供应链协同管理、人力资源管理等核心应用。技术架构上该产品采用平台化构建,支持跨数据库应用,支持本地部署、私有云部署与公有云部署三种部署方式,同时还在公有云上开放中国第一款基于ERP的协同开发云平台。任何一家使用金蝶K/3Cloud产品的企业,其拥有的是包含金蝶在内的众多基于同一个平台提供服务的IT服务伙伴。
数据接口配置方案
系统对接前期需要通过调研公司的业务,规划出最便捷,效率最高的整体流程。通过流程我们需要建立对应的方案来吧这些流程一一的落地,轻易云集成平台开箱即用的、可视化拖、拉、拽实现接口服务编排与聚合。只需要根据指引设定好对应的参数即可启动使用。设定好源平台:四化智造MES(WEB)的接口参数设置,以及设定好目标平台:金蝶云星空的映射,即可启动方案进行测试



四化智造MES(WEB)接口明细
- 调用接口:mbs/pur/record/purDetailList
- 接口名称:原材料/标准件采购查询(待采购)
- 方法:GET
请求参数
字段字段名称类型配置值
pageNum页码string1
pageSize页数string500
BeginTime开始时间string{{LAST_SYNC_TIME datetime}}
EndTime结束时间string{{CURRENT_TIME datetime}}
purType采购类型string1
updateTime更新时间string
purStatus订单状态string
filtrationBomStatus显示与影藏string1
响应参数
字段字段名称类型配置值
mchIdmchIdstring
createBycreateBystring
createNamecreateNamestring
checkLabelcheckLabelstring
createTimecreateTimestring
updateByupdateBystring
updateNameupdateNamestring
updateTimeupdateTimestring
remarkremarkstring
companyCodecompanyCodestring
currentUserBycurrentUserBystring
currentUserNamecurrentUserNamestring
currentTimecurrentTimestring
filtrationBomStatusfiltrationBomStatusstring
ididstring
recordIdrecordIdstring
detailIddetailIdstring
purIdpurIdstring
coefficientcoefficientstring
haveDeliveryNumhaveDeliveryNumstring
supplierUuidsupplierUuidstring
patterNopatterNostring
customerDeliveryDatecustomerDeliveryDatestring
supplierNamesupplierNamestring
supplierFullNamesupplierFullNamestring
purRecordUuidpurRecordUuidstring
purRecordDetailUuidpurRecordDetailUuidstring
purTaskUuidpurTaskUuidstring
takeApartDetailUuidtakeApartDetailUuidstring
orderUuidorderUuidstring
bomUuidbomUuidstring
planBomUuidplanBomUuidstring
partNopartNostring
processNameprocessNamestring
gradeNamegradeNamestring
picNopicNostring
qualityqualitystring
purTypepurTypestring
outsourcedTypeoutsourcedTypestring
outProcessCodeoutProcessCodestring
heatTreatmentheatTreatmentstring
bomNobomNostring
keyNokeyNostring
locationCodelocationCodestring
barcodebarcodestring
purchaseNumpurchaseNumstring
purPricepurPricestring
purTotalPricepurTotalPricestring
reqDatereqDatestring
productUuidproductUuidstring
outsourcedWayoutsourcedWaystring
outsourcedWayListoutsourcedWayListstring
locationUuidlocationUuidstring
stockNumstockNumstring
deliveryDatedeliveryDatestring
reqNoreqNostring
deptNamedeptNamestring
totalDemandNumtotalDemandNumstring
productNoproductNostring
productNameproductNamestring
orderNoorderNostring
orderTypeorderTypestring
customerNamecustomerNamestring
projectCodeprojectCodestring
purNopurNostring
purReasonpurReasonstring
purStatuspurStatusstring
backStatusbackStatusstring
customerOrderNocustomerOrderNostring
deptIddeptIdstring
receiveByreceiveBystring
receiveTimereceiveTimestring
receiveNamereceiveNamestring
takeApartTypetakeApartTypestring
specspecstring
brandbrandstring
materialInfoNomaterialInfoNostring
craftIdcraftIdstring
rawPurchaseWeightrawPurchaseWeightstring
rawMaterialInfoNorawMaterialInfoNostring
purTaskTypepurTaskTypestring
ifMoldifMoldstring
taxPricetaxPricestring
taxTotalPricetaxTotalPricestring
untaxedPriceuntaxedPricestring
untaxedTotalPriceuntaxedTotalPricestring
taxRatetaxRatestring
customerPartNocustomerPartNostring
stockTimestockTimestring
purchaseUnitNopurchaseUnitNostring
purchaseUnitNamepurchaseUnitNamestring
returnsNumberreturnsNumberstring
replaceModeNoreplaceModeNostring
secondPurTypesecondPurTypestring
isSecondPurisSecondPurstring
checkedNumcheckedNumstring
processingFeeprocessingFeestring
itemCategoryitemCategorystring
stagestagestring
projectNameprojectNamestring
rawMaterialInforawMaterialInfostring
rawPartNorawPartNostring
rawGradeNamerawGradeNamestring
rawSpecrawSpecstring
rawBrandrawBrandstring
rawQualityrawQualitystring
rawQuantityrawQuantitystring
nuclearPriceTaskUuidnuclearPriceTaskUuidstring
detailBackStatusdetailBackStatusstring
unitNameunitNamestring
processingTypeprocessingTypestring
beginReqDatebeginReqDatestring
endReqDateendReqDatestring
beginReceiveTimebeginReceiveTimestring
endReceiveTimeendReceiveTimestring
beginReplyTimebeginReplyTimestring
endReplyTimeendReplyTimestring
isAbnormalisAbnormalstring
bomVersionbomVersionstring
orderNumorderNumstring
workNoworkNostring
bomContractNobomContractNostring
urgentNeedNourgentNeedNostring
bomRemarkbomRemarkstring
distributeNumdistributeNumstring
distributeDatedistributeDatestring
purRevokeUuidpurRevokeUuidstring
businessUuidbusinessUuidstring
filePathfilePathstring
fileNamefileNamestring
fileSuffixfileSuffixstring
fileName2dfileName2dstring
filePath2dfilePath2dstring
fileName3dfileName3dstring
filePath3dfilePath3dstring
changeRemarkchangeRemarkstring
changeColorchangeColorstring
invTypeNameinvTypeNamestring
rawUnitNamerawUnitNamestring
bomStatusbomStatusstring
bomClosebomClosestring
shipmentPlaceshipmentPlacestring
realNamerealNamestring
procuredNumprocuredNumstring
taskPurTypetaskPurTypestring
moldNomoldNostring
purCreateNamepurCreateNamestring
uploadFileTimeuploadFileTimestring
replyTimereplyTimestring
beginPurchaseTimebeginPurchaseTimestring
endPurchaseTimeendPurchaseTimestring
dispatchNodispatchNostring
orderGradeNameorderGradeNamestring
orderPartNoorderPartNostring
parentMaterialInfoNoparentMaterialInfoNostring
closeReasoncloseReasonstring
closeUsercloseUserstring
closeTimecloseTimestring
revokeReasonrevokeReasonstring
revokeNamerevokeNamestring
revokeTimerevokeTimestring
detailStatusdetailStatusstring
customerAndUrgentcustomerAndUrgentstring
orderNoBomorderNoBomstring
singleSetNumsingleSetNumstring
receiveNumreceiveNumstring
minPurchaseNumminPurchaseNumstring
purNo采购订单号string
金蝶云星空接口明细
- API:batchSave
- NAME:采购订单新增
- METHOD:POST
请求参数
接口字段字段名称预设值描述
FBillNo单据编号{{purNo}}
FDate采购日期{{createTime}}
FPurchaseOrgId采购组织1
FSupplierId供应商{{supplierUuid}}
FPurchaserGroupId采购组
FPurchaserId采购员
FBillTypeID单据类型ZZJPO
FBusinessType业务类型CG
FPOOrderEntry明细信息details
FPOOrderEntry.FMaterialId物料编码{{details.partNo}}
FPOOrderEntry.FQty采购数量{{details.purchaseNum}}
FPOOrderEntry.FEntryDiscountRate折扣率%
FPOOrderEntry.FEntryTaxRate税率%
function {{details.taxRate}}*100
FPOOrderEntry.FTaxNetPrice净价
FPOOrderEntry.FEntryAmount金额
FPOOrderEntry.FAllAmount价税合计
FPOOrderEntry.FEntryNote备注
FPOOrderEntry.FTaxPrice含税单价{{details.purPrice}}
FPOOrderEntry.FEntryTaxAmount税额
FPOOrderEntry.FRowCost行费用
FPOOrderEntry.FDeliveryDate交货日期{{details.reqDate}}
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.spec}}
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_Text17件号{{details.picNo}}
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替换派工案号{{details.replaceModeNo}}
FPOOrderEntry.F_UZMJ_Qty需求数{{details.totalDemandNum}}
FPOOrderEntry.F_UZMJ_Text6替换料号名称{{details.replaceName}}
FPOOrderEntry.F_UZMJ_Text5是否替换料号{{details.ynReplace}}
FPOOrderEntry.F_UZMJ_Qty1用量比{{details.singleSetNum}}
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_Text9请购单号{{details.reqNo}}
FPOOrderEntry.F_UZMJ_Text7换算系数{{details.coefficient}}
FPOOrderEntry.F_UZMJ_Text10产品编号{{details.orderPartNo}}
FPOOrderEntry.F_UZMJ_Text11产品名称{{details.orderGradeName}}
FPOOrderEntry.F_UZMJ_Text12加工图档路径{{details.processFilePath}}
FPOOrderEntry.F_sh_id四化采购订单id{{purRecordUuid}}
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层面解决企业烟囱式业务系统集成现状,实现深度的业务流程拉通四化智造MES(WEB)到金蝶云星空之间数据集成;通过API连接各业务系统,复用已有的业务系统能力,让集成架构、服务关系更清晰。使用统一的API管理平台,对API进行显性化、可视化,使所有API服务成为企业的数字资产,提升复用率和价值。全面管控企业的API资产,梳理现有业务系统的API。实现API文档的统一管理,建立API的上线、下线、监控的统一管理体系及标准规范。已链接和打通主流SaaS系统超过100+,快速对接各种API接口,实现云上云下的互联互通。将SaaS和本地业务系统联接起来,打破时间与空间界限,打通原有核心数据及SaaS应用,构建可平滑演进的企业IT架构。


