有不少客户需求从webapi获取多账簿科目余额表和多账簿核算维度余额表的问题,此需求在PT-151005 [8.2.0.20231109]中正式支持,但使用前需要注意如下事项:
1.因系统目前仅支持简单账表的webapi查询,系统中现有的两个多账簿账表因需要树形控件支持,所以元数据类型是动态表单,并非标准的简单账表(这也是一直不支持webapi的原因),此次是将两个账表重写为简单账表,来使用平台统一支持的webapi,使用单据体列表呈现。
2.因1中原因,webapi获取到的数据类似于现有账表引出的格式,未实现树形展开与合并
3.因webapi测试页面需要依赖系统的菜单发布,所以如需使用webapi测试页面进行测试,需要将两个账表从boside发布到主控台菜单后,方可在webapi测试页面显示,两个元数据id分别是(GL_RPT_MULTIACCOUNTBOOK多账簿科目余额表、GL_RPT_MULTIACCOUNTBOOKFLEXITEM多账簿核算维度余额表)
4.放出之后,方可正常使用webapi测试,如果生产环境仅调用,可不用进行第3步进行发布,发布后如下图所示
查询结果如图:
请求json样例如下:
{
“FieldKeys”: “FAccountBookName,FBALANCEID,FBALANCENAME,FACCTTYPE,FACCTGROUP,FDETAILNUMBER,FDETAILNAME,FBEGINDEBIT,FBEGINCREDIT,FDebit,FCredit,FytdDebit,FytdCredit,FENDDEBIT,FENDCREDIT,FPROFITDEBIT,FPROFITCREDIT,FYTDPROFITDEBIT,FYTDPROFITCREDIT”,
“SchemeId”: “”,
“StartRow”: 0,
“Limit”: 2000,
“IsVerifyBaseDataField”: “true”,
“FilterString”: [],
“Model”: {
“FSchemeID”: {
“FNumber”: “001”
},
“FCURRENCY”: “1”,
“FSTARTYEAR”: “2012”,
“FSTARTPERIOD”: “7”,
“FENDYEAR”: “2026”,
“FBALANCELEVEL”: “1”,
“FENDPERIOD”: “2”,
“FSHOWDETAIL”: true,
“FFORBIDBALANCE”: true,
“FNOTPOSTVOUCHER”: false,
“FBALANCEZERO”: true,
“FNOBUSINESS”: false,
“FPERIODNOBALANCE”: true,
“FYEARNOBALANCE”: true,
“FLEVEL”: “1”,
“FSHOWFULLNAME”: false,
“FSHOWDETAILONLY”: false,
“FEXCLUDEADJUSTVCH”: false,
“FSAMEDIRECTION”: false,
“FSHOWQTYPRC”: false,
“FShowEveryAcctName”: false,
“FACCTBOOKRadioGrp”: “0”
}
}
多账簿核算维度余额表
请求json样例:
{
“FieldKeys”: “FSCHEMENAME,FYEAR,FPERIOD,FDETAILNUMBER,FDETAILNAME,FBEGINDEBIT,FBEGINCREDIT,FDEBIT,FCREDIT,FYTDDEBIT,FYTDCREDIT,FENDDEBIT,FENDCREDIT”,
“SchemeId”: “”,
“StartRow”: 0,
“Limit”: 2000,
“IsVerifyBaseDataField”: “true”,
“FilterString”: [],
“Model”: {
“FSCHEMEID”: {
“FNumber”: “001”
},
“FCURRENCYID”: “1”,
“FSTARTYEAR”: “2012”,
“FENDYEAR”: “2026”,
“FSTARTPERIOD”: “7”,
“FENDPERIOD”: “2”,
“FBALANCE”: {
“FNumber”: “1122”
},
“FDETAILGROUP”: “BD_Supplier”,
“FORBIDBALANCE”: true,
“FNOTPOSTVOUCHER”: false,
“FLEVEL”: “蓝海实业集团”,
“FFORBIDDETIAL”: true,
“FDETIALZERO”: false,
“FAMOUNTZERO”: false,
“FLEVELID”: “1”,
“FEXCLUDEADJUSTVCH”: false,
“FSAMEDIRECTION”: false,
“FFLEXLEVEL”: “0”,
“FMergeBalance”: false
}
}