轻易云
注册体验

金蝶云星空对接外部易快报系统

1 条评论

金蝶云星空对接外部易快报系统

MES与ERP集成

来源系统:易快报

易快报是敏捷的企业报销费控与聚合消费平台，为企业提供移动报销、聚合消费、全程费控、预算管理、发票管理等一站式解决方案。同时，易快报可集成多家银行及第三方支付平台，打通对公对私付款，对接财务软件自动生成凭证，实现申请-订购-报销-验票-支付-记账全流程，并可与企业现有ERP、OA、CRM等业务系统无缝集成，打破信息孤岛，激活数据价值。

接通系统：金蝶云星空

金蝶K/3Cloud（金蝶云星空）是移动互联网时代的新型ERP，是基于WEB2.0与云技术的新时代企业管理服务平台。金蝶K/3Cloud围绕着“生态、人人、体验”，旨在帮助企业打造面向新时代的生态互联与协同平台，围绕生态中的每个角色，提供随手可得的云服务，最终实现敏捷协同，智慧运营的企业运营新境界。整个产品采用SOA架构，完全基于BOS平台组建而成，业务架构上贯穿流程驱动与角色驱动思想，结合中国管理模式与中国管理实践积累，精细化支持企业财务管理、供应链管理、生产管理、供应链协同管理、人力资源管理等核心应用。技术架构上该产品采用平台化构建，支持跨数据库应用，支持本地部署、私有云部署与公有云部署三种部署方式，同时还在公有云上开放中国第一款基于ERP的协同开发云平台。任何一家使用金蝶K/3Cloud产品的企业，其拥有的是包含金蝶在内的众多基于同一个平台提供服务的IT服务伙伴。

数据接口配置方案

通过轻易云系统数据集成平台新增创建集成方案，通过轻易云的方案市场可以一键复制，并且可以借鉴其他的方案配置完成方案制作，方案制作只需要两步，第一步先确定好对应的数据来源；源系统：易快报接口：获取指定状态单据列表(包含已删除单据)通过请求调度者配置对应的请求参数即可获取到对应的数据。目标系统：金蝶云星空接口：付款单新增，通过写入调度者匹配获取到的数据和写入的映射关系，即可自动生成符合目标系统：金蝶云星空写入的数据自动产生写入队列，通过运行概况，系统会自动帮你诊断方案的运行情况。实时监控到方案的运行情况系统数据集成平台更加专注于数据集成与流程自动化的应用连接器，通过自研引擎，与各个平台或者服务完成对接，从而打通数据孤岛，实现数据的跨系统自由流转，让数据真正成为企业的核心生产力。
多套系统之间数据打通

易快报接口明细

  • 调用接口：/api/openapi/v1/docSequences
  • 接口名称：获取指定状态单据列表(包含已删除单据)
  • 方法：POST

请求参数

字段字段名称类型配置值 fields需要过滤掉的字段object fields.docData单据数据object fields.docData.logs审批日志string fields.docData.flowPlan审批流信息string fields.type单据类型stringexpense fields.index分页查询的起始索引序号string_function ({{LAST_SYNC_TIME}}000)*1 fields.count查询数据条数string10 fields.state单据状态stringPAID

响应参数

