| 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 | 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 | 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 | 26 | N9 | FLOR | Number - Floor | String | UDC | 4 | 0 |
12 | F1541B | Tenant Sales History | 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.
TOPUDC 15 / FL (Floor) stock values
| Value | Description | Special Handling Code | Hard Coded |
---|
1 | | No Floor | N | N |
2 | 1 | First Floor | N | N |
3 | 2 | Second Floor | N | N |
4 | 3 | Third Floor | N | N |
5 | 4 | Fourth Floor | N | N |
6 | 5 | Fifth Floor | N | N |
7 | 6 | Sixth Floor | N | N |
8 | 7 | Seventh Floor | N | N |
9 | 8 | Eighth Floor | N | N |
10 | 9 | Ninth Floor | N | N |
11 | 10 | Tenth Floor | N | N |
12 | 01 | First Floor | N | N |
13 | 02 | Second Floor | N | N |
14 | 03 | Third Floor | N | N |
15 | 04 | Fourth Floor | N | N |
16 | 05 | Fifth Floor | N | N |
17 | 06 | Sixth Floor | N | N |
18 | 07 | Seventh Floor | N | N |
19 | 08 | Eighth Floor | N | N |
20 | 09 | Ninth Floor | N | N |
21 | 10 | Tenth Floor | N | N |
22 | 11 | Eleventh Floor | N | N |
23 | 12 | Twelth Floor | N | N |
24 | LOB | Lobby | N | N |
25 | MEZ | Mezzanine | N | N |
26 | P1 | Parking Level One | N | N |
27 | P2 | Parking Level Two | N | N |
28 | P3 | Parking Level Three | N | N |
29 | PENT | Penthouse | N | N |