金蝶云星空与金蝶云星空对接集成付款退款单查询连通付款退款单新增(付款退款单test)

金蝶云星空与金蝶云星空对接集成付款退款单查询连通付款退款单新增(付款退款单test)

接入系统：金蝶云星空

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

接通系统：金蝶云星空

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

多系统对接方案配置

集成方案是整个轻易云集成平台的核心，每一个集成方案代表一种业务的对接策略（对接方案借鉴可以在轻易云系统数据集成交流社区bbs.qeasy.cloud 中找到相关信息），用户可以根据业务的不同新建多个不同规则的集成方案。比如：采购订单同步，线上销售出库同步，线下销售出库同步。一个集成方案必须要配置源系统：金蝶云星空，源系统 API：付款退款单查询，目标系统：金蝶云星空，目标系统 API付款退款单新增。在新增集成方案之前需要确定两个系统的连接器都已经配置完成。系统数据集成平台更加专注于数据集成与流程自动化的应用连接器，通过自研引擎，与各个平台或者服务完成对接，从而打通数据孤岛，实现数据的跨系统自由流转，让数据真正成为企业的核心生产力。

金蝶云星空接口明细

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

请求参数

字段字段名称类型配置值 FAFTTAXTOTALAMOUNT应退金额stringFAFTTAXTOTALAMOUNT FID实体主键stringFID FSRCSETTLETYPEID结算方式stringFSRCSETTLETYPEID FBillNo单据编号stringFBillNo FDOCUMENTSTATUS单据状态stringFDOCUMENTSTATUS FREALREFUNDAMOUNT_S本次退款金额stringFREALREFUNDAMOUNT_S FCreaterId创建人stringFCreaterId FSRCBILLID源单内码stringFSRCBILLID FSRCROWID源单行内码stringFSRCROWID FCreateDate创建日期stringFCreateDate FSRCSEQ源单行号stringFSRCSEQ FSETTLEORGID结算组织stringFSETTLEORGID.FNumber FApproveDate审核日期stringFApproveDate FPLANREFUNDAMOUNT计划退款金额stringFPLANREFUNDAMOUNT FPURCHASEORGID采购组织stringFPURCHASEORGID.FNumber FSRCCURRENCYID源单结算币别stringFSRCCURRENCYID.FNumber FSOURCETYPE源单类型stringFSOURCETYPE FEXCHANGETYPE汇率类型stringFEXCHANGETYPE FSRCBILLNO源单编号stringFSRCBILLNO FMAINBOOKCURRID本位币stringFMAINBOOKCURRID FEXPIRY到期日stringFEXPIRY FREFUNDTOTALAMOUNT应退金额本位币stringFREFUNDTOTALAMOUNT FPAYPURPOSEID付款用途stringFPAYPURPOSEID.FNumber FDATE业务日期stringFDATE FSRCMATERIALID物料编码stringFSRCMATERIALID.FNumber FCURRENCYID币别stringFCURRENCYID.FNumber FModifyDate修改日期stringFModifyDate FSRCPURCHASEORDERNO采购订单号stringFSRCPURCHASEORDERNO FModifierId修改人stringFModifierId FEXCHANGERATE汇率stringFEXCHANGERATE FSRCMATERIALSEQ采购订单行号stringFSRCMATERIALSEQ FWRITTENOFFSTATUS核销状态stringFWRITTENOFFSTATUS FSRCORDERENTRYID采购订单明细内码stringFSRCORDERENTRYID FSRCPRICEUNITID计价单位stringFSRCPRICEUNITID FBillTypeID单据类型stringFBillTypeID.FNumber FSRCPRICE含税单价stringFSRCPRICE FREFUNDTOTALAMOUNTFOR表头-应退金额stringFREFUNDTOTALAMOUNTFOR FPurchaserId采购员stringFPurchaserId FSRCQTY数量stringFSRCQTY FEXPENSEDEPTID费用承担部门stringFEXPENSEDEPTID.FNumber FPurchaserGroupId采购组stringFPurchaserGroupId FExpID费用项目stringFExpID FPurchaseDeptId采购部门stringFPurchaseDeptId FAPPROVERID审核人stringFAPPROVERID FTaxAmt税额stringFTaxAmt FPREPAYORDERNO预付采购订单号stringFPREPAYORDERNO FREALREFUNDAMOUNTFOR表头-实退金额stringFREALREFUNDAMOUNTFOR FREALREFUNDAMOUNTMB本次退款金额本位币stringFREALREFUNDAMOUNTMB FREALREFUNDAMOUNT实退金额本位币stringFREALREFUNDAMOUNT FSETTLEAMOUNT结算金额stringFSETTLEAMOUNT FACCOUNTSYSTEM会计核算体系stringFACCOUNTSYSTEM FCancellerId作废人stringFCancellerId FCancelStatus作废状态stringFCancelStatus FCancelDate作废日期stringFCancelDate FCONTACTUNITTYPE往来单位类型stringFCONTACTUNITTYPE FCONTACTUNIT往来单位stringFCONTACTUNIT.FNumber FPAYUNITTYPE付款单位类型stringFPAYUNITTYPE FPAYUNIT付款单位stringFPAYUNIT.FNumber FSOURCESYSTEM来源系统stringFSOURCESYSTEM FBUSINESSTYPE业务类型stringFBUSINESSTYPE FISINIT是否期初单据stringFISINIT FDepartment部门stringFDepartment.FNumber FPAYORGID付款组织stringFPAYORGID.FNumber FISSAMEORG是否相同组织stringFISSAMEORG FSETTLECUR结算币别stringFSETTLECUR FSETTLERATE结算汇率stringFSETTLERATE FREFUNDAMOUNTFOR_H退款金额stringFREFUNDAMOUNTFOR_H FREFUNDAMOUNT_H表头-退款金额本位币stringFREFUNDAMOUNT_H FIsWriteOff是否转销stringFIsWriteOff FMatchMethodID核销方式stringFMatchMethodID FScanPoint扫描点stringFScanPoint FISFROMALLREFUND是否来源于整单退款stringFISFROMALLREFUND FREMARK备注stringFREMARK FSETTLEMAINBOOKID结算本位币stringFSETTLEMAINBOOKID.FNumber FSETTLEEXCHANGETYPE结算汇率类型stringFSETTLEEXCHANGETYPE FTHIRDBILLNO第三方单据编号stringFTHIRDBILLNO FWBSETTLENO流水号stringFWBSETTLENO FGYACCOUNTWATERID管易财务流水内码stringFGYACCOUNTWATERID FISCARRYRATE是否下推携带汇率到结算汇率stringFISCARRYRATE FGYSHOPNAME管易对应店铺stringFGYSHOPNAME FGYCUSTOMERID管易对应客户stringFGYCUSTOMERID FPRESETBASE1预设基础资料字段1stringFPRESETBASE1 FPRESETBASE2预设基础资料字段2stringFPRESETBASE2 FPRESETASSISTANT1预设辅助资料字段1stringFPRESETASSISTANT1 FPRESETASSISTANT2预设辅助资料字段2stringFPRESETASSISTANT2 FPRESETTEXT1预设文本字段1stringFPRESETTEXT1 FPRESETTEXT2预设文本字段2stringFPRESETTEXT2 FSETTLETYPEID结算方式stringFSETTLETYPEID.FNumber FREFUNDAMOUNTFOR表体-应退金额stringFREFUNDAMOUNTFOR FNOTE备注stringFNOTE FWRITTENOFFSTATUS_D表体明细-核销状态stringFWRITTENOFFSTATUS_D FWRITTENOFFAMOUNTFOR_D表体明细-已核销金额stringFWRITTENOFFAMOUNTFOR_D FOPPOSITECCOUNTNAME对方账户名称stringFOPPOSITECCOUNTNAME FOPPOSITEBANKACCOUNT对方银行账号stringFOPPOSITEBANKACCOUNT FREFUNDAMOUNT应退金额本位币stringFREFUNDAMOUNT FHANDLINGCHARGEFOR手续费stringFHANDLINGCHARGEFOR FREALREFUNDAMOUNTFOR_D表体-实退金额stringFREALREFUNDAMOUNTFOR_D FHANDLINGCHARGE手续费本位币stringFHANDLINGCHARGE FREALREFUNDAMOUNT_D实退金额本位币stringFREALREFUNDAMOUNT_D FACCOUNTID我方银行账号stringFACCOUNTID.FNumber FACCOUNTNAME我方账户名称stringFACCOUNTNAME FSETTLENO结算号stringFSETTLENO FBLEND勾对stringFBLEND FOPPOSITEBANKNAME对方开户行stringFOPPOSITEBANKNAME FPURPOSEID原付款用途stringFPURPOSEID FINNERACCOUNTID内部账号stringFINNERACCOUNTID FINNERACCOUNTNAME内部账户名称stringFINNERACCOUNTNAME FCOSTID费用项目stringFCOSTID.FNumber FCashAccount现金账号stringFCashAccount FREFUNDAMOUNTFOR_E退款金额stringFREFUNDAMOUNTFOR_E FREFUNDAMOUNT_E退款金额本位币stringFREFUNDAMOUNT_E FPOSTDATE登账日期stringFPOSTDATE FISPOST是否登账stringFISPOST FPURCHASEORDERNO采购订单号stringFPURCHASEORDERNO FPURCHASEORDERID采购订单内码stringFPURCHASEORDERID FMATERIALID物料编码stringFMATERIALID.FNumber FMATERIALSEQ采购订单行号stringFMATERIALSEQ FORDERENTRYID采购订单明细内码stringFORDERENTRYID FPURCHASEORDERNUMBER采购订单编号stringFPURCHASEORDERNUMBER FPRICEUNITID计价单位stringFPRICEUNITID FPRICE含税单价stringFPRICE FQTY数量stringFQTY FWRITTENOFFAMOUNT已核销金额本位币stringFWRITTENOFFAMOUNT FGYSALEORDERNO管易销售订单号stringFGYSALEORDERNO FNOTVERIFICATEAMOUNT未核销金额stringFNOTVERIFICATEAMOUNT FEXPENSEDEPTID_E费用承担部门stringFEXPENSEDEPTID_E FREFUNDBILLENTRY_FEntryIDFREFUNDBILLENTRY_FEntryIDstringFREFUNDBILLENTRY_FEntryID Limit最大行数string{{PAGINATION_PAGE_SIZE}} StartRow开始行索引string{{PAGINATION_START_ROW}} TopRowCount返回总行数int FilterString过滤条件stringFApproveDate>='{{LAST_SYNC_TIME dateTime}}' FieldKeys需查询的字段key集合array FormId业务对象表单IdstringAP_REFUNDBILL

