U8C API中心

API中心

总账
凭证

指导视频
对接方案模板
工具
游客

凭证表头查询

接口所在U8C版本:U8 cloud3.1以及更高版本

详细描述:用于凭证表头查询

API视频讲解API详情补丁列表常见问题参考

接口地址

请求方式

请求参数header

请求参数body

返回类型参数

代码示例

请求参数示例

正确返回示例

错误返回示例

接口地址:http://ip:port/u8cloud/api/gl/voucher/pagequeryHead

参数填写指南

请求方式:POST

请求参数(header):

参数填写指南

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

请求参数(body):

参数名	是否数组	必填	描述	默认值
endTs	否	否	结束时间戳（v3.5版本支持）
no_from	否	否	凭证号从
no_to	否	否	凭证号至
page_now	否	是	当前页	1
page_size	否	是	每页条数	5
pk_casher	否	否	出纳人编码
pk_checked	否	否	审核人编码
pk_glorgbook	否	是	主体账簿档案
pk_manager	否	否	记账人编码
pk_prepared	否	否	制单人编码
pk_system	否	否	制单系统编码
pk_vouchertype	否	否	凭证类别简称
prepareddate_from	否	否	制单日期从
prepareddate_to	否	否	制单日期至
startTs	否	否	开始时间戳（v3.5版本支持）

返回类型参数:

参数名	类型	是否数组	必填	描述
vouchervo
casher_code	string	否	否	出纳人编码
casher_name	string	否	否	出纳人名称
checked_code	string	否	否	审核人编码
checked_name	string	否	否	审核人名称
checkeddate	string	否	否	审核日期
detail		是	是	分录
accsubj_code	string	否	否	科目编码
accsubj_name	string	否	否	科目名称
ass		是	否	辅助核算
checktypecode	string	否	否	辅助核算类型编码
checktypename	string	否	否	辅助核算类型名称
checkvaluecode	string	否	否	辅助核算值编码
checkvaluename	string	否	否	辅助核算值名称
pk_checktype	string	否	否	辅助核算类型
pk_checkvalue	string	否	否	辅助核算值
cashflow		是	否	现金流量
cashflow_code	string	否	否	现金流量表项编码
cashflow_name	string	否	否	现金流量表项名称
currtype_code	string	否	否	现金流量币种编码
currtype_name	string	否	否	现金流量币种名称
money	string	否	否	金额
pk_cashflow	string	否	否	现金流量表项
pk_cashflowcase	string	否	否	主键
pk_currtype	string	否	否	现金流量币种
creditamount	double	否	否	原币贷发生额
creditquantity	double	否	否	贷方数量
currtype_code	string	否	否	币种编码
currtype_name	string	否	否	币种名称
debitamount	double	否	否	原币借发生额
debitquantity	double	否	否	借方数量
detailindex	int	否	否	分录号
excrate1	double	否	否	本币汇率
explanation	string	否	否	摘要
localcreditamount	double	否	否	本币贷发生额
localdebitamount	double	否	否	本币借发生额
pk_accsubj	string	否	否	科目主键
pk_currtype	string	否	否	币种主键
pk_detail	string	否	否	表体分录主键
pk_voucher	string	否	否	表头主键
price	double	否	否	单价
discardflag	boolean	否	否	是否作废
explanation	string	否	否	摘要
glorgbook_code	string	否	否	主体账簿编码
glorgbook_name	string	否	否	主体账簿名称
manager_code	string	否	否	记账人编码
manager_name	string	否	否	记账人名称
no	int	否	否	凭证号
period	string	否	否	会计期间
pk_casher	string	否	否	出纳人主键
pk_checked	string	否	否	审核人主键
pk_glorgbook	string	否	否	主体账簿
pk_manager	string	否	否	记账人主键
pk_prepared	string	否	否	制单人主键
pk_system	string	否	否	制单系统
pk_voucher	string	否	否	表头主键
pk_vouchertype	string	否	否	凭证类别
prepared_code	string	否	否	制单人编码
prepared_name	string	否	否	制单人名称
prepareddate	string	否	否	制单日期
signdate	string	否	否	签字日期
signflag	boolean	否	否	是否签字
system_code	string	否	否	制单系统编码
system_name	string	否	否	制单系统名称
tallydate	string	否	否	记账日期
totalcredit	double	否	否	贷方本币金额合计
totaldebit	double	否	否	借方本币金额合计
vouchertype_name	string	否	否	凭证类别名称
year	string	否	否	会计年度

代码示例:

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

请求参数示例:

复制代码

