Lingxing
切换旧版

库存报表 - 本地仓 - 新报表 - 明细

POST/inventory/center/openapi/storageReport/local/detail/page

接口信息

API Path请求协议请求方式令牌桶容量
/inventory/center/openapi/storageReport/local/detail/pageHTTPSPOST3

请求参数

offsetinteger必填
分页页码，默认1
lengthinteger必填
分页长度，默认15，不超过100
start_datestring必填
开始时间，格式：Y-m-d
end_datestring必填
结束时间，格式：Y-m-d
sys_widstring
系统仓库id，多个用英文逗号分隔

请求示例

{
    "offset": 1,
    "length": 15,
    "start_date": "2020-01-01",
    "end_date": "2024-08-05",
    "sys_wid": "1268,21"
}

返回结果

Json Object

codeinteger必填
状态码，0 成功
示例 0
messagestring必填
消息
request_idstring必填
请求链路id
示例 c39932cfb78143f48235d2ccbc87cb80
response_timestring必填
响应时间
示例 2022-12-21 18:43:02
totalinteger必填
总数
示例 1
dataarray<object>必填
响应数据
隐藏子属性
sys_widinteger必填
系统仓库ID
示例 1
ware_house_namestring必填
仓库名称
示例 仓库1
seller_namestring必填
店铺名称
示例 店铺2
product_namestring必填
商品名称
示例 [演示数据]Sony ZX系列有线头戴式耳机 黑色 MDR-ZX110
product_typestring必填
产品类型:普通产品
组合产品
辅料
捆绑产品
示例 普通产品
skustring必填
SKU
示例 SKU37E3BFF
fnskustring必填
FNSKU
示例 FND1D7401
spustring必填
SPU
spu_namestring必填
款名
brandstring必填
品牌名称
示例 品牌1
category1string必填
一级类目-名称
示例 分类3
category2string必填
二级类目-名称
category3string必填
三级类目-名称
attribute_textstring必填
库存属性: 全部
可售
待检
不可售
示例 全部
global_tagsarray<any>必填
产品标签列表
sku_attributearray<any>必填
产品属性
allocation_in_costnumber必填
调拨入库-成本（精度：2位小数点）
示例 0
allocation_in_countnumber必填
调拨入库-数量
allocation_in_transit_costnumber必填
期末在途-成本（精度：2位小数点）
示例 0
allocation_in_transit_countnumber必填
期末在途-数量
allocation_out_costnumber必填
调拨出库-成本（精度：2位小数点）
示例 0
allocation_out_countnumber必填
调拨出库-数量
change_of_standard_in_costnumber必填
换标入库-成本（精度：2位小数点）
示例 0
change_of_standard_in_countnumber必填
换标入库-数量
change_of_standard_out_costnumber必填
换标出库-成本（精度：2位小数点）
示例 0
change_of_standard_out_countnumber必填
换标出库-数量
cost_adjustmentnumber必填
成本调整（精度：2位小数点）
示例 0
day_early_costnumber必填
期初库存-成本（精度：2位小数点）
示例 0
day_early_countnumber必填
期初库存-数量
day_end_costnumber必填
期末库存-成本（精度：2位小数点）
示例 0
day_end_countnumber必填
期末库存-数量
fba_out_costnumber必填
fba出库-成本（精度：2位小数点）
示例 0
fba_out_countnumber必填
fba出库-数量
fbm_out_costnumber必填
fbm出库-成本（精度：2位小数点）
示例 0
fbm_out_countnumber必填
fbm出库-数量
inventory_deficit_out_costnumber必填
盘亏出库-成本（精度：2位小数点）
示例 0
inventory_deficit_out_countnumber必填
盘亏出库-数量
inventory_surplus_in_costnumber必填
盘盈入库-成本（精度：2位小数点）
示例 0
inventory_surplus_in_countnumber必填
盘盈入库-数量
other_in_costnumber必填
其他入库-成本（精度：2位小数点）
示例 0
other_in_countnumber必填
其他入库-数量
other_out_costnumber必填
其他出库-成本（精度：2位小数点）
示例 0
other_out_countnumber必填
其他出库-数量
outsourcing_in_costnumber必填
委外入库-成本（精度：2位小数点）
示例 0
outsourcing_in_countnumber必填
委外入库-数量
outsourcing_out_costnumber必填
委外出库-成本（精度：2位小数点）
示例 0
outsourcing_out_countnumber必填
委外出库-数量
processing_in_costnumber必填
加工入库-成本（精度：2位小数点）
示例 0
processing_in_countnumber必填
加工入库-数量
processing_out_costnumber必填
加工出库-成本（精度：2位小数点）
示例 0
processing_out_countnumber必填
加工出库-数量
purchase_in_costnumber必填
采购入库-成本（精度：2位小数点）
示例 0
purchase_in_countnumber必填
采购入库-数量
purchase_return_costnumber必填
退货出库-成本（精度：2位小数点）
示例 0
purchase_return_countnumber必填
退货出库-数量
remove_in_costnumber必填
移除入库-成本（精度：2位小数点）
示例 0
remove_in_countnumber必填
移除入库-数量
return_goods_in_costnumber必填
退货入库-成本（精度：2位小数点）
示例 0
return_goods_in_countnumber必填
退货入库-数量
rotation_day_costnumber必填
周转天数-成本（精度：2位小数点）
示例 0
rotation_day_countnumber必填
周转天数-数量（精度：2位小数点）
示例 0
split_in_costnumber必填
拆分入库-成本（精度：2位小数点）
示例 0
split_in_countnumber必填
拆分入库-数量
split_out_costnumber必填
拆分出库-成本（精度：2位小数点）
示例 0
split_out_countnumber必填
拆分出库-数量
wfs_out_costnumber必填
WFS出库-成本（精度：2位小数点）
示例 0
wfs_out_countnumber必填
WFS出库-数量
gifts_in_costnumber必填
赠品入库-成本（精度：2位小数点）
示例 0
gifts_in_countnumber必填
赠品入库-数量
示例 0
rotation_rate_countnumber必填
周转率-数量（精度：4位小数点）
示例 0
rotation_rate_costnumber必填
周转率-成本（精度：4位小数点）
示例 0
sales_ratio_countnumber必填
存销比-数量（精度：4位小数点）
示例 0
sales_ratio_costnumber必填
存销比-成本（精度：4位小数点）
示例 0
child_listarray<any>必填
子项，与外层列表字段一致-库存状态为全部时会有数据
示例 &nbsp;

