API
查询仓租单明细
更新时间： 2025-03-10 19:39:15 访问次数：10191

接口说明

卖家通过本接口可以查询到仓储单明细费用，精确到商品编码维度。
由于数据庞大，一般仅支持查询时间跨度为1天的数据。

使用场景

卖家通过商品SKU/商品条码/海外仓储收费单号查询对应仓储费用明细，仓租日期：海外仓仓储收费单产生的日期。
1.通过商品SKU/商品条码+海外仓编码进行查询，仓租日期支持31天时间跨度的查询

  • 查询商品SKU+海外仓编码，仓租日期时间跨度最多不超过31天
  • 查询商品条码+海外仓编码，仓租日期时间跨度最多不超过31天
  • 查询海外仓编码，仓租日期时间跨度最多不超过1天

2.通过海外仓储收费单号进行查询的，此时仓租开始日期startTime和endTime无须入参

接口名称

winit.ims.queryWarehouseReceiptDetails

请求说明

请求内容 说明
URL https://openapi.winit.com.cn/openapi/service
接口测试 https://sandboxopenapi.winit.com.cn/openapi/service
验证方法 Token,md5
格式 json
字符编码 UTF-8
http请求方式 http
请求数限制 默认每分钟1000，有需要可申请加大。
接口版本Version 1.0

请求入参

名称 类型 必填 说明 示例
merchandiseCode string(255) N 商品编码
merchandiseBarcode string(255) N 商品条码
WarehousereceiptNum string(255) O 海外仓储收费单号
warehouseCode String(100) N 海外仓编码 通过接口queryWarehouse查询得到出参：warehouseCode
startTime String(50) O 仓租开始日期 格式：YYYY-MM-DD
endTime String(50) O 仓租结束日期 格式：YYYY-MM-DD
pageNo Int Y 页码 整数
pageSize Int Y 每页记录数量 整数

请求示例

1.仓租时间查询

  1. {
  2.     "action": "winit.ims.queryWarehouseReceiptDetails",
  3.     "app_key": "rebecca",
  4.     "client_id": "ODJKMDU1YZCTYJQ5YY00ZWZLLTK5N2QTOWY4MZI5OGMWNDG2",
  5.     "data": {
  6.         "warehousereceiptNum": "",
  7.         "merchandiseBarcode": "",
  8.         "merchandiseCode": "",
  9.         "warehouseCode": "",
  10.         "startTime": "2019-08-20",
  11.         "endTime": "2019-08-20",
  12.         "pageSize": "10",
  13.         "pageNo": "1"
  14.     },
  15.     "format": "json",
  16.     "platform": "OWNERERP",
  17.     "sign_method": "md5",
  18.     "timestamp": "2019-05-28 10:39:00",
  19.     "version": "1.0",
  20.     "sign": "5A3EFDEDE38459E620B4A918AC0C74CA",
  21.     "client_sign": "27C011EE7F9C620DE9813DC3CE529EB1",
  22.     "language": "zh_CN"
  23. }

2.收费单号查询

  1. {
  2.   "action": "winit.ims.queryWarehouseReceiptDetails",
  3.   "app_key": "rebecca",
  4.   "client_id":"ODJKMDU1YZCTYJQ5YY00ZWZLLTK5N2QTOWY4MZI5OGMWNDG2",
  5.   "data": {
  6.      "warehousereceiptNum":"WC20190916153044000135",
  7.       "merchandiseBarcode":"",
  8.       "merchandiseCode":"",
  9.       "warehouseCode":"",
  10.       "startTime":"2019-09-16",
  11.       "endTime":"",
  12.       "pageSize": "10",
  13.       "pageNo":"1"
  14.   },
  15.   "format": "json",
  16.   "platform": "OWNERERP",
  17.   "sign_method": "md5",
  18.   "timestamp": "2019-05-28 10:39:00",
  19.   "version": "1.0",
  20.   "sign": "020D2D8BFB59EBC9218CB06C68804B7C",
  21.   "client_sign":"08A0D3CC862D25F4093F7B14E787FF82",
  22.   "language": "zh_CN"
  23.  }

