易快报对接打通金蝶云星空获取指定状态单据列表(包含已删除单据)接口与付款单新增接口

源系统:易快报

易快报是敏捷的企业报销费控与聚合消费平台，为企业提供移动报销、聚合消费、全程费控、预算管理、发票管理等一站式解决方案。同时，易快报可集成多家银行及第三方支付平台，打通对公对私付款，对接财务软件自动生成凭证，实现申请-订购-报销-验票-支付-记账全流程，并可与企业现有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分页查询的起始索引序号string1651334400000 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

金蝶云星空接口明细

API：batchSave
NAME：付款单新增
METHOD：POST

请求参数

接口字段名称预设值 FBillNo单据编号{{code}} FCURRENCYID币别PRE001 FDATE业务日期function FROM_UNIXTIME( ( {{payTime}} / 1000 ) ,'%Y-%m-%d %H:%i:%S' ) FBillTypeID单据类型rcfybxd FCONTACTUNITTYPE往来单位类型BD_Department FCONTACTUNIT往来单位_findCollection find code from 19c94f4e-612d-3b26-8952-edf9168371d5 where name={{department.name}} FRECTUNITTYPE收款单位类型BD_Department FRECTUNIT收款单位findCollection find code from 19c94f4e-612d-3b26-8952-edf9168371d5 where name={{department.name}} FSETTLEORGID结算组织_function case when '{{userProps.u归属组织.code}}' in ('') then 'findCollection find FUseOrgId_Fnumber from ecb60aad-ba50-38a9-85bf-8604d4180790 where FNumber={{paymentAccount.accountNo}} endFind' else '{{userProps.u归属组织.code}}' end FDepartment部门findCollection find code from 19c94f4e-612d-3b26-8952-edf9168371d5 where name={{department.name}} FPAYORGID付款组织{{userProps.u_归属组织.code}} FPAYAMOUNTFOR付款金额function sum({{sumAmount}}-{{writeOffAmount}}) FEXCHANGETYPE汇率类型HLTX01_SYS FSETTLECUR结算币别PRE001 FREMARK备注{{remark}}{{owner.name}}报{{title}} FPAYBILLENTRY付款单明细details FPAYBILLENTRY.FSETTLETYPEID结算方式_function case when '{{paymentAccountId}}' in ('') then 'JSFS01_SYS' else 'JSFS04_SYS' end FPAYBILLENTRY.FPAYTOTALAMOUNTFOR付款金额{{details.amount}} FPAYBILLENTRY.FPURPOSEID收付款用途SFKYT10_SYS FPAYBILLENTRY.FACCOUNTID我方银行账号{{paymentAccount.accountNo}} FPAYBILLENTRY.FCOMMENT备注{{details.remark}} FPAYBILLENTRY.FCOSTID费用项目findCollection find code from 0e3410bc-d1ad-3810-bd5f-639ce883690a where id={{details.feeTypeId}} FPAYBILLENTRY.FEXPENSEDEPTID_E费用承担部门_findCollection find code from 19c94f4e-612d-3b26-8952-edf9168371d5 where id={{details.userProps.expenseDepartment}} FPAYBILLENTRY.F_wk_KH客户{{details.userProps.u客户.code}} FPAYBILLENTRY.F_wk_bxje1报销金额{{sumAmount}} FPAYBILLENTRY.F_wk_hxje核销金额{{writeOffAmount}} FPAYBILLENTRY.F_wk_YG员工_function case when '{{userProps.u原借款人.code}}'='null' then '{{userProps.u实际报销人.code}}' else '{{userProps.u_原借款人.code}}' en FPAYBILLENTRY.FormId业务对象表单IdAP_PAYBILL FPAYBILLENTRY.Operation执行的操作BatchSave FPAYBILLENTRY.IsAutoSubmitAndAudit提交并审核false FPAYBILLENTRY.IsVerifyBaseDataField验证基础资料false

系统打通概况

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

易快报对接打通金蝶云星空获取指定状态单据列表(包含已删除单据)接口与付款单新增接口