| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F1501 | Tenant/Lease Master | 15 | NE | LSET | Lease Type | String | UDC | 2 | 0 |
| TOP15: Property Management |
| 2 | F1501B | Lease Master Header File | 16 | NE | LSET | Lease Type | String | UDC | 2 | 0 |
| 3 | F1502 | Recurring Billings Master | 2 | NF | LSET | Lease Type | String | UDC | 2 | 0 |
| 4 | F1502B | Recurring Billings Master | 2 | NF | LSET | Lease Type | String | UDC | 2 | 0 |
| 5 | F1502WB | Estimated EP Recurring Billing Work File (OneWorld) | 4 | N4 | LSET | Lease Type | String | UDC | 2 | 0 |
| 6 | F1503 | Log Standards Master | 2 | NB | LSET | Lease Type | String | UDC | 2 | 0 |
| 7 | F1523 | Log Standard Master | 12 | OG | LSET | Lease Type | String | UDC | 2 | 0 |
| 8 | F1543B | Tenant Sales Analysis Reporting File | 27 | OA | LSET | Lease Type | String | UDC | 2 | 0 |
| 9 | F157012 | Lease Option Type Detail | 7 | NC | LSET | Lease Type | String | UDC | 2 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 15 / LT (Tenant Lease Type) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | AP | Apartment | N | N |
| 2 | CO | Commercial Office | N | N |
| 3 | ID | Industrial | N | N |
| 4 | LL | Land Lease | N | N |
| 5 | OA | Operating Agreement | N | N |
| 6 | RS | Restaurant | N | N |
| 7 | RT | Retail | N | N |
| 8 | SB | Sub Lease | N | N |
| 9 | SL | Speculative Lease | N | N |
| 10 | TS | Trade Show Booth | N | N |
| 11 | WH | Warehouse / Storage | N | N |
