吉客云·奇门对接打通金蝶云星空销售单查询接口与[旺店通][销售退货单标准新增]-v1接口

对接系统：吉客云·奇门

吉客云是基于“网店管家”十五年电商ERP行业和技术积累基础上顺应产业发展需求，重新定位、全新设计推出的换代产品，从业务数字化和组织数字化两个方向出发，以构建流程的闭环为依归，致力于为企业的数字化升级提供落地工具。

对接目标平台:金蝶云星空

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

多系统对接方案配置

数据集成平台对应的配置吉客云·奇门与金蝶云星空的对接只要三步就能完成两个系统之间的数据对接。第一步根据吉客云·奇门的接口参数要求记录在轻易云集成平台。第二步配置吉客云·奇门与金蝶云星空之间的字段对应关系（更多方案可借鉴轻易云数据集成社区论坛中找到相关方案信息）第三步完成方案的检查参数设置：传递时间、重试次数、是否启动、前置条件等上线运行。

吉客云·奇门接口明细

调用接口：jackyun.tradenotsensitiveinfos.list.get
接口名称：销售单查询
方法：POST

请求参数

字段字段名称类型配置值 modified_begin起始时间string modified_end结束时间string startModified最后修改时间（起始）string endModified最后修改时间（截止）string tradeNo销售单号，多个用半角逗号分隔string pageSize每页记录数，默认50，最大1000string20 pageIndex页码，0为第1页string{{PAGINATION_START_PAGE}} hasTotal默认返回，首次调用时可以传1获取总记录数string1 startCreated创建时间（起始）string endCreated创建时间（截止）string startAuditTime审核时间（起始）string endAuditTime审核时间（截止）string startConsignTime发货时间（起始）string{{LAST_SYNC_TIME datetime}} endConsignTime发货时间（截止）string{{CURRENT_TIME datetime}} tradeStatus订单状态string9090 tradeType订单类型string8 sourceTradeNos网店订单号string fields需要返回字段列表逗号分隔stringcheckTotal,tradeNo,postFee,otherFee,chargeCurrency,accountName,payType,payNo,sellerMemo,buyerMemo,goodsDetail,goodsDetail.goodsNo,goodsDetail.goodsName,goodsDetail.specName,goodsDetail.barcode,goodsDetail.sellCount,goodsDetail.unit,goodsDetail.sellPrice,goodsDetail.sellTotal,goodsDetail.cost,goodsDetail.discountTotal,goodsDetail.discountPoint,goodsDetail.taxFee,goodsDetail.shareFavourableFee,goodsDetail.estimateWeight,goodsDetail.goodsMemo,goodsDetail.cateName,goodsDetail.brandName,goodsDetail.goodsTags,goodsDetail.isFit,goodsDetail.isGift,goodsDetail.discountFee,goodsDetail.taxRate,goodsDetail.estimateGoodsVolume,goodsDetail.isPresell,goodsDetail.customerPrice,goodsDetail.customerTotal,goodsDetail.tradeGoodsNo,goodsDetail.tradeGoodsName,goodsDetail.tradeGoodsSpec,goodsDetail.tradeGoodsUnit,goodsDetail.sourceTradeNo,goodsDetail.sourceSubtradeNo,goodsDetail.platCode,goodsDetail.platGoodsId,goodsDetail.subTradeId,appendMemo,tradeFrom,register,seller,auditor,reviewer,estimateWeight,packageWeight,tradeCount,goodsTypeCount,freezeReason,abnormalDescription,onlineTradeNo,goodslist,gmtCreate,gmtModified,stockoutNo,confirmTime,departName,lastShipTime,payStatus,chargeCurrencyCode,chargeExchangeRate,tradeStatus,grossProfit,estimateVolume,customerName,customerTypeName,customerGradeName,customerTags,customerCode,customerDiscount,specialReminding,blackList,tradeTime,country,state,city,district,town,zip,payTime,countryCode,cityCode,invoiceType,payerName,payerRegno,payerBankAccount,payerPhone,auditTime,payerAddress,invoiceNo,invoiceCode,invoiceStatus,payerBankName,preTypedetail,firstPayment,finalPayment,firstPaytime,finalPaytime,reviewTime,activationTime,customerTotalFee,customerDiscountFee,notifyPickTime,consignTime,orderNo,customerPostFee,shopId,shopName,tradeOrderPayList,tradeOrderPayList.chargeType,tradeOrderPayList.chargeCurrency,tradeOrderPayList.chargeAccount,tradeOrderPayList.accountName,tradeOrderPayList.payType,tradeOrderPayList.payNo,tradeOrderPayList.payment,tradeOrderPayList.chargeCurrencyCode,tradeOrderPayList.chargeExchangeRate,customerPayment,companyName,tradeOrderColumnExt,tradeOrderColumnExt.tradeId,tradeOrderColumnExt.customizeTradeColumn1,tradeOrderColumnExt.customizeTradeColumn2,tradeOrderColumnExt.customizeTradeColumn3,tradeOrderColumnExt.customizeTradeColumn4,tradeOrderColumnExt.customizeTradeColumn5,tradeOrderColumnExt.customizeTradeColumn6,tradeOrderColumnExt.customizeTradeColumn7,tradeOrderColumnExt.customizeTradeColumn8,tradeOrderColumnExt.customizeTradeColumn9,tradeOrderColumnExt.customizeTradeColumn10,isBillCheck,warehouseCode,warehouseName,logisticName,tradeId,billDate,logisticType,mainPostid,tradeType,totalFee,taxFee,receivedPostFee,discountFee,payment,couponFee,receivedTotal,isDelete,flagIds,flagNames,shopCode,goodsDetail.specId,goodsDelivery.batchNo,goodsDelivery.productionDate,goodsDelivery.expirationDate,goodsDetail.shareFavourableAfterFee,goodsDelivery.sendCount,goodsDetail.divideSellTotal,goodsDetail.shareOrderDiscountFee,goodsDetail.shareOrderPlatDiscountFee

