文档
测试

2.查询盘亏记录

websocket测试
POST
https://api.jd.com/routerjson

接口描述

开发者可调用此接口查询事业部在某段时间内的盘亏列表记录

jos官网说明

https://jos.jd.com/apilist?apiGroupId=138&apiId=13159&apiName=jingdong.eclp.checkstock.queryCheckStockLosses

数据格式及编码

``` Content_type：application/x-www-form-urlencoded Accept：application/json Charset：utf-8 ```

Params公共请求参数

参数名
类型
描述
必填
method
string
接口方法名。请填写"jingdong.eclp.checkstock.queryCheckStockLosses"
必填
app_key
string
开发者应用app_key
必填
access_token
string
京东账户授权访问令牌码
必填
timestamp
string
请求时间, 京东网关允许误差为10分钟。 示例：2020-09-23 12:23:45
必填
format
string
数据格式。固定值"json"
必填
v
string
接口版本号，固定值“2.0”
必填
sign_method
string
签名方式,可支持"md5"（默认）,"hmacmd5","hmacsha256"
可选
sign
string
签名值。签名算法请参考https://easydoc.xyz/doc/85914950/QULSrw7u/EnnJTVOz
必填

Request Body应用级参数

application/x-www-form-urlencoded
参数名
类型
描述
必填
360buy_param_json
string
业务系统参数
必填
deptNo
string
eclp系统--事业部编码
必填
checkStockNos
string
eclp系统--盘点单号
必填
pageNo
number
查询页码；默认第一页
必填
pageSize
number
每页盘点单个数；默认：50，最大50条
必填
startTime
string
开始日期；格式：yyyy-MM-dd HH:mm:ss
必填
endTime
string
结束日期；格式：yyyy-MM-dd HH:mm:ss
必填

Response响应参数

application/json
参数名
类型
描述
必填
jingdong_eclp_checkstock_queryCheckStockLosses_responce
object
数据字典
必填
code
string
网关状态码
必填
checkstocklossesList
array
业务系统盘亏数据列表
必填
deptNo
string
eclp系统--事业部编码
可选
checkStockNo
string
eclp系统--盘亏单号
可选
warehouseId
string
eclp系统--库房编号
可选
createTime
int
创建时间(unix时间戳,单位毫秒)
可选
details
array
商品数据列表
可选
goodsNo
string
eclp系统--商品编码
可选
goodsName
string
eclp系统--商品名称
可选
productLevel
string
eclp系统--商品等级
可选
diffQty
int
盘亏数量
可选
oneLevelReason
string
一级差异原因； 示例：1193||库存差异
可选
twoLevelReason
string
二级差异原因； 示例：1195||盘点差异
可选
threeLevelReason
string
三级差异原因；示例：1196||盘点
可选
batchInfoMap
object
商品批属性数据字典
可选
production_date_lot
string
生产日期；格式：yyyy-MM-dd
可选
expiration_date_lot
string
到期日期；格式：yyyy-MM-dd
可选
isPo
string(200)
采购单号
可选
isSupplier
string(200)
供应商
可选
isRcvDate
date
收货日期
可选
isPLU
string(200)
plu管理批属性
可选
isLogisticCompany
string(200)
物流公司
可选
isOrigin
string(200)
原产地
可选
isLot
string(200)
批号
可选
isManufacturer
string(200)
制造商
可选
isPackageBatch
string(200)
包装批号
可选
isBoxNo
string(200)
箱号属性
可选
isNosale
string(200)
不可售属性
可选
gysgL
string(200)
供应商管理
可选
isStore
string(200)
门店
可选

请求示例

`url示例:` --- > https://api.jd.com/routerjson?method=jingdong.eclp.checkstock.queryCheckStockLosses&app_key=**++{{app_key值}}++**&access_token=**++{{access_token值}}++**& timestamp=**++{{请求时间}}++**&format=json&v=2.0&sign_method=**md5**&sign=**++{{签名值}}++** `Request Body示例:` --- ```json 360buy_param_json={ "deptNo":"EBU4418046558657", "pageNo":"1", "pageSize":"50", "startTime":"2020-10-01", "endTime":"2020-10-14" } ```

响应示例

