查询仓租单明细
更新时间: 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.仓租时间查询
{
"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"
}
]
}
}
关键词