响应参数

字段字段名称类型配置值 checkTotal对账金额string tradeNo订单编号string postFee实际邮资string otherFee其它费用string sellerMemo备注string buyerMemo买家备注string goodsDetail货品详情array goodsDetail.goodsNo货品编号string goodsDetail.goodsName货品名称string goodsDetail.specName规格名称string goodsDetail.barcode条码string goodsDetail.sellCount数量string goodsDetail.unit单位string goodsDetail.sellPrice单价string goodsDetail.sellTotal总金额string goodsDetail.cost货品成本string goodsDetail.discountTotal优惠金额string goodsDetail.discountPoint抵扣积分string goodsDetail.shareFavourableFee分摊金额string goodsDetail.goodsMemo货品备注string goodsDetail.cateName货品类别string goodsDetail.brandName品牌string goodsDetail.goodsTags货品标签string goodsDetail.isFit组合装标记string goodsDetail.isGift赠品标记string goodsDetail.taxRate税率string goodsDetail.estimateGoodsVolume预估体积（单个货品）string goodsDetail.isPresell是否预售货品标记1是0否string goodsDetail.customerPrice终端销售单价string goodsDetail.customerTotal终端销售金额string goodsDetail.tradeGoodsNo交易编号string goodsDetail.tradeGoodsName交易名称string goodsDetail.tradeGoodsSpec交易规格string goodsDetail.tradeGoodsUnit交易单位string goodsDetail.sourceTradeNo网店订单号string goodsDetail.sourceSubtradeNo网店子订单好string goodsDetail.platCode平台代码string goodsDetail.platGoodsId平台商品idstring goodsDetail.subTradeId商品明细id（唯一）string goodsDetail.taxFee税额string goodsDetail.estimateWeight预估重量string goodsDetail.discountFee优惠金额string goodsDetail.appendMemo追加备注string goodsDetail.tradeFrom订单来源string goodsDetail.register登记人string goodsDetail.seller业务员string goodsDetail.auditor审核人string goodsDetail.reviewer复核人string goodsDetail.packageWeight包裹重量string goodsDetail.tradeCount订单总数量string goodsDetail.goodsTypeCount商品样数string goodsDetail.freezeReason冻结原因string goodsDetail.abnormalDescription问题单具体描述string goodsDetail.onlineTradeNo网店订单号string goodsDetail.goodslist货品摘要string goodsDetail.gmtCreate创建时间string goodsDetail.gmtModified最后修改时间string goodsDetail.stockoutNo出库单号string goodsDetail.confirmTime确认时间string goodsDetail.departName部门名称string goodsDetail.lastShipTime承诺发货时间string goodsDetail.payStatus付款状态：未付款、部分付款、已付款string goodsDetail.tradeStatus订单状态string goodsDetail.grossProfit毛利string goodsDetail.estimateVolume订单预估体积string goodsDetail.customerName客户名称string goodsDetail.customerTypeName客户类型string goodsDetail.customerGradeName客户等级string goodsDetail.customerTags客户标签string goodsDetail.customerCode客户编号string goodsDetail.customerDiscount折扣string goodsDetail.specialReminding特别提醒string goodsDetail.blackList黑名单string goodsDetail.tradeTime下单时间string goodsDetail.country国家string goodsDetail.state省string goodsDetail.city城市string goodsDetail.district区县string goodsDetail.town街道string goodsDetail.zip邮编string goodsDetail.payTime支付时间string goodsDetail.countryCode国家编码string goodsDetail.cityCode城市编码string goodsDetail.invoiceType发票类型string goodsDetail.payerName购方名称string goodsDetail.payerRegno购方税号string goodsDetail.payerBankAccount购方开户行及帐号string goodsDetail.payerPhone购方电话string goodsDetail.auditTime审核时间string goodsDetail.payerAddress购方地址string goodsDetail.invoiceNo发票号码string goodsDetail.invoiceCode发票代码string goodsDetail.invoiceStatus发票开具状态string goodsDetail.payerBankName购方开户行string goodsDetail.preTypedetail预定类别描述string goodsDetail.firstPayment付首款金额string goodsDetail.finalPayment付尾款金额string goodsDetail.firstPaytime付首款时间string goodsDetail.finalPaytime付尾款时间string goodsDetail.reviewTime复核时间string goodsDetail.activationTime激活时间string goodsDetail.customerTotalFee终端货款合计string goodsDetail.customerDiscountFee终端优惠string goodsDetail.notifyPickTime通知仓库发货时间string goodsDetail.consignTime发货时间string goodsDetail.orderNo发货单单号string goodsDetail.customerPostFee终端应收邮资string goodsDetail.shopId店铺idstring goodsDetail.ShopName店铺名称string goodsDetail.tradeOrderPayList订单支付详情array goodsDetail.tradeOrderPayList.chargeCurrency结算币种string goodsDetail.tradeOrderPayList.accountName收款账户名称string goodsDetail.tradeOrderPayList.payType支付方式：1,支付宝 2,财付通 3,微信支付 4,银联支付 5,盛付通 6,其它 7,现金 8,储值卡 9,扫码付 10,挂账 11,诺诺支付 16,易付宝 32,有赞支付 33,汇付支付 35,商盟支付 36,易宝支付 37,汇聚支付 38,合利宝支付 27,通联支付string goodsDetail.tradeOrderPayList.payNo支付单号string goodsDetail.tradeOrderPayList.chargeCurrencyCode结算币种编码string goodsDetail.tradeOrderPayList.chargeExchangeRate结算汇率string goodsDetail.tradeOrderPayList.chargeType结算方式：1.担保交易2.银行收款3.现金收款4.货到付款5.欠款计应收6.客户预存款7.多种结算8.退换货冲抵9.电子钱包string goodsDetail.tradeOrderPayList.chargeAccount收款帐户string goodsDetail.tradeOrderPayList.payment应收金额float goodsDetail.tradeOrderPayList.customerPayment终端应收合计string goodsDetail.tradeOrderPayList.companyName公司名称string goodsDetail.tradeOrderPayList.tradeOrderColumnExt销售单自定义字段object goodsDetail.tradeOrderPayList.tradeOrderColumnExt.customizeTradeColumn1自定义字段1string goodsDetail.tradeOrderPayList.tradeOrderColumnExt.customizeTradeColumn2自定义字段2string goodsDetail.tradeOrderPayList.tradeOrderColumnExt.customizeTradeColumn3自定义字段3string goodsDetail.tradeOrderPayList.tradeOrderColumnExt.customizeTradeColumn4自定义字段4string goodsDetail.tradeOrderPayList.tradeOrderColumnExt.customizeTradeColumn5自定义字段5string goodsDetail.tradeOrderPayList.tradeOrderColumnExt.customizeTradeColumn6自定义字段6string goodsDetail.tradeOrderPayList.tradeOrderColumnExt.customizeTradeColumn7自定义字段7string goodsDetail.tradeOrderPayList.tradeOrderColumnExt.customizeTradeColumn8自定义字段8string goodsDetail.tradeOrderPayList.tradeOrderColumnExt.customizeTradeColumn9自定义字段9string goodsDetail.tradeOrderPayList.tradeOrderColumnExt.customizeTradeColumn10自定义字段10string goodsDetail.tradeOrderPayList.tradeOrderColumnExt.tradeId系统编码string goodsDetail.tradeOrderPayList.tradeOrderColumnExt.isBillCheck对账状态 1对账，其他未对账string goodsDetail.tradeOrderPayList.tradeOrderColumnExt.warehouseCode仓库编码string goodsDetail.tradeOrderPayList.tradeOrderColumnExt.warehouseName仓库名称string goodsDetail.tradeOrderPayList.tradeOrderColumnExt.logisticName物流名称string goodsDetail.tradeOrderPayList.tradeOrderColumnExt.billDate对账时间string goodsDetail.tradeOrderPayList.tradeOrderColumnExt.logisticType配送方式string goodsDetail.tradeOrderPayList.tradeOrderColumnExt.mainPostid运单号string goodsDetail.tradeOrderPayList.tradeOrderColumnExt.tradeType订单类型string goodsDetail.tradeOrderPayList.tradeOrderColumnExt.totalFee商品金额string goodsDetail.tradeOrderPayList.tradeOrderColumnExt.receivedPostFee应收邮资string goodsDetail.tradeOrderPayList.tradeOrderColumnExt.couponFee平台优惠string goodsDetail.tradeOrderPayList.tradeOrderColumnExt.receivedTotal已收金额string goodsDetail.tradeOrderPayList.tradeOrderColumnExt.isDelete删除标记，0 未删除， 1已删除string goodsDetail.tradeOrderPayList.tradeOrderColumnExt.flagIds标记idstring goodsDetail.tradeOrderPayList.tradeOrderColumnExt.flagNames标记名称string goodsDetail.tradeOrderPayList.tradeOrderColumnExt.shopCode店铺编号string

