文档
测试

商品盘点明细查询-查询

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

接口描述

商品盘点明细查询-查询

请求参数

参数名
类型
描述
params
object
过滤条件
shopid
string
机构编码
planid
string
盘点计划编码
placeid
string
存货地编码
bdate
string
盘点日期(起)
edate
string
盘点日期(止)
categoryid
string
类别编码
gdid
string
商品编码
barcode
string
商品条码
inputflag
string
录入标识(0=非录入 1=录入)
condition
string
示例:shopid = '${shopid}' and planid = '${planid}' and placeid = '${placeid}' and pdate >= '${bdate}' and pdate <= '${edate}' and categoryid = '${categoryid}' and gdid = '${gdid}' and barcode = '${barcode}' 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
帐面金额(含税)
cost
int
进价
costtaxrate
int
进项税率
pdate
int
盘点日期
gdid
string
商品编号
placeid
string
存货地编码
ccostvalue
float
帐面金额(含税)
saletaxrate
int
销项税率
placename
string
存货地名称
realcostvalue
float
盘点成本金额
realqty
float
核算码实盘数量(非子母码等于实盘数量,子母码要转换)
gdskuid
string
用于以后扩展,按skuid录入盘点范围
qty
int
打印数量
shopname
string
机构名称
planname
string
盘点计划名称
categoryname
string
类别名称
planid
string
盘点计划编码
shopid
string
机构编码
goodsspec
string
商品规格
barcode
string
商品条码
cqty
float
帐面数量
netrealcostvalue
float
示例:-26.55
categoryid
int
类别编码
gdname
string
商品名称
returncode
string
示例:0

请求示例

```json { "params": { "shopid": "M025", "planid": "PD32021042700009", "placeid": "000000", "bdate": "2020-01-01", "edate": "2022-04-30", "categoryid": "2020202", "gdid": "17763", "barcode": "231776300000", "inputflag": "0" }, "condition": "shopid = '${shopid}' and planid = '${planid}' and placeid = '${placeid}' and pdate >= '${bdate}' and pdate <= '${edate}' and categoryid = '${categoryid}' and gdid = '${gdid}' and barcode = '${barcode}' and inputflag = '${inputflag}' ", "orderBy": "pdate desc", "pageNo": 1, "pageSize": 30 } ```

响应示例

```json { "data": { "pageCount": 1, "total": 1, "pageNo": 1, "pageSize": 30, "pageData": [{ "costvalue": 0, "realcostvalue": -28.94, "realqty": -0.998, "qty": 0, "ccostvalue": -28.94, "cqty": -0.998, "netrealcostvalue": -26.55 }, { "costvalue": 0.00, "cost": 29.00, "costtaxrate": 9.0000, "pdate": 1619452800000, "gdid": "17763", "placeid": "000000", "ccostvalue": -28.94, "saletaxrate": 9.0000, "placename": "卖场", "realcostvalue": -28.94, "realqty": -0.998, "gdskuid": "17763", "qty": 0.000, "shopname": "绿篮子南山郡店", "planname": "CESHI111", "categoryname": "散称杂粮", "planid": "PD32021042700009", "shopid": "M025", "goodsspec": "KG", "barcode": "231776300000", "cqty": -0.998, "netrealcostvalue": -26.55, "categoryid": 2020202, "gdname": "黑芝麻粉散称BN" }] }, "returncode": "0" } ```