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

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

接口英文名称

winit.ims.queryWarehouseReceiptDetails

使用场景

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

备注

  • 仓租时间、海外仓储收费单号两个入参至少一个必填,不能同时必填
    1.仓租时间为必填,入参含有商品编码/商品条码,支持查询时间跨度31天内;
    2.海外仓储收费单号必填,时间不限
    两个入参同时填写,取海外仓收费单必填,仓租时间无效
    请求说明
    URL http://openapi.winit.com.cn/openapi/service
    接口测试 http://openapi.sandbox.winit.com.cn/openapi/service
    验证方法 Token,md5
    格式 json
    字符编码 UTF-8
    http请求方式 http
    请求数限制 默认每分钟1000,有需要可申请加大。
    请求入参
    名称 类型 必填 说明 示例
    merchandiseCode string(255) N 商品编码
    商品SKU
    通过接口winit.mms.item.list查询返回参数skuCode;
    注意:商品一定要入海外仓上架之后才会收取仓储费用。
    merchandiseBarcode string(255) N 商品条码
    商品条码,
    通过接口winit.mms.item.list查询返回参数Code;
    注意:商品一定要入海外仓上架之后才会收取仓储费用。
    WarehousereceiptNum string(255) O 海外仓储收费单号
    可以通过万邑联进行查询,或者本接口返回的出参:WarehousereceiptNum
    仓租时间、海外仓储收费单号两个入参至少一个必填,不能同时必填
    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-05-09",
            "warehouseCode": "US0001",
            "warehouseName": "USWC Warehouse",
            "merchandiseCode": "auto_sku22",
            "specification": "",
            "merchandiseName": "cnName_auto_sku22",
            "merchandiseBarcode": "M010000000001674549",
            "merchandiseAge": 104,
            "totalQty": 42,
            "totalVolume": "0.042",
            "cargoType": "T50",
            "priceVersion": "20190401",
            "priceCode": "GBJ0000000044",
            "totalPrice": "0.021",
            "currency": "USD",
            "price": "0.5",
            "created": "2019-09-17 14:30:02"
          },
          {
            "chargeDate": "2019-08-20",
            "shelveDate": "2019-05-12",
            "warehouseCode": "US0001",
            "warehouseName": "USWC Warehouse",
            "merchandiseCode": "auto_sku22",
            "specification": "",
            "merchandiseName": "cnName_auto_sku22",
            "merchandiseBarcode": "M010000000001674549",
            "merchandiseAge": 101,
            "totalQty": 9,
            "totalVolume": "0.009",
            "cargoType": "T50",
            "priceVersion": "20190401",
            "priceCode": "GBJ0000000044",
            "totalPrice": "0.0045",
            "currency": "USD",
            "price": "0.5",
            "created": "2019-09-17 14:30:02"
          },
          {
            "chargeDate": "2019-08-20",
            "shelveDate": "2019-05-13",
            "warehouseCode": "US0001",
            "warehouseName": "USWC Warehouse",
            "merchandiseCode": "auto_sku22",
            "specification": "",
            "merchandiseName": "cnName_auto_sku22",
            "merchandiseBarcode": "M010000000001674549",
            "merchandiseAge": 100,
            "totalQty": 2,
            "totalVolume": "0.002",
            "cargoType": "T50",
            "priceVersion": "20190401",
            "priceCode": "GBJ0000000044",
            "totalPrice": "0.001",
            "currency": "USD",
            "price": "0.5",
            "created": "2019-09-17 14:30:02"
          },
          {
            "chargeDate": "2019-08-20",
            "shelveDate": "2019-05-20",
            "warehouseCode": "US0001",
            "warehouseName": "USWC Warehouse",
            "merchandiseCode": "auto_sku22",
            "specification": "",
            "merchandiseName": "cnName_auto_sku22",
            "merchandiseBarcode": "M010000000001674549",
            "merchandiseAge": 93,
            "totalQty": 16,
            "totalVolume": "0.016",
            "cargoType": "T50",
            "priceVersion": "20190401",
            "priceCode": "GBJ0000000044",
            "totalPrice": "0.008",
            "currency": "USD",
            "price": "0.5",
            "created": "2019-09-17 14:30:02"
          },
          {
            "chargeDate": "2019-08-20",
            "shelveDate": "2019-05-27",
            "warehouseCode": "US0001",
            "warehouseName": "USWC Warehouse",
            "merchandiseCode": "auto_sku22",
            "specification": "",
            "merchandiseName": "cnName_auto_sku22",
            "merchandiseBarcode": "M010000000001674549",
            "merchandiseAge": 86,
            "totalQty": 17,
            "totalVolume": "0.017",
            "cargoType": "T50",
            "priceVersion": "20190401",
            "priceCode": "GBJ0000000044",
            "totalPrice": "0",
            "currency": "USD",
            "price": "0",
            "created": "2019-09-17 14:30:02"
          },
          {
            "chargeDate": "2019-08-20",
            "shelveDate": "2019-05-29",
            "warehouseCode": "US0001",
            "warehouseName": "USWC Warehouse",
            "merchandiseCode": "auto_sku22",
            "specification": "",
            "merchandiseName": "cnName_auto_sku22",
            "merchandiseBarcode": "M010000000001674549",
            "merchandiseAge": 84,
            "totalQty": 5,
            "totalVolume": "0.005",
            "cargoType": "T50",
            "priceVersion": "20190401",
            "priceCode": "GBJ0000000044",
            "totalPrice": "0",
            "currency": "USD",
            "price": "0",
            "created": "2019-09-17 14:30:02"
          },
          {
            "chargeDate": "2019-08-20",
            "shelveDate": "2019-06-03",
            "warehouseCode": "US0001",
            "warehouseName": "USWC Warehouse",
            "merchandiseCode": "auto_sku22",
            "specification": "",
            "merchandiseName": "cnName_auto_sku22",
            "merchandiseBarcode": "M010000000001674549",
            "merchandiseAge": 79,
            "totalQty": 37,
            "totalVolume": "0.037",
            "cargoType": "T50",
            "priceVersion": "20190401",
            "priceCode": "GBJ0000000044",
            "totalPrice": "0",
            "currency": "USD",
            "price": "0",
            "created": "2019-09-17 14:30:02"
          },
          {
            "chargeDate": "2019-08-20",
            "shelveDate": "2019-06-04",
            "warehouseCode": "US0001",
            "warehouseName": "USWC Warehouse",
            "merchandiseCode": "auto_sku22",
            "specification": "",
            "merchandiseName": "cnName_auto_sku22",
            "merchandiseBarcode": "M010000000001674549",
            "merchandiseAge": 78,
            "totalQty": 18,
            "totalVolume": "0.018",
            "cargoType": "T50",
            "priceVersion": "20190401",
            "priceCode": "GBJ0000000044",
            "totalPrice": "0",
            "currency": "USD",
            "price": "0",
            "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"
          }
        ]
      }
    }
    1.使用仓租时间进行查询
    
    	   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