| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0006 | Business Unit Master | 8 | MC | CNTY | County | String | UDC | 3 | 0 |
2 | F0006S | Date Effective Business Unit Master | 10 | MC | CNTY | County | String | UDC | 3 | 0 |
3 | F0006Z1 | Cost Center Unedited Transaction Table | 21 | SZ | CNTY | County | String | UDC | 3 | 0 |
4 | F0006Z2 | Business Unit Master Z File | 21 | SZ | CNTY | County | String | UDC | 3 | 0 |
TOP75T: Taiwan |
5 | F75T001 | GUI/VAT Declaration Site - 75T | 8 | DS | CNTY | County | 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 / 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 | | |