| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 40: Inventory/OP Base | ||||||||||
| 1 | F4215 | Shipment Header | 61 | XH | ADSO | Origin State | String | UDC | 3 | 0 |
| 49: Transportation Management | ||||||||||
| 2 | F4981 | Freight Audit History | 78 | FH | ADSO | Origin State | String | UDC | 3 | 0 |
| 75I: India | ||||||||||
| 3 | F75I2213 | Setoff Temp Table | 29 | TT | ADSO | Origin State | String | UDC | 3 | 0 |
| 4 | F75I401 | Sales Form Information-IND-42 | 27 | QA | ADSO | Origin State | String | UDC | 3 | 0 |
| 5 | F75I401C | Sales Form Information- Secondary | 18 | QA | ADSO | Origin State | String | UDC | 3 | 0 |
| 6 | F75I402 | Purchase Tax Form Details | 27 | PT | ADSO | Origin State | String | UDC | 3 | 0 |
| 7 | F75I402T | Purchase Tax Form Details -Secondary | 25 | PT | ADSO | Origin State | String | UDC | 3 | 0 |
| 8 | F75I403 | Stock Transfer Details | 23 | AB | ADSO | Origin State | String | UDC | 3 | 0 |
| 9 | F75I403T | Temp Data for F75i403 | 26 | AB | ADSO | Origin State | String | UDC | 3 | 0 |
| 10 | F75I406 | State / Branch Plant Cross Reference | 3 | SB | ADSO | Origin State | String | UDC | 3 | 0 |
| 11 | F75I4210 | Sales Form Tracking - Secondary | 9 | FT | ADSO | Origin State | String | UDC | 3 | 0 |
| 89: Conversion Programs | ||||||||||
| 12 | F4215T | OBSOLETE - Shipment Header Tag File | 3 | XT | ADSO | Origin State | String | UDC | 3 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
UDC 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 |