旺店通WMS对接外部金蝶云星空系统

接通系统：金蝶云星空

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

对接目标系统:旺店通WMS

　　旺店通wms最新版是一款功能齐全的店铺管理软件。旺店通wms管理系统官方版为用户量身定做仓储规划设计，覆盖了全行业，满足了各个行业不同经营模式的仓库运营管理。旺店通wms管理系统支持货品细化管理，无纸化FR作业，PDA，业务防呆机制等功能，有效的提高了企业运营效率。

配置集成方案

轻易云集成平台的对接是通过一个个对应的对接方案去形成两个系统对接的连线，所以对接方案的配置极其重要，方案可以选择一键复制，轻易云有海量的对接方案可支持一键复制，复制后直接启动使用（对接方案借鉴可以在轻易云系统数据集成交流社区bbs.qeasy.cloud 中找到相关信息。或者可以通过手工配置，配置只要确认源平台：金蝶云星空的取数逻辑，例如什么时间取什么样的数据。即可完成配置，目标平台：旺店通WMS，把获取的数据组装成目标系统需要的格式进行写入。

金蝶云星空接口明细

API：executeBillQuery
NAME：销售出库单查询
METHOD：POST

请求参数

接口字段名称预设值 FBillTypeID_FNumber单据类型FBillTypeID.FNumber FBillNo单据编号FBillNo FDate日期FDate FSaleOrgId_FNumber销售组织FSaleOrgId.FNumber FCustomerID_FNumber客户FCustomerID.FNumber FCarriageNO运输单号FCarriageNO FStockOrgId_FNumber发货组织FStockOrgId.FNumber FLinkPhone联系电话FLinkPhone FLinkMan收货人姓名FLinkMan FReceiveAddress收货方地址FReceiveAddress FSettleTypeID_FNumber结算方式FSettleTypeID.FNumber FReceiverAddress收货人地址FReceiverAddress FReceiverMobile收货人手机FReceiverMobile FReceiverCountry收货人国家FReceiverCountry FReceiverState收货人省份FReceiverState FReceiverCity收货人城市FReceiverCity FReceiverDistrict收货人地区FReceiverDistrict FReceiverPhone收货人电话FReceiverPhone FSHOPNUMBER网店编码FSHOPNUMBER FSALECHANNEL销售渠道FSALECHANNEL FVIPCODE会员编码FVIPCODE FCustMatID_FNumber客户物料编码FCustMatID.FNumber FMaterialID_FNumber物料编码FMaterialID.FNumber FBarcode零售条形码FBarcode FMustQty应发数量FMustQty FRealQty实发数量FRealQty FPrice单价FPrice FTaxPrice含税单价FTaxPrice FIsFree是否赠品FIsFree FLot批号FLot FProduceDate生产日期FProduceDate FExpiryDate有效期至FExpiryDate FEntryTaxRate税率%FEntryTaxRate FEntryTaxAmount税额FEntryTaxAmount FAmount金额FAmount FAllAmount价税合计FAllAmount FStockID仓库FStockID.FNumber FStockStatusID_FNumber库存状态FStockStatusID.FNumber FMtoNo计划跟踪号FMtoNo FEntrynote备注FEntrynote FSrcType源单类型FSrcType FSrcBillNo源单编号FSrcBillNo FSoorDerno订单单号FSoorDerno FDiscountRate折扣率%FDiscountRate FDiscount折扣额FDiscount FPriceDiscount单价折扣FPriceDiscount FSOEntryId销售订单EntryIdFSOEntryId FB2CORDERDETAILIDB2C订单明细IdFB2CORDERDETAILID FThirdEntryId管易订单单号FThirdEntryId FETHIRDBILLID第三方单据IDFETHIRDBILLID FETHIRDBILLNO第三方单据编号FETHIRDBILLNO FGYFINDate管易到账时间FGYFINDate FIDFIDFID FEntity_FEntryIDFEntity_FEntryIDFEntity_FEntryID F_JZJ_Remarks_XSMSz销售描述F_JZJ_Remarks_XSMS FMaterialID_F_JZJ_Text_SCCJ生产厂家FMaterialID.F_JZJ_Text_SCCJ FMaterialID_F_JZJ_Text_ZCZH生产备案号/注册证号FMaterialID.F_JZJ_Text_ZCZH FCustomerID_FName客户名称FCustomerID.FName FBillAllAmount价税合计FBillAllAmount FStockOrgId_FName发货组织名称FStockOrgId.FName FSalesGroupID销售组FSalesGroupID.FName FCreatorId创建人FCreatorId.FName Limit最大行数{{PAGINATION_PAGE_SIZE}} StartRow开始行索引{{PAGINATION_START_ROW}} TopRowCount返回总行数 FilterString过滤条件FApproveDate>='{{MINUTE_AGO_30 datetime}}' and FStockID.F_JZJ_CheckBox=1 and FBillTypeID.FNumber='XSCKD01_SYS' FieldKeys需查询的字段key集合 FormId业务对象表单IdSAL_OUTSTOCK

响应参数

