金蝶云星空与浪潮ERP对接集成付款申请单查询打通新增凭证-定制webService

金蝶云星空与浪潮ERP对接集成付款申请单查询打通新增凭证-定制webService

对接系统：金蝶云星空

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

写入目标:浪潮ERP

cc

数据对接方案

通过数据集成平台新增创建集成方案，然后在数据源平台中选择对应的源平台为：金蝶云星空，并且选择对应的连接器（关于金蝶云星空的接口连接器如何配置可以在轻易云系统数据集成交流社区bbs.qeasy.cloud 中找到相关信息）。选择对应的付款申请单查询接口作为数据对接来源。然后再通过写入目标平台配置目标系统为浪潮ERP，并且选择对应连接器。选择对应的新增凭证-定制webService接口作为数据写入动作，既可以完成第一步的数据对接配置；打破跨系统连接，让数据轻易互通成为现实。

金蝶云星空接口明细

• 调用接口：executeBillQuery
• 接口名称：付款申请单查询
• 方法：POST

请求参数

字段字段名称类型配置值 FID实体主键stringFID FBillNo单据编号stringFBillNo FDOCUMENTSTATUS单据状态stringFDOCUMENTSTATUS FCREATORID创建人stringFCREATORID FAPPROVERID审核人stringFAPPROVERID FCREATEDATE创建日期stringFCREATEDATE FSETTLEORGID结算组织stringFSETTLEORGID FAPPROVEDATE审核日期stringFAPPROVEDATE FPURCHASEORGID采购组织stringFPURCHASEORGID FPAYAMOUNTFOR_H应付金额stringFPAYAMOUNTFOR_H FCURRENCYID币别stringFCURRENCYID FDATE申请日期stringFDATE FMODIFYDATE修改日期stringFMODIFYDATE FMODIFIERID修改人stringFMODIFIERID FBILLTYPEID单据类型stringFBILLTYPEID FPURCHASERID采购员stringFPURCHASERID FPURCHASEDEPTID采购部门stringFPURCHASEDEPTID FAPPLYAMOUNTFOR_H申请付款金额stringFAPPLYAMOUNTFOR_H FACCOUNTSYSTEM会计核算体系stringFACCOUNTSYSTEM FCANCELLERID作废人stringFCANCELLERID FCANCELSTATUS作废状态stringFCANCELSTATUS FCANCELDATE作废日期stringFCANCELDATE FCONTACTUNITTYPE往来单位类型stringFCONTACTUNITTYPE FCONTACTUNIT往来单位stringFCONTACTUNIT FRECTUNITTYPE收款单位类型stringFRECTUNITTYPE FRECTUNIT收款单位stringFRECTUNIT FBUSINESSTYPE业务类型stringFBUSINESSTYPE FDEPARTMENT部门stringFDEPARTMENT FPAYORGID付款组织stringFPAYORGID FSALEORGID销售组织stringFSALEORGID FSALEDEPTID销售部门stringFSALEDEPTID FSALEERID销售员stringFSALEERID FMAINBOOKID本位币stringFMAINBOOKID FEXCHANGERATE汇率stringFEXCHANGERATE FEXCHANGETYPE汇率类型stringFEXCHANGETYPE FSOURCESYSTEM来源系统stringFSOURCESYSTEM FIsCredit是否信贷业务stringFIsCredit FBankActID银行账号stringFBankActID FAPPLYORGID申请组织stringFAPPLYORGID FScanPoint扫描点stringFScanPoint FCLOSESTATUS关闭状态stringFCLOSESTATUS FCLOSERID关闭人stringFCLOSERID FCLOSEDATE关闭日期stringFCLOSEDATE FSETTLECUR结算币别stringFSETTLECUR FREALAPPLYAMOUNTFOR实际申请金额stringFREALAPPLYAMOUNTFOR FSETTLERATE结算汇率stringFSETTLERATE FAPPLYAMOUNT申请付款金额本位币stringFAPPLYAMOUNT FPURCHASERGROUPID采购组stringFPURCHASERGROUPID FSALEGROUPID销售组stringFSALEGROUPID FIsBorrow是否其他预付stringFIsBorrow FISCARRYRATE是否下推携带汇率到结算汇率stringFISCARRYRATE FMoreReceive多收款人stringFMoreReceive FPRESETBASE1预设基础资料字段1stringFPRESETBASE1 FPRESETBASE2预设基础资料字段2stringFPRESETBASE2 FPRESETASSISTANT1预设辅助资料字段1stringFPRESETASSISTANT1 FPRESETASSISTANT2预设辅助资料字段2stringFPRESETASSISTANT2 FPRESETTEXT1预设文本字段1stringFPRESETTEXT1 FPRESETTEXT2预设文本字段2stringFPRESETTEXT2 F_JSJT_CheckBox_SFXT是否相同组织stringF_JSJT_CheckBox_SFXT F_JSJT_Base_DYGYS对应供应商stringF_JSJT_Base_DYGYS F_JSJT_CheckBox_GX更新按钮stringF_JSJT_CheckBox_GX F_JSJT_CheckBox_YD源单stringF_JSJT_CheckBox_YD F_JSJT_PrintTimes打印次数stringF_JSJT_PrintTimes FPAYAPPLYENTRY_FEntryIDFPAYAPPLYENTRY_FEntryIDstringFPAYAPPLYENTRY_FEntryID FSETTLETYPEID结算方式stringFSETTLETYPEID FPAYAMOUNTFOR应付金额stringFPAYAMOUNTFOR FEACHBANKACCOUNT对方银行账号stringFEACHBANKACCOUNT FAPPLYAMOUNTFOR申请付款金额stringFAPPLYAMOUNTFOR FPAYPURPOSEID付款用途stringFPAYPURPOSEID FARPURPOSEID收款用途stringFARPURPOSEID FSOURCETYPE源单类型stringFSOURCETYPE FSRCBILLNO源单编号stringFSRCBILLNO FENDDATE到期日stringFENDDATE FEXPECTPAYDATE期望付款日期stringFEXPECTPAYDATE FEACHCCOUNTNAME对方账户名称stringFEACHCCOUNTNAME FEACHBANKNAME对方开户行stringFEACHBANKNAME FCOMMENT备注（作废）stringFCOMMENT FSRCROWID源单行内码stringFSRCROWID FRELATEPAYAMOUNT付退款关联金额stringFRELATEPAYAMOUNT FRELATEREFUNDAMOUNT作废—收款退款关联金额stringFRELATEREFUNDAMOUNT FCOSTID费用项目stringFCOSTID FApplyPclAmount申请还本金额stringFApplyPclAmount FApplyInstAmount申请付利息金额stringFApplyInstAmount FWritePclAmount关联付利息金额stringFWritePclAmount FDescription备注stringFDescription FMATERIALID物料编码stringFMATERIALID FMATERIALNAME物料名称stringFMATERIALNAME FPURCHASEORDERNO订单号stringFPURCHASEORDERNO FMATERIALSEQ订单行号stringFMATERIALSEQ FORDERENTRYID订单明细内码stringFORDERENTRYID FPRICE含税单价stringFPRICE FQTY数量stringFQTY FPRICEUNITID计价单位stringFPRICEUNITID FRELATEPAYQTY付(退)款关联数量stringFRELATEPAYQTY FUnpaidAmount未付款金额stringFUnpaidAmount FSwiftCodeSwiftCodestringFSwiftCode FTAXAMOUNT税额stringFTAXAMOUNT FBankDetail银行网点stringFBankDetail FEXPENSEDEPTID费用承担部门stringFEXPENSEDEPTID F_JSJT_Base_FKKH费用承担客户stringF_JSJT_Base_FKKH F_JSJT_Base_FYCDZZ费用承担组织stringF_JSJT_Base_FYCDZZ F_JSJT_Base_YG员工stringF_JSJT_Base_YG F_JSJT_Base_CK仓库stringF_JSJT_Base_CK F_JSJT_Assistant股东stringF_JSJT_Assistant F_JSJT_Assistant1投资项目stringF_JSJT_Assistant1 F_JSJT_CheckBox_SFXTZZ是否相同组织stringF_JSJT_CheckBox_SFXTZZ F_JSJT_Assistant2涉税公司stringF_JSJT_Assistant2 F_JSJT_CheckBox_SFEJBM是否二级部门stringF_JSJT_CheckBox_SFEJBM Limit最大行数string{{PAGINATION_PAGE_SIZE}} StartRow开始行索引string{{PAGINATION_START_ROW}} TopRowCount返回总行数int FilterString过滤条件stringFApproveDate>='{{LAST_SYNC_TIME dateTime}}' FieldKeys需查询的字段key集合array FormId业务对象表单IdstringCN_PAYAPPLY

