| 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) | 11 | AD | CONTY | Country | String | UDC | 3 | 0 |
TOP90CC: CRM Marketing Automation |
2 | F90CC01C | Campaign Event Address table | 14 | CA | CONTY | Country | String | UDC | 3 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 00 / CN (Country Codes) stock values
| Value | Description | Special Handling Code | Hard Coded |
---|
1 | | . | | N |
2 | AE | UNITED ARAB EMIRATES | | N |
3 | AN | NETHERLANDS ANTILLES | | N |
4 | AZ | AZERBAIJAN | | N |
5 | BA | BOSNIA | | N |
6 | BB | BARBADOS | | N |
7 | BD | BANGLADESH | | N |
8 | BE | BELGIUM | | N |
9 | BF | BURKINA FASO | | N |
10 | BG | BULGARIA | | N |
11 | BH | BAHRAIN | | N |
12 | BI | BURUNDI | | N |
13 | BJ | BENIN | | N |
14 | BM | BERMUDA | | N |
15 | BN | BRUNEI | | N |
16 | BO | BOLIVIA | | N |
17 | BR | BRAZIL | | N |
18 | BS | BAHAMAS | | N |
19 | BT | BHUTAN | | N |
20 | BW | BOTSWANA | | N |
21 | BY | BELARUS | | N |
22 | BZ | BELIZE | | N |
23 | CA | CANADA | | N |
24 | CD | CONGO, | | N |
25 | CF | CENTRAL AFRICAN | | N |
26 | CG | CONGO | | N |
27 | CH | SWITZERLAND | | N |
28 | CI | COTE D'IVOIRE | | N |
29 | CK | COOK ISLANDS | | N |
30 | CL | CHILE | | N |
31 | CM | CAMEROON | | N |
32 | CN | CHINA, | | N |
33 | CO | COLOMBIA | | N |
34 | CR | COSTA RICA | | N |
35 | CU | CUBA | | N |
36 | CV | CAPE VERDE | | N |
37 | CY | CYPRUS | | N |
38 | CZ | CZECH REPUBLIC, THE | | N |
39 | DE | GERMANY | | N |
40 | DJ | DJIBOUTI | | N |
41 | DK | DENMARK | | N |
42 | DM | DOMINICA | | N |
43 | DO | DOMINICAN REPUBLIC | | N |
44 | EC | ECUADOR | | N |
45 | EE | ESTONIA | | N |
46 | EG | EGYPT | | N |
47 | ER | ERITREA | | N |
48 | ES | SPAIN | | N |
49 | ET | ETHIOPIA | | N |
50 | FI | FINLAND | | N |
51 | FJ | FIJI | | N |
52 | FK | FALKLAND ISLANDS | | N |
53 | FM | MICRONESIA, | | N |
54 | FO | FAROE ISLANDS | | N |
55 | FR | FRANCE | | N |
56 | GA | GABON | | N |
57 | GB | UNITED KINGDOM | | N |
58 | GD | GRENADA | | N |
59 | GE | GEORGIA | | N |
60 | GF | FRENCH GUYANA | | N |
61 | GG | GUERNSEY | | N |
62 | GH | GHANA | | N |
63 | GI | GIBRALTAR | | N |
64 | GL | GREENLAND | | N |
65 | GM | GAMBIA | | N |
66 | GN | GUINEA REPUBLIC | | N |
67 | GP | GUADELOUPE | | N |
68 | GQ | GUINEA-EQUATORIAL | | N |
69 | GR | GREECE | | N |
70 | GT | GUATEMALA | | N |
71 | GU | GUAM | | N |
72 | GW | GUINEA-BISSAU | | N |
73 | GY | GUYANA (BRITISH) | | N |
74 | HK | HONG KONG | | N |
75 | HN | HONDURAS | | N |
76 | HR | CROATIA | | N |
77 | HT | HAITI | | N |
78 | HU | HUNGARY | | N |
79 | IC | CANARY ISLANDS, THE | | N |
80 | ID | INDONESIA | | N |
81 | IE | IRELAND, REPUBLIC OF | | N |
82 | IL | ISRAEL | | N |
83 | IN | INDIA | | N |
84 | IQ | IRAQ | | N |
85 | IR | IRAN (ISLAMIC REPUBLIC OF) | | N |
86 | IS | ICELAND | | N |
87 | IT | ITALY | | N |
88 | JE | JERSEY | | N |
89 | JM | JAMAICA | | N |
90 | JO | JORDAN | | N |
91 | JP | JAPAN | | N |
92 | KE | KENYA | | N |
93 | KG | KYRGYZSTAN | | N |
94 | KH | CAMBODIA | | N |
95 | KI | KIRIBATI | | N |
96 | KM | COMOROS | | N |
97 | KN | ST. KITTS | | N |
98 | KP | KOREA, THE D.P.R OF | | N |
99 | KR | KOREA, REPUBLIC OF | | N |
100 | KV | KOSOVO | | N |
101 | KW | KUWAIT | | N |
102 | KY | CAYMAN ISLANDS | | N |
103 | KZ | KAZAKHSTAN | | N |
104 | LA | LAO PEOPLE'S | | N |
105 | LB | LEBANON | | N |
106 | LC | ST. LUCIA | | N |
107 | LI | LIECHTENSTEIN | | N |
108 | LK | SRI LANKA | | N |
109 | LR | LIBERIA | | N |
110 | LS | LESOTHO | | N |
111 | LT | LITHUANIA | | N |
112 | LU | LUXEMBOURG | | N |
113 | LV | LATVIA | | N |
114 | LY | LIBYA | | N |
115 | MA | MOROCCO | | N |
116 | MC | MONACO | | N |
117 | MD | MOLDOVA, REPUBLIC OF | | N |
118 | ME | MONTENEGRO, | | N |
119 | MG | MADAGASCAR | | N |
120 | MH | MARSHALL ISLANDS | | N |
121 | MK | MACEDONIA, | | N |
122 | ML | MALI | | N |
123 | MM | MYANMAR | | N |
124 | MN | MONGOLIA | | N |
125 | MO | MACAU | | N |
126 | MP | SAIPAN | | N |
127 | MQ | MARTINIQUE | | N |
128 | MR | MAURITANIA | | N |
129 | MS | MONTSERRAT | | N |
130 | MT | MALTA | | N |
131 | MU | MAURITIUS | | N |
132 | MV | MALDIVES | | N |
133 | MW | MALAWI | | N |
134 | MX | MEXICO | | N |
135 | MY | MALAYSIA | | N |
136 | MZ | MOZAMBIQUE | | N |
137 | NA | NAMIBIA | | N |
138 | NC | NEW CALEDONIA | | N |
139 | NE | NIGER | | N |
140 | NG | NIGERIA | | N |
141 | NI | NICARAGUA | | N |
142 | NL | NETHERLANDS, THE | | N |
143 | NO | NORWAY | | N |
144 | NP | NEPAL | | N |
145 | NR | NAURU, REPUBLIC OF | | N |
146 | NU | NIUE | | N |
147 | NZ | NEW ZEALAND | | N |
148 | OM | OMAN | | N |
149 | PA | PANAMA | | N |
150 | PE | PERU | | N |
151 | PF | TAHITI | | N |
152 | PG | PAPUA NEW GUINEA | | N |
153 | PH | PHILIPPINES, THE | | N |
154 | PK | PAKISTAN | | N |
155 | PL | POLAND | | N |
156 | PR | PUERTO RICO | | N |
157 | PT | PORTUGAL | | N |
158 | PW | PALAU | | N |
159 | PY | PARAGUAY | | N |
160 | QA | QATAR | | N |
161 | RE | REUNION, ISLAND OF | | N |
162 | RO | ROMANIA | | N |
163 | RS | SERBIA, REPUBLIC OF | | N |
164 | RU | RUSSIAN FEDERATION, THE | | N |
165 | RW | RWANDA | | N |
166 | SA | SAUDI ARABIA | | N |
167 | SB | SOLOMON ISLANDS | | N |
168 | SC | SEYCHELLES | | N |
169 | SD | SUDAN | | N |
170 | SE | SWEDEN | | N |
171 | SG | SINGAPORE | | N |
172 | SI | SLOVENIA | | N |
173 | SK | SLOVAKIA | | N |
174 | SL | SIERRA LEONE | | N |
175 | SM | SAN MARINO | | N |
176 | SN | SENEGAL | | N |
177 | SO | SOMALIA | | N |
178 | SR | SURINAME | | N |
179 | ST | SAO TOME AND PRINCIPE | | N |
180 | SV | EL SALVADOR | | N |
181 | SY | SYRIA | | N |
182 | SZ | SWAZILAND | | N |
183 | TC | TURKS AND CAICOS ISLANDS | | N |
184 | TD | CHAD | | N |
185 | TG | TOGO | | N |
186 | TH | THAILAND | | N |
187 | TJ | TAJIKISTAN | | N |
188 | TM | TURKMENISTAN | | N |
189 | TN | TUNISIA | | N |
190 | TO | TONGA | | N |
191 | TP | EAST TIMOR | | N |
192 | TR | TURKEY | | N |
193 | TT | TRINIDAD AND TOBAGO | | N |
194 | TV | TUVALU | | N |
195 | TW | TAIWAN | | N |
196 | TZ | TANZANIA | | N |
197 | UA | UKRAINE | | N |
198 | UG | UGANDA | | N |
199 | US | UNITED STATES OF AMERICA | | N |
200 | UY | URUGUAY | | N |
201 | UZ | UZBEKISTAN | | N |
202 | VC | ST. VINCENT | | N |
203 | VE | VENEZUELA | | N |
204 | VG | VIRGIN ISLANDS (BRITISH) | | N |
205 | VI | VIRGIN ISLANDS (US) | | N |
206 | VN | VIETNAM | | N |
207 | VU | VANUATU | | N |
208 | WS | SAMOA | | N |
209 | XB | BONAIRE | | N |
210 | XC | CURACAO | | N |
211 | XE | ST. EUSTATIUS | | N |
212 | XM | ST. MAARTEN | | N |
213 | XN | NEVIS | | N |
214 | XS | SOMALILAND, | | N |
215 | XY | ST. BARTHELEMY | | N |
216 | YE | YEMEN, REPUBLIC OF | | N |
217 | YT | MAYOTTE | | N |
218 | ZA | SOUTH AFRICA | | N |
219 | ZM | ZAMBIA | | N |
220 | ZW | ZIMBABWE | | N |