金蝶云星空和四化智造MES(WEB)单据接口对接

接通系统:四化智造MES(WEB)
“MES助力智能制造过程控制:MES管理生产订单的整个生产流程,通过对生产过程的所有突发事件实时监控,自动纠正生产过程中的错误或提供决策支持,以实现生产调度要求;在出现异常或与生产计划偏离太大时,及时反馈相关人员使其采取相应的措施。任务派工:MES在生产计划完成后,自动生成任务派工单,根据生产设备实际加工能力的变化,制定并优化生产的具体过程及各设备的详细操作顺序
对接目标平台:金蝶云星空
金蝶K/3Cloud在总结百万家客户管理最佳实践的基础上,提供了标准的管理模式;通过标准的业务架构:多会计准则、多币别、多地点、多组织、多税制应用框架等,有效支持企业的运营管理;K/3Cloud提供了标准的业务建模:35种标准ERP领域模型、1046种模型元素、21243种模型元素属性组合,288个业务服务构件,让企业及伙伴可快速构建出行业化及个性化的应用。
数据接口配置方案
使用轻易云系统数据集成平台对应的模块:数据集成方案。然后选择开始创建数据集成方案。在方案配置表单中选择对应的源业务系统:四化智造MES(WEB),然后选择对应的连接器。选择对应的原材料/标准件采购查询(待采购)作为数据对接来源。然后再通过写入目标平台配置目标系统为金蝶云星空,并且选择对应连接器(关于金蝶云星空的接口如何配置可以在轻易云数据集成社区论坛中找到相关信息,选择好对应的采购订单新增接口作为数据写入动作,既可以完成第一步的数据对接配置。

四化智造MES(WEB)接口明细
- 调用接口:mbs/pur/record/purDetailList
- 接口名称:原材料/标准件采购查询(待采购)
- 方法:GET
请求参数
字段 | 字段名称 | 类型 | 配置值 |
pageNum | 页码 | string | 1 |
pageSize | 页数 | string | 100 |
BeginTime | 开始时间 | string | {{LAST_SYNC_TIME datetime}} |
EndTime | 结束时间 | string | {{CURRENT_TIME datetime}} |
purType | 采购类型 | string | 6 |
响应参数
字段 | 字段名称 | 类型 | 配置值 |
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 | |
金蝶云星空接口明细
- 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.FPrice | 单价 | {{details.untaxedPrice}} | |
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' end | true 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 '1' then '客户订单' when '2' then '备货订单' when '3' then '异常订单' when '10' then '返修订单' when '11' then '无po订单' when '13' then '备货转销售订单' when '14' then '售后维修' when '12' then '免费打样' end | |
FPOOrderEntry.F_lyzx_Text13 | 下料尺寸 | {{details.rawSpec}} | |
FPOOrderEntry.F_UZMJ_Text | 四化明细行id | {{details.purRecordDetailUuid}} | |
FPOOrderEntry.F_UZMJ_Text42 | 采购申请人 | {{details.createName}} | |
FPOOrderEntry.F_sh_id | 四化采购订单id | {{purRecordUuid}} | |
FPOOrderEntry.F_UZMJ_Text18 | 是否核对 | 否 | |
FPOOrderEntry.F_UZMJ_Text50 | MES订单类型 | 校正采购 | |
FPOOrderEntry.FormId | 业务对象表单Id | PUR_PurchaseOrder | 必须填写金蝶的表单ID如😛UR_PurchaseOrder |
FPOOrderEntry.Operation | 执行的操作 | BatchSave | |
FPOOrderEntry.IsAutoSubmitAndAudit | 提交并审核 | true | |
FPOOrderEntry.IsVerifyBaseDataField | 验证基础资料 | true | 是否验证所有的基础资料有效性,布尔类,默认false(非必录) |
系统集成总览
通过无代码的数据集成与数据建模的智能数据管道技术,帮助企业将所有应用程序、数据库、事件和文件等数据信息提取到数据仓库中,并快速将分散的数据转化为数据集、API、自动化流程等开箱即用的数据服务。配置接口的模式对接四化智造MES(WEB)和金蝶云星空,使得单据无缝互通。打造企业内部数据一体化,让企业日常运营管理实现敏捷数据化运营。实现供应链业务信息流的互通,同时支持供应链数据分析流程自动化,结果推送,推进相关供应链问题优化。及时打通供应链孤岛,实现数据驱动供应链协同,进一步提升企业竞争力。