金蝶云星空接口明细

调用接口：batchSave
接口名称：[旺店通][销售退货单标准新增]-v1
方法：POST

请求参数

字段字段名称类型配置值 FBillTypeID单据类型stringXSTHD01_SYS FBillNo单据编号string{{tradeNo}} FSaleOrgId销售组织string009 FDate日期string{{consignTime}} FStockOrgId库存组织string009 FRetcustId退货客户string{{shopCode}} FSaledeptid销售部门string FHeadNote备注string FPayCustId付款方string FEntity明细信息arraygoodsDetail FEntity.FMaterialId物料编码string{{goodsDetail.goodsNo}} FEntity.FBarcode零售条形码string FEntity.FRealQty实退数量stringfunction {{goodsDetail.sellCount}}*-1 FEntity.FPrice单价string_function {{goodsDetail.shareFavourableAfterFee}}/{{goodsDetail.sellCount}} FEntity.FTaxPrice含税单价string_function {{goodsDetail.shareFavourableAfterFee}}/{{goodsDetail.sellCount}} FEntity.FIsFree是否赠品string FEntity.FStockId仓库string{{warehouseCode}} FEntity.FNote备注string FEntity.SubHeadEntity财务信息object FEntity.SubHeadEntity.FSettleOrgId结算组织string009 FEntity.SubHeadEntity.FormId业务对象表单IdstringSAL_RETURNSTOCK FEntity.SubHeadEntity.Operation执行的操作stringSave FEntity.SubHeadEntity.IsAutoSubmitAndAudit提交并审核booltrue FEntity.SubHeadEntity.IsVerifyBaseDataField验证基础资料boolfalse FEntity.SubHeadEntity.SubSystemId系统模块string21

系统对接概况

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

吉客云·奇门对接打通金蝶云星空销售单查询接口与[旺店通][销售退货单标准新增]-v1接口