查询【其他收入单】接口

概述

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

参数说明

1.请求方式

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

2.header参数

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

3.请求参数

字段名称 字段代号 类型 长度 必填 固定值 备注
程序代号 PGM     MONEXR  
费用识别码 EP_ID string 2 ER  
费用单号 EP_NO string 20   ERP的单据号码

请求JSON示例

{
  “PGM”: “MONEXR”,       //单据程序代号
  “EP_ID”: “ER”,       //单据识别代号
  “EP_NO”: “ER2009160001”       //ERP的单据号码
}

返回结果示例

{
    "code": 0,            //为0表示执行成功,其他表示错误
    "message": "查询成功",           //提示信息
    "data": {
        "MF_EXP": [                 //查询单据表头信息
            {
                "EP_DD": "2020-09-16 00:00:00",
                "EP_ID": "ER",
                "EP_NO": "ER2009160001",
                "USR": "0001",
                "PRT_SW": "N",
                "USR_NO": "0001",
                "OPN_ID": "2",
                "SYS_DATE": "2020-09-16 11:12:16",
                "BIL_TYPE": "01",
                "DEP": "00000000",
                "CHK_MAN": "0001",
                "CLS_DATE": "2020-09-16 00:00:00"
            }
        ],
        "TF_EXP": [                   //查询单据表身信息
            {
                "ITM": 1,
                "IDX_NO": "0001",
                "CUS_NO": "C0001",
                "EXC_RTO": 1.0,
                "TAX_ID": "2",
                "AMT": 500.0,
                "AMTN_NET": 476.19,
                "TAX": 23.81,
                "ARP_NO": "AR2009160001",
                "DEP": "00000000",
                "KP_ID": "F",
                "PAY_REM": "结帐期:2020-10-01;票据到期日:2020-11-01",
                "SAL_NO": "0002",
                "PAY_DD": "2020-10-01 00:00:00",
                "EP_ID": "ER",
                "EP_NO": "ER2009160001",
                "SHARE_MTH": "1",
                "CHK_DD": "2020-11-01 00:00:00",
                "CHK_DAYS": 30,
                "PAY_MTH": "1",
                "PAY_DAYS": 1,
                "INT_DAYS": 30,
                "RTO_TAX": 5.0,
                "KEY_ITM": 1,
                "CAS_NO": "",
                "GEN_VOH": "F",
                "ZHANG_ID": "1",
                "OBJ": "",
                "TAXCODE": ""
            },
            {
                "ITM": 2,
                "IDX_NO": "0002",
                "CUS_NO": "C0001",
                "EXC_RTO": 1.0,
                "TAX_ID": "2",
                "AMT": 800.0,
                "AMTN_NET": 761.9,
                "TAX": 38.1,
                "ARP_NO": "AR2009160002",
                "DEP": "00000000",
                "KP_ID": "F",
                "PAY_REM": "结帐期:2020-10-01;票据到期日:2020-11-01",
                "SAL_NO": "0002",
                "PAY_DD": "2020-10-01 00:00:00",
                "EP_ID": "ER",
                "EP_NO": "ER2009160001",
                "SHARE_MTH": "1",
                "CHK_DD": "2020-11-01 00:00:00",
                "CHK_DAYS": 30,
                "PAY_MTH": "1",
                "PAY_DAYS": 1,
                "INT_DAYS": 30,
                "RTO_TAX": 5.0,
                "KEY_ITM": 2,
                "CAS_NO": "",
                "GEN_VOH": "F",
                "ZHANG_ID": "1",
                "OBJ": "",
                "TAXCODE": ""
            }
        ]
    }
}