从金蝶云星空到植隆业务中台通过接口配置打通数据

对接源平台:金蝶云星空

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

对接目标系统:植隆业务中台

上海植隆自研业务中台将企业的核心能力以数字化形式沉淀为各种服务中心，其目的是“提供企业能够快速，低成本创新的能力”。业务中台的核心是“构建企业共享服务中心”，其过程是通过业务板块之间的链接和协同，持续提升业务创新效率，确保关键业务链路的稳定高效和经济性兼顾的思想体系，并突出组织和业务机制。业务中台也包含技术和组织两大部分，通过“方法+工具+业务理解”加以实现。

配置集成方案

集成方案是整个轻易云集成平台的核心，每一个集成方案代表一种业务的对接策略（对接方案借鉴可以在轻易云系统数据集成交流社区bbs.qeasy.cloud 中找到相关信息），用户可以根据业务的不同新建多个不同规则的集成方案。比如：采购订单同步，线上销售出库同步，线下销售出库同步。一个集成方案必须要配置源系统：金蝶云星空，源系统 API：逐个单据查询，目标系统：植隆业务中台，目标系统 API工单状态更新接口。在新增集成方案之前需要确定两个系统的连接器都已经配置完成。

金蝶云星空接口明细

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

请求参数

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

响应参数

字段字段名称类型配置值 BillNo单据编号string DOCUMENTSTATUS单据状态string DATE业务日期string CURRENCYID_Id币别Idstring CURRENCYID_Name币别_名称string CURRENCYID_Number币别编码string BILLINGWAY开票方式string INVOICENO发票号string INVOICEDATE发票日期string SETTLEORGID_Id结算组织_Idstring SETTLEORGID_Name结算组织名称string SETTLEORGID_Number结算组织_编码string SALEORGID_Id销售组织Idstring SALEORGID_Name销售组织_名称string SALEORGID_Number销售组织编码string SALEDEPTID_Id销售部门_Idstring SALEDEPTID_Name销售部门名称string SALEDEPTID_Number销售部门_编码string FSALEGROUPID_Id销售组Idstring FSALEGROUPID_Name销售组_名称string FSALEGROUPID_Number销售组编码string OPENSTATUS表头基本-开票核销状态string SETTLETYPEID_Id结算方式_Idstring SETTLETYPEID_Name结算方式名称string SETTLETYPEID_Number结算方式_编码string EXCHANGERATE汇率string EXCHANGETYPE_Id汇率类型Idstring EXCHANGETYPE_Name汇率类型_名称string EXCHANGETYPE_Number汇率类型编码string MAINBOOKSTDCURRID_Id本位币_Idstring MAINBOOKSTDCURRID_Name本位币名称string MAINBOOKSTDCURRID_Number本位币_编码string HEADAUXPRICEFOR不含税金额string TAXAMOUNTFOR税额string AFTERTOTALTAXFOR价税合计string TAXAMOUNT税额本位币string AFTERTOTALTAX价税合计本位币string HEADAUXPRICE不含税金额本位币string FModifyDate修改日期string FCreateDate创建日期string APPROVERID_Id审核人Idstring APPROVERID_Name审核人_名称string APPROVERID_Number审核人编码string FCREATORID_Id创建人_Idstring FCREATORID_Name创建人名称string FCREATORID_Number创建人_编码string ApproveDate审核日期string ModifierId_Id修改人Idstring ModifierId_Name修改人_名称string ModifierId_Number修改人编码string FSALEERID_Id销售员_Idstring FSALEERID_Name销售员名称string FSALEERID_Number销售员_编码string CUSTOMERID_Id客户Idstring CUSTOMERID_Name客户_名称string CUSTOMERID_Number客户编码string BillTypeID单据类型string ACCOUNTSYSTEM_Id会计核算体系_Idstring ACCOUNTSYSTEM_Name会计核算体系名称string ACCOUNTSYSTEM_Number会计核算体系_编码string ISTAX按含税单价录入string CancellerId_Id作废人Idstring CancellerId_Name作废人_名称string CancellerId_Number作废人编码string CancelStatus作废状态string CancelDate作废日期string REDBLUE红蓝字string FEXPORTCOUNT金税引出次数string FGenType发票生成方式string FSerialNumber开票流水号string FElectronicStatus税控状态（已弃用）string INVOICETITLE发票抬头string TAXREGISTERCODE纳税人识别号string ISB2CB2C业务string OPENBANKNAME开户银行string BANKCODE银行账号string TEL联系电话string ADDRESS通讯地址string IVCODE发票代码string SOURCEIVCODE原发票代码string IVNUMBER发票号码string SOURCEIVNUMBER原发票号码string GTSTATUS开票状态string GTPRINTCOUNT打印次数string GTPRINTLISTCOUNT打印清单次数string HAVEIVLIST清单标识string SOURCESERIALNUM原开票流水号string FSrcSetAccountType源单立账类型string PAYEE收款人string DRAWER开票人string REVIEWER复核人string GTDISKNUMBER金税盘机号string IVCUSTOMERID_Id开票客户_Idstring IVCUSTOMERID_Name开票客户名称string IVCUSTOMERID_Number开票客户_编码string GetCostLastedDate获取成本时间string COSTCALDATE获取到的成本核算时间string FISHookMatch不参与开票核销string FScanPoint_Id扫描点Idstring FScanPoint_Name扫描点_名称string FScanPoint_Number扫描点编码string FARCHIVENO归档号string INFOTABLENUMBER信息表编号string CHECKCODE校验码string FPDFURLCOPY电子发票地址string FWBOPENQTY反写开票数量string FSRCBUSINESSTYPE源单业务类型string F_ZHHB_Assistant核销业务类型string F_ZHHB_Combo客户类型/开票对象string F_ZHHB_Combo1开票方式string F_ZHHB_Combo4寄送方式string F_ZHHB_Combo2发票申请类型string F_ZHHB_Combo3发票分类string F_ZHHBout_type外部业务类型string F_ZHHB__out_id外部IDstring F_ZHHB__out_no外部编码string F_ZHHB_Text8入账公司名称string F_ZHHB_Text9代理商名称string F_ZHHB_Text7入账公司编码string F_ZHHB_Text13收件人姓名string F_ZHHB_Text14收件人地址string F_ZHHB_Text10邮箱string F_ZHHB_Text11收件人备注string F_ZHHB_Text12收件人手机string SALESICENTRY销售增值税专用发票明细array SALESICENTRY.SRCBILLID源单内码string SALESICENTRY.SRCROWID源单行内码string SALESICENTRY.FSRCSEQ源单行号string SALESICENTRY.MATERIALID_Id物料编码_Idstring SALESICENTRY.MATERIALID_Name物料编码名称string SALESICENTRY.MATERIALID_Number物料编码_编码string SALESICENTRY.AUXPRICE单价string SALESICENTRY.AUXTAXPRICE含税单价string SALESICENTRY.SALESORDERNO销售订单string SALESICENTRY.PRICECOEFFICIEN价格系数string SALESICENTRY.PRICEQTY计价数量string SALESICENTRY.AMOUNTFOR不含税金额string SALESICENTRY.TAXRATE税率%string SALESICENTRY.DETAILTAXAMOUNTFOR税额string SALESICENTRY.ALLAMOUNTFOR价税合计string SALESICENTRY.COMMENT备注string SALESICENTRY.OPENSTATUS表体明细-开票核销状态string SALESICENTRY.OPENAMOUNTFOR表体明细-已开票核销金额string SALESICENTRY.NOTOPENAMOUNTFOR表体明细-未开票核销金额string SALESICENTRY.HOOKSTATUS勾稽状态string SALESICENTRY.HOOKAMOUNTFOR已钩稽金额string SALESICENTRY.HOOKQTY已钩稽基本单位数量string SALESICENTRY.UNHOOKQTY未钩稽基本单位数量string SALESICENTRY.UNHOOKAMOUNTFOR未钩稽金额string SALESICENTRY.BASICUNITID_Id基本单位Idstring SALESICENTRY.BASICUNITID_Name基本单位_名称string SALESICENTRY.BASICUNITID_Number基本单位编码string SALESICENTRY.PRICEUNITID_Id计价单位_Idstring SALESICENTRY.PRICEUNITID_Name计价单位名称string SALESICENTRY.PRICEUNITID_Number计价单位_编码string SALESICENTRY.BASICUNITQTY基本单位数量string SALESICENTRY.SRCBILLTYPEID源单类型string SALESICENTRY.SRCBILLNO源单编号string SALESICENTRY.SRCBASICQTY源单基本单位数量string SALESICENTRY.SRCIVBASICQTY源单已开票基本单位数量string SALESICENTRY.PLANPRICEQTY计划计价数量string SALESICENTRY.NOTOPENQTY表体明细-未开票核销数量string SALESICENTRY.OPENQTY表体明细-已开票核销数量string SALESICENTRY.TempAmount上游销售发票价税合计string SALESICENTRY.PUSHREDQTY已下推发票数量string SALESICENTRY.BASICUNITPRICEFOR基本单位单价string SALESICENTRY.MatchNotTaxAmtFor已核销不含税金额string SALESICENTRY.SPECIALAMOUNTFOR上游特殊核销金额string SALESICENTRY.MaterialDesc物料说明string SALESICENTRY.FPUSHRECABLEQTY已下推应收数量string SALESICENTRY.DEDUCTION免征额string SALESICENTRY.TAXDEDUCTION免征税额string SALESICENTRY.ROWID行标识string SALESICENTRY.PARENTROWID父行标识string SALESICENTRY.TAILDIFFFLAG尾差处理标识string SALESICENTRY.FLot_Id批号Idstring SALESICENTRY.FLot_Name批号_名称string SALESICENTRY.FLot_Number批号编码string SALESICENTRY.ENTRYDISCOUNTRATE折扣率(%)string SALESICENTRY.DISCOUNTAMOUNTFOR折扣额string SALESICENTRY.DISCOUNTAMOUNT折扣额本位币string SALESICENTRY.DETAILTAXAMOUNT税额本位币string SALESICENTRY.NOTAXAMOUNT不含税金额本位币string SALESICENTRY.ALLAMOUNT价税合计本位币string SALESICENTRY.COSTAMTSUM成本金额string SALESICENTRY.FCustMatID_Id客户物料编码_Idstring SALESICENTRY.FCustMatID_Name客户物料编码名称string SALESICENTRY.FCustMatID_Number客户物料编码_编码string SALESICENTRY.FOPENAMOUNT已核销金额本位币string SALESICENTRY.FTAXTYPEID_Id税收分类编码Idstring SALESICENTRY.FTAXTYPEID_Name税收分类编码_名称string SALESICENTRY.FTAXTYPEID_Number税收分类编码编码string SALESICENTRY.FMATCHNOTTAXAMT已核销不含税金额本位币string SALESICENTRY.COSTENTRY成本明细array SALESICENTRY.COSTENTRY.METRIALID_Id货物编码_Idstring SALESICENTRY.COSTENTRY.METRIALID_Name货物编码名称string SALESICENTRY.COSTENTRY.METRIALID_Number货物编码_编码string SALESICENTRY.COSTENTRY.PriceUnit_Id计价单位Idstring SALESICENTRY.COSTENTRY.PriceUnit_Name计价单位_名称string SALESICENTRY.COSTENTRY.PriceUnit_Number计价单位编码string SALESICENTRY.COSTENTRY.PriceUnitQty明细计价数量string SALESICENTRY.COSTENTRY.OUTSTOCKTYPE源出库单类型string SALESICENTRY.COSTENTRY.BILLNOSRC源单单号string SALESICENTRY.COSTENTRY.ROWNOSRC源单行内码string SALESICENTRY.COSTENTRY.ACCTSYS_Id核算体系_Idstring SALESICENTRY.COSTENTRY.ACCTSYS_Name核算体系名称string SALESICENTRY.COSTENTRY.ACCTSYS_Number核算体系_编码string SALESICENTRY.COSTENTRY.ACCTPOLICY_Id会计政策Idstring SALESICENTRY.COSTENTRY.ACCTPOLICY_Name会计政策_名称string SALESICENTRY.COSTENTRY.ACCTPOLICY_Number会计政策编码string SALESICENTRY.COSTENTRY.COSTPrice成本价string SALESICENTRY.COSTENTRY.COSTAMT成本金额string SALESICENTRY.COSTENTRY.BaseQty基本单位数量string SALESICENTRY.COSTENTRY.FSEQSRC源单行号string SALESICENTRY.COSTENTRY.FDEntryID明细内码string SALESICENTRY.COSTENTRY.BASICUNIT_Id基本单位_Idstring SALESICENTRY.COSTENTRY.BASICUNIT_Name基本单位名称string SALESICENTRY.COSTENTRY.BASICUNIT_Number基本单位_编码string SALESICENTRY.COSTENTRY.FBILLIDSRC源单内码string SALESICENTRY.COSTENTRY.FFORMIDSRC源单单据string SALESICENTRY.COSTENTRY.SALESICSCAN扫描信息array SALESICENTRY.COSTENTRY.SALESICSCAN.FCODESC发票代码string SALESICENTRY.COSTENTRY.SALESICSCAN.FNUMBERSC发票号string SALESICENTRY.COSTENTRY.SALESICSCAN.FAMOUNTSC发票金额string SALESICENTRY.COSTENTRY.SALESICSCAN.FINVOICEDATESC发票日期string

