| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP44H: Homebuilder Management |
| 1 | F44H201 | Lot Master | 21 | LM | CONLST | Construction Status Code Last | String | UDC | 3 | 0 |
| 2 | F44H201H | Lot Master History | 22 | LM | CONLST | Construction Status Code Last | String | UDC | 3 | 0 |
| 3 | F44H201Z | HB Lot Master Unedited Transaction File | 34 | SZ | CONLST | Construction Status Code Last | String | UDC | 3 | 0 |
| 4 | F44H501H | Lot Sales History | 166 | LS | CONLST | Construction Status Code Last | String | UDC | 3 | 0 |
| 5 | F44H9911 | Milestone Status Rules | 3 | MS | CONLST | Construction Status Code Last | 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 44H0 / RL (Homebuilder Activity Rules) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | No Status | | Y |
| 2 | 1 | Construction Activities ------ | | Y |
| 3 | 100 | Released for Construction | | Y |
| 4 | 200 | Construction Start | | Y |
| 5 | 220 | Foundation | | Y |
| 6 | 230 | Framing | | Y |
| 7 | 240 | Plumbing | | Y |
| 8 | 250 | Electrical | | Y |
| 9 | 260 | Roof | | Y |
| 10 | 270 | Cabinets | | Y |
| 11 | 280 | Surfaces | | Y |
| 12 | 290 | Finish | | Y |
| 13 | 300 | Inspection | | Y |
| 14 | 370 | New HB Activity Rule | | Y |
| 15 | 450 | Construction Complete | | Y |
| 16 | 5 | Sales Activities ------------ | | Y |
| 17 | 500 | Released for Sale | | Y |
| 18 | 505 | Hot Prospect | | Y |
| 19 | 510 | Really Hot Prospect | | Y |
| 20 | 580 | Transfer out | | Y |
| 21 | 590 | Canceled Sale | | Y |
| 22 | 600 | Sold | | Y |
| 23 | 900 | Closed | | Y |