返回成功示例

{
    "code": 0,
    "message": "",
    "request_id": "99954c8d8cdc44f0b165331ec2ae7eff",
    "response_time": "2022-12-21 18:52:14",
    "total": 1,
    "data": [
        {
            "other_in_count": 0,
            "purchase_in_count": 0,
            "allocation_in_count": 0,
            "outsourcing_in_count": 0,
            "inventory_surplus_in_count": 0,
            "change_of_standard_in_count": 0,
            "processing_in_count": 0,
            "split_in_count": 0,
            "return_goods_in_count": 0,
            "remove_in_count": 0,
            "outsourcing_out_count": 0,
            "inventory_deficit_out_count": 0,
            "change_of_standard_out_count": 0,
            "processing_out_count": 0,
            "split_out_count": 0,
            "fba_out_count": 0,
            "fbm_out_count": 0,
            "purchase_return_count": 0,
            "allocation_out_count": 0,
            "other_out_count": 0,
            "wfs_out_count": 0,
            "gifts_in_cost": 0,
            "gifts_in_count": 0,
            "day_early_count": 443,
            "day_end_count": 443,
            "allocation_in_transit_count": 0,
            "other_in_cost": "0.00",
            "purchase_in_cost": "0.00",
            "allocation_in_cost": "0.00",
            "outsourcing_in_cost": "0.00",
            "inventory_surplus_in_cost": "0.00",
            "change_of_standard_in_cost": "0.00",
            "processing_in_cost": "0.00",
            "split_in_cost": "0.00",
            "return_goods_in_cost": "0.00",
            "remove_in_cost": "0.00",
            "outsourcing_out_cost": "0.00",
            "inventory_deficit_out_cost": "0.00",
            "change_of_standard_out_cost": "0.00",
            "processing_out_cost": "0.00",
            "split_out_cost": "0.00",
            "fba_out_cost": "0.00",
            "fbm_out_cost": "0.00",
            "purchase_return_cost": "0.00",
            "allocation_out_cost": "0.00",
            "other_out_cost": "0.00",
            "wfs_out_cost": "0.00",
            "day_early_cost": "0.00",
            "day_end_cost": "0.00",
            "allocation_in_transit_cost": "0.00",
            "cost_adjustment": "0.00",
            "rotation_day_count": "0.00",
            "rotation_rate_count": "0.0000",
            "sales_ratio_count": "0.0000",
            "rotation_day_cost": "0.00",
            "rotation_rate_cost": "0.0000",
            "sales_ratio_cost": "0.0000",
            "seller_name": null,
            "sys_wid": null,
            "ware_house_name": "仓库1",
            "brand": null,
            "product_name": "[演示数据]适用于iPad的手写笔带手掌柜绝",
            "spu": "",
            "spu_name": "",
            "sku": "SKU1991FC9",
            "fnsku": "",
            "category1": null,
            "category2": null,
            "category3": null,
            "global_tags": null,
            "product_type": "普通产品",
            "sku_attribute": null,
            "attribute_text": "全部",
            "child_list": [
                {
                    "other_in_count": 0,
                    "purchase_in_count": 0,
                    "allocation_in_count": 0,
                    "outsourcing_in_count": 0,
                    "inventory_surplus_in_count": 0,
                    "change_of_standard_in_count": 0,
                    "processing_in_count": 0,
                    "split_in_count": 0,
                    "return_goods_in_count": 0,
                    "remove_in_count": 0,
                    "outsourcing_out_count": 0,
                    "inventory_deficit_out_count": 0,
                    "change_of_standard_out_count": 0,
                    "processing_out_count": 0,
                    "split_out_count": 0,
                    "fba_out_count": 0,
                    "fbm_out_count": 0,
                    "purchase_return_count": 0,
                    "allocation_out_count": 0,
                    "other_out_count": 0,
                    "wfs_out_count": 0,
                    "gifts_in_cost": 0,
                    "gifts_in_count": 0,
                    "day_early_count": 440,
                    "day_end_count": 440,
                    "allocation_in_transit_count": 0,
                    "other_in_cost": "0.00",
                    "purchase_in_cost": "0.00",
                    "allocation_in_cost": "0.00",
                    "outsourcing_in_cost": "0.00",
                    "inventory_surplus_in_cost": "0.00",
                    "change_of_standard_in_cost": "0.00",
                    "processing_in_cost": "0.00",
                    "split_in_cost": "0.00",
                    "return_goods_in_cost": "0.00",
                    "remove_in_cost": "0.00",
                    "outsourcing_out_cost": "0.00",
                    "inventory_deficit_out_cost": "0.00",
                    "change_of_standard_out_cost": "0.00",
                    "processing_out_cost": "0.00",
                    "split_out_cost": "0.00",
                    "fba_out_cost": "0.00",
                    "fbm_out_cost": "0.00",
                    "purchase_return_cost": "0.00",
                    "allocation_out_cost": "0.00",
                    "other_out_cost": "0.00",
                    "wfs_out_cost": "0.00",
                    "day_early_cost": "0.00",
                    "day_end_cost": "0.00",
                    "allocation_in_transit_cost": "0.00",
                    "cost_adjustment": "0.00",
                    "rotation_day_count": "0.00",
                    "rotation_rate_count": "0.0000",
                    "sales_ratio_count": "0.0000",
                    "rotation_day_cost": "0.00",
                    "rotation_rate_cost": "0.0000",
                    "sales_ratio_cost": "0.0000",
                    "seller_name": null,
                    "sys_wid": null,
                    "ware_house_name": "仓库1",
                    "brand": null,
                    "product_name": "[演示数据]适用于iPad的手写笔带手掌柜绝",
                    "spu": "",
                    "spu_name": "",
                    "sku": "SKU1991FC9",
                    "fnsku": "",
                    "category1": null,
                    "category2": null,
                    "category3": null,
                    "global_tags": null,
                    "product_type": "普通产品",
                    "sku_attribute": null,
                    "attribute_text": "可售",
                    "child_list": null
                },
                {
                    "other_in_count": 0,
                    "purchase_in_count": 0,
                    "allocation_in_count": 0,
                    "outsourcing_in_count": 0,
                    "inventory_surplus_in_count": 0,
                    "change_of_standard_in_count": 0,
                    "processing_in_count": 0,
                    "split_in_count": 0,
                    "return_goods_in_count": 0,
                    "remove_in_count": 0,
                    "outsourcing_out_count": 0,
                    "inventory_deficit_out_count": 0,
                    "change_of_standard_out_count": 0,
                    "processing_out_count": 0,
                    "split_out_count": 0,
                    "fba_out_count": 0,
                    "fbm_out_count": 0,
                    "purchase_return_count": 0,
                    "allocation_out_count": 0,
                    "other_out_count": 0,
                    "wfs_out_count": 0,
                    "day_early_count": 0,
                    "day_end_count": 0,
                    "allocation_in_transit_count": 0,
                    "other_in_cost": "0.00",
                    "purchase_in_cost": "0.00",
                    "allocation_in_cost": "0.00",
                    "outsourcing_in_cost": "0.00",
                    "inventory_surplus_in_cost": "0.00",
                    "change_of_standard_in_cost": "0.00",
                    "processing_in_cost": "0.00",
                    "split_in_cost": "0.00",
                    "return_goods_in_cost": "0.00",
                    "remove_in_cost": "0.00",
                    "outsourcing_out_cost": "0.00",
                    "inventory_deficit_out_cost": "0.00",
                    "change_of_standard_out_cost": "0.00",
                    "processing_out_cost": "0.00",
                    "split_out_cost": "0.00",
                    "fba_out_cost": "0.00",
                    "fbm_out_cost": "0.00",
                    "purchase_return_cost": "0.00",
                    "allocation_out_cost": "0.00",
                    "other_out_cost": "0.00",
                    "wfs_out_cost": "0.00",
                    "day_early_cost": "0.00",
                    "day_end_cost": "0.00",
                    "allocation_in_transit_cost": "0.00",
                    "cost_adjustment": "0.00",
                    "rotation_day_count": "0.00",
                    "rotation_rate_count": "0.0000",
                    "sales_ratio_count": "0.0000",
                    "rotation_day_cost": "0.00",
                    "rotation_rate_cost": "0.0000",
                    "sales_ratio_cost": "0.0000",
                    "seller_name": null,
                    "sys_wid": null,
                    "ware_house_name": "仓库1",
                    "brand": null,
                    "product_name": "[演示数据]适用于iPad的手写笔带手掌柜绝",
                    "spu": "",
                    "spu_name": "",
                    "sku": "SKU1991FC9",
                    "fnsku": "",
                    "category1": null,
                    "category2": null,
                    "category3": null,
                    "global_tags": null,
                    "product_type": "普通产品",
                    "sku_attribute": null,
                    "attribute_text": "待检",
                    "child_list": null
                },
                {
                    "other_in_count": 0,
                    "purchase_in_count": 0,
                    "allocation_in_count": 0,
                    "outsourcing_in_count": 0,
                    "inventory_surplus_in_count": 0,
                    "change_of_standard_in_count": 0,
                    "processing_in_count": 0,
                    "split_in_count": 0,
                    "return_goods_in_count": 0,
                    "remove_in_count": 0,
                    "outsourcing_out_count": 0,
                    "inventory_deficit_out_count": 0,
                    "change_of_standard_out_count": 0,
                    "processing_out_count": 0,
                    "split_out_count": 0,
                    "fba_out_count": 0,
                    "fbm_out_count": 0,
                    "purchase_return_count": 0,
                    "allocation_out_count": 0,
                    "other_out_count": 0,
                    "wfs_out_count": 0,
                    "day_early_count": 3,
                    "day_end_count": 3,
                    "allocation_in_transit_count": 0,
                    "other_in_cost": "0.00",
                    "purchase_in_cost": "0.00",
                    "allocation_in_cost": "0.00",
                    "outsourcing_in_cost": "0.00",
                    "inventory_surplus_in_cost": "0.00",
                    "change_of_standard_in_cost": "0.00",
                    "processing_in_cost": "0.00",
                    "split_in_cost": "0.00",
                    "return_goods_in_cost": "0.00",
                    "remove_in_cost": "0.00",
                    "outsourcing_out_cost": "0.00",
                    "inventory_deficit_out_cost": "0.00",
                    "change_of_standard_out_cost": "0.00",
                    "processing_out_cost": "0.00",
                    "split_out_cost": "0.00",
                    "fba_out_cost": "0.00",
                    "fbm_out_cost": "0.00",
                    "purchase_return_cost": "0.00",
                    "allocation_out_cost": "0.00",
                    "other_out_cost": "0.00",
                    "wfs_out_cost": "0.00",
                    "day_early_cost": "0.00",
                    "day_end_cost": "0.00",
                    "allocation_in_transit_cost": "0.00",
                    "cost_adjustment": "0.00",
                    "rotation_day_count": "0.00",
                    "rotation_rate_count": "0.0000",
                    "sales_ratio_count": "0.0000",
                    "rotation_day_cost": "0.00",
                    "rotation_rate_cost": "0.0000",
                    "sales_ratio_cost": "0.0000",
                    "seller_name": null,
                    "sys_wid": null,
                    "ware_house_name": "仓库1",
                    "brand": null,
                    "product_name": "[演示数据]适用于iPad的手写笔带手掌柜绝",
                    "spu": "",
                    "spu_name": "",
                    "sku": "SKU1991FC9",
                    "fnsku": "",
                    "category1": null,
                    "category2": null,
                    "category3": null,
                    "global_tags": null,
                    "product_type": "普通产品",
                    "sku_attribute": null,
                    "attribute_text": "不可售",
                    "child_list": null
                }
            ]
        }
    ]
}

返回成功示例

{
    "code": 500,
    "message": "系统错误",
    "data": null,
    "total": 0,
    "request_id": "557581a380f4447b959d4adf777dfa09",
    "response_time": "2022-12-21 18:44:54"
}