金蝶云星空与易快报对接集成获取指定状态单据列表(包含已删除单据)连通付款单新增(款项支付单同步)
金蝶云星空与易快报对接集成获取指定状态单据列表(包含已删除单据)连通付款单新增(款项支付单同步)
对接源平台:易快报
合思信息致力于企业SaaS领域云产品及服务的创新,运用前沿的互联网应用技术和先进的企业管理理念,为企业提供差旅订购、电子报销、预算费控、发票管理等一站式服务,从而帮企业实现显著的降本增效,为企业提供有力的业务决策支持。
对接目标系统:金蝶云星空
金蝶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分页查询的起始索引序号string1610640000 fields.count查询数据条数string10 fields.state单据状态string响应参数
字段字段名称类型配置值 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金蝶云星空接口明细
- 调用接口:batchSave
- 接口名称:付款单新增
- 方法:POST
请求参数
字段字段名称类型配置值 FBillNo单据编号string{{id}} FCURRENCYID币别stringPRE001 FDATE业务日期stringfunction FROM_UNIXTIME( ( {{expenseDate}} / 1000 ) ,'%Y-%m-%d %H:%i:%S' ) FBillTypeID单据类型stringkxzfd FCONTACTUNITTYPE往来单位类型stringBD_Department FCONTACTUNIT往来单位string_findCollection find code from 19c94f4e-612d-3b26-8952-edf9168371d5 where name={{department.name}} FRECTUNITTYPE收款单位类型stringBD_Department FRECTUNIT收款单位stringfindCollection find code from 19c94f4e-612d-3b26-8952-edf9168371d5 where name={{department.name}} FSETTLEORGID结算组织string100 FDepartment部门stringBM000001 FPAYORGID付款组织string100 FPAYAMOUNTFOR付款金额string{{sumAmount}} FEXCHANGETYPE汇率类型stringHLTX01_SYS FSETTLECUR结算币别stringPRE001 FREMARK备注string测试单据{{remark}}{{owner.name}}报{{title}} FPAYBILLENTRY付款单明细arraydetails FPAYBILLENTRY.FSETTLETYPEID结算方式stringJSFS01_SYS FPAYBILLENTRY.FPAYTOTALAMOUNTFOR付款金额string{{details.amount}} FPAYBILLENTRY.FPURPOSEID收付款用途stringSFKYT12_SYS FPAYBILLENTRY.FACCOUNTID我方银行账号string FPAYBILLENTRY.FCOMMENT备注string{{details.remark}}测试 FPAYBILLENTRY.FCOSTID费用项目string_findCollection find code from 0e3410bc-d1ad-3810-bd5f-639ce883690a where id={{details.feeTypeId}} FPAYBILLENTRY.FEXPENSEDEPTID_E费用承担部门string_findCollection find code from 19c94f4e-612d-3b26-8952-edf9168371d5 where id={{details.userProps.expenseDepartment}} FPAYBILLENTRY.FormId业务对象表单IdstringAP_PAYBILL FPAYBILLENTRY.Operation执行的操作stringBatchSave FPAYBILLENTRY.IsAutoSubmitAndAudit提交并审核booltrue FPAYBILLENTRY.IsVerifyBaseDataField验证基础资料boolfalse响应参数
字段字段名称类型配置值 FBillNo单据编号string FCURRENCYID币别string FDATE业务日期string FBillTypeID单据类型string FCONTACTUNITTYPE往来单位类型string FCONTACTUNIT往来单位string FRECTUNITTYPE收款单位类型string FRECTUNIT收款单位string FBUSINESSTYPE业务类型string FDepartment部门string FPAYORGID付款组织array FSETTLERATE结算汇率string FPAYAMOUNTFOR付款金额string FEXCHANGETYPE汇率类型string FSETTLECUR结算币别string FEXCHANGERATE汇率string FREMARK备注string FBookingDate期望付款日期string FTHIRDBILLNO第三方单据编号string FIsBorrow是否其他预付string FPRESETASSISTANT1预设辅助资料字段1string FPRESETASSISTANT2预设辅助资料字段2string FPRESETTEXT1预设文本字段1string FPRESETTEXT2预设文本字段2string FPRESETBASE1预设基础资料字段1string FPRESETBASE2预设基础资料字段2string FPAYBILLENTRY付款单明细array FPAYBILLENTRY.FSETTLETYPEID结算方式string FPAYBILLENTRY.FOPPOSITECCOUNTNAME对方账户名称string FPAYBILLENTRY.FHANDLINGCHARGEFOR手续费string FPAYBILLENTRY.FCOSTID费用项目string FPAYBILLENTRY.FPAYAMOUNTFOR_E付款金额string FPAYBILLENTRY.FISPOST是否登账string FPAYBILLENTRY.FPOSTDATE登账日期string FPAYBILLENTRY.FMATERIALID物料编码string FPAYBILLENTRY.FEXPENSEDEPTID_E费用承担部门string FPAYBILLENTRY.FPayType支付类型string FPAYBILLENTRY.FPRICE含税单价string FPAYBILLENTRY.FQTY数量string FPAYBILLENTRY.FTaxAmt税额string FPAYBILLENTRY.FCOMMENT备注string FPAYBILLENTRY.FPAYBILLSRCENTRY_Link关联关系表array FPAYBILLENTRY.FPAYBILLSRCENTRY_Link_FRuleId转换规则string FPAYBILLENTRY.FPAYBILLSRCENTRY_Link_FSTableName源单表string FPAYBILLENTRY.FPAYBILLSRCENTRY_Link_FSBillId源单内码string FPAYBILLENTRY.FPAYBILLSRCENTRY_Link_FSId源单分录内码string系统数据集成价值
通过无代码的数据集成与数据建模的智能数据管道技术,帮助企业将所有应用程序、数据库、事件和文件等数据信息提取到数据仓库中,并快速将分散的数据转化为数据集、API、自动化流程等开箱即用的数据服务。配置接口的模式对接易快报和金蝶云星空,使得单据无缝互通。打造企业内部数据一体化,让企业日常运营管理实现敏捷数据化运营。实现供应链业务信息流的互通,同时支持供应链数据分析流程自动化,结果推送,推进相关供应链问题优化。及时打通供应链孤岛,实现数据驱动供应链协同,进一步提升企业竞争力。

