伯俊ERP对接外部金蝶云星空系统

接入系统：金蝶云星空

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

接入系统：伯俊ERP

未来，伯俊科技也会砥砺前行，不断为品牌提供更全面的零售终端致胜利器。伯俊科技始终坚持创新发展，探索大零售行业发力方向及突破机会，不断总结提炼当前及未来的新场景新玩法，优化升级自身体系的同时陪伴客户持续性发展。

数据对接方案

通过数据集成平台新增创建集成方案，然后在数据源平台中选择对应的源平台为：金蝶云星空，并且选择对应的连接器（关于金蝶云星空的接口连接器如何配置可以在轻易云系统数据集成交流社区bbs.qeasy.cloud 中找到相关信息）。选择对应的付款单查询接口作为数据对接来源。然后再通过写入目标平台配置目标系统为伯俊ERP，并且选择对应连接器。选择对应的修改记录接口作为数据写入动作，既可以完成第一步的数据对接配置；打破跨系统连接，让数据轻易互通成为现实。通过该系统数据集成平台的能力，可以集成的应用系统包括CRM、ERP、钉钉、企业微信、MES、飞书、用友、金蝶等 177 个不同应用系统之间的无代码接口集成，并且每周都在增加新的应用系统接入。

金蝶云星空接口明细

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

请求参数

