批量查询【销货单】接口

概述

该接口主要用于第三方平台或自主研发者,需要通过日期、单号、部门批量查询ERP系统的单据时,则可调用该单据的批量查询接口,将Sunlike ERP或Online ERP系统中的批量单据信息查询到第三方平台中。

参数说明

请求方式

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

header参数

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

请求参数

字段名称 字段代号 类型 长度 必填 固定值 备注
程序代号 PGM     DRPSA  
单据别 PS_ID String 2 SA  
单据号码 PS_NO String 20     ERP的单据号码,可多张单号,加中括号[],单号之间用豆号隔开,如”PS_NO”:[“PR11110001″,”PR11110002”]
单据日期类型 DATE_TYPE String 1   0表示单据日期,1表示制单日期,2表示终审日期,3修改日期
开始日期 START_DATE datetime       从开始日期开始查询单据,当单号为空时,日期必填
结束日期 END_DATE datetime       查询以结束日期截止的单据,当单号为空时,日期必填
单据部门 DEP string 8     多个部门,用中括号[]包住多个部门,以豆号隔开,不含下属部门,如”DEP”:[“01″,”02”];单个部门,不用中括号,有含下属
排序 ORDER_BY         例如:
“ORDER BY”:{“PS_NO”:”DESC”,      “CUS_NO”:”ASC”}

请求JSON示例

{
  "PGM":"DRPSA",   //程序代号
  "PS_ID":"SA",    //单据别,但若单据无单据别,该参数可不用
  "PS_NO":"",   //按单号查询,可多张单号,加中括号[],单号之间用豆号隔开
  "DATE_TYPE":0,        //0表示单据日期,1表示制单日期,2表示终审日期,3修改日期
  "START_DATE":"2021-01-22",  //查询的开始日期
  "END_DATE":"2021-01-31",   //查询的结束日期
  "DEP":"00000000",      //有[]表示多选,不含下属部门;没有[]表示单选且含下属
  "ORDER_BY":{        //排序规则
      "PS_NO":"DESC",   //DESC表示降序排序
      "CUS_NO":"ASC"    //ASC表示升序排序
  }
}

返回结果示例

{
    "code": 0,     //0表示执行成功
    "message": "查询成功",
    "data": {
        "UP_DD": "2021-01-22 16:57:20",    //本次查询单据的最大单据日期
        "TOTAL_NUM": 1,      //本次查询单据的总单量,每次查询最大返回5000笔
        "BILL_LIST": [       //本次查询单据的单据明细
            {
                "MF_PSS": [
                    {
                        "PS_ID": "SA",
                        "PS_NO": "SA11220001",
                        "PS_DD": "2021-01-22 00:00:00",
                        "PAY_DD": "2021-02-01 00:00:00",
                        "CHK_DD": "2021-03-01 00:00:00",
                        "CUS_NO": "0001",
                        "CUS_NAME": "0001客户",
                        "DEP": "0104",
                        "DEP_NAME": "总部-销售部",
                        "TAX_ID": "1",
                        "SEND_MTH": "1",
                        "ZHANG_ID": "1",
                        "CUR_ID": "",
                        "EXC_RTO": 1.00000000,
                        "SAL_NO": "10001",
                        "SAL_NAME": "10001员工",
                        "ARP_NO": "AR11220001",
                        "ARP_DD": "2021-01-22 00:00:00",
                        "PAY_MTH": "1",
                        "PAY_DAYS": 1,
                        "CHK_DAYS": 30,
                        "INT_DAYS": 30,
                        "PAY_REM": "结帐期:2021-02-01;票据到期日:2021-03-01",
                        "USR": "ADMIN",
                        "CHK_MAN": "ADMIN",
                        "PRT_SW": "N",
                        "CLS_DATE": "2021-01-22 00:00:00",
                        "CK_CLS_ID": "F",
                        "LZ_CLS_ID": "F",
                        "YD_ID": "T",
                        "BIL_TYPE": "",
                        "AMTN_RCV": 0.00000000,
                        "SYS_DATE": "2021-01-22 16:46:12",
                        "REM": "112233",
                        "TOT_QTY": 1.00000000,
                        "CFM_ID": "T",
                        "KP_ID": "F",
                        "ISSVS": "F",
                        "AMT": 123.00000000,
                        "MODIFY_DD": "2021-01-22 16:57:20",
                        "MODIFY_MAN": "ADMIN",
                        "OFF_OS_NO": "",
                        "AMTN_TAX_IRP": 0.00000000,
                        "AMT_TAX_IRP": 0.00000000,
                        "BIL_FILE_COUNT": 0
                    }
                ],
                "TF_PSS": [
                    {
                        "PS_ID": "SA",
                        "PS_NO": "SA11220001",
                        "ITM": 1,
                        "PS_DD": "2021-01-22 00:00:00",
                        "WH": "A000",
                        "PRD_NO": "00001",
                        "PRD_NAME": "00001货品",
                        "PRD_MARK": "",
                        "UNIT": "1",
                        "PRM_NO": "",
                        "QTY": 1.00000000,
                        "UP": 123.00000000,
                        "AMTN_NET": 123.00000000,
                        "AMT": 123.00000000,
                        "UP_SALE": 123.00000000,
                        "AMTN_SALE": 123.00000000,
                        "PRE_ITM": 1,
                        "CSTN_SAL": -7.42000000,
                        "TAX": 0.00000000,
                        "OTH_ITM": 1,
                        "CST_STD": 0.00000000,
                        "TAX_RTO": 5.00000000,
                        "TRANSM": "0",
                        "LOGIST": "0",
                        "TPL_NO": "001",
                        "NOJF_ID": "F",
                        "ACT_DSC": "",
                        "ACT_REM": "",
                        "CHK_XZL": "T",
                        "CHK_TAX": "F",
                        "TAXCODE": "",
                        "UP_DIS_CNT": 123.00,
                        "QTY_BAR": 0.00,
                        "PRD_NO_NO": "00001",
                        "CST_STD_UNIT": 0.00,
                        "UP_CST": -7.42,
                        "WLGL_UP": "123.00000000"
                    }
                ],
                "BILL_STATE": {     //查询本单是否允许删除,true则不允许删除,false则允许删除
                    "READONLY": false,
                    "READONLY_REM": []
                }
            }
        ]
    }
}