Qeasy Cloud
Get Started

金蝶云星空、金蝶云星空通过接口配置数据对接

1 comments

金蝶云星空、金蝶云星空通过接口配置数据对接

用友与旺店通打通

来源系统:金蝶云星空

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

对接系统：金蝶云星空

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

数据接口配置方案

数据集成平台对应的配置金蝶云星空与金蝶云星空的对接只要三步就能完成两个系统之间的数据对接。第一步根据金蝶云星空的接口参数要求记录在轻易云集成平台。第二步配置金蝶云星空与金蝶云星空之间的字段对应关系（更多方案可借鉴轻易云数据集成社区论坛中找到相关方案信息）第三步完成方案的检查参数设置：传递时间、重试次数、是否启动、前置条件等上线运行。
电商接口对接

金蝶云星空接口明细

  • 接口：ExecuteBillQuery
  • 接口名称：逐个单据查询
  • 接口方法：POST

请求参数

字段名称类型 FieldKeys需查询的字段key集合array FormId业务对象表单Idstring FilterString过滤条件string TopRowCount返回总行数int Limit最大行数string StartRow开始行索引string

响应参数

字段名称类型描述 BillNo单据编号string DocumentStatus单据状态string ProposerID_Id申请人Idstring ProposerID_Name申请人_名称string ProposerID_Number申请人编码string RequestDeptID_Id申请部门_Idstring RequestDeptID_Name申请部门名称string RequestDeptID_Number申请部门_编码string ExpenseDeptID_Id费用承担部门Idstring ExpenseDeptID_Name费用承担部门_名称string ExpenseDeptID_Number费用承担部门编码string ExchangeRate汇率string CurrencyID_Id币别_Idstring CurrencyID_Name币别名称string CurrencyID_Number币别_编码string ExchangeTypeID_Id汇率类型Idstring ExchangeTypeID_Name汇率类型_名称string ExchangeTypeID_Number汇率类型编码string CreatorId_Id创建人_Idstring CreatorId_Name创建人名称string CreatorId_Number创建人_编码string CreateDate创建日期string ModifierId_Id修改人Idstring ModifierId_Name修改人_名称string ModifierId_Number修改人编码string ModifyDate修改日期string APPROVERID_Id审核人_Idstring APPROVERID_Name审核人名称string APPROVERID_Number审核人_编码string APPROVEDATE审核日期string OrgID_Id申请组织Idstring OrgID_Name申请组织_名称string OrgID_Number申请组织编码string Date申请日期string ContactPhoneNo联系电话string BankAccountNameT账户名称string BankAccountT银行账号string ExpenseOrgId_Id费用承担组织_Idstring ExpenseOrgId_Name费用承担组织名称string ExpenseOrgId_Number费用承担组织_编码string CancellerId_Id作废人Idstring CancellerId_Name作废人_名称string CancellerId_Number作废人编码string CancelDate作废日期string CancelStatus作废状态string LocCurrencyID_Id本位币_Idstring LocCurrencyID_Name本位币名称string LocCurrencyID_Number本位币_编码string PayOrgId_Id付款组织Idstring PayOrgId_Name付款组织_名称string PayOrgId_Number付款组织编码string CONTACTUNITTYPE往来单位类型string CONTACTUNIT往来单位string BankTypeRecT_Id收款银行（作废）_Idstring BankTypeRecT_Name收款银行（作废）名称string BankTypeRecT_Number收款银行（作废）_编码string ProvinceT_Id省（作废）Idstring ProvinceT_Name省（作废）_名称string ProvinceT_Number省（作废）编码string City_Id城市（作废）_Idstring City_Name城市（作废）名称string City_Number城市（作废）_编码string DistrictT_Id地区（作废）Idstring DistrictT_Name地区（作废）_名称string DistrictT_Number地区（作废）编码string LocExpAmountSum报销金额本位币string LocReqAmountSum退/付款金额本位币string BillTypeID单据类型string BankBranchT开户银行string RequestType退款/付款string CombinedPay是否合并付款string ExpAmountSum核定报销金额汇总string ReqAmountSum核定退/付款金额汇总string OnlineBankShow通过网上银行支付string RefundBankAccount_Id银行账号_Idstring RefundBankAccount_Name银行账号名称string RefundBankAccount_Number银行账号_编码string OtherPayBillNumber下游其他应付单编码string Causa事由string ReqReimbAmountSum申请报销金额汇总string ReqPayReFoundAmountSum申请退/付款金额汇总string SplitEntry拆分行string IsCostOfOutORG费用外部承担string OUTCONTACTUNITTYPE外部往来单位类型string OUTCONTACTUNIT外部往来单位string PaySettlleTypeID_Id结算方式Idstring PaySettlleTypeID_Name结算方式_名称string PaySettlleTypeID_Number结算方式编码string FBankAddress开户行地址string FBANKCNAPS联行号string FScanPoint_Id扫描点_Idstring FScanPoint_Name扫描点名称string FScanPoint_Number扫描点_编码string FRealPay实报实付string BankDetail_Id银行网点Idstring BankDetail_Name银行网点_名称string BankDetail_Number银行网点编码string Country国别string NProvince省string NCity城市string NDistrict地区string FBUSINESSTYPE业务类型string FMultiPayee多收款人string SourceBillKey创建来源string FillByBeimAmount按报销金额填写string F_lyzx_Text发票号string ER_ExpenseReimbEntry报销明细array ER_ExpenseReimbEntry.ExpID_Id费用项目_Idstring ER_ExpenseReimbEntry.ExpID_Name费用项目名称string ER_ExpenseReimbEntry.ExpID_Number费用项目_编码string ER_ExpenseReimbEntry.InvoiceType发票类型string ER_ExpenseReimbEntry.ExpenseAmount申请报销金额string ER_ExpenseReimbEntry.TaxRate税率%string ER_ExpenseReimbEntry.TaxAmt税额string ER_ExpenseReimbEntry.TaxSubmitAmt费用金额string ER_ExpenseReimbEntry.ExpSubmitAmount核定报销金额string ER_ExpenseReimbEntry.RequestAmount申请退/付款金额string ER_ExpenseReimbEntry.ReqSubmitAmount核定退/付款金额string ER_ExpenseReimbEntry.ProductID_Id费用承担产品Idstring ER_ExpenseReimbEntry.ProductID_Name费用承担产品_名称string ER_ExpenseReimbEntry.ProductID_Number费用承担产品编码string ER_ExpenseReimbEntry.SettlleTypeID_Id结算方式_Idstring ER_ExpenseReimbEntry.SettlleTypeID_Name结算方式名称string ER_ExpenseReimbEntry.SettlleTypeID_Number结算方式_编码string ER_ExpenseReimbEntry.OnlineBank通过网上银行支付string ER_ExpenseReimbEntry.BankType_Id收款银行Idstring ER_ExpenseReimbEntry.BankType_Name收款银行_名称string ER_ExpenseReimbEntry.BankType_Number收款银行编码string ER_ExpenseReimbEntry.Province_Id省_Idstring ER_ExpenseReimbEntry.Province_Name省名称string ER_ExpenseReimbEntry.Province_Number省_编码string ER_ExpenseReimbEntry.City_Id城市Idstring ER_ExpenseReimbEntry.City_Name城市_名称string ER_ExpenseReimbEntry.City_Number城市编码string ER_ExpenseReimbEntry.District_Id地区_Idstring ER_ExpenseReimbEntry.District_Name地区名称string ER_ExpenseReimbEntry.District_Number地区_编码string ER_ExpenseReimbEntry.BankAccountName账户名称string ER_ExpenseReimbEntry.BankBranch开户银行string ER_ExpenseReimbEntry.BankAccount银行账号string ER_ExpenseReimbEntry.LocExpSubmitAmount核定报销金额本位币string ER_ExpenseReimbEntry.LocReqSubmitAmount核定金额本位币string ER_ExpenseReimbEntry.BorrowAmount冲借款金额string ER_ExpenseReimbEntry.PayedAmount已付款金额string ER_ExpenseReimbEntry.RefundedAmount已退款金额string ER_ExpenseReimbEntry.OffsetAmount冲销金额string ER_ExpenseReimbEntry.WRITTENOFFAMOUNT已核销金额string ER_ExpenseReimbEntry.WRITTENOFFSTATUS核销状态string ER_ExpenseReimbEntry.PushTFSAMOUNT已下推转移金额string ER_ExpenseReimbEntry.PushPayAmount已下推付款/退款金额string ER_ExpenseReimbEntry.SourceBillType源单类型string ER_ExpenseReimbEntry.SourceBillNo源单编号string ER_ExpenseReimbEntry.SRCBORROWAMOUNT源单可冲销金额string ER_ExpenseReimbEntry.IsFromBorrow是否来源于借款string ER_ExpenseReimbEntry.SrcOffSetAmount本次冲销源单金额string ER_ExpenseReimbEntry.SosurceRowID源单分录IDstring ER_ExpenseReimbEntry.LOCNOTAXAMOUNT不含税金额本位币string ER_ExpenseReimbEntry.LOCTAXAMOUNT税额本位币string ER_ExpenseReimbEntry.Remark备注string ER_ExpenseReimbEntry.WRITTENOFFAMOUNT_C核销关联控制string ER_ExpenseReimbEntry.TransferedAMOUNT已转移金额string ER_ExpenseReimbEntry.ReimbNotPayAmount报销未付款金额string ER_ExpenseReimbEntry.ExpenseDeptEntryID_Id费用承担部门Idstring ER_ExpenseReimbEntry.ExpenseDeptEntryID_Name费用承担部门_名称string ER_ExpenseReimbEntry.ExpenseDeptEntryID_Number费用承担部门编码string ER_ExpenseReimbEntry.PushRecAmount已下推应收金额string ER_ExpenseReimbEntry.RELRQAMOUNT关联费用申请金额string ER_ExpenseReimbEntry.ISGENINV已生成发票string ER_ExpenseReimbEntry.SRCBILLAMT源单金额string ER_ExpenseReimbEntry.AUTOMATCHAMOUNT匹配核销金额string ER_ExpenseReimbEntry.FOriginalCurrencyId_Id原币别_Idstring ER_ExpenseReimbEntry.FOriginalCurrencyId_Name原币别名称string ER_ExpenseReimbEntry.FOriginalCurrencyId_Number原币别_编码string ER_ExpenseReimbEntry.FOriginalAmount原金额string ER_ExpenseReimbEntry.FOriginalExRate付款汇率string ER_ExpenseReimbEntry.FRecInvBillNo收票单号string ER_ExpenseReimbEntry.PAYPERIOD付款期string ER_ExpenseReimbEntry.PAYDATE计划付款日期string ER_ExpenseReimbEntry.F_lyzx_Base_Id费用预算部门Idstring ER_ExpenseReimbEntry.F_lyzx_Base_Name费用预算部门_名称string ER_ExpenseReimbEntry.F_lyzx_Base_Number费用预算部门编码string ER_ExpenseReimbEntry.FEInvoiceEntity电子发票array ER_ExpenseReimbEntry.FEInvoiceEntity.TaxNumber纳税人识别号string ER_ExpenseReimbEntry.FEInvoiceEntity.CompanyName购货方名称string ER_ExpenseReimbEntry.FEInvoiceEntity.Telephone手机号码string ER_ExpenseReimbEntry.FEInvoiceEntity.SwiftNumber开票唯一流水号string ER_ExpenseReimbEntry.FEInvoiceEntity.OrderNo订单号码string ER_ExpenseReimbEntry.FEInvoiceEntity.InvoiceNumber发票号码string ER_ExpenseReimbEntry.FEInvoiceEntity.InvoiceCode发票代码string ER_ExpenseReimbEntry.FEInvoiceEntity.InvoiceRemark电子发票备注string ER_ExpenseReimbEntry.FEInvoiceEntity.InvAmount价税合计金额string ER_ExpenseReimbEntry.FEInvoiceEntity.InvCreateDate发票开票日期string ER_ExpenseReimbEntry.FEInvoiceEntity.RandomCode状态修改随机码string ER_ExpenseReimbEntry.FEInvoiceEntity.ClientIdAppIDstring ER_ExpenseReimbEntry.FEInvoiceEntity.ClientSecret秘钥string ER_ExpenseReimbEntry.FEInvoiceEntity.Status状态string ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo收票信息array ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.RecInv_Id收票单_Idstring ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.RecInv_Name收票单名称string ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.RecInv_Number收票单_编码string ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.ISFROMSRCBILL从源单携带string ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.FIVSERIALNO发票序列号string ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.FMultiPayeeEntity多收款人array ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.FMultiPayeeEntity.FPayee收款人string ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.FMultiPayeeEntity.FBankName开户银行string ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.FMultiPayeeEntity.FBankNum银行账号string ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.FMultiPayeeEntity.FBankOutlets_Id银行网点Idstring ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.FMultiPayeeEntity.FBankOutlets_Name银行网点_名称string ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.FMultiPayeeEntity.FBankOutlets_Number银行网点编码string ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.FMultiPayeeEntity.FPayeeAmount收款金额string ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.FMultiPayeeEntity.FPayeeRemark备注string ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.FMultiPayeeEntity.FSettlleType_Id支付方式_Idstring ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.FMultiPayeeEntity.FSettlleType_Name支付方式名称string ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.FMultiPayeeEntity.FSettlleType_Number支付方式_编码string ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.FMultiPayeeEntity.FSrcEntry冲借款信息array ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.FMultiPayeeEntity.FSrcEntry.FSrcBillNo借款单号string ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.FMultiPayeeEntity.FSrcEntry.FSrcStaffID_Id借款人Idstring ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.FMultiPayeeEntity.FSrcEntry.FSrcStaffID_Name借款人_名称string ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.FMultiPayeeEntity.FSrcEntry.FSrcStaffID_Number借款人_编码string ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.FMultiPayeeEntity.FSrcEntry.FTurnoverAmount借款余额string ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.FMultiPayeeEntity.FSrcEntry.FSrcWriteOffAmount冲销金额string ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.FMultiPayeeEntity.FSrcEntry.FSrcFid源单内码string ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.FMultiPayeeEntity.FSrcEntry.FSrcEntityId源单分录内码string ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.FMultiPayeeEntity.FSrcEntry.FSrcSeq源单序号string ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.FMultiPayeeEntity.FSrcEntry.FSrcFormId源单类型string ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.FMultiPayeeEntity.FSrcEntry.lyzx_Cust_Entry100024单据体array ER_ExpenseReimbEntry.FEInvoiceEntity.RecInvInfo.FMultiPayeeEntity.FSrcEntry.lyzx_Cust_Entry100024.F_lyzx_Text1发票号码string

