文档
测试

盘点盈亏记账单-单据明细

websocket测试
POST
http://172.16.4.219:8181/ampOpenapiService?method=istktake.stktakeplacc.search&token=d055bd9b-e5a9-4336-a911-7d23fca84591

接口描述

盘点盈亏记账单-单据明细

请求参数

参数名
类型
描述
params
object
过滤条件
sheetid
string
单据编号
dbsplitcode
string
分库串
orderBy
string
示例：sheetid
pageNo
int
页码
pageSize
int
每页数据条数
condition
string
示例：sheetid like '${sheetid}' and dbsplitcode = '${dbsplitcode}'

响应参数

参数名
类型
描述
data
object
数据字典
pageCount
int
总页数
total
int
总条数
pageNo
int
页码
pageSize
int
每页数据条数
pageData
array
数据列表
bussgdid
string
商品编码
entid
string
企业ID
sampleflag
int
样品标志(1=样品)
directflag
int
借贷方向(+1=Dr -1=Cr)
gdid
string
商品编码
saletaxrate
int
销项税率
price
float
售价
paytypeid
int
结算方式编码
sheetid
string
单据编号
id
int
示例：4739759561737216
paytypename
string
结算方式名称
barcode
string
商品条码
gdstkmode
int
库存管理维度(0=按照SPU管理 1=SKU管理)
gdname
string
商品名称
colorid
string
示例：
costtaxrate
int
进项税率
bussgdskuid
string
skuid
venderid
string
供应商编码
fromshopid
string
机构编码
ksid
string
示例：
netcost
float
不含税成本
contracttype
int
合同性质(lookup表定义(bizflag))1=购销 2=代销 3=联营 4=租赁)
giftflag
int
赠品标志(0=正常商品 1=赠品)
qty
int
盈亏数量
runtype
int
经营方式
fromshopname
string
机构名称
isfresh
int
是否生鲜(0=常温 1=生鲜)
oldcost
float
原进价
shopid
string
机构编码
netcostvalue
float
不含税金额
vendername
string
供应商名称
batchno
string
生产批号
popflag
int
促销标志(0=正常批次 1=促销批次)
instkno
string
首次入库单号
logistics
int
物流模式(1=直送 2=直通 3=配送)
contno
string
合同号
placename
string
存货地名称
goodscostid
int
批次号
instkdate
int
首次入库日期
fvenderid
string
对应采购供应商编码
dbsplitcode
string
分库特征码
categoryid
int
类别编码
costvalue
float
金额
rowno
int
行号
sizeid
string
尺码(辅助信息)
cost
float
进价
localflag
int
采购级别(0=统采 2=联采 3=地采)
placeid
string
存货地编码
purdate
int
生产日期
validdate
int
到期日期
gdskuid
string
核算skuid
shopname
string
机构名称
categoryname
string
类别名称
inflag
int
出入库标识(0=出库 1=入库)
fvendername
string
对应采购供应商名称
returncode
string
示例：0

请求示例

```json { "params": { "sheetid": "PD92022042700001%", "dbsplitcode": "1001" }, "orderBy": "sheetid", "pageNo": 1, "pageSize": 100000, "condition": "sheetid like '${sheetid}' and dbsplitcode = '${dbsplitcode}'" } ```

响应示例

