轻易云
注册体验

易快报和金蝶云星空接口打通对接实战

1 条评论

易快报和金蝶云星空接口打通对接实战

ERP接口数据对接

对接系统易快报

易快报为企业提供移动报销,预算费控,台账管理,报表分析,电子发票验真查重,全流程费控等一站式解决方案.全方位满足企业的报销费控需求,以连接为核心,促进企业降低成本、提升效率.

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

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

数据接口配置

集成方案是整个轻易云集成平台的核心，每一个集成方案代表一种业务的对接策略（对接方案借鉴可以在轻易云系统数据集成交流社区bbs.qeasy.cloud 中找到相关信息），用户可以根据业务的不同新建多个不同规则的集成方案。比如：采购订单同步，线上销售出库同步，线下销售出库同步。一个集成方案必须要配置源系统：易快报，源系统 API：获取指定状态单据列表(包含已删除单据)，目标系统：金蝶云星空，目标系统 API付款单新增。在新增集成方案之前需要确定两个系统的连接器都已经配置完成。
飞书与ERP对接

易快报接口明细

  • 调用接口：/api/openapi/v1/docSequences
  • 接口名称：获取指定状态单据列表(包含已删除单据)
  • 方法：POST

请求参数

字段字段名称类型配置值 fields需要过滤掉的字段object fields.docData单据数据object fields.docData.logs审批日志string fields.docData.flowPlan审批流信息string fields.type单据类型stringexpense fields.index分页查询的起始索引序号string{{LAST_SYNC_TIME}}000 fields.count查询数据条数string10 fields.state单据状态stringPAID

响应参数

字段字段名称类型配置值 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

金蝶云星空接口明细

  • 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 FCURRENCYID币别PRE001 FDATE业务日期_function FROM_UNIXTIME( ( {{payTime}} / 1000 ) ,'%Y-%m-%d %H:%i:%S' ) FBillTypeID单据类型clbxd 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结算组织function case when '{{details.userProps.u归属组织.code}}'>0 then '{{details.userProps.u归属组织.code}}' else '{{userProps.u归属组织.code}}' end FDepartment部门findCollection find code from 19c94f4e-612d-3b26-8952-edf9168371d5 where name={{department_name}} FPAYORGID付款组织 FPAYAMOUNTFOR付款金额_function sum({{sumAmount}}-{{writeOffAmount}}) FEXCHANGETYPE汇率类型HLTX01_SYS FSETTLECUR结算币别PRE001 FREMARK备注{{remark}} FPAYBILLENTRY付款单明细details FPAYBILLENTRY.FSETTLETYPEID结算方式function case when '{{paymentAccount_accountNo}}' in ('') then '10' else 'JSFS04_SYS' end FPAYBILLENTRY.FPAYTOTALAMOUNTFOR付款金额{{details_amount}} FPAYBILLENTRY.FPURPOSEID收付款用途SFKYT12_SYS FPAYBILLENTRY.FACCOUNTID我方银行账号{{paymentAccount_accountNo}} 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_wk_KH客户{{details_userProps_u_客户code}} FPAYBILLENTRY.F_PBLH_YKBHEXJE易快报核销金额{{details_amount}} FPAYBILLENTRY.F_wk_bxje1报销金额{{sumAmount}} FPAYBILLENTRY.F_wk_hxje核销金额{{writeOffAmount}} FPAYBILLENTRY.F_wk_YG员工_function case when '{{userProps_u原借款人code}}'='' then '{{userProps_u实际报销人code}}' else '{{userProps_u原借款人code}}' end FPAYBILLENTRY.FormId业务对象表单IdAP_PAYBILL必须填写金蝶的表单ID如😛UR_PurchaseOrder FPAYBILLENTRY.Operation执行的操作BatchSave FPAYBILLENTRY.IsAutoSubmitAndAudit提交并审核false FPAYBILLENTRY.IsVerifyBaseDataField验证基础资料false是否验证所有的基础资料有效性，布尔类，默认false（非必录）

系统数据对接

将传统的统计分析转变为预测分析，从被动分析到主动分析，从非实时分析转变为实时分析，从结构化的数据变成多元化的数据。精准查询数据流同步状况，实时监管队列任务以及数据资产的有序管理。为业务赋能，降本增效，让企业能够更加合理的布局团队；结合业务需求实现与OA，CRM，WMS等系统之间的数据交流与同步，为企业定制自定义的数据管理方案，用技术拓展商业边界，为新业务、新部门提供成长空间。
管易对接

论坛热帖