| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP15: Property Management |
1 | F1503 | Log Standards Master | 30 | NB | FLOR | Number - Floor | String | UDC | 4 | 0 |
2 | F1504 | Log Standards Text Master | 7 | NC | FLOR | Number - Floor | String | UDC | 4 | 0 |
3 | F1506 | Floor Master File | 3 | OP | FLOR | Number - Floor | String | UDC | 4 | 0 |
4 | F1506D | Floor Master - Alternate Description | 2 | OP | FLOR | Number - Floor | String | UDC | 4 | 0 |
5 | F1507 | Unit Master File | 4 | NH | FLOR | Number - Floor | String | UDC | 4 | 0 |
6 | F1514 | Area Master | 2 | NW | FLOR | Number - Floor | String | UDC | 4 | 0 |
7 | F15141 | Gross Lease Occupied Areas | 3 | NC | FLOR | Number - Floor | String | UDC | 4 | 0 |
8 | F1514D | Area Master - Alternate Description | 2 | NW | FLOR | Number - Floor | String | UDC | 4 | 0 |
9 | F1521 | Log Detail Master | 25 | NB | FLOR | Number - Floor | String | UDC | 4 | 0 |
10 | F1541 | Tenant Sales History | 29 | N8 | FLOR | Number - Floor | String | UDC | 4 | 0 |
11 | F15410 | Tenant Weekly Sales File | 26 | N9 | FLOR | Number - Floor | String | UDC | 4 | 0 |
12 | F1541B | Tenant Sales History File | 36 | N8 | FLOR | Number - Floor | String | UDC | 4 | 0 |
13 | F1541BW | Sales History Work File | 48 | OW | FLOR | Number - Floor | String | UDC | 4 | 0 |
14 | F1543B | Tenant Sales Analysis Reporting File | 13 | OA | FLOR | Number - Floor | String | UDC | 4 | 0 |
15 | F15702 | Legal Clause Space Detail | 7 | NF | FLOR | Number - Floor | String | UDC | 4 | 0 |
16 | F159071 | Market/Potential/Renewal Rent Master | 3 | NY | FLOR | Number - Floor | String | UDC | 4 | 0 |
TOP15L: Adv Real Estate Forecasting |
17 | F15L101 | AREF Unit Master | 6 | UM | FLOR | Number - Floor | String | UDC | 4 | 0 |
18 | F15L141 | AREF Gross Lease Occupied Area | 4 | GL | FLOR | Number - Floor | String | UDC | 4 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.