轻易云
注册体验

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

1 条评论

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

多系统间数据对接

对接系统：易快报

合思信息致力于企业SaaS领域云产品及服务的创新，运用前沿的互联网应用技术和先进的企业管理理念，为企业提供差旅订购、电子报销、预算费控、发票管理等一站式服务，从而帮企业实现显著的降本增效，为企业提供有力的业务决策支持。

对接系统：金蝶云星空

金蝶K/3Cloud在总结百万家客户管理最佳实践的基础上，提供了标准的管理模式；通过标准的业务架构：多会计准则、多币别、多地点、多组织、多税制应用框架等，有效支持企业的运营管理；K/3Cloud提供了标准的业务建模：35种标准ERP领域模型、1046种模型元素、21243种模型元素属性组合，288个业务服务构件，让企业及伙伴可快速构建出行业化及个性化的应用。

数据接口配置方案

系统对接前期需要通过调研公司的业务，规划出最便捷，效率最高的整体流程。通过流程我们需要建立对应的方案来吧这些流程一一的落地，轻易云集成平台开箱即用的、可视化拖、拉、拽实现接口服务编排与聚合。只需要根据指引设定好对应的参数即可启动使用。设定好源平台：易快报的接口参数设置，以及设定好目标平台：金蝶云星空的映射，即可启动方案进行测试
跨境电商与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_function ({{LAST_SYNC_TIME}}000)*1 fields.count查询数据条数string10 fields.state单据状态stringPROCESSING

响应参数

字段字段名称类型配置值 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单据编号stringfunction case when '{{details_userProps_u归属组织code}}'='' then '{{code}}{{userProps_u归属组织code}}' else '{{code}}{{details_userProps_u归属组织code}}' end FPAYORGID付款组织string_function case when '{{FPAYORGID}}'>0 then '{{FPAYORGID}}' when '{{details_userProps_u归属组织code}}' in ('') then '{{userProps_u归属组织code}}' else '{{details_userProps_u归属组织code}}' end FSETTLEORGID结算组织stringfunction case when '{{details_userProps_u归属组织code}}'>0 then '{{details_userProps_u归属组织code}}' else '{{userProps_u归属组织code}}' end FCURRENCYID币别stringPRE001 FDATE业务日期string_function FROM_UNIXTIME( ( {{payTime}} / 1000 ) ,'%Y-%m-%d %H:%i:%S' ) FBillTypeID单据类型stringfunction case when '{{writeOffAmount}}'>0 then 'hxd' else 'rcfybxd' end FCONTACTUNITTYPE往来单位类型stringBD_Department FCONTACTUNIT往来单位string_function case when '{{department_code}}' in ('') then 'BM000001' else '{{department_code}}' end FRECTUNITTYPE收款单位类型stringBD_Department FRECTUNIT收款单位stringfunction case when '{{department_code}}' in ('') then 'BM000001' else '{{department_code}}' end FDepartment部门string{{department_code}} FPAYAMOUNTFOR付款金额string_function sum({{sumAmount}}-{{writeOffAmount}}) FEXCHANGETYPE汇率类型stringHLTX01_SYS FSETTLECUR结算币别stringPRE001 FREMARK备注stringfunction left('{{title}}',400) F_wk_bxje1报销金额string{{sumAmount}} F_wk_hxje核销金额string{{writeOffAmount}} F_wk_YG员工string_function case when '{{userProps_u原借款人name}}'='' then '{{userProps_u实际报销人name}}' else '{{userProps_u原借款人name}}' end FPAYBILLENTRY付款单明细arraydetails FPAYBILLENTRY.FSETTLETYPEID结算方式stringfunction case when '{{paymentAccount_accountNo}}' in ('') then '10' when '{{writeOffAmount}}'>0 then '10' else 'JSFS04_SYS' end FPAYBILLENTRY.FPAYTOTALAMOUNTFOR付款金额string_function abs({{details_amount}}) FPAYBILLENTRY.FPURPOSEID收付款用途stringSFKYT10_SYS FPAYBILLENTRY.FACCOUNTID我方银行账号string{{paymentAccount_accountNo}} FPAYBILLENTRY.FCOMMENT备注stringfunction left('{{details_remark}}',400) FPAYBILLENTRY.FCOSTID费用项目string_findCollection find code from 0e3410bc-d1ad-3810-bd5f-639ce883690a where id={{details_feeTypeId}} FPAYBILLENTRY.FEXPENSEDEPTID_E费用承担部门stringfindCollection find code from 19c94f4e-612d-3b26-8952-edf9168371d5 where id={{details_userProps_expenseDepartment}} FPAYBILLENTRY.F_wk_KH客户string{{details_userProps_u_客户code}} FPAYBILLENTRY.F_PBLH_YKBHEXJE易快报核销金额string{{details_amount}} FPAYBILLENTRY.F_WK_NF年份string{{details_userProps_u_年份code}} FPAYBILLENTRY.F_WK_jj季节string{{details_userProps_u_季度code}} FPAYBILLENTRY.F_WK_PP品牌string{{details_userProps_u_品牌_code}} FPAYBILLENTRY.FormId业务对象表单IdstringAP_PAYBILL FPAYBILLENTRY.Operation执行的操作stringBatchSave FPAYBILLENTRY.IsAutoSubmitAndAudit提交并审核boolfalse FPAYBILLENTRY.IsVerifyBaseDataField验证基础资料boolfalse

系统数据对接

随着企业数字化业务的深入发展，对于企业的 IT 或者 CIO 来讲，正在面临一个愈发重要的问题——系统的结构太复杂了，尤其是头部企业，至少有十多套系统，这些系统之间的蛛网状的接口如果经常出问题。企业内部以及企业内部与外部建立起越来越多的业务应用系统，如何整合企业的现有IT资源，使企业中计算机孤岛式的应用向集体协作的方向发展，发挥资源效益的最大化，降低企业成本，正在逐渐成为企业关注的重要问题。用户希望企业内所有系统集成在一个平台上，操作统一，以节省培训时间。使用在轻易云应用集成平台 + MDM基础数据平台的解决方案中，轻易云应用集成平台负责实现异构、分布式系统之间互联互通，实现服务API治理以及数据传输交换。通过轻易云预置的各种适配器组件，连接现有各孤立应用系统，以图形化、拖拽方式构建集成流程和服务，提高应用系统集成工作效率，降低异构系统集成风险。针对未来可能出现的业务需求变更，在应用集成平台上进行动态调整，实现各应用系统之间的集成策略平滑升级。
API数据接口打通

论坛热帖