CustDetail

Silverlake Dlt Delete Record Flag 1 SrcKey Unique Record Key 9 NameSuffix Customer name suffix CFMAST CFSFX 4 CustId Customer Id 8 ComName Customer name CFNA1 40 FirstName Customer first name CFFNA 20 MiddleName Customer middle name CFMNA LastName Customer last name CFLNA LegalName Legal Name 70 StreetAddr1 Address line 1 CFNA2 StreetAddr2 Address line 2 CFNA3 City CFCITY StateCode State CFSTAT 2 PostalCode Zip code CFZIP 5 Cntry Foreign Country CFFORC 50 BrCode Branch number CFBRNN 3 BrDesc Bank/branch name JHDATA JDNAME 30 CustImporCode VIP customer CFVIPC CustImporDesc VIP Flag Desc 25 DeceasedDt Date Deceased CFDDEA 7 CustOrgDt Original customer date (YYYYDDD) CFORGD BirthDt Date of birth (YYYYDDD) CFBIRD LastFinStmtDt Financial statement date CFFSDT DoNotCallCode CIF Do Not Call Flag CFNOCALL DoNotCallDesc Do Not Call Desc OccType CIF Occupation Code CFOCPCD Gender Sex CFSEX County CFCNTY NAICSCode NAICS Code CFNAICS 6 NAICSDesc 2002 DESCRIPTION LNNAIC NAIDSC StdIndustCode Business type CFBUST StdIndustDesc Standard Industry Desc CFSICC CFSINA EmplName Employer name CFEMPL 35 LastMainDt Date of last maintenance CFDLM Deceased Deceased customer flag CFDEAD LastIntnetActDt Last access date HBMAST LACDT7 TaxId Tax ID number CFSSNO TINCode Tax ID type code CFSSCD TINDesc Description CFPART TXDESC CustCode Class CFCLAS RegPOptOutCode Privacy Act opt out CFREGP InsiderCode Insider code CFINSC CRACenTract Census Tract CFCENS ResCntry POSTAL COUNTRY CFORGN FPCNTR RiskRateCode CIF Risk Rating CFRSKRT RiskRateDesc Risk Rating Description CFPARRT RPRSKDSC CertCode TIN status CFTINS CertCodeDesc Cert Code Desc CertCodeDt Status changed date CFTNDT CRASMSACode SMSA code CFSMSA CRASMSADesc LNPAR503 L5DESC CustCycleCode CIF combined cycle CFCCYC AbbName Short name CFSNME CustType Individual CFINDI MailDirCode Hold mail code CFHLDM MailDirDesc Hold mail description JHMAIL JHMDES TaxIdMod Tax ID suffix CFSSFX InvAddr Insufficient address CFBADA SalesPerson Sales Associate SALESAC 15 InsiderDesc Insider code text CFPAR5 CP5TXT BnkRptcyDt Bankruptcy date AlienTypeCode ALIEN Flag AlienTypeDesc ALIEN Flag Description AnnIncmCode Annual Income Code AnnIncmDesc Annual Income Description GroupCode CIF group GroupDesc CIF group description NetWorthAmt Net Worth LastConDt Date of Last Contact ReqLegalEntityType FinCen Legal Entity ExcOwnPct Override Ownership Percentage ExcPctRsnCode Override Percentage Reason ExcPctRsnDesc Override Reason Code Description BenflOwnExclCode Exclusion Code BenflOwnExclDesc Exclusion description ResCntryType Residency Country CitzCntryType Citizenship Country CitzCntry Citizenship Country Name StreetAddr3 City State Zip/Foreign Address BnkRptcyFileCode CIF Bankruptcy Flag BnkRptcyFileDesc Litigation Code Description BnkRptcyChapCode Bankruptcy Chapter BnkRptcyChapDesc Bankruptcy Chapter Description BnkRptcyCaseId Bankruptcy Case Id BnkRptcyCaseStatType Bankruptcy Case Status Type