响应参数

字段字段名称类型配置值 FID实体主键string FBillNo单据编号string FDOCUMENTSTATUS单据状态string FCREATORID创建人string FAPPROVERID审核人string FCREATEDATE创建日期string FSETTLEORGID结算组织string FAPPROVEDATE审核日期string FPURCHASEORGID采购组织string FPAYAMOUNTFOR_H应付金额string FCURRENCYID币别string FDATE申请日期string FMODIFYDATE修改日期string FMODIFIERID修改人string FBILLTYPEID单据类型string FPURCHASERID采购员string FPURCHASEDEPTID采购部门string FAPPLYAMOUNTFOR_H申请付款金额string FACCOUNTSYSTEM会计核算体系string FCANCELLERID作废人string FCANCELSTATUS作废状态string FCANCELDATE作废日期string FCONTACTUNITTYPE往来单位类型string FCONTACTUNIT往来单位string FRECTUNITTYPE收款单位类型string FRECTUNIT收款单位string FBUSINESSTYPE业务类型string FDEPARTMENT部门string FPAYORGID付款组织string FSALEORGID销售组织string FSALEDEPTID销售部门string FSALEERID销售员string FMAINBOOKID本位币string FEXCHANGERATE汇率string FEXCHANGETYPE汇率类型string FSOURCESYSTEM来源系统string FIsCredit是否信贷业务string FBankActID银行账号string FAPPLYORGID申请组织string FScanPoint扫描点string FCLOSESTATUS关闭状态string FCLOSERID关闭人string FCLOSEDATE关闭日期string FSETTLECUR结算币别string FREALAPPLYAMOUNTFOR实际申请金额string FSETTLERATE结算汇率string FAPPLYAMOUNT申请付款金额本位币string FPURCHASERGROUPID采购组string FSALEGROUPID销售组string FIsBorrow是否其他预付string FISCARRYRATE是否下推携带汇率到结算汇率string FMoreReceive多收款人string FPRESETBASE1预设基础资料字段1string FPRESETBASE2预设基础资料字段2string FPRESETASSISTANT1预设辅助资料字段1string FPRESETASSISTANT2预设辅助资料字段2string FPRESETTEXT1预设文本字段1string FPRESETTEXT2预设文本字段2string F_JSJT_CheckBox_SFXT是否相同组织string F_JSJT_Base_DYGYS对应供应商string F_JSJT_CheckBox_GX更新按钮string F_JSJT_CheckBox_YD源单string F_JSJT_PrintTimes打印次数string FPAYAPPLYENTRY_FEntryIDFPAYAPPLYENTRY_FEntryIDstring FSETTLETYPEID结算方式string FPAYAMOUNTFOR应付金额string FEACHBANKACCOUNT对方银行账号string FAPPLYAMOUNTFOR申请付款金额string FPAYPURPOSEID付款用途string FARPURPOSEID收款用途string FSOURCETYPE源单类型string FSRCBILLNO源单编号string FENDDATE到期日string FEXPECTPAYDATE期望付款日期string FEACHCCOUNTNAME对方账户名称string FEACHBANKNAME对方开户行string FCOMMENT备注（作废）string FSRCROWID源单行内码string FRELATEPAYAMOUNT付退款关联金额string FRELATEREFUNDAMOUNT作废—收款退款关联金额string FCOSTID费用项目string FApplyPclAmount申请还本金额string FApplyInstAmount申请付利息金额string FWritePclAmount关联付利息金额string FDescription备注string FMATERIALID物料编码string FMATERIALNAME物料名称string FPURCHASEORDERNO订单号string FMATERIALSEQ订单行号string FORDERENTRYID订单明细内码string FPRICE含税单价string FQTY数量string FPRICEUNITID计价单位string FRELATEPAYQTY付(退)款关联数量string FUnpaidAmount未付款金额string FSwiftCodeSwiftCodestring FTAXAMOUNT税额string FBankDetail银行网点string FEXPENSEDEPTID费用承担部门string F_JSJT_Base_FKKH费用承担客户string F_JSJT_Base_FYCDZZ费用承担组织string F_JSJT_Base_YG员工string F_JSJT_Base_CK仓库string F_JSJT_Assistant股东string F_JSJT_Assistant1投资项目string F_JSJT_CheckBox_SFXTZZ是否相同组织string F_JSJT_Assistant2涉税公司string F_JSJT_CheckBox_SFEJBM是否二级部门string

