| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP15: Property Management |
| 1 | F15013B | Sales Overage Master File | 33 | NO | ULI2 | Tenant Sales Category | String | UDC | 8 | 0 |
| 2 | F15014B | Product Scales Master | 14 | NP | ULI2 | Tenant Sales Category | String | UDC | 8 | 0 |
| 3 | F1540B | Sales Report Control File | 16 | NR | ULI2 | Tenant Sales Category | String | UDC | 8 | 0 |
| 4 | F15410 | Tenant Weekly Sales File | 14 | N9 | ULI2 | Tenant Sales Category | String | UDC | 8 | 0 |
| 5 | F1541B | Tenant Sales History File | 13 | N8 | ULI2 | Tenant Sales Category | String | UDC | 8 | 0 |
| 6 | F1541BW | Sales History Work File | 13 | OW | ULI2 | Tenant Sales Category | String | UDC | 8 | 0 |
| 7 | F1542 | Projected Sales | 13 | OJ | ULI2 | Tenant Sales Category | String | UDC | 8 | 0 |
| 8 | F1543B | Tenant Sales Analysis Reporting File | 15 | OA | ULI2 | Tenant Sales Category | String | UDC | 8 | 0 |
| 9 | F1549 | Seasonality Models | 6 | OL | ULI2 | Tenant Sales Category | String | UDC | 8 | 0 |
| TOP15L: Adv Real Estate Forecasting |
| 10 | F15L301 | AREF Projected Sales | 14 | PS | ULI2 | Tenant Sales Category | String | UDC | 8 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 15 / UL (Urban Land Institute Codes) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | A01 | Department Stores | N | N |
| 2 | B05 | Deli | N | N |
| 3 | D02 | Ladies Ready-to-Wear | N | N |
| 4 | D08 | Menswear | N | N |
| 5 | E01 | Family Shoes | N | N |
| 6 | E02 | Ladies Shoes | N | N |
| 7 | E03 | Mens & Boys Shoes | N | N |
| 8 | E04 | Childrens Shoes | N | N |
| 9 | G04 | Records & Tapes | N | N |
| 10 | G07 | Computer / Calculator (Retail) | N | N |
| 11 | M01 | Sporting Goods | N | N |
| 12 | M02 | Hobby | N | N |
| 13 | P03 | Jewelry | N | N |
| 14 | P04 | Cosmetics | N | N |
| 15 | R02 | Drugs / Pharmacy | N | N |
| 16 | S06 | Other Retail | N | N |
| 17 | X02 | Savings & Loans | N | N |
| 18 | X06 | Insurance | N | N |
| 19 | X07 | Real Estate | N | N |
| 20 | Y02 | Medical and Dental | N | N |
| 21 | Y03 | Legal | N | N |
| 22 | Y04 | Accounting | N | N |
| 23 | Y07 | Other Offices | N | N |
| 24 | Z04 | Storage | N | N |
| 25 | A01 | Department Stores | N | N |
| 26 | B05 | Deli | N | N |
| 27 | D02 | Ladies Ready-to-Wear | N | N |
| 28 | D08 | Menswear | N | N |
| 29 | E01 | Family Shoes | N | N |
| 30 | E02 | Ladies Shoes | N | N |
| 31 | E03 | Mens & Boys Shoes | N | N |
| 32 | E04 | Childrens Shoes | N | N |
| 33 | G04 | Records & Tapes | N | N |
| 34 | G07 | Computer / Calculator (Retail) | N | N |
| 35 | M01 | Sporting Goods | N | N |
| 36 | M02 | Hobby | N | N |
| 37 | P03 | Jewelry | N | N |
| 38 | P04 | Cosmetics | N | N |
| 39 | R02 | Drugs / Pharmacy | N | N |
| 40 | S06 | Other Retail | N | N |
| 41 | X02 | Savings & Loans | N | N |
| 42 | X06 | Insurance | N | N |
| 43 | X07 | Real Estate | N | N |
| 44 | Y02 | Medical and Dental | N | N |
| 45 | Y03 | Legal | N | N |
| 46 | Y04 | Accounting | N | N |
| 47 | Y07 | Other Offices | N | N |
| 48 | Z04 | Storage | N | N |