字段字段名称类型配置值 FPAYBILLENTRY_FEntryIDFPAYBILLENTRY_FEntryIDstringFPAYBILLENTRY_FEntryID FID实体主键stringFID FBillNo单据编号stringFBillNo FDOCUMENTSTATUS单据状态stringFDOCUMENTSTATUS FCreatorId创建人stringFCreatorId FAPPROVERID审核人stringFAPPROVERID FCreateDate创建日期stringFCreateDate FSETTLEORGID结算组织stringFSETTLEORGID.FNumber FApproveDate审核日期stringFApproveDate FPURCHASEORGID采购组织stringFPURCHASEORGID.FNumber FPAYTOTALAMOUNTFOR_H表头-应付金额stringFPAYTOTALAMOUNTFOR_H FCURRENCYID币别stringFCURRENCYID.FNumber FDATE业务日期stringFDATE FModifyDate修改日期stringFModifyDate FModifierId修改人stringFModifierId FWRITTENOFFSTATUS核销状态stringFWRITTENOFFSTATUS FBillTypeID单据类型stringFBillTypeID.FNumber FPURCHASERID采购员stringFPURCHASERID.FNumber FPURCHASERGROUPID采购组stringFPURCHASERGROUPID FPURCHASEDEPTID采购部门stringFPURCHASEDEPTID.FNumber FREALPAYAMOUNTFOR_H表头-实付金额stringFREALPAYAMOUNTFOR_H FACCOUNTSYSTEM会计核算体系stringFACCOUNTSYSTEM FCancellerId作废人stringFCancellerId FCancelStatus作废状态stringFCancelStatus FCancelDate作废日期stringFCancelDate FCONTACTUNITTYPE往来单位类型stringFCONTACTUNITTYPE FCONTACTUNIT往来单位stringFCONTACTUNIT.FNumber FRECTUNITTYPE收款单位类型stringFRECTUNITTYPE FRECTUNIT收款单位stringFRECTUNIT.FNumber FSOURCESYSTEM来源系统stringFSOURCESYSTEM FBUSINESSTYPE业务类型stringFBUSINESSTYPE FISINIT是否期初单据stringFISINIT FDepartment部门stringFDepartment.FNumber FPAYORGID付款组织stringFPAYORGID.FNumber FISSAMEORG是否相同组织stringFISSAMEORG FIsCredit是否信贷业务stringFIsCredit FSETTLERATE结算汇率stringFSETTLERATE FPAYAMOUNTFOR付款金额stringFPAYAMOUNTFOR FEXCHANGETYPE汇率类型stringFEXCHANGETYPE FMAINBOOKID本位币stringFMAINBOOKID FSETTLECUR结算币别stringFSETTLECUR FPAYTOTALAMOUNT_H表头-应付金额本位币stringFPAYTOTALAMOUNT_H FPAYAMOUNT表头-付款金额本位币stringFPAYAMOUNT FREALPAYAMOUNT_H表头-实付金额本位币stringFREALPAYAMOUNT_H FEXCHANGERATE汇率stringFEXCHANGERATE FScanPoint扫描点stringFScanPoint FIsWriteOff是否转销stringFIsWriteOff FMatchMethodID核销方式stringFMatchMethodID FREALPAY实报实付stringFREALPAY FREMARK备注stringFREMARK FBookingDate期望付款日期stringFBookingDate FTHIRDBILLNO第三方单据编号stringFTHIRDBILLNO FWBSETTLENO流水号stringFWBSETTLENO FSETTLEMAINBOOKID结算本位币stringFSETTLEMAINBOOKID FSETTLEEXCHANGETYPE结算汇率类型stringFSETTLEEXCHANGETYPE FISCASHPURCHASE现购stringFISCASHPURCHASE FOUTCONTACTID转出往来单位stringFOUTCONTACTID.FNumber FOUTCONTACTTYPE转出往来单位类型stringFOUTCONTACTTYPE FIsBorrow是否其他预付stringFIsBorrow FISFROMTRADEBANK来源交易明细stringFISFROMTRADEBANK FGYACCOUNTWATERID管易财务流水内码stringFGYACCOUNTWATERID FISCARRYRATE是否下推携带汇率到结算汇率stringFISCARRYRATE FGYSHOPNAME管易对应店铺stringFGYSHOPNAME FGYCUSTOMERID管易对应客户stringFGYCUSTOMERID FMoreReceive多收款人stringFMoreReceive FPRESETASSISTANT1预设辅助资料字段1stringFPRESETASSISTANT1 FPRESETASSISTANT2预设辅助资料字段2stringFPRESETASSISTANT2 FPRESETTEXT1预设文本字段1stringFPRESETTEXT1 FPRESETTEXT2预设文本字段2stringFPRESETTEXT2 FPRESETBASE1预设基础资料字段1stringFPRESETBASE1 FPRESETBASE2预设基础资料字段2stringFPRESETBASE2 FVirIsSameAcctOrg是否同一核算组织stringFVirIsSameAcctOrg FSETTLETYPEID结算方式stringFSETTLETYPEID.FNumber FSETTLEPAYAMOUNTFOR折后金额stringFSETTLEPAYAMOUNTFOR FSETTLEDISTAMOUNTFOR现金折扣stringFSETTLEDISTAMOUNTFOR FPAYTOTALAMOUNTFOR表体-应付金额stringFPAYTOTALAMOUNTFOR FSETTLEPAYAMOUNT折后金额本位币stringFSETTLEPAYAMOUNT FSETTLEDISTAMOUNT现金折扣本位币stringFSETTLEDISTAMOUNT FPAYTOTALAMOUNT表体-应付金额本位币stringFPAYTOTALAMOUNT FWRITTENOFFSTATUS_D表体明细-核销状态stringFWRITTENOFFSTATUS_D FWRITTENOFFAMOUNTFOR_D表体明细-已核销金额stringFWRITTENOFFAMOUNTFOR_D FOPPOSITEBANKACCOUNT对方银行账号stringFOPPOSITEBANKACCOUNT FCOMMENT备注stringFCOMMENT FOPPOSITECCOUNTNAME对方账户名称stringFOPPOSITECCOUNTNAME FPAYITEM采购订单stringFPAYITEM FHANDLINGCHARGEFOR手续费stringFHANDLINGCHARGEFOR FHANDLINGCHARGE手续费本位币stringFHANDLINGCHARGE FREALPAYAMOUNTFOR_D表体-实付金额stringFREALPAYAMOUNTFOR_D FREALPAYAMOUNT_D表体-实付金额本位币stringFREALPAYAMOUNT_D FASSTOTALAMOUNTFOR关联金额stringFASSTOTALAMOUNTFOR FPAYITEMTYPE预付项目类型stringFPAYITEMTYPE FPURCHASEORDERID采购订单IDstringFPURCHASEORDERID FACCOUNTID我方银行账号stringFACCOUNTID.FNumber FPAYACCOUNTNAME我方账户名称stringFPAYACCOUNTNAME FPAYBANKID我方开户行stringFPAYBANKID FOPPOSITEBANKNAME对方开户行stringFOPPOSITEBANKNAME FSETTLENO结算号stringFSETTLENO FBLEND勾对stringFBLEND FPURPOSEID付款用途stringFPURPOSEID.FNumber FOpenAddressRec开户行地址stringFOpenAddressRec FRecType收款类型stringFRecType FCNAPS联行号stringFCNAPS FBankTypeRec收款银行（作废）stringFBankTypeRec FProvince省（作废）stringFProvince FCity城市（作废）stringFCity FDistrict地区（作废）stringFDistrict FUrgent加急stringFUrgent FSubmitStatus提交银行状态stringFSubmitStatus FSubmitUser提交/撤销银行人stringFSubmitUser FSubmitBankTime提交/撤销银行时间stringFSubmitBankTime FBankStatus银行处理状态stringFBankStatus FBankCode银行状态码stringFBankCode FINNERACCOUNTID内部账号stringFINNERACCOUNTID FINNERACCOUNTNAME内部账户名称stringFINNERACCOUNTNAME FCOSTID费用项目stringFCOSTID.FNumber FRefundAmount退款关联金额stringFRefundAmount FCashAccount现金账号stringFCashAccount FPAYAMOUNTFOR_E付款金额stringFPAYAMOUNTFOR_E FPAYAMOUNT_E付款金额本位币stringFPAYAMOUNT_E FISPOST是否登账stringFISPOST FPOSTDATE登账日期stringFPOSTDATE FMATERIALID物料编码stringFMATERIALID.FNumber FMATERIALNAME物料名称stringFMATERIALNAME FPURCHASEORDERNO采购订单号stringFPURCHASEORDERNO FMATERIALSEQ采购订单行号stringFMATERIALSEQ FORDERENTRYID采购订单明细内码stringFORDERENTRYID FRuZhangType入账类型stringFRuZhangType FEBMSG银企处理详细信息stringFEBMSG FOVERSHORTAGEFOR长短款stringFOVERSHORTAGEFOR FOVERSHORTAGE长短款本位币stringFOVERSHORTAGE FEXPENSEDEPTID_E费用承担部门stringFEXPENSEDEPTID_E FPayType支付类型stringFPayType FPRICEUNITID计价单位stringFPRICEUNITID.FNumber FPRICE含税单价stringFPRICE FQTY数量stringFQTY FREFUNDQTY退款关联数量stringFREFUNDQTY FSwiftCodeSwiftCodestringFSwiftCode FWRITTENOFFAMOUNT已核销金额本位币stringFWRITTENOFFAMOUNT FCHECKCODE流水号/对账码stringFCHECKCODE FTOPAYMENTAMOUNTFOR保证金转货款金额stringFTOPAYMENTAMOUNTFOR FTaxAmt税额stringFTaxAmt FNProvince省stringFNProvince FNCity城市stringFNCity FNDistrict地区stringFNDistrict FBankDetail银行网点stringFBankDetail FCountry国别stringFCountry FSignature签名stringFSignature FGYSALEORDERNO管易销售订单号stringFGYSALEORDERNO FReturnMsg错误码stringFReturnMsg FFinishTime付款完成时间stringFFinishTime FDistrictCode地区码stringFDistrictCode FBANKMSG银行状态描述stringFBANKMSG FResponseTme付款回调时间stringFResponseTme FRequestTime请求时间stringFRequestTime FCertType收款人证件类型stringFCertType FCertNum收款人证件号码stringFCertNum FBankInvoice银企开票stringFBankInvoice FNoteStatus电票状态stringFNoteStatus FNOTVERIFICATEAMOUNT未核销金额stringFNOTVERIFICATEAMOUNT FENTRYPREPAYORDERNO预付采购订单号stringFENTRYPREPAYORDERNO FIsInvoice已电票开票stringFIsInvoice FUnique行唯一标志stringFUnique FTransacType交易类型stringFTransacType FMessageInstruct电文指示stringFMessageInstruct FServiceLevel服务级别stringFServiceLevel FPayMethod付款方式stringFPayMethod FCNYPayMethodCNY付款方式stringFCNYPayMethod FExContractNo兑换合约号stringFExContractNo FCollectionCurr收款币别stringFCollectionCurr FCollectionAmount收款金额stringFCollectionAmount FReceiveBankBIC收款银行BICstringFReceiveBankBIC FReceiveBankCode收款银行代码stringFReceiveBankCode FReceiveBranchCode收款支行代码stringFReceiveBranchCode FServiceChargeBear手续费承担方stringFServiceChargeBear FServiceChargeNo手续费账号stringFServiceChargeNo FServiceChargeBank手续费账号银行stringFServiceChargeBank FServiceChargeCurr手续费币别stringFServiceChargeCurr FCNAPSNumCNAPSNumstringFCNAPSNum FCNYTransactType人民币交易种类stringFCNYTransactType FRMBPayMethod人民币付款方式stringFRMBPayMethod FByAgentBank通过代理行完成stringFByAgentBank FAgentBankAcnt代理行账号stringFAgentBankAcnt FAgentBankName代理行名称stringFAgentBankName FAgentBankArea代理行国家\地区stringFAgentBankArea FAgentSWIFTCodeSWIFT Code(代理行)stringFAgentSWIFTCode FAgentBankAddress代理行地址stringFAgentBankAddress FReceiveBankClear收款银行本地清算码stringFReceiveBankClear FReceiveBranchClear收款人本地清算分行代码stringFReceiveBranchClear FClearParameter清算要求参数stringFClearParameter FOtherPartyAdress对方地址stringFOtherPartyAdress FOtherPartyEmail对方邮箱stringFOtherPartyEmail FOverseaPay境外支付stringFOverseaPay FLinkRowId关联行IDstringFLinkRowId Limit最大行数string{{PAGINATION_PAGE_SIZE}} StartRow开始行索引string{{PAGINATION_START_ROW}} TopRowCount返回总行数int FilterString过滤条件stringFApproveDate>='{{LAST_SYNC_TIME dateTime}}' and FBillNo like 'PY%' and FPURPOSEID.Fnumber = 'SFKYT09_SYS' FieldKeys需查询的字段key集合array FormId业务对象表单IdstringAP_PAYBILL

