oracle科目余额表的查询,科目余额表查询 · selfaccount-services · 看云

## 查询某个月的科目余额表

*访问财务数据库并查询某个月的科目余额表*

+++

post:/finicial_getItemBalance

*string:acctId#登录者账号id

*string:custId#客户id

*string:startYearMon#查询开始月份

*string:endYearMon#查询结束月份

<<<

{

"errNum": 0,

"retMsg": "success",

"retData":{

resultnum:20,

resultdetail:[{

subcode:'1001',

grade:'1',

subname:'库存现金',

mbdebit:12000.00,

mbcredit:,

mdebit:12611.99,

mcredit:,

ydebit:128660.00,

ycredit:10800.00,

medebit:1273669.00,

mecredit:

},

{

subcode:'100101',

grade:'2',

subname:'工商银行现金',

mbdebit:12000.00,

mbcredit:,

mdebit:12611.99,

mcredit:,

ydebit:128660.00,

ycredit:10800.00,

medebit:1273669.00,

mecredit:

}]

}

}

* * * * *

errnum:错误代码，0表示成功

retmsg:成功时写入success；失败时写入错误信息

retData:成功时返回业务数据

itemdetailnum:返回记录数目

itemdetail:返回记录详情

subcode:科目编码

grade:科目级别

subname:科目名称

mbdebit:期初借方

mbcredit:期初贷方

mdebit:本期发生借方

mcredit:本期发生贷方

ydebit:本年累计借方

ycredit:本年累计贷方

medebit:期末借方

mecredit:期末贷方

+++