从金蝶云星空到金蝶云星空通过接口集成数据

数据源平台:金蝶云星空

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

目标系统:金蝶云星空

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

数据对接方案

在轻易云平台进行集成方案的配置时，为了实现快速搭建，轻易云平台还提供了现有的市场方案进行复制参考。用户可以在创建集成方案的时候在第四步选择引用市场方案，参考市场主流所进行的字段配置完成集成方案的自定义化快速配置，即便是第一次使用轻易云平台的用户也能轻松搭建属于自己的数据同步方案。向导式配置，让配置更加清晰，首先确定该方方案的对接内容，第二歩获取筛选数据源平台的数据，第三步数据源与写入目标形成映射关系配置。完成配置后一键启用

金蝶云星空接口明细

调用接口：executeBillQuery
接口名称：委外退料单
方法：POST

请求参数

字段字段名称类型配置值 FID实体主键stringFID FBillNo单据编号stringFBillNo FDocumentStatus单据状态stringFDocumentStatus FApproverId审核人stringFApproverId FApproveDate审核日期stringFApproveDate FModifierId修改人stringFModifierId FCreateDate创建日期stringFCreateDate FCreatorId创建人stringFCreatorId FModifyDate修改日期stringFModifyDate FCancelDate作废日期stringFCancelDate FCanceler作废人stringFcanceler FCancelStatus作废状态stringFCancelStatus FDescription备注stringFDescription FBillType单据类型stringFBillType.FNUMBER FStockOrgId收料组织stringFStockOrgId.Fnumber FOwnerId0货主stringFOwnerId0.Fnumber FStockId0仓库stringFStockId0.Fnumber Fdate日期stringFdate FSubOrgId委外组织stringFSubOrgId.Fnumber FSubSupplierId供应商stringFSubSupplierId.Fnumber FOwnerTypeId0货主类型stringFOwnerTypeId0 FCurrId本位币stringFCurrId.Fnumber FTransferBizType跨组织业务类型stringFTransferBizType FSTOCKERID仓管员stringFSTOCKERID.Fnumber FReturnerId退料人stringFReturnerId.Fnumber FIsCrossTrade跨法人交易stringFIsCrossTrade FVmiBusinessVMI业务stringFVmiBusiness FSourceType倒冲来源stringFSourceType FIsOwnerTInclOrg货主含组织stringFIsOwnerTInclOrg FMaterialId物料编码stringFMaterialId.Fnumber FPPBOMEntryId委外用料清单分录IDstringFPPBOMEntryId FMaterialName物料名称stringFMaterialName FSpecification规格型号stringFSpecification FUnitID单位stringFUnitID.Fnumber FBomIdBOM版本stringFBomId FAPPQty申请数量stringFAPPQty FQty实退数量stringFQty FSelRePickedQty补料选单数stringFSelRePickedQty FReturnType退料类型stringFReturnType FReturnReason退料原因stringFReturnReason FStockId仓库stringFStockId.Fnumber FStockLocId仓位stringFStockLocId FSUBReqBillNo委外订单stringFSUBReqBillNo FSUBReqId委外订单IDstringFSUBReqId FSUBReqEntrySeq委外订单行号stringFSUBReqEntrySeq FSubReqEntryId委外订单分录IDstringFSubReqEntryId FAuxPropId辅助属性stringFAuxPropId FOwnerTypeId货主类型stringFOwnerTypeId FOwnerId货主stringFOwnerId.Fnumber FSrcBillType系统源单类型stringFSrcBillType FSrcBillNo系统源单编号stringFSrcBillNo FSrcBillId系统源单内码stringFSrcBillId FSrcEntrySeq系统源单行号stringFSrcEntrySeq FSrcEntryId系统源单分录内码stringFSrcEntryId FBaseUnitId基本单位stringFBaseUnitId.Fnumber FBaseSelRePickedQty基本单位补料选单数stringFBaseSelRePickedQty FBaseAppQty基本单位申请数量stringFBaseAppQty FBaseQty基本单位实退数量stringFBaseQty FStockUnitId主库存单位stringFStockUnitId.Fnumber FStockAppQty主库存申请数量stringFStockAppQty FStockQty主库存实退数量stringFStockQty FSecUnitId辅库存单位stringFSecUnitId FSecStockQty辅库存实退数量stringFSecStockQty FMtoNo计划跟踪号stringFMtoNo FStockStatusId库存状态stringFStockStatusId.Fnumber FProduceDate生产日期stringFProduceDate FExpPeriod保质期stringFExpPeriod FExpiryDate有效期至stringFExpiryDate FKeeperTypeId保管者类型stringFKeeperTypeId FKeeperId保管者stringFKeeperId.Fnumber FOperId工序号stringFOperId FProcessId作业stringFProcessId FMemo备注stringFMemo FPrice成本价stringFPrice FAmount总成本stringFAmount FStockFlag更新库存标志位stringFStockFlag FLot批号stringFLot FPPBomBillNo委外用料清单编号stringFPPBomBillNo FParentOwnerTypeId产品货主类型stringFParentOwnerTypeId FParentOwnerId产品货主stringFParentOwnerId.Fnumber FSRCBIZBILLTYPE业务源单类型stringFSRCBIZBILLTYPE FSRCBIZBILLNO业务源单编号stringFSRCBIZBILLNO FSRCBIZINTERID业务源单内码stringFSRCBIZINTERID FSRCBIZENTRYID业务源单分录内码stringFSRCBIZENTRYID FSRCBIZENTRYSEQ业务源单行号stringFSRCBIZENTRYSEQ FBFLowId业务流程stringFBFLowId FParentMaterialId产品编码stringFParentMaterialId FSNUnitID序列号单位stringFSNUnitID.Fnumber FSNQty序列号单位数量stringFSNQty FReserveType预留类型stringFReserveType FSettleOrgId结算组织stringFSettleOrgId FBaseStockQty主库存基本单位实退数量stringFBaseStockQty FConsome消耗汇总stringFConsome FEntryVmiBusinessVMI业务stringFEntryVmiBusiness FReqSrc需求来源stringFReqSrc FReqBillNo需求单据stringFReqBillNo FReqBillId需求单据内码stringFReqBillId FReqEntrySeq需求单据行号stringFReqEntrySeq FReqEntryId需求单据分录内码stringFReqEntryId FPOOrderBillNo采购订单stringFPOOrderBillNo FPOOrderSeq采购订单行号stringFPOOrderSeq FSupplierId供应商stringFSupplierId.Fnumber FIsUpdateQty不更新未领stringFIsUpdateQty Limit最大行数string{{PAGINATION_PAGE_SIZE}} StartRow开始行索引string{{PAGINATION_START_ROW}} TopRowCount返回总行数int FilterString过滤条件stringFApproveDate>='{{LAST_SYNC_TIME dateTime}}' FieldKeys需查询的字段key集合array FormId业务对象表单IdstringSUB_RETURNMTRL