```json { "data": { "pageCount": 1, "total": 3, "pageNo": 1, "pageSize": 100000, "pageData": [{ "bussgdid": "2761", "entid": "1", "sampleflag": 0, "gdid": "2761", "directflag": 1, "saletaxrate": 13, "price": 8.5, "paytypeid": 2, "sheetid": "PD92022042700001-1", "id": 4739759561737216, "paytypename": "购销月结0天", "barcode": "6902265120506", "gdname": "海天金标生抽王酱油N3", "gdstkmode": 0, "colorid": "", "costtaxrate": 13, "bussgdskuid": "00027610001", "venderid": "1606", "fromshopid": "M025", "ksid": "", "netcost": 5.7788, "contracttype": 1, "giftflag": 0, "qty": 60, "runtype": 0, "fromshopname": "绿篮子南山郡店", "isfresh": 0, "oldcost": 6.53, "shopid": "M025", "netcostvalue": 346.73, "vendername": "六安市闻生调味食品有限公司", "batchno": "", "popflag": 0, "instkno": "", "logistics": 3, "contno": "20201229160600001", "placename": "", "goodscostid": 1094606, "instkdate": 1650988800000, "fvenderid": "1606", "dbsplitcode": "1001", "categoryid": 2010201, "costvalue": 391.8, "rowno": 1, "sizeid": "", "cost": 6.53, "localflag": 0, "placeid": "000000", "purdate": 1650988800000, "validdate": 1650988800000, "gdskuid": "2761", "shopname": "", "categoryname": "", "inflag": 0, "fvendername": "六安市闻生调味食品有限公司" }, { "bussgdid": "2769", "entid": "1", "sampleflag": 0, "gdid": "2769", "directflag": 1, "saletaxrate": 13, "price": 9.5, "paytypeid": 2, "sheetid": "PD92022042700001-1", "id": 4739759562228736, "paytypename": "购销月结0天", "barcode": "6902265210504", "gdname": "海天草菇老抽酱油N3", "gdstkmode": 0, "colorid": "", "costtaxrate": 13, "bussgdskuid": "00027690001", "venderid": "1606", "fromshopid": "M025", "ksid": "", "netcost": 6.4691, "contracttype": 1, "giftflag": 0, "qty": 22, "runtype": 0, "fromshopname": "绿篮子南山郡店", "isfresh": 0, "oldcost": 7.31, "shopid": "M025", "netcostvalue": 142.32, "vendername": "六安市闻生调味食品有限公司", "batchno": "", "popflag": 0, "instkno": "", "logistics": 3, "contno": "20201229160600001", "placename": "", "goodscostid": 1094607, "instkdate": 1650988800000, "fvenderid": "1606", "dbsplitcode": "1001", "categoryid": 2010201, "costvalue": 160.82, "rowno": 2, "sizeid": "", "cost": 7.31, "localflag": 0, "placeid": "000000", "purdate": 1650988800000, "validdate": 1650988800000, "gdskuid": "2769", "shopname": "", "categoryname": "", "inflag": 0, "fvendername": "六安市闻生调味食品有限公司" }, { "bussgdid": "9159", "entid": "1", "sampleflag": 0, "gdid": "9159", "directflag": 1, "saletaxrate": 13, "price": 13.9, "paytypeid": 2, "sheetid": "PD92022042700001-1", "id": 4739759562343424, "paytypename": "购销月结0天", "barcode": "6931299062681", "gdname": "鲁花自然鲜原味酱油", "gdstkmode": 0, "colorid": "", "costtaxrate": 13, "bussgdskuid": "00091590001", "venderid": "1864", "fromshopid": "M025", "ksid": "", "netcost": 9.1151, "contracttype": 1, "giftflag": 0, "qty": 122, "runtype": 0, "fromshopname": "绿篮子南山郡店", "isfresh": 0, "oldcost": 10.3, "shopid": "M025", "netcostvalue": 1112.04, "vendername": "安徽舜臣贸易有限公司", "batchno": "", "popflag": 0, "instkno": "", "logistics": 3, "contno": "20201229186400001", "placename": "", "goodscostid": 1094608, "instkdate": 1650988800000, "fvenderid": "1864", "dbsplitcode": "1001", "categoryid": 2010201, "costvalue": 1256.6, "rowno": 3, "sizeid": "", "cost": 10.3, "localflag": 0, "placeid": "000000", "purdate": 1650988800000, "validdate": 1650988800000, "gdskuid": "9159", "shopname": "", "categoryname": "", "inflag": 0, "fvendername": "安徽舜臣贸易有限公司" }] }, "returncode": "0" } ```
上一篇 盘点盈亏记账单-查询
nextDoc 盘点盈亏总查询-查询
本文档使用易文档编写, 更新时间: 2022-05-16 10:33