webapi查询多账簿科目余额表和多账簿核算维度余额表

栏目:云星空知识作者:金蝶来源:金蝶云社区发布:2024-09-16浏览:1

webapi查询多账簿科目余额表和多账簿核算维度余额表

有不少客户需求从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步进行发布,发布后如下图所示 ![image.webp](/download/0100865676a2d54a49d1a2bd3126bb942882.webp) 查询结果如图: ![image.webp](/download/0100e36e9e6a640b4ed6b7900b5e478cb8e4.webp) 请求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" } } 多账簿核算维度余额表 ![image.webp](/download/01001f6b0207878f4720bc9686646c542140.webp) 请求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 } }

webapi查询多账簿科目余额表和多账簿核算维度余额表

有不少客户需求从webapi获取多账簿科目余额表和多账簿核算维度余额表的问题,此需求在PT-151005 [8.2.0.20231109]中正式支持,但使用前需...
点击下载文档
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息