响应参数

字段字段名称类型配置值 FPAYBILLENTRY_FEntryIDFPAYBILLENTRY_FEntryIDstring FID实体主键string FBillNo单据编号string FDOCUMENTSTATUS单据状态string FCreatorId创建人string FAPPROVERID审核人string FCreateDate创建日期string FSETTLEORGID结算组织string FApproveDate审核日期string FPURCHASEORGID采购组织string FPAYTOTALAMOUNTFOR_H表头-应付金额string FCURRENCYID币别string FDATE业务日期string FModifyDate修改日期string FModifierId修改人string FWRITTENOFFSTATUS核销状态string FBillTypeID单据类型string FPURCHASERID采购员string FPURCHASERGROUPID采购组string FPURCHASEDEPTID采购部门string FREALPAYAMOUNTFOR_H表头-实付金额string FACCOUNTSYSTEM会计核算体系string FCancellerId作废人string FCancelStatus作废状态string FCancelDate作废日期string FCONTACTUNITTYPE往来单位类型string FCONTACTUNIT往来单位string FRECTUNITTYPE收款单位类型string FRECTUNIT收款单位string FSOURCESYSTEM来源系统string FBUSINESSTYPE业务类型string FISINIT是否期初单据string FDepartment部门string FPAYORGID付款组织string FISSAMEORG是否相同组织string FIsCredit是否信贷业务string FSETTLERATE结算汇率string FPAYAMOUNTFOR付款金额string FEXCHANGETYPE汇率类型string FMAINBOOKID本位币string FSETTLECUR结算币别string FPAYTOTALAMOUNT_H表头-应付金额本位币string FPAYAMOUNT表头-付款金额本位币string FREALPAYAMOUNT_H表头-实付金额本位币string FEXCHANGERATE汇率string FScanPoint扫描点string FIsWriteOff是否转销string FMatchMethodID核销方式string FREALPAY实报实付string FREMARK备注string FBookingDate期望付款日期string FTHIRDBILLNO第三方单据编号string FWBSETTLENO流水号string FSETTLEMAINBOOKID结算本位币string FSETTLEEXCHANGETYPE结算汇率类型string FISCASHPURCHASE现购string FOUTCONTACTID转出往来单位string FOUTCONTACTTYPE转出往来单位类型string FIsBorrow是否其他预付string FISFROMTRADEBANK来源交易明细string FGYACCOUNTWATERID管易财务流水内码string FISCARRYRATE是否下推携带汇率到结算汇率string FGYSHOPNAME管易对应店铺string FGYCUSTOMERID管易对应客户string FMoreReceive多收款人string FPRESETASSISTANT1预设辅助资料字段1string FPRESETASSISTANT2预设辅助资料字段2string FPRESETTEXT1预设文本字段1string FPRESETTEXT2预设文本字段2string FPRESETBASE1预设基础资料字段1string FPRESETBASE2预设基础资料字段2string FVirIsSameAcctOrg是否同一核算组织string FSETTLETYPEID结算方式string FSETTLEPAYAMOUNTFOR折后金额string FSETTLEDISTAMOUNTFOR现金折扣string FPAYTOTALAMOUNTFOR表体-应付金额string FSETTLEPAYAMOUNT折后金额本位币string FSETTLEDISTAMOUNT现金折扣本位币string FPAYTOTALAMOUNT表体-应付金额本位币string FWRITTENOFFSTATUS_D表体明细-核销状态string FWRITTENOFFAMOUNTFOR_D表体明细-已核销金额string FOPPOSITEBANKACCOUNT对方银行账号string FCOMMENT备注string FOPPOSITECCOUNTNAME对方账户名称string FPAYITEM采购订单string FHANDLINGCHARGEFOR手续费string FHANDLINGCHARGE手续费本位币string FREALPAYAMOUNTFOR_D表体-实付金额string FREALPAYAMOUNT_D表体-实付金额本位币string FASSTOTALAMOUNTFOR关联金额string FPAYITEMTYPE预付项目类型string FPURCHASEORDERID采购订单IDstring FACCOUNTID我方银行账号string FPAYACCOUNTNAME我方账户名称string FPAYBANKID我方开户行string FOPPOSITEBANKNAME对方开户行string FSETTLENO结算号string FBLEND勾对string FPURPOSEID付款用途string FOpenAddressRec开户行地址string FRecType收款类型string FCNAPS联行号string FBankTypeRec收款银行（作废）string FProvince省（作废）string FCity城市（作废）string FDistrict地区（作废）string FUrgent加急string FSubmitStatus提交银行状态string FSubmitUser提交/撤销银行人string FSubmitBankTime提交/撤销银行时间string FBankStatus银行处理状态string FBankCode银行状态码string FINNERACCOUNTID内部账号string FINNERACCOUNTNAME内部账户名称string FCOSTID费用项目string FRefundAmount退款关联金额string FCashAccount现金账号string FPAYAMOUNTFOR_E付款金额string FPAYAMOUNT_E付款金额本位币string FISPOST是否登账string FPOSTDATE登账日期string FMATERIALID物料编码string FMATERIALNAME物料名称string FPURCHASEORDERNO采购订单号string FMATERIALSEQ采购订单行号string FORDERENTRYID采购订单明细内码string FRuZhangType入账类型string FEBMSG银企处理详细信息string FOVERSHORTAGEFOR长短款string FOVERSHORTAGE长短款本位币string FEXPENSEDEPTID_E费用承担部门string FPayType支付类型string FPRICEUNITID计价单位string FPRICE含税单价string FQTY数量string FREFUNDQTY退款关联数量string FSwiftCodeSwiftCodestring FWRITTENOFFAMOUNT已核销金额本位币string FCHECKCODE流水号/对账码string FTOPAYMENTAMOUNTFOR保证金转货款金额string FTaxAmt税额string FNProvince省string FNCity城市string FNDistrict地区string FBankDetail银行网点string FCountry国别string FSignature签名string FGYSALEORDERNO管易销售订单号string FReturnMsg错误码string FFinishTime付款完成时间string FDistrictCode地区码string FBANKMSG银行状态描述string FResponseTme付款回调时间string FRequestTime请求时间string FCertType收款人证件类型string FCertNum收款人证件号码string FBankInvoice银企开票string FNoteStatus电票状态string FNOTVERIFICATEAMOUNT未核销金额string FENTRYPREPAYORDERNO预付采购订单号string FIsInvoice已电票开票string FUnique行唯一标志string FTransacType交易类型string FMessageInstruct电文指示string FServiceLevel服务级别string FPayMethod付款方式string FCNYPayMethodCNY付款方式string FExContractNo兑换合约号string FCollectionCurr收款币别string FCollectionAmount收款金额string FReceiveBankBIC收款银行BICstring FReceiveBankCode收款银行代码string FReceiveBranchCode收款支行代码string FServiceChargeBear手续费承担方string FServiceChargeNo手续费账号string FServiceChargeBank手续费账号银行string FServiceChargeCurr手续费币别string FCNAPSNumCNAPSNumstring FCNYTransactType人民币交易种类string FRMBPayMethod人民币付款方式string FByAgentBank通过代理行完成string FAgentBankAcnt代理行账号string FAgentBankName代理行名称string FAgentBankArea代理行国家\地区string FAgentSWIFTCodeSWIFT Code(代理行)string FAgentBankAddress代理行地址string FReceiveBankClear收款银行本地清算码string FReceiveBranchClear收款人本地清算分行代码string FClearParameter清算要求参数string FOtherPartyAdress对方地址string FOtherPartyEmail对方邮箱string FOverseaPay境外支付string FLinkRowId关联行IDstring

