U8C API中心

API中心

总账
账表查询

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

辅助余额表查询

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

详细描述:对应的是U8C界面【辅助余额表】节点。请注意与【科目辅助余额表】区分，这个容易混

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

接口地址

请求方式

请求参数header

请求参数body

返回类型参数

代码示例

请求参数示例

正确返回示例

错误返回示例

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

参数填写指南

请求方式:POST

请求参数(header):

参数填写指南

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

请求参数(body):

参数名	类型	是否数组	必填	描述
assvo		是	是	辅助核算
checktypecode	string	否	是	辅助核算类型编码
checkvaluecode	string	否	是	辅助核算的值编码
endPeriod		否	否	查询会计期间至
includeErrorVoucher		否	否	是否包含错误凭证
includeInstVoucher		否	否	是否包含实时凭证
includeUntallyVoucher		否	否	是否包含未记账凭证
isContainEndClass		否	否	是否包含所有末级科目
isShowHasOccurButZeroBalance		否	否	无余额有发生不显示（5.2及以后版本）
isShowZeroAmountRec		否	否	无余额无发生（5.2及以后版本）
isShowZeroOccor		否	否	有余额无发生是否显示（5.1及以后版本）
pk_accsubj		是	否	会计科目
pk_corp		否	否	公司
pk_glorgbook		否	否	主体账簿
startPeriod		否	否	查询会计期间从

返回类型参数:

参数名	类型	是否数组	必填	描述
datas
creditAccumAmount	string	否	否	贷方累计(原币)
creditAccumAuxAmount	string	否	否	贷方累计(辅币)
creditAccumLocAmount	string	否	否	贷方累计(本币)
creditAccumQuant	string	否	否	贷方累计(数量)
creditAmount	string	否	否	本期贷方发生额(原币)
creditAuxAmount	string	否	否	本期贷方发生额(辅币)
creditLocAmount	string	否	否	本期贷方发生额(本币)
creditQuant	string	否	否	本期贷方(数量)
debitAccumAmount	string	否	否	借方累计(原币)
debitAccumAuxAmount	string	否	否	借方累计(辅币)
debitAccumLocAmount	string	否	否	借方累计(本币)
debitAccumQuant	string	否	否	借方累计(数量)
debitAmount	string	否	否	本期借方发生额(原币)
debitAuxAmount	string	否	否	本期借方发生额(辅币)
debitLocAmount	string	否	否	本期借方发生额(本币)
debitQuant	string	否	否	本期借方(数量)
endCreditAmount	string	否	否	期末贷方余额(原币)
endCreditAuxAmount	string	否	否	期末贷方余额(辅币)
endCreditLocAmount	string	否	否	期末贷方余额(本币)
endCreditQuant	string	否	否	期末贷方余额(数量)
endDebitAmount	string	否	否	期末借方余额(原币)
endDebitAuxAmount	string	否	否	期末借方余额(辅币)
endDebitLocAmount	string	否	否	期末借方余额(本币)
endDebitQuant	string	否	否	期末借方余额(数量)
endOrient	string	否	否	期末方向
glqueryassvo	balanceass_glqueryassvo	是	否	辅助核算项目
asscode	string	否	否	辅助核算项编码
assname	string	否	否	辅助核算项名称
asstypecode	string	否	否	辅助核算项类型
asstypeid	string	否	否	辅助核算项类型主键
asstypename	string	否	否	辅助核算项类型名称
pk_assvalue	string	否	否	辅助核算项主键
initCreditAmount	string	否	否	期初贷方余额(原币)
initCreditAuxAmount	string	否	否	期初贷方余额(辅币)
initCreditLocAmount	string	否	否	期初贷方余额(本币)
initCreditQuant	string	否	否	期初贷方余额(数量)
initDebitAmount	string	否	否	期初借方余额(原币)
initDebitAuxAmount	string	否	否	期初借方余额(辅币)
initDebitLocAmount	string	否	否	期初借方余额(本币)
initDebitQuant	string	否	否	期初借方余额(数量)
initOrient	string	否	否	期初方向
pk_accsubj	string	否	否	科目主键
pk_accsubj_code	string	否	否	科目编码
pk_accsubj_name	string	否	否	科目编名称
pk_corp	string	否	否	公司主键
pk_corp_code	string	否	否	公司编码
pk_corp_name	string	否	否	公司名称
pk_glorgbook	string	否	否	账簿主键

