CustDetail

CIF2020 Dlt Delete Record Flag 1 SrcKey No Forign Key Unique Record Key 7 CustId Customer number NameSuffix Customer name suffix 4 ComName Customer name 40 FirstName Customer first name 20 LegalName Legal Name 70 MiddleName Customer middle name LastName Customer last name StreetAddr1 Address line 1 StreetAddr2 Address line 2 City StateCode State 2 PostalCode Zip code 5 9 BrCode Branch number 3 BrDesc Bank/branch name 30 CustImporCode VIP customer CustImporDesc VIP Flag Desc 25 DeceasedDt Date Deceased CustOrgDt Original customer date (YYYYDDD) BirthDt Date of birth (YYYYDDD) LastFinStmtDt Financial statement date DoNotCallCode CIF Do Not Call Flag DoNotCallDesc Do Not Call Desc OccType CIF Occupation Code 50 Gender Sex County NAICSCode NAICS Code 6 NAICSDesc 2002 DESCRIPTION StdIndustCode Business type StdIndustDesc Standard Industry Desc EmplName Employer name 35 LastMainDt Date of last maintenance Deceased Deceased customer flag LastIntnetActDt Last access date TaxId Tax ID number TINCode Tax ID type code TINDesc Description SalesPerson CIF Sales Associate Code 15 CustCode Class RegPOptOutCode Privacy Act opt out InsiderCode Insider code InsiderDesc Insider code text CRACenTract Census Tract ResCntry POSTAL COUNTRY RiskRateCode CIF Risk Rating RiskRateDesc Risk Rating Description CertCode TIN status CertCodeDesc Cert Code Desc CertCodeDt Status changed date CRASMSACode SMSA code CRASMSADesc CustCycleCode CIF combined cycle AbbName Short name CustType Individual MailDirCode Hold mail code MailDirDesc Hold mail description TaxIdMod Tax ID suffix InvAddr Insufficient address 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 BnkRptcyChapCode Bankruptcy Chapter BnkRptcyChapDesc Bankruptcy Chapter Description BnkRptcyCaseId Bankruptcy Case Number BnkRptcyCaseStatType Bankruptcy Case Status Type BnkRptcyDisChgDt Bankruptcy Date Discharged