响应参数

字段字段名称类型配置值 FAFTTAXTOTALAMOUNT应退金额string FID实体主键string FSRCSETTLETYPEID结算方式string FBillNo单据编号string FREALREFUNDAMOUNT_S本次退款金额string FDOCUMENTSTATUS单据状态string FSRCBILLID源单内码string FCreaterId创建人string FCreateDate创建日期string FSRCROWID源单行内码string FSETTLEORGID结算组织string FSRCSEQ源单行号string FPLANREFUNDAMOUNT计划退款金额string FApproveDate审核日期string FPURCHASEORGID采购组织string FSRCCURRENCYID源单结算币别string FEXCHANGETYPE汇率类型string FSOURCETYPE源单类型string FMAINBOOKCURRID本位币string FSRCBILLNO源单编号string FREFUNDTOTALAMOUNT应退金额本位币string FEXPIRY到期日string FDATE业务日期string FPAYPURPOSEID付款用途string FSRCMATERIALID物料编码string FCURRENCYID币别string FModifyDate修改日期string FModifierId修改人string FSRCPURCHASEORDERNO采购订单号string FEXCHANGERATE汇率string FSRCMATERIALSEQ采购订单行号string FWRITTENOFFSTATUS核销状态string FSRCORDERENTRYID采购订单明细内码string FBillTypeID单据类型string FSRCPRICEUNITID计价单位string FSRCPRICE含税单价string FREFUNDTOTALAMOUNTFOR表头-应退金额string FPurchaserId采购员string FSRCQTY数量string FPurchaserGroupId采购组string FEXPENSEDEPTID费用承担部门string FExpID费用项目string FPurchaseDeptId采购部门string FAPPROVERID审核人string FTaxAmt税额string FPREPAYORDERNO预付采购订单号string FREALREFUNDAMOUNTFOR表头-实退金额string FREALREFUNDAMOUNT实退金额本位币string FREALREFUNDAMOUNTMB本次退款金额本位币string FSETTLEAMOUNT结算金额string FACCOUNTSYSTEM会计核算体系string FCancellerId作废人string FCancelStatus作废状态string FCancelDate作废日期string FCONTACTUNITTYPE往来单位类型string FCONTACTUNIT往来单位string FPAYUNITTYPE付款单位类型string FPAYUNIT付款单位string FSOURCESYSTEM来源系统string FBUSINESSTYPE业务类型string FISINIT是否期初单据string FDepartment部门string FPAYORGID付款组织string FISSAMEORG是否相同组织string FSETTLECUR结算币别string FSETTLERATE结算汇率string FREFUNDAMOUNTFOR_H退款金额string FREFUNDAMOUNT_H表头-退款金额本位币string FIsWriteOff是否转销string FMatchMethodID核销方式string FScanPoint扫描点string FISFROMALLREFUND是否来源于整单退款string FREMARK备注string FSETTLEMAINBOOKID结算本位币string FSETTLEEXCHANGETYPE结算汇率类型string FTHIRDBILLNO第三方单据编号string FWBSETTLENO流水号string FGYACCOUNTWATERID管易财务流水内码string FISCARRYRATE是否下推携带汇率到结算汇率string FGYSHOPNAME管易对应店铺string FGYCUSTOMERID管易对应客户string FPRESETBASE1预设基础资料字段1string FPRESETBASE2预设基础资料字段2string FPRESETASSISTANT1预设辅助资料字段1string FPRESETASSISTANT2预设辅助资料字段2string FPRESETTEXT1预设文本字段1string FPRESETTEXT2预设文本字段2string FSETTLETYPEID结算方式string FREFUNDAMOUNTFOR表体-应退金额string FNOTE备注string FWRITTENOFFSTATUS_D表体明细-核销状态string FWRITTENOFFAMOUNTFOR_D表体明细-已核销金额string FOPPOSITECCOUNTNAME对方账户名称string FOPPOSITEBANKACCOUNT对方银行账号string FREFUNDAMOUNT应退金额本位币string FHANDLINGCHARGEFOR手续费string FREALREFUNDAMOUNTFOR_D表体-实退金额string FHANDLINGCHARGE手续费本位币string FREALREFUNDAMOUNT_D实退金额本位币string FACCOUNTID我方银行账号string FACCOUNTNAME我方账户名称string FSETTLENO结算号string FBLEND勾对string FOPPOSITEBANKNAME对方开户行string FPURPOSEID原付款用途string FINNERACCOUNTID内部账号string FINNERACCOUNTNAME内部账户名称string FCOSTID费用项目string FCashAccount现金账号string FREFUNDAMOUNTFOR_E退款金额string FREFUNDAMOUNT_E退款金额本位币string FPOSTDATE登账日期string FISPOST是否登账string FPURCHASEORDERNO采购订单号string FPURCHASEORDERID采购订单内码string FMATERIALID物料编码string FMATERIALSEQ采购订单行号string FORDERENTRYID采购订单明细内码string FPURCHASEORDERNUMBER采购订单编号string FPRICEUNITID计价单位string FPRICE含税单价string FQTY数量string FWRITTENOFFAMOUNT已核销金额本位币string FGYSALEORDERNO管易销售订单号string FNOTVERIFICATEAMOUNT未核销金额string FEXPENSEDEPTID_E费用承担部门string FREFUNDBILLENTRY_FEntryIDFREFUNDBILLENTRY_FEntryIDstring

