和小青GPT助理聊天吧

小青是一位基于大语言预训练模型的超级智能AI,熟悉轻易云产品并能为您提供多种数据集成方案和技术支持。您在使用轻易云产品时遇到问题或有关技术咨询,小青都将为您提供专业、即时、高效的帮助和建议。与小青智能对话,您可享受同人类互动一样的使用体验,全面了解最新产品更新、功能特性及相关技术资讯,进一步提升您在数据集成领域的实力。小青是您友好、智能、便捷的助手,与她互动让您的数据集成之路轻松愉快。
轻易云自训练大语言模型小青助理
扫码关注公众号即可开始聊天

系统数据集成方案

金蝶云星空与金蝶云星空对接集成逐个单据查询打通凭证新增

吉客云系统对接ERP

接通系统:金蝶云星空

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

对接系统:金蝶云星空

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

多系统对接方案配置

使用轻易云系统数据集成平台对应的模块:数据集成方案。然后选择开始创建数据集成方案。在方案配置表单中选择对应的源业务系统:金蝶云星空,然后选择对应的连接器。选择对应的逐个单据查询作为数据对接来源。然后再通过写入目标平台配置目标系统为金蝶云星空,并且选择对应连接器(关于金蝶云星空的接口如何配置可以在轻易云数据集成社区论坛中找到相关信息,选择好对应的凭证新增接口作为数据写入动作,既可以完成第一步的数据对接配置。

用友数据打通

金蝶云星空接口明细

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

请求参数

字段名称类型描述
Limit最大行数string金蝶的查询分页参数
StartRow开始行索引string金蝶的查询分页参数
TopRowCount返回总行数int金蝶的查询分页参数
FilterString过滤条件string示例写法 FSupplierId.FNumber = 'VEN00010' and FApproveDate>=
FieldKeys需查询的字段key集合array金蝶分录主键ID格式:FPOOrderEntry_FEntryId,其它格式 FPurchaseOrgId.FNumber
FormId业务对象表单Idstring必须填写金蝶的表单ID如:PUR_PurchaseOrder

响应参数

字段名称类型描述
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
NProvincestring
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审核状态string
FEntity明细array
FEntity.FEXPLANATION借方摘要string
FEntity.FACCOUNTID借方科目string
FEntity.FDetailID借方核算维度object
FEntity.FDetailID.FFLEX4供应商string
FEntity.FDetailID.FFLEX5部门string
FEntity.FDetailID.FFLEX6客户string
FEntity.FDetailID.FFLEX7员工string
FEntity.FDetailID.FFLEX8物料string
FEntity.FDetailID.FFLEX9费用项目string
FEntity.FDetailID.FF100002现金账号string
FEntity.FDetailID.FCURRENCYID借方币别string
FEntity.FDetailID.FEXCHANGERATETYPE借方汇率类型string
FEntity.FDetailID.FEXCHANGERATE借方汇率string
FEntity.FDetailID.FDEBIT借方金额string
FEntity.FDetailID.FEXPLANATION-1贷方摘要string
FEntity.FDetailID.FACCOUNTID-1贷方科目string
FEntity.FDetailID.FDetailID-1贷方核算维度object
FEntity.FDetailID.FDetailID-1.FFLEX4供应商string
FEntity.FDetailID.FDetailID-1.FFLEX5部门string
FEntity.FDetailID.FDetailID-1.FFLEX6客户string
FEntity.FDetailID.FDetailID-1.FFLEX7员工string
FEntity.FDetailID.FDetailID-1.FFLEX8物料string
FEntity.FDetailID.FDetailID-1.FFLEX9费用项目string
FEntity.FDetailID.FDetailID-1.FF100002现金账号string
FEntity.FDetailID.FDetailID-1.FCURRENCYID-1贷方币别string
FEntity.FDetailID.FDetailID-1.FEXCHANGERATETYPE-1贷方汇率类型string
FEntity.FDetailID.FDetailID-1.FEXCHANGERATE-1贷方汇率string
FEntity.FDetailID.FDetailID-1.FCREDIT-1贷方金额string
FEntity.FormId业务对象表单Idstring必须填写金蝶的表单ID如:PUR_PurchaseOrder
FEntity.Operation执行的操作string
FEntity.IsAutoSubmitAndAudit提交并审核bool
FEntity.IsVerifyBaseDataField验证基础资料bool是否验证所有的基础资料有效性,布尔类,默认false(非必录)
FEntity.accountStrategyId科目基础资料查询方案string

系统打通概况

基于轻易云的连接器和数据服务能力,轻松实现供应链异构系统的“相互沟通”,通过数据应用自动化业务流程管理,全面管控供应链的每一环节。从要货、销售出库、退货入库、到盘点、调拨,无需人工参与,实时更新,自动化流转。通过快速连接金蝶云星空接口抽取数据后再自动分发到金蝶云星空, 解放生产力,自动生成数据、并分发推送到业务应用,数据传递时效性提升10倍以上。

系统接口对接

系统数据对接方案元数据代码