浪潮ERP接口明细

• 接口：Voucher
• 接口名称：新增凭证-定制webService
• 接口方法：POST

请求参数

字段名称类型 BillType单据类型string Rows.DESC12预留字段文本字段12string Rows.DESC23预留金额字段3string BusinessDate业务日期string Rows.SubjectCode科目编号string Rows.DESC1预留字段文本字段1string Rows.BusinessDate业务日期string Rows.Credit-1贷方-1object Rows.VoucherRowNo凭证行Nostring Rows.BankAccountCode银行账号编号string Rows.DESC13预留字段文本字段13string VoucherID凭证idstring Rows.DESC23预留金额字段3string Rows.DESC7预留字段文本字段7string Rows.DESC24预留金额字段4string Currency币种string Rows.DESC28预留金额字段8string Rows.DESC19预留字段文本字段19string Rows.DESC9预留字段文本字段9string Rows.DESC10预留字段文本字段10string Rows.DESC3预留字段文本字段3string Rows.DESC1预留字段文本字段1string Rows.DESC12预留字段文本字段12string Rows.DESC5预留字段5string Rows.RoomCode房号编号string Abstact摘要string Direction借贷方向string Rows.DESC7预留字段文本字段7string Rows.DESC25预留金额字段5string Rows.TaxRateCode税率编号string Rows.DESC13预留字段文本字段13string Rows.DESC26预留金额字段6string Rows.InterTradItemCode内部交易项目编号string Rows.DESC29预留金额字段9string VoucherDate凭证日期string OrderNo订单号string Rows.DESC28预留金额字段8string Rows.DESC16预留字段文本字段16string Rows.OrderNo订单号string Rows.TaxRateCode税率编号string Rows.DESC2预留字段文本字段2string Rows.DESC2预留字段文本字段2string VoucherType凭证类型string Rows.DESC22预留金额字段2string Rows.ProjectCode工程项目编号string VoucherRowNo凭证行Nostring Rows.DESC6预留字段文本字段6string Rows.VoucherRowID凭证行IDstring SubjectCode科目编号string Rows.DESC18预留字段文本字段18string Rows.CashFlowCode现金流量编号string Rows.DESC4预留字段文本字段4string Rows.Currency币种string Rows.DESC20预留字段文本字段20string SourceSystemName系统名称string Rows.DESC30预留金额字段10string Rows.StaffCode人员编号string Rows.DESC8预留字段文本字段8string Rows.DESC4预留字段文本字段4string Rows.DESC21预留金额字段1string Rows.DESC27预留金额字段7string Amount金额string Rows.DESC2预留字段2string Rows.DeptmentCode部门编号string Rows.DESC24预留金额字段4string Rows.DESC11预留字段文本字段11string Rows.DESC27预留金额字段7string Rows.ContractCode合同档案编号string Rows.DeptmentCode部门编号string Rows.DESC22预留金额字段2string Rows.DESC14预留字段文本字段14string Rows.VoucherRowID行idstring Rows.CashFlowCode现金流量编号string Applier制单人string Rows.DESC26预留金额字段6string BalanceDate结算日期string Rows.DESC5预留字段文本字段5string Rows.InterTradItemCode内部交易项目编号string Rows.RelatedCompany往来单位编号string Rows.DESC17预留字段文本字段17string Rows.DESC10预留字段文本字段10string Rows.BankAccountCode银行账号编号string Rows.StaffCode人员编号string Rows.VoucherID凭证idstring Rows.DESC25预留金额字段5string Rows.DESC17预留字段文本字段17string Rows.Quantity数量string Rows.DESC1预留字段1string Rows.Amount金额string Rows.Direction借贷方向string Rows.RoomCode房号编号string Rows.DESC3预留字段3string Rows分录行array Rows.BalanceDate结算日期string Rows.DESC11预留字段文本字段11string Rows.ProjectCode工程项目编号string Rows.VoucherID凭证IDstring Rows.DESC18预留字段文本字段18string Rows.DESC15预留字段文本字段15string Rows.DESC16预留字段文本字段16string Rows.DESC9预留字段文本字段9string Rows.DESC4预留字段4string Rows.DESC3预留字段文本字段3string Rows.DESC14预留字段文本字段14string Rows.DESC30预留金额字段10string Rows.DESC6预留字段文本字段6string Rows.DESC8预留字段文本字段8string Rows.DESC29预留金额字段9string Rows.DESC21预留金额字段1string Rows.ContractCode合同档案编号string Rows.Debit-1借方-1object Rows.DESC19预留字段文本字段19string Rows.DESC5预留字段文本字段5string SourceSystemCode系统编码string VoucherCode凭证编码string Rows.Abstact摘要string Rows.DESC15预留字段文本字段15string Rows.Quantity数量string Rows.DESC20预留字段文本字段20string Rows.RelatedCompany往来单位编号string

数据对接效果

从API层面解决企业烟囱式业务系统集成现状,实现深度的业务流程拉通金蝶云星空到浪潮ERP之间数据集成；通过API连接各业务系统，复用已有的业务系统能力，让集成架构、服务关系更清晰。使用统一的API管理平台，对API进行显性化、可视化，使所有API服务成为企业的数字资产，提升复用率和价值。全面管控企业的API资产，梳理现有业务系统的API。实现API文档的统一管理，建立API的上线、下线、监控的统一管理体系及标准规范。已链接和打通主流SaaS系统超过100+，快速对接各种API接口，实现云上云下的互联互通。将SaaS和本地业务系统联接起来，打破时间与空间界限，打通原有核心数据及SaaS应用，构建可平滑演进的企业IT架构。