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

来源系统:易快报

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

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

金蝶K/3Cloud（金蝶云星空）是移动互联网时代的新型ERP，是基于WEB2.0与云技术的新时代企业管理服务平台。金蝶K/3Cloud围绕着“生态、人人、体验”，旨在帮助企业打造面向新时代的生态互联与协同平台，围绕生态中的每个角色，提供随手可得的云服务，最终实现敏捷协同，智慧运营的企业运营新境界。整个产品采用SOA架构，完全基于BOS平台组建而成，业务架构上贯穿流程驱动与角色驱动思想，结合中国管理模式与中国管理实践积累，精细化支持企业财务管理、供应链管理、生产管理、供应链协同管理、人力资源管理等核心应用。技术架构上该产品采用平台化构建，支持跨数据库应用，支持本地部署、私有云部署与公有云部署三种部署方式，同时还在公有云上开放中国第一款基于ERP的协同开发云平台。任何一家使用金蝶K/3Cloud产品的企业，其拥有的是包含金蝶在内的众多基于同一个平台提供服务的IT服务伙伴。

系统对接接口配置

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

易快报接口明细

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

请求参数

字段名称类型描述 fields需要过滤掉的字段object指定过滤掉的字段返回空值，从而缩小响应数据 fields.docData单据数据object包含所有单据数据 fields.docData.logs审批日志string fields.docData.flowPlan审批流信息string fields.type单据类型stringexpense : 报销单 loan : 借款单 repayment : 还款记录 payment : 付款单 requisition : 申请单 custom : 通用审批单 receipt : 收款单 fields.index分页查询的起始索引序号string例如 : 当 index = 1484498318240 时，会查询所有 index > 1484498318240 的单据 fields.count查询数据条数string最大不能超过 100 fields.state单据状态stringREJECTED : 已驳回 PAYING : 待支付 PROCESSING : 支付中 PAID : 已支付不传值时，查询四种状态单据

响应参数

