| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP40: Inventory/OP Base |
1 | F41001 | Inventory Constants | 107 | CI | NCOOC | Branch Country Of Origin Code | String | UDC | 3 | 0 |
TOP47: Electronic Commerce |
2 | F470371 | EDI Shipping Notice Detail - Outbound | 248 | SZ | NCOOC | Branch Country Of Origin Code | 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 40R / CO (Country of Origin) stock values
| Value | Description | Special Handling Code | Hard Coded |
---|
1 | | . | | N |
2 | CA | Canada | | N |
3 | MX | Mexico | | N |
4 | UAK | Alaska | | N |
5 | UAL | Alabama | | N |
6 | UAR | Arkansas | | N |
7 | UAZ | Arizona | | N |
8 | UCA | California | | N |
9 | UCO | Colorado | | N |
10 | UCT | Conneticut | | N |
11 | UDE | Delaware | | N |
12 | UFL | Florida | | N |
13 | UGA | Georgia | | N |
14 | UHI | Hawaii | | N |
15 | UIA | Iowa | | N |
16 | UID | Idaho | | N |
17 | UIL | Illinois | | N |
18 | UIN | Indiana | | N |
19 | UKS | Kansas | | N |
20 | UKY | Kentucky | | N |
21 | ULA | Louisiana | | N |
22 | UMA | Massachusetts | | N |
23 | UMD | Maryland | | N |
24 | UME | Maine | | N |
25 | UMI | Michigan | | N |
26 | UMN | Minnesota | | N |
27 | UMO | Missouri | | N |
28 | UMS | Mississippi | | N |
29 | UMT | Montanta | | N |
30 | UNC | North Carolina | | N |
31 | UND | North Dakota | | N |
32 | UNE | Nebraska | | N |
33 | UNH | New Hampshire | | N |
34 | UNJ | New Jersey | | N |
35 | UNM | New Mexico | | N |
36 | UNV | Nevada | | N |
37 | UNY | New York | | N |
38 | UOH | Ohio | | N |
39 | UOK | Oklahoma | | N |
40 | UOR | Oregon | | N |
41 | UPA | Pennsylvania | | N |
42 | URI | Rhode Island | | N |
43 | USC | South Carolina | | N |
44 | USD | South Dakota | | N |
45 | UTN | Tennessee | | N |
46 | UTX | Texas | | N |
47 | UUT | Utah | | N |
48 | UVA | Virginia | | N |
49 | UVT | Vermont | | N |
50 | UWA | Washington | | N |
51 | UWI | Wisconsin | | N |
52 | UWV | West Virginia | | N |
53 | UWY | Wyoming | | N |