接口说明

卖家通过本接口可以查询到仓储单明细费用，精确到商品编码维度。
由于数据庞大，一般仅支持查询时间跨度为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.仓租时间查询

{
    "action": "winit.ims.queryWarehouseReceiptDetails",
    "app_key": "rebecca",
    "client_id": "ODJKMDU1YZCTYJQ5YY00ZWZLLTK5N2QTOWY4MZI5OGMWNDG2",
    "data": {
        "warehousereceiptNum": "",
        "merchandiseBarcode": "",
        "merchandiseCode": "",
        "warehouseCode": "",
        "startTime": "2019-08-20",
        "endTime": "2019-08-20",
        "pageSize": "10",
        "pageNo": "1"
    },
    "format": "json",
    "platform": "OWNERERP",
    "sign_method": "md5",
    "timestamp": "2019-05-28 10:39:00",
    "version": "1.0",
    "sign": "5A3EFDEDE38459E620B4A918AC0C74CA",
    "client_sign": "27C011EE7F9C620DE9813DC3CE529EB1",
    "language": "zh_CN"
}

2.收费单号查询

{
  "action": "winit.ims.queryWarehouseReceiptDetails",
  "app_key": "rebecca",
  "client_id":"ODJKMDU1YZCTYJQ5YY00ZWZLLTK5N2QTOWY4MZI5OGMWNDG2",
  "data": {
     "warehousereceiptNum":"WC20190916153044000135",
      "merchandiseBarcode":"",
      "merchandiseCode":"",
      "warehouseCode":"",
      "startTime":"2019-09-16",
      "endTime":"",
      "pageSize": "10",
      "pageNo":"1"
  },
  "format": "json",
  "platform": "OWNERERP",
  "sign_method": "md5",
  "timestamp": "2019-05-28 10:39:00",
  "version": "1.0",
  "sign": "020D2D8BFB59EBC9218CB06C68804B7C",
  "client_sign":"08A0D3CC862D25F4093F7B14E787FF82",
  "language": "zh_CN"
 }

3.商品条码查询

{
  "action": "winit.ims.queryWarehouseReceiptDetails",
  "app_key": "rebecca",
  "client_id":"ODJKMDU1YZCTYJQ5YY00ZWZLLTK5N2QTOWY4MZI5OGMWNDG2",
  "data": {
     "warehousereceiptNum":"",
      "merchandiseBarcode":"M010000000001674549",
      "merchandiseCode":"",
      "warehouseCode":"US0001",
      "startTime":"2019-08-01",
      "endTime":"2019-08-30",
      "pageSize": "10",
      "pageNo":"1"
  },
  "format": "json",
  "platform": "OWNERERP",
  "sign_method": "md5",
  "timestamp": "2019-05-28 10:39:00",
  "version": "1.0",
  "sign": "03F4FC16780E861A02CD454D7B29F41F",
  "client_sign":"D5B450EE8144EC8D91AEBD3139EA136E",
  "language": "zh_CN"
 }

返回出参

返回参数说明：正确的返回编码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
priceVersion	String()	Y	价格表编码	20190401
priceCode	String()	Y	价格版本	GBJ0000000044
totalCount	Int	Y	金额	0.0135
currency	String()	Y	价格币种	USD
price	String()	Y	计费单价	0.5
created	String()	Y	海外仓储收费单号创建时间（精确到秒）	2019-09-17 14:30:02
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

返回示例

 {
   "code": "0",
   "msg": "操作成功",
   "data": {
     "pageParams": {
         "pageNo": 1,
         "pageSize": 10,
         "totalCount": 41
     },
     "list": [
       {
         "chargeDate": "2019-08-20",
         "shelveDate": "2019-05-06",
         "warehouseCode": "US0001",
         "warehouseName": "USWC Warehouse",
         "merchandiseCode": "auto_sku22",
         "specification": "",
         "merchandiseName": "cnName_auto_sku22",
         "merchandiseBarcode": "M010000000001674549",
         "merchandiseAge": 107,
         "totalQty": 27,
         "totalVolume": "0.027",
         "cargoType": "T50",
         "priceVersion": "20190401",
         "priceCode": "GBJ0000000044",
         "totalPrice": "0.0135",
         "currency": "USD",
         "price": "0.5",
         "created": "2019-09-17 14:30:02"
       },
       {
         "chargeDate": "2019-08-20",
         "shelveDate": "2019-06-10",
         "warehouseCode": "US0001",
         "warehouseName": "USWC Warehouse",
         "merchandiseCode": "auto_sku22",
         "specification": "",
         "merchandiseName": "cnName_auto_sku22",
         "merchandiseBarcode": "M010000000001674549",
         "merchandiseAge": 72,
         "totalQty": 18,
         "totalVolume": "0.018",
         "cargoType": "T50",
         "priceVersion": "20190401",
         "priceCode": "GBJ0000000044",
         "totalPrice": "0",
         "currency": "USD",
         "price": "0",
         "created": "2019-09-17 14:30:02"
       }
     ]
   }
 }

关键词

查询仓租单明细