| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP90CB: CRM Sales Force Automation |
| 1 | F90CB030 | CRM Address Table (Lead related information) | 10 | AD | CNY | County | Variable String | UDC | 25 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 00 / CT (County Codes) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | No county | | |
| 2 | 42 105 | Crockett | | |
| 3 | AB 001 | Alberta | | |
| 4 | AI 001 | Arctic Islands | | |
| 5 | BC 001 | British Columbia | | |
| 6 | CA 019 | Fresno | | |
| 7 | CA 023 | Humboldt | | |
| 8 | CA 107 | Tulare | | |
| 9 | CO 005 | Arapahoe | | |
| 10 | CO 045 | Garfield | | |
| 11 | CO 059 | Jefferson | | |
| 12 | LA 027 | Claiborne | | |
| 13 | LA 777 | Offshore LA | | |
| 14 | ND 047 | Logan | | |
| 15 | NM 025 | Lea | | |
| 16 | NM 039 | Rio Arriba | | |
| 17 | NM 045 | San Juan | | |
| 18 | OK 009 | Beckham | | |
| 19 | OK 011 | Blaine | | |
| 20 | OK 045 | Ellis | | |
| 21 | TN 125 | Montgomery | | |
| 22 | TX 073 | Cherokee | | |
| 23 | TX 105 | Crockett | | |
| 24 | TX 173 | Glasscock | | |
| 25 | WY 003 | Big Horn | | |
| 26 | WY 005 | Campbell | | |
| 27 | WY 041 | Uinta | | |