植隆业务中台接口明细

调用接口：/api/agentInvoiceApply/updateBatch
接口名称：工单状态更新接口
方法：POST

请求参数

字段字段名称类型配置值 approveTime开票审批时间string{{DATE}} logisticsNo物流单号string测试物流单号001 approveUser开票审批人string{{APPROVERID_Name}} approveStatus开票审批string3 invoiceApplyId开票IDstring{{F_ZHHB__out_id}} invoiceUrl发票下载地址stringhttp://k3.zhihong.net.cn/k3cloud/html5/index.aspx invoiceNumber发票号码string{{IVNUMBER}} logisticsCompany物流公司string测试物流公司 invoiceComment开票备注string开票备注test otherInfo其他信息string invoiceCode发票代码string{{IVCODE}} invoiceTime开票时间string{{DATE}} invoiceStatus开票状态（1-未开票 2-已开票 3-已作废）string2

数据对接价值

可视化配置，即便是普通业务人员也可以快速轻松对接多个平台，解决企业面临的数据孤岛，数据混乱等问题，实现数据可见、可用、可运营。进行统一化，模块化，标准化的服务能力和输出，实现对业务端数据需求的精准满足和高效响应，也可以在业务数据需求的不断增加下，让企业有整套的可复用的api资产以更换，支持业务的正常运转，节省开发成本。在不同的着重点和应用上解决数据共享，实现平台之间的独立管理。

从金蝶云星空到植隆业务中台通过接口配置打通数据