| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP44H: Homebuilder Management |
| 1 | F44H201 | Lot Master | 18 | LM | LSTATHB | Lot Status Code - HomeBuilder | Character | UDC | 1 | 0 |
| 2 | F44H201H | Lot Master History | 19 | LM | LSTATHB | Lot Status Code - HomeBuilder | Character | UDC | 1 | 0 |
| 3 | F44H201Z | HB Lot Master Unedited Transaction File | 31 | SZ | LSTATHB | Lot Status Code - HomeBuilder | Character | UDC | 1 | 0 |
| 4 | F44H501H | Lot Sales History | 168 | LS | LSTATHB | Lot Status Code - HomeBuilder | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 44H2 / LS (Lot Status Code) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | 0 | Not Available | | Y |
| 2 | 1 | Not Sold / Not Started | | Y |
| 3 | 2 | Not Sold / Started | | Y |
| 4 | 3 | Sold / Not Started | | Y |
| 5 | 4 | Sold / Started | | Y |
| 6 | 5 | Not Sold / Completed | | Y |
| 7 | 6 | Sold / Completed | | Y |
| 8 | 9 | Closed | | Y |
| 9 | M | Model | | Y |
