CustDetail
ODI Extracts
>
CIF2020
>
CustDetail
Extract to provide customer master file information
| Provider | Element | Element Description | Reference File | Reference Field | Field Type | Length | Digits | Decimal Places |
|---|---|---|---|---|---|---|---|---|
| CIF2020 | Dlt | Delete Record Flag | String | 1 | 0 | 0 | ||
| CIF2020 | SrcKey | No Forign Key | String | 1 | 0 | 0 | ||
| CIF2020 | SrcKey | Unique Record Key | String | 7 | 0 | 0 | ||
| CIF2020 | CustId | Customer number | String | 7 | 0 | 0 | ||
| CIF2020 | NameSuffix | Customer name suffix | String | 4 | 0 | 0 | ||
| CIF2020 | ComName | Customer name | String | 40 | 0 | 0 | ||
| CIF2020 | FirstName | Customer first name | String | 20 | 0 | 0 | ||
| CIF2020 | LegalName | Legal Name | String | 70 | 0 | 0 | ||
| CIF2020 | MiddleName | Customer middle name | String | 20 | 0 | 0 | ||
| CIF2020 | LastName | Customer last name | String | 20 | 0 | 0 | ||
| CIF2020 | StreetAddr1 | Address line 1 | String | 40 | 0 | 0 | ||
| CIF2020 | StreetAddr2 | Address line 2 | String | 40 | 0 | 0 | ||
| CIF2020 | City | City | String | 20 | 0 | 0 | ||
| CIF2020 | StateCode | State | String | 2 | 0 | 0 | ||
| CIF2020 | PostalCode | Zip code | Integer | 5 | 9 | 0 | ||
| CIF2020 | BrCode | Branch number | Integer | 2 | 3 | 0 | ||
| CIF2020 | BrDesc | Bank/branch name | String | 30 | 0 | 0 | ||
| CIF2020 | CustImporCode | VIP customer | String | 1 | 0 | 0 | ||
| CIF2020 | CustImporDesc | VIP Flag Desc | String | 25 | 0 | 0 | ||
| CIF2020 | DeceasedDt | Date Deceased | Integer | 4 | 7 | 0 | ||
| CIF2020 | CustOrgDt | Original customer date (YYYYDDD) | Integer | 4 | 7 | 0 | ||
| CIF2020 | BirthDt | Date of birth (YYYYDDD) | Integer | 4 | 7 | 0 | ||
| CIF2020 | LastFinStmtDt | Financial statement date | Integer | 4 | 7 | 0 | ||
| CIF2020 | DoNotCallCode | CIF Do Not Call Flag | String | 1 | 0 | 0 | ||
| CIF2020 | DoNotCallDesc | Do Not Call Desc | String | 25 | 0 | 0 | ||
| CIF2020 | OccType | CIF Occupation Code | String | 50 | 0 | 0 | ||
| CIF2020 | Gender | Sex | String | 1 | 0 | 0 | ||
| CIF2020 | County | County | Integer | 2 | 3 | 0 | ||
| CIF2020 | NAICSCode | NAICS Code | String | 6 | 0 | 0 | ||
| CIF2020 | NAICSDesc | 2002 DESCRIPTION | String | 50 | 0 | 0 | ||
| CIF2020 | StdIndustCode | Business type | Integer | 3 | 4 | 0 | ||
| CIF2020 | StdIndustDesc | Standard Industry Desc | String | 30 | 0 | 0 | ||
| CIF2020 | EmplName | Employer name | String | 35 | 0 | 0 | ||
| CIF2020 | LastMainDt | Date of last maintenance | Integer | 4 | 7 | 0 | ||
| CIF2020 | Deceased | Deceased customer flag | String | 1 | 0 | 0 | ||
| CIF2020 | LastIntnetActDt | Last access date | Integer | 4 | 7 | 0 | ||
| CIF2020 | TaxId | Tax ID number | Integer | 5 | 9 | 0 | ||
| CIF2020 | TINCode | Tax ID type code | String | 1 | 0 | 0 | ||
| CIF2020 | TINDesc | Description | String | 20 | 0 | 0 | ||
| CIF2020 | SalesPerson | CIF Sales Associate Code | String | 15 | 0 | 0 | ||
| CIF2020 | CustCode | Class | String | 1 | 0 | 0 | ||
| CIF2020 | RegPOptOutCode | Privacy Act opt out | String | 1 | 0 | 0 | ||
| CIF2020 | InsiderCode | Insider code | String | 1 | 0 | 0 | ||
| CIF2020 | InsiderDesc | Insider code text | String | 50 | 0 | 0 | ||
| CIF2020 | CRACenTract | Census Tract | Integer | 4 | 7 | 2 | ||
| CIF2020 | ResCntry | POSTAL COUNTRY | String | 2 | 0 | 0 | ||
| CIF2020 | RiskRateCode | CIF Risk Rating | String | 6 | 0 | 0 | ||
| CIF2020 | RiskRateDesc | Risk Rating Description | String | 40 | 0 | 0 | ||
| CIF2020 | CertCode | TIN status | String | 1 | 0 | 0 | ||
| CIF2020 | CertCodeDesc | Cert Code Desc | String | 40 | 0 | 0 | ||
| CIF2020 | CertCodeDt | Status changed date | Integer | 4 | 7 | 0 | ||
| CIF2020 | CRASMSACode | SMSA code | Integer | 4 | 7 | 2 | ||
| CIF2020 | CRASMSADesc | Description | String | 40 | 0 | 0 | ||
| CIF2020 | CustCycleCode | CIF combined cycle | Integer | 2 | 2 | 0 | ||
| CIF2020 | AbbName | Short name | String | 20 | 0 | 0 | ||
| CIF2020 | CustType | Individual | String | 1 | 0 | 0 | ||
| CIF2020 | MailDirCode | Hold mail code | String | 2 | 0 | 0 | ||
| CIF2020 | MailDirDesc | Hold mail description | String | 35 | 0 | 0 | ||
| CIF2020 | TaxIdMod | Tax ID suffix | String | 1 | 0 | 0 | ||
| CIF2020 | InvAddr | Insufficient address | String | 1 | 0 | 0 | ||
| CIF2020 | AnnIncmCode | Annual Income Code | String | 1 | 0 | 0 | ||
| CIF2020 | AnnIncmDesc | Annual Income Description | String | 30 | 0 | 0 | ||
| CIF2020 | GroupCode | CIF group | Integer | 4 | 7 | 0 | ||
| CIF2020 | GroupDesc | CIF group description | String | 50 | 0 | 0 | ||
| CIF2020 | NetWorthAmt | Net Worth | Integer | 5 | 9 | 0 | ||
| CIF2020 | LastConDt | Date of Last Contact | Integer | 4 | 7 | 0 | ||
| CIF2020 | ReqLegalEntityType | FinCen Legal Entity | String | 1 | 0 | 0 | ||
| CIF2020 | ExcOwnPct | Override Ownership Percentage | Integer | 2 | 3 | 0 | ||
| CIF2020 | ExcPctRsnCode | Override Percentage Reason | String | 3 | 0 | 0 | ||
| CIF2020 | ExcPctRsnDesc | Override Reason Code Description | String | 40 | 0 | 0 | ||
| CIF2020 | BenflOwnExclCode | Exclusion Code | String | 3 | 0 | 0 | ||
| CIF2020 | BenflOwnExclDesc | Exclusion description | String | 40 | 0 | 0 | ||
| CIF2020 | ResCntryType | Residency Country | String | 2 | 0 | 0 | ||
| CIF2020 | CitzCntryType | Citizenship Country | String | 2 | 0 | 0 | ||
| CIF2020 | CitzCntry | Citizenship Country Name | String | 40 | 0 | 0 | ||
| CIF2020 | StreetAddr3 | City State Zip/Foreign Address | String | 40 | 0 | 0 | ||
| CIF2020 | BnkRptcyFileCode | CIF Bankruptcy Flag | String | 1 | 0 | 0 | ||
| CIF2020 | BnkRptcyChapCode | Bankruptcy Chapter | String | 4 | 0 | 0 | ||
| CIF2020 | BnkRptcyChapDesc | Bankruptcy Chapter Description | String | 40 | 0 | 0 | ||
| CIF2020 | BnkRptcyCaseId | Bankruptcy Case Number | String | 20 | 0 | 0 | ||
| CIF2020 | BnkRptcyCaseStatType | Bankruptcy Case Status Type | Integer | 4 | 7 | 0 | ||
| CIF2020 | BnkRptcyDisChgDt | Bankruptcy Date Discharged | 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 Fri Feb 21 2025