金蝶云星空接口明细

• 调用接口：batchSave
• 接口名称：付款退款单新增
• 方法：POST

请求参数

字段字段名称类型配置值 FBillNo单据编号string{{id}} FSETTLEORGID结算组织string100 FApproveDate审核日期string_function FROM_UNIXTIME( ( {{expenseDate}} / 1000 ) ,'%Y-%m-%d %H:%i:%S' ) FDATE业务日期string{{FSRCROWID}} FCURRENCYID币别stringPRE001 FBillTypeID单据类型stringFKTKDLX02_SYS FCONTACTUNITTYPE往来单位类型stringBD_Department FCONTACTUNIT往来单位stringBM000001 FPAYUNITTYPE付款单位类型stringBD_Department FPAYUNIT付款单位stringBM000001 FBUSINESSTYPE业务类型string3 FDepartment部门string FPAYORGID付款组织string100 FSETTLECUR结算币别stringPRE001 FREMARK备注string测试单据 FREFUNDBILLENTRY退款单明细array FREFUNDBILLENTRY.FSETTLETYPEID结算方式stringJSFS01_SYS FREFUNDBILLENTRY.FNOTE备注string FREFUNDBILLENTRY.FACCOUNTID我方银行账号string FREFUNDBILLENTRY.FPURPOSEID原付款用途stringSFKYT11_SYS FREFUNDBILLENTRY.FCOSTID费用项目string{{FCOSTID}} FREFUNDBILLENTRY.FCashAccount现金账号string FREFUNDBILLENTRY.FEXPENSEDEPTID_E费用承担部门string{{FEXPENSEDEPTID_E}} FREFUNDBILLENTRY.FREFUNDAMOUNTFOR表体-应退金额string250 FREFUNDBILLENTRY.FormId业务对象表单IdstringAP_REFUNDBILL FREFUNDBILLENTRY.Operation执行的操作stringBatchSave FREFUNDBILLENTRY.IsAutoSubmitAndAudit提交并审核booltrue FREFUNDBILLENTRY.IsVerifyBaseDataField验证基础资料boolfalse

数据对接价值

全面管控企业的API资产，梳理现有业务系统的API。实现API文档的统一管理，建立API的上线、下线、监控的统一管理体系。API低代码开发平台能够实现低代码或零代码一键发布API服务，很好地解决企业用户上面的问题。轻易云应用集成主要解决已有应用系统的无序蔓延现象，减少各业务系统间的维护成本，减少各应用系统的操作系统、开发语言、访问协议、通信技术多而杂、整合难度大的问题，将企业数据平滑对接，减少信息竖井。