文档
测试

盘点检查报表-查询

POST
http://172.16.4.219:8181/ampOpenapiService?method=istktake.stktakerptcheckinput.search&token=fa119020-983b-4dc3-87cd-64f8789d88ba

接口描述

盘点录入单单据汇总-查询

请求参数

参数名
类型
描述
condition
string
示例:shopid = '${shopid}' and shopname = '${shopname}' and planid = '${planid}' and planname = '${planname}' and placeid = '${placeid}' and placename = '${placename}' and categoryid like '${categoryid}' and categoryname = '${categoryname}' and gdid = '${gdid}' and skuid = '${skuid}' and gdname = '${gdname}' and stktype = '${stktype}' and displaytype = '${displaytype}' and filterzeroflag = '${fil...
params
object
筛选条件
shopid
string
机构编码
shopname
string
机构名称
planid
string
盘点计划编码
planname
string
盘点计划名称
placeid
string
存货地编码
placename
string
存货地名称
categoryid
string
类别编码
categoryname
string
类别名称
gdid
string
商品编码
skuid
string
skuid
gdname
string
商品名称
stktype
string
盘点类型(1=初盘 2=复盘)
displaytype
string
展示类型(0=正常 1=漏盘 2=错盘)
filterzeroflag
int
过滤账存实盘为0的(0=不过滤 1=过滤)
orderBy
string
示例:planid desc
pageNo
int
页码
pageSize
int
每页数据条数

响应参数

参数名
类型
描述
data
object
数据字典
pageCount
int
总页数
total
int
总条数
pageNo
int
页码
pageSize
int
每页数据条数
pageData
array
数据列表
diffsalevalue
int
差异金额
displaytype
int
展示类型(0=正常 1=漏盘 2=错盘)
sheetsum
int
盘点单据数
bussgdid
string
商品编码
entid
string
企业ID
gdid
string
核算商品编码
ccostvalue
float
账存成本金额
absdiffqty
int
绝对差异数量
placename
string
存货地名称
qtydiffrate
int
数量差异率
diffcostvalue
float
差异成本金额
cskusum
int
账存品种数
realcostvalue
int
盘点成本金额
realskusum
int
盘点品种数
unitname
string
销售单位
barcode
string
商品条码
planname
string
盘点计划名称
cqty
int
账存数量
stktype
int
盘点类型(1=初盘 2=复盘)
categoryid
int
类别编码
gdname
string
商品名称
bussgdskuid
string
skuid
placeid
string
存货地编码
costvaluediffrate
int
成本金额差异率
realqty
int
核算码实盘数量(非子母码等于实盘数量,子母码要转换)
gdskuid
string
核算skuid
shopname
string
机构名称
diffqty
int
差异数量
categoryname
string
类别名称
planid
string
盘点计划编号
shopid
string
机构编码
goodsspec
string
销售规格
returncode
string
示例:0

请求示例

```json { "condition": "shopid = '${shopid}' and shopname = '${shopname}' and planid = '${planid}' and planname = '${planname}' and placeid = '${placeid}' and placename = '${placename}' and categoryid like '${categoryid}' and categoryname = '${categoryname}' and gdid = '${gdid}' and skuid = '${skuid}' and gdname = '${gdname}' and stktype = '${stktype}' and displaytype = '${displaytype}' and filterzeroflag = '${filterzeroflag}' ", "params": { "shopid": "M025", "shopname": "绿篮子南山郡店", "planid": "PD22021051000001", "planname": "M025测试", "placeid": "000000", "placename": "卖场", "categoryid": "2030101%", "categoryname": "冷藏酸奶", "gdid": "10393", "skuid": "10393", "gdname": "伊利红枣味8连杯酸奶", "stktype": "1", "displaytype": "1", "filterzeroflag": 1 }, "orderBy": "planid desc", "pageNo": 1, "pageSize": 30 } ```

响应示例

```json { "data": { "pageCount": 1, "total": 1, "pageNo": 1, "pageSize": 30, "pageData": [{ "diffsalevalue": 0, "realcostvalue": 0, "realqty": 0, "diffqty": 1, "ccostvalue": -13.4, "cqty": -1, "diffcostvalue": 13.4 }, { "diffsalevalue": 0, "displaytype": 1, "sheetsum": 0, "bussgdid": "10393", "entid": "1", "gdid": "10393", "absdiffqty": 1, "ccostvalue": -13.4, "placename": "卖场", "qtydiffrate": -1, "diffcostvalue": 13.4, "cskusum": 16857, "realcostvalue": 0, "realskusum": 0, "unitname": "板", "planname": "M025测试", "barcode": "6907992103549", "cqty": -1, "stktype": 1, "categoryid": 2030101, "gdname": "伊利红枣味8连杯酸奶", "bussgdskuid": "10393", "placeid": "000000", "costvaluediffrate": -1, "realqty": 0, "gdskuid": "10393", "shopname": "绿篮子南山郡店", "diffqty": 1, "categoryname": "冷藏酸奶", "planid": "PD22021051000001", "shopid": "M025", "goodsspec": "100G*8" }] }, "returncode": "0" } ```