代码示例:

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

请求参数示例:

复制代码

{
    "pk_corp": "01010103",
    "pk_glorgbook":"01010103-N/A-001",
    "startPeriod":"2023-07",
    "endPeriod":"2023-07",
   "pk_accsubj":["1122","112202"],
    "includeErrorVoucher":"true",
    "includeUntallyVoucher":"true",
    "includeInstVoucher":"false",
   "assvo":[{"checktypecode":"73","checkvaluecode":"0101010303,010201"},{"checktypecode":"jobass","checkvaluecode":"OEM公摊"},{"checktypecode":"2","checkvaluecode":"公共部门"}]
}

正确返回示例:

复制代码

{
    "status": "success",
    "data": "{\"allcount\":4,\"retcount\":4,\"datas\":[{\"pk_corp\":\"1006\",\"pk_corp_code\":\"01010103\",\"pk_corp_name\":\"xxxxxxxxxxxx有限公司\",\"pk_glorgbook\":\"00011210000000000MX1\",\"glorgbook_code\":\"01010103-N/A-001\",\"glorgbook_name\":\"xxxxxxxxxxxx有限公司WINKING集团财务核算账簿（人民币）\",\"initDebitQuant\":\"0.00000000\",\"initDebitAmount\":\"771340.00000000\",\"initDebitAuxAmount\":\"0.00000000\",\"initDebitLocAmount\":\"5595068.96000000\",\"initCreditQuant\":\"0.00000000\",\"initCreditAmount\":\"0.00000000\",\"initCreditAuxAmount\":\"0.00000000\",\"initCreditLocAmount\":\"0.00000000\",\"debitQuant\":\"0.00000000\",\"debitAmount\":\"-500000.00000000\",\"debitAuxAmount\":\"0.00000000\",\"debitLocAmount\":\"-3626850.00000000\",\"creditQuant\":\"0.00000000\",\"creditAmount\":\"0.00000000\",\"creditAuxAmount\":\"0.00000000\",\"creditLocAmount\":\"30091.61000000\",\"debitAccumQuant\":\"0.00000000\",\"debitAccumAmount\":\"0.00000000\",\"debitAccumAuxAmount\":\"0.00000000\",\"debitAccumLocAmount\":\"290217.94000000\",\"creditAccumQuant\":\"0.00000000\",\"creditAccumAmount\":\"630000.00000000\",\"creditAccumAuxAmount\":\"0.00000000\",\"creditAccumLocAmount\":\"4629563.15000000\",\"endDebitQuant\":\"0.00000000\",\"endDebitAmount\":\"271340.00000000\",\"endDebitAuxAmount\":\"0.00000000\",\"endDebitLocAmount\":\"1938127.35000000\",\"endCreditQuant\":\"0.00000000\",\"endCreditAmount\":\"0.00000000\",\"endCreditAuxAmount\":\"0.00000000\",\"endCreditLocAmount\":\"0.00000000\",\"pk_accsubj\":\"00011210000000001OXO\",\"pk_accsubj_code\":\"1122\",\"pk_accsubj_name\":\"应收账款\",\"glqueryassvo\":[{\"asscode\":\"公共部门\",\"assname\":\"公共部门\",\"pk_assvalue\":\"000112100000000027JB\",\"asstypecode\":\"2\",\"asstypename\":\"部门档案\",\"asstypeid\":\"00010000000000000002\"},{\"asscode\":\"0101010303\",\"assname\":\"xxxxxxxxxxxx\",\"pk_assvalue\":\"00011210000000000MA5\",\"asstypecode\":\"73\",\"asstypename\":\"客商辅助核算\",\"asstypeid\":\"00010000000000000073\"},{\"asscode\":\"OEM公摊\",\"assname\":\"OEM公摊\",\"pk_assvalue\":\"000112100000000026J3\",\"asstypecode\":\"jobass\",\"asstypename\":\"项目辅助核算\",\"asstypeid\":\"UAP00000000000jobass\"}],\"endOrient\":\"借\",\"initOrient\":\"借\"},{\"pk_corp\":\"1006\",\"pk_corp_code\":\"01010103\",\"pk_corp_name\":\"xxxxxxxxxxxx有限公司\",\"pk_glorgbook\":\"00011210000000000MX1\",\"glorgbook_code\":\"01010103-N/A-001\",\"glorgbook_name\":\"xxxxxxxxxxxx有限公司WINKING集团财务核算账簿（人民币）\",\"initDebitQuant\":\"0.00000000\",\"initDebitAmount\":\"0.00000000\",\"initDebitAuxAmount\":\"0.00000000\",\"initDebitLocAmount\":\"0.00000000\",\"initCreditQuant\":\"0.00000000\",\"initCreditAmount\":\"1034550.00000000\",\"initCreditAuxAmount\":\"0.00000000\",\"initCreditLocAmount\":\"1034550.00000000\",\"debitAccumQuant\":\"0.00000000\",\"debitAccumAmount\":\"-1178950.00000000\",\"debitAccumAuxAmount\":\"0.00000000\",\"debitAccumLocAmount\":\"-1178950.00000000\",\"creditAccumQuant\":\"0.00000000\",\"creditAccumAmount\":\"1034550.00000000\",\"creditAccumAuxAmount\":\"0.00000000\",\"creditAccumLocAmount\":\"1034550.00000000\",\"endDebitQuant\":\"0.00000000\",\"endDebitAmount\":\"0.00000000\",\"endDebitAuxAmount\":\"0.00000000\",\"endDebitLocAmount\":\"0.00000000\",\"endCreditQuant\":\"0.00000000\",\"endCreditAmount\":\"1034550.00000000\",\"endCreditAuxAmount\":\"0.00000000\",\"endCreditLocAmount\":\"1034550.00000000\",\"pk_accsubj\":\"00011210000000001OXO\",\"pk_accsubj_code\":\"1122\",\"pk_accsubj_name\":\"应收账款\",\"glqueryassvo\":[{\"asscode\":\"公共部门\",\"assname\":\"公共部门\",\"pk_assvalue\":\"000112100000000027JB\",\"asstypecode\":\"2\",\"asstypename\":\"部门档案\",\"asstypeid\":\"00010000000000000002\"},{\"asscode\":\"010201\",\"assname\":\"xxxxxxxxxxxx台灣分公司\",\"pk_assvalue\":\"00011310000000008T34\",\"asstypecode\":\"73\",\"asstypename\":\"客商辅助核算\",\"asstypeid\":\"00010000000000000073\"},{\"asscode\":\"OEM公摊\",\"assname\":\"OEM公摊\",\"pk_assvalue\":\"000112100000000026J3\",\"asstypecode\":\"jobass\",\"asstypename\":\"项目辅助核算\",\"asstypeid\":\"UAP00000000000jobass\"}],\"endOrient\":\"贷\",\"initOrient\":\"贷\"},{\"pk_corp\":\"1006\",\"pk_corp_code\":\"01010103\",\"pk_corp_name\":\"xxxxxxxxxxxx有限公司\",\"pk_glorgbook\":\"00011210000000000MX1\",\"glorgbook_code\":\"01010103-N/A-001\",\"glorgbook_name\":\"xxxxxxxxxxxx有限公司WINKING集团财务核算账簿（人民币）\",\"initDebitQuant\":\"0.00000000\",\"initDebitAmount\":\"771340.00000000\",\"initDebitAuxAmount\":\"0.00000000\",\"initDebitLocAmount\":\"5595068.96000000\",\"initCreditQuant\":\"0.00000000\",\"initCreditAmount\":\"0.00000000\",\"initCreditAuxAmount\":\"0.00000000\",\"initCreditLocAmount\":\"0.00000000\",\"debitQuant\":\"0.00000000\",\"debitAmount\":\"-500000.00000000\",\"debitAuxAmount\":\"0.00000000\",\"debitLocAmount\":\"-3626850.00000000\",\"creditQuant\":\"0.00000000\",\"creditAmount\":\"0.00000000\",\"creditAuxAmount\":\"0.00000000\",\"creditLocAmount\":\"30091.61000000\",\"debitAccumQuant\":\"0.00000000\",\"debitAccumAmount\":\"0.00000000\",\"debitAccumAuxAmount\":\"0.00000000\",\"debitAccumLocAmount\":\"290217.94000000\",\"creditAccumQuant\":\"0.00000000\",\"creditAccumAmount\":\"630000.00000000\",\"creditAccumAuxAmount\":\"0.00000000\",\"creditAccumLocAmount\":\"4629563.15000000\",\"endDebitQuant\":\"0.00000000\",\"endDebitAmount\":\"271340.00000000\",\"endDebitAuxAmount\":\"0.00000000\",\"endDebitLocAmount\":\"1938127.35000000\",\"endCreditQuant\":\"0.00000000\",\"endCreditAmount\":\"0.00000000\",\"endCreditAuxAmount\":\"0.00000000\",\"endCreditLocAmount\":\"0.00000000\",\"pk_accsubj\":\"00011210000000001OXQ\",\"pk_accsubj_code\":\"112202\",\"pk_accsubj_name\":\"应收账款-内部贸易\",\"glqueryassvo\":[{\"asscode\":\"公共部门\",\"assname\":\"公共部门\",\"pk_assvalue\":\"000112100000000027JB\",\"asstypecode\":\"2\",\"asstypename\":\"部门档案\",\"asstypeid\":\"00010000000000000002\"},{\"asscode\":\"0101010303\",\"assname\":\"xxxxxxxxxxxx\",\"pk_assvalue\":\"00011210000000000MA5\",\"asstypecode\":\"73\",\"asstypename\":\"客商辅助核算\",\"asstypeid\":\"00010000000000000073\"},{\"asscode\":\"OEM公摊\",\"assname\":\"OEM公摊\",\"pk_assvalue\":\"000112100000000026J3\",\"asstypecode\":\"jobass\",\"asstypename\":\"项目辅助核算\",\"asstypeid\":\"UAP00000000000jobass\"}],\"endOrient\":\"借\",\"initOrient\":\"借\"},{\"pk_corp\":\"1006\",\"pk_corp_code\":\"01010103\",\"pk_corp_name\":\"xxxxxxxxxxxx有限公司\",\"pk_glorgbook\":\"00011210000000000MX1\",\"glorgbook_code\":\"01010103-N/A-001\",\"glorgbook_name\":\"xxxxxxxxxxxx有限公司WINKING集团财务核算账簿（人民币）\",\"initDebitQuant\":\"0.00000000\",\"initDebitAmount\":\"0.00000000\",\"initDebitAuxAmount\":\"0.00000000\",\"initDebitLocAmount\":\"0.00000000\",\"initCreditQuant\":\"0.00000000\",\"initCreditAmount\":\"1034550.00000000\",\"initCreditAuxAmount\":\"0.00000000\",\"initCreditLocAmount\":\"1034550.00000000\",\"debitAccumQuant\":\"0.00000000\",\"debitAccumAmount\":\"-1178950.00000000\",\"debitAccumAuxAmount\":\"0.00000000\",\"debitAccumLocAmount\":\"-1178950.00000000\",\"creditAccumQuant\":\"0.00000000\",\"creditAccumAmount\":\"1034550.00000000\",\"creditAccumAuxAmount\":\"0.00000000\",\"creditAccumLocAmount\":\"1034550.00000000\",\"endDebitQuant\":\"0.00000000\",\"endDebitAmount\":\"0.00000000\",\"endDebitAuxAmount\":\"0.00000000\",\"endDebitLocAmount\":\"0.00000000\",\"endCreditQuant\":\"0.00000000\",\"endCreditAmount\":\"1034550.00000000\",\"endCreditAuxAmount\":\"0.00000000\",\"endCreditLocAmount\":\"1034550.00000000\",\"pk_accsubj\":\"00011210000000001OXQ\",\"pk_accsubj_code\":\"112202\",\"pk_accsubj_name\":\"应收账款-内部贸易\",\"glqueryassvo\":[{\"asscode\":\"公共部门\",\"assname\":\"公共部门\",\"pk_assvalue\":\"000112100000000027JB\",\"asstypecode\":\"2\",\"asstypename\":\"部门档案\",\"asstypeid\":\"00010000000000000002\"},{\"asscode\":\"010201\",\"assname\":\"xxxxxxxxxxxx台灣分公司\",\"pk_assvalue\":\"00011310000000008T34\",\"asstypecode\":\"73\",\"asstypename\":\"客商辅助核算\",\"asstypeid\":\"00010000000000000073\"},{\"asscode\":\"OEM公摊\",\"assname\":\"OEM公摊\",\"pk_assvalue\":\"000112100000000026J3\",\"asstypecode\":\"jobass\",\"asstypename\":\"项目辅助核算\",\"asstypeid\":\"UAP00000000000jobass\"}],\"endOrient\":\"贷\",\"initOrient\":\"贷\"}]}",
    "taskNumber": "202401050056"
}

错误返回示例:

复制代码

暂无数据