查询【生产需求分析】接口

概述

该接口主要用于第三方平台或自主研发者,通过调用【生产需求分析】的查询接口,将Sunlike ERP或Online ERP系统中的【生产需求分析】信息调出至第三方平台中显示。

参数说明

1.请求方式

请求方式 POST
接口地址 http://ERPAPI站点/MRPABA/GETDATA
格式 JSON
编码类型 UTF-8

2.header参数

Content-Type application/json
Authorization token 获取每次登录的值

3.请求参数

请求JSON示例

{
    "PGM":"MRPABA",
    "MP_NO":"MP2204150001"
}

说明:

上面查询接口返回如下表信息:MF_MP\TF_MP0\TF_MP1\TF_MP2\TF_MP3\TF_MP4

返回结果示例

{
    "code": 0,
    "message": "查询成功",
    "data": {
        "MF_MP": [
            {
                "MP_NO": "MP2204150001",
                "MP_DD": "2022-04-15 10:57:44",
                "SO_NO": "SO2204150001",
                "CHK_MAN": "ADMIN",
                "PRD_OUT": "T",
                "PRT_SW": "N",
                "CLS_DATE": "2022-04-15 10:58:42",
                "USR": "ADMIN",
                "OVER_RTO": 0.0,
                "WH": "",
                "CLUDE": "F",
                "SYS_DATE": "2022-04-15 10:58:42",
                "PRT_USR": "",
                "MODIFY_DD": "2022-04-15 10:58:49",
                "MODIFY_MAN": "ADMIN"
            }
        ],
        "TF_MP1": [
            {
                "MP_NO": "MP2204150001",
                "ITM": 1,
                "PRD_NO": "001",
                "PRD_NO_NO": "001",
                "PRD_NAME": "哈姆卡通玩具",
                "PRD_MARK": "",
                "WH": "JA01",
                "UNIT": "1",
                "UP": 95.24,
                "QTY_MAX_SO": 0.0,
                "QTY_SO": 5.0,
                "QTY_NON": 5.0,
                "BAT_NO": "",
                "SO_NO": "SO2204150001",
                "REM": "",
                "EST_DD": "2022-04-15 00:00:00",
                "QTY_MIN": 0.0,
                "QTY_ON_WAY": 0.0,
                "QTY_ON_PRC": 0.0,
                "QTY_ON_RSV": 0.0,
                "QTY_ON_ODR": 5.0,
                "QTY_LRN": 0.0,
                "QTY_BRW": 0.0,
                "QTY": 0.0,
                "EST_ITM": 1,
                "NUMBER": "0000_000",
                "STA_DD": "2022-04-15 00:00:00",
                "ID_NO": "",
                "PO_YES": "T",
                "EST_ITMSTR": "",
                "QTY_STD": 0.0,
                "QTY_LOST": 0.0,
                "BIL_ID": "SO",
                "PRD_NO1": "",
                "PRD_MARK1": "",
                "ECN_ID": "",
                "BOM_NO": "",
                "OS_ITM": 1,
                "QTY_PO": 0.0,
                "CUS_OS_NO": "",
                "CHG_RTO": 0.0,
                "ZC_PRD": "N",
                "QTY_SQ": 0.0,
                "LLC": 1,
                "QTY_CTL": 0.0,
                "DRC": "T",
                "CNTT_NO": "",
                "PRD_NO_CHG": "",
                "BOM_NO_P": "",
                "QTY_SW": 0.0,
                "QTY_Q3": 0.0,
                "QTY_WX": 0.0,
                "QTY_Q2_YL": 0.0,
                "QTY_WS_KC": 0.0,
                "CHG_RTO_STR": "",
                "QTY_ADD": 0.0,
                "MRP_NO": ""
            }
        ],
        "TF_MP2": [
            {
                "MP_NO": "MP2204150001",
                "ITM": 1,
                "PRD_NO": "001",
                "PRD_NO_NO": "001",
                "PRD_NAME": "哈姆卡通玩具",
                "PRD_MARK": "",
                "WH": "JA01",
                "CUS_NO": "CU0301",
                "UNIT": "1",
                "QTY": 0.0,
                "QTY1": 5.0,
                "UP_PO": 100.0,
                "UP_SO": 95.24,
                "AMTN_PO": 0.0,
                "AMTN_SO": 0.0,
                "SO_NO": "SO2204150001",
                "PO_NO": "PO2204150001",
                "EST_DD": "2022-04-15 00:00:00",
                "REM": "",
                "QTY_AD": 5.0,
                "STA_DD": "2022-04-15 00:00:00",
                "END_DD": "2022-04-15 00:00:00",
                "QTY_PO": 5.0,
                "AMT_PO": 500.0,
                "DIS_CNT": 0.0,
                "CUR_ID": "",
                "PO_ID": "1",
                "SAL_NO": "YM0201",
                "EST_ITM": 1,
                "QTY_STD": 0.0,
                "QTY_LOST": 0.0,
                "UP_QTY1": 100.0,
                "CUS_OS_NO": "",
                "PRE_ITM": 1,
                "SO_ID": "SO",
                "QTY_SO": 5.0,
                "QTY_NON": 5.0,
                "QTY_MAX_SO": 0.0,
                "DZ_ID": "N",
                "CNTT_NO": "",
                "QTY_AL": 0.0,
                "PRD_NO_CHG": "",
                "SUP_PRD_NO": "1070300082",
                "SUP_PRD_MARK": "",
                "CHG_RTO": ""
            }
        ],
        "BILL_STATE": {
            "READONLY": false,
            "READONLY_REM": []
        }
    }
}