API中心

  1. 借款报销管理
  2. 借款单
返回

借款单查询

接口所在U8C版本:U8 cloud5.0sp以及更高版本
详细描述:用于借款单查询
API视频讲解API详情补丁列表常见问题参考
接口地址
请求方式
请求参数header
请求参数body
返回类型参数
代码示例
请求参数示例
正确返回示例
错误返回示例
接口地址:http://ip:port/u8cloud/api/er/load/query

参数填写指南

请求方式:POST

请求参数(header):

参数填写指南
参数名必填描述默认值
Content-Type是请求体数据类型application/json
usercode是用户
password是密码
trantype否翻译类型，按编码为code，不需要翻译为pkcode
system是系统参数

请求参数(body):

参数名类型是否数组必填描述默认值
code否否单据编码
corp否是公司编码
date_begin否否单据日期开始
date_end否否单据日期结束
djzt否否单据状态
jkbxr否否借款人
lrr否否录入人
pk_jkbx否否单据主键
spzt否否审批状态
ts_begin否否时间戳开始（5.2及以后版本支持）
ts_end否否时间戳结束（5.2及以后版本支持）

返回类型参数:

参数名类型是否数组必填描述默认值
No Data

代码示例:

Java模板示例下载C#模板示例下载

请求参数示例:

复制代码

{"code":"CLJK2308160012","corp":"3801"}

正确返回示例:

复制代码

{
    "status": "success",
    "data": "{\"allcount\":1,\"retcount\":1,\"queryallsql\":\"select distinct er_jkzb.cbillid, er_jkzb.vcode from er_jkzb inner join er_busitem on er_jkzb.pk_jkbx = er_busitem.pk_jkbx where er_jkzb.dr = 0 and er_busitem.dr = 0 and zb.djbh = 'CLJK2308170001' and zb.pk_corp in (select pk_corp from bd_corp where unitcode = '3801') order by er_jkzb.djbh\",\"datas\":[{\"parentvo\":{\"djbh\":\"CLJK2308170001\",\"djrq\":\"2023-07-27\",\"pk_corp\":\"1019\",\"pk_corp_code\":\"3801\",\"pk_corp_name\":\"zz保险股份有限公司\",\"lrr\":\"0001A2100000000000Y8\",\"lrr_code\":\"apilym\",\"lrr_name\":\"lym\",\"ybje\":\"2358.00000000\",\"djlxbm\":\"2631\",\"bzbm\":\"00010000000000000001\",\"bzbm_code\":\"CNY\",\"bzbm_name\":\"人民币\",\"bbhl\":\"1.00000000\",\"qcbz\":false,\"djzt\":\"1\",\"spzt\":\"-1\",\"shr\":\"0001A2100000000000Y8\",\"shr_code\":\"apilym\",\"shr_name\":\"lym\",\"enduser\":\"0001A2100000000000Y8\",\"enduser_code\":\"apilym\",\"enduser_name\":\"lym\",\"pk_jkbx\":\"1019ZZ1000000000DZUY\",\"ts\":\"2023-08-18 10:50:12\",\"dwbm\":\"1019\",\"dwbm_code\":\"3801\",\"dwbm_name\":\"zz保险股份有限公司\",\"fydwbm\":\"1019\",\"fydwbm_code\":\"3801\",\"fydwbm_name\":\"zz保险股份有限公司\",\"zfdwbm\":\"1019\",\"zfdwbm_code\":\"3801\",\"zfdwbm_name\":\"zz保险股份有限公司\",\"jkbxr\":\"0001A110000000029EOU\",\"jkbxr_code\":\"HI2304130007\",\"jkbxr_name\":\"赵小稳\",\"fydeptid\":\"3801-_-1001         \",\"deptid\":\"3801-_-1001         \",\"yjye\":\"2358.00000000\",\"payflag\":\"1\",\"ispaypublic\":false,\"szxmid\":\"1019A210000000001S1R\",\"reimrule\":\"报销标准:\",\"iscostshare\":false,\"total\":\"2380.00000000\",\"cjkybje\":\"0.00000000\",\"cjkbbje\":\"0.00000000\",\"hkybje\":\"0.00000000\",\"hkbbje\":\"0.00000000\",\"zfybje\":\"2358.00000000\",\"zfbbje\":\"2358.00000000\",\"fjzs\":\"1\",\"iscjk\":true,\"sxbz\":\"0\"},\"finitem\":[null,null],\"bxbusitemvos\":[{\"amount\":\"1234.00000000\",\"tablecode\":\"arap_bxbusitem\",\"defitem1\":\"2023-05-17\",\"defitem5\":\"2023-06-02\",\"defitem10\":\"12\",\"defitem11\":\"1234.00\",\"defitem49\":\"0.000000\",\"defitem50\":\"0.000000\",\"ts\":\"2023-08-18 10:50:11\",\"pk_jkbx\":\"1019ZZ1000000000DZUY\",\"pk_busitem\":\"0001ZZ10000000042L0U\",\"szxmid\":\"1019A210000000001S1R\",\"binputtaxmny\":\"0.00000000\",\"notaxmny\":\"0.00000000\",\"othermny\":\"0.00000000\",\"ticketmny\":\"0.00000000\",\"pk_reimtype\":\"0001A21000000000V3N4\",\"pk_reimtype_code\":\"01\",\"pk_reimtype_name\":\"一般报销\"},{\"amount\":\"1124.00000000\",\"tablecode\":\"other\",\"defitem48\":\"0.000000\",\"ts\":\"2023-08-18 10:50:11\",\"pk_jkbx\":\"1019ZZ1000000000DZUY\",\"pk_busitem\":\"0001ZZ10000000042L0V\",\"szxmid\":\"0001A21000000001I6DQ\",\"szxmid_code\":\"121501010101\",\"szxmid_name\":\"弃西歌皆天今\",\"binputtaxmny\":\"0.00000000\",\"notaxmny\":\"1124.00000000\",\"othermny\":\"0.00000000\",\"ticketmny\":\"1124.00000000\",\"pk_reimtype\":\"0001A21000000000V3N4\",\"pk_reimtype_code\":\"01\",\"pk_reimtype_name\":\"一般报销\"}],\"contrastvo\":[],\"cShareDetailVo\":[]}]}",
    "taskNumber": "202308180020"
}

错误返回示例:

复制代码

{
    "status": "falied",
    "errorcode": "-32000",
    "errormsg": "U8C返回信息:下列查询条件必须输入：[corp]",
    "taskNumber": "202308160056"
}