Final Psd Report
The following interfaces apply to General Data Query
Request URL
- API
Request Parameters
| field | Type | required | description |
|---|---|---|---|
| batch_id | String | N | generated by the partner, need to gurantee the uniqueness |
| page_no | Integer | N(default 1) | current request page number |
| page_size | Integer | N(default 5000) | data size per page (all_page_number = total_data_size/page_size ) |
Response Parameters
| field | Type |
|---|---|
| PSD_VERSION | VARCHAR2(20) |
| SO_ID | VARCHAR2(10) |
| SO_ITEM_ID | VARCHAR2(6) |
| HOH_SO | VARCHAR2(10) |
| HOHSO_ITEM | VARCHAR2(6) |
| PO_ID | VARCHAR2(10) |
| PO_ITEM_ID | VARCHAR2(6) |
| MTM | VARCHAR2(100) |
| GEO | VARCHAR2(20) |
| SUBGEO | VARCHAR2(20) |
| DSP | NUMBER |
| PLANT | VARCHAR2(20) |
| FAMILY | VARCHAR2(100) |
| BRAND | VARCHAR2(20) |
| CREATE_DATE | VARCHAR2(20) |
| CREATE_TIME | VARCHAR2(20) |
| ORDER_PRIORITY | NUMBER |
| ORDER_QTY | NUMBER |
| PLANNED_QTY | NUMBER |
| ORDER_MAD | DATE |
| INPUT_DATE | DATE |
| FG_DATE | DATE |
| LINE_PSD | DATE |
| TIE_PSD | DATE |
| ADJUST_LINE_PSD | DATE |
| ADJUST_TIE_PSD | DATE |
| FPSD | DATE |
| SHIP_DATE | DATE |
| CANCEL_DATE | DATE |
| STATUS | VARCHAR2(20) |
| STATUS_COMMENT | VARCHAR2(2000) |
| REASON_CODE | VARCHAR2(1000) |
| REASON_CODE2 | VARCHAR2(1000) |
| REASON_COMMENT | VARCHAR2(4000) |
| MO_ID | VARCHAR2(1000) |
| SHORTAGE_PART | VARCHAR2(1000) |
| CSD | DATE |
| RSD | DATE |
| DELIVERY_BLOCK | VARCHAR2(20) |
| TIE_INDICATOR | VARCHAR2(20) |
| CUSTOMER | VARCHAR2(500) |
| DELIVERY_GROUP | VARCHAR2(10) |
| HEADER_COMPLETE | VARCHAR2(10) |
| ITEM_COMPLETE | VARCHAR2(10) |
| COUNTRY | VARCHAR2(60) |
| ROUTE | VARCHAR2(6) |
| SHIP_CONDITION | VARCHAR2(60) |
| SHIPTO | VARCHAR2(20) |
| SOLDTO | VARCHAR2(20) |
| SALES_ORG | VARCHAR2(10) |
| CHANNEL | VARCHAR2(10) |
| UPDATE_ID | VARCHAR2(10) |
| UPDATE_TIME | DATE |
| SYS_SOURCE | VARCHAR2(25) |
| SYS_CREATED_BY | VARCHAR2(70) |
| SYS_CREATION_DATE | DATE |
| SYS_LAST_MODIFIED_BY | VARCHAR2(70) |
| SYS_LAST_MODIFIED_DATE | DATE |
| SYS_ENT_STATE | VARCHAR2(25) |
| SYS_NC_TYPE | VARCHAR2(25) |
| SYS_FILTER | VARCHAR2(60) |
| SYS_EXCEPTION_TYPE | VARCHAR2(20) |
| SYS_ERR_SVRTY | VARCHAR2(30) |
| SYS_ERR_CODE | VARCHAR2(1000) |
| SYS_AUTH_ID | VARCHAR2(25) |
| SYS_TARGET_ID | NUMBER(11,0) |
| FPSD_GENERATE_DATE | DATE |
| INIT_LINE_PSD | DATE |
| REMARK | VARCHAR2(2000) |
| TOECC | VARCHAR2(2) |
| ATP_DATE | DATE |
| UPGRADE_FLG | VARCHAR2(40) |
| DEGRADE_FLG | VARCHAR2(40) |
| ORDER_SEGMENT | VARCHAR2(20) |
| BA_SUPPLY_MARK | VARCHAR2(5) |
| BA_ORDERS | VARCHAR2(2000) |
| ORDER_TYPE | VARCHAR2(5) |
Request Example
https://api-cn-t.lenovo.com/uat/v1.0/supply_chain/scc/open_platform/data/query/ips_report/final_psd?batch_id=a95e30&page_no=1Response Example
json
{
"code": "0",
"message": "request success!",
"result": {
"total": 233,
"data": [
{
"SCENARIO_ID": "123451",
"SITEID": "127622008",
...
},
{
"SCENARIO_ID": "123452",
"SITEID": "127622008"
},
...
]
}
}Error Example
json
{
"code": "-1",
"message": "System error. Please try again later or contact your system administrator！"
}Business Error code
| error code | error description | solutions |
|---|---|---|