轻易云
注册体验

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

1 条评论

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

数据集成平台

源系统:易快报

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

接通系统：金蝶云星空

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

数据对接方案

轻易云集成平台的对接是通过一个个对应的对接方案去形成两个系统对接的连线，所以对接方案的配置极其重要，方案可以选择一键复制，轻易云有海量的对接方案可支持一键复制，复制后直接启动使用（对接方案借鉴可以在轻易云系统数据集成交流社区bbs.qeasy.cloud 中找到相关信息。或者可以通过手工配置，配置只要确认源平台：易快报的取数逻辑，例如什么时间取什么样的数据。即可完成配置，目标平台：金蝶云星空，把获取的数据组装成目标系统需要的格式进行写入。系统数据集成平台更加专注于数据集成与流程自动化的应用连接器，通过自研引擎，与各个平台或者服务完成对接，从而打通数据孤岛，实现数据的跨系统自由流转，让数据真正成为企业的核心生产力。
数据集成配置
金蝶云星空对接
ERP与电商数据对接

易快报接口明细

  • 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单据状态PAYING

响应参数

接口字段名称预设值 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

请求参数

接口字段名称预设值 FBillTypeID单据类型gyfyjsdyf FBillNo单据编号function case when '{{details_userProps_u归属组织code}}'='' then '{{code}}{{userProps_u归属组织code}}' else '{{code}}{{details_userProps_u归属组织code}}' end FDATE业务日期_function FROM_UNIXTIME( ( {{payTime}} / 1000 ) ,'%Y-%m-%d %H:%i:%S' ) FCONTACTUNITTYPE往来单位类型BD_Department FCONTACTUNIT往来单位findCollection find code from 19c94f4e-612d-3b26-8952-edf9168371d5 where name={{department_name}} FCURRENCYID币别PRE001 FSETTLEORGID结算组织_function case when '{{details_userProps_u归属组织code}}' in ('') then '{{userProps_u归属组织code}}' else '{{details_userProps_u归属组织code}}' end FPAYORGID付款组织{{userProps_u品牌code}} FRemarks备注function left('{{title}}',400) FMAINBOOKSTDCURRID本位币PRE001 FEXCHANGETYPE汇率类型HLTX01_SYS FExchangeRate汇率1.0 FNOTAXAMOUNT不含税金额本位币 FTAXAMOUNT税额本位币 FACCNTTIMEJUDGETIME到期日计算日期_function FROM_UNIXTIME( ( {{payTime}} / 1000 ) ,'%Y-%m-%d %H:%i:%S' ) FCancelStatus作废状态A FBUSINESSTYPE业务类型T F_wk_bxje1报销金额{{sumAmount}} F_wk_hxje核销金额{{writeOffAmount}} F_wk_YG员工function case when '{{userProps_u原借款人code}}'='' then '{{userProps_u实际报销人code}}' else '{{userProps_u原借款人code}}' end FEntity单据明细details FEntity.FCOSTID费用项目编码_findCollection find code from 0e3410bc-d1ad-3810-bd5f-639ce883690a where id={{details.feeTypeId}} FEntity.FCOSTDEPARTMENTID费用承担部门findCollection find code from 19c94f4e-612d-3b26-8952-edf9168371d5 where id={{details.userProps_expenseDepartment}} FEntity.FINVOICETYPE发票类型 FEntity.FEntryTaxRate税率(%)A FEntity.FNOTAXAMOUNTFOR不含税金额{{details.amount}} FEntity.FTAXAMOUNTFOR税额 FEntity.FCOMMENT备注_function left('{{details.remark}}',400) FEntity.FSourceBillNo源单编号 FEntity.F_wk_KH客户{{details_userProps_u客户code}} FEntity.FormId业务对象表单IdAP_OtherPayable FEntity.Operation执行的操作BatchSave FEntity.IsAutoSubmitAndAudit提交并审核false FEntity.IsVerifyBaseDataField验证基础资料false

数据对接效果

全面支持数据集成操作可视化、拖拽流式开发，无代码完成多套异构系统集成，降低使用门槛，提升交付速度。特别是在面向易快报、金蝶云星空间API接口集成时，通过对API的设计、创建、测试、部署、集成、管理、运维、下线等全生命周期管理，帮助企业洞察运营状况，进一步优化流程，提高企业商业价值。基于Web图形界面，通过拖拽、连接、配置完成流程设计，数据整合和集成，高效打通业务系统，通过面向运营的统计报表，直观查看API各项指标，实现对全局和项目层级双维度的监控管理。再通过轻易云数据集成中台通过统一门户注册管理，将业务以API的方式对外开放，实现业务创新、能力输出。
数据集成方案
用友接口

论坛热帖