金蝶云星空对接打通四化智造MES（API）逐个单据查询接口与新增客户信息接口

数据源系统:金蝶云星空

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

目标系统:四化智造MES（API）

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

多系统对接方案配置

异构系统具有非常丰富的业务流程、复杂的系统架构和服务接口。在很多情况下，这两个系统都是分别独立部署和运行的，各自拥有不同的技术栈和编程模型，甚至两者在系统平台、技术平台和编程语言上是完全异构的。那么对接就需要根据接口配置对应的规则，例如取数就要根据查询接口获取金蝶云星空的数据，并且根据对应的条件进行取数，目标系统就必须根据目标系统的格式，以及获取的数据进行加工处理后进行写入到四化智造MES（API）中。轻易云集成平台的可视化配置轻松实现。

金蝶云星空接口明细

调用接口：ExecuteBillQuery
接口名称：逐个单据查询
方法：POST

请求参数

字段字段名称类型配置值 Limit最大行数string{{PAGINATION_PAGE_SIZE}} StartRow开始行索引string{{PAGINATION_START_ROW}} TopRowCount返回总行数int FilterString过滤条件stringFApproveDate>='{{LAST_SYNC_TIME dateTime}}' FieldKeys需查询的字段key集合array FormId业务对象表单IdstringPRD_MO

响应参数

