| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP44H: Homebuilder Management |
| 1 | F44H401 | Option Master | 13 | OC | OPTYP | Option Type | String | UDC | 3 | 0 |
| 2 | F44H4011 | Option by Community | 14 | OC | OPTYP | Option Type | String | UDC | 3 | 0 |
| 3 | F44H401W | Option Master Work File | 19 | OW | OPTYP | Option Type | String | UDC | 3 | 0 |
| 4 | F44H511 | Option Selections | 20 | OS | OPTYP | Option Type | String | UDC | 3 | 0 |
| 5 | F44H511H | Option Selection History | 21 | OH | OPTYP | Option Type | String | UDC | 3 | 0 |
| 6 | F44H599 | Closing Worksheet Data Mapping | 4 | CM | OPTYP | Option Type | String | UDC | 3 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 44H4 / OT (Option Type) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | No Option Type Selected | | N |
| 2 | ALA | Alarm Systems | | N |
| 3 | APL | Appliances | | N |
| 4 | CAB | Cabinets | | N |
| 5 | COR | Corian Countertops | | N |
| 6 | DC | Design Center Options | | N |
| 7 | ELC | Electrical Options | | N |
| 8 | EXT | Exterior Options | | N |
| 9 | HVC | HVAC Options | | N |
| 10 | INT | Interior Trim/Hdware Opts | | N |
| 11 | NEW | New Option Type | | N |
| 12 | PLM | Plumbing | | N |
| 13 | STR | Structural Options | | N |
| 14 | WIN | Window Options | | N |
