金蝶云星空与易快报对接集成获取指定状态单据列表(包含已删除单据)连通付款单新增(客户终止合同退款申请同步ok)

接入系统：易快报

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

对接目标平台:金蝶云星空

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

数据集成方案配置

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

易快报接口明细

API：/api/openapi/v1/docSequences
NAME：获取指定状态单据列表(包含已删除单据)
METHOD：POST

请求参数

接口字段名称预设值 fields需要过滤掉的字段 fields.docData单据数据 fields.docData.logs审批日志 fields.docData.flowPlan审批流信息 fields.type单据类型expense fields.index分页查询的起始索引序号_function ({{LAST_SYNC_TIME}}000)*1 fields.count查询数据条数10 fields.state单据状态PAID

响应参数

接口字段名称预设值 typetype idid corporationIdcorporationId ownerIdownerId dataTypedataType remarkremark titletitle updateTimeupdateTime specificationIdspecificationId ownerowner owner.idid owner.namename owner.departmentsdepartments owner.codecode owner.departmentdepartment owner.department.idid owner.department.namename owner.department.codecode owner.department.codecode owner.department.userPropsuserProps owner.department.userProps.payeeIdpayeeId owner.department.userProps.descriptiondescription owner.department.userProps.submitterIdsubmitterId owner.department.userProps.companyRealPaycompanyRealPay owner.department.userProps.specificationIdspecificationId owner.department.userProps.expenseDepartmentexpenseDepartment owner.department.userProps.companyRealPay_ratecompanyRealPay_rate owner.department.userProps.companyRealPay_budgetcompanyRealPay_budget owner.department.userProps.companyRealPay_foreigncompanyRealPay_foreign owner.department.userProps.companyRealPay_budgetRatecompanyRealPay_budgetRate owner.department.userProps.companyRealPay_budgetUnitcompanyRealPay_budgetUnit owner.department.userProps.companyRealPay_budgetScalecompanyRealPay_budgetScale owner.department.userProps.companyRealPay_foreignUnitcompanyRealPay_foreignUnit owner.department.userProps.companyRealPay_budgetSymbolcompanyRealPay_budgetSymbol owner.department.userProps.companyRealPay_standardUnitcompanyRealPay_standardUnit owner.department.userProps.companyRealPay_budgetNumCodecompanyRealPay_budgetNumCode owner.department.userProps.companyRealPay_budgetStrCodecompanyRealPay_budgetStrCode owner.department.userProps.companyRealPay_foreignSymbolcompanyRealPay_foreignSymbol owner.department.userProps.companyRealPay_foreignNumCodecompanyRealPay_foreignNumCode owner.department.userProps.companyRealPay_foreignStrCodecompanyRealPay_foreignStrCode owner.department.userProps.companyRealPay_standardSymbolcompanyRealPay_standardSymbol owner.department.userProps.companyRealPay_standardNumCodecompanyRealPay_standardNumCode owner.department.userProps.companyRealPay_standardStrCodecompanyRealPay_standardStrCode owner.department.userProps.statestate owner.department.userProps.projectproject owner.department.userProps.logslogs owner.department.userProps.flowPlanflowPlan owner.department.userProps.sumAmountsumAmount owner.department.userProps.writeOffAmountwriteOffAmount owner.department.userProps.expenseDateexpenseDate owner.department.userProps.detailsdetails owner.department.userProps.details.amountamount owner.department.userProps.details.amount_standardStrCodeamount_standardStrCode owner.department.userProps.details.amount_standardNumCodeamount_standardNumCode owner.department.userProps.details.amount_standardSymbolamount_standardSymbol owner.department.userProps.details.amount_standardUnitamount_standardUnit owner.department.userProps.details.amount_rateamount_rate owner.department.userProps.details.amount_foreignStrCodeamount_foreignStrCode owner.department.userProps.details.amount_foreignNumCodeamount_foreignNumCode owner.department.userProps.details.amount_foreignamount_foreign owner.department.userProps.details.amount_foreignSymbolamount_foreignSymbol owner.department.userProps.details.amount_foreignUnitamount_foreignUnit owner.department.userProps.details.datedate owner.department.userProps.details.remarkremark owner.department.userProps.details.feeTypeIdfeeTypeId owner.department.userProps.details.userPropsuserProps owner.department.userProps.details.invoiceCountinvoiceCount owner.department.userProps.details.taxAmounttaxAmount owner.department.userProps.details.noTaxAmountnoTaxAmount owner.department.userProps.details.invoicesinvoices owner.department.userProps.details.invoiceFormTypeinvoiceFormType owner.department.userProps.details.payeeInfopayeeInfo owner.department.userProps.details.writtenOffRecordswrittenOffRecords owner.department.userProps.details.submitTimesubmitTime owner.department.userProps.details.payeeInfopayeeInfo owner.department.userProps.details.payeeInfo.sortsort owner.department.userProps.details.payeeInfo.namename owner.department.userProps.details.payeeInfo.cardNocardNo owner.department.userProps.details.payeeInfo.bankbank owner.department.userProps.details.payeeInfo.branchbranch owner.department.userProps.details.payeeInfo.typetype owner.department.userProps.details.payeeInfo.provinceprovince owner.department.userProps.details.payeeInfo.citycity owner.department.userProps.details.payeeInfo.certificateTypecertificateType owner.department.userProps.details.payeeInfo.certificateNocertificateNo owner.department.userProps.details.payeeInfo.bankLinkNobankLinkNo owner.department.userProps.details.payeeInfo.bankNamebankName owner.department.userProps.details.payeeInfo.swiftCodeswiftCode owner.department.userProps.details.payeeInfo.bankCodebankCode owner.department.userProps.details.payeeInfo.branchCodebranchCode owner.department.userProps.details.payeeInfo.remarkremark owner.department.userProps.details.payeeInfo.idid owner.department.userProps.details.payeeInfo.payorIdpayorId owner.department.userProps.details.payeeInfo.paymentChannelpaymentChannel owner.department.userProps.details.payeeInfo.paymentAccountIdpaymentAccountId owner.department.userProps.details.payeeInfo.payTimepayTime owner.department.userProps.details.payeeInfo.multiplePayeesModemultiplePayeesMode owner.department.userProps.details.payeeInfo.channelTradeNochannelTradeNo owner.department.userProps.details.payeeInfo.payPlanpayPlan owner.department.userProps.details.payeeInfo.receiptStatereceiptState owner.department.userProps.details.payeeInfo.paymentAccountpaymentAccount

