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

对接系统金蝶云星空

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

对接目标系统:赛意SMOM

广州赛意信息科技股份有限公司（简称“赛意信息”），成立于2005年，2017年8月在深圳证券交易所挂牌上市（证券代码：300687），是深交所创业板第666家上市企业。

多系统对接方案配置

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

金蝶云星空接口明细

API：executeBillQuery
NAME：退料申请查询
METHOD：POST

请求参数

接口字段字段名称预设值描述 FBillNo单据编号FBillNo FEntity_FEntryIDFEntity_FEntryIDFEntryID FIDFIDFID FDocumentStatus单据状态FDocumentStatus FBillTypeID_Fnumber单据类型FBillTypeID.Fnumber FDate申请日期FDate FPURCHASEORGID_Fnumber采购组织FPURCHASEORGID.Fnumber FStockOrgId_Fnumber退料组织FStockOrgId.Fnumber FMRDeptId_Fnumber退料部门FMRDeptId.Fnumber FSUPPLIERID_Fnumber供应商FSUPPLIERID.Fnumber FMRTYPE退料类型FMRTYPE FMRMODE退料方式FMRMODE FCreatorId创建人FCreatorId FCreateDate创建日期FCreateDate FModifierId最后修改人FModifierId FModifyDate最后修改日期FModifyDate FCancelerId作废人FCancelerId FCancelDate作废日期FCancelDate FCancelStatus作废状态FCancelStatus FBusinessType业务类型FBusinessType FDESCRIPTION备注FDESCRIPTION FMRREASON退料原因FMRREASON FRequireOrgId_Fnumber需求组织FRequireOrgId.Fnumber FConfirmerId确认人FConfirmerId FConfirmDate确认日期FConfirmDate FConfirmStatus确认状态FConfirmStatus FMATERIALID_Fnumber物料编码FMATERIALID.Fnumber FMaterialName物料名称FMaterialName FMateriaModel规格型号FMateriaModel FRMREALQTY实退数量FRMREALQTY FREPLENISHQTY补料数量FREPLENISHQTY FKEAPAMTQTY扣款数量FKEAPAMTQTY FNOTE备注FNOTE FPRICEQTY_F计价数量FPRICEQTY_F FPRICE_F单价FPRICE_F FPRICECOEFFICIENT_F价格系数FPRICECOEFFICIENT_F FDISCOUNTRATE_F折扣率FDISCOUNTRATE_F FDISCOUNT_F折扣额FDISCOUNT_F FTAXNETPRICE_F净价FTAXNETPRICE_F FAMOUNT_F退料金额FAMOUNT_F FALLAMOUNT_F退料含税金额FALLAMOUNT_F FAPPROVEPRICE_F含税单价FAPPROVEPRICE_F FSRCSEQ源单行号FSRCSEQ FCONTRACTNO合同单号FCONTRACTNO FORDERNO订单单号FORDERNO FREQTRACENO需求跟踪号FREQTRACENO FBASEUNITQTY库存基本数量FBASEUNITQTY FBASEUNITID退料申请基本单位FBASEUNITID FUNITID库存单位FUNITID FPRICEUNITID_F计价单位FPRICEUNITID_F FBASEMRJOINQTY退料关联数量（库存基本）FBASEMRJOINQTY FBASEMRQTY退料数量(基本单位)FBASEMRQTY FAUXPROPID辅助属性FAUXPROPID FSRCBILLNO源单编号FSRCBILLNO FSRCBILLTYPEID源单类型FSRCBILLTYPEID FREPLENISHAMOUNT补料金额FREPLENISHAMOUNT FKEAPAMTAMOUNT扣款金额FKEAPAMTAMOUNT FLot批号FLot FRMREASON_M退料原因FRMREASON_M FBFLowId业务流程FBFLowId FMtoNo计划跟踪号FMtoNo FGiveAway是否赠品FGiveAway FPriceBaseQty计价基本数量FPriceBaseQty FPURUNITID采购单位FPURUNITID FPurQty采购数量FPurQty FPurBaseQty采购基本数量FPurBaseQty FPURBASENUM采购基本分子FPURBASENUM FSTOCKBASEDEN库存基本分母FSTOCKBASEDEN FSRCBIZUNITID携带的主业务单位FSRCBIZUNITID FRETURNSTOCKJNBASEQTY退料关联数量（采购基本）FRETURNSTOCKJNBASEQTY FEntryTaxRate税率%FEntryTaxRate FENTRYPRICELISTID分录价目表FENTRYPRICELISTID FPOORDERENTRYID采购订单分录内码FPOORDERENTRYID FStockId_Fnumber仓库FStockId.Fnumber FISSYNTOTHIRD是否同步管易(GY)FISSYNTOTHIRD FRowType产品类型FRowType FPARENTMATID父项产品FPARENTMATID FPriceDiscount单价折扣FPriceDiscount FSTOCKLOCID仓位FSTOCKLOCID FPriLstEntryId价目表分录idFPriLstEntryId FEntity_Link_FFlowId业务流程图FEntity_Link_FFlowId FEntity_Link_FFlowLineId推进路线FEntity_Link_FFlowLineId FEntity_Link_FRuleId转换规则FEntity_Link_FRuleId FEntity_Link_FSTableId源单表内码FEntity_Link_FSTableId FEntity_Link_FSTableName源单表FEntity_Link_FSTableName FEntity_Link_FSBillId源单内码FEntity_Link_FSBillId FEntity_Link_FSId源单分录内码FEntity_Link_FSId FEntity_Link_FBASEUNITQTYOld原始携带量FEntity_Link_FBASEUNITQTYOld FEntity_Link_FBASEUNITQTY修改携带量FEntity_Link_FBASEUNITQTY FEntity_Link_FPurBaseQtyOld原始携带量FEntity_Link_FPurBaseQtyOld FEntity_Link_FPurBaseQty修改携带量FEntity_Link_FPurBaseQty FEntity_Link_FLnkTrackerId迁移图FEntity_Link_FLnkTrackerId FEntity_Link_FLnkSState上游状态FEntity_Link_FLnkSState FEntity_Link_FLnkAmount数量FLnkFEntity_Link_FLnkAmount FieldKeys需查询的字段key集合金蝶分录主键ID格式：FPOOrderEntry_FEntryId,其它格式 FPurchaseOrgId.FNumber Limit最大行数{{PAGINATION_PAGE_SIZE}} StartRow开始行索引{{PAGINATION_START_ROW}}金蝶的查询分页参数 TopRowCount返回总行数金蝶的查询分页参数 FilterString过滤条件FBillNo='10-CGTL2212190001'示例写法 FSupplierId.FNumber = 'VEN00010' and FApproveDate>= FormId业务对象表单IdPUR_MRB必须填写金蝶的表单ID如😛UR_PurchaseOrder