字段名称类型描述 typetypestringautoFillResponse ididstring_autoFillResponse corporationIdcorporationIdstringautoFillResponse ownerIdownerIdstring_autoFillResponse dataTypedataTypestringautoFillResponse remarkremarkstring_autoFillResponse titletitlestringautoFillResponse updateTimeupdateTimestring_autoFillResponse specificationIdspecificationIdstringautoFillResponse ownerownerobject_autoFillResponse owner.ididstringautoFillResponse owner.namenamestring_autoFillResponse owner.departmentsdepartmentsstringautoFillResponse owner.codecodestring_autoFillResponse owner.departmentdepartmentobjectautoFillResponse owner.department.ididstring_autoFillResponse owner.department.namenamestringautoFillResponse owner.department.codecodestring_autoFillResponse owner.department.codecodestringautoFillResponse owner.department.userPropsuserPropsobject_autoFillResponse owner.department.userProps.payeeIdpayeeIdstringautoFillResponse owner.department.userProps.descriptiondescriptionstring_autoFillResponse owner.department.userProps.submitterIdsubmitterIdstringautoFillResponse owner.department.userProps.companyRealPaycompanyRealPaystring_autoFillResponse owner.department.userProps.specificationIdspecificationIdstringautoFillResponse owner.department.userProps.expenseDepartmentexpenseDepartmentstring_autoFillResponse owner.department.userProps.companyRealPay_ratecompanyRealPay_ratestringautoFillResponse owner.department.userProps.companyRealPay_budgetcompanyRealPay_budgetstring_autoFillResponse owner.department.userProps.companyRealPay_foreigncompanyRealPay_foreignstringautoFillResponse owner.department.userProps.companyRealPay_budgetRatecompanyRealPay_budgetRatestring_autoFillResponse owner.department.userProps.companyRealPay_budgetUnitcompanyRealPay_budgetUnitstringautoFillResponse owner.department.userProps.companyRealPay_budgetScalecompanyRealPay_budgetScalestring_autoFillResponse owner.department.userProps.companyRealPay_foreignUnitcompanyRealPay_foreignUnitstringautoFillResponse owner.department.userProps.companyRealPay_budgetSymbolcompanyRealPay_budgetSymbolstring_autoFillResponse owner.department.userProps.companyRealPay_standardUnitcompanyRealPay_standardUnitstringautoFillResponse owner.department.userProps.companyRealPay_budgetNumCodecompanyRealPay_budgetNumCodestring_autoFillResponse owner.department.userProps.companyRealPay_budgetStrCodecompanyRealPay_budgetStrCodestringautoFillResponse owner.department.userProps.companyRealPay_foreignSymbolcompanyRealPay_foreignSymbolstring_autoFillResponse owner.department.userProps.companyRealPay_foreignNumCodecompanyRealPay_foreignNumCodestringautoFillResponse owner.department.userProps.companyRealPay_foreignStrCodecompanyRealPay_foreignStrCodestring_autoFillResponse owner.department.userProps.companyRealPay_standardSymbolcompanyRealPay_standardSymbolstringautoFillResponse owner.department.userProps.companyRealPay_standardNumCodecompanyRealPay_standardNumCodestring_autoFillResponse owner.department.userProps.companyRealPay_standardStrCodecompanyRealPay_standardStrCodestringautoFillResponse owner.department.userProps.statestatestring_autoFillResponse owner.department.userProps.projectprojectstringautoFillResponse owner.department.userProps.logslogsstring_autoFillResponse owner.department.userProps.flowPlanflowPlanstringautoFillResponse owner.department.userProps.sumAmountsumAmountstring_autoFillResponse owner.department.userProps.writeOffAmountwriteOffAmountstringautoFillResponse owner.department.userProps.expenseDateexpenseDatestring_autoFillResponse owner.department.userProps.detailsdetailsarrayautoFillResponse owner.department.userProps.details.amountamountstring_autoFillResponse owner.department.userProps.details.amount_standardStrCodeamount_standardStrCodestringautoFillResponse owner.department.userProps.details.amount_standardNumCodeamount_standardNumCodestring_autoFillResponse owner.department.userProps.details.amount_standardSymbolamount_standardSymbolstringautoFillResponse owner.department.userProps.details.amount_standardUnitamount_standardUnitstring_autoFillResponse owner.department.userProps.details.amount_rateamount_ratestringautoFillResponse owner.department.userProps.details.amount_foreignStrCodeamount_foreignStrCodestring_autoFillResponse owner.department.userProps.details.amount_foreignNumCodeamount_foreignNumCodestringautoFillResponse owner.department.userProps.details.amount_foreignamount_foreignstring_autoFillResponse owner.department.userProps.details.amount_foreignSymbolamount_foreignSymbolstringautoFillResponse owner.department.userProps.details.amount_foreignUnitamount_foreignUnitstring_autoFillResponse owner.department.userProps.details.datedatestringautoFillResponse owner.department.userProps.details.remarkremarkstring_autoFillResponse owner.department.userProps.details.feeTypeIdfeeTypeIdstringautoFillResponse owner.department.userProps.details.userPropsuserPropsstring_autoFillResponse owner.department.userProps.details.invoiceCountinvoiceCountstringautoFillResponse owner.department.userProps.details.taxAmounttaxAmountstring_autoFillResponse owner.department.userProps.details.noTaxAmountnoTaxAmountstringautoFillResponse owner.department.userProps.details.invoicesinvoicesstring_autoFillResponse owner.department.userProps.details.invoiceFormTypeinvoiceFormTypestringautoFillResponse owner.department.userProps.details.payeeInfopayeeInfostring_autoFillResponse owner.department.userProps.details.writtenOffRecordswrittenOffRecordsobjectautoFillResponse owner.department.userProps.details.submitTimesubmitTimestring_autoFillResponse owner.department.userProps.details.payeeInfopayeeInfoobjectautoFillResponse owner.department.userProps.details.payeeInfo.sortsortstring_autoFillResponse owner.department.userProps.details.payeeInfo.namenamestringautoFillResponse owner.department.userProps.details.payeeInfo.cardNocardNostring_autoFillResponse owner.department.userProps.details.payeeInfo.bankbankstringautoFillResponse owner.department.userProps.details.payeeInfo.branchbranchstring_autoFillResponse owner.department.userProps.details.payeeInfo.typetypestringautoFillResponse owner.department.userProps.details.payeeInfo.provinceprovincestring_autoFillResponse owner.department.userProps.details.payeeInfo.citycitystringautoFillResponse owner.department.userProps.details.payeeInfo.certificateTypecertificateTypestring_autoFillResponse owner.department.userProps.details.payeeInfo.certificateNocertificateNostringautoFillResponse owner.department.userProps.details.payeeInfo.bankLinkNobankLinkNostring_autoFillResponse owner.department.userProps.details.payeeInfo.bankNamebankNamestringautoFillResponse owner.department.userProps.details.payeeInfo.swiftCodeswiftCodestring_autoFillResponse owner.department.userProps.details.payeeInfo.bankCodebankCodestringautoFillResponse owner.department.userProps.details.payeeInfo.branchCodebranchCodestring_autoFillResponse owner.department.userProps.details.payeeInfo.remarkremarkstringautoFillResponse owner.department.userProps.details.payeeInfo.ididstring_autoFillResponse owner.department.userProps.details.payeeInfo.payorIdpayorIdstringautoFillResponse owner.department.userProps.details.payeeInfo.paymentChannelpaymentChannelstring_autoFillResponse owner.department.userProps.details.payeeInfo.paymentAccountIdpaymentAccountIdstringautoFillResponse owner.department.userProps.details.payeeInfo.payTimepayTimestring_autoFillResponse owner.department.userProps.details.payeeInfo.multiplePayeesModemultiplePayeesModestringautoFillResponse owner.department.userProps.details.payeeInfo.channelTradeNochannelTradeNostring_autoFillResponse owner.department.userProps.details.payeeInfo.payPlanpayPlanstringautoFillResponse owner.department.userProps.details.payeeInfo.receiptStatereceiptStatestring_autoFillResponse owner.department.userProps.details.payeeInfo.paymentAccountpaymentAccountstring_autoFillResponse

