API
查询仓租单明细
更新时间: 2023-08-20 18:32:02 访问次数:9365

接口说明

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

返回示例

  1. {
  2. "code": "0",
  3. "msg": "操作成功",
  4. "data": {
  5. "pageParams": {
  6. "pageNo": 1,
  7. "pageSize": 10,
  8. "totalCount": 41
  9. },
  10. "list": [
  11. {
  12. "chargeDate": "2019-08-20",
  13. "shelveDate": "2019-05-06",
  14. "warehouseCode": "US0001",
  15. "warehouseName": "USWC Warehouse",
  16. "merchandiseCode": "auto_sku22",
  17. "specification": "",
  18. "merchandiseName": "cnName_auto_sku22",
  19. "merchandiseBarcode": "M010000000001674549",
  20. "merchandiseAge": 107,
  21. "totalQty": 27,
  22. "totalVolume": "0.027",
  23. "cargoType": "T50",
  24. "priceVersion": "20190401",
  25. "priceCode": "GBJ0000000044",
  26. "totalPrice": "0.0135",
  27. "currency": "USD",
  28. "price": "0.5",
  29. "created": "2019-09-17 14:30:02"
  30. },
  31. {
  32. "chargeDate": "2019-08-20",
  33. "shelveDate": "2019-06-10",
  34. "warehouseCode": "US0001",
  35. "warehouseName": "USWC Warehouse",
  36. "merchandiseCode": "auto_sku22",
  37. "specification": "",
  38. "merchandiseName": "cnName_auto_sku22",
  39. "merchandiseBarcode": "M010000000001674549",
  40. "merchandiseAge": 72,
  41. "totalQty": 18,
  42. "totalVolume": "0.018",
  43. "cargoType": "T50",
  44. "priceVersion": "20190401",
  45. "priceCode": "GBJ0000000044",
  46. "totalPrice": "0",
  47. "currency": "USD",
  48. "price": "0",
  49. "created": "2019-09-17 14:30:02"
  50. }
  51. ]
  52. }
  53. }