API
查询仓租单明细
更新时间: 2019-10-16 19:41:19 访问次数:4614
接口说明

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

接口英文名称

winit.ims.queryWarehouseReceiptDetails

使用场景

卖家通过商品SKU/商品条码/海外仓储收费单号查询对应仓储费用明细   仓租日期:海外仓仓储收费单产生的日期。
1.通过商品SKU/商品条码+海外仓编码进行查询,仓租日期支持31天时间跨度的查询;
1.1查询商品SKU+海外仓编码,仓租日期时间跨度最多不超过31天
查询1.2商品条码+海外仓编码,仓租日期时间跨度最多不超过31天
查询1.3海外仓编码,仓租日期时间跨度最多不超过1天
2.通过海外仓储收费单号进行查询的,此时仓租开始日期startTime和endTime无须入参。

请求说明
URL https://openapi.winit.com.cn/openapi/service
接口测试 https://openapi.sandbox.winit.com.cn/openapi/service
验证方法 Token,md5
格式 json
字符编码 UTF-8
http请求方式 http
请求数限制 默认每分钟1000,有需要可申请加大。
请求入参
名称 类型 必填 说明 示例
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
pageParams 页码列表
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"
 }
 
        
 
      
返回出参
名称 类型 必填 说明 示例
chargeDatestring仓租时间2019-08-20
shelveDatestring上架时间2019-05-06
warehouseCodestring海外仓编码US0001
warehouseNamestring海外仓名称USWC Warehouse
merchandiseCodeString()商品编码auto_sku22
specificationString()商品规格
merchandiseNameString()商品中文cnName_auto_sku22
merchandiseBarcodeString()商品条码M010000000001674549
merchandiseAgeString()库龄(天)107
totalQtyINT商品数量27
totalVolumeString总体积(CBM)0.027
cargoTypeString()货型T50
priceVersionString()价格表编码20190401
priceCodeString()价格版本GBJ0000000044
totalCountint0.0135
currencyString()价格币种USD
priceString()计费单价0.5
createdString()海外仓储收费单号创建时间(精确到秒)2019-09-17 14:30:02
pageNoint页数1
pageSizeint每页记录数量10
totalCountint记录数量41
返回示例
 1.使用仓租时间进行查询
        {
   "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"
       }
     ]
   }
 }
 
        3.使用商品条码查询结果
        {
   "code": "0",
   "msg": "操作成功",
   "data": {
     "pageParams": {
       "pageNo": 1,
       "pageSize": 10,
       "totalCount": 558
     },
     "list": [
       {
         "chargeDate": "2019-08-01",
         "shelveDate": "2019-05-06",
         "warehouseCode": "US0001",
         "warehouseName": "USWC Warehouse",
         "merchandiseCode": "auto_sku22",
         "specification": "",
         "merchandiseName": "cnName_auto_sku22",
         "merchandiseBarcode": "M010000000001674549",
         "merchandiseAge": 88,
         "totalQty": 27,
         "totalVolume": "0.027",
         "cargoType": "T50",
         "priceVersion": "20190401",
         "priceCode": "GBJ0000000044",
         "totalPrice": "0",
         "currency": "USD",
         "price": "0",
         "created": "2019-09-17 14:30:01"
       },
       {
         "chargeDate": "2019-08-01",
         "shelveDate": "2019-05-09",
         "warehouseCode": "US0001",
         "warehouseName": "USWC Warehouse",
         "merchandiseCode": "auto_sku22",
         "specification": "",
         "merchandiseName": "cnName_auto_sku22",
         "merchandiseBarcode": "M010000000001674549",
         "merchandiseAge": 85,
         "totalQty": 42,
         "totalVolume": "0.042",
         "cargoType": "T50",
         "priceVersion": "20190401",
         "priceCode": "GBJ0000000044",
         "totalPrice": "0",
         "currency": "USD",
         "price": "0",
         "created": "2019-09-17 14:30:01"
       },
       {
         "chargeDate": "2019-08-01",
         "shelveDate": "2019-05-12",
         "warehouseCode": "US0001",
         "warehouseName": "USWC Warehouse",
         "merchandiseCode": "auto_sku22",
         "specification": "",
         "merchandiseName": "cnName_auto_sku22",
         "merchandiseBarcode": "M010000000001674549",
         "merchandiseAge": 82,
         "totalQty": 9,
         "totalVolume": "0.009",
         "cargoType": "T50",
         "priceVersion": "20190401",
         "priceCode": "GBJ0000000044",
         "totalPrice": "0",
         "currency": "USD",
         "price": "0",
         "created": "2019-09-17 14:30:01"
       },
       {
         "chargeDate": "2019-08-01",
         "shelveDate": "2019-05-13",
         "warehouseCode": "US0001",
         "warehouseName": "USWC Warehouse",
         "merchandiseCode": "auto_sku22",
         "specification": "",
         "merchandiseName": "cnName_auto_sku22",
         "merchandiseBarcode": "M010000000001674549",
         "merchandiseAge": 81,
         "totalQty": 2,
         "totalVolume": "0.002",
         "cargoType": "T50",
         "priceVersion": "20190401",
         "priceCode": "GBJ0000000044",
         "totalPrice": "0",
         "currency": "USD",
         "price": "0",
         "created": "2019-09-17 14:30:01"
       },
       {
         "chargeDate": "2019-08-01",
         "shelveDate": "2019-05-20",
         "warehouseCode": "US0001",
         "warehouseName": "USWC Warehouse",
         "merchandiseCode": "auto_sku22",
         "specification": "",
         "merchandiseName": "cnName_auto_sku22",
         "merchandiseBarcode": "M010000000001674549",
         "merchandiseAge": 74,
         "totalQty": 16,
         "totalVolume": "0.016",
         "cargoType": "T50",
         "priceVersion": "20190401",
         "priceCode": "GBJ0000000044",
         "totalPrice": "0",
         "currency": "USD",
         "price": "0",
         "created": "2019-09-17 14:30:01"
       },
       {
         "chargeDate": "2019-08-01",
         "shelveDate": "2019-05-27",
         "warehouseCode": "US0001",
         "warehouseName": "USWC Warehouse",
         "merchandiseCode": "auto_sku22",
         "specification": "",
         "merchandiseName": "cnName_auto_sku22",
         "merchandiseBarcode": "M010000000001674549",
         "merchandiseAge": 67,
         "totalQty": 17,
         "totalVolume": "0.017",
         "cargoType": "T50",
         "priceVersion": "20190401",
         "priceCode": "GBJ0000000044",
         "totalPrice": "0",
         "currency": "USD",
         "price": "0",
         "created": "2019-09-17 14:30:01"
       },
       {
         "chargeDate": "2019-08-01",
         "shelveDate": "2019-05-29",
         "warehouseCode": "US0001",
         "warehouseName": "USWC Warehouse",
         "merchandiseCode": "auto_sku22",
         "specification": "",
         "merchandiseName": "cnName_auto_sku22",
         "merchandiseBarcode": "M010000000001674549",
         "merchandiseAge": 65,
         "totalQty": 5,
         "totalVolume": "0.005",
         "cargoType": "T50",
         "priceVersion": "20190401",
         "priceCode": "GBJ0000000044",
         "totalPrice": "0",
         "currency": "USD",
         "price": "0",
         "created": "2019-09-17 14:30:01"
       },
       {
         "chargeDate": "2019-08-01",
         "shelveDate": "2019-06-03",
         "warehouseCode": "US0001",
         "warehouseName": "USWC Warehouse",
         "merchandiseCode": "auto_sku22",
         "specification": "",
         "merchandiseName": "cnName_auto_sku22",
         "merchandiseBarcode": "M010000000001674549",
         "merchandiseAge": 60,
         "totalQty": 37,
         "totalVolume": "0.037",
         "cargoType": "T50",
         "priceVersion": "20190401",
         "priceCode": "GBJ0000000044",
         "totalPrice": "0",
         "currency": "USD",
         "price": "0",
         "created": "2019-09-17 14:30:01"
       },
       {
         "chargeDate": "2019-08-01",
         "shelveDate": "2019-06-04",
         "warehouseCode": "US0001",
         "warehouseName": "USWC Warehouse",
         "merchandiseCode": "auto_sku22",
         "specification": "",
         "merchandiseName": "cnName_auto_sku22",
         "merchandiseBarcode": "M010000000001674549",
         "merchandiseAge": 59,
         "totalQty": 18,
         "totalVolume": "0.018",
         "cargoType": "T50",
         "priceVersion": "20190401",
         "priceCode": "GBJ0000000044",
         "totalPrice": "0",
         "currency": "USD",
         "price": "0",
         "created": "2019-09-17 14:30:01"
       },
       {
         "chargeDate": "2019-08-01",
         "shelveDate": "2019-06-10",
         "warehouseCode": "US0001",
         "warehouseName": "USWC Warehouse",
         "merchandiseCode": "auto_sku22",
         "specification": "",
         "merchandiseName": "cnName_auto_sku22",
         "merchandiseBarcode": "M010000000001674549",
         "merchandiseAge": 53,
         "totalQty": 18,
         "totalVolume": "0.018",
         "cargoType": "T50",
         "priceVersion": "20190401",
         "priceCode": "GBJ0000000044",
         "totalPrice": "0",
         "currency": "USD",
         "price": "0",
         "created": "2019-09-17 14:30:01"
       }
     ]
   }
 } 
 
      
v