响应参数

接口字段字段名称预设值描述 FBillNo单据编号FBillNo FEntity_FEntryIDFEntity_FEntryIDFEntity_FEntryID FIDFIDFID FDocumentStatus单据状态FDocumentStatus FBillTypeID_Fnumber单据类型FBillTypeID.Fnumber FDate申请日期FDate FPURCHASEORGID_Fnumber采购组织FPURCHASEORGID.Fnumber FAPPORGID_Fnumber申请组织FAPPORGID.Fnumber FAPPDEPTID_Fnumber申请部门FAPPDEPTID.Fnumber FRMLOC退料地点FRMLOC FSUPPLIERID_Fnumber供应商FSUPPLIERID.Fnumber FRMMODE退料方式FRMMODE FREPLENISHMODE补料方式FREPLENISHMODE FCreatorId创建人FCreatorId FCreateDate创建日期FCreateDate FModifierId最后修改人FModifierId FModifyDate最后修改日期FModifyDate FAPPROVERID审核人FAPPROVERID FAPPROVEDATE审核日期FAPPROVEDATE FCANCELLERID作废人FCANCELLERID FCANCELDATE作废日期FCANCELDATE FCANCELSTATUS作废状态FCANCELSTATUS FBusinessType业务类型FBusinessType FRemarks备注FRemarks FRMREASON退料原因FRMREASON FRequireOrgId_Fnumber需求组织FRequireOrgId.Fnumber FCorrespondOrgId_Fnumber对应组织FCorrespondOrgId.Fnumber FConfirmerId确认人FConfirmerId FConfirmDate确认日期FConfirmDate FConfirmStatus确认状态FConfirmStatus FMATERIALID_Fnumber物料编码FMATERIALID.Fnumber FMaterialName物料名称FMaterialName FUOM规格型号FUOM FMaterialType存货类别FMaterialType FMRAPPQTY申请退料数量FMRAPPQTY FREPLENISHQTY补料数量FREPLENISHQTY FKEAPAMTQTY扣款数量FKEAPAMTQTY FMRJOINQTY退料关联数量FMRJOINQTY FMRQTY退料数量FMRQTY FNOTE_M备注FNOTE_M FBOMIDBOM版本FBOMID FPRICEQTY_F计价数量FPRICEQTY_F FPRICE_F单价FPRICE_F FPRICECOEFFICIENT_F价格系数FPRICECOEFFICIENT_F FDISCOUNTRATE_F折扣率FDISCOUNTRATE_F FDISCOUNT_F折扣额FDISCOUNT_F FTAXNETPRICE_F净价FTAXNETPRICE_F FAMOUNT_F退料金额FAMOUNT_F FALLAMOUNT_F退料含税金额FALLAMOUNT_F FAPPROVEPRICE_F含税单价FAPPROVEPRICE_F FSRCSEQ源单行号FSRCSEQ FCONTRACTNO合同单号FCONTRACTNO FORDERNO订单单号FORDERNO FREQTRACENO需求跟踪号FREQTRACENO FBASEUNITQTY库存基本数量FBASEUNITQTY FBASEUNITID退料申请基本单位FBASEUNITID FUNITID库存单位FUNITID FPRICEUNITID_F计价单位FPRICEUNITID_F FBASEMRJOINQTY退料关联数量（库存基本）FBASEMRJOINQTY FBASEMRQTY退料数量(基本单位)FBASEMRQTY FAUXPROPID辅助属性FAUXPROPID FSRCBILLNO源单编号FSRCBILLNO FSRCBILLTYPEID源单类型FSRCBILLTYPEID FREPLENISHAMOUNT补料金额FREPLENISHAMOUNT FKEAPAMTAMOUNT扣款金额FKEAPAMTAMOUNT FLot批号FLot FRMREASON_M退料原因FRMREASON_M FBFLowId业务流程FBFLowId FMtoNo计划跟踪号FMtoNo FGiveAway是否赠品FGiveAway FPriceBaseQty计价基本数量FPriceBaseQty FPURUNITID采购单位FPURUNITID FPurQty采购数量FPurQty FPurBaseQty采购基本数量FPurBaseQty FPURBASENUM采购基本分子FPURBASENUM FSTOCKBASEDEN库存基本分母FSTOCKBASEDEN FSRCBIZUNITID携带的主业务单位FSRCBIZUNITID FRETURNSTOCKJNBASEQTY退料关联数量（采购基本）FRETURNSTOCKJNBASEQTY FEntryTaxRate税率%FEntryTaxRate FENTRYPRICELISTID分录价目表FENTRYPRICELISTID FPOORDERENTRYID采购订单分录内码FPOORDERENTRYID FStockId_Fnumber仓库FStockId.Fnumber FISSYNTOTHIRD是否同步管易(GY)FISSYNTOTHIRD FRowType产品类型FRowType FPARENTMATID父项产品FPARENTMATID FPriceDiscount单价折扣FPriceDiscount FSTOCKLOCID仓位FSTOCKLOCID FPriLstEntryId价目表分录idFPriLstEntryId FEntity_Link_FFlowId业务流程图FEntity_Link_FFlowId FEntity_Link_FFlowLineId推进路线FEntity_Link_FFlowLineId FEntity_Link_FRuleId转换规则FEntity_Link_FRuleId FEntity_Link_FSTableId源单表内码FEntity_Link_FSTableId FEntity_Link_FSTableName源单表FEntity_Link_FSTableName FEntity_Link_FSBillId源单内码FEntity_Link_FSBillId FEntity_Link_FSId源单分录内码FEntity_Link_FSId FEntity_Link_FBASEUNITQTYOld原始携带量FEntity_Link_FBASEUNITQTYOld FEntity_Link_FBASEUNITQTY修改携带量FEntity_Link_FBASEUNITQTY FEntity_Link_FPurBaseQtyOld原始携带量FEntity_Link_FPurBaseQtyOld FEntity_Link_FPurBaseQty修改携带量FEntity_Link_FPurBaseQty FEntity_Link_FLnkTrackerId迁移图FEntity_Link_FLnkTrackerId FEntity_Link_FLnkSState上游状态FEntity_Link_FLnkSState FEntity_Link_FLnkAmount数量FLnkFEntity_Link_FLnkAmount

