CustDetail
ODI Extracts
>
Silverlake
>
CustDetail
Extract to provide customer master file information
| Provider | Element | Element Description | Reference File | Reference Field | Field Type | Length | Digits | Decimal Places |
|---|---|---|---|---|---|---|---|---|
| Silverlake | Dlt | Delete Record Flag | String | 1 | 0 | 0 | ||
| Silverlake | SrcKey | Unique Record Key | String | 9 | 0 | 0 | ||
| Silverlake | NameSuffix | Customer name suffix | CFMAST | CFSFX | String | 4 | 0 | 0 |
| Silverlake | CustId | Customer Id | String | 8 | 0 | 0 | ||
| Silverlake | ComName | Customer name | CFMAST | CFNA1 | String | 40 | 0 | 0 |
| Silverlake | FirstName | Customer first name | CFMAST | CFFNA | String | 20 | 0 | 0 |
| Silverlake | MiddleName | Customer middle name | CFMAST | CFMNA | String | 20 | 0 | 0 |
| Silverlake | LastName | Customer last name | CFMAST | CFLNA | String | 20 | 0 | 0 |
| Silverlake | LegalName | Legal Name | String | 70 | 0 | 0 | ||
| Silverlake | StreetAddr1 | Address line 1 | CFMAST | CFNA2 | String | 40 | 0 | 0 |
| Silverlake | StreetAddr2 | Address line 2 | CFMAST | CFNA3 | String | 40 | 0 | 0 |
| Silverlake | City | City | CFMAST | CFCITY | String | 20 | 0 | 0 |
| Silverlake | StateCode | State | CFMAST | CFSTAT | String | 2 | 0 | 0 |
| Silverlake | PostalCode | Zip code | CFMAST | CFZIP | Integer | 5 | 9 | 0 |
| Silverlake | Cntry | Foreign Country | CFMAST | CFFORC | String | 50 | 0 | 0 |
| Silverlake | BrCode | Branch number | CFMAST | CFBRNN | Integer | 2 | 3 | 0 |
| Silverlake | BrDesc | Bank/branch name | JHDATA | JDNAME | String | 30 | 0 | 0 |
| Silverlake | CustImporCode | VIP customer | CFMAST | CFVIPC | String | 1 | 0 | 0 |
| Silverlake | CustImporDesc | VIP Flag Desc | String | 25 | 0 | 0 | ||
| Silverlake | DeceasedDt | Date Deceased | CFMAST | CFDDEA | Integer | 4 | 7 | 0 |
| Silverlake | CustOrgDt | Original customer date (YYYYDDD) | CFMAST | CFORGD | Integer | 4 | 7 | 0 |
| Silverlake | BirthDt | Date of birth (YYYYDDD) | CFMAST | CFBIRD | Integer | 4 | 7 | 0 |
| Silverlake | LastFinStmtDt | Financial statement date | CFMAST | CFFSDT | Integer | 4 | 7 | 0 |
| Silverlake | DoNotCallCode | CIF Do Not Call Flag | CFMAST | CFNOCALL | String | 1 | 0 | 0 |
| Silverlake | DoNotCallDesc | Do Not Call Desc | String | 25 | 0 | 0 | ||
| Silverlake | OccType | CIF Occupation Code | CFMAST | CFOCPCD | String | 50 | 0 | 0 |
| Silverlake | Gender | Sex | CFMAST | CFSEX | String | 1 | 0 | 0 |
| Silverlake | County | County | CFMAST | CFCNTY | Integer | 2 | 3 | 0 |
| Silverlake | NAICSCode | NAICS Code | CFMAST | CFNAICS | String | 6 | 0 | 0 |
| Silverlake | NAICSDesc | 2002 DESCRIPTION | LNNAIC | NAIDSC | String | 50 | 0 | 0 |
| Silverlake | StdIndustCode | Business type | CFMAST | CFBUST | Integer | 3 | 4 | 0 |
| Silverlake | StdIndustDesc | Standard Industry Desc | CFSICC | CFSINA | String | 30 | 0 | 0 |
| Silverlake | EmplName | Employer name | CFMAST | CFEMPL | String | 35 | 0 | 0 |
| Silverlake | LastMainDt | Date of last maintenance | CFMAST | CFDLM | Integer | 4 | 7 | 0 |
| Silverlake | Deceased | Deceased customer flag | CFMAST | CFDEAD | String | 1 | 0 | 0 |
| Silverlake | LastIntnetActDt | Last access date | HBMAST | LACDT7 | Integer | 4 | 7 | 0 |
| Silverlake | TaxId | Tax ID number | CFMAST | CFSSNO | Integer | 5 | 9 | 0 |
| Silverlake | TINCode | Tax ID type code | CFMAST | CFSSCD | String | 1 | 0 | 0 |
| Silverlake | TINDesc | Description | CFPART | TXDESC | String | 20 | 0 | 0 |
| Silverlake | CustCode | Class | CFMAST | CFCLAS | String | 1 | 0 | 0 |
| Silverlake | RegPOptOutCode | Privacy Act opt out | CFMAST | CFREGP | String | 1 | 0 | 0 |
| Silverlake | InsiderCode | Insider code | CFMAST | CFINSC | String | 1 | 0 | 0 |
| Silverlake | CRACenTract | Census Tract | CFMAST | CFCENS | Integer | 4 | 7 | 2 |
| Silverlake | ResCntry | POSTAL COUNTRY | CFORGN | FPCNTR | String | 2 | 0 | 0 |
| Silverlake | RiskRateCode | CIF Risk Rating | CFMAST | CFRSKRT | String | 6 | 0 | 0 |
| Silverlake | RiskRateDesc | Risk Rating Description | CFPARRT | RPRSKDSC | String | 40 | 0 | 0 |
| Silverlake | CertCode | TIN status | CFMAST | CFTINS | String | 1 | 0 | 0 |
| Silverlake | CertCodeDesc | Cert Code Desc | String | 40 | 0 | 0 | ||
| Silverlake | CertCodeDt | Status changed date | CFMAST | CFTNDT | Integer | 4 | 7 | 0 |
| Silverlake | CRASMSACode | SMSA code | CFMAST | CFSMSA | Integer | 3 | 5 | 0 |
| Silverlake | CRASMSADesc | Description | LNPAR503 | L5DESC | String | 40 | 0 | 0 |
| Silverlake | CustCycleCode | CIF combined cycle | CFMAST | CFCCYC | Integer | 2 | 2 | 0 |
| Silverlake | AbbName | Short name | CFMAST | CFSNME | String | 20 | 0 | 0 |
| Silverlake | CustType | Individual | CFMAST | CFINDI | String | 1 | 0 | 0 |
| Silverlake | MailDirCode | Hold mail code | CFMAST | CFHLDM | String | 1 | 0 | 0 |
| Silverlake | MailDirDesc | Hold mail description | JHMAIL | JHMDES | String | 35 | 0 | 0 |
| Silverlake | TaxIdMod | Tax ID suffix | CFMAST | CFSSFX | String | 1 | 0 | 0 |
| Silverlake | InvAddr | Insufficient address | CFMAST | CFBADA | String | 1 | 0 | 0 |
| Silverlake | SalesPerson | Sales Associate | CFMAST | SALESAC | String | 15 | 0 | 0 |
| Silverlake | InsiderDesc | Insider code text | CFPAR5 | CP5TXT | String | 50 | 0 | 0 |
| Silverlake | BnkRptcyDt | Bankruptcy date | Integer | 4 | 7 | 0 | ||
| Silverlake | AlienTypeCode | ALIEN Flag | String | 1 | 0 | 0 | ||
| Silverlake | AlienTypeDesc | ALIEN Flag Description | String | 20 | 0 | 0 | ||
| Silverlake | AnnIncmCode | Annual Income Code | String | 1 | 0 | 0 | ||
| Silverlake | AnnIncmDesc | Annual Income Description | String | 30 | 0 | 0 | ||
| Silverlake | GroupCode | CIF group | CFMAST | CFGRP# | Integer | 4 | 7 | 0 |
| Silverlake | GroupDesc | CIF group description | CFPARG | CFGRPD | String | 50 | 0 | 0 |
| Silverlake | NetWorthAmt | Net Worth | Integer | 5 | 9 | 0 | ||
| Silverlake | LastConDt | Date of Last Contact | Integer | 4 | 7 | 0 | ||
| Silverlake | ReqLegalEntityType | FinCen Legal Entity | CFFBENIN | FINCENLE | String | 1 | 0 | 0 |
| Silverlake | ExcOwnPct | Override Ownership Percentage | CFFBENIN | OVRPCT | Integer | 2 | 3 | 0 |
| Silverlake | ExcPctRsnCode | Override Percentage Reason | CFFBENIN | PCTREASON | String | 3 | 0 | 0 |
| Silverlake | ExcPctRsnDesc | Override Reason Code Description | CFPROC | OVERDESC | String | 40 | 0 | 0 |
| Silverlake | BenflOwnExclCode | Exclusion Code | CFFBENIN | EXCLCODE | String | 3 | 0 | 0 |
| Silverlake | BenflOwnExclDesc | Exclusion description | CFPARN | PNEXDESC | String | 40 | 0 | 0 |
| Silverlake | ResCntryType | Residency Country | CFORGN | FNCTRY | String | 2 | 0 | 0 |
| Silverlake | CitzCntryType | Citizenship Country | CFORGN | FCITZN | String | 2 | 0 | 0 |
| Silverlake | CitzCntry | Citizenship Country Name | CFOPR1 | F1DESC | String | 40 | 0 | 0 |
| Silverlake | StreetAddr3 | City State Zip/Foreign Address | String | 40 | 0 | 0 | ||
| Silverlake | BnkRptcyFileCode | CIF Bankruptcy Flag | EXTCFMAST | CFBKRPT | String | 1 | 0 | 0 |
| Silverlake | BnkRptcyFileDesc | Litigation Code Description | LNLPRB_T | LNBBDS | String | 30 | 0 | 0 |
| Silverlake | BnkRptcyChapCode | Bankruptcy Chapter | LNLPRB_T | LNBBCH | String | 4 | 0 | 0 |
| Silverlake | BnkRptcyChapDesc | Bankruptcy Chapter Description | String | 30 | 0 | 0 | ||
| Silverlake | BnkRptcyCaseId | Bankruptcy Case Id | LNLCIF | LBCAS# | String | 20 | 0 | 0 |
| Silverlake | BnkRptcyCaseStatType | Bankruptcy Case Status Type | LNLBCIF | LCCASESTAT | Integer | 4 | 7 | 0 |
Have a Question?
Have a how-to question? Seeing a weird error? Get help on
StackOverflow.
Register for the Developer Office Hours
where we answer technical Q&A from the audience.
Did this page help you?
Last updated Mon Oct 27 2025