金蝶云星空接口明细

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

请求参数

接口字段名称预设值 FBillNo单据编号function case when '{{details_userProps_u归属组织code}}'='' then '{{code}}{{userProps_u归属组织code}}' else '{{code}}{{details_userProps_u归属组织code}}' end FPAYORGID付款组织_function case when '{{FPAYORGID}}'>0 then '{{FPAYORGID}}' when '{{details_userProps_u归属组织code}}' in ('') then '{{userProps_u归属组织code}}' else '{{details_userProps_u归属组织code}}' end FSETTLEORGID结算组织function case when '{{details_userProps_u归属组织code}}'>0 then '{{details_userProps_u归属组织code}}' else '{{userProps_u归属组织code}}' end FCURRENCYID币别PRE001 FDATE业务日期_function FROM_UNIXTIME( ( {{payTime}} / 1000 ) ,'%Y-%m-%d %H:%i:%S' ) FBillTypeID单据类型KHHTZZ FCONTACTUNITTYPE往来单位类型BD_Department FCONTACTUNIT往来单位function case when '{{department_code}}' in ('') then 'BM000001' else '{{department_code}}' end FRECTUNITTYPE收款单位类型BD_Department FRECTUNIT收款单位_function case when '{{department_code}}' in ('') then 'BM000001' else '{{department_code}}' end FDepartment部门{{department_code}} FPAYAMOUNTFOR付款金额function sum({{sumAmount}}-{{writeOffAmount}}) FEXCHANGETYPE汇率类型HLTX01_SYS FSETTLECUR结算币别PRE001 FREMARK备注_function left('{{title}}',400) F_wk_bxje1报销金额{{sumAmount}} F_wk_hxje核销金额{{writeOffAmount}} F_wk_YG员工function case when '{{userProps_u原借款人name}}'='' then '{{userProps_u实际报销人name}}' else '{{userProps_u原借款人name}}' end FPAYBILLENTRY付款单明细details FPAYBILLENTRY.FSETTLETYPEID结算方式_function case when '{{paymentAccount_accountNo}}' in ('') then '10' when '{{writeOffAmount}}'>0 then '10' else 'JSFS04_SYS' end FPAYBILLENTRY.FPAYTOTALAMOUNTFOR付款金额{{details_amount}} FPAYBILLENTRY.FPURPOSEID收付款用途SFKYT10_SYS FPAYBILLENTRY.FACCOUNTID我方银行账号{{paymentAccount_accountNo}} FPAYBILLENTRY.FCOMMENT备注function left('{{details_remark}}',400) 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_PBLH_YKBHEXJE易快报核销金额{{details_amount}} FPAYBILLENTRY.FormId业务对象表单IdAP_PAYBILL FPAYBILLENTRY.Operation执行的操作BatchSave FPAYBILLENTRY.IsAutoSubmitAndAudit提交并审核false FPAYBILLENTRY.IsVerifyBaseDataField验证基础资料false

系统对接总览

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

金蝶云星空与易快报对接集成获取指定状态单据列表(包含已删除单据)连通付款单新增(客户终止合同退款申请同步ok)