金蝶云星空与四化智造MES（API）对接集成逐个单据查询连通新增客户信息(生产订单-模切-TESTS)

数据源系统:金蝶云星空

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

接通系统：四化智造MES（API）

“MES助力智能制造过程控制:MES管理生产订单的整个生产流程,通过对生产过程的所有突发事件实时监控,自动纠正生产过程中的错误或提供决策支持,以实现生产调度要求;在出现异常或与生产计划偏离太大时,及时反馈相关人员使其采取相应的措施。任务派工:MES在生产计划完成后,自动生成任务派工单,根据生产设备实际加工能力的变化,制定并优化生产的具体过程及各设备的详细操作顺序

接口方案配置

轻易云集成平台的对接是通过一个个对应的对接方案去形成两个系统对接的连线，所以对接方案的配置极其重要，方案可以选择一键复制，轻易云有海量的对接方案可支持一键复制，复制后直接启动使用（对接方案借鉴可以在轻易云系统数据集成交流社区bbs.qeasy.cloud 中找到相关信息。或者可以通过手工配置，配置只要确认源平台：金蝶云星空的取数逻辑，例如什么时间取什么样的数据。即可完成配置，目标平台：四化智造MES（API），把获取的数据组装成目标系统需要的格式进行写入。

金蝶云星空接口明细

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

请求参数

字段名称类型描述 Limit最大行数string金蝶的查询分页参数 StartRow开始行索引string金蝶的查询分页参数 TopRowCount返回总行数int金蝶的查询分页参数 FilterString过滤条件string示例写法 FSupplierId.FNumber = 'VEN00010' and FApproveDate>= FieldKeys需查询的字段key集合array金蝶分录主键ID格式：FPOOrderEntry_FEntryId,其它格式 FPurchaseOrgId.FNumber FormId业务对象表单Idstring必须填写金蝶的表单ID如😛UR_PurchaseOrder

响应参数

字段名称类型描述 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}}

系统数据对接

随着企业数字化业务的深入发展，对于企业的 IT 或者 CIO 来讲，正在面临一个愈发重要的问题——系统的结构太复杂了，尤其是头部企业，至少有十多套系统，这些系统之间的蛛网状的接口如果经常出问题。企业内部以及企业内部与外部建立起越来越多的业务应用系统，如何整合企业的现有IT资源，使企业中计算机孤岛式的应用向集体协作的方向发展，发挥资源效益的最大化，降低企业成本，正在逐渐成为企业关注的重要问题。用户希望企业内所有系统集成在一个平台上，操作统一，以节省培训时间。使用在轻易云应用集成平台 + MDM基础数据平台的解决方案中，轻易云应用集成平台负责实现异构、分布式系统之间互联互通，实现服务API治理以及数据传输交换。通过轻易云预置的各种适配器组件，连接现有各孤立应用系统，以图形化、拖拽方式构建集成流程和服务，提高应用系统集成工作效率，降低异构系统集成风险。针对未来可能出现的业务需求变更，在应用集成平台上进行动态调整，实现各应用系统之间的集成策略平滑升级。

金蝶云星空与四化智造MES（API）对接集成逐个单据查询连通新增客户信息(生产订单-模切-TESTS)