和小青GPT助理聊天吧

小青是一位基于大语言预训练模型的超级智能AI,熟悉轻易云产品并能为您提供多种数据集成方案和技术支持。您在使用轻易云产品时遇到问题或有关技术咨询,小青都将为您提供专业、即时、高效的帮助和建议。与小青智能对话,您可享受同人类互动一样的使用体验,全面了解最新产品更新、功能特性及相关技术资讯,进一步提升您在数据集成领域的实力。小青是您友好、智能、便捷的助手,与她互动让您的数据集成之路轻松愉快。
轻易云自训练大语言模型小青助理
扫码关注公众号即可开始聊天

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

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

数据集成平台

源系统:易快报

易快报是敏捷的企业报销费控与聚合消费平台,为企业提供移动报销、聚合消费、全程费控、预算管理、发票管理等一站式解决方案。同时,易快报可集成多家银行及第三方支付平台,打通对公对私付款,对接财务软件自动生成凭证,实现申请-订购-报销-验票-支付-记账全流程,并可与企业现有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的方式对外开放,实现业务创新、能力输出。
数据集成方案
用友接口

热门文章

网易互客对接打通金蝶云星空查询订单列表接口与[标准][收款单新增]-v1接口

2023-01-26 10:08:49

畅捷通T+与道一云对接集成获取报销信息列表连通凭证创建(报销车辆维修费(甘肃))

2023-01-26 10:08:49

钉钉和四化智造MES(WEB)单据接口集成

2023-01-26 10:08:48

积加ERP与金蝶云星空对接集成采购入库查询连通创建其他入库单(KG采购入库对接其他入库-新)

2023-01-26 10:08:47

管易云对接打通金蝶K3-WISE退货单查询2.0接口与新增销售出库(红蓝字)接口

2023-01-26 10:08:46