查询【商品物料表】接口

概述

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

参数说明

1.请求方式

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

2.header参数

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

3.请求参数

字段名称 字段代号 类型 长度 必填 固定值 备注
程序代号 PGM     MRPBom  
BOM代号 BOM_NO string 38     BOM配方号,如A2002->

请求JSON示例

{
  "PGM": "MRPBom",     //单据程序代号
  "BOM_NO": "A2002->"     //BOM代号
}

返回结果示例

{
    "code": 0,        //0表示执行成功
    "message": "查询成功",
    "data": {
        "MF_BOM": [      //返回单据表头信息
            {
                "BOM_NO": "A2002->",
                "NAME": "A2002制成品",
                "PRD_NO": "A2002",
                "WH_NO": "A000",
                "PRD_KND": "2",
                "UNIT": "1",
                "QTY": 1.0,
                "CST_MAKE": 0.0,
                "CST_PRD": 0.0,
                "CST_MAN": 0.0,
                "CST_OUT": 0.0,
                "USED_TIME": 0.0,
                "CST": 0.0,
                "DEP": "01",
                "USR": "ADMIN",
                "CHK_MAN": "ADMIN",
                "CLS_DATE": "2021-01-29 15:21:09",
                "TIME_CNT": 0.0,
                "DEP_INC": "01",
                "SYS_DATE": "2021-01-29 15:21:09",
                "DEP_INC1": "01",
                "CST_FCP": 0.0,
                "IDX_NO": ""
            }
        ],
        "TF_BOM": [         //返回单据表身信息
            {
                "BOM_NO": "A2002->",
                "ITM": 1,
                "PRD_NO": "A4001",
                "PRD_MARK": "",
                "ID_NO": "",
                "NAME": "A4001原料",
                "WH_NO": "A000",
                "UNIT": "1",
                "QTY": 1.0,
                "REM": "",
                "ZC_NO": "",
                "USEIN_NO": "",
                "QTY_BAS": 1.0,
                "UP_STD": 0.0,
                "PRE_ITM": 1,
                "QTY_LOST_FIX": 0.0,
                "QTY_BL_FIX": 0.0,
                "PRD_SPC": "",
                "PRD_KND": "4",
                "PRD_NO1": "A4001",
                "PRD_NAME_ENG": ""
            },
            {
                "BOM_NO": "A2002->",
                "ITM": 2,
                "PRD_NO": "A4002",
                "PRD_MARK": "",
                "ID_NO": "",
                "NAME": "A4002原料",
                "WH_NO": "A000",
                "UNIT": "1",
                "QTY": 2.0,
                "ZC_NO": "",
                "USEIN_NO": "",
                "QTY_BAS": 1.0,
                "UP_STD": 0.0,
                "PRE_ITM": 2,
                "QTY_LOST_FIX": 0.0,
                "QTY_BL_FIX": 0.0,
                "PRD_SPC": "",
                "PRD_KND": "4",
                "PRD_NO1": "A4002",
                "PRD_NAME_ENG": ""
            }
        ],
        "BILL_STATE": {
            "READONLY": false,       //false表示此允许删除,true表示不允许删除
            "READONLY_REM": []       //显示不允许删除的理由说明
        }
    }
}