Mappings

Request GLMAST ACCTNO Account Number AcctId 9 Integer BRANCH Branch Number BrCode 2 File to View M/E GLInqType 1 NA String Response JHFREFAPI USRRSTR Account Lvl User Access AcctId.Rstr 32 Rq Branch TITLE Account Title GLAcctInqRec.GLAcctInfoRec.AcctTitle 35 ACTYPE Account Type GLAcctInqRec.GLAcctInfoRec.AcctType GLAcctInqRec.GLAcctInfoRec.BrCode LEVEL Totaling Level GLAcctInqRec.GLAcctInfoRec.GLTotalLvl PRTSUM Print On Summary Reports GLAcctInqRec.GLAcctInfoRec.PrtSumRpt DAILY Show on Daily Reports GLAcctInqRec.GLAcctInfoRec.PrtDlyRpt BALCOD Normal Balance GLAcctInqRec.GLAcctInfoRec.StdBalType PSTFRQ Posting Frequency GLAcctInqRec.GLAcctInfoRec.GLPostFreqUnits TRNTYP Transaction Type GLAcctInqRec.GLAcctInfoRec.StdTrnType MANOFF Mandatory Officer GLAcctInqRec.GLAcctInfoRec.OffReqType COST Cost Center GLAcctInqRec.GLAcctInfoRec.GLCostCtr 3 PROD Product Code GLAcctInqRec.GLAcctInfoRec.GLProdCode CALREP Call Report Code GLAcctInqRec.GLAcctInfoRec.CallRpt1Code 8 CALRP2 GLAcctInqRec.GLAcctInfoRec.CallRpt2Code CALRP3 GLAcctInqRec.GLAcctInfoRec.CallRpt3Code CALRP4 GLAcctInqRec.GLAcctInfoRec.CallRpt4Code DLA7 Date Last Active GLAcctInqRec.GLAcctInfoRec.LastActDt 7 CONS# Consolidated Account Number GLAcctInqRec.GLAcctInfoRec.GLCnsldtAcctId STATUS Status GLAcctInqRec.GLAcctInfoRec.AcctStat OFFICR Officer Code GLAcctInqRec.GLAcctInfoRec.OffCode MANDES Mandatory Description GLAcctInqRec.GLAcctInfoRec.DescReqType ALLPOD Allow POD Transactions GLAcctInqRec.GLAcctInfoRec.PODPostAllwType Cur Calendar Month 1 GLAcctInqRec.GLAcctInfoRec.GLMonthAmtInfoArray.GLMonthAmtInfoRec.CalMonth 4 Cur Calendar Month 10 Cur Calendar Month 11 Cur Calendar Month 12 Cur Calendar Month 2 Cur Calendar Month 3 Cur Calendar Month 4 Cur Calendar Month 5 Cur Calendar Month 6 Cur Calendar Month 7 Cur Calendar Month 8 Cur Calendar Month 9 Prv Calendar Month 1 Prv Calendar Month 10 Prv Calendar Month 11 Prv Calendar Month 12 Prv Calendar Month 2 Prv Calendar Month 3 Prv Calendar Month 4 Prv Calendar Month 5 Prv Calendar Month 6 Prv Calendar Month 7 Prv Calendar Month 8 Prv Calendar Month 9 Cur Calendar Year 1 GLAcctInqRec.GLAcctInfoRec.GLMonthAmtInfoArray.GLMonthAmtInfoRec.CalYr Cur Calendar Year 10 Cur Calendar Year 11 Cur Calendar Year 12 Cur Calendar Year 2 Cur Calendar Year 3 Cur Calendar Year 4 Cur Calendar Year 5 Cur Calendar Year 6 Cur Calendar Year 7 Cur Calendar Year 8 Cur Calendar Year 9 Prv Calendar Year 1 Prv Calendar Year 10 Prv Calendar Year 11 Prv Calendar Year 12 Prv Calendar Year 2 Prv Calendar Year 3 Prv Calendar Year 4 Prv Calendar Year 5 Prv Calendar Year 6 Prv Calendar Year 7 Prv Calendar Year 8 Prv Calendar Year 9 BUC1 Current Year Budget 1 GLAcctInqRec.GLAcctInfoRec.GLMonthAmtInfoArray.GLMonthAmtInfoRec.MonthBdgAmt 11 BUC10 Current Year Budget 10 BUC11 Current Year Budget 11 BUC12 Current Year Budget 12 BUC2 Current Year Budget 2 BUC3 Current Year Budget 3 BUC4 Current Year Budget 4 BUC5 Current Year Budget 5 BUC6 Current Year Budget 6 BUC7 Current Year Budget 7 BUC8 Current Year Budget 8 BUC9 Current Year Budget 9 BUP1 Working Budget 1 GLAcctInqRec.GLAcctInfoRec.GLMonthAmtInfoArray.GLMonthAmtInfoRec.WorkBdgAmt BUP10 Working Budget 10 BUP11 Working Budget 11 BUP12 Working Budget 12 BUP2 Working Budget 2 BUP3 Working Budget 3 BUP4 Working Budget 4 BUP5 Working Budget 5 BUP6 Working Budget 6 BUP7 Working Budget 7 BUP8 Working Budget 8 BUP9 Working Budget 9 EMC1 Current Year MTD Balance 1 GLAcctInqRec.GLAcctInfoRec.GLMonthAmtInfoArray.GLMonthAmtInfoRec.MonthActAmt 13 EMC10 Current Year MTD Balance 10 EMC11 Current Year MTD Balance 11 EMC12 Current Year MTD Balance 12 EMC2 Current Year MTD Balance 2 EMC3 Current Year MTD Balance 3 EMC4 Current Year MTD Balance 4 EMC5 Current Year MTD Balance 5 EMC6 Current Year MTD Balance 6 EMC7 Current Year MTD Balance 7 EMC8 Current Year MTD Balance 8 EMC9 Current Year MTD Balance 9 EMP1 Prior Year Monthly Activity 1 EMP10 Prior Year Monthly Activity 10 EMP11 Prior Year Monthly Activity 11 EMP12 Prior Year Monthly Activity 12 EMP2 Prior Year Monthly Activity 2 EMP3 Prior Year Monthly Activity 3 EMP4 Prior Year Monthly Activity 4 EMP5 Prior Year Monthly Activity 5 EMP6 Prior Year Monthly Activity 6 EMP7 Prior Year Monthly Activity 7 EMP8 Prior Year Monthly Activity 8 EMP9 Prior Year Monthly Activity 9 AGC1 Current Year Average Balance 1 GLAcctInqRec.GLAcctInfoRec.GLMonthAmtInfoArray.GLMonthAmtInfoRec.MonthAvgBalAmt 15 AGC10 Current Year Average Balance 10 AGC11 Current Year Average Balance 11 AGC12 Current Year Average Balance 12 AGC2 Current Year Average Balance 2 AGC3 Current Year Average Balance 3 AGC4 Current Year Average Balance 4 AGC5 Current Year Average Balance 5 AGC6 Current Year Average Balance 6 AGC7 Current Year Average Balance 7 AGC8 Current Year Average Balance 8 AGC9 Current Year Average Balance 9 AGP1 Prior Year Average Balance 1 AGP10 Prior Year Average Balance 10 AGP11 Prior Year Average Balance 11 AGP12 Prior Year Average Balance 12 AGP2 Prior Year Average Balance 2 AGP3 Prior Year Average Balance 3 AGP4 Prior Year Average Balance 4 AGP5 Prior Year Average Balance 5 AGP6 Prior Year Average Balance 6 AGP7 Prior Year Average Balance 7 AGP8 Prior Year Average Balance 8 AGP9 Prior Year Average Balance 9 EOMB1 EOM Balance January GLAcctInqRec.GLAcctInfoRec.GLMonthAmtInfoArray.GLMonthAmtInfoRec.MonthBalAmt EOMB10 EOM Balance October EOMB11 EOM Balance November EOMB12 EOM Balance December EOMB2 EOM Balance February EOMB3 EOM Balance March EOMB4 EOM Balance April EOMB5 EOM Balance May EOMB6 EOM Balance June EOMB7 EOM Balance July EOMB8 EOM Balance August EOMB9 EOM Balance September Current Year Aggregate Balance 1 GLAcctInqRec.GLAcctInfoRec.GLMonthAmtInfoArray.GLMonthAmtInfoRec.SvcPrvdInfo.CIF2020.MonthAggBalAmt Current Year Aggregate Balance 10 Current Year Aggregate Balance 11 Current Year Aggregate Balance 12 Current Year Aggregate Balance 2 Current Year Aggregate Balance 3 Current Year Aggregate Balance 4 Current Year Aggregate Balance 5 Current Year Aggregate Balance 6 Current Year Aggregate Balance 7 Current Year Aggregate Balance 8 Current Year Aggregate Balance 9 Prior Year Aggregate Balance 1 Prior Year Aggregate Balance 10 Prior Year Aggregate Balance 11 Prior Year Aggregate Balance 12 Prior Year Aggregate Balance 2 Prior Year Aggregate Balance 3 Prior Year Aggregate Balance 4 Prior Year Aggregate Balance 5 Prior Year Aggregate Balance 6 Prior Year Aggregate Balance 7 Prior Year Aggregate Balance 8 Prior Year Aggregate Balance 9 Account Type Description GLAcctInqRec.AcctTypeDesc 20 ELIM Elimination Entry GLAcctInqRec.GLAcctInfoRec.SvcPrvdInfo.CIF2020.ElimEntry JHPARB JHBRNM Branch Name GLAcctInqRec.BrDesc 30 SECCOD GL Security Code GLAcctInqRec.GLAcctInfoRec.SvcPrvdInfo.CIF2020.SecCode 6 GLPAR6 P6DESC Product Description GLAcctInqRec.GLProdDesc Status Description GLAcctInqRec.AcctStatDesc CBAL Current Balance GLAcctInqRec.CurBal YESBAL Yesterdays Balance GLAcctInqRec.YestBal NETBAL Todays Net Balance GLAcctInqRec.DlyBalChngAmt BEGCYR Beginning Balance Current Year GLAcctInqRec.BegYrBal BEGPYR Beginning Balance Previous Year GLAcctInqRec.BegLastYrBal Cur Avg YTD Balance GLAcctInqRec.AvgYTDBal File to View PMOBAL Previous Month Balance GLAcctInqRec.SvcPrvdInfo.CIF2020.CurYrLstMonthBal Memo Balance GLAcctInqRec.SvcPrvdInfo.CIF2020.MemoCurBal Prv Avg YTD Balance GLAcctInqRec.SvcPrvdInfo.CIF2020.AvgPrevYrBal