Mappings

Request Customer number CustId 8 NA String CFACCT CFACC# Account number AccountId.AcctId 11 Integer CFATYP Account type AccountId.AcctType 1 Inquiry Filters IncXtendElemArray.IncXtendElemInfo.XtendElem 600 Response JHFREFAPI USRRSTR Customer Lvl User Access CustRec.Rstr 32 CFMAST CFFNA Customer First Name CustRec.CustDetail.PersonName.FirstName 20 CFMNA Customer Middle Name CustRec.CustDetail.PersonName.MiddleName CFLNA Customer Last Name CustRec.CustDetail.PersonName.LastName CFSALU Salutation CustRec.CustDetail.PersonName.x_PersonName.SalName 35 CFNA1 Customer Name CustRec.CustDetail.PersonName.ComName CFNA2 Address Line #1 CustRec.CustDetail.Addr.FreeFormAddrArray.AddrLineInfo.AddrLine Address Line #2 Address Line #3 Address Line #4 Address Line #5 Address Line #6 ADDRESS LINE#1 CustRec.CustDetail.Addr.StreetAddr1 CFNA3 ADDRESS LINE#2 CustRec.CustDetail.Addr.StreetAddr2 CFCITY City CustRec.CustDetail.Addr.City CFSTAT State Code CustRec.CustDetail.Addr.StateCode 2 CFZIP Zip Code CustRec.CustDetail.Addr.PostalCode 9 CFDELP Delivery Point CustRec.CustDetail.Addr.DlvryPt CFCNTY County CustRec.CustDetail.Addr.County CFFORN Foreign Address CustRec.CustDetail.Addr.FornAddr CFDBA Title/DBA CustRec.CustDetail.PersonName.x_PersonName.LegalName 70 Insufficient Address CustRec.CustDetail.Addr.InvAddr Customer Type Code CustRec.CustDetail.CustType CFNAIC NAICS Code CustRec.CustDetail.NAICSCode 6 CFSNME Abbreviated Name CustRec.CustDetail.PersonName.x_PersonName.AbbName 13 CFSEX Sex CustRec.CustDetail.Gender CFDOB7 Date of Birth CustRec.CustDetail.BirthDt 7 CFEMPL Employer CustRec.CustDetail.EmplName CFOCCU Occupation CustRec.CustDetail.OccType CFORG7 Original Customer Date CustRec.CustDetail.CustOrgDt CFMLM7 Last Maintenance Date CustRec.CustDetail.LastMainDt CFDEAD Deceased Customer Flag CustRec.CustDetail.Deceased CFDDE7 Deceased Date CustRec.CustDetail.DeceasedDt CFEML1 E-mail Address CustRec.CustDetail.EmailArray.EmailInfo.EmailAddr 80 CFEML2 Other E-mail Address CFHPHO Home Phone CustRec.CustDetail.PhoneArray.PhoneInfo.PhoneNum CFBPHO Business Phone CFCEL1 Personal Cell Phone 10 CFCEL2 Business Cell Phone CFFAX1 Home Fax CFFAX2 Business Fax Phone Description CustRec.CustDetail.PhoneArray.PhoneInfo.PhoneType CFBPHE Business Phone Extension CustRec.CustDetail.PhoneArray.PhoneInfo.PhoneExt 4 E-MAIL DESCRIPTION CustRec.CustDetail.EmailArray.EmailInfo.EmailType CFHHNO Household Number CustRec.CustDetail.HouseHoldNum CFHNAME Household Name CustRec.CustDetail.HouseHoldName CFSPOU Spouse Name CustRec.CustDetail.SpouseName.ComName Customer Number CustRec.CustId CustRec.AccountId.AcctId CustRec.AccountId.AcctType LNPNAI NAIDSC 2002 DESCRIPTION CustRec.NAICSDesc 50 Messages Exist CustRec.CondNotfArray.CondNotfInfo.CondNotf Alert Messages Exist Seasonal Address Exist HBMAST HBCID NETTELLER ID 01 CustRec.IntnetFinInstIdArray.IntnetFinInstIdArrayInfo.IntnetFinInstId 12 NETTELLER ID 02 NETTELLER ID 03 NETTELLER ID 04 NETTELLER ID 05 NETTELLER ID 06 NETTELLER ID 07 NETTELLER ID 08 NETTELLER ID 09 NETTELLER ID 10 CFSSTP Tax ID Type x_TaxDetail.TaxDetail.TINInfo.TINCode Description x_TaxDetail.TaxDetail.TINInfo.TINDesc CFSSNO Tax ID Number x_TaxDetail.TaxDetail.TINInfo.TaxId CFBNOT Number of B Notices Sent x_TaxDetail.TaxDetail.TINInfo.BNotStat CFBND7 Last B Notice Sent Date x_TaxDetail.TaxDetail.TINInfo.BNotIRSDt CFADT7 Alien W8 Certification Date x_TaxDetail.TaxDetail.Alien.AlienLastW8Dt CFPCTY Alien Postal City x_TaxDetail.TaxDetail.Alien.ResCity 25 CFPROV Alien Postal Province x_TaxDetail.TaxDetail.Alien.ResStateProv CFPCOD Alien Postal Zip Code x_TaxDetail.TaxDetail.Alien.ResPostalCode CFRCNT Alien Country of Residency x_TaxDetail.TaxDetail.Alien.ResCntryType CFEXEM Alien Chapter 3 Exemption Code x_TaxDetail.TaxDetail.Alien.IRSExmpCode CFOPR3 F3DESC IRS W/H EXEMPTION DESC x_TaxDetail.TaxDetail.Alien.IRSExmpDesc 40 CFRECP Alien Chapter 3 Status Code x_TaxDetail.TaxDetail.Alien.IRSRecipCode CFOPR2 F2DESC IRS RECIPIENT DESCRIP. x_TaxDetail.TaxDetail.Alien.IRSRecipDesc CFAFLG Alien Customer x_TaxDetail.TaxDetail.Alien.AlienTypeCode CFBR# Branch x_BusDetail.BusDetail.BrCode DDSIC1 Desc x_BusDetail.BusDetail.UserDefInfoArray.UserDefInfo.UserDefTxt CFSIC4 Desc CFSIC5 Desc CFSIC6 Desc CFSIC7 Desc JHPARU PUDSC1 DESC CODE 1 PUDSC2 DESC CODE 2 PUDSC3 DESC CODE 3 PUDSC4 DESC CODE 4 PUDSC5 DESC CODE 5 PUDSC6 DESC CODE 6 PUDSCA1 DESC 1 ALPHA 1 PUDSCA2 DESC 1 ALPHA 2 PUDSCA3 DESC 1 ALPHA 3 PUDSCA4 DESC 1 ALPHA 4 PUDSCA5 DESC 1 ALPHA 5 PUDSCA6 DESC 1 ALPHA 6 PUDSC51 DESC 5 ALPHA 1 PUDSC52 DESC 5 ALPHA 2 PUDSC53 DESC 5 ALPHA 3 PUDSC54 DESC 5 ALPHA 4 PUDSC55 DESC 5 ALPHA 5 PUDSC56 DESC 5 ALPHA 6 PUDSN31 DESC 3 NUMERIC 1 PUDSN32 DESC 3 NUMERIC 2 PUDSN33 DESC 3 NUMERIC 3 PUDSN34 DESC 3 NUMERIC 4 PUDSN35 DESC 3 NUMERIC 5 PUDSN36 DESC 3 NUMERIC 6 PUDD351 DESC 35 DESC 1 PUDD352 DESC 35 DESC 2 PUDD353 DESC 35 DESC 3 PUDD354 DESC 35 DESC 4 PUDD355 DESC 35 DESC 5 PUDD356 DESC 35 DESC 6 PUDSD1 DESC DATE 1 PUDSD2 DESC DATE 2 PUDSD3 DESC DATE 3 PUDSD4 DESC DATE 4 PUDSD5 DESC DATE 5 PUDSD6 DESC DATE 6 PUDSA1 DESC AMT 1 PUDSA2 DESC AMT 2 PUDSA3 DESC AMT 3 PUDSA4 DESC AMT 4 PUDSA5 DESC AMT 5 PUDSA6 DESC AMT 6 PUDSN11 DESC 11 NUMERIC 1 PUDSN12 DESC 11 NUMERIC 2 PUDSN13 DESC 11 NUMERIC 3 PUDSN14 DESC 11 NUMERIC 4 PUDSN15 DESC 11 NUMERIC 5 PUDSN16 DESC 11 NUMERIC 6 CFSIC1 Employee x_BusDetail.BusDetail.UserDefInfoArray.UserDefInfo.UserDefCode CFSIC4 OFFICERS CFSIC5 DIRECTORS CFSIC6 ATM CARD HOLDER CFSIC7 RESTRICTED CFUCD1 User code #1 CFUCD2 User code #2 CFUCD3 User code #3 CFUCD4 User code #4 CFUCD5 User code #5 CFUCD6 User code #6 CFUC1A1 User 1 alpha #1 CFUC1A3 User 1 alpha #3 CFUC1A4 User 1 alpha #4 CFUC1A5 User 1 alpha #5 CFUC1A6 User 1 alpha #6 CFUC5A1 User 5 alpha #1 5 CFUC5A2 User 5 alpha #2 CFUC5A3 User 5 alpha #3 CFUC5A4 User 5 alpha #4 CFUC5A5 User 5 alpha #5 CFUC5A6 User 5 alpha #6 CFUC3N1 User numeric 3 #1 3 CFUC3N2 User numeric 3 #2 CFUC3N3 User numeric 3 #3 CFUC3N4 User numeric 3 #4 CFUC3N5 User numeric 3 #5 CFUC3N6 User numeric 3 #6 CFUDSC1 User desc #1 CFUDSC2 User desc #2 CFUDSC3 User desc #3 CFUDSC4 User desc #4 CFUDSC5 User desc #5 CFUDSC6 User desc #6 CF1UD7 User date #1 CF2UD7 User date #2 CF3UD7 User date #3 CF4UD7 User date #4 CF5UD7 User date #5 CF6UD7 User date #6 CFUAM1 User amount #1 CFUAM2 User amount #2 CFUAM3 User amount #3 CFUAM4 User amount #4 CFUAM5 User amount #5 CFUAM6 User amount #6 CFUAM21 User amount #2-#1 CFUAM22 User amount #2-#2 CFUAM23 User amount #2-#3 CFUAM24 User amount #2-#4 CFUAM25 User amount #2-#5 CFUAM26 User amount #2-#6 CFINSC Insider Code x_BusDetail.BusDetail.InsiderCode CFSIC2 VIP Customer x_BusDetail.BusDetail.CustImporCode CFWRTH Net Worth x_BusDetail.BusDetail.NetWorth CFSIC3 Mailing Instructions Code x_BusDetail.BusDetail.MailDirCode CFFCD7 Most Recent Financial Statement Date x_BusDetail.BusDetail.LastFinStmtDt CFFXD7 Financial Statement Expiration Date x_BusDetail.BusDetail.FinStmtExpDt CSASSC Sales Associate x_BusDetail.BusDetail.SalesPerson 15 CFBKRPT Bankruptcy File Code x_BusDetail.BusDetail.BnkRptcyInfoRec.BnkRptcyFileCode CFBCHPT Bankruptcy Chapter Filed x_BusDetail.BusDetail.BnkRptcyInfoRec.BnkRptcyChapCode CFBDAT7 Bankruptcy Date x_BusDetail.BusDetail.BnkRptcyInfoRec.BnkRptcyDt CFBCAS# Bankruptcy Case ID x_BusDetail.BusDetail.BnkRptcyInfoRec.BnkRptcyCaseId CFBDTD7 Bankruptcy Discharge Date x_BusDetail.BusDetail.BnkRptcyInfoRec.BnkRptcyDisChgDt CFOFF1 Primary Officer x_BusDetail.BusDetail.OffInfoArray.OffInfoRec.OffCode CFOFF2 Secondary Officer CFPARJ PJOFNM OFFICER NAME x_BusDetail.BusDetail.OffInfoArray.OffInfoRec.OffDesc 30 CFPCNT Alien Postal Country x_TaxDetail.TaxDetail.Alien.ResCntry JHPARB JHBRNM BRANCH NAME x_BusDetail.BrDesc CFPARI PIDESC Insider code text x_BusDetail.InsiderDesc JHPARC PCHMSG SPECIAL.HANDLING DESC x_BusDetail.MailDirDesc CFDNCD7 No Call Expiration Date x_RegDetail.RegDetail.DoNotCallExpDt CFDNCF No Call Customer x_RegDetail.RegDetail.DoNotCallCode CFREGP Privacy Act Opted Out x_RegDetail.RegDetail.RegPOptOutCode CFRPD7 Privacy Act Last Notice Sent Date x_RegDetail.RegDetail.RegPSentDt CFSMSA CRA SMSA Code x_RegDetail.RegDetail.CRARec.CRASMSACode CFINCL CRA Income Level x_RegDetail.RegDetail.CRARec.CRAIncmLvl CFAOPTO Affiliate Opt Out x_RegDetail.RegDetail.AflOptOutCode CFAOOCD Affiliate Opt Out Exception Code x_RegDetail.RegDetail.AflOptOutExcptCode CFAOOC7 Affiliate Opt Out Exception Date x_RegDetail.RegDetail.AflOptOutExcptDt CFAOOD7 Affiliate Opt Out Expiration Date x_RegDetail.RegDetail.AflOptOutExpDt CFRISK Risk Rating x_RegDetail.RegDetail.RiskRateCode CFRID7 Risk Rating Date x_RegDetail.RegDetail.RiskRateDt CFRIRC Risk Rated By x_RegDetail.RegDetail.RiskRateByCode CFPARE PEDESC x_RegDetail.AflOptOutDesc CFPARC RRDESC Risk Rating Description x_RegDetail.RiskRateDesc x_TaxDetail.TaxDetail.TINInfo.TaxId.MaskVal CFUC1A2 User 1 alpha #2 CFMASTV4 CFFICO Current FICO Score CustRec.CustDetail.CrScoreArray.CrScoreInfo.CrScoreId Beneficial Owner CustRec.CustBenflOwnType CFORGN CFFORTIN Foreign TIN x_TaxDetail.TaxDetail.Alien.FornTaxId 22 CFACTRYCIT Alien Country of Citizenship x_TaxDetail.TaxDetail.Alien.CitzCntryType CFGIIN Alien GIIN x_TaxDetail.TaxDetail.Alien.GIINId 19 CFGIINDP7 Alien GIIN Date Provided x_TaxDetail.TaxDetail.Alien.GIINDt CFGIINDC7 Alien GIIN Certificate Date x_TaxDetail.TaxDetail.Alien.GIINCertDt Chapter Exists x_TaxDetail.TaxDetail.Alien.RptChapArray.RptChapInfoRec.RptChapExst CFCHAPT Reporting Chapter x_TaxDetail.TaxDetail.Alien.RptChapArray.RptChapInfoRec.RptChapType EXEMPTION CODE x_TaxDetail.TaxDetail.Alien.RptChapArray.RptChapInfoRec.IRSExmpCode x_TaxDetail.TaxDetail.Alien.RptChapArray.RptChapInfoRec.IRSExmpDesc Recipient Code 1 x_TaxDetail.TaxDetail.Alien.RptChapArray.RptChapInfoRec.IRSRecipCode CFRECP2 Recipient Code 2 IRS Recipient Description 1 x_TaxDetail.TaxDetail.Alien.RptChapArray.RptChapInfoRec.IRSRecipDesc CFOP24 IRS Recipient Description 2 CFARPT Alien Reporting Method x_TaxDetail.TaxDetail.Alien.AlienIRSRptType Net Worth Amount x_BusDetail.BusDetail.NetWorthAmt CFCDT7 Date of Last Contact x_BusDetail.BusDetail.LastConDt CFFBENIN FINCENLE FinCEN Legal Entity x_RegDetail.RegDetail.ReqLegalEntityType OVRPCT Override Ownership Percentage x_RegDetail.RegDetail.ExcOwnPct Contact Identifier x_ConDetail.ConDetailArray.ConDetailRec.ConDetail.ConText 31 PCTREASON Override Percentage Reason x_RegDetail.RegDetail.ExcPctRsnCode Contact Type x_ConDetail.ConDetailArray.ConDetailRec.ConDetail.ConName EXCLCODE Exclusion Code x_RegDetail.RegDetail.BenflOwnExclCode Contact Value x_ConDetail.ConDetailArray.ConDetailRec.ConDetail.ConVal CFPCON PCSEQ Preferred Contact Sequence x_ConDetail.ConDetailArray.ConDetailRec.ConDetail.PrioritySeq CFPARN PNEXDESC Exclusion Description x_RegDetail.BenflOwnExclDesc CFPROC OVERDESC Override Reason Code Description x_RegDetail.ExcPctRsnDesc Gross Annual Revenue x_RegDetail.RegDetail.AnnRevenueAmt CFPARZ CPZIDV IDENTIFICATION DESC x_IdVerify.IdVerifyArray.IdVerify.IdVerifyDesc CFMLID CFIDCD IDENTIFICATION CODE x_IdVerify.IdVerifyArray.IdVerify.IdVerifyCode CFIDVA IDENTIFICATION VALUE x_IdVerify.IdVerifyArray.IdVerify.IdVerifyVal CFVERC VERIFICATION CODE x_IdVerify.IdVerifyArray.IdVerify.IdVerifyBy x_IdVerify.IdVerifyArray.IdVerify.IdVerifyQueryArray.IdVerifyQueryInfo.IdVerifyQuery CFPLIS PLACE OF ISSUANCE x_IdVerify.IdVerifyArray.IdVerify.IdVerifyQueryArray.IdVerifyQueryInfo.IdVerifyQueryVal 60 CFSTIS STATE OF ISSUANCE CFMCD7 USER DATE 1 CFMED7 USER DATE 2 CFDTI7 USER DATE 3 CPZVTX State of Issuance x_IdVerify.IdVerifyArray.IdVerify.IdIssueBy