Lingxing
切换旧版

库存报表 - 海外仓 - 历史报表 - 明细

POST/erp/sc/routing/inventoryLog/WareHouseReport/getOverSeaDetailList

接口信息

API Path请求协议请求方式令牌桶容量
/erp/sc/routing/inventoryLog/WareHouseReport/getOverSeaDetailListHTTPSPOST1

请求参数

sys_widinteger
系统仓库id,多个用英文逗号分隔
start_datestring必填
开始时间,格式:Y-m-d
end_datestring必填
结束时间,格式:Y-m-d
offsetinteger必填
分页偏移量,默认0
lengthinteger必填
每页条数,默认15

请求示例

{
    "offset": 0,
    "length": 15,
    "start_date": "2022-01-01",
    "end_date": "2024-08-05",
    "sys_wid": "9"
}

返回结果

Json Object

codeinteger必填
状态码,0 成功
示例 0
messagestring必填
消息提示
示例 success
error_detailsarray<any>必填
错误信息
request_idstring必填
请求链路id
示例 8D680B8B-3C6F-3E16-F055-73DC70EAD977
response_timestring必填
响应时间
示例 2020-05-18 11:23:47
dataarray<object>必填
返回数据
隐藏子属性
skustring必填
SKU
示例 SKU-1
api_skustring必填
第三方SKU
示例 ASVSDSA-1
product_namestring必填
品名
示例 手机
fnskustring必填
FNSKU
示例 SDSADSV123
seller_namestring必填
店铺
示例 店铺1
sys_widinteger必填
仓库id
示例 23
ware_house_namestring必填
仓库名称
示例 仓库1
category1string必填
一级分类
示例 分类1
category2string必填
二级分类
示例 分类2
category3string必填
三级分类
示例 分类3
brandstring必填
品牌
示例 某果
attribute_textstring必填
库存属性
示例 可售
product_typestring必填
产品类型
示例 辅料
day_early_countnumber必填
期初库存(数量)
示例 2450424
day_early_costnumber必填
期初库存(成本)
示例 723024419.45
api_day_early_countnumber必填
第三方期初库存(数量)第三方只有数量
api_day_end_countnumber必填
第三方期末库存(数量)第三方只有数量
purchase_in_countnumber必填
采购入库(数量)
示例 30
purchase_in_costnumber必填
采购入库(成本)
示例 22.5
allocation_in_countnumber必填
调拨入库(数量)
allocation_in_costnumber必填
调拨入库(成本)
示例 0
return_goods_in_countnumber必填
退货入库(数量)
return_goods_in_costnumber必填
退货入库(成本)
示例 0
other_in_countnumber必填
其他入库(数量)
示例 1000
other_in_costnumber必填
其他入库(成本)
示例 0
inventory_surplus_in_countnumber必填
盘盈入库(数量)
inventory_surplus_in_costnumber必填
盘盈入库(成本)
示例 0
adjustment_countnumber必填
库存调整(数量)
adjustment_costnumber必填
库存调整(成本)
示例 0
fba_out_countnumber必填
FBA出库(数量)
fba_out_costnumber必填
FBA出库(成本)
示例 0
fbm_out_countnumber必填
FBM出库(数量)
fbm_out_costnumber必填
FBM出库(成本)
示例 0
allocation_out_countnumber必填
调拨出库(数量)
allocation_out_costnumber必填
调拨出库(成本)
示例 0
purchase_return_countnumber必填
采购退货(数量)
purchase_return_costnumber必填
采购退货(成本)
示例 0
other_out_countnumber必填
其他出库(数量)
other_out_costnumber必填
其他出库(成本)
示例 0
inventory_deficit_out_countnumber必填
盘亏出库(数量)
inventory_deficit_out_costnumber必填
盘亏出库(成本)
示例 0
wfs_out_countnumber必填
WFS出库(数量)
wfs_out_costnumber必填
WFS出库(成本)
示例 0
allocation_in_transit_countnumber必填
期末在途(数量)
示例 1
allocation_in_transit_costnumber必填
期末在途(成本)
示例 13
day_end_countnumber必填
期末库存(数量)
示例 2451454
day_end_costnumber必填
期末库存(成本)
示例 723024441.95
stocking_in_transit_countnumber必填
期末在途(数量)
stocking_in_transit_costnumber必填
期末在途(成本)
示例 0
rotation_rate_countnumber必填
库存周转率(数量)
示例 0
rotation_rate_costnumber必填
库存周转率(成本)
示例 0
rotation_day_countnumber必填
库存周转天数(数量)
rotation_day_costnumber必填
库存周转天数(成本)
sales_ratio_countnumber必填
存销比(数量)
sales_ratio_costnumber必填
存销比(成本)
cost_change_costnumber必填
成本补录(成本)
示例 0
sales_ratenumber必填
动销率
totalinteger必填
记录行数
示例 510