3.商品条码查询

  1. {
  2.   "action": "winit.ims.queryWarehouseReceiptDetails",
  3.   "app_key": "rebecca",
  4.   "client_id":"ODJKMDU1YZCTYJQ5YY00ZWZLLTK5N2QTOWY4MZI5OGMWNDG2",
  5.   "data": {
  6.      "warehousereceiptNum":"",
  7.       "merchandiseBarcode":"M010000000001674549",
  8.       "merchandiseCode":"",
  9.       "warehouseCode":"US0001",
  10.       "startTime":"2019-08-01",
  11.       "endTime":"2019-08-30",
  12.       "pageSize": "10",
  13.       "pageNo":"1"
  14.   },
  15.   "format": "json",
  16.   "platform": "OWNERERP",
  17.   "sign_method": "md5",
  18.   "timestamp": "2019-05-28 10:39:00",
  19.   "version": "1.0",
  20.   "sign": "03F4FC16780E861A02CD454D7B29F41F",
  21.   "client_sign":"D5B450EE8144EC8D91AEBD3139EA136E",
  22.   "language": "zh_CN"
  23.  }

返回出参

返回参数说明：正确的返回编码code：0及结果data，错误的返回错误码及错误信息msg。

名称 类型 必填 说明 示例
chargeDate string Y 仓租时间 2019-08-20
shelveDate string Y 上架时间 2019-05-06
warehouseCode string Y 海外仓编码 US0001
warehouseName string Y 海外仓名称 USWC Warehouse
merchandiseCode String() Y 商品编码 auto_sku22
specification String() N 商品规格
merchandiseName String() Y 商品中文 cnName_auto_sku22
merchandiseBarcode String() Y 商品条码 M010000000001674549
merchandiseAge String() Y 库龄（天） 107
totalQty Int Y 商品数量 27
totalVolume String Y 总体积（CBM） 0.027
cargoType String() Y 一级货型 T50
cargoType2 String() Y 二级货型 T50+
pieceTypeSpec | Y 商品件型
小件
中件
大件
超大件		 中件
productVolume String() Y 单个商品体积(CBM) 0.00098
priceVersion String() Y 价格表编码 20190401
priceCode String() Y 价格版本 GBJ0000000044
totalPrice Int Y 金额 0.0135
currency String() Y 价格币种 USD
price String() Y 计费单价 0.5
created String() Y 海外仓储收费单号创建时间（精确到秒） 2019-09-17 14:30:02
recalcCompleteDate String() N 重算完成日期
属于重算明细返回，正常仓租计费不返回。		 2019-09-30
pageNo Int Y 页数 1
pageSize Int Y 每页记录数量 10
totalCount Int Y 记录数量 41

无用字段请忽略：

serviceType、boxSpecNo、merchandiseGrade、isBatchManager、isReturn、isHighValue、isMinCharge、isChartered、rackCode、chargeName、chargeVolume、skuType、electricType、skuThirdQty、chargeAmountOld、chargeAmountNew、sizeSource、recalcAdjType、orderNo、isPallet、dimension、palletQty、packageQty、isInsured、chargeTypeName

