从四化智造MES（WEB）到金蝶云星空通过接口集成数据
源系统:四化智造MES（WEB）
MES系统是集成生产管理、品质管理、设备管理、BI数据中心、库存管理、工时管理、数据采集、看板管理等为一体的综合性生产管理系统。通过强调制造过程的透明化，帮助企业由粗放式向精益化管理模式升级。
对接系统：金蝶云星空
金蝶K/3Cloud结合当今先进管理理论和数十万家国内客户最佳应用实践，面向事业部制、多地点、多工厂等运营协同与管控型企业及集团公司，提供一个通用的ERP服务平台。K/3Cloud支持的协同应用包括但不限于：集中/分散销售、集中/分散采购、B2B电商管理、B2C电商中心、供应商协同、多工厂计划、跨工厂领料、跨工厂加工、工厂间调拨、内部交易及结算、集团财务管理、阿米巴经营等。
系统对接接口配置
使用系统数据集成平台对应的模块：数据集成方案。然后选择开始创建数据集成方案。在方案配置表单中选择对应的源业务系统：四化智造MES（WEB），然后选择对应的连接器。选择对应的原材料/标准件采购查询（待采购）作为数据对接来源。然后再通过写入目标平台配置目标系统为金蝶云星空,并且选择对应连接器（关于金蝶云星空的接口如何配置可以在轻易云数据集成社区论坛中找到相关信息,选择好对应的采购订单新增接口作为数据写入动作，既可以完成第一步的数据对接配置。
四化智造MES（WEB）接口明细
- 调用接口：mbs/pur/record/purDetailList
- 接口名称：原材料/标准件采购查询（待采购）
- 方法：GET
请求参数
| 字段 | 字段名称 | 类型 | 配置值 |
|---|
| pageNum | 页码 | string | 1 |
| pageSize | 页数 | string | 500 |
| BeginTime | 开始时间 | string | {{LAST_SYNC_TIME datetime}} |
| EndTime | 结束时间 | string | {{CURRENT_TIME datetime}} |
| purType | 采购类型 | string | 4 |
| updateTime | 更新时间 | string | |
| purStatus | 订单状态 | string | |
响应参数
| 字段 | 字段名称 | 类型 | 配置值 |
|---|
| mchId | mchId | string | |
| createBy | createBy | string | |
| createName | createName | string | |
| checkLabel | checkLabel | string | |
| createTime | createTime | string | |
| updateBy | updateBy | string | |
| updateName | updateName | string | |
| updateTime | updateTime | string | |
| remark | remark | string | |
| companyCode | companyCode | string | |
| currentUserBy | currentUserBy | string | |
| currentUserName | currentUserName | string | |
| currentTime | currentTime | string | |
| filtrationBomStatus | filtrationBomStatus | string | |
| id | id | string | |
| recordId | recordId | string | |
| detailId | detailId | string | |
| purId | purId | string | |
| coefficient | coefficient | string | |
| haveDeliveryNum | haveDeliveryNum | string | |
| supplierUuid | supplierUuid | string | |
| patterNo | patterNo | string | |
| customerDeliveryDate | customerDeliveryDate | string | |
| supplierName | supplierName | string | |
| supplierFullName | supplierFullName | string | |
| purRecordUuid | purRecordUuid | string | |
| purRecordDetailUuid | purRecordDetailUuid | string | |
| purTaskUuid | purTaskUuid | string | |
| takeApartDetailUuid | takeApartDetailUuid | string | |
| orderUuid | orderUuid | string | |
| bomUuid | bomUuid | string | |
| planBomUuid | planBomUuid | string | |
| partNo | partNo | string | |
| processName | processName | string | |
| gradeName | gradeName | string | |
| picNo | picNo | string | |
| quality | quality | string | |
| purType | purType | string | |
| outsourcedType | outsourcedType | string | |
| outProcessCode | outProcessCode | string | |
| heatTreatment | heatTreatment | string | |
| bomNo | bomNo | string | |
| keyNo | keyNo | string | |
| locationCode | locationCode | string | |
| barcode | barcode | string | |
| purchaseNum | purchaseNum | string | |
| purPrice | purPrice | string | |
| purTotalPrice | purTotalPrice | string | |
| reqDate | reqDate | string | |
| productUuid | productUuid | string | |
| outsourcedWay | outsourcedWay | string | |
| outsourcedWayList | outsourcedWayList | string | |
| locationUuid | locationUuid | string | |
| stockNum | stockNum | string | |
| deliveryDate | deliveryDate | string | |
| reqNo | reqNo | string | |
| deptName | deptName | string | |
| totalDemandNum | totalDemandNum | string | |
| productNo | productNo | string | |
| productName | productName | string | |
| orderNo | orderNo | string | |
| orderType | orderType | string | |
| customerName | customerName | string | |
| projectCode | projectCode | string | |
| purNo | purNo | string | |
| purReason | purReason | string | |
| purStatus | purStatus | string | |
| backStatus | backStatus | string | |
| customerOrderNo | customerOrderNo | string | |
| deptId | deptId | string | |
| receiveBy | receiveBy | string | |
| receiveTime | receiveTime | string | |
| receiveName | receiveName | string | |
| takeApartType | takeApartType | string | |
| spec | spec | string | |
| brand | brand | string | |
| materialInfoNo | materialInfoNo | string | |
| craftId | craftId | string | |
| rawPurchaseWeight | rawPurchaseWeight | string | |
| rawMaterialInfoNo | rawMaterialInfoNo | string | |
| purTaskType | purTaskType | string | |
| ifMold | ifMold | string | |
| taxPrice | taxPrice | string | |
| taxTotalPrice | taxTotalPrice | string | |
| untaxedPrice | untaxedPrice | string | |
| untaxedTotalPrice | untaxedTotalPrice | string | |
| taxRate | taxRate | string | |
| customerPartNo | customerPartNo | string | |
| stockTime | stockTime | string | |
| purchaseUnitNo | purchaseUnitNo | string | |
| purchaseUnitName | purchaseUnitName | string | |
| returnsNumber | returnsNumber | string | |
| replaceModeNo | replaceModeNo | string | |
| secondPurType | secondPurType | string | |
| isSecondPur | isSecondPur | string | |
| checkedNum | checkedNum | string | |
| processingFee | processingFee | string | |
| itemCategory | itemCategory | string | |
| stage | stage | string | |
| projectName | projectName | string | |
| rawMaterialInfo | rawMaterialInfo | string | |
| rawPartNo | rawPartNo | string | |
| rawGradeName | rawGradeName | string | |
| rawSpec | rawSpec | string | |
| rawBrand | rawBrand | string | |
| rawQuality | rawQuality | string | |
| rawQuantity | rawQuantity | string | |
| nuclearPriceTaskUuid | nuclearPriceTaskUuid | string | |
| detailBackStatus | detailBackStatus | string | |
| unitName | unitName | string | |
| processingType | processingType | string | |
| beginReqDate | beginReqDate | string | |
| endReqDate | endReqDate | string | |
| beginReceiveTime | beginReceiveTime | string | |
| endReceiveTime | endReceiveTime | string | |
| beginReplyTime | beginReplyTime | string | |
| endReplyTime | endReplyTime | string | |
| isAbnormal | isAbnormal | string | |
| bomVersion | bomVersion | string | |
| orderNum | orderNum | string | |
| workNo | workNo | string | |
| bomContractNo | bomContractNo | string | |
| urgentNeedNo | urgentNeedNo | string | |
| bomRemark | bomRemark | string | |
| distributeNum | distributeNum | string | |
| distributeDate | distributeDate | string | |
| purRevokeUuid | purRevokeUuid | string | |
| businessUuid | businessUuid | string | |
| filePath | filePath | string | |
| fileName | fileName | string | |
| fileSuffix | fileSuffix | string | |
| fileName2d | fileName2d | string | |
| filePath2d | filePath2d | string | |
| fileName3d | fileName3d | string | |
| filePath3d | filePath3d | string | |
| changeRemark | changeRemark | string | |
| changeColor | changeColor | string | |
| invTypeName | invTypeName | string | |
| rawUnitName | rawUnitName | string | |
| bomStatus | bomStatus | string | |
| bomClose | bomClose | string | |
| shipmentPlace | shipmentPlace | string | |
| realName | realName | string | |
| procuredNum | procuredNum | string | |
| taskPurType | taskPurType | string | |
| moldNo | moldNo | string | |
| purCreateName | purCreateName | string | |
| uploadFileTime | uploadFileTime | string | |
| replyTime | replyTime | string | |
| beginPurchaseTime | beginPurchaseTime | string | |
| endPurchaseTime | endPurchaseTime | string | |
| dispatchNo | dispatchNo | string | |
| orderGradeName | orderGradeName | string | |
| orderPartNo | orderPartNo | string | |
| parentMaterialInfoNo | parentMaterialInfoNo | string | |
| closeReason | closeReason | string | |
| closeUser | closeUser | string | |
| closeTime | closeTime | string | |
| revokeReason | revokeReason | string | |
| revokeName | revokeName | string | |
| revokeTime | revokeTime | string | |
| detailStatus | detailStatus | string | |
| customerAndUrgent | customerAndUrgent | string | |
| orderNoBom | orderNoBom | string | |
| singleSetNum | singleSetNum | string | |
| receiveNum | receiveNum | string | |
| minPurchaseNum | minPurchaseNum | string | |
金蝶云星空接口明细
- 调用接口：batchSave
- 接口名称：采购订单新增
- 方法：POST
请求参数
| 字段 | 字段名称 | 类型 | 配置值 |
|---|
| FBillNo | 单据编号 | string | {{purNo}} |
| FDate | 采购日期 | string | {{createTime}} |
| FPurchaseOrgId | 采购组织 | string | 1 |
| FSupplierId | 供应商 | string | {{supplierUuid}} |
| FPurchaserGroupId | 采购组 | string | |
| FPurchaserId | 采购员 | string | |
| FBillTypeID | 单据类型 | string | ZZJPO |
| FBusinessType | 业务类型 | string | CG |
| FPOOrderEntry | 明细信息 | array | details |
| FPOOrderEntry.FMaterialId | 物料编码 | string | {{details.partNo}} |
| FPOOrderEntry.FQty | 采购数量 | string | {{details.purchaseNum}} |
| FPOOrderEntry.FPrice | 单价 | string | {{details.untaxedPrice}} |
| FPOOrderEntry.FEntryDiscountRate | 折扣率% | string | |
| FPOOrderEntry.FEntryTaxRate | 税率% | string | function {{details.taxRate}}*100 |
| FPOOrderEntry.FTaxNetPrice | 净价 | string | |
| FPOOrderEntry.FEntryAmount | 金额 | string | |
| FPOOrderEntry.FAllAmount | 价税合计 | string | |
| FPOOrderEntry.FEntryNote | 备注 | string | |
| FPOOrderEntry.FTaxPrice | 含税单价 | string | {{details.purPrice}} |
| FPOOrderEntry.FEntryTaxAmount | 税额 | string | |
| FPOOrderEntry.FRowCost | 行费用 | string | |
| FPOOrderEntry.FDeliveryDate | 交货日期 | string | {{details.reqDate}} |
| FPOOrderEntry.FMtoNo | 计划跟踪号 | string | {{details.bomNo}} |
| FPOOrderEntry.FGiveAway | 是否赠品 | string | _function case '{{details.ifFreebie}}' when '0' then 'true' when '1' then 'false' end |
| FPOOrderEntry.F_lyzx_Text4 | 模件号 | string | {{details.patterNo}} |
| FPOOrderEntry.F_lyzx_Text5 | 阶段 | string | {{details.stage}} |
| FPOOrderEntry.F_lyzx_Text6 | 客户订单号 | string | {{details.customerOrderNo}} |
| FPOOrderEntry.F_lyzx_Text7 | 紧急需求单号 | string | {{details.urgentNeedNo}} |
| FPOOrderEntry.F_lyzx_Text8 | 发包单号 | string | {{details.bomContractNo}} |
| FPOOrderEntry.F_lyzx_Text9 | 工令单号 | string | {{details.workNo}} |
| FPOOrderEntry.F_lyzx_Text10 | 收货城市 | string | {{details.shipmentPlace}} |
| FPOOrderEntry.F_lyzx_Text3 | 订单类型 | string | _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 | 下料尺寸 | string | {{details.rawSpec}} |
| FPOOrderEntry.F_UZMJ_Text | 四化明细行id | string | {{details.purRecordDetailUuid}} |
| FPOOrderEntry.F_UZMJ_Text42 | 采购申请人 | string | {{details.createName}} |
| FPOOrderEntry.F_sh_id | 四化采购订单id | string | {{purRecordUuid}} |
| FPOOrderEntry.F_UZMJ_Text18 | 是否核对 | string | 否 |
| FPOOrderEntry.F_UZMJ_Text50 | MES订单类型 | string | 其他采购 |
| FPOOrderEntry.FormId | 业务对象表单Id | string | PUR_PurchaseOrder |
| FPOOrderEntry.Operation | 执行的操作 | string | BatchSave |
| FPOOrderEntry.IsAutoSubmitAndAudit | 提交并审核 | bool | true |
| FPOOrderEntry.IsVerifyBaseDataField | 验证基础资料 | bool | true |
系统对接总览
基于轻易云的连接器和数据服务能力，轻松实现供应链异构系统的“相互沟通”，通过数据应用自动化业务流程管理，全面管控供应链的每一环节。从要货、销售出库、退货入库、到盘点、调拨，无需人工参与，实时更新，自动化流转。通过快速连接四化智造MES（WEB）接口抽取数据后再自动分发到金蝶云星空， 解放生产力，自动生成数据、并分发推送到业务应用，数据传递时效性提升10倍以上。