赛意SMOM接口明细

调用接口：SmomWebApiController.SaveShippingOrders
接口名称：保存发运单数据
方法：POST

请求参数

字段字段名称类型配置值 No单据号string{{FBillNo}} ErpIdErpIdstring OrderType单据大类string74 ShippingWareHouseCode发货仓库代码string{{details.FStockId_Fnumber}} DeliveryDate发货日期datetime{{FDate}} ShippingDate装运日期datetime{{CURRENT_TIME datetime}} Contacts联系人string ContactNumber联系电话string Connecter连接器string Address地址string CustomerCode客户编码string EnterpriseCode企业代码string SupplierCode供应商编码string{{details.FSUPPLIERID_Fnumber}} TransportCompany运输公司string TransportNo运输编码string OrderState订单状态string PriorityType优先级string CancelReason取消原因string Remark备注string DetailList详情arraydetails DetailList.ShippingOrderNo发货订单号string{{FBillNo}} DetailList.LineNo行号string{{details.FEntity_FEntryID}} DetailList.ItemCode物料编码string{{details.FMATERIALID_Fnumber}} DetailList.ExpectQty预计数量string{{details.FMRAPPQTY}} DetailList.ErpIdErpIdstring DetailList.OrderNo订单编码string DetailList.InvoiceNo发票代码string DetailList.PoNo订单号string DetailList.PoDetailLineNo采购订单明细行编号string{{details.FEntity_FEntryID}} DetailList.AppointStorageLocationCode指定存储位置代码string DetailList.AppointLotCodeAppointLotCodestring DetailList.OrderState订单状态string DetailList.Volume体积string DetailList.Weight重量string DetailList.Amount金额string DetailList.ErpKeyErpKeystring DetailList.Code编码string DetailList.Name名称string DetailList.InfkeyInfkeystring DetailList.IsDelete是否删除stringfalse DetailList.LastUpdateDate上次更新日期datetime{{CURRENT_TIME datetime}} DetailList.WarehouseCode发货仓库编码string{{details.FStockId_Fnumber}} DetailList.Thatokid明细IDstring{{details.FEntity_FEntryID}} DetailList.ErpKeyErpKeystring DetailList.Code编码string{{FBillNo}} DetailList.Name名称string DetailList.InfkeyInfkeystring DetailList.IsDelete是否删除stringfalse DetailList.LastUpdateDate上次更新日期datetime{{CURRENT_TIME datetime}} DetailList.TransactionCode单据小类stringTLSQDD01_SYS DetailList.Headid表头IDstring{{FID}} DetailList.EnterpriseCode部门string DetailList.ErpReviewStatusERP审核状态string已审核

系统对接概况

将传统的统计分析转变为预测分析，从被动分析到主动分析，从非实时分析转变为实时分析，从结构化的数据变成多元化的数据。精准查询数据流同步状况，实时监管队列任务以及数据资产的有序管理。为业务赋能，降本增效，让企业能够更加合理的布局团队；结合业务需求实现与OA，CRM，WMS等系统之间的数据交流与同步，为企业定制自定义的数据管理方案，用技术拓展商业边界，为新业务、新部门提供成长空间。

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