Qeasy Cloud
Get Started

易快报、金蝶云星空通过接口配置数据对接

1 comments

易快报、金蝶云星空通过接口配置数据对接

钉钉与ERP集成

对接源平台:易快报

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

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

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

数据接口配置

通过数据集成平台新增创建集成方案,然后在数据源平台中选择对应的源平台为:易快报,并且选择对应的连接器(关于易快报的接口连接器如何配置可以在轻易云系统数据集成交流社区bbs.qeasy.cloud 中找到相关信息)。选择对应的获取指定状态单据列表(包含已删除单据)接口作为数据对接来源。然后再通过写入目标平台配置目标系统为金蝶云星空,并且选择对应连接器。选择对应的付款单新增接口作为数据写入动作,既可以完成第一步的数据对接配置;打破跨系统连接,让数据轻易互通成为现实。轻易云数据集成中台提供快速与各种业务系统进行连接的能力,可以将软件接口上线到平台轻松实现数百款应用软件的数据互通。也可以将轻易云的集成能力嵌入到您的软件系统中,将数百款软件的集成能力变成您产品的功能与卖点,扩展额外收入,提升客户成交率,成交金额与满意度。
系统接口打通

易快报接口明细

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

请求参数

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

响应参数

接口字段名称预设值 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单据编号 FCURRENCYID币别 FDATE业务日期 FBillTypeID单据类型 FCONTACTUNITTYPE往来单位类型 FCONTACTUNIT往来单位 FRECTUNITTYPE收款单位类型 FRECTUNIT收款单位 FBUSINESSTYPE业务类型 FDepartment部门 FPAYORGID付款组织 FSETTLERATE结算汇率 FPAYAMOUNTFOR付款金额 FEXCHANGETYPE汇率类型 FSETTLECUR结算币别 FEXCHANGERATE汇率 FREMARK备注 FBookingDate期望付款日期 FTHIRDBILLNO第三方单据编号 FIsBorrow是否其他预付 FPRESETASSISTANT1预设辅助资料字段1 FPRESETASSISTANT2预设辅助资料字段2 FPRESETTEXT1预设文本字段1 FPRESETTEXT2预设文本字段2 FPRESETBASE1预设基础资料字段1 FPRESETBASE2预设基础资料字段2 FPAYBILLENTRY付款单明细 FPAYBILLENTRY.FSETTLETYPEID结算方式 FPAYBILLENTRY.FOPPOSITECCOUNTNAME对方账户名称 FPAYBILLENTRY.FHANDLINGCHARGEFOR手续费 FPAYBILLENTRY.FCOSTID费用项目 FPAYBILLENTRY.FPAYAMOUNTFOR_E付款金额 FPAYBILLENTRY.FISPOST是否登账 FPAYBILLENTRY.FPOSTDATE登账日期 FPAYBILLENTRY.FMATERIALID物料编码 FPAYBILLENTRY.FEXPENSEDEPTID_E费用承担部门 FPAYBILLENTRY.FPayType支付类型 FPAYBILLENTRY.FPRICE含税单价 FPAYBILLENTRY.FQTY数量 FPAYBILLENTRY.FTaxAmt税额 FPAYBILLENTRY.FCOMMENT备注 FPAYBILLENTRY.FPAYBILLSRCENTRY_Link关联关系表 FPAYBILLENTRY.FPAYBILLSRCENTRY_Link_FRuleId转换规则 FPAYBILLENTRY.FPAYBILLSRCENTRY_Link_FSTableName源单表 FPAYBILLENTRY.FPAYBILLSRCENTRY_Link_FSBillId源单内码 FPAYBILLENTRY.FPAYBILLSRCENTRY_Link_FSId源单分录内码 FPAYBILLENTRY.FormId业务对象表单IdAP_PAYBILL FPAYBILLENTRY.Operation执行的操作BatchSave FPAYBILLENTRY.IsAutoSubmitAndAudit提交并审核true FPAYBILLENTRY.IsVerifyBaseDataField验证基础资料false

响应参数

接口字段名称预设值 FBillNo单据编号 FCURRENCYID币别 FDATE业务日期 FBillTypeID单据类型 FCONTACTUNITTYPE往来单位类型 FCONTACTUNIT往来单位 FRECTUNITTYPE收款单位类型 FRECTUNIT收款单位 FBUSINESSTYPE业务类型 FDepartment部门 FPAYORGID付款组织 FSETTLERATE结算汇率 FPAYAMOUNTFOR付款金额 FEXCHANGETYPE汇率类型 FSETTLECUR结算币别 FEXCHANGERATE汇率 FREMARK备注 FBookingDate期望付款日期 FTHIRDBILLNO第三方单据编号 FIsBorrow是否其他预付 FPRESETASSISTANT1预设辅助资料字段1 FPRESETASSISTANT2预设辅助资料字段2 FPRESETTEXT1预设文本字段1 FPRESETTEXT2预设文本字段2 FPRESETBASE1预设基础资料字段1 FPRESETBASE2预设基础资料字段2 FPAYBILLENTRY付款单明细 FPAYBILLENTRY.FSETTLETYPEID结算方式 FPAYBILLENTRY.FOPPOSITECCOUNTNAME对方账户名称 FPAYBILLENTRY.FHANDLINGCHARGEFOR手续费 FPAYBILLENTRY.FCOSTID费用项目 FPAYBILLENTRY.FPAYAMOUNTFOR_E付款金额 FPAYBILLENTRY.FISPOST是否登账 FPAYBILLENTRY.FPOSTDATE登账日期 FPAYBILLENTRY.FMATERIALID物料编码 FPAYBILLENTRY.FEXPENSEDEPTID_E费用承担部门 FPAYBILLENTRY.FPayType支付类型 FPAYBILLENTRY.FPRICE含税单价 FPAYBILLENTRY.FQTY数量 FPAYBILLENTRY.FTaxAmt税额 FPAYBILLENTRY.FCOMMENT备注 FPAYBILLENTRY.FPAYBILLSRCENTRY_Link关联关系表 FPAYBILLENTRY.FPAYBILLSRCENTRY_Link_FRuleId转换规则 FPAYBILLENTRY.FPAYBILLSRCENTRY_Link_FSTableName源单表 FPAYBILLENTRY.FPAYBILLSRCENTRY_Link_FSBillId源单内码 FPAYBILLENTRY.FPAYBILLSRCENTRY_Link_FSId源单分录内码

数据对接效果

可视化配置,即便是普通业务人员也可以快速轻松对接多个平台,解决企业面临的数据孤岛,数据混乱等问题,实现数据可见、可用、可运营。进行统一化,模块化,标准化的服务能力和输出,实现对业务端数据需求的精准满足和高效响应,也可以在业务数据需求的不断增加下,让企业有整套的可复用的api资产以更换,支持业务的正常运转,节省开发成本。在不同的着重点和应用上解决数据共享,实现平台之间的独立管理。
ERP接口数据对接
金蝶云星空对接