从金蝶云星空到泛微OA-E9通过接口配置打通数据

数据源平台:金蝶云星空

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

接通系统：泛微OA-E9

上海泛微网络科技股份有限公司成立于2001年，总部设立于上海，专注于协同管理软件领域，帮助组织构建统一的数字化办公平台。泛微是“国家规划布局内重点软件企业”，OA行业上交所主板上市公司（股票代码：603039）。获得腾讯战略投资、是企业微信战略合作伙伴。

数据集成方案配置

系统对接前期需要通过调研公司的业务，规划出最便捷，效率最高的整体流程。通过流程我们需要建立对应的方案来吧这些流程一一的落地，轻易云集成平台开箱即用的、可视化拖、拉、拽实现接口服务编排与聚合。只需要根据指引设定好对应的参数即可启动使用。设定好源平台：金蝶云星空的接口参数设置，以及设定好目标平台：泛微OA-E9的映射，即可启动方案进行测试

金蝶云星空接口明细

接口：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 BillTypeID单据类型string ApplicationOrgId_Id申请组织Idstring ApplicationOrgId_Name申请组织_名称string ApplicationOrgId_Number申请组织编码string ApplicationDeptId_Id申请部门_Idstring ApplicationDeptId_Name申请部门名称string ApplicationDeptId_Number申请部门_编码string ApplicantId_Id申请人Idstring ApplicantId_Name申请人_名称string ApplicantId_Number申请人编码string CurrencyId_Id币别_Idstring CurrencyId_Name币别名称string CurrencyId_Number币别_编码string TotalAmount含税金额合计string CancellerId_Id作废人Idstring CancellerId_Name作废人_名称string CancellerId_Number作废人编码string CloseStatus关闭状态string CloserId_Id关闭人_Idstring CloserId_Name关闭人名称string CloserId_Number关闭人_编码string CreatorId_Id创建人Idstring CreatorId_Name创建人_名称string CreatorId_Number创建人编码string CloseDate关闭日期string CancelDate作废日期string ApproverId_Id审核人_Idstring ApproverId_Name审核人名称string ApproverId_Number审核人_编码string ModifierId_Id最后修改人Idstring ModifierId_Name最后修改人_名称string ModifierId_Number最后修改人编码string CreateDate创建日期string CancelStatus作废状态string ModifyDate最后修改日期string ApproveDate审核日期string ExchangeTypeId_Id汇率类型_Idstring ExchangeTypeId_Name汇率类型名称string ExchangeTypeId_Number汇率类型_编码string Note备注string IsConvert是否是单据转换string RequestType申请类型string ApplicationDate申请日期string IsMergeCancel合并作废string SrcType来源类型string PublishStatus供应商协同发布状态(6.1废弃)string FISPRICEEXCLUDETAX价外税string FACCTYPE验收方式string MANUALCLOSE手工关闭string ReqEntry明细信息array ReqEntry.ReqQty申请数量string ReqEntry.ApproveQty批准数量string ReqEntry.SuggestSupplierId_Id建议供应商Idstring ReqEntry.SuggestSupplierId_Name建议供应商_名称string ReqEntry.SuggestSupplierId_Number建议供应商编码string ReqEntry.LeadTime提前期string ReqEntry.ReqAmount含税金额string ReqEntry.PurchaseOrgId_Id采购组织_Idstring ReqEntry.PurchaseOrgId_Name采购组织名称string ReqEntry.PurchaseOrgId_Number采购组织_编码string ReqEntry.PurchaseGroupId_Id采购组Idstring ReqEntry.PurchaseGroupId_Name采购组_名称string ReqEntry.PurchaseGroupId_Number采购组编码string ReqEntry.ReceiveOrgId_Id收料组织_Idstring ReqEntry.ReceiveOrgId_Name收料组织名称string ReqEntry.ReceiveOrgId_Number收料组织_编码string ReqEntry.StockId_Id仓库Idstring ReqEntry.StockId_Name仓库_名称string ReqEntry.StockId_Number仓库编码string ReqEntry.OrderQty订单数量string ReqEntry.RemainQty剩余数量string ReqEntry.ContractNo合同号string ReqEntry.REQTRACENO需求跟踪号string ReqEntry.MRPTerminateStatus业务终止string ReqEntry.TerminaterId_Id终止人_Idstring ReqEntry.TerminaterId_Name终止人名称string ReqEntry.TerminaterId_Number终止人_编码string ReqEntry.TerminateDate终止日期string ReqEntry.MRPCloseStatus业务关闭string ReqEntry.PlanConfirm计划确认string ReqEntry.SupplierId_Id指定供应商(6.0作废)Idstring ReqEntry.SupplierId_Name指定供应商(6.0作废)_名称string ReqEntry.SupplierId_Number指定供应商(6.0作废)编码string ReqEntry.MaterialId_Id物料编码_Idstring ReqEntry.MaterialId_Name物料编码名称string ReqEntry.MaterialId_Number物料编码_编码string ReqEntry.PriceUnitQty计价数量string ReqEntry.PurchaseDeptId_Id采购部门Idstring ReqEntry.PurchaseDeptId_Name采购部门_名称string ReqEntry.PurchaseDeptId_Number采购部门编码string ReqEntry.ReceiveAddress交货地址string ReqEntry.EntryNote备注string ReqEntry.OrderJNBaseQty订单关联数量（基本单位）string ReqEntry.OrderBaseQty订单数量（基本单位）string ReqEntry.BaseUnitId_Id基本单位_Idstring ReqEntry.BaseUnitId_Name基本单位名称string ReqEntry.BaseUnitId_Number基本单位_编码string ReqEntry.PriceUnitId_Id计价单位Idstring ReqEntry.PriceUnitId_Name计价单位_名称string ReqEntry.PriceUnitId_Number计价单位编码string ReqEntry.UnitID_Id申请单位_Idstring ReqEntry.UnitID_Name申请单位名称string ReqEntry.UnitID_Number申请单位_编码string ReqEntry.OrderJoinQty订单关联数量string ReqEntry.FBaseUnitQty批准数量(基本单位)string ReqEntry.BOMNoId_IdBOM版本Idstring ReqEntry.BOMNoId_NameBOM版本_名称string ReqEntry.BOMNoId_NumberBOM版本编码string ReqEntry.SrcBillTypeId源单类型string ReqEntry.SrcBillNo源单编号string ReqEntry.MaterialDesc物料说明string ReqEntry.SuggestPurDate建议采购日期string ReqEntry.ArrivalDate到货日期string ReqEntry.BaseStockQty入库数量(基本单位)string ReqEntry.BaseReceiveQty收料数量(基本单位)string ReqEntry.StockQty入库数量string ReqEntry.ReceiveQty收料数量string ReqEntry.FBFLowId业务流程string ReqEntry.ProviderId_Id供货地点_Idstring ReqEntry.ProviderId_Name供货地点名称string ReqEntry.ProviderId_Number供货地点_编码string ReqEntry.IsSplitCancel拆分作废string ReqEntry.MtoNo计划跟踪号string ReqEntry.RequireOrgId_Id需求组织Idstring ReqEntry.RequireOrgId_Name需求组织_名称string ReqEntry.RequireOrgId_Number需求组织编码string ReqEntry.PurchaserId_Id采购员_Idstring ReqEntry.PurchaserId_Name采购员名称string ReqEntry.PurchaserId_Number采购员_编码string ReqEntry.BaseReqQty申请数量(基本单位)string ReqEntry.ReceiveDeptId_Id收料部门Idstring ReqEntry.ReceiveDeptId_Name收料部门_名称string ReqEntry.ReceiveDeptId_Number收料部门编码string ReqEntry.RequireDeptId_Id需求部门_Idstring ReqEntry.RequireDeptId_Name需求部门名称string ReqEntry.RequireDeptId_Number需求部门_编码string ReqEntry.ChargeProjectID_Id费用项目Idstring ReqEntry.ChargeProjectID_Name费用项目_名称string ReqEntry.ChargeProjectID_Number费用项目编码string ReqEntry.EvaluatePrice单价string ReqEntry.QueryPriceId1688询价单IDstring ReqEntry.RowPublishStatus供应商协同行发布状态(6.1废弃)string ReqEntry.SalUnitID_Id销售单位_Idstring ReqEntry.SalUnitID_Name销售单位名称string ReqEntry.SalUnitID_Number销售单位_编码string ReqEntry.SalQty销售数量string ReqEntry.SalBaseQty销售基本数量string ReqEntry.TAXPRICE含税单价string ReqEntry.HASPUBLISH1688发布状态string ReqEntry.REQSTOCKUNITID_Id库存单位Idstring ReqEntry.REQSTOCKUNITID_Name库存单位_名称string ReqEntry.REQSTOCKUNITID_Number库存单位编码string ReqEntry.REQSTOCKQTY库存单位数量string ReqEntry.REQSTOCKBASEQTY库存基本数量string ReqEntry.ORDERSTOCKJNBASEQTY订单库存关联数量(基本单位)string ReqEntry.PRICEBASEQTY计价基本数量string ReqEntry.SRCBIZUNITID_Id携带的主业务单位_Idstring ReqEntry.SRCBIZUNITID_Name携带的主业务单位名称string ReqEntry.SRCBIZUNITID_Number携带的主业务单位_编码string ReqEntry.PURBASENUM采购基本分子string ReqEntry.STOCKBASEDEN库存基本分母string ReqEntry.IsVmiBusinessVMI业务string ReqEntry.TAXRATE税率%string ReqEntry.Amount金额string ReqEntry.PriceListEntry_Id价目表Idstring ReqEntry.PriceListEntry_Name价目表_名称string ReqEntry.PriceListEntry_Number价目表编码string ReqEntry.InquiryJoinQty关联询价数量string ReqEntry.InquiryJoinBaseQty关联询价数量（基本单位）string ReqEntry.DownPrice价格下限string ReqEntry.UpPrice价格上限string ReqEntry.DEMANDTYPE需求来源string ReqEntry.DEMANDBILLNO需求单据编号string ReqEntry.DEMANDBILLENTRYSEQ需求单据行号string ReqEntry.DEMANDBILLENTRYID需求单据分录内码string ReqEntry.RowType产品类型string ReqEntry.ParentMaterialId_Id父项产品_Idstring ReqEntry.ParentMaterialId_Name父项产品名称string ReqEntry.ParentMaterialId_Number父项产品_编码string ReqEntry.ParentBomId_Id父项BOM版本Idstring ReqEntry.ParentBomId_Name父项BOM版本_名称string ReqEntry.ParentBomId_Number父项BOM版本_编码string ReqEntry.ParentRowId父产品行主键string ReqEntry.SrcReqSplitEntryId申请单拆单前分录内码string ReqEntry.SrcReqMergeEntryIds申请单合并前分录内码string ReqEntry.PRILSTENTRYID价目表分录idstring ReqEntry.AssortBillNo配套单据编号string ReqEntry.ASSORTBILLSEQ配套单据行号string ReqEntry.PUR_RequisitionMob移动单据object ReqEntry.PUR_RequisitionMob.ExtendField扩展字段string ReqEntry.PUR_RequisitionMob.OrderName订单名称string ReqEntry.PUR_RequisitionMob.IsMobBill移动单据string ReqEntry.PUR_RequisitionMob.MobIsPending是否挂单string

