| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 00: Foundation Environment | ||||||||||
| 1 | F1501 | Tenant/Lease Master | 31 | NE | SIC2 | Occupant SIC Code | String | UDC | 10 | 0 |
| 15: Property Management | ||||||||||
| 2 | F15017 | Lease Master Detail File | 8 | NW | SIC2 | Occupant SIC 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 |