字段字段名称类型配置值 typetypestring ididstring corporationIdcorporationIdstring ownerIdownerIdstring dataTypedataTypestring remarkremarkstring titletitlestring updateTimeupdateTimestring specificationIdspecificationIdstring ownerownerobject owner.ididstring owner.namenamestring owner.departmentsdepartmentsstring owner.codecodestring owner.departmentdepartmentobject owner.department.ididstring owner.department.namenamestring owner.department.codecodestring owner.department.codecodestring owner.department.userPropsuserPropsobject owner.department.userProps.payeeIdpayeeIdstring owner.department.userProps.descriptiondescriptionstring owner.department.userProps.submitterIdsubmitterIdstring owner.department.userProps.companyRealPaycompanyRealPaystring owner.department.userProps.specificationIdspecificationIdstring owner.department.userProps.expenseDepartmentexpenseDepartmentstring owner.department.userProps.companyRealPay_ratecompanyRealPay_ratestring owner.department.userProps.companyRealPay_budgetcompanyRealPay_budgetstring owner.department.userProps.companyRealPay_foreigncompanyRealPay_foreignstring owner.department.userProps.companyRealPay_budgetRatecompanyRealPay_budgetRatestring owner.department.userProps.companyRealPay_budgetUnitcompanyRealPay_budgetUnitstring owner.department.userProps.companyRealPay_budgetScalecompanyRealPay_budgetScalestring owner.department.userProps.companyRealPay_foreignUnitcompanyRealPay_foreignUnitstring owner.department.userProps.companyRealPay_budgetSymbolcompanyRealPay_budgetSymbolstring owner.department.userProps.companyRealPay_standardUnitcompanyRealPay_standardUnitstring owner.department.userProps.companyRealPay_budgetNumCodecompanyRealPay_budgetNumCodestring owner.department.userProps.companyRealPay_budgetStrCodecompanyRealPay_budgetStrCodestring owner.department.userProps.companyRealPay_foreignSymbolcompanyRealPay_foreignSymbolstring owner.department.userProps.companyRealPay_foreignNumCodecompanyRealPay_foreignNumCodestring owner.department.userProps.companyRealPay_foreignStrCodecompanyRealPay_foreignStrCodestring owner.department.userProps.companyRealPay_standardSymbolcompanyRealPay_standardSymbolstring owner.department.userProps.companyRealPay_standardNumCodecompanyRealPay_standardNumCodestring owner.department.userProps.companyRealPay_standardStrCodecompanyRealPay_standardStrCodestring owner.department.userProps.statestatestring owner.department.userProps.projectprojectstring owner.department.userProps.logslogsstring owner.department.userProps.flowPlanflowPlanstring owner.department.userProps.sumAmountsumAmountstring owner.department.userProps.writeOffAmountwriteOffAmountstring owner.department.userProps.expenseDateexpenseDatestring owner.department.userProps.detailsdetailsarray owner.department.userProps.details.amountamountstring owner.department.userProps.details.amount_standardStrCodeamount_standardStrCodestring owner.department.userProps.details.amount_standardNumCodeamount_standardNumCodestring owner.department.userProps.details.amount_standardSymbolamount_standardSymbolstring owner.department.userProps.details.amount_standardUnitamount_standardUnitstring owner.department.userProps.details.amount_rateamount_ratestring owner.department.userProps.details.amount_foreignStrCodeamount_foreignStrCodestring owner.department.userProps.details.amount_foreignNumCodeamount_foreignNumCodestring owner.department.userProps.details.amount_foreignamount_foreignstring owner.department.userProps.details.amount_foreignSymbolamount_foreignSymbolstring owner.department.userProps.details.amount_foreignUnitamount_foreignUnitstring owner.department.userProps.details.datedatestring owner.department.userProps.details.remarkremarkstring owner.department.userProps.details.feeTypeIdfeeTypeIdstring owner.department.userProps.details.userPropsuserPropsstring owner.department.userProps.details.invoiceCountinvoiceCountstring owner.department.userProps.details.taxAmounttaxAmountstring owner.department.userProps.details.noTaxAmountnoTaxAmountstring owner.department.userProps.details.invoicesinvoicesstring owner.department.userProps.details.invoiceFormTypeinvoiceFormTypestring owner.department.userProps.details.payeeInfopayeeInfostring owner.department.userProps.details.writtenOffRecordswrittenOffRecordsobject owner.department.userProps.details.submitTimesubmitTimestring owner.department.userProps.details.payeeInfopayeeInfoobject owner.department.userProps.details.payeeInfo.sortsortstring owner.department.userProps.details.payeeInfo.namenamestring owner.department.userProps.details.payeeInfo.cardNocardNostring owner.department.userProps.details.payeeInfo.bankbankstring owner.department.userProps.details.payeeInfo.branchbranchstring owner.department.userProps.details.payeeInfo.typetypestring owner.department.userProps.details.payeeInfo.provinceprovincestring owner.department.userProps.details.payeeInfo.citycitystring owner.department.userProps.details.payeeInfo.certificateTypecertificateTypestring owner.department.userProps.details.payeeInfo.certificateNocertificateNostring owner.department.userProps.details.payeeInfo.bankLinkNobankLinkNostring owner.department.userProps.details.payeeInfo.bankNamebankNamestring owner.department.userProps.details.payeeInfo.swiftCodeswiftCodestring owner.department.userProps.details.payeeInfo.bankCodebankCodestring owner.department.userProps.details.payeeInfo.branchCodebranchCodestring owner.department.userProps.details.payeeInfo.remarkremarkstring owner.department.userProps.details.payeeInfo.ididstring owner.department.userProps.details.payeeInfo.payorIdpayorIdstring owner.department.userProps.details.payeeInfo.paymentChannelpaymentChannelstring owner.department.userProps.details.payeeInfo.paymentAccountIdpaymentAccountIdstring owner.department.userProps.details.payeeInfo.payTimepayTimestring owner.department.userProps.details.payeeInfo.multiplePayeesModemultiplePayeesModestring owner.department.userProps.details.payeeInfo.channelTradeNochannelTradeNostring owner.department.userProps.details.payeeInfo.payPlanpayPlanstring owner.department.userProps.details.payeeInfo.receiptStatereceiptStatestring owner.department.userProps.details.payeeInfo.paymentAccountpaymentAccountstring

金蝶云星空接口明细

  • 调用接口：batchSave
  • 接口名称：付款单新增
  • 方法：POST

请求参数

