赛意SMOM和金蝶云星空单据接口集成

接入系统：金蝶云星空

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

对接目标平台:赛意SMOM

赛意信息已经发展成为国内企业数字化服务领域最具发展潜力的领军企业之一，聚焦于工业互联网、智能制造、新一代信息技术、数字化转型等领域的技术与商业模式应用，为企业提供高端软件咨询、实施及集成服务，形成面向通讯、电子、家电、家居等23个重点行业和11条业务线的产品和解决方案。

系统对接接口配置

通过数据集成平台新增创建集成方案，然后在数据源平台中选择对应的源平台为：金蝶云星空，并且选择对应的连接器（关于金蝶云星空的接口连接器如何配置可以在轻易云系统数据集成交流社区bbs.qeasy.cloud 中找到相关信息）。选择对应的销售退货查询接口作为数据对接来源。然后再通过写入目标平台配置目标系统为赛意SMOM，并且选择对应连接器。选择对应的保存标签数据接口作为数据写入动作，既可以完成第一步的数据对接配置；打破跨系统连接，让数据轻易互通成为现实。

金蝶云星空接口明细

API：executeBillQuery
NAME：销售退货查询
METHOD：POST

请求参数

接口字段名称预设值 FID实体主键FID FBillNo单据编号FBillNo FDocumentStatus单据状态FDocumentStatus FSaleOrgId销售组织FSaleOrgId FDate日期FDate FStockOrgId库存组织FStockOrgId FRetcustId退货客户FRetcustId FStockerGroupId库存组FStockerGroupId FStockerId仓管员FStockerId FStockDeptId库存部门FStockDeptId FSaleGroupId销售组FSaleGroupId FSaledeptid销售部门FSaledeptid FSalesManId销售员FSalesManId FSettleCustId结算方FSettleCustId FPayCustId付款方FPayCustId FCreatorId创建人FCreatorId FCreateDate创建日期FCreateDate FModifierId最后修改人FModifierId FModifyDate最后修改日期FModifyDate FApproverId审核人FApproverId FApproveDate审核日期FApproveDate FCancellerId作废人FCancellerId FCancelDate作废日期FCancelDate FCancelStatus作废状态FCancelStatus FBillTypeID单据类型FBillTypeID FReceiveCustId收货方FReceiveCustId FOwnerTypeIdHead货主类型FOwnerTypeIdHead FOwnerIdHead货主FOwnerIdHead FBussinessType业务类型FBussinessType FReturnReason退货原因FReturnReason FReceiveAddress收货方地址FReceiveAddress FHeadLocId交货地点FHeadLocId FCreditCheckResult信用检查结果FCreditCheckResult FTransferBizType跨组织业务类型FTransferBizType FCorrespondOrgId对应组织FCorrespondOrgId FReceiveCusContact收货方联系人FReceiveCusContact FIsInterLegalPerson组织间结算跨法人标识FIsInterLegalPerson FHeadNote备注FHeadNote FIsTotalServiceOrCost整单服务标识FIsTotalServiceOrCost FGenFromPOS_CMK零售单日结生成FGenFromPOS_CMK FBranchId销售门店FBranchId FSHOPNUMBER网店编码FSHOPNUMBER FGYDATE管易退货日期FGYDATE FSALECHANNEL销售渠道FSALECHANNEL FGYExpressNo管易物流单号FGYExpressNo Fentity明细信息 Fentity.FENTRYID实体主键FENTRYID Fentity.FMaterialId物料编码FMaterialId Fentity.FMaterialName物料名称FMaterialName Fentity.FMaterialModel规格型号FMaterialModel Fentity.FMaterialType物料类别FMaterialType Fentity.FUnitID库存单位FUnitID Fentity.FMustqty应退数量FMustqty Fentity.FRealQty实退数量FRealQty Fentity.FStockId仓库FStockId Fentity.FStockstatusId库存状态FStockstatusId Fentity.FOwnerTypeId货主类型FOwnerTypeId Fentity.FOwnerId货主FOwnerId Fentity.FKeeperTypeId保管者类型FKeeperTypeId Fentity.FKeeperId保管者FKeeperId Fentity.FBOMIdBOM版本FBOMId Fentity.FAuxpropId辅助属性FAuxpropId Fentity.FProduceDate生产日期FProduceDate Fentity.FExpiryDate有效期至FExpiryDate Fentity.FBaseunitId基本单位FBaseunitId Fentity.FBaseunitQty库存基本数量FBaseunitQty Fentity.FAuxUnitId库存辅单位FAuxUnitId Fentity.FAuxUnitQty库存辅单位数量FAuxUnitQty Fentity.FCostPrice成本价（本位币）FCostPrice Fentity.FEntryCostAmount总成本FEntryCostAmount Fentity.FOrderNo订单单号FOrderNo Fentity.FNote备注FNote Fentity.FInvoicedQty关联应收数量（计价）FInvoicedQty Fentity.FBaseInvoicedQty(作废)关联开票数量(基本单位)FBaseInvoicedQty Fentity.FSumInvoicedQty累计应收数量（销售）FSumInvoicedQty Fentity.FSumInvoicedAmt(作废)累计开票金额FSumInvoicedAmt Fentity.FSumRecievedAmt累计收款金额FSumRecievedAmt Fentity.FStockFlag库存更新标示FStockFlag Fentity.FSrcBillTypeID源单类型FSrcBillTypeID Fentity.FExpUnit保质期单位FExpUnit Fentity.FExpPeriod保质期FExpPeriod Fentity.FStocklocId仓位FStocklocId Fentity.FF100001仓位FF100001 Fentity.FMapId客户物料编码FMapId Fentity.FMapName客户物料名称FMapName Fentity.FLot批号FLot Fentity.FReturnType退货类型FReturnType Fentity.FBaseSumInvoicedQty(作废)累计开票数量(基本单位)FBaseSumInvoicedQty Fentity.FCostAmount_LC总成本（本位币）FCostAmount_LC Fentity.FPriceUnitId计价单位FPriceUnitId Fentity.FPriceUnitQty计价数量FPriceUnitQty Fentity.FPrice单价FPrice Fentity.FTaxPrice含税单价FTaxPrice Fentity.FTaxCombination税组合FTaxCombination Fentity.FEntryTaxRate税率%FEntryTaxRate Fentity.FPriceCoefficient价格系数FPriceCoefficient Fentity.FSysPrice系统定价FSysPrice Fentity.FLimitDownPrice最低限价FLimitDownPrice Fentity.FBefDisAmt折前金额FBefDisAmt Fentity.FBefDisAllAmt折前价税合计FBefDisAllAmt Fentity.FDiscountRate折扣率%FDiscountRate Fentity.FDiscount折扣额FDiscount Fentity.FAmount金额FAmount Fentity.FAmount_LC金额（本位币）FAmount_LC Fentity.FEntryTaxAmount税额FEntryTaxAmount Fentity.FTaxAmount_LC税额（本位币）FTaxAmount_LC Fentity.FAllAmount价税合计FAllAmount Fentity.FAllAmount_LC价税合计（本位币）FAllAmount_LC Fentity.FIsFree是否赠品FIsFree Fentity.FTaxNetPrice净价FTaxNetPrice Fentity.FDeliveryDate退货日期FDeliveryDate Fentity.FBaseARJoinQty关联应收数量（计价基本）FBaseARJoinQty Fentity.FBFLowId业务流程FBFLowId Fentity.FBASEARQTY累计应收数量（销售基本）FBASEARQTY Fentity.FARJOINAMOUNT关联应收金额FARJOINAMOUNT Fentity.FARAMOUNT累计应收金额FARAMOUNT Fentity.FSalCostPrice销售成本价FSalCostPrice Fentity.FSrcBillNo源单编号FSrcBillNo Fentity.FSOBILLTYPEID订单类型FSOBILLTYPEID Fentity.FSNUnitID序列号单位FSNUnitID Fentity.FSNQty序列号单位数量FSNQty Fentity.FMtoNo计划跟踪号FMtoNo Fentity.FProjectNo项目编号FProjectNo Fentity.FRefuseFlag拒收标志FRefuseFlag Fentity.FISCONSUMESUM消耗汇总FISCONSUMESUM Fentity.FExtAuxUnitId辅单位FExtAuxUnitId Fentity.FExtAuxUnitQty实退数量（辅单位）FExtAuxUnitQty Fentity.FInventoryQty当前库存FInventoryQty Fentity.FPriceBaseQty计价基本数量FPriceBaseQty Fentity.FSalUnitID销售单位FSalUnitID Fentity.FSalUnitQty销售数量FSalUnitQty Fentity.FSalBaseQty销售基本数量FSalBaseQty Fentity.FQualifyType质量类型FQualifyType Fentity.FSalBaseNum销售基本分子FSalBaseNum Fentity.FStockBaseDen库存基本分母FStockBaseDen Fentity.FStockBaseARJoinQty关联应收数量（库存基本）FStockBaseARJoinQty Fentity.FSRCBIZUNITID携带的主业务单位FSRCBIZUNITID Fentity.FEOwnerSupplierId明细货主供应商FEOwnerSupplierId Fentity.FIsOverLegalOrg组织间结算跨法人标识FIsOverLegalOrg Fentity.FESettleCustomerId明细结算组织客户FESettleCustomerId Fentity.FSalBaseARJoinQty关联应收数量（销售基本）FSalBaseARJoinQty Fentity.FPriceListEntry行价目表FPriceListEntry Fentity.FARNOTJOINQTY未关联应收数量（计价单位）FARNOTJOINQTY Fentity.FSOEntryId销售订单EntryIdFSOEntryId Fentity.FIsReturnCheck退货检验FIsReturnCheck Fentity.FRowType产品类型FRowType Fentity.FParentMatId父项产品FParentMatId Fentity.FRowId行标识FRowId Fentity.FParentRowId父行标识FParentRowId Fentity.FThirdEntryId管易订单单号FThirdEntryId Fentity.FETHIRDBILLID第三方单据IDFETHIRDBILLID Fentity.FETHIRDBILLNO第三方单据编号FETHIRDBILLNO Fentity.FServiceContext服务上下文FServiceContext Fentity.FProPrice门店供货价FProPrice Fentity.FProAmount供货金额FProAmount Fentity.FBarcode零售条形码FBarcode Fentity.FGYFINSTATUS管易是否到账FGYFINSTATUS Fentity.FGYFINDate管易到账时间FGYFINDate Fentity.FPriceDiscount单价折扣FPriceDiscount Fentity.FTailDiffFlag尾差处理标识FTailDiffFlag Fentity.FWRITEOFFPRICEBASEQTY冲销数量(计价基本)FWRITEOFFPRICEBASEQTY Fentity.FWRITEOFFSALEBASEQTY冲销数量(销售基本)FWRITEOFFSALEBASEQTY Fentity.FWRITEOFFSTOCKBASEQTY冲销数量(库存基本)FWRITEOFFSTOCKBASEQTY Fentity.FWRITEOFFAMOUNT冲销金额FWRITEOFFAMOUNT Fentity.FSettleBySon按子项结算FSettleBySon Fentity.FBOMEntryIdBOM分录内码FBOMEntryId Fentity.F_out_id外部IDF_out_id Fentity.F_out_no外部编码F_out_no Fentity.F_out_type外部业务类型F_out_type Fentity.F_ZHHB_Text开户单号F_ZHHB_Text Fentity.Limit最大行数{{PAGINATION_PAGE_SIZE}} Fentity.StartRow开始行索引{{PAGINATION_START_ROW}} Fentity.TopRowCount返回总行数 Fentity.FilterString过滤条件FApproveDate>='{{LAST_SYNC_TIME dateTime}}' Fentity.FieldKeys需查询的字段key集合 Fentity.FormId业务对象表单IdSAL_RETURNSTOCK

