CPSP_KQ_LARGE_CMT

This interface is applicable for data query API, read Api Query Process first

Request address

• API

Environment	URL
Test	https://api-cn-t.lenovo.com/uat/v1.0/supply_chain/scc/open_platform/data/query/gspldt_scpomgr/cpsp_kq_large_cmt
Prod	https://api-cn.lenovo.com/v1.0/supply_chain/scc/open_platform/data/query/gspldt_scpomgr/cpsp_kq_large_cmt

Request data description

Param	Type	Required	Description
pageNo	Integer	Y	page number
pageSize	Integer	Y	page size

Response data description

Param	Type	Length	Description
version	String	2	version 01-31
run_number	String	2	run number，01-02，01 morning，02 afternoon
salesorderid	String	50	ICP Demand ID
project_name	String	500	project name
commodity	String	50	Commodity
itemgroup	String	500	item group
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 , Format：yyyy-MM-dd
cmt_qty	Number	22	Supply Cmt qty
due_date	Date		Dmd Schedule date, Format：yyyy-MM-dd
priority	Number	22	ICP Fcst priority
project_no	String	50	project number
measure	String	50	MTM measure
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	shortage flag:Y/null
dmd_qty	Number	22
usage	Number	22	usgae=dmd_qty/fcst_qty
sys_created_by	String	200
sys_creation_date	Datetime		yyyy-MM-dd HH:mm:ss

Request sample

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

Successful response sample

{
  "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": 30004435,
        "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"
      },
      ....
    ]
  }
}

Failed response sample

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