伯俊ERP接口明细

调用接口：/rest/excute
接口名称：修改记录
方法：POST

请求参数

字段字段名称类型配置值 table表名string25705 ID主键IDstring_findCollection find ID from 78b640d2-573e-3d98-b3d2-6bb2f4e160d9 where DOCNO={{FBillNo}} _endfind partial_update是否部分更新stringtrue EDIFLAG接口标记string99 command操作命令stringObjectModify

系统数据集成价值

数据集成中台设计中心Web界面以“拖拽”式交互设计，使用鼠标即可构建设计多异构系统数据集成流程，低代码平台大大降低流程设计者上手门槛。还有丰富的组件库快速满足复杂业务需求，结合不同模块即可生成不同业务流程，提升流程设计效率。平台支持多种高度灵活部署，高并发、高性能、高可用，可以通过多节点组成集群实现性能的横向扩展。适度集群配置其数据集成处理能力可达GB级/秒，为业务流提供更高数据吞吐量。平台已集成数据回压、优先级队列等能力，保障运行稳定性。完善的企业API运营管理机制帮助您构建“API生产者、API管理者、API消费者”三者结合的统一API数字化生态。支持市面上主流厂家软件如：金蝶、用友、SAP、泛微、蓝凌、旺店通、聚水潭、马帮、小满CRM等等。

伯俊ERP对接外部金蝶云星空系统