| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP44H: Homebuilder Management |
| 1 | F44H501 | Sales Master Table | 13 | SM | SALLST | Sales Activity Code - Last | String | UDC | 3 | 0 |
| 2 | F44H501H | Lot Sales History | 14 | LS | SALLST | Sales Activity Code - Last | String | UDC | 3 | 0 |
| 3 | F44H501Z | HB Sales Master Unedited Transaction File | 26 | SZ | SALLST | Sales Activity 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 |