接口字段名称预设值 FBillTypeID_FNumber单据类型FBillTypeID.FNumber FBillNo单据编号FBillNo FDate日期FDate FSaleOrgId_FNumber销售组织FSaleOrgId.FNumber FCustomerID_FNumber客户FCustomerID.FNumber FCarriageNO运输单号FCarriageNO FStockOrgId_FNumber发货组织FStockOrgId.FNumber FLinkPhone联系电话FLinkPhone FLinkMan收货人姓名FLinkMan FReceiveAddress收货方地址FReceiveAddress FSettleTypeID_FNumber结算方式FSettleTypeID.FNumber FReceiverAddress收货人地址FReceiverAddress FReceiverMobile收货人手机FReceiverMobile FReceiverCountry收货人国家FReceiverCountry FReceiverState收货人省份FReceiverState FReceiverCity收货人城市FReceiverCity FReceiverDistrict收货人地区FReceiverDistrict FReceiverPhone收货人电话FReceiverPhone FSHOPNUMBER网店编码FSHOPNUMBER FSALECHANNEL销售渠道FSALECHANNEL FVIPCODE会员编码FVIPCODE FCustMatID_FNumber客户物料编码FCustMatID.FNumber FMaterialID_FNumber物料编码FMaterialID.FNumber FBarcode零售条形码FBarcode FMustQty应发数量FMustQty FRealQty实发数量FRealQty FPrice单价FPrice FTaxPrice含税单价FTaxPrice FIsFree是否赠品FIsFree FLot批号FLot FProduceDate生产日期FProduceDate FExpiryDate有效期至FExpiryDate FEntryTaxRate税率%FEntryTaxRate FEntryTaxAmount税额FEntryTaxAmount FAmount金额FAmount FAllAmount价税合计FAllAmount FStockID仓库FStockID.FNumber FStockStatusID_FNumber库存状态FStockStatusID.FNumber FMtoNo计划跟踪号FMtoNo FEntrynote备注FEntrynote FSrcType源单类型FSrcType FSrcBillNo源单编号FSrcBillNo FSoorDerno订单单号FSoorDerno FDiscountRate折扣率%FDiscountRate FDiscount折扣额FDiscount FPriceDiscount单价折扣FPriceDiscount FSOEntryId销售订单EntryIdFSOEntryId FB2CORDERDETAILIDB2C订单明细IdFB2CORDERDETAILID FThirdEntryId管易订单单号FThirdEntryId FETHIRDBILLID第三方单据IDFETHIRDBILLID FETHIRDBILLNO第三方单据编号FETHIRDBILLNO FGYFINDate管易到账时间FGYFINDate FIDFIDFID FEntity_FEntryIDFEntity_FEntryIDFEntity_FEntryID F_JZJ_Remarks_XSMSz销售描述 FMaterialID_F_JZJ_Text_SCCJ生产厂家 FMaterialID_F_JZJ_Text_ZCZH生产备案号/注册证号 FCustomerID_FName客户名称FCustomerID.FName FBillAllAmount价税合计 FStockOrgId_FName发货组织名称FStockOrgId.FName FSalesGroupID销售组 FCreatorId创建人

旺店通WMS接口明细

API：WDT_WMS_STOCKOUT_CREATE
NAME：商品同步接口
METHOD：POST

请求参数

接口字段名称预设值 deliveryOrder出库单信息 deliveryOrder.deliveryOrderCode出库单号{{FBillNo}} deliveryOrder.orderType出库单类型QTCK deliveryOrder.createTime出库单创建时间{{FDate}} deliveryOrder.warehouseCode仓库编码{{FStockID}} deliveryOrder.receiverInfo收件人信息 deliveryOrder.receiverInfo.name姓名{{FLinkMan}} deliveryOrder.receiverInfo.mobile移动电话{{FLinkPhone}} deliveryOrder.receiverInfo.detailAddress详细地址{{FReceiveAddress}} deliveryOrder.receiverInfo.company公司名称{{FCustomerID_FName}} deliveryOrder.receiverInfo.remark备注{{F_JZJ_Remarks_XSMS}} deliveryOrder.receiverInfo.extendPropsextendProps deliveryOrder.receiverInfo.extendProps.prop1自定义属性1（取消{{FSalesGroupID}} deliveryOrder.receiverInfo.extendProps.prop2自定义属性2（取消{{FCreatorId }} deliveryOrder.receiverInfo.extendProps.prop3自定义属性3（取消{{FStockOrgId_FName}} deliveryOrder.receiverInfo.extendProps.shipment_type自定义属性1{{FCustomerID_FName}} deliveryOrder.receiverInfo.extendProps.platform_code自定义属性2{{FCreatorId }} deliveryOrder.receiverInfo.extendProps.prop3自定义属性3{{FSalesGroupID}} deliveryOrder.orderLines单据信息details deliveryOrder.orderLines.orderLineorderLine deliveryOrder.orderLines.orderLine.itemCode商家编码{{details.FMaterialID_FNumber}} deliveryOrder.orderLines.orderLine.orderLineNo单据行号{{details.FEntity_FEntryID}} deliveryOrder.orderLines.orderLine.planQty应发商品数量{{details.FRealQty}} deliveryOrder.orderLines.orderLine.batchCode批次_function case when '{{details.FLot}}'='0' then ' ' else {{details.FLot}} end deliveryOrder.orderLines.orderLine.productDate生产日期{{details.FProduceDate date}} deliveryOrder.orderLines.orderLine.expireDate过期日期{{details.FExpiryDate date}} deliveryOrder.orderLines.orderLine.remark备注{{details.FMaterialID_F_JZJ_Text_ZCZH}}/{{details.FMaterialID_F_JZJ_Text_SCCJ}} deliveryOrder.orderLines.orderLine.actualPrice实际成交单价{{details.FTaxPrice}}

数据对接价值

通过轻易云集成平台系列产品线可以协助企业轻易快捷的构建基于微服务架构的新一代企业服务总线，传统基于SOA架构的ESB产品主要解决的数据集成和协议转换等基础功能，已完全不能满足基于微服务架构、混合云集成架构、跨组织、跨单位的总线解决方案。而轻易云集成平台的每个产品线都是新一代的按照最新的互联网架构模式进行研发的产品线，能快速协助企业从传统的SOA架构转向微服务架构的服务总线解决方案。

旺店通WMS对接外部金蝶云星空系统