泛微OA-E9接口明细

调用接口：doCreateWorkflowRequest
接口名称：发起审批流
方法：POST

请求参数

字段字段名称类型配置值 workflowBaseInfo流程信息object workflowBaseInfo.workflowId工作流IDstring22 workflowBaseInfo.requestName请求名称string由{{ApplicantId_Name}}发起的采购申请单：{{BillNo}} workflowBaseInfo.requestLevel请求重要级别string1 workflowBaseInfo.creatorId创建者IDstring4 workflowBaseInfo.workflowMainTableInfo表头信息object workflowBaseInfo.workflowMainTableInfo.no金蝶编码string{{BillNo}} workflowBaseInfo.workflowMainTableInfo.purchasing_org采购组织string{{ApplicationOrgId_Name}} workflowBaseInfo.workflowMainTableInfo.custom_field3表头字段3string workflowBaseInfo.workflowMainTableInfo.custom_field4表头字段4string workflowBaseInfo.workflowMainTableInfo.custom_field5表头字段5string workflowBaseInfo.workflowMainTableInfo.custom_field6表头字段6string workflowBaseInfo.workflowMainTableInfo.custom_field7表头字段7string workflowBaseInfo.workflowMainTableInfo.custom_field8表头字段8string workflowBaseInfo.workflowMainTableInfo.details1明细表1array workflowBaseInfo.workflowMainTableInfo.details1.detail_field1明细字段1string workflowBaseInfo.workflowMainTableInfo.details1.detail_field2明细字段2string workflowBaseInfo.workflowMainTableInfo.details1.detail_field3明细字段3string workflowBaseInfo.workflowMainTableInfo.details1.detail_field4明细字段4string workflowBaseInfo.workflowMainTableInfo.details1.detail_field5明细字段5string workflowBaseInfo.workflowMainTableInfo.details1.detail_field6明细字段6string workflowBaseInfo.workflowMainTableInfo.details1.detail_field7明细字段7string workflowBaseInfo.workflowMainTableInfo.details1.detail_field8明细字段8string

系统数据对接

数据集成中台设计中心Web界面以“拖拽”式交互设计，使用鼠标即可构建设计多异构系统数据集成流程，低代码平台大大降低流程设计者上手门槛。还有丰富的组件库快速满足复杂业务需求，结合不同模块即可生成不同业务流程，提升流程设计效率。平台支持多种高度灵活部署，高并发、高性能、高可用，可以通过多节点组成集群实现性能的横向扩展。适度集群配置其数据集成处理能力可达GB级/秒，为业务流提供更高数据吞吐量。平台已集成数据回压、优先级队列等能力，保障运行稳定性。完善的企业API运营管理机制帮助您构建“API生产者、API管理者、API消费者”三者结合的统一API数字化生态。支持市面上主流厂家软件如：金蝶、用友、SAP、泛微、蓝凌、旺店通、聚水潭、马帮、小满CRM等等。

从金蝶云星空到泛微OA-E9通过接口配置打通数据