响应参数

字段字段名称类型配置值 FID实体主键string FBillNo单据编号string FDocumentStatus单据状态string FApproverId审核人string FApproveDate审核日期string FModifierId修改人string FCreateDate创建日期string FCreatorId创建人string FModifyDate修改日期string FCancelDate作废日期string FCanceler作废人string FCancelStatus作废状态string FDescription备注string FBillType单据类型string FStockOrgId收料组织string FOwnerId0货主string FStockId0仓库string Fdate日期string FSubOrgId委外组织string FSubSupplierId供应商string FOwnerTypeId0货主类型string FCurrId本位币string FTransferBizType跨组织业务类型string FSTOCKERID仓管员string FReturnerId退料人string FIsCrossTrade跨法人交易string FVmiBusinessVMI业务string FScanBox序列号上传string FSourceType倒冲来源string FIsOwnerTInclOrg货主含组织string FEntryID实体主键string FMaterialId物料编码string FPPBOMEntryId委外用料清单分录IDstring FMaterialName物料名称string FSpecification规格型号string FUnitID单位string FBomIdBOM版本string FAPPQty申请数量string FQty实退数量string FSelRePickedQty补料选单数string FReturnType退料类型string FReturnReason退料原因string FStockId仓库string FStockLocId仓位string FSUBReqBillNo委外订单string FSUBReqId委外订单IDstring FSUBReqEntrySeq委外订单行号string FSubReqEntryId委外订单分录IDstring FAuxPropId辅助属性string FOwnerTypeId货主类型string FOwnerId货主string FSrcBillType系统源单类型string FSrcBillNo系统源单编号string FSrcBillId系统源单内码string FSrcEntrySeq系统源单行号string FSrcEntryId系统源单分录内码string FBaseUnitId基本单位string FBaseSelRePickedQty基本单位补料选单数string FBaseAppQty基本单位申请数量string FBaseQty基本单位实退数量string FStockUnitId主库存单位string FStockAppQty主库存申请数量string FStockQty主库存实退数量string FSecUnitId辅库存单位string FSecStockQty辅库存实退数量string FMtoNo计划跟踪号string FStockStatusId库存状态string FProduceDate生产日期string FExpUnit保质期单位string FExpPeriod保质期string FExpiryDate有效期至string FKeeperTypeId保管者类型string FKeeperId保管者string FOperId工序号string FProcessId作业string FMemo备注string FPrice成本价string FAmount总成本string FStockFlag更新库存标志位string FLot批号string FPPBomBillNo委外用料清单编号string FParentOwnerTypeId产品货主类型string FParentOwnerId产品货主string FSRCBIZBILLTYPE业务源单类型string FSRCBIZBILLNO业务源单编号string FSRCBIZINTERID业务源单内码string FSRCBIZENTRYID业务源单分录内码string FSRCBIZENTRYSEQ业务源单行号string FBFLowId业务流程string FParentMaterialId产品编码string FSNUnitID序列号单位string FSNQty序列号单位数量string FReserveType预留类型string FSettleOrgId结算组织string FBaseStockQty主库存基本单位实退数量string FConsome消耗汇总string FEntryVmiBusinessVMI业务string FReqSrc需求来源string FReqBillNo需求单据string FReqBillId需求单据内码string FReqEntrySeq需求单据行号string FReqEntryId需求单据分录内码string FPOOrderBillNo采购订单string FPOOrderSeq采购订单行号string FSupplierId供应商string FIsUpdateQty不更新未领string

金蝶云星空接口明细

接口：batchSave
接口名称：新增付款单
接口方法：POST

请求参数

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

数据对接价值

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

从金蝶云星空到金蝶云星空通过接口集成数据