响应参数

接口字段名称预设值 FID实体主键FID FBillNo单据编号FBillNo FDocumentStatus单据状态FDocumentStatus FSaleOrgId销售组织FSaleOrgId FDate日期FDate FStockOrgId库存组织FStockOrgId FRetcustId退货客户FRetcustId FStockerGroupId库存组FStockerGroupId FStockerId仓管员FStockerId FStockDeptId库存部门FStockDeptId FSaleGroupId销售组FSaleGroupId FSaledeptid销售部门FSaledeptid FSalesManId销售员FSalesManId FSettleCustId结算方FSettleCustId FPayCustId付款方FPayCustId FCreatorId创建人FCreatorId FCreateDate创建日期FCreateDate FModifierId最后修改人FModifierId FModifyDate最后修改日期FModifyDate FApproverId审核人FApproverId FApproveDate审核日期FApproveDate FCancellerId作废人FCancellerId FCancelDate作废日期FCancelDate FCancelStatus作废状态FCancelStatus FBillTypeID单据类型FBillTypeID FReceiveCustId收货方FReceiveCustId FOwnerTypeIdHead货主类型FOwnerTypeIdHead FOwnerIdHead货主FOwnerIdHead FBussinessType业务类型FBussinessType FReturnReason退货原因FReturnReason FReceiveAddress收货方地址FReceiveAddress FHeadLocId交货地点FHeadLocId FCreditCheckResult信用检查结果FCreditCheckResult FTransferBizType跨组织业务类型FTransferBizType FCorrespondOrgId对应组织FCorrespondOrgId FReceiveCusContact收货方联系人FReceiveCusContact FIsInterLegalPerson组织间结算跨法人标识FIsInterLegalPerson FHeadNote备注FHeadNote FIsTotalServiceOrCost整单服务标识FIsTotalServiceOrCost FGenFromPOS_CMK零售单日结生成FGenFromPOS_CMK FBranchId销售门店FBranchId FSHOPNUMBER网店编码FSHOPNUMBER FGYDATE管易退货日期FGYDATE FSALECHANNEL销售渠道FSALECHANNEL FGYExpressNo管易物流单号FGYExpressNo Fentity明细信息 FENTRYID实体主键FENTRYID FMaterialId物料编码FMaterialId FMaterialName物料名称FMaterialName FMaterialModel规格型号FMaterialModel FMaterialType物料类别FMaterialType FUnitID库存单位FUnitID FMustqty应退数量FMustqty FRealQty实退数量FRealQty FStockId仓库FStockId FStockstatusId库存状态FStockstatusId FOwnerTypeId货主类型FOwnerTypeId FOwnerId货主FOwnerId FKeeperTypeId保管者类型FKeeperTypeId FKeeperId保管者FKeeperId FBOMIdBOM版本FBOMId FAuxpropId辅助属性FAuxpropId FProduceDate生产日期FProduceDate FExpiryDate有效期至FExpiryDate FBaseunitId基本单位FBaseunitId FBaseunitQty库存基本数量FBaseunitQty FAuxUnitId库存辅单位FAuxUnitId FAuxUnitQty库存辅单位数量FAuxUnitQty FCostPrice成本价（本位币）FCostPrice FEntryCostAmount总成本FEntryCostAmount FOrderNo订单单号FOrderNo FNote备注FNote FInvoicedQty关联应收数量（计价）FInvoicedQty FBaseInvoicedQty(作废)关联开票数量(基本单位)FBaseInvoicedQty FSumInvoicedQty累计应收数量（销售）FSumInvoicedQty FSumInvoicedAmt(作废)累计开票金额FSumInvoicedAmt FSumRecievedAmt累计收款金额FSumRecievedAmt FStockFlag库存更新标示FStockFlag FSrcBillTypeID源单类型FSrcBillTypeID FExpUnit保质期单位FExpUnit FExpPeriod保质期FExpPeriod FStocklocId仓位FStocklocId FF100001仓位FF100001 FMapId客户物料编码FMapId FMapName客户物料名称FMapName FLot批号FLot FReturnType退货类型FReturnType FBaseSumInvoicedQty(作废)累计开票数量(基本单位)FBaseSumInvoicedQty FCostAmount_LC总成本（本位币）FCostAmount_LC FPriceUnitId计价单位FPriceUnitId FPriceUnitQty计价数量FPriceUnitQty FPrice单价FPrice FTaxPrice含税单价FTaxPrice FTaxCombination税组合FTaxCombination FEntryTaxRate税率%FEntryTaxRate FPriceCoefficient价格系数FPriceCoefficient FSysPrice系统定价FSysPrice FLimitDownPrice最低限价FLimitDownPrice FBefDisAmt折前金额FBefDisAmt FBefDisAllAmt折前价税合计FBefDisAllAmt FDiscountRate折扣率%FDiscountRate FDiscount折扣额FDiscount FAmount金额FAmount FAmount_LC金额（本位币）FAmount_LC FEntryTaxAmount税额FEntryTaxAmount FTaxAmount_LC税额（本位币）FTaxAmount_LC FAllAmount价税合计FAllAmount FAllAmount_LC价税合计（本位币）FAllAmount_LC FIsFree是否赠品FIsFree FTaxNetPrice净价FTaxNetPrice FDeliveryDate退货日期FDeliveryDate FBaseARJoinQty关联应收数量（计价基本）FBaseARJoinQty FBFLowId业务流程FBFLowId FBASEARQTY累计应收数量（销售基本）FBASEARQTY FARJOINAMOUNT关联应收金额FARJOINAMOUNT FARAMOUNT累计应收金额FARAMOUNT FSalCostPrice销售成本价FSalCostPrice FSrcBillNo源单编号FSrcBillNo FSOBILLTYPEID订单类型FSOBILLTYPEID FSNUnitID序列号单位FSNUnitID FSNQty序列号单位数量FSNQty FMtoNo计划跟踪号FMtoNo FProjectNo项目编号FProjectNo FRefuseFlag拒收标志FRefuseFlag FISCONSUMESUM消耗汇总FISCONSUMESUM FExtAuxUnitId辅单位FExtAuxUnitId FExtAuxUnitQty实退数量（辅单位）FExtAuxUnitQty FInventoryQty当前库存FInventoryQty FPriceBaseQty计价基本数量FPriceBaseQty FSalUnitID销售单位FSalUnitID FSalUnitQty销售数量FSalUnitQty FSalBaseQty销售基本数量FSalBaseQty FQualifyType质量类型FQualifyType FSalBaseNum销售基本分子FSalBaseNum FStockBaseDen库存基本分母FStockBaseDen FStockBaseARJoinQty关联应收数量（库存基本）FStockBaseARJoinQty FSRCBIZUNITID携带的主业务单位FSRCBIZUNITID FEOwnerSupplierId明细货主供应商FEOwnerSupplierId FIsOverLegalOrg组织间结算跨法人标识FIsOverLegalOrg FESettleCustomerId明细结算组织客户FESettleCustomerId FSalBaseARJoinQty关联应收数量（销售基本）FSalBaseARJoinQty FPriceListEntry行价目表FPriceListEntry FARNOTJOINQTY未关联应收数量（计价单位）FARNOTJOINQTY FSOEntryId销售订单EntryIdFSOEntryId FIsReturnCheck退货检验FIsReturnCheck FRowType产品类型FRowType FParentMatId父项产品FParentMatId FRowId行标识FRowId FParentRowId父行标识FParentRowId FThirdEntryId管易订单单号FThirdEntryId FETHIRDBILLID第三方单据IDFETHIRDBILLID FETHIRDBILLNO第三方单据编号FETHIRDBILLNO FServiceContext服务上下文FServiceContext FProPrice门店供货价FProPrice FProAmount供货金额FProAmount FBarcode零售条形码FBarcode FGYFINSTATUS管易是否到账FGYFINSTATUS FGYFINDate管易到账时间FGYFINDate FPriceDiscount单价折扣FPriceDiscount FTailDiffFlag尾差处理标识FTailDiffFlag FWRITEOFFPRICEBASEQTY冲销数量(计价基本)FWRITEOFFPRICEBASEQTY FWRITEOFFSALEBASEQTY冲销数量(销售基本)FWRITEOFFSALEBASEQTY FWRITEOFFSTOCKBASEQTY冲销数量(库存基本)FWRITEOFFSTOCKBASEQTY FWRITEOFFAMOUNT冲销金额FWRITEOFFAMOUNT FSettleBySon按子项结算FSettleBySon FBOMEntryIdBOM分录内码FBOMEntryId F_out_id外部IDF_out_id F_out_no外部编码F_out_no F_out_type外部业务类型F_out_type F_ZHHB_Text开户单号F_ZHHB_Text

赛意SMOM接口明细

API：保存标签数据
NAME：保存标签数据
METHOD：POST

系统对接概况

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

赛意SMOM和金蝶云星空单据接口集成