Mappings

Request GLMAST ACCTNO Account number AcctId 7 Integer BRANCH Branch number BrCode 3 CENTER Cost center GLCostCtr 4 PRDCOD Product code GLProdCode FILE TO VIEW M/E/C GLInqType 1 NA String CONSOLIDATION NUMBER GLCnsldtAcctId 2 Response Account Number User Access Acct Level AcctId.Rstr INPUTTED BRANCH NUMB INPUTTED COST CENTER INPUTTED PROD CODE TITLE Account Title GLAcctInqRec.GLAcctInfoRec.AcctTitle 35 ACTYPE Account Type GLAcctInqRec.GLAcctInfoRec.AcctType Branch GLAcctInqRec.GLAcctInfoRec.BrCode LEVEL Totaling Level GLAcctInqRec.GLAcctInfoRec.GLTotalLvl BALCOD Normal Balance GLAcctInqRec.GLAcctInfoRec.StdBalType TRNTYP Transaction Type GLAcctInqRec.GLAcctInfoRec.StdTrnType MANOFF Mandatory Officer GLAcctInqRec.GLAcctInfoRec.OffReqType Responsibility Center: GLAcctInqRec.GLAcctInfoRec.GLCostCtr PSTFRQ Posting Frequency GLAcctInqRec.GLAcctInfoRec.GLPostFreqUnits Product Code: GLAcctInqRec.GLAcctInfoRec.GLProdCode CALRP1 Call Report Code 1 GLAcctInqRec.GLAcctInfoRec.CallRpt1Code 8 CALRP2 Call Report Code 2 GLAcctInqRec.GLAcctInfoRec.CallRpt2Code CALRP3 Call Report Code 3 GLAcctInqRec.GLAcctInfoRec.CallRpt3Code CALRP4 Call Report Code 4 GLAcctInqRec.GLAcctInfoRec.CallRpt4Code DLA7 Last Active Date GLAcctInqRec.GLAcctInfoRec.LastActDt CONACC Consolidated Account Number GLAcctInqRec.GLAcctInfoRec.GLCnsldtAcctId STATUS Status GLAcctInqRec.GLAcctInfoRec.AcctStat OFFICR Officer GLAcctInqRec.GLAcctInfoRec.OffCode 6 Mandatory Description GLAcctInqRec.GLAcctInfoRec.DescReqType RISK Risk Based Code GLAcctInqRec.GLAcctInfoRec.CapitalRiskPct DATOP7 Opened Date GLAcctInqRec.GLAcctInfoRec.OpenDt DLM7 Last Maintenance Date GLAcctInqRec.GLAcctInfoRec.LastMainDt COND1 Condensed Code 1 GLAcctInqRec.GLAcctInfoRec.GLCombStmtInfoArray.GLCombStmtInfoRec.GLCombStmtCode COND2 Condensed Code 2 COND3 Condensed Code 3 COND4 Condensed Code 4 COND5 Condensed Code 5 COND6 Condensed Code 6 COND7 Condensed Code 7 COND8 Condensed Code 8 COND9 Condensed Code 9 Cur Calendar Month 1 GLAcctInqRec.GLAcctInfoRec.GLMonthAmtInfoArray.GLMonthAmtInfoRec.CalMonth 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 Lst Calendar Month 1 Lst Calendar Month 10 Lst Calendar Month 11 Lst Calendar Month 12 Lst Calendar Month 2 Lst Calendar Month 3 Lst Calendar Month 4 Lst Calendar Month 5 Lst Calendar Month 6 Lst Calendar Month 7 Lst Calendar Month 8 Lst Calendar Month 9 Nxt Calendar Month 1 Nxt Calendar Month 10 Nxt Calendar Month 11 Nxt Calendar Month 12 Nxt Calendar Month 2 Nxt Calendar Month 3 Nxt Calendar Month 4 Nxt Calendar Month 5 Nxt Calendar Month 6 Nxt Calendar Month 7 Nxt Calendar Month 8 Nxt 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 Lst Calendar Year 1 Lst Calendar Year 10 Lst Calendar Year 11 Lst Calendar Year 12 Lst Calendar Year 2 Lst Calendar Year 3 Lst Calendar Year 4 Lst Calendar Year 5 Lst Calendar Year 6 Lst Calendar Year 7 Lst Calendar Year 8 Lst Calendar Year 9 Nxt Calendar Year 1 Nxt Calendar Year 10 Nxt Calendar Year 11 Nxt Calendar Year 12 Nxt Calendar Year 2 Nxt Calendar Year 3 Nxt Calendar Year 4 Nxt Calendar Year 5 Nxt Calendar Year 6 Nxt Calendar Year 7 Nxt Calendar Year 8 Nxt 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 CBUD1 Budget 1 Current GLAcctInqRec.GLAcctInfoRec.GLMonthAmtInfoArray.GLMonthAmtInfoRec.MonthBdgAmt 11 CBUD10 Budget 10 Current CBUD11 Budget 11 Current CBUD12 Budget 12 Current CBUD2 Budget 2 Current CBUD3 Budget 3 Current CBUD4 Budget 4 Current CBUD5 Budget 5 Current CBUD6 Budget 6 Current CBUD7 Budget 7 Current CBUD8 Budget 8 Current CBUD9 Budget 9 Current LBUD1 Budget 1 Last Year LBUD10 Budget 10 Last Year LBUD11 Budget 11 Last Year LBUD12 Budget 12 Last Year LBUD2 Budget 2 Last Year LBUD3 Budget 3 Last Year LBUD4 Budget 4 Last Year LBUD5 Budget 5 Last Year LBUD6 Budget 6 Last Year LBUD7 Budget 7 Last Year LBUD8 Budget 8 Last Year LBUD9 Budget 9 Last Year NBUD1 Budget 1 Next Year NBUD10 Budget 10 Next Year NBUD11 Budget 11 Next Year NBUD12 Budget 12 Next Year NBUD2 Budget 2 Next Year NBUD3 Budget 3 Next Year NBUD4 Budget 4 Next Year NBUD5 Budget 5 Next Year NBUD6 Budget 6 Next Year NBUD7 Budget 7 Next Year NBUD8 Budget 8 Next Year NBUD9 Budget 9 Next Year OBUD1 Budget 1 Original GLAcctInqRec.GLAcctInfoRec.GLMonthAmtInfoArray.GLMonthAmtInfoRec.OrigBdgAmt OBUD10 Budget 10 Original OBUD11 Budget 11 Original OBUD12 Budget 12 Original OBUD2 Budget 2 Original OBUD3 Budget 3 Original OBUD4 Budget 4 Original OBUD5 Budget 5 Original OBUD6 Budget 6 Original OBUD7 Budget 7 Original OBUD8 Budget 8 Original OBUD9 Budget 9 Original CMTD1 Mth to date 1 Current GLAcctInqRec.GLAcctInfoRec.GLMonthAmtInfoArray.GLMonthAmtInfoRec.MonthActAmt 13 CMTD10 Mth to date 10 Current CMTD11 Mth to date 11 Current CMTD12 Mth to date 12 Current CMTD2 Mth to date 2 Current CMTD3 Mth to date 3 Current CMTD4 Mth to date 4 Current CMTD5 Mth to date 5 Current CMTD6 Mth to date 6 Current CMTD7 Mth to date 7 Current CMTD8 Mth to date 8 Current CMTD9 Mth to date 9 Current LMTD1 Mth to date 1 Last Yr LMTD10 Mth to date 10 Last Yr LMTD11 Mth to date 11 Last Yr LMTD12 Mth to date 12 Last Yr LMTD2 Mth to date 2 Last Yr LMTD3 Mth to date 3 Last Yr LMTD4 Mth to date 4 Last Yr LMTD5 Mth to date 5 Last Yr LMTD6 Mth to date 6 Last Yr LMTD7 Mth to date 7 Last Yr LMTD8 Mth to date 8 Last Yr LMTD9 Mth to date 9 Last Yr PMTD1 Mth to date 1 Previous PMTD10 Mth to date 10 Previous PMTD11 Mth to date 11 Previous PMTD12 Mth to date 12 Previous PMTD2 Mth to date 2 Previous PMTD3 Mth to date 3 Previous PMTD4 Mth to date 4 Previous PMTD5 Mth to date 5 Previous PMTD6 Mth to date 6 Previous PMTD7 Mth to date 7 Previous PMTD8 Mth to date 8 Previous PMTD9 Mth to date 9 Previous CAVG1 Month avg 1 Current GLAcctInqRec.GLAcctInfoRec.GLMonthAmtInfoArray.GLMonthAmtInfoRec.MonthAvgBalAmt CAVG10 Month avg 10 Current CAVG11 Month avg 11 Current CAVG12 Month avg 12 Current CAVG2 Month avg 2 Current CAVG3 Month avg 3 Current CAVG4 Month avg 4 Current CAVG5 Month avg 5 Current CAVG6 Month avg 6 Current CAVG7 Month avg 7 Current CAVG8 Month avg 8 Current CAVG9 Month avg 9 Current LAVG1 Month avg 1 Last Year LAVG10 Month avg 10 Last Year LAVG11 Month avg 11 Last Year LAVG12 Month avg 12 Last Year LAVG2 Month avg 2 Last Year LAVG3 Month avg 3 Last Year LAVG4 Month avg 4 Last Year LAVG5 Month avg 5 Last Year LAVG6 Month avg 6 Last Year LAVG7 Month avg 7 Last Year LAVG8 Month avg 8 Last Year LAVG9 Month avg 9 Last Year PAVG1 Month avg 1 Previous PAVG10 Month avg 10 Previous PAVG11 Month avg 11 Previous PAVG12 Month avg 12 Previous PAVG2 Month avg 2 Previous PAVG3 Month avg 3 Previous PAVG4 Month avg 4 Previous PAVG5 Month avg 5 Previous PAVG6 Month avg 6 Previous PAVG7 Month avg 7 Previous PAVG8 Month avg 8 Previous PAVG9 Month avg 9 Previous CMEB1 Month end 1 Current GLAcctInqRec.GLAcctInfoRec.GLMonthAmtInfoArray.GLMonthAmtInfoRec.MonthBalAmt CMEB10 Month end 10 Current CMEB11 Month end 11 Current CMEB12 Month end 12 Current CMEB2 Month end 2 Current CMEB3 Month end 3 Current CMEB4 Month end 4 Current CMEB5 Month end 5 Current CMEB6 Month end 6 Current CMEB7 Month end 7 Current CMEB8 Month end 8 Current CMEB9 Month end 9 Current LMEB1 Month end 1 Last Year LMEB10 Month end 10 Last Year LMEB11 Month end 11 Last Year LMEB12 Month end 12 Last Year LMEB2 Month end 2 Last Year LMEB3 Month end 3 Last Year LMEB4 Month end 4 Last Year LMEB5 Month end 5 Last Year LMEB6 Month end 6 Last Year LMEB7 Month end 7 Last Year LMEB8 Month end 8 Last Year LMEB9 Month end 9 Last Year PMEB1 Month end 1 Previous PMEB10 Month end 10 Previous PMEB11 Month end 11 Previous PMEB12 Month end 12 Previous PMEB2 Month end 2 Previous PMEB3 Month end 3 Previous PMEB4 Month end 4 Previous PMEB5 Month end 5 Previous PMEB6 Month end 6 Previous PMEB7 Month end 7 Previous PMEB8 Month end 8 Previous PMEB9 Month end 9 Previous Cur Calendar Beg Date Q1 GLAcctInqRec.GLAcctInfoRec.GLQtrAmtInfoArray.GLQtrAmtInfoRec.QtrBegDt Cur Calendar Beg Date Q2 Cur Calendar Beg Date Q3 Cur Calendar Beg Date Q4 Lst Calendar Beg Date Q1 Lst Calendar Beg Date Q2 Lst Calendar Beg Date Q3 Lst Calendar Beg Date Q4 Prv Calendar Beg Date Q1 Prv Calendar Beg Date Q2 Prv Calendar Beg Date Q3 Prv Calendar Beg Date Q4 Cur Calendar End Date Q1 GLAcctInqRec.GLAcctInfoRec.GLQtrAmtInfoArray.GLQtrAmtInfoRec.QtrEndDt Cur Calendar End Date Q2 Cur Calendar End Date Q3 Cur Calendar End Date Q4 Lst Calendar End Date Q1 Lst Calendar End Date Q2 Lst Calendar End Date Q3 Lst Calendar End Date Q4 Prv Calendar End Date Q1 Prv Calendar End Date Q2 Prv Calendar End Date Q3 Prv Calendar End Date Q4 CQAV1 Qtr average 1 Current GLAcctInqRec.GLAcctInfoRec.GLQtrAmtInfoArray.GLQtrAmtInfoRec.QtrAvgBalAmt CQAV2 Qtr average 2 Current CQAV3 Qtr average 3 Current CQAV4 Qtr average 4 Current LQAV1 Qtr average 1 Last LQAV2 Qtr average 2 Last LQAV3 Qtr average 3 Last LQAV4 Qtr average 4 Last PQAV1 Qtr average 1 Previous PQAV2 Qtr average 2 Previous PQAV3 Qtr average 3 Previous PQAV4 Qtr average 4 Previous CQEB1 Qtr end 1 Current GLAcctInqRec.GLAcctInfoRec.GLQtrAmtInfoArray.GLQtrAmtInfoRec.QtrBalAmt CQEB2 Qtr end 2 Current CQEB3 Qtr end 3 Current CQEB4 Qtr end 4 Current LQEB1 Qtr end 1 Last LQEB2 Qtr end 2 Last LQEB3 Qtr end 3 Last LQEB4 Qtr end 4 Last PQEB1 Qtr end 1 Previous PQEB2 Qtr end 2 Previous PQEB3 Qtr end 3 Previous PQEB4 Qtr end 4 Previous GLPARS SICDES SIC Description GLAcctInqRec.GLAcctInfoRec.UserDefInfoArray.UserDefInfo.UserDefTxt 20 GLSIC1 Special Info Code 1 GLAcctInqRec.GLAcctInfoRec.UserDefInfoArray.UserDefInfo.UserDefCode GLSIC2 Special Info Code 2 GLSIC3 Special Info Code 3 GLSIC4 Special Info Code 4 ACCOUNT TYPE GLAcctInqRec.AcctTypeDesc JHDATA JDNAME Bank/branch name GLAcctInqRec.BrDesc 30 JHOFFR JHONAM Officer name GLAcctInqRec.OffDesc GLPAR9 P9DESC Product Description GLAcctInqRec.GLProdDesc 40 GLPAR8 P8DESC Description GLAcctInqRec.CallRpt1Desc GLAcctInqRec.CallRpt2Desc GLAcctInqRec.CallRpt3Desc GLAcctInqRec.CallRpt4Desc GLAcctInqRec.AcctStatDesc CURBAL Current Balance GLAcctInqRec.CurBal YESBAL Yesterday's Balance GLAcctInqRec.YestBal NETCHG Net Change Today GLAcctInqRec.DlyBalChngAmt BEGCYR Current Year Beginning Balance GLAcctInqRec.BegYrBal BEGLYR Last Year Beginning Balance GLAcctInqRec.BegLastYrBal BEGPYR Prior Year Beginning Balance GLAcctInqRec.BegPrevYrBal YTDAVG YTD Average Balance GLAcctInqRec.AvgYTDBal YTDBAL YTD Balance GLAcctInqRec.BalYTDAmt 15 File