| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP74: EMEA Localization |
1 | F0091 | A/B Vendor Information for Year-end IVA tape - Italy | 7 | IF | IRPN | Province of Birth | String | UDC | 3 | 0 |
TOP74Y: Italy |
2 | F74Y0101 | Address Book Italian Tag File - ITA - 01 | 7 | RI | IRPN | Province of Birth | String | UDC | 3 | 0 |
3 | F74YUI01 | Italy Legal Company WF - ITA - 74Y | 9 | LC | IRPN | Province of Birth | 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 / S (State & Province Codes) stock values
| Value | Description | Special Handling Code | Hard Coded |
---|
1 | | . | | N |
2 | * | All States | | N |
3 | AB | Alberta | | |
4 | AI | Arctic Islands | | |
5 | AK | Alaska | | |
6 | AL | Alabama | | |
7 | AM | Amazonas | | N |
8 | AR | Arkansas | | |
9 | AU | Australia | | |
10 | AZ | Arizona | | |
11 | BC | British Columbia | | |
12 | CA | California | | |
13 | CN | Canada | | |
14 | CO | Colorado | | |
15 | CT | Connecticut | | |
16 | CZ | Canal Zone | | |
17 | DC | District of Columbia | | |
18 | DE | Delaware | | |
19 | DF | Distrito Federal | | N |
20 | FL | Florida | | |
21 | GA | Georgia | | |
22 | HI | Hawaii | | |
23 | IA | Iowa | | |
24 | ID | Idaho | | |
25 | IL | Illinois | | |
26 | IN | Indiana | | |
27 | KS | Kansas | | |
28 | KY | Kentucky | | |
29 | LA | Louisiana | | |
30 | MA | Massachusetts | | |
31 | MB | Manitoba | | |
32 | MD | Maryland | | |
33 | ME | Maine | | |
34 | MI | Michigan | | |
35 | MN | Minnesota | | |
36 | MO | Missouri | | |
37 | MS | Mississippi | | |
38 | MT | Montana | | |
39 | MX | Estado de Mexico | | N |
40 | NB | New Brunswick | | |
41 | NC | North Carolina | | |
42 | ND | North Dakota | | |
43 | NE | Nebraska | | |
44 | NF | Newfoundland | | |
45 | NH | New Hampshire | | |
46 | NJ | New Jersey | | |
47 | NL | Nuevo Leon | | N |
48 | NM | New Mexico | | |
49 | NS | Nova Scotia | | |
50 | NSW | New South Wales | | Y |
51 | NT | Northwest Territory | | |
52 | NU | Nunavut | | N |
53 | NV | Nevada | | |
54 | NY | New York | | |
55 | NZ | New Zealand | | |
56 | OH | Ohio | | |
57 | OK | Oklahoma | | |
58 | ON | Ontario | | |
59 | OR | Oregon | | |
60 | PA | Pennsylvania | | |
61 | PE | Prince Edward Island | | |
62 | PR | Puerto Rico | | |
63 | QC | Quebec | | N |
64 | RI | Rhode Island | | |
65 | RJ | Rio de Janiero | | N |
66 | RS | Rio Grande do Sul | | N |
67 | SA | South Australia | | Y |
68 | SC | South Carolina | | |
69 | SD | South Dakota | | |
70 | SK | Saskatchewan | | |
71 | SP | Sao Paulo | | N |
72 | TAS | Tasmania | | Y |
73 | TN | Tennessee | | |
74 | TX | Texas | | |
75 | UT | Utah | | |
76 | VA | Virginia | | |
77 | VI | Virgin Islands | | |
78 | VIC | Victoria | | Y |
79 | VT | Vermont | | |
80 | WA | Washington | | |
81 | WI | Wisconsin | | |
82 | WV | West Virginia | | |
83 | WY | Wyoming | | |
84 | YT | Yukon Territory | | |
85 | ZZ | Other Areas | | |