| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP44H: Homebuilder Management |
| 1 | F44H201 | Lot Master | 25 | LM | HBSCS | Sales Contract Status | String | UDC | 3 | 0 |
| 2 | F44H201H | Lot Master History | 26 | LM | HBSCS | Sales Contract Status | String | UDC | 3 | 0 |
| 3 | F44H201Z | HB Lot Master Unedited Transaction File | 38 | SZ | HBSCS | Sales Contract Status | String | UDC | 3 | 0 |
| 4 | F44H501 | Sales Master Table | 17 | SM | HBSCS | Sales Contract Status | String | UDC | 3 | 0 |
| 5 | F44H501H | Lot Sales History | 18 | LS | HBSCS | Sales Contract Status | String | UDC | 3 | 0 |
| 6 | F44H501W | Sales Statistics Work Table | 10 | SS | HBSCS | Sales Contract Status | String | UDC | 3 | 0 |
| 7 | F44H501Z | HB Sales Master Unedited Transaction File | 30 | SZ | HBSCS | Sales Contract Status | 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 44H5 / ST (Sales Contract Status) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | Allow Blank Status | | N |
| 2 | 4SL | Released for Sale | | N |
| 3 | CAN | Cancelled | | N |
| 4 | CLS | Closed | | N |
| 5 | SAL | Sold | | N |
| 6 | SPC | Spec House | | N |
| 7 | TRI | Transfer - In | | N |
| 8 | TRO | Transfer - Out | | N |