返回成功示例

{
    "code": 0,
    "message": "success",    
    "error_details": [],
    "request_id": "557581a380f4447b959d4adf777dfa09",
    "response_time": "2022-12-21 18:44:54"
    "request_id": "A42097F7-3400-BD9F-2A11-FED53ADD955A",
    "data": [{
        "id": 4387598,
        "product_id": 8,
        "ware_house_name": "西邮智仓 美国洛杉矶",
        "date_locale": "2022-10-15",
        "attribute": 1,
        "purchase_in_count": "0",
        "allocation_in_count": "0",
        "return_goods_in_count": "0",
        "pickout_in_count": "0",
        "other_in_count": "0",
        "adjustment_count": "0",
        "fba_out_count": "0",
        "fbm_out_count": "0",
        "allocation_out_count": "0",
        "purchase_return_count": "0",
        "other_out_count": "0",
        "cost_change_count": "0",
        "fnsku": "",
        "api_sku": "",
        "sku": "123713811-11",
        "product_name": "[演示数据]USB 壁式充电器 2.1A/5V 双端口 立方体电源适配器充电器插头充电块替换件",
        "is_combo": 0,
        "is_aux": 0,
        "api_day_early_count": 0,
        "api_day_end_count": 0,
        "uk": "39-8-0--1",
        "seller_id": "0",
        "inventory_surplus_in": "0",
        "wfs_out_count": "0",
        "bid": 1,
        "cid": 3,
        "different_count": -100,
        "global_tags": "",
        "seller_name": "",
        "brand": "",
        "category": "缺失的品牌\\缺失的品牌",
        "category1": "缺失的品牌",
        "category2": "缺失的品牌",
        "category3": "",
        "attribute_text": "可售",
        "day_early_count": 100,
        "day_end_count": 100,
        "product_type": "普通商品",
        "sys_wid": 39,
        "day_early_cost": 0,
        "purchase_in_cost": 0,
        "allocation_in_cost": 0,
        "other_in_cost": 0,
        "inventory_surplus_in_cost": 0,
        "return_goods_in_cost": 0,
        "pickout_in_cost": 0,
        "adjustment_cost": 0,
        "fba_out_cost": 0,
        "fbm_out_cost": 0,
        "other_out_cost": 0,
        "allocation_out_cost": 0,
        "purchase_return_cost": 0,
        "inventory_deficit_out_cost": 0,
        "cost_change_cost": 0,
        "wfs_out_cost": 0,
        "day_end_cost": 0,
        "rotation_rate_cost": 0,
        "rotation_day_cost": 0,
        "stocking_in_transit_cost": 0,
        "nventory_surplus_in_count": "0",
        "inventory_deficit_out_count": "0",
        "rotation_rate_count": "0.0000",
        "rotation_day_count": "0.00",
        "stocking_in_transit_counst": 0,
        "product_count": 0
    }],
    "total": 1
}