API中心

  1. 基本档案
  2. 收支项目
返回

收支项目查询

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

参数填写指南

请求方式:POST

请求参数(header):

参数填写指南
参数名必填描述默认值
Content-Type是请求体数据类型application/json
usercode是用户
password是密码
system是系统参数

请求参数(body):

参数名类型是否数组必填描述默认值
code否否收支项目编码
corp_code否是公司编码
creatorcorpcode否否创建公司编码
endTs否否结束ts
isexpensepro否否是否费用项目
mnecode否否助记码
name否否收支项目名称
startTs否否起始ts

返回类型参数:

参数名类型是否数组必填描述默认值
billvo返回数据字段说明
cfitemcodestring否否对应现金流量编码
cfitemnamestring否否对应现金流量名称
costcodestring否否项目编码
costnamestring否否项目名称
createcorpcodestring否否创建公司编码
createcorpnamestring否否创建公司名称
creatorcorpstring否否创建公司主键
def1~5string否否自定义项1~5
drint否否删除标志
free1~10string否否自由项1~10
incomeflagboolean否否是否收入
ioflagboolean否否是否收支
isactiveapprboolean否否是否主动下拨
isbalancesubjboolean否否是否结算项目
isexpenseprostring否否是否费用项目
memostring否否备注
mnecodestring否否助记码
outflagboolean否否是否支出
parentcodestring否否上级收支项目编码
parentnamestring否否上级收支项目名称
pk_cashflowstring否否对应现金流量项目主键
pk_corpstring否否公司主键
pk_costsubjstring否否收支项目主键
pk_parentstring否否上级收支项目主键
pk_sourcestring否否源收支项目
sealflagboolean否否封存标志
sourcecodestring否否源收支项目编码
sourcenamestring否否源收支项目名称
tsstring否否时间戳
unitcodestring否否公司编码
unitnamestring否否公司名称

代码示例:

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

请求参数示例:

复制代码

{"corp_code":"9000","startTs":"2021-08-09 14:32:00","endTs":"2021-08-10 14:32:00"}

正确返回示例:

复制代码