{
　　"includediscard":"N",
　　"no_from":"2",
　　"no_to":"9",
　　"page_now":"1",
　　"page_size":"5",
　　"pk_casher":"14444444005",
　　"pk_checked":"14444444004",
　　"pk_glorgbook":"1000-0002",
　　"pk_manager":"14444444003",
　　"pk_prepared":"14444444002",
　　"pk_system":"FA",
　　"pk_vouchertype":"记账",
　　"prepareddate_from":"2017-01-11",
　　"prepareddate_to":"2018-01-11",
　　"startTs": "2021-08-09 14:32:00",
　　"endTs": "2021-08-10 14:32:00"
}

pk_system【凭证来源系统】字段枚举说明：

XX:外部系统交换平台
CM:成本管理
CMP:现金管理
ARAP:应收应付系统
ERM:报销管理
FA:固定资产
GL:总账
IC:库存管理
MM:生产制造
PO:采购管理
IA:存货核算
SO:销售管理
QC:质量管理
CT:合同管理
SC:委外加工
TO:内部交易
AIM:资产信息管理

正确返回示例:

复制代码

{
"status":"success"
"data":"{"allcount":50,"retcount":5,"datas":[{"pk_glorgbook":"0001F81000000000039D","glorgbook_code":"5000-2018E","glorgbook_name":"09232018会计准则科目","pk_voucher":"1001F8100000000002BY","no":"1","year":"2020","period":"09","prepareddate":"2020-09-23","tallydate":"2020-09-23","pk_prepared":"0001F8100000000000ZI","prepared_code":"15733166089","prepared_name":"陈智鑫","pk_checked":"0001F8100000000000ZI","checked_code":"15733166089","checked_name":"陈智鑫","pk_manager":"0001F8100000000000ZI","manager_code":"15733166089","manager_name":"陈智鑫","pk_vouchertype":"0001DEFAULT000000001","vouchertype_code":"记账","vouchertype_name":"记账凭证","explanation":"总账","totaldebit":100,"totalcredit":100,"pk_system":"GL","signflag":false,"discardflag":false,"detail":[],"pk_corp":"1001","corp_code":"5000","corp_name":"0923"},{"pk_glorgbook":"0001F81000000000039D","glorgbook_code":"5000-2018E","glorgbook_name":"09232018会计准则科目","pk_voucher":"1001F8100000000002C2","no":"2","year":"2020","period":"09","prepareddate":"2020-09-23","tallydate":"2020-09-23","pk_prepared":"0001F8100000000000ZI","prepared_code":"15733166089","prepared_name":"陈智鑫","pk_checked":"0001F8100000000000ZI","checked_code":"15733166089","checked_name":"陈智鑫","pk_manager":"0001F8100000000000ZI","manager_code":"15733166089","manager_name":"陈智鑫","pk_vouchertype":"0001DEFAULT000000001","vouchertype_code":"记账","vouchertype_name":"记账凭证","explanation":"总账凭证","totaldebit":200,"totalcredit":200,"pk_system":"GL","signflag":false,"discardflag":false,"detail":[],"pk_corp":"1001","corp_code":"5000","corp_name":"0923"},{"pk_glorgbook":"0001F81000000000039D","glorgbook_code":"5000-2018E","glorgbook_name":"09232018会计准则科目","pk_voucher":"1001F8100000000002RF","no":"3","year":"2020","period":"09","prepareddate":"2020-09-23","tallydate":"2020-09-23","pk_prepared":"0001F8100000000000ZI","prepared_code":"15733166089","prepared_name":"陈智鑫","pk_checked":"0001F8100000000000ZI","checked_code":"15733166089","checked_name":"陈智鑫","pk_manager":"0001F8100000000000ZI","manager_code":"15733166089","manager_name":"陈智鑫","pk_vouchertype":"0001DEFAULT000000001","vouchertype_code":"记账","vouchertype_name":"记账凭证","explanation":"付款结算单","totaldebit":100,"totalcredit":100,"pk_system":"CMP","signflag":true,"discardflag":false,"detail":[],"pk_corp":"1001","corp_code":"5000","corp_name":"0923"},{"pk_glorgbook":"0001F81000000000039D","glorgbook_code":"5000-2018E","glorgbook_name":"09232018会计准则科目","pk_voucher":"1001F8100000000002RJ","no":"4","year":"2020","period":"09","prepareddate":"2020-09-23","tallydate":"2020-09-23","pk_prepared":"0001F8100000000000ZI","prepared_code":"15733166089","prepared_name":"陈智鑫","pk_checked":"0001F8100000000000ZI","checked_code":"15733166089","checked_name":"陈智鑫","pk_manager":"0001F8100000000000ZI","manager_code":"15733166089","manager_name":"陈智鑫","pk_vouchertype":"0001DEFAULT000000001","vouchertype_code":"记账","vouchertype_name":"记账凭证","explanation":"华章结算单","totaldebit":20,"totalcredit":20,"pk_system":"CMP","signflag":true,"discardflag":false,"detail":[],"pk_corp":"1001","corp_code":"5000","corp_name":"0923"},{"pk_glorgbook":"0001F81000000000039D","glorgbook_code":"5000-2018E","glorgbook_name":"09232018会计准则科目","pk_voucher":"1001F8100000000002RN","no":"5","year":"2020","period":"09","prepareddate":"2020-09-23","tallydate":"2020-09-23","pk_prepared":"0001F8100000000000ZI","prepared_code":"15733166089","prepared_name":"陈智鑫","pk_checked":"0001F8100000000000ZI","checked_code":"15733166089","checked_name":"陈智鑫","pk_manager":"0001F8100000000000ZI","manager_code":"15733166089","manager_name":"陈智鑫","pk_vouchertype":"0001DEFAULT000000001","vouchertype_code":"记账","vouchertype_name":"记账凭证","explanation":"收款结算单","totaldebit":120,"totalcredit":120,"pk_system":"CMP","signflag":true,"discardflag":false,"detail":[],"pk_corp":"1001","corp_code":"5000","corp_name":"0923"}]}"
"taskNumber":"202010220007"
}

