MWD (DT) Data

This interface is applicable for data integration API, read Api Access Process first

Frequency	Time	Data amount
Weekly	Before 17：00 for Wednesday	Weekly version of data (full amount)

Request address

• API

Environment	URL
Test	https://api-cn-t.lenovo.com/uat/v1.0/supply_chain/scc/open_platform/data/sync/odm/mwd_dt
Prod	https://api-cn.lenovo.com/v1.0/supply_chain/scc/open_platform/data/sync/odm/mwd_dt

• FTP

Environment	Partner directory	Lenovo directory	File name
Test	/Planning/SCC/{appName}/odm/mwd_dt/	/Planning/SCC/{appName}/odm/mwd_dt/feedback/	mwd_dt_{crud}_{yyyyMMddHHmmss}_
Prod	/Planning/SCC/{appName}/odm/mwd_dt/	/Planning/SCC/{appName}/odm/mwd_dt/feedback/	mwd_dt_{crud}_{yyyyMMddHHmmss}_

Sample：/Planning/SCC/LCFC/odm/mwd_docking/mwd_dt_update_20220928123000_001

Request data description

Param	Key	Type	Required	Length	Description	Example
uid		String		32	Unique id
site	Y	String	Y	50	ODM or Lenovo inhouse plant	AVC/9116/X410
bu	Y	String	Y	50	IdeaDT, ThinkDT, DT	IdeaDT/ThinkDT/DT
project		String	Y	400	Main MWD driven family	M838Z/M930Z/A960
family		String		400	MWD PN Used on	M838Z/M930Z/A960
sbb		String		1000	SBB Number	SBB1/SBB2/SBB3/..
item_group		String		100	Procurement Item Group in JDA maintained by each GSM
odm_pn	Y	String	Y	50	ODM part number	PN1
lenovo_pn		String	Y	1000	Lenovo part number	PN1/PN2/PN3
supplier		String		50	MWD supplier	TI
category		String	Y	2	BS/DS/DB	DB/DS/BS
commodity		String	Y	100	Need follow tierN master data	Planar
description		String	Y	300	material description	ABCD
usage		String	Y	13.2	BOM usage	1
lead_time		Integer	Y	10	Material lead time by week	8
ncnr_window		String	Y	10	CANCELLATION_WINDOW	8
moq		Integer	Y	10	min order num	10000
eol		string		5	whether eol	N/Y
fcst_version	Y	String	Y	8	MWD refered FCST version (like9/21)	20221216
first_hl_week		String	Y	8	ODM firstly claim MWD date yyyyMMdd	20221104
agingweeks		number		13.2	Weeks that MWD had been in aging	6
odmplant_stock		number		13.2	Material inventory quantity in ODM	1000
noncancellable_po		number		13.2	none cancellable quantity	2000
fg		number		13.2	Parts FG inventory in sub-tier suppliers	0
wip		number		13.2	Parts WIP in sub-tier suppliers	0
rawmaterials		number		13.2	Raw materials in sub-tier suppliers	2000
total_qty		number		13.2	total quantity	3000
demand		number		13.2	Lenovo net demand on the MWD parts	0
total_mwd_qty		number		13.2	mwd quantity	3000
lenovoowned_mwd_qty		number	Y	13.2		3000
odmowned_mwd_qty		number		13.2		0
lastwk_lenovoowned_mwd_qty		number		13.2		1000
variance		number		13.2		2000
unit_price		number	Y	13.4	Unit Price	35
total_amount		number		13.4		105000
lenovoowned_mwd		number		13.2		105000
odmowned_mwd		number		13.2		0
demand_peak_week		String	Y	8	yyyyMMdd	20221021
remark		String		1000	Reason or any other comment	Demand downside
odm	Y	String	Y	20	ODM name	LCFC
parts_owner	Y	String	Y	100	Parts Owner

Response data description

Param	Type	Description
code	String	0: success, others:failed
msg	String	the detail message, especially useful on failure

Request sample

{
  "batch_id": "90397",
  "batch_size": 1,
  "seq_id": "1",
  "seq_size": 1,
  "data": [ {
    "uid":"",
    "site":"AVC/9116/X410",
    "bu":"IdeaDT",
    "project":"M838Z",
    "family":"M838Z",
    "sbb":"SBB1",
    "item_group":"",
    "odm_pn":"PN1",
    "lenovo_pn":"PN1",
    "supplier":"TI",
    "category":"DB",
    "commodity":"Planar",
    "description":"ABCD",
    "usage":"1",
    "lead_time":"8",
    "ncnr_window":"8",
    "moq":"10000",
    "eol":"N",
    "fcst_version":"20221216",
    "first_hl_week":"20221104",
    "agingweeks":"6.34",
    "odmplant_stock":"1000",
    "noncancellable_po":"2000",
    "fg":"0",
    "wip":"0",
    "rawmaterials":"2000",
    "total_qty":"3000",
    "demand":"0",
    "total_mwd_qty":"3000",
    "lenovoowned_mwd_qty":"3000",
    "odmowned_mwd_qty":"0",
    "lastwk_lenovoowned_mwd_qty":"1000",
    "variance":"2000",
    "unit_price":"35",
    "total_amount":"105000",
    "lenovoowned_mwd":"105000",
    "odmowned_mwd":"0",
    "demand_peak_week":"20221021",
    "remark":"Demand downside",
    "odm": "ECS",
    "parts_owner": "chenww10"
  }]
}

Successful response sample

{
  "code": "0",
  "msg": "request success"
}

Failed response sample

{
    "code": "E00V00",
    "msg": "data verification failed！",
    "result": [{
        "row": {
            "odm": "LCFC",
            ...
        },
        "verify": [{
            "type": "value length exceed",
            "fields": "version"
        }]
    }]
}