查询【单厂商付款】接口

概述

该接口主要用于第三方平台或自主研发者,通过调用【单厂商付款】的查询接口,将Sunlike ERP或Online ERP系统中的【单厂商付款】信息调出至第三方平台中显示。

参数说明

1.请求方式

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

2.header参数

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

3.请求参数

字段名称 字段代号 类型 长度 必填 固定值 备注
程序代号 PGM     MONBA  
识别码 RP_ID string 1 2 1:收款;2:付款
收付款单号 RP_NO string 20   ERP的单据号码

请求JSON示例

{
  "PGM": "MONBA",       //单据程序代号
  "RP_ID": "2",       //单据识别代号
  "RP_NO": "PT2009160001"       //ERP的单据号码
}

返回结果示例

{
    "code": 0,             //为0表示执行成功,其他表示错误
    "message": "查询成功",            //提示信息
    "data": {
        "TF_MON": [                 //查询收付款表头冲帐信息
            {
                "RP_ID": "2",
                "RP_NO": "PT2009160001",
                "ITM": 1,
                "IRP_ID": "T",
                "CLS_ID": "F",
                "RP_DD": "2020-09-16 00:00:00",
                "CUS_NO": "C0001",
                "HS_ID": "F",
                "AMTN_TAX": 0.0,
                "AMTN_TAX_IRP": 0.0,
                "AMT_TAX_IRP": 0.0,
                "AMTN_NET_IRP": 0.0,
                "AMT_NET_IRP": 0.0,
                "INCLUDESON": "F",
                "AMTN_BC": 100.0,
                "AMTN_BB": 200.0,
                "AMTN_CHK": 300.0,
                "AMTN_OTHER": 400.0,
                "AMTN_IRP": 0.0,
                "AMTN_CLS": 0.0,
                "AMT_CHK": 0.0,
                "AMT_OTHER": 0.0,
                "AMT_IRP": 0.0,
                "BC_NO": "BT2009160006",
                "CACC_NO": "201",
                "BB_NO": "BT2009160005",
                "BACC_NO": "001",
                "EXC_RTO": 1.0,
                "USR_NO": "0001",
                "DEP": "103",
                "SK_TYPE": "1",
                "USR": "ADMIN",
                "CHK_MAN": "ADMIN",
                "PRT_SW": "N",
                "AMT_CLS": 0.0,
                "CLS_DATE": "2020-09-16 00:00:00",
                "SYS_DATE": "2020-09-16 19:20:48",
                "IEA_ID": "F",
                "IOR_ID": "F"
            }
        ],
        "MF_MON": [                    //查询收付款主库信息
            {
                "RP_ID": "2",
                "RP_NO": "PT2009160001",
                "RP_DD": "2020-09-16 00:00:00",
                "USR_NO": "0001",
                "DEP": "103",
                "AMTN": 1000.0,
                "USR": "ADMIN",
                "CLS_DATE": "2020-09-16 00:00:00",
                "LOCK_MAN": "",
                "FJ_NUM": 0,
                "CAS_NO": ""
            }
        ],
        "TF_MON3": [               //查询其他收入/支出冲帐库信息
            {
                "RP_ID": "2",
                "RP_NO": "PT2009160001",
                "ITM": 1,
                "ITM2": 1,
                "CUR_ID": "",
                "EXC_RTO": 1.0,
                "AMTN": 400.0
            }
        ],
        "TF_MON4": [                //查询票据明细冲帐库信息
            {
                "RP_ID": "2",
                "RP_NO": "PT2009160001",
                "ITM": 1,
                "ITM2": 1,
                "CUR_ID": "",
                "EXC_RTO": 1.0,
                "CHK_ID": "1",
                "CHK_NO": "ZP20200916001",
                "AMTN_CHK": 300.0,
                "CASH_ID": "F",
                "CHK_KND": "0",
                "CUS_NO": "C0001",
                "BANK_NO": "001",
                "BACC_NO": "001",
                "BACC_NO_BAK": "001",
                "END_DD": "2020-09-30 00:00:00",
                "RCV_DD": "2020-09-16 00:00:00",
                "CAH_DD": "2020-09-30 00:00:00",
                "CRECARD_NO": "",
                "ID_CODE": "",
                "CHK_STS": "D"
            }
        ]
    }
}