字段字段名称类型配置值 FBillNo单据编号stringfunction case when '{{details_userProps_u归属组织code}}'='' then '{{code}}{{userProps_u归属组织code}}-1' else '{{code}}{{details_userProps_u归属组织code}}-1' end FPAYORGID付款组织string_function case when '{{FPAYORGID}}'>0 then '{{FPAYORGID}}' when '{{details_userProps_u归属组织code}}' in ('') then '{{userProps_u归属组织code}}' else '{{details_userProps_u归属组织code}}' end FSETTLEORGID结算组织stringfunction case when '{{details_userProps_u归属组织code}}'>0 then '{{details_userProps_u归属组织code}}' else '{{userProps_u归属组织code}}' end FCURRENCYID币别stringPRE001 FDATE业务日期string_function FROM_UNIXTIME( ( {{payTime}} / 1000 ) ,'%Y-%m-%d %H:%i:%S' ) FBillTypeID单据类型stringfunction case when '{{userProps_specificationId_name}}' in ('差旅报销单') then 'clbxd' when '{{userProps_specificationId_name}}' in ('日常费用报销单') then 'rcfybxd' when '{{userProps_specificationId_name}}' in ('款项支付单') then 'kxzfd' when '{{userProps_specificationId_name}}' in ('固定资产报销单') then 'gdzcbxd' when '{{userProps_specificationId_name}}' in ('工艺费用结算单') then 'gyfyjsd' else 'sdhkd1' end FCONTACTUNITTYPE往来单位类型stringBD_Department FCONTACTUNIT往来单位string_function case when '{{department_code}}' in ('') then 'BM000001' else '{{department_code}}' end FRECTUNITTYPE收款单位类型stringBD_Department FRECTUNIT收款单位stringfunction case when '{{department_code}}' in ('') then 'BM000001' else '{{department_code}}' end FDepartment部门string_findCollection find code from 19c94f4e-612d-3b26-8952-edf9168371d5 where name={{department_name}} FPAYAMOUNTFOR付款金额stringfunction sum({{sumAmount}}-{{writeOffAmount}}) FEXCHANGETYPE汇率类型stringHLTX01_SYS FSETTLECUR结算币别stringPRE001 FREMARK备注string_function left('{{remark}}',400) FPAYBILLENTRY付款单明细array FPAYBILLENTRY.FSETTLETYPEID结算方式stringfunction case when '{{paymentAccount_accountNo}}' in ('') then 'JSFS01_SYS' else 'JSFS04_SYS' end FPAYBILLENTRY.FPAYTOTALAMOUNTFOR付款金额string_function sum({{sumAmount}}-{{writeOffAmount}}) FPAYBILLENTRY.FPURPOSEID收付款用途stringSFKYT12_SYS FPAYBILLENTRY.FACCOUNTID我方银行账号string{{paymentAccount_accountNo}} FPAYBILLENTRY.FCOMMENT备注stringfunction left('{{details_remark}}',400) FPAYBILLENTRY.FCOSTID费用项目string_findCollection find code from 0e3410bc-d1ad-3810-bd5f-639ce883690a where id={{details_feeTypeId}} FPAYBILLENTRY.FEXPENSEDEPTID_E费用承担部门stringfindCollection find code from 19c94f4e-612d-3b26-8952-edf9168371d5 where id={{details_userProps_expenseDepartment}} FPAYBILLENTRY.F_wk_KH客户string{{details_userProps_u_客户code}} FPAYBILLENTRY.F_PBLH_YKBHEXJE易快报核销金额string FPAYBILLENTRY.F_wk_bxje1报销金额string{{sumAmount}} FPAYBILLENTRY.F_wk_hxje核销金额string{{writeOffAmount}} FPAYBILLENTRY.F_wk_YG员工string_function case when '{{userProps_u原借款人name}}'='' then '{{userProps_u实际报销人name}}' else '{{userProps_u原借款人name}}' end FPAYBILLENTRY.FormId业务对象表单IdstringAP_PAYBILL FPAYBILLENTRY.Operation执行的操作stringBatchSave FPAYBILLENTRY.IsAutoSubmitAndAudit提交并审核boolfalse FPAYBILLENTRY.IsVerifyBaseDataField验证基础资料boolfalse

系统打通概况

从API层面解决企业烟囱式业务系统集成现状,实现深度的业务流程拉通易快报到金蝶云星空之间数据集成；通过API连接各业务系统，复用已有的业务系统能力，让集成架构、服务关系更清晰。使用统一的API管理平台，对API进行显性化、可视化，使所有API服务成为企业的数字资产，提升复用率和价值。全面管控企业的API资产，梳理现有业务系统的API。实现API文档的统一管理，建立API的上线、下线、监控的统一管理体系及标准规范。已链接和打通主流SaaS系统超过100+，快速对接各种API接口，实现云上云下的互联互通。将SaaS和本地业务系统联接起来，打破时间与空间界限，打通原有核心数据及SaaS应用，构建可平滑演进的企业IT架构。
ERP打通OA
系统接口打通
用友接口

论坛热帖