`成功示例:` --- ```json { "jingdong_eclp_checkstock_queryCheckStockLosses_responce": { "code": "0", "checkstocklossesList": [ { "deptNo": "EBU4418046558657", "createTime": 1591603745000, "checkStockNo": "CL0100342006080000001", "details": [ { "oneLevelReason": "1193||库存差异", "productLevel": "200", "batchInfoMap": { "expiration_date_lot": "2021-06-02", "production_date_lot": "2019-12-03" }, "threeLevelReason": "1196||盘点", "twoLevelReason": "1195||盘点差异", "goodsNo": "EMG4418079101719", "diffQty": 1, "goodsName": "合生元益生菌冲剂(儿童型)5袋装" }, { "oneLevelReason": "1193||库存差异", "productLevel": "200", "batchInfoMap": { "expiration_date_lot": "2021-06-25", "production_date_lot": "2019-12-26" }, "threeLevelReason": "1196||盘点", "twoLevelReason": "1195||盘点差异", "goodsNo": "EMG4418079102473", "diffQty": 10, "goodsName": "合生元益生菌冲剂(儿童型)26袋装" }, { "oneLevelReason": "1193||库存差异", "productLevel": "200", "batchInfoMap": { "expiration_date_lot": "2022-12-07", "production_date_lot": "2019-12-08" }, "threeLevelReason": "1196||盘点", "twoLevelReason": "1195||盘点差异", "goodsNo": "EMG4418088302593", "diffQty": 2, "goodsName": "合生元贝塔星较大婴儿配方奶粉 900g" }, { "oneLevelReason": "1193||库存差异", "productLevel": "200", "batchInfoMap": { "expiration_date_lot": "2022-10-19", "production_date_lot": "2019-10-20" }, "threeLevelReason": "1196||盘点", "twoLevelReason": "1195||盘点差异", "goodsNo": "EMG4418088545176", "diffQty": 17, "goodsName": "合生元派星婴儿配方奶粉 （400克）" }, { "oneLevelReason": "1193||库存差异", "productLevel": "200", "batchInfoMap": { "expiration_date_lot": "2022-02-20", "production_date_lot": "2020-02-21" }, "threeLevelReason": "1196||盘点", "twoLevelReason": "1195||盘点差异", "goodsNo": "EMG4418105745599", "diffQty": 1, "goodsName": "合生元可贝思幼儿配方羊奶粉800克 /罐" }, { "oneLevelReason": "1193||库存差异", "productLevel": "200", "batchInfoMap": { "expiration_date_lot": "2022-09-25", "production_date_lot": "2019-09-26" }, "threeLevelReason": "1196||盘点", "twoLevelReason": "1195||盘点差异", "goodsNo": "EMG4418088301651", "diffQty": 3, "goodsName": "合生元贝塔星婴儿配方奶粉 900g" }, { "oneLevelReason": "1193||库存差异", "productLevel": "200", "batchInfoMap": { "expiration_date_lot": "2022-12-20", "production_date_lot": "2019-12-21" }, "threeLevelReason": "1196||盘点", "twoLevelReason": "1195||盘点差异", "goodsNo": "EMG4418088302190", "diffQty": 5, "goodsName": "合生元派星较大婴儿配方奶粉 900g" }, { "oneLevelReason": "1193||库存差异", "productLevel": "200", "batchInfoMap": { "expiration_date_lot": "2022-12-01", "production_date_lot": "2019-12-02" }, "threeLevelReason": "1196||盘点", "twoLevelReason": "1195||盘点差异", "goodsNo": "EMG4418088545172", "diffQty": 31, "goodsName": "合生元派星幼儿配方奶粉 900g" }, { "oneLevelReason": "1193||库存差异", "productLevel": "200", "batchInfoMap": { "expiration_date_lot": "2021-09-13", "production_date_lot": "2018-09-14" }, "threeLevelReason": "1196||盘点", "twoLevelReason": "1195||盘点差异", "goodsNo": "EMG4418088301675", "diffQty": 1, "goodsName": "合生元阿尔法星婴儿配方奶粉400克 /罐" }, { "oneLevelReason": "1193||库存差异", "productLevel": "200", "batchInfoMap": { "expiration_date_lot": "2021-09-07", "production_date_lot": "2020-03-09" }, "threeLevelReason": "1196||盘点", "twoLevelReason": "1195||盘点差异", "goodsNo": "EMG4418088302178", "diffQty": 3, "goodsName": "合生元儿童益生菌粉48袋装 通用型号" }, { "oneLevelReason": "1193||库存差异", "productLevel": "200", "batchInfoMap": { "expiration_date_lot": "2022-02-09", "production_date_lot": "2020-02-10" }, "threeLevelReason": "1196||盘点", "twoLevelReason": "1195||盘点差异", "goodsNo": "EMG4418105745595", "diffQty": 2, "goodsName": "合生元可贝思婴儿配方羊奶粉800克 /罐" }, { "oneLevelReason": "1193||库存差异", "productLevel": "200", "batchInfoMap": { "expiration_date_lot": "2022-10-17", "production_date_lot": "2019-10-18" }, "threeLevelReason": "1196||盘点", "twoLevelReason": "1195||盘点差异", "goodsNo": "EMG4418088302585", "diffQty": 1, "goodsName": "合生元贝塔星较大婴儿配方奶粉 （400克）" }, { "oneLevelReason": "1193||库存差异", "productLevel": "200", "batchInfoMap": { "expiration_date_lot": "2022-08-28", "production_date_lot": "2019-08-29" }, "threeLevelReason": "1196||盘点", "twoLevelReason": "1195||盘点差异", "goodsNo": "EMG4418088302589", "diffQty": 1, "goodsName": "合生元阿尔法星学龄前儿童配方奶粉 900g" }, { "oneLevelReason": "1193||库存差异", "productLevel": "200", "batchInfoMap": { "expiration_date_lot": "2021-09-10", "production_date_lot": "2018-09-11" }, "threeLevelReason": "1196||盘点", "twoLevelReason": "1195||盘点差异", "goodsNo": "EMG4418088545184", "diffQty": 11, "goodsName": "合生元阿尔法星较大婴儿配方奶粉400克 /罐" } ], "warehouseId": "110001869" }, { "deptNo": "EBU4418046558657", "createTime": 1595571421000, "checkStockNo": "CL0100342007240000003", "details": [ { "oneLevelReason": "1193||库存差异", "productLevel": "200", "threeLevelReason": "1196||盘点", "twoLevelReason": "1195||盘点差异", "goodsNo": "EMG4418113735677", "diffQty": 2, "goodsName": "迪士尼冰雪奇缘云毯" }, { "oneLevelReason": "1193||库存差异", "productLevel": "200", "batchInfoMap": { "expiration_date_lot": "2021-12-28", "production_date_lot": "2018-12-29" }, "threeLevelReason": "1196||盘点", "twoLevelReason": "1195||盘点差异", "goodsNo": "EMG4418093147594", "diffQty": 1, "goodsName": "Dodie Air 柔成长裤 L 32片/包" }, { "oneLevelReason": "1193||库存差异", "productLevel": "200", "threeLevelReason": "1196||盘点", "twoLevelReason": "1195||盘点差异", "goodsNo": "EMG4418098039367", "diffQty": 6, "goodsName": "Carat钻石多用锅 2.0L象牙白" }, { "oneLevelReason": "1193||库存差异", "productLevel": "200", "batchInfoMap": { "expiration_date_lot": "2023-04-13", "production_date_lot": "2020-04-13" }, "threeLevelReason": "1196||盘点", "twoLevelReason": "1195||盘点差异", "goodsNo": "EMG4418106361023", "diffQty": 1, "goodsName": "Dodie 亲薄柔护 · 日款婴儿纸尿裤（初生柔）S码18片 18片/包" } ], "warehouseId": "110001869" }, { "deptNo": "EBU4418046558657", "createTime": 1596445140000, "checkStockNo": "CL0100342008030000001", "details": [ { "oneLevelReason": "1193||库存差异", "productLevel": "200", "threeLevelReason": "1196||盘点", "twoLevelReason": "1195||盘点差异", "goodsNo": "EMG4418112124205", "diffQty": 50000, "goodsName": "新手父母扫盲指南" } ], "warehouseId": "110001869" } ] } } ``` `失败示例:` --- ```json { "jingdong_eclp_checkstock_queryCheckStockLosses_responce": { "code": "0", "checkstocklossesList": null } } ``` `异常示例:` --- ```json { "error_response": { "code": "null 3,107", "zh_desc": "盘点系统 参数：事业部编码，解析错误，请检查数据（解决方案参考：http://open.jd.com/home/home#/doc/common?listId=533）", "en_desc": "null 3,107(Solution reference:http://open.jd.com/home/home#/doc/common?listId=533)" } } ```
上一篇 1.查询盘盈记录
nextDoc 1.店铺库存查询
本文档使用易文档编写, 更新时间: 2022-08-17 10:58