CPSP_KQ_LARGE_CMT 数据

以下接口适用于 通用数据集成

请求地址

• API

环境	URL
测试	https://api-cn-t.lenovo.com/uat/v1.0/supply_chain/scc/open_platform/data/query/gspldt_scpomgr/cpsp_kq_large_cmt
正式	https://api-cn.lenovo.com/v1.0/supply_chain/scc/open_platform/data/query/gspldt_scpomgr/cpsp_kq_large_cmt

请求参数

参数	类型	是否必填	描述
pageNo	Integer	Y	页码
pageSize	Integer	Y	每页数量

请求响应

字段	类型	长度	备注
version	String	2	版本 01-31
run_number	String	2	版本，01-02，01代表上午：02代表下午
salesorderid	String	50	ICP Demand唯一标识
project_name	String	500	大单名称
commodity	String	50	Commodity
itemgroup	String	500	物料组
toitem	String	50	大单MTM
tositeid	String	50	大单Site
effstartdate	Date		大单需求日期 格式：yyyy-MM-dd
fcst_qty	Number	22	Netted Fost aty
siteid	String	50	Supply Site
cmt_date	Date		Supply Cmt Date , 格式：yyyy-MM-dd
cmt_qty	Number	22	Supply Cmt qty
due_date	Date		Dmd Schedule date, 格式：yyyy-MM-dd
priority	Number	22	ICP Fcst优先级
project_no	String	50	大单流水号
measure	String	50	MTM 标识
customer_segment	String	100	customer segment
product_segment	String	100	product segment
channel	String	100	channel
biz_unit	String	100	biz unit
orig_segment	String	255	customer segment + product segment +channel+ biz unit
cpsp_segment	String	255	cp match code
shortage	String	2	缺料标识Y/空
dmd_qty	Number	22	根据SALESORDERID对ITEMGROUP的CMT_QTY进行汇总
usage	Number	22	用量 usgae=dmd_qty/fcst_qty
sys_created_by	String	200	写入程序
sys_creation_date	Datetime		系统时间 , 格式：yyyy-MM-dd HH:mm:ss

请求示例

{
  "pageNo": 1,
  "pageSize": 10
}

响应示例

{
  "code": "0",
  "msg": "request success!",
  "result": {
    "total": 7449,
    "page_num": 1,
    "page_size": 10,
    "total_page": 745,
    "data": [
      {
        "commodity": "Planar",
        "channel": "COMMERCIAL",
        "tositeid": "******",
        "project_name": "******",
        "orig_segment": "COMMERCIAL|COMMERCIAL|COMMERCIAL|X",
        "shortage": "",
        "fcst_qty": 300,
        "sys_creation_date": "2023-11-28 11:45:30",
        "cmt_qty": 125,
        "siteid": "******",
        "itemgroup": "******",
        "cpsp_segment": "PRC|COMMERCIAL|COMMERCIAL|COMMERCIAL|X|QITIAN",
        "effstartdate": "2024-01-01",
        "sys_created_by": "",
        "due_date": "2024-01-12",
        "model_id": "******",
        "priority": 0,
        "customer_segment": "COMMERCIAL",
        "version": "28",
        "dmd_qty": 300,
        "toitem": "******",
        "biz_unit": "X",
        "measure": "MTM",
        "project_no": "******",
        "cmt_date": "2024-01-12",
        "run_number": "01",
        "usage": 0.29,
        "salesorderid": "******",
        "product_segment": "COMMERCIAL"
      },
      ....
    ]
  }
}

异常示例

{
  "code": "-1",
  "msg": "system error!",
  "result": null
}