查询【BOM切割单】接口

概述

该接口主要用于第三方平台或自主研发者,通过调用【BOM切割单】的查询接口,将Sunlike ERP或Online ERP系统中的【BOM切割单】信息查询到第三方平台。

参数说明

1.请求方式

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

2.header参数

Content-Type application/json
Authorization token 授权接口所获取的值

3.请求参数

字段名称 字段代号 类型 长度 必填 固定值 备注
程序代号 PGM     MRPBG  
单据别 MB_ID string 2 MD  
组合代号 MB_NO string 20   ERP单据号码

请求JSON示例

{
  "PGM": "MRPBG",      //单据程序代号
  "MB_ID": "MD",       //单据别代号
  "MB_NO": "MD0C280001"     //ERP单据号码
}

返回结果示例

{
    "code": 0,
    "message": "查询成功",
    "data": {
        "MF_MB": [
            {
                "MB_ID": "MD",
                "MB_NO": "MD0C280001",
                "MB_DD": "2020-12-28 00:00:00",
                "USR_NO": "",
                "WH_PRD": "A000",
                "MRP_NO": "A2001",
                "PRD_NAME": "A2001制成品",
                "EXP_MTH": "1",
                "UNIT": "1",
                "QTY": 2.0,
                "DEP": "00000000",
                "CST": 200.0,
                "CST_MAKE": 0.0,
                "CST_PRD": 0.0,
                "CST_MAN": 0.0,
                "CST_OUT": 0.0,
                "USED_TIME": 0.0,
                "VOH_ID": "",
                "CST_STD": 0.0,
                "CST_SMAKE": 0.0,
                "CST_SPRD": 0.0,
                "CST_SMAN": 0.0,
                "CST_SOUT": 0.0,
                "USED_STIME": 0.0,
                "CST_DIFF": 200.0,
                "CST_SDIFF": 0.0,
                "USR": "ADMIN",
                "CHK_MAN": "ADMIN",
                "PRT_SW": "N",
                "CLS_DATE": "2020-12-28 00:00:00",
                "ID_NO": "A2001->",
                "SYS_DATE": "2020-12-29 10:39:57",
                "TIME_CNT": 0.0,
                "TIME_SCNT": 0.0,
                "PRT_USR": ""
            }
        ],
        "TF_MB": [
            {
                "MB_ID": "MD",
                "MB_NO": "MD0C280001",
                "ITM": 1,
                "MB_DD": "2020-12-28 00:00:00",
                "PRD_NO": "A4001",
                "PRD_NAME": "A4001原料",
                "PRD_MARK": "",
                "WH": "A000",
                "UNIT": "1",
                "QTY": 4.0,
                "QTY1": 0.0,
                "QTY_LOST": 0.0,
                "QTY1_LOST": 0.0,
                "CST": 0.0,
                "REM": "",
                "CST_STD": 0.0,
                "ID_NO": "",
                "VAL_FT": 4.0,
                "EST_ITM": 5,
                "PRE_ITM": 5,
                "USEIN_NO": "",
                "LOS_RTO": 0.0,
                "QTY_STD": 2.0,
                "DEP_RK": "",
                "CAS_NO": "",
                "UP_MAIN": 0.0,
                "UP_STD": 0.0
            },
            {
                "MB_ID": "MD",
                "MB_NO": "MD0C280001",
                "ITM": 2,
                "MB_DD": "2020-12-28 00:00:00",
                "PRD_NO": "A4002",
                "PRD_NAME": "A4002原料",
                "PRD_MARK": "",
                "WH": "A000",
                "UNIT": "1",
                "QTY": 4.0,
                "QTY1": 0.0,
                "QTY_LOST": 0.0,
                "QTY1_LOST": 0.0,
                "CST": 0.0,
                "REM": "",
                "CST_STD": 0.0,
                "ID_NO": "",
                "VAL_FT": 4.0,
                "EST_ITM": 6,
                "PRE_ITM": 6,
                "USEIN_NO": "",
                "LOS_RTO": 0.0,
                "QTY_STD": 2.0,
                "DEP_RK": "",
                "CAS_NO": "",
                "UP_MAIN": 0.0,
                "UP_STD": 0.0
            },
            {
                "MB_ID": "MD",
                "MB_NO": "MD0C280001",
                "ITM": 3,
                "MB_DD": "2020-12-28 00:00:00",
                "PRD_NO": "A5001",
                "PRD_NAME": "A5001物料",
                "PRD_MARK": "",
                "WH": "A000",
                "UNIT": "1",
                "QTY": 2.0,
                "QTY1": 0.0,
                "QTY_LOST": 0.0,
                "QTY1_LOST": 0.0,
                "CST": 0.0,
                "REM": "",
                "CST_STD": 0.0,
                "ID_NO": "",
                "VAL_FT": 2.0,
                "EST_ITM": 7,
                "PRE_ITM": 7,
                "USEIN_NO": "",
                "LOS_RTO": 0.0,
                "QTY_STD": 1.0,
                "DEP_RK": "",
                "CAS_NO": "",
                "UP_MAIN": 0.0,
                "UP_STD": 0.0
            }
        ]
    }
}