| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP15: Real Estate 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 | 16 | NR | ULI2 | Tenant Sales Category | String | UDC | 8 | 0 |
| 4 | F15410 | Tenant Weekly Sales | 14 | N9 | ULI2 | Tenant Sales Category | String | UDC | 8 | 0 |
| 5 | F1541B | Tenant Sales History | 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 | | . | N | N |
| 2 | A01 | Department Stores | N | N |
| 3 | B05 | Food | N | N |
| 4 | D02 | Clothing | N | N |
| 5 | D08 | Menswear | N | N |
| 6 | E01 | Family Shoes | N | N |
| 7 | E02 | Ladies Shoes | N | N |
| 8 | E03 | Children's Shoes | N | N |
| 9 | G04 | Records & Tapes | N | N |
| 10 | G07 | Computer / Calculator | 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 and Loan | 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 Office | N | N |
| 24 | Z04 | Storage | N | N |
