| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP15: Property Management |
1 | F15014 | Product Scales Master | 3 | NP | PRDC | Product Code | String | UDC | 4 | 0 |
2 | F15014B | Product Scales Master | 7 | NP | PRDC | Product Code | String | UDC | 4 | 0 |
3 | F1511 | Tenant/Lease Billings Detail | 39 | NJ | PRDC | Product Code | String | UDC | 4 | 0 |
4 | F1511B | Tenant/Lease Billings Detail Master | 39 | NJ | PRDC | Product Code | String | UDC | 4 | 0 |
5 | F1511H | Tenant/Lease Billings Detail History | 39 | N# | PRDC | Product Code | String | UDC | 4 | 0 |
6 | F1511HB | Tenant/Lease Billings Detail History | 39 | NC | PRDC | Product Code | String | UDC | 4 | 0 |
7 | F1540 | Sales Report Control File | 4 | NR | PRDC | Product Code | String | UDC | 4 | 0 |
8 | F1540B | Sales Report Control File | 7 | NR | PRDC | Product Code | String | UDC | 4 | 0 |
9 | F1541 | Tenant Sales History | 5 | N8 | PRDC | Product Code | String | UDC | 4 | 0 |
10 | F15410 | Tenant Weekly Sales File | 6 | N9 | PRDC | Product Code | String | UDC | 4 | 0 |
11 | F1541B | Tenant Sales History File | 6 | N8 | PRDC | Product Code | String | UDC | 4 | 0 |
12 | F1541BW | Sales History Work File | 8 | OW | PRDC | Product Code | String | UDC | 4 | 0 |
13 | F1542 | Projected Sales | 6 | OJ | PRDC | Product Code | String | UDC | 4 | 0 |
14 | F1543B | Tenant Sales Analysis Reporting File | 9 | OA | PRDC | Product Code | String | UDC | 4 | 0 |
15 | F1547 | Sales Seasonality | 7 | OI | PRDC | Product Code | String | UDC | 4 | 0 |
TOP15L: Adv Real Estate Forecasting |
16 | F15L301 | AREF Projected Sales | 6 | PS | PRDC | Product Code | String | UDC | 4 | 0 |
17 | F15L302 | AREF Prior Gross Billings | 13 | PG | PRDC | Product Code | String | UDC | 4 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.