金蝶云星空接口明细

API：batchSave
NAME：付款单新增
METHOD：POST

请求参数

接口字段字段名称预设值描述 FBillNo单据编号{{code}} FCURRENCYID币别PRE001 FDATE业务日期function FROM_UNIXTIME( ( {{payTime}} / 1000 ) ,'%Y-%m-%d %H:%i:%S' ) FBillTypeID单据类型lsyksqd FCONTACTUNITTYPE往来单位类型BD_Empinfo FCONTACTUNIT往来单位{{userProps.u_实际申请人.code}} FRECTUNITTYPE收款单位类型BD_Empinfo FRECTUNIT收款单位{{userProps.u实际申请人.code}} FSETTLEORGID结算组织{{userProps_u_归属组织code}} FDepartment部门_findCollection find code from 19c94f4e-612d-3b26-8952-edf9168371d5 where name={{department.name}} FPAYORGID付款组织function case when '{{FPAYORGID}}' in ('') then '{{userProps_u归属组织code}}' else '{{FPAYORGID}}' end FPAYAMOUNTFOR付款金额{{money}} FEXCHANGETYPE汇率类型HLTX01_SYS FSETTLECUR结算币别PRE001 FREMARK备注{{title}} FPAYBILLENTRY付款单明细 FPAYBILLENTRY.FSETTLETYPEID结算方式_function case when '{{paymentAccount.accountNo}}' in ('') then '10' else 'JSFS04_SYS' end FPAYBILLENTRY.FPAYTOTALAMOUNTFOR付款金额{{money}} FPAYBILLENTRY.FPURPOSEID收付款用途SFKYT12_SYS FPAYBILLENTRY.FACCOUNTID我方银行账号{{paymentAccount.accountNo}} FPAYBILLENTRY.FCOMMENT备注function left('{{remark}}',400) FPAYBILLENTRY.FCOSTID费用项目_findCollection find code from 0e3410bc-d1ad-3810-bd5f-639ce883690a where id={{details_feeTypeId}} FPAYBILLENTRY.FEXPENSEDEPTID_E费用承担部门{{userProps_loanDepartment_code}} FPAYBILLENTRY.F_wk_KH客户 FPAYBILLENTRY.F_wk_bxje1报销金额 FPAYBILLENTRY.F_wk_hxje核销金额 FPAYBILLENTRY.F_wk_YG员工{{userProps.u_实际申请人.name}} FPAYBILLENTRY.FormId业务对象表单IdAP_PAYBILL必须填写金蝶的表单ID如😛UR_PurchaseOrder FPAYBILLENTRY.Operation执行的操作BatchSave FPAYBILLENTRY.IsAutoSubmitAndAudit提交并审核false FPAYBILLENTRY.IsVerifyBaseDataField验证基础资料false是否验证所有的基础资料有效性，布尔类，默认false（非必录）

数据对接效果

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

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