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

对接源平台:金蝶云星空

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

目标系统:金蝶云星空

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

数据接口配置

通过可视化界面的拖、拉、拽即可轻松快速构建数据集成流程，将金蝶云星空、金蝶云星空之间接口数据联通，支持数据在线预览、数据集成流程全过程调试，Web界面追踪调试日志等功能。平台兼具实时数据处理和数据集成分发功能，用户通过可视化的拖、拽即可完成数据处理逻辑，将数据加工处理后分发到下游业务系统或其他异构存储中。

金蝶云星空接口明细

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

请求参数

字段字段名称类型配置值 Limit最大行数string{{PAGINATION_PAGE_SIZE}} StartRow开始行索引string{{PAGINATION_START_ROW}} TopRowCount返回总行数int FilterString过滤条件stringFApproveDate>='{{LAST_SYNC_TIME dateTime}}' FieldKeys需查询的字段key集合array FormId业务对象表单IdstringER_ExpReimbursement

响应参数

字段字段名称类型配置值 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科目基础资料查询方案stringb64cf235-0e1f-3a72-beba-3a9d0b6d5b85

系统数据对接

通过无代码的数据集成与数据建模的智能数据管道技术，帮助企业将所有应用程序、数据库、事件和文件等数据信息提取到数据仓库中，并快速将分散的数据转化为数据集、API、自动化流程等开箱即用的数据服务。配置接口的模式对接金蝶云星空和金蝶云星空，使得单据无缝互通。打造企业内部数据一体化，让企业日常运营管理实现敏捷数据化运营。实现供应链业务信息流的互通，同时支持供应链数据分析流程自动化，结果推送，推进相关供应链问题优化。及时打通供应链孤岛，实现数据驱动供应链协同，进一步提升企业竞争力。

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