字段字段名称类型配置值 BillNo单据编号string DocumentStatus单据状态string ApproverId_Id审核人Idstring ApproverId_Name审核人_名称string ApproverId_Number审核人编码string ApproveDate审核日期string ModifierId_Id修改人_Idstring ModifierId_Name修改人名称string ModifierId_Number修改人_编码string CreateDate创建日期string CreatorId_Id创建人Idstring CreatorId_Name创建人_名称string CreatorId_Number创建人编码string ModifyDate修改日期string CancelDate作废日期string CANCELER_Id作废人_Idstring CANCELER_Name作废人名称string CANCELER_Number作废人_编码string CancelStatus作废状态string Description备注string BillType单据类型string Trustteed受托string WorkShopID_Id生产车间Idstring WorkShopID_Name生产车间_名称string WorkShopID_Number生产车间编码string PrdOrgId_Id生产组织_Idstring PrdOrgId_Name生产组织名称string PrdOrgId_Number生产组织_编码string PlannerID_Id计划员Idstring PlannerID_Name计划员_名称string PlannerID_Number计划员编码string Date单据日期string OwnerTypeId货主类型string OwnerId货主string WorkGroupId_Id计划组_Idstring WorkGroupId_Name计划组名称string WorkGroupId_Number计划组_编码string BusinessType销售业务类型string IsRework是否返工string IsEntrust组织受托加工string ENTrustOrgId_Id委托组织Idstring ENTrustOrgId_Name委托组织_名称string ENTrustOrgId_Number委托组织编码string PPBOMType用料清单展开string IssueMtrl生产发料string IsQCMO期初生产订单string F_UZMJ_Text2是否核对string F_UZMJ_Text5MES工单类型string F_UZMJ_CheckBox产品检验1string TreeEntity明细array TreeEntity.ParentRowId父级行主键string TreeEntity.RowExpandType行展开类型string TreeEntity.RowId行标识string TreeEntity.MaterialId_Id物料编码_Idstring TreeEntity.MaterialId_Name物料编码名称string TreeEntity.MaterialId_Number物料编码_编码string TreeEntity.ProductType产品类型string TreeEntity.Qty数量string TreeEntity.PlanFinishDate计划完工时间string TreeEntity.PlanStartDate计划开工时间string TreeEntity.Lot_Id批号Idstring TreeEntity.Lot_Name批号_名称string TreeEntity.Lot_Number批号编码string TreeEntity.MTONo计划跟踪号string TreeEntity.ProjectNo项目编号string TreeEntity.BaseUnitQty基本单位数量string TreeEntity.Group组别string TreeEntity.BomId_IdBOM版本_Idstring TreeEntity.BomId_NameBOM版本名称string TreeEntity.BomId_NumberBOM版本_编码string TreeEntity.RoutingId_Id工艺路线Idstring TreeEntity.RoutingId_Name工艺路线_名称string TreeEntity.RoutingId_Number工艺路线编码string TreeEntity.YieldRate成品率%string TreeEntity.StockInLimitH入库上限string TreeEntity.StockInLimitL入库下限string TreeEntity.StockInQuaSelAuxQty合格品入库选单数量string TreeEntity.StockInQuaSelQty基本单位合格品入库选单数量string TreeEntity.StockInFailSelQty基本单位不合格品入库选单数量string TreeEntity.StockInFailSelAuxQty不合格品入库选单数量string TreeEntity.StockInQuaQty基本单位合格品入库数量string TreeEntity.StockInQuaAuxQty合格品入库数量string TreeEntity.StockInFailQty基本单位不合格品入库数量string TreeEntity.StockInFailAuxQty不合格品入库数量string TreeEntity.StockInOrgId_Id入库组织_Idstring TreeEntity.StockInOrgId_Name入库组织名称string TreeEntity.StockInOrgId_Number入库组织_编码string TreeEntity.StockId_Id仓库Idstring TreeEntity.StockId_Name仓库_名称string TreeEntity.StockId_Number仓库编码string TreeEntity.StockLocId_Id仓位_Idstring TreeEntity.StockLocId_Name仓位名称string TreeEntity.StockLocId_Number仓位_编码string TreeEntity.OperId产出工序string TreeEntity.ProcessId_Id产出作业编码Idstring TreeEntity.ProcessId_Name产出作业编码_名称string TreeEntity.ProcessId_Number产出作业编码编码string TreeEntity.CostRate成本权重string TreeEntity.Memo备注(禁用)string TreeEntity.PlanConfirmDate计划确认日期string TreeEntity.ScheduleDate排程日期string TreeEntity.ConveyDate下达日期string TreeEntity.StartDate开工日期string TreeEntity.FinishDate完工日期string TreeEntity.CloseDate结案日期string TreeEntity.CostDate结算日期string TreeEntity.CreateType生成方式string TreeEntity.SrcBillId来源单据IDstring TreeEntity.SrcBillEntryId来源单据分录内码string TreeEntity.SaleOrderId销售订单IDstring TreeEntity.SaleOrderNo需求单据string TreeEntity.SaleOrderEntryId销售订单分录内码string TreeEntity.RequestOrgId_Id需求组织_Idstring TreeEntity.RequestOrgId_Name需求组织名称string TreeEntity.RequestOrgId_Number需求组织_编码string TreeEntity.RepQuaSelQty基本单位汇报选单数量string TreeEntity.RepFailQty基本单位不合格数量string TreeEntity.RepQuaSelAuxQty汇报选单数量string TreeEntity.RepQuaAuxQty合格数量string TreeEntity.RepFailAuxQty不合格数量string TreeEntity.RepQuaQty基本单位合格数量string TreeEntity.Status业务状态string TreeEntity.UnitId_Id单位Idstring TreeEntity.UnitId_Name单位_名称string TreeEntity.UnitId_Number单位编码string TreeEntity.BaseUnitId_Id基本单位_Idstring TreeEntity.BaseUnitId_Name基本单位名称string TreeEntity.BaseUnitId_Number基本单位_编码string TreeEntity.AuxPropId_Id辅助属性Idstring TreeEntity.AuxPropId_Name辅助属性_名称string TreeEntity.AuxPropId_Number辅助属性编码string TreeEntity.BaseStockInLimitH基本单位入库上限string TreeEntity.BaseStockInLimitL基本单位入库下限string TreeEntity.StockInUlRatio入库上限比例string TreeEntity.SrcBillType源单类型string TreeEntity.SrcBillNo源单编号string TreeEntity.SrcBillEntrySeq源单分录行号string TreeEntity.SaleOrderEntrySeq需求单据行号string TreeEntity.BaseYieldQty基本单位成品数量string TreeEntity.CopyEntryId联副产品分录内码string TreeEntity.IsSuspend挂起状态string TreeEntity.StockInLlRatio入库下限比例string TreeEntity.BFLowId业务流程string TreeEntity.RepFailSelQty基本单位汇报不合格选单数量string TreeEntity.RepFailSelAuxQty汇报不合格选单数量string TreeEntity.WorkShopID_Id生产车间_Idstring TreeEntity.WorkShopID_Name生产车间名称string TreeEntity.WorkShopID_Number生产车间_编码string TreeEntity.ReqType需求类型string TreeEntity.Priority需求优先级string TreeEntity.StockReady备料套数string TreeEntity.BaseStockReady基本单位备料数量string TreeEntity.BaseScrapQty基本单位报废数量string TreeEntity.ScrapQty报废数量string TreeEntity.BaseRepairQty基本单位返修数量string TreeEntity.RepairQty返修数量string TreeEntity.BaseStockInScrapSelQty基本单位报废品入库选单数量string TreeEntity.StockInScrapSelQty报废品入库选单数量string TreeEntity.BaseStockInScrapQty基本单位报废品入库数量string TreeEntity.StockInScrapQty报废品入库数量string TreeEntity.InStockOwnerTypeId入库货主类型string TreeEntity.InStockOwnerId入库货主string TreeEntity.InStockType入库类型-推入库单用string TreeEntity.CheckProduct产品检验string TreeEntity.OutPutOptQueue产出序列string TreeEntity.BaseRptFinishQty基本单位汇报完成数量string TreeEntity.RptFinishQty汇报完成数量string TreeEntity.QAIP紧急放行string TreeEntity.YieldQty成品数量string TreeEntity.ISBACKFLUSH倒冲领料string TreeEntity.NoStockInQty未入库数量string TreeEntity.BaseNoStockInQty基本单位未入库数量string TreeEntity.ReqSrc需求来源string TreeEntity.ForceCloserId_Id结案人Idstring TreeEntity.ForceCloserId_Name结案人_名称string TreeEntity.ForceCloserId_Number结案人编码string TreeEntity.REMWorkShopId_Id产线_Idstring TreeEntity.REMWorkShopId_Name产线名称string TreeEntity.REMWorkShopId_Number产线_编码string TreeEntity.ScheduleSeq排产序号string TreeEntity.ScheduleStartTime排程开工时间string TreeEntity.ScheduleFinishTime排程完工时间string TreeEntity.CloseType结案类型string TreeEntity.ScheduleProcSplit排程工序拆分数string TreeEntity.SNUnitID_Id序列号单位Idstring TreeEntity.SNUnitID_Name序列号单位_名称string TreeEntity.SNUnitID_Number序列号单位编码string TreeEntity.SNQty序列号单位数量string TreeEntity.ReStkQty退库数量string TreeEntity.BaseReStkQty基本单位退库数量string TreeEntity.ReStkQuaQty合格品退库数量string TreeEntity.BaseReStkQuaQty基本合格品退库数量string TreeEntity.ReStkFailQty不合格品退库数量string TreeEntity.BaseReStkFailQty基本不合格品退库数量string TreeEntity.ReStkScrapQty报废品退库数量string TreeEntity.BaseReStkScrapQty基本报废品退库数量string TreeEntity.PickMtlQty领料套数string TreeEntity.BasePickMtlQty基本单位领料套数string TreeEntity.ISNEWLC是否手工新增联副产品string TreeEntity.PickMtrlStatus领料状态string TreeEntity.BaseIssueQty基本单位发料通知套数string TreeEntity.IssueQty发料通知套数string TreeEntity.SrcSplitBillNo源拆分订单编号string TreeEntity.SrcSplitSeq源拆分订单行号string TreeEntity.SrcSplitEntryId源拆分订单分录内码string TreeEntity.SrcSplitId源拆分生产订单内码string TreeEntity.MOChangeFlag变更标志string TreeEntity.SrcBomEntryId上级订单BOM分录内码string TreeEntity.ReStkReMadeQty返工品退库数量string TreeEntity.BaseReStkReMadeQty基本单位返工品退库数量string TreeEntity.BaseReMadeQty基本单位返工数量string TreeEntity.ReMadeQty返工数量string TreeEntity.BaseStockInReMadeQty基本单位返工品入库数量string TreeEntity.StockInReMadeQty返工品入库数量string TreeEntity.BaseStockInReMadeSelQty基本单位返工品入库选单数量string TreeEntity.StockInReMadeSelQty返工品入库选单数量string TreeEntity.CloseReason强制结案原因string TreeEntity.BaseScheduledQtySum基本单位已排产数量string TreeEntity.ScheduledQtySum已排产数量string TreeEntity.ScheduleStatus排产状态string TreeEntity.IsFirstInspect首检string TreeEntity.FirstInspectStatus首检状态string TreeEntity.ConfirmId_Id计划确认人_Idstring TreeEntity.ConfirmId_Name计划确认人名称string TreeEntity.ConfirmId_Number计划确认人_编码string TreeEntity.ReleaseId_Id下达人Idstring TreeEntity.ReleaseId_Name下达人_名称string TreeEntity.ReleaseId_Number下达人编码string TreeEntity.StartID_Id开工人_Idstring TreeEntity.StartID_Name开工人名称string TreeEntity.StartID_Number开工人_编码string TreeEntity.FinishId_Id完工人Idstring TreeEntity.FinishId_Name完工人_名称string TreeEntity.FinishId_Number完工人编码string TreeEntity.IsMRP已计划运算string TreeEntity.BaseSampleDamageQty基本单位样本破坏数string TreeEntity.SampleDamageQty样本破坏数string TreeEntity.ISENABLESCHEDULE启用日排产string TreeEntity.PathEntryIdBOM展开路径string TreeEntity.PPBOMENTRYID用料清单分录内码string TreeEntity.BOMENTRYIDBOM分录内码string TreeEntity.SrcFormID用料清单类型string TreeEntity.F_lyzx_Text计划订单号string TreeEntity.F_sh_ywddh四化业务订单号string TreeEntity.F_sh_no四化派工单号string TreeEntity.F_sh_id四化派工单号IDstring TreeEntity.F_sh_bomNo四化派工案号string TreeEntity.F_UZMJ_YCLPC原材料批次string TreeEntity.F_UZMJ_Text下一工序string TreeEntity.F_UZMJ_Text1派工案号string TreeEntity.F_UZMJ_Base_Id入库人_Idstring TreeEntity.F_UZMJ_Base_Name入库人名称string TreeEntity.F_UZMJ_Base_Number入库人_编码string TreeEntity.UZMJ_Date生产日期string TreeEntity.F_UZMJ_KHLH客户料号string TreeEntity.F_UZMJ_Text4客户版次string TreeEntity.F_UZMJ_banci版次string TreeEntity.UZMJ_pinming品名string TreeEntity.F_UZMJ_YCLPH原材料批号string TreeEntity.F_UZMJ_QM签名string TreeEntity.F_UZMJ_YCD原产地string TreeEntity.F_UZMJ_paihao牌号string TreeEntity.F_UZMJ_BZ_Id班组Idstring TreeEntity.F_UZMJ_BZ_Name班组_名称string TreeEntity.F_UZMJ_BZ_Number班组编码string TreeEntity.F_UZMJ_CZ材质string TreeEntity.F_UZMJ_JZ1机种string TreeEntity.F_UZMJ_GG规格string TreeEntity.F_UZMJ_BG包规string TreeEntity.F_UZMJ_YCLLH原材料料号string TreeEntity.F_UZMJ_YCLBC原材料版次string TreeEntity.F_UZMJ_PGJLH抛光件料号string TreeEntity.F_UZMJ_PGJBC抛光件版次string TreeEntity.FREMARK备注string TreeEntity.F_UZMJ_SGXLH上工序料号string TreeEntity.F_UZMJ_SGXBC上工序版次string TreeEntity.F_UZMJ_XIANG板箱代码string TreeEntity.F_UZMJ_DATEY日期(条码)string TreeEntity.F_UZMJ_YABC月(条码)string TreeEntity.F_UZMJ_TMIDID(条码)string TreeEntity.F_UZMJ_TMLSH流水号(条码)string TreeEntity.F_UZMJ_PKGIDPKGID(条码)string TreeEntity.F_UZMJ_DXBZSL单箱标准数量string TreeEntity.F_UZMJ_YCLPCM客户原材料批次码string TreeEntity.F_UZMJ_Text3客户原材料料号(批次码)string TreeEntity.F_UZMJ_Text31客户原材料批次号(批次码)string TreeEntity.SerialSubEntity序列号子单据体array TreeEntity.SerialSubEntity.SNQty数量string TreeEntity.SerialSubEntity.SerialNo序列号string TreeEntity.SerialSubEntity.SerialId_Id序列号_Idstring TreeEntity.SerialSubEntity.SerialId_Name序列号名称string TreeEntity.SerialSubEntity.SerialId_Number序列号_编码string TreeEntity.SerialSubEntity.SNStockInSelQty入库选单数量string TreeEntity.SerialSubEntity.SerialNote备注string TreeEntity.SerialSubEntity.BaseSNQty基本单位数量string TreeEntity.SerialSubEntity.BaseSNStockInSelQty基本单位入库选单数量string TreeEntity.SerialSubEntity.SNRptSelQty汇报选单数量string TreeEntity.SerialSubEntity.BaseSNRptSelQty基本单位汇报选单数量string TreeEntity.SerialSubEntity.ScheduledEntity排产明细表体array TreeEntity.SerialSubEntity.ScheduledEntity.MOENTRYID生产订单分录内码string TreeEntity.SerialSubEntity.ScheduledEntity.MOSEQ生产订单行号string TreeEntity.SerialSubEntity.ScheduledEntity.DetailMaterialId_Id物料编码Idstring TreeEntity.SerialSubEntity.ScheduledEntity.DetailMaterialId_Name物料编码_名称string TreeEntity.SerialSubEntity.ScheduledEntity.DetailMaterialId_Number物料编码编码string TreeEntity.SerialSubEntity.ScheduledEntity.DAILYOUTPUTQTY日产量string TreeEntity.SerialSubEntity.ScheduledEntity.BASEDAILYOUTPUTQTY基本单位日产量string TreeEntity.SerialSubEntity.ScheduledEntity.DetailUnitID_Id单位_Idstring TreeEntity.SerialSubEntity.ScheduledEntity.DetailUnitID_Name单位名称string TreeEntity.SerialSubEntity.ScheduledEntity.DetailUnitID_Number单位_编码string TreeEntity.SerialSubEntity.ScheduledEntity.BaseUnitIdDetail_Id基本单位Idstring TreeEntity.SerialSubEntity.ScheduledEntity.BaseUnitIdDetail_Name基本单位_名称string TreeEntity.SerialSubEntity.ScheduledEntity.BaseUnitIdDetail_Number基本单位编码string TreeEntity.SerialSubEntity.ScheduledEntity.PLANQTY计划数量string TreeEntity.SerialSubEntity.ScheduledEntity.BASEPLANQTY基本单位计划数量string TreeEntity.SerialSubEntity.ScheduledEntity.BASESCHEDULEDQTY基本单位排产数量string TreeEntity.SerialSubEntity.ScheduledEntity.SCHEDULEDQTY排产数量string TreeEntity.SerialSubEntity.ScheduledEntity.PRODUCTIONLINEID_Id产线_Idstring TreeEntity.SerialSubEntity.ScheduledEntity.PRODUCTIONLINEID_Name产线名称string TreeEntity.SerialSubEntity.ScheduledEntity.PRODUCTIONLINEID_Number产线_编码string TreeEntity.SerialSubEntity.ScheduledEntity.PlanStartDateD排产日期string TreeEntity.SerialSubEntity.ScheduledEntity.PlanFinishDateD排产结束string TreeEntity.SerialSubEntity.ScheduledEntity.ISLOCKED锁定string TreeEntity.SerialSubEntity.ScheduledEntity.SchDtlRowId排产标识string TreeEntity.SerialSubEntity.ScheduledEntity.BASEDIFFERQTY基本单位差异数string TreeEntity.SerialSubEntity.ScheduledEntity.DIFFERQTY差异数string TreeEntity.SerialSubEntity.ScheduledEntity.BASEFINISHEDQTY基本单位上线数量string TreeEntity.SerialSubEntity.ScheduledEntity.FINISHEDQTY上线数量string TreeEntity.SerialSubEntity.ScheduledEntity.DIssueQty发料数量string TreeEntity.SerialSubEntity.ScheduledEntity.BaseDIssueQty基本单位发料数量string TreeEntity.SerialSubEntity.ScheduledEntity.MatchQty1齐套数量1string TreeEntity.SerialSubEntity.ScheduledEntity.MatchQty2齐套数量2string

