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

• FTP

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

Sample：/Planning/SCC/LCFC/odm/mwd_acc/mwd_acc_update_20220928123000_001

Request data description

TIP

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

Param	Key	Type	Default required	MDSC-TB	Length	Description	Example
uid		String			32	Unique id
fcst_version	Y	String	Y	Y	8	yyyyMMdd	20220711
odm	Y	String	Y	Y	20		LCFC
bu	Y	String	Y	Y	50		MDSC-TB
site		String	Y	Y	50
odm_pn	Y	String	Y	Y	50	ODM part number
lenovo_pn	Y	String	Y	Y	50	Lenovo part number
project_name		String			50	ODM project name
family	Y	String			4000	lenovo project name
plc		String	Y	Y	10	product status	EOL
commodity		String	Y	Y	100
item_desc		String	Y	Y	200	item description
material_type		String	Y	Y	10	material type	DB
alternative_code		String	Y	Y	200
moq		Integer	Y	Y	10	min order number
lead_time		Integer	Y	Y	10	LT
quotation_price		Number	Y	Y	13.6	price
lenovo_mwd_qty		Integer	Y	Y	10	lenovo MWD quantity
lenovo_mwd_amt		Number	Y	Y	13.6	lenovo MWD amount
remark		String			100
initial_submission_date		Date	Y	Y
usage		Integer	Y	Y	10,2
vendor		String	Y	Y	200
unique		String	Y	Y	1		Y
odm_plant_stock		Integer	Y	Y	10	ODM stock	50000
non_cancel_po		String	Y	Y	10	none cancellable OPEN PO	0
tire_2_non_cancel_po		String	Y	Y	10	ODM open po	0
total_demand		Integer	Y	Y	10		30000
ttl_mwd		Integer	Y	Y	10		20000
last_version_mwd_qty		Integer	Y	Y	10	MWD quantity of last version
last_version_mwd_amt		Number	Y	Y	13.6	MWD amount of last version
w2w_mwd_change_amt		Number	Y	Y	13.6	MWD amount change between this and last week
odm_mwd_qty		Integer	Y	Y	10	ODM total MWD quantity
odm_mwd_amt		Number	Y	Y	13.6	ODM total MWD amount
comment1		String			100
comment2		String			100

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": [
    {
      "fcst_version": "2022711",
      "odm": "odm_1",
      "bu": "ACC",
      "site": "site_1",
      "odm_pn": "",
      "lenovo_pn": "lenovo_pn_1ni",
      "project_name": "",
      "family": "",
      "plc": "EOL",
      "commodity": "包材类",
      "item_desc": "中性通用封箱胶带",
      "material_type": "DB",
      "alternative_code": "12.34",
      "moq": "123",
      "lead_time": "20221012",
      "quotation_price": "1.23",
      "lenovo_mwd_qty": "123",
      "lenovo_mwd_amt": "12.3",
      "remark": "",
      "initial_submission_date": "20220915",
      "usage": "456",
      "vendor": "vendor-1",
      "unique": "Y",
      "odm_plant_stock": "50000",
      "non_cancel_po": "0",
      "tire_2_non_cancel_po": "0",
      "total_demand": "30000",
      "ttl_mwd": "20000",
      "last_version_mwd_qty": "123",
      "last_version_mwd_amt": "1234.32",
      "w2w_mwd_change_amt": "123.23",
      "odm_mwd_qty": "321",
      "odm_mwd_amt": "12.12",
      "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"
        }]
    }]
}