| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP01: Address Book |
| 1 | F0101 | Address Book Master | 7 | AB | SIC | Industry Classification Code | String | UDC | 10 | 0 |
| 2 | F0101Z2 | Address Book - Interoperability | 20 | SZ | SIC | Industry Classification Code | String | UDC | 10 | 0 |
| TOP05U: OW HR & PR Foundation US |
| 3 | F05850 | EEO-1 Annual Data | 5 | EO | SIC | Industry Classification Code | String | UDC | 10 | 0 |
| TOP15: Property Management |
| 4 | F1501 | Tenant/Lease Master | 17 | NE | SIC | Industry Classification Code | String | UDC | 10 | 0 |
| 5 | F1501B | Lease Master Header | 24 | NE | SIC | Industry Classification Code | String | UDC | 10 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 01 / SC (Standard Industry Code) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | 0100 | Agricul. Products/Crops (APC) | | N |
| 2 | 0700 | Agricultural Services (AS) | | N |
| 3 | 0800 | Forestry Products | | N |
| 4 | 1000 | Metal Mining (MM) | | N |
| 5 | 1500 | General Bldg. Contractors(GBC) | | N |
| 6 | 1521 | GBC/Single Family Housing | | N |
| 7 | 2000 | Manufacturing, Food Prod (MFP) | | N |
| 8 | 2032 | MFP/Canned Specialties | | N |
| 9 | 5000 | Wholesale Trade | | N |
| 10 | 5200 | Retail Trade | | N |
| 11 | 6000 | Finance, Insurance, RealEstate | | N |
| 12 | 7000 | Services | | N |
| 13 | 9000 | Government/Public Admin | | N |
