易快报接口与金蝶云星空接口实现互通

数据源系统:易快报

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

对接目标系统:金蝶云星空

金蝶K/3Cloud结合当今先进管理理论和数十万家国内客户最佳应用实践，面向事业部制、多地点、多工厂等运营协同与管控型企业及集团公司，提供一个通用的ERP服务平台。K/3Cloud支持的协同应用包括但不限于：集中/分散销售、集中/分散采购、B2B电商管理、B2C电商中心、供应商协同、多工厂计划、跨工厂领料、跨工厂加工、工厂间调拨、内部交易及结算、集团财务管理、阿米巴经营等。

多系统对接方案配置

通过轻易云系统数据集成平台新增创建集成方案，通过轻易云的方案市场可以一键复制，并且可以借鉴其他的方案配置完成方案制作，方案制作只需要两步，第一步先确定好对应的数据来源；源系统：易快报接口：获取指定状态单据列表(包含已删除单据)通过请求调度者配置对应的请求参数即可获取到对应的数据。目标系统：金蝶云星空接口：付款单新增，通过写入调度者匹配获取到的数据和写入的映射关系，即可自动生成符合目标系统：金蝶云星空写入的数据自动产生写入队列，通过运行概况，系统会自动帮你诊断方案的运行情况。实时监控到方案的运行情况

易快报接口明细

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单据编号{{id}} FCURRENCYID币别PRE001 FDATE业务日期function FROM_UNIXTIME( ( {{expenseDate}} / 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结算组织100 FDepartment部门_findCollection find code from 19c94f4e-612d-3b26-8952-edf9168371d5 where name={{department.name}} FPAYORGID付款组织100 FPAYAMOUNTFOR付款金额{{sumAmount}} FEXCHANGETYPE汇率类型HLTX01_SYS FSETTLECUR结算币别PRE001 FREMARK备注测试单据{{remark}}{{owner.name}}报{{title}} FPAYBILLENTRY付款单明细details FPAYBILLENTRY.FSETTLETYPEID结算方式JSFS01_SYS FPAYBILLENTRY.FPAYTOTALAMOUNTFOR付款金额function sum({{details.amount}}-{{details.userProps.writtenOffMoney}}) FPAYBILLENTRY.FPURPOSEID收付款用途SFKYT12_SYS FPAYBILLENTRY.FACCOUNTID我方银行账号 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_PBLH_YKBHEXJE核销金额{{details.userProps.writtenOffMoney}} 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、自动化流程等开箱即用的数据服务。配置接口的模式对接易快报和金蝶云星空，使得单据无缝互通。打造企业内部数据一体化，让企业日常运营管理实现敏捷数据化运营。实现供应链业务信息流的互通，同时支持供应链数据分析流程自动化，结果推送，推进相关供应链问题优化。及时打通供应链孤岛，实现数据驱动供应链协同，进一步提升企业竞争力。