金蝶云星空接口明细

  • 调用接口：batchSave
  • 接口名称：凭证新增
  • 方法：POST

请求参数

字段字段名称类型配置值 FBillNo凭证编号string FDocumentStatus审核状态stringZ FEntity明细arrayER_ExpenseReimbEntry FEntity.FEXPLANATION借方摘要string{{ProposerID_Name}}-{{ER_ExpenseReimbEntry.ExpID_Name}} FEntity.FACCOUNTID借方科目string6604 FEntity.FDetailID借方核算维度object FEntity.FDetailID.FFLEX4供应商string FEntity.FDetailID.FFLEX5部门string{{RequestDeptID_Number}} FEntity.FDetailID.FFLEX6客户string FEntity.FDetailID.FFLEX7员工string{{CONTACTUNIT_Number}} FEntity.FDetailID.FFLEX8物料string FEntity.FDetailID.FFLEX9费用项目stringA0101 FEntity.FDetailID.FF100002现金账号stringA0101 FEntity.FDetailID.FCURRENCYID借方币别stringPRE001 FEntity.FDetailID.FEXCHANGERATETYPE借方汇率类型stringHLTX01_SYS FEntity.FDetailID.FEXCHANGERATE借方汇率string1 FEntity.FDetailID.FDEBIT借方金额string{{ER_ExpenseReimbEntry.ExpenseAmount}} FEntity.FDetailID.FEXPLANATION-1贷方摘要string支付报销费用 FEntity.FDetailID.FACCOUNTID-1贷方科目string1001 FEntity.FDetailID.FDetailID-1贷方核算维度object FEntity.FDetailID.FDetailID-1.FFLEX4供应商string FEntity.FDetailID.FDetailID-1.FFLEX5部门string{{RequestDeptID_Number}} FEntity.FDetailID.FDetailID-1.FFLEX6客户string FEntity.FDetailID.FDetailID-1.FFLEX7员工string{{CONTACTUNIT_Number}} FEntity.FDetailID.FDetailID-1.FFLEX8物料string FEntity.FDetailID.FDetailID-1.FFLEX9费用项目stringA0101 FEntity.FDetailID.FDetailID-1.FF100002现金账号stringCASH01 FEntity.FDetailID.FDetailID-1.FCURRENCYID-1贷方币别stringPRE001 FEntity.FDetailID.FDetailID-1.FEXCHANGERATETYPE-1贷方汇率类型stringHLTX01_SYS FEntity.FDetailID.FDetailID-1.FEXCHANGERATE-1贷方汇率string1 FEntity.FDetailID.FDetailID-1.FCREDIT-1贷方金额string{{ER_ExpenseReimbEntry.ExpenseAmount}} FEntity.FormId业务对象表单IdstringGL_VOUCHER FEntity.Operation执行的操作stringBatchSave FEntity.IsAutoSubmitAndAudit提交并审核boolfalse FEntity.IsVerifyBaseDataField验证基础资料boolfalse FEntity.accountStrategyId科目基础资料查询方案stringd1a2a477-90d7-3e08-bab7-0069369ebd47

系统对接概况

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

Hot Discussions

金蝶云星空、金蝶云星空通过接口配置数据对接 | Qeasy Cloud