四化智造MES（API）接口明细

API：暂无
NAME：新增客户信息
METHOD：POST

请求参数

接口字段名称预设值 customerPartNo客户料号{{F_lyzx_Text}} CutQmsQualityPlanTaskDTO质检明细信息Entity CutQmsQualityPlanTaskDTO.checkoutName检验项目{{Entity.InspectItemId_Name}} CutQmsQualityPlanTaskDTO.analyticalMethod分析方发{{Entity.AnalysisMethod}} CutQmsQualityPlanTaskDTO.flawLevel缺陷等级{{Entity.DefectLevel}} CutQmsQualityPlanTaskDTO.isEmphasisCheckout是否重点检验（0否 1是）{{Entity.KeyInspect}} CutQmsQualityPlanTaskDTO.isDestroyCheckout是否破坏性检验（0否 1是）{{Entity.DestructInspect}} CutQmsQualityPlanTaskDTO.isSpecimenCheckout是否启用样品检验值（0否 1是）{{Entity.EnableQcValue}} CutQmsQualityPlanTaskDTO.checkoutMethod检验方法{{Entity.InspectMethodId_Name}} CutQmsQualityPlanTaskDTO.qualityStandard质量标准{{Entity.QualityStdId_Name}} CutQmsQualityPlanTaskDTO.inspectionStandard检验依据{{Entity.InspectBasisId_Name}} CutQmsQualityPlanTaskDTO.inspectionInstrument检验仪器{{Entity.InspectInstrumentId_Name}} CutQmsQualityPlanTaskDTO.samplingMethod抽样方式{{Entity.InspectMethodId_Name}} CutQmsQualityPlanTaskDTO.aqlCheckoutAQL{{Entity.FSSAQLE}} CutQmsQualityPlanTaskDTO.stringent严格度{{Entity.FSSStrictLevelE}} CutQmsQualityPlanTaskDTO.standardValue标准值{{Entity.TargetVal}} CutQmsQualityPlanTaskDTO.upOffset上偏差{{Entity.UpOffset}} CutQmsQualityPlanTaskDTO.downOffset下偏差{{Entity.DownOffset}} CutQmsQualityPlanTaskDTO.unitName单位{{Entity.UnitId_Name}}

数据对接效果

通过轻易云集成平台系列产品线可以协助企业轻易快捷的构建基于微服务架构的新一代企业服务总线，传统基于SOA架构的ESB产品主要解决的数据集成和协议转换等基础功能，已完全不能满足基于微服务架构、混合云集成架构、跨组织、跨单位的总线解决方案。而轻易云集成平台的每个产品线都是新一代的按照最新的互联网架构模式进行研发的产品线，能快速协助企业从传统的SOA架构转向微服务架构的服务总线解决方案。

金蝶云星空对接打通四化智造MES（API）逐个单据查询接口与新增客户信息接口