库龄报表(非实时) - 元仓开放平台

1.每天0点开始统计,不是实时库龄数据,如今天是2025-04-22,最后的统计数据保存的时间是calculateDate = 2025-04-21
2.如仓库重新测量尺寸stockAgeVolume体积可能会更新

请求参数

Header 参数

Authorization

string

必需

例: Bearer 2296|M9DlZJI54pxcbdtdapSOy4wNkzYKijw5jpjJIhS7

默认值:

Bearer {{token}}

Content-Type

string

必需

默认值:

application/json

Body 参数application/json

warehouseCode

string

仓库code

必需

customerSku

array[string]

客户sku

可选

限制：1-100

prePage

integer

每页显示的条数

可选

默认15

page

integer

当前页

可选

默认1

calculateDate

string

统计时间

必需

2025-04-22

示例

{
  "warehouseCode": "001",
  "page": 1,
  "prePage": 20,
  "customerSku": [
    "MA015001",
    "MA019002"
  ]
}

返回响应

🟢200成功

application/json

Body

state

string

必需

msg

string

必需

data

object

必需

list

array [object {11}]

必需

total

integer

必需

prePage

integer

必需

page

integer

必需

示例

{
  "state": "000001",
  "msg": "请求成功",
  "data": {
    "list": [
      {
        "warehouseCode": "001",
        "sectionName": "X>180",
        "customerSku": "test12",
        "stockAgeQuantity": 2,
        "shelveDate": "2023-11-08 14:38:16",
        "stockAgeDay": 530,
        "stockAgeVolume": 0.15972,
        "calculateDate": "2025-04-21",
        "stockAgeDetailId": "0609fee513034d1bb6bbaf7d5381a456",
        "originSn": "RG230829175009007065",
        "shelveDescription": "退件入库"
      },
      {
        "warehouseCode": "001",
        "sectionName": "X>180",
        "customerSku": "test12",
        "stockAgeQuantity": 6,
        "shelveDate": "2023-08-10 15:18:52",
        "stockAgeDay": 620,
        "stockAgeVolume": 0.47916,
        "calculateDate": "2025-04-21",
        "stockAgeDetailId": "103019d824a6453fa911f8f7a350dd4f",
        "originSn": "SMY-CS110-0492-P",
        "shelveDescription": "头程预报入库"
      },
      {
        "warehouseCode": "001",
        "sectionName": "X>180",
        "customerSku": "test12",
        "stockAgeQuantity": 4,
        "shelveDate": "2024-01-11 14:45:25",
        "stockAgeDay": 466,
        "stockAgeVolume": 0.31944,
        "calculateDate": "2025-04-21",
        "stockAgeDetailId": "183a893b6f08459c8b377b42eaa34e53",
        "originSn": "AMY-CS110-0586-P",
        "shelveDescription": "头程预报入库"
      },
      {
        "warehouseCode": "001",
        "sectionName": "X>180",
        "customerSku": "test12",
        "stockAgeQuantity": 1,
        "shelveDate": "2023-07-31 18:31:34",
        "stockAgeDay": 630,
        "stockAgeVolume": 0.07986,
        "calculateDate": "2025-04-21",
        "stockAgeDetailId": "1e0e4dfd671f49f3a7ec35d1463e15ab",
        "originSn": "RG230731164044060",
        "shelveDescription": "退件入库"
      },
      {
        "warehouseCode": "001",
        "sectionName": "X>180",
        "customerSku": "test12",
        "stockAgeQuantity": 3,
        "shelveDate": "2023-09-04 14:51:39",
        "stockAgeDay": 595,
        "stockAgeVolume": 0.23958,
        "calculateDate": "2025-04-21",
        "stockAgeDetailId": "2059f49ccd984e9e8fc6d5053cd771a8",
        "originSn": "RG230904144807065756",
        "shelveDescription": "退件入库"
      },
      {
        "warehouseCode": "001",
        "sectionName": "X>180",
        "customerSku": "test12",
        "stockAgeQuantity": 4,
        "shelveDate": "2023-11-08 15:26:18",
        "stockAgeDay": 530,
        "stockAgeVolume": 0.31944,
        "calculateDate": "2025-04-21",
        "stockAgeDetailId": "22e906056c7947b3bdb9b9576aefad17",
        "originSn": "SC202311080010003",
        "shelveDescription": "入库异常入库"
      },
      {
        "warehouseCode": "001",
        "sectionName": "X>180",
        "customerSku": "test12",
        "stockAgeQuantity": 6,
        "shelveDate": "2023-08-28 17:58:42",
        "stockAgeDay": 602,
        "stockAgeVolume": 0.47916,
        "calculateDate": "2025-04-21",
        "stockAgeDetailId": "242d0d6bfeb14742a2fd28b143b1d02e",
        "originSn": "LMY-CS110-0521-P",
        "shelveDescription": "头程预报入库"
      },
      {
        "warehouseCode": "001",
        "sectionName": "X>180",
        "customerSku": "test12",
        "stockAgeQuantity": 10,
        "shelveDate": "2023-08-25 18:34:46",
        "stockAgeDay": 605,
        "stockAgeVolume": 0.7986,
        "calculateDate": "2025-04-21",
        "stockAgeDetailId": "287d4ecd75cf47baa41cb9acf5ba90c3",
        "originSn": "SMY-CS110-0503-P",
        "shelveDescription": "头程预报入库"
      },
      {
        "warehouseCode": "001",
        "sectionName": "X>180",
        "customerSku": "test12",
        "stockAgeQuantity": 6,
        "shelveDate": "2023-09-04 15:05:10",
        "stockAgeDay": 595,
        "stockAgeVolume": 0.47916,
        "calculateDate": "2025-04-21",
        "stockAgeDetailId": "2d75a0e465594b06ac4d62ff8c01fd27",
        "originSn": "RG230904144956014933",
        "shelveDescription": "退件入库"
      },
      {
        "warehouseCode": "001",
        "sectionName": "X>180",
        "customerSku": "test12",
        "stockAgeQuantity": 2,
        "shelveDate": "2023-07-01 18:12:25",
        "stockAgeDay": 660,
        "stockAgeVolume": 0.15972,
        "calculateDate": "2025-04-21",
        "stockAgeDetailId": "30f2ed74815e45d483c40e7f19deeb64",
        "originSn": "SMY-CS110-0579-P",
        "shelveDescription": "头程预报入库"
      },
      {
        "warehouseCode": "001",
        "sectionName": "X>180",
        "customerSku": "test12",
        "stockAgeQuantity": 1891,
        "shelveDate": "2023-01-11 11:14:13",
        "stockAgeDay": 832,
        "stockAgeVolume": 151.01526,
        "calculateDate": "2025-04-21",
        "stockAgeDetailId": "322acaa6c192417d873f1695f75ab919",
        "originSn": "SMY-CS110-0160-P",
        "shelveDescription": "头程预报入库"
      },
      {
        "warehouseCode": "001",
        "sectionName": "X>180",
        "customerSku": "test12",
        "stockAgeQuantity": 3,
        "shelveDate": "2023-08-10 12:16:44",
        "stockAgeDay": 620,
        "stockAgeVolume": 0.23958,
        "calculateDate": "2025-04-21",
        "stockAgeDetailId": "34af2e483df44a6fbb1706e4a2aee307",
        "originSn": "SMY-CS110-0490-P",
        "shelveDescription": "头程预报入库"
      },
      {
        "warehouseCode": "001",
        "sectionName": "X>180",
        "customerSku": "test12",
        "stockAgeQuantity": 45,
        "shelveDate": "2023-09-04 15:05:10",
        "stockAgeDay": 595,
        "stockAgeVolume": 3.5937,
        "calculateDate": "2025-04-21",
        "stockAgeDetailId": "35af2f0f1a3c444da076511bd872c4ee",
        "originSn": "RG230821162112000889",
        "shelveDescription": "退件入库"
      },
      {
        "warehouseCode": "001",
        "sectionName": "X>180",
        "customerSku": "test12",
        "stockAgeQuantity": 10,
        "shelveDate": "2024-01-11 14:45:25",
        "stockAgeDay": 466,
        "stockAgeVolume": 0.7986,
        "calculateDate": "2025-04-21",
        "stockAgeDetailId": "378b6d9839bc4a3189b2434f26eba28c",
        "originSn": "SMY-CS110-0666-P",
        "shelveDescription": "头程预报入库"
      },
      {
        "warehouseCode": "001",
        "sectionName": "X>180",
        "customerSku": "test12",
        "stockAgeQuantity": 6,
        "shelveDate": "2023-08-17 19:20:05",
        "stockAgeDay": 613,
        "stockAgeVolume": 0.47916,
        "calculateDate": "2025-04-21",
        "stockAgeDetailId": "3b48a69a9f0c42cc87ddc42806ba1b68",
        "originSn": "RG230817184210024450",
        "shelveDescription": "退件入库"
      },
      {
        "warehouseCode": "001",
        "sectionName": "X>180",
        "customerSku": "test12",
        "stockAgeQuantity": 1,
        "shelveDate": "2024-06-07 16:03:37",
        "stockAgeDay": 318,
        "stockAgeVolume": 0.07986,
        "calculateDate": "2025-04-21",
        "stockAgeDetailId": "3fe48ed58cda402eb0e80a3aec593b47",
        "originSn": "RG240229174416006769",
        "shelveDescription": "退件入库"
      },
      {
        "warehouseCode": "001",
        "sectionName": "X>180",
        "customerSku": "test12",
        "stockAgeQuantity": 4,
        "shelveDate": "2023-11-08 14:39:38",
        "stockAgeDay": 530,
        "stockAgeVolume": 0.31944,
        "calculateDate": "2025-04-21",
        "stockAgeDetailId": "55154d76c8244463b9c09d971867ff60",
        "originSn": "SC202311080010002",
        "shelveDescription": "入库异常入库"
      },
      {
        "warehouseCode": "001",
        "sectionName": "X>180",
        "customerSku": "test12",
        "stockAgeQuantity": 5,
        "shelveDate": "2023-08-10 12:20:52",
        "stockAgeDay": 620,
        "stockAgeVolume": 0.3993,
        "calculateDate": "2025-04-21",
        "stockAgeDetailId": "5965895df350492985afd0cb1c3358fd",
        "originSn": "AMY-CS110-0491-P",
        "shelveDescription": "头程预报入库"
      },
      {
        "warehouseCode": "001",
        "sectionName": "X>180",
        "customerSku": "test12",
        "stockAgeQuantity": 8,
        "shelveDate": "2023-09-04 15:05:10",
        "stockAgeDay": 595,
        "stockAgeVolume": 0.63888,
        "calculateDate": "2025-04-21",
        "stockAgeDetailId": "5d0075b1eabb4727b67d393cc69bffda",
        "originSn": "RG230904145741081070",
        "shelveDescription": "退件入库"
      },
      {
        "warehouseCode": "001",
        "sectionName": "X>180",
        "customerSku": "test12",
        "stockAgeQuantity": 1,
        "shelveDate": "2023-07-12 16:38:35",
        "stockAgeDay": 649,
        "stockAgeVolume": 0.07986,
        "calculateDate": "2025-04-21",
        "stockAgeDetailId": "5e4ebe73023349efbd0fa3a9b3ef07fa",
        "originSn": "",
        "shelveDescription": "退件入库"
      }
    ],
    "total": 44,
    "prePage": 20,
    "page": 1
  }
}