{
 "status": "success",
"data": "{\"allcount\":14,\"retcount\":14,\"datas\":[{\"pk_costsubj\":\"100214100000000002BD\",\"pk_corp\":\"1002\",\"unitcode\":\"9000\",\"unitname\":\"下雨\",\"costcode\":\"1\",\"costname\":\"收支1\",\"memo\":\"\",\"ioflag\":true,\"sealflag\":false,\"creatorcorp\":\"0001\",\"createcorpcode\":\"0001\",\"createcorpname\":\"集团\",\"pk_source\":\"0001141000000000066E\",\"sourcecode\":\"1\",\"sourcename\":\"收支1\",\"isbalancesubj\":false,\"mnecode\":\"\",\"isexpensepro\":true,\"modProperty\":\"false\",\"modsubcorpdate\":\"false\",\"modsubdata\":\"false\",\"modSuper\":\"false\",\"sealsubcorpdata\":\"false\",\"sealsubdata\":\"false\",\"ts\":\"2020-07-09 09:56:48\",\"unseal\":\"false\",\"direction\":\"2\"},{\"pk_costsubj\":\"100214100000000002BF\",\"pk_corp\":\"1002\",\"unitcode\":\"9000\",\"unitname\":\"下雨\",\"costcode\":\"10\",\"costname\":\"收支10\",\"incomeflag\":true,\"memo\":\"\",\"sealflag\":false,\"creatorcorp\":\"0001\",\"createcorpcode\":\"0001\",\"createcorpname\":\"集团\",\"pk_source\":\"0001141000000000066O\",\"sourcecode\":\"10\",\"sourcename\":\"收支10\",\"isbalancesubj\":false,\"mnecode\":\"\",\"isexpensepro\":false,\"modProperty\":\"false\",\"modsubcorpdate\":\"false\",\"modsubdata\":\"false\",\"modSuper\":\"false\",\"sealsubcorpdata\":\"false\",\"sealsubdata\":\"false\",\"ts\":\"2020-07-09 09:56:48\",\"unseal\":\"false\",\"direction\":\"0\"},{\"pk_costsubj\":\"100214100000000002BG\",\"pk_corp\":\"1002\",\"unitcode\":\"9000\",\"unitname\":\"下雨\",\"costcode\":\"2\",\"costname\":\"收支2\",\"memo\":\"\",\"ioflag\":true,\"sealflag\":false,\"creatorcorp\":\"0001\",\"createcorpcode\":\"0001\",\"createcorpname\":\"集团\",\"pk_source\":\"0001141000000000066G\",\"sourcecode\":\"2\",\"sourcename\":\"收支2\",\"isbalancesubj\":false,\"mnecode\":\"\",\"isexpensepro\":true,\"modProperty\":\"false\",\"modsubcorpdate\":\"false\",\"modsubdata\":\"false\",\"modSuper\":\"false\",\"sealsubcorpdata\":\"false\",\"sealsubdata\":\"false\",\"ts\":\"2020-07-09 09:56:48\",\"unseal\":\"false\",\"direction\":\"2\"},{\"pk_costsubj\":\"100214100000000002BH\",\"pk_corp\":\"1002\",\"unitcode\":\"9000\",\"unitname\":\"下雨\",\"costcode\":\"3\",\"costname\":\"收支3\",\"memo\":\"\",\"ioflag\":true,\"sealflag\":false,\"creatorcorp\":\"0001\",\"createcorpcode\":\"0001\",\"createcorpname\":\"集团\",\"pk_source\":\"0001141000000000066H\",\"sourcecode\":\"3\",\"sourcename\":\"收支3\",\"isbalancesubj\":false,\"mnecode\":\"\",\"isexpensepro\":true,\"modProperty\":\"false\",\"modsubcorpdate\":\"false\",\"modsubdata\":\"false\",\"modSuper\":\"false\",\"sealsubcorpdata\":\"false\",\"sealsubdata\":\"false\",\"ts\":\"2020-07-09 09:56:48\",\"unseal\":\"false\",\"direction\":\"2\"},{\"pk_costsubj\":\"100214100000000002BI\",\"pk_corp\":\"1002\",\"unitcode\":\"9000\",\"unitname\":\"下雨\",\"costcode\":\"4\",\"costname\":\"收支4\",\"memo\":\"\",\"ioflag\":true,\"sealflag\":false,\"creatorcorp\":\"0001\",\"createcorpcode\":\"0001\",\"createcorpname\":\"集团\",\"pk_source\":\"0001141000000000066I\",\"sourcecode\":\"4\",\"sourcename\":\"收支4\",\"isbalancesubj\":false,\"mnecode\":\"\",\"isexpensepro\":true,\"modProperty\":\"false\",\"modsubcorpdate\":\"false\",\"modsubdata\":\"false\",\"modSuper\":\"false\",\"sealsubcorpdata\":\"false\",\"sealsubdata\":\"false\",\"ts\":\"2020-07-09 09:56:48\",\"unseal\":\"false\",\"direction\":\"2\"},{\"pk_costsubj\":\"100214100000000002BJ\",\"pk_corp\":\"1002\",\"unitcode\":\"9000\",\"unitname\":\"下雨\",\"costcode\":\"5\",\"costname\":\"收支5\",\"memo\":\"\",\"ioflag\":true,\"sealflag\":false,\"creatorcorp\":\"0001\",\"createcorpcode\":\"0001\",\"createcorpname\":\"集团\",\"pk_source\":\"0001141000000000066J\",\"sourcecode\":\"5\",\"sourcename\":\"收支5\",\"isbalancesubj\":false,\"mnecode\":\"\",\"isexpensepro\":true,\"modProperty\":\"false\",\"modsubcorpdate\":\"false\",\"modsubdata\":\"false\",\"modSuper\":\"false\",\"sealsubcorpdata\":\"false\",\"sealsubdata\":\"false\",\"ts\":\"2020-07-09 09:56:48\",\"unseal\":\"false\",\"direction\":\"2\"},{\"pk_costsubj\":\"100214100000000002BE\",\"pk_corp\":\"1002\",\"unitcode\":\"9000\",\"unitname\":\"下雨\",\"costcode\":\"6\",\"costname\":\"收支6\",\"memo\":\"\",\"ioflag\":true,\"sealflag\":false,\"pk_parent\":\"100214100000000002BD\",\"creatorcorp\":\"0001\",\"createcorpcode\":\"0001\",\"createcorpname\":\"集团\",\"pk_source\":\"0001141000000000066K\",\"sourcecode\":\"6\",\"sourcename\":\"收支6\",\"isbalancesubj\":false,\"mnecode\":\"\",\"isexpensepro\":true,\"modProperty\":\"false\",\"modsubcorpdate\":\"false\",\"modsubdata\":\"false\",\"modSuper\":\"false\",\"sealsubcorpdata\":\"false\",\"sealsubdata\":\"false\",\"ts\":\"2020-07-09 09:56:48\",\"unseal\":\"false\",\"direction\":\"2\"},{\"pk_costsubj\":\"100214100000000002BK\",\"pk_corp\":\"1002\",\"unitcode\":\"9000\",\"unitname\":\"下雨\",\"costcode\":\"7\",\"costname\":\"收支7\",\"memo\":\"\",\"ioflag\":true,\"sealflag\":false,\"creatorcorp\":\"0001\",\"createcorpcode\":\"0001\",\"createcorpname\":\"集团\",\"pk_source\":\"0001141000000000066L\",\"sourcecode\":\"7\",\"sourcename\":\"收支7\",\"isbalancesubj\":false,\"mnecode\":\"\",\"isexpensepro\":true,\"modProperty\":\"false\",\"modsubcorpdate\":\"false\",\"modsubdata\":\"false\",\"modSuper\":\"false\",\"sealsubcorpdata\":\"false\",\"sealsubdata\":\"false\",\"ts\":\"2020-07-09 09:56:48\",\"unseal\":\"false\",\"direction\":\"2\"},{\"pk_costsubj\":\"100214100000000002BL\",\"pk_corp\":\"1002\",\"unitcode\":\"9000\",\"unitname\":\"下雨\",\"costcode\":\"8\",\"costname\":\"收支8\",\"memo\":\"\",\"ioflag\":true,\"sealflag\":false,\"creatorcorp\":\"0001\",\"createcorpcode\":\"0001\",\"createcorpname\":\"集团\",\"pk_source\":\"0001141000000000066M\",\"sourcecode\":\"8\",\"sourcename\":\"收支8\",\"isbalancesubj\":false,\"mnecode\":\"\",\"isexpensepro\":true,\"modProperty\":\"false\",\"modsubcorpdate\":\"false\",\"modsubdata\":\"false\",\"modSuper\":\"false\",\"sealsubcorpdata\":\"false\",\"sealsubdata\":\"false\",\"ts\":\"2020-07-09 09:56:48\",\"unseal\":\"false\",\"direction\":\"2\"},{\"pk_costsubj\":\"100214100000000002BM\",\"pk_corp\":\"1002\",\"unitcode\":\"9000\",\"unitname\":\"下雨\",\"costcode\":\"9\",\"costname\":\"收支9\",\"outflag\":true,\"memo\":\"\",\"sealflag\":false,\"creatorcorp\":\"0001\",\"createcorpcode\":\"0001\",\"createcorpname\":\"集团\",\"pk_source\":\"0001141000000000066N\",\"sourcecode\":\"9\",\"sourcename\":\"收支9\",\"isbalancesubj\":false,\"mnecode\":\"\",\"isexpensepro\":true,\"modProperty\":\"false\",\"modsubcorpdate\":\"false\",\"modsubdata\":\"false\",\"modSuper\":\"false\",\"sealsubcorpdata\":\"false\",\"sealsubdata\":\"false\",\"ts\":\"2020-07-09 09:56:48\",\"unseal\":\"false\",\"direction\":\"1\"},{\"pk_costsubj\":\"100214100000000002BN\",\"pk_corp\":\"1002\",\"unitcode\":\"9000\",\"unitname\":\"下雨\",\"costcode\":\"dst\",\"costname\":\"电商通\",\"memo\":\"\",\"ioflag\":true,\"sealflag\":false,\"creatorcorp\":\"0001\",\"createcorpcode\":\"0001\",\"createcorpname\":\"集团\",\"pk_source\":\"YLS1ZZ1000000000D2AO\",\"sourcecode\":\"dst\",\"sourcename\":\"电商通\",\"isbalancesubj\":false,\"mnecode\":\"\",\"isexpensepro\":true,\"modProperty\":\"false\",\"modsubcorpdate\":\"false\",\"modsubdata\":\"false\",\"modSuper\":\"false\",\"sealsubcorpdata\":\"false\",\"sealsubdata\":\"false\",\"ts\":\"2020-07-09 09:56:48\",\"unseal\":\"false\",\"direction\":\"2\"},{\"pk_costsubj\":\"100214100000000002BO\",\"pk_corp\":\"1002\",\"unitcode\":\"9000\",\"unitname\":\"下雨\",\"costcode\":\"dst01\",\"costname\":\"电商应收\",\"memo\":\"\",\"ioflag\":true,\"sealflag\":false,\"pk_parent\":\"100214100000000002BN\",\"creatorcorp\":\"0001\",\"createcorpcode\":\"0001\",\"createcorpname\":\"集团\",\"pk_source\":\"YLS1ZZ1000000000D2AQ\",\"sourcecode\":\"dst01\",\"sourcename\":\"电商应收\",\"isbalancesubj\":false,\"mnecode\":\"\",\"isexpensepro\":true,\"modProperty\":\"false\",\"modsubcorpdate\":\"false\",\"modsubdata\":\"false\",\"modSuper\":\"false\",\"sealsubcorpdata\":\"false\",\"sealsubdata\":\"false\",\"ts\":\"2020-07-09 09:56:48\",\"unseal\":\"false\",\"direction\":\"2\"},{\"pk_costsubj\":\"100214100000000002BP\",\"pk_corp\":\"1002\",\"unitcode\":\"9000\",\"unitname\":\"下雨\",\"costcode\":\"dst02\",\"costname\":\"电商预收\",\"memo\":\"\",\"ioflag\":true,\"sealflag\":false,\"pk_parent\":\"100214100000000002BN\",\"creatorcorp\":\"0001\",\"createcorpcode\":\"0001\",\"createcorpname\":\"集团\",\"pk_source\":\"YLS1ZZ1000000000D2AS\",\"sourcecode\":\"dst02\",\"sourcename\":\"电商预收\",\"isbalancesubj\":false,\"mnecode\":\"\",\"isexpensepro\":true,\"modProperty\":\"false\",\"modsubcorpdate\":\"false\",\"modsubdata\":\"false\",\"modSuper\":\"false\",\"sealsubcorpdata\":\"false\",\"sealsubdata\":\"false\",\"ts\":\"2020-07-09 09:56:48\",\"unseal\":\"false\",\"direction\":\"2\"},{\"pk_costsubj\":\"100214100000000002BQ\",\"pk_corp\":\"1002\",\"unitcode\":\"9000\",\"unitname\":\"下雨\",\"costcode\":\"dst03\",\"costname\":\"电商费用\",\"memo\":\"\",\"ioflag\":true,\"sealflag\":false,\"pk_parent\":\"100214100000000002BN\",\"creatorcorp\":\"0001\",\"createcorpcode\":\"0001\",\"createcorpname\":\"集团\",\"pk_source\":\"YLS1ZZ1000000000D2AV\",\"sourcecode\":\"dst03\",\"sourcename\":\"电商费用\",\"isbalancesubj\":false,\"mnecode\":\"\",\"isexpensepro\":true,\"modProperty\":\"false\",\"modsubcorpdate\":\"false\",\"modsubdata\":\"false\",\"modSuper\":\"false\",\"sealsubcorpdata\":\"false\",\"sealsubdata\":\"false\",\"ts\":\"2020-10-22 10:23:20\",\"unseal\":\"false\",\"direction\":\"2\"}]}",
  "taskNumber": "202010230010"
}

错误返回示例:

复制代码

{
status: "falied",
errorcode: "-32000",
errormsg: "查询条件不能输入单引号！"
}