文档
测试

盘点汇总查询报表-查询

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

接口描述

盘点汇总查询报表-查询

请求参数

参数名
类型
描述
params
object
过滤条件
shopid
string
机构编码
planid
string
盘点计划编码
deptlevel
string
类别级次
bdate
string
盘点日期(起)
edate
string
盘点日期(止)
categoryid
int
类别编码
inputflag
string
录入标示(0-非录入|1-录入)
condition
string
示例:shopid = '${shopid}' and planid = '${planid}' and deptlevel = '${deptlevel}' and pdate >= '${bdate}' and pdate <= '${edate}' and categoryid = '${categoryid}' and inputflag = '${inputflag}'
orderBy
string
示例:pdate desc
pageNo
int
页码
pageSize
int
每页数据条数

响应参数

参数名
类型
描述
data
object
数据字典
pageCount
int
总页数
total
int
总条数
pageNo
int
页码
pageSize
int
每页条数
pageData
array
数据列表
costvalue
int
含税金额
costtaxrate
int
进项税率
pdate
int
盘点日期
ccostvalue
float
账存成本金额
netccostvalue
float
示例:-15.75
realcostvalue
float
实盘金额(含税)
realqty
int
核算码实盘数量(非子母码等于实盘数量,子母码要转换)
qty
int
打印数量
shopname
string
机构名称
planname
string
盘点计划名称
categoryname
string
类别名称
planid
string
盘点计划编码
shopid
string
机构编码
netcostvalue
int
示例:0
cqty
int
帐存数量
netrealcostvalue
float
示例:-15.75
categoryid
string
类别编码
returncode
string
示例:0

请求示例

```json { "params": { "shopid": "M025", "planid": "PD32021042700009", "deptlevel": "4", "bdate": "2020-01-01", "edate": "2022-04-27", "categoryid": 2010101, "inputflag": "0" }, "condition": "shopid = '${shopid}' and planid = '${planid}' and deptlevel = '${deptlevel}' and pdate >= '${bdate}' and pdate <= '${edate}' and categoryid = '${categoryid}' and inputflag = '${inputflag}' ", "orderBy": "pdate desc", "pageNo": 1, "pageSize": 30 } ```

响应示例

```json { "data": { "pageCount": 1, "total": 1, "pageNo": 1, "pageSize": 30, "pageData": [{ "costvalue": 0, "netccostvalue": -15.75, "realcostvalue": -17.8, "realqty": -2, "qty": 0, "ccostvalue": -17.8, "netcostvalue": 0, "cqty": -2, "netrealcostvalue": -15.75 }, { "costvalue": 0.00, "costtaxrate": 13.0000, "pdate": 1619452800000, "ccostvalue": -17.80, "netccostvalue": -15.75, "realcostvalue": -17.80, "realqty": -2.000, "qty": 0.000, "shopname": "绿篮子南山郡店", "planname": "CESHI111", "categoryname": "调和油", "planid": "PD32021042700009", "shopid": "M025", "netcostvalue": 0.00, "cqty": -2.000, "netrealcostvalue": -15.75, "categoryid": "2010101" }] }, "returncode": "0" } ```