返回示例

  1. {
  2.   "code": "0",
  3.   "msg": "操作成功",
  4.   "data": {
  5.     "pageParams": {
  6.       "pageNo": 1,
  7.       "pageSize": 10,
  8.       "totalCount": 2
  9.     },
  10.     "list": [
  11.       {
  12.         "chargeNo": null,
  13.         "chargeDate": "2025-02-18",
  14.         "shelveDate": "2025-02-18",
  15.         "warehouseCode": "US0001",
  16.         "warehouseName": "USWC Warehouse",
  17.         "merchandiseCode": "TEST202502190001",
  18.         "specification": "",
  19.         "merchandiseName": "TEST202502190001",
  20.         "merchandiseBarcode": "M010000000006443968-3X",
  21.         "merchandiseAge": 1,
  22.         "totalQty": 6,
  23.         "totalVolume": "0.2295",
  24.         "cargoType": "T120",
  25.         "cargoType2": "T120+",
  26.         "pieceTypeSpec": "大件",
  27.         "priceVersion": null,
  28.         "priceCode": "CZ250204059917",
  29.         "totalPrice": "1.2",
  30.         "currency": "USD",
  31.         "price": "1",
  32.         "created": "2025-02-20 17:25:31",
  33.         "serviceType": "2B",
  34.         "boxSpecNo": null,
  35.         "merchandiseGrade": "GOOD",
  36.         "isBatchManager": "N",
  37.         "isReturn": "N",
  38.         "isHighValue": "N",
  39.         "isMinCharge": "Y",
  40.         "isChartered": "N",
  41.         "rackCode": null,
  42.         "chargeName": "仓储费",
  43.         "chargeVolume": "1.2",
  44.         "productVolume": 0.114750000,
  45.         "skuType": "NORMAL_GOODS",
  46.         "electricType": "NONE",
  47.         "skuThirdQty": 0,
  48.         "chargeAmountOld": null,
  49.         "chargeAmountNew": null,
  50.         "sizeSource": null,
  51.         "recalcAdjType": null,
  52.         "orderNo": null,
  53.         "docNo": null,
  54.         "isPallet": null,
  55.         "dimension": null,
  56.         "palletQty": null,
  57.         "packageQty": null,
  58.         "isInsured": "N",
  59.         "chargeTypeName": "收入",
  60.         "recalcCompleteDate": null
  61.       },
  62.       {
  63.         "chargeNo": null,
  64.         "chargeDate": "2025-02-18",
  65.         "shelveDate": "2025-02-18",
  66.         "warehouseCode": "US0001",
  67.         "warehouseName": "USWC Warehouse",
  68.         "merchandiseCode": "TEST202502190001",
  69.         "specification": "",
  70.         "merchandiseName": "TEST202502190001",
  71.         "merchandiseBarcode": "M010000000006443968-3X",
  72.         "merchandiseAge": 1,
  73.         "totalQty": 6,
  74.         "totalVolume": "0.424194",
  75.         "cargoType": "T120",
  76.         "cargoType2": "T120+",
  77.         "pieceTypeSpec": "大件",
  78.         "priceVersion": null,
  79.         "priceCode": "CZ250204059917",
  80.         "totalPrice": "0",
  81.         "currency": "USD",
  82.         "price": "1",
  83.         "created": "2025-02-20 17:25:31",
  84.         "serviceType": "2B",
  85.         "boxSpecNo": null,
  86.         "merchandiseGrade": "GOOD",
  87.         "isBatchManager": "N",
  88.         "isReturn": "N",
  89.         "isHighValue": "N",
  90.         "isMinCharge": "Y",
  91.         "isChartered": "N",
  92.         "rackCode": null,
  93.         "chargeName": "仓储费",
  94.         "chargeVolume": "1.2",
  95.         "productVolume": 0.212097000,
  96.         "skuType": "NORMAL_GOODS",
  97.         "electricType": "NONE",
  98.         "skuThirdQty": 0,
  99.         "chargeAmountOld": 1.200000,
  100.         "chargeAmountNew": 1.200000,
  101.         "sizeSource": null,
  102.         "recalcAdjType": "ALL",
  103.         "orderNo": null,
  104.         "docNo": null,
  105.         "isPallet": null,
  106.         "dimension": null,
  107.         "palletQty": null,
  108.         "packageQty": null,
  109.         "isInsured": "N",
  110.         "chargeTypeName": "调整",
  111.         "recalcCompleteDate": "2025-02-20"
  112.       }
  113.     ]
  114.   }
  115. }