MWD (Docking) 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_docking
Prod	https://api-cn.lenovo.com/v1.0/supply_chain/scc/open_platform/data/sync/odm/mwd_docking

• FTP

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

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

Request data description

TIP

Note: field requirements are different on bu, please refer to the following table

Param	Key	Type	default requird	Length	Description	Example
uid		String		32	Unique id
risk_level		String		8		Lower
odm	Y	String	Y	20		LCFC
odm_code		String	Y	20	odm trade code
bu	Y	String	Y	18		MDSC-TB
site	Y	String	Y	50
lenovo_pn	Y	String	Y	50	lenovo part number
commodity		String	Y	100
item_desc		String	Y	200	item description
fcst_version	Y	String	Y	100		20220711
fcst_qty		Integer	Y	10	liability window forecast quantity
max_demand_version		String	Y	40
max_demand_qty		Integer	Y	5	liability window
actualize_qty		Integer	Y	5
moq		Integer	Y	10	min order quantity
mpq		Integer	Y	10	min package quantity
fg_lead_time		Integer	Y	10
liability_lt		String	Y	200	DOI/In transit
boh_soi		Integer	Y	10
in_transit		Integer	Y	10
mfg_gf		Integer	Y	10
wip		Integer	Y	10
square_set		String	Y	50
non_square_excess_qty		Integer	Y	10
lenovo_own_total_qty		Integer	Y	10	SOI+In transit+MFG FG+WIP+square-set+non-sqaure excess qty
square_mwd_qty		Integer	Y	10	(SOI+In transit+MFG FG+WIP+Square set)-fcst qty
total_mwd_qty		Integer	Y	10	(SOI+In transit+MFG FG+WIP+Square set+Non-square excess qty)-fcst qty
fg_unit_price		Number	Y	13.2	price($)
square_mwd_amt		Number	Y	13.2	square mwd qty*fg unit price
total_mwd_amt		Number	Y	13.2	square_mwd_amt+non-sqaure amt+llt_excess amt
lenovo_square_amt		Number	Y	13.2	SOI+In transit+MFG FG+WIP+Square set)*fg unit prcie
non_square_amt		Number	Y	13.2	Non square excess within liability amt $
llt_moq_excess_amt		Number	Y	13.2	LLT excess out of liability amt $
odm_own_liability_qty		Integer		10	ODM afford excess quantity
odm_own_liability_amt		Number		13.2	ODM afford excess amount($)
remark		String		100	remark
gsm_owner		String	Y	30
comment1		String		100	reserved field
comment2		String		100	reserved field

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": "",
    "risk_level": "",
    "odm": "LCFC_test",
    "odm_code": "test_code",
    "bu": "MDSC-TB",
    "site": "site_test",
    "lenovo_pn": "lenovo_pn_1",
    "commodity": "atype",
    "item_desc": "some description",
    "fcst_version": "20220711",
    "fcst_qty": "12",
    "max_demand_version": "12",
    "max_demand_qty": "12",
    "actualize_qty": "32",
    "moq": "12",
    "mpq": "34",
    "fg_lead_time": "2",
    "liability_lt": "123",
    "boh_soi": "12",
    "in_transit": "34",
    "mfg_gf": "12",
    "wip": "13",
    "square_set": "abc123",
    "non_square_excess_qty": "12",
    "lenovo_own_total_qty": "34",
    "square_mwd_qty": "12",
    "total_mwd_qty": "23",
    "fg_unit_price": "10.02",
    "square_mwd_amt": "17.34",
    "total_mwd_amt": "12.25",
    "llt_moq_excess_amt": "12.2",
    "lenovo_square_amt": "11.21",
    "non_square_amt": "3.08",
    "llt_excess_amt": "4.23",
    "odm_own_liability_qty": "23",
    "odm_own_liability_amt": "11.67",
    "remark": "remark_remark",
    "gsm_owner": "owner_abc",
    "comment1": "",
    "comment2": ""
  }]
}

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"
        }]
    }]
}