| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 00: Foundation Environment | ||||||||||
| 1 | F1501 | Tenant/Lease Master | 17 | NE | SIC | Industry Classification Code | String | UDC | 10 | 0 |
| 01: Address Book | ||||||||||
| 2 | F0101 | Address Book Master | 7 | AB | SIC | Industry Classification Code | String | UDC | 10 | 0 |
| 3 | F0101Z2 | Address Book - Interoperability | 20 | SZ | SIC | Industry Classification Code | String | UDC | 10 | 0 |
| 05U: OW HR & PR Foundation US | ||||||||||
| 4 | F05850 | EEO-1 Annual Data | 5 | EO | SIC | Industry Classification Code | String | UDC | 10 | 0 |
| 15: Property Management | ||||||||||
| 5 | F1501B | Lease Master Header File | 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.
UDC 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 |