错误返回示例:

复制代码

{
  "status": "falied",
  "errorcode": "-32000",
  "errormsg": "U8C返回信息:下列查询条件必须输入：[pk_glorgbook]",
  "stacktrace": "nc.vo.pub.BusinessException: 下列查询条件必须输入：[pk_glorgbook]\r\nu8c.bs.action.query.AbstractQueryAction.convertToConditions(AbstractQueryAction.java:343)\r\nu8c.bs.action.query.AbstractQueryAction.queryVOS(AbstractQueryAction.java:156)\r\nu8c.bs.action.query.AbstractQueryAction.doAction(AbstractQueryAction.java:97)\r\nu8c.bs.invoke.bp.JSONInvokeBP.invoke(JSONInvokeBP.java:80)\r\nu8c.impl.invoke.json.InvokeWithJSonImpl.invoke(InvokeWithJSonImpl.java:29)\r\nsun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\nsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)\r\nsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\njava.lang.reflect.Method.invoke(Method.java:606)\r\nnc.bs.framework.ejb.CMTProxyImpl.delegate(CMTProxyImpl.java:22)\r\nnc.itf.framework.ejb.CMTProxyEjbBean.delegate(CMTProxyEjbBean.java:44)\r\nnc.itf.framework.ejb.CMTProxy_Local.delegate(CMTProxy_Local.java:61)\r\nsun.reflect.GeneratedMethodAccessor50.invoke(Unknown Source)\r\nsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\njava.lang.reflect.Method.invoke(Method.java:606)\r\nnc.bs.framework.ejb.AbstractEJBServiceHandler.invoke(AbstractEJBServiceHandler.java:56)\r\nnc.bs.framework.ejb.AbstractEJBServiceHandler.invoke(AbstractEJBServiceHandler.java:34)\r\ncom.sun.proxy.$Proxy13.delegate(Unknown Source)\r\nnc.bs.framework.ejb.CMTEJBServiceHandler.invoke(CMTEJBServiceHandler.java:32)\r\ncom.sun.proxy.$Proxy59.invoke(Unknown Source)\r\nu8c.vo.oip.task.APITask.execute(APITask.java:93)\r\nu8c.impl.oip.task.APITaskServiceImpl.executeTask(APITaskServiceImpl.java:68)\r\nu8c.server.APIController.forWard(APIController.java:138)\r\nu8c.server.APIServletForJSON.doAction(APIServletForJSON.java:27)\r\nnc.bs.framework.server.extsys.ExtSystemInvokerServlet.doAction(ExtSystemInvokerServlet.java:170)\r\nnc.bs.framework.server.extsys.ExtSystemInvokerServlet.doPost(ExtSystemInvokerServlet.java:76)\r\njavax.servlet.http.HttpServlet.service(HttpServlet.java:641)\r\njavax.servlet.http.HttpServlet.service(HttpServlet.java:722)\r\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)\r\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)\r\norg.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)\r\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)\r\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)\r\nnc.bs.framework.server.LoggerServletFilter.doFilter(LoggerServletFilter.java:34)\r\norg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)\r\norg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)\r\norg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)\r\norg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)\r\norg.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)\r\norg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)\r\norg.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)\r\norg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)\r\norg.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:683)\r\norg.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)\r\norg.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115)\r\norg.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)\r\norg.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)\r\njava.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)\r\njava.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)\r\norg.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)\r\njava.lang.Thread.run(Thread.java:744)\r\n",
  "taskNumber": "202010220011"
}