| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP44H: Homebuilder Management |
1 | F44H101 | Community Phase Master | 104 | CM | HBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 |
2 | F44H101Z | HB Community Master Unedited Transaction File | 117 | SZ | HBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 |
3 | F44H201 | Lot Master | 111 | LM | HBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 |
4 | F44H201H | Lot Master History | 112 | LM | HBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 |
5 | F44H201Z | HB Lot Master Unedited Transaction File | 124 | SZ | HBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 |
6 | F44H301 | Plan Master | 78 | PM | HBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 |
7 | F44H401 | Option Master | 51 | OC | HBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 |
8 | F44H401W | Option Master Work File | 57 | OW | HBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 |
9 | F44H501 | Sales Master Table | 160 | SM | HBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 |
10 | F44H501H | Lot Sales History | 161 | LS | HBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 |
11 | F44H501Z | HB Sales Master Unedited Transaction File | 173 | SZ | HBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 |
12 | F44H511 | Option Selections | 27 | OS | HBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 |
13 | F44H511H | Option Selection History | 28 | OH | HBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 |
14 | F44H601 | Bid Header | 44 | BH | HBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 |
15 | F44H602 | Takeoff Master File | 32 | TO | HBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 |
16 | F44H602H | Takeoff History File | 33 | TH | HBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 |
17 | F44H602W | Take Off Summary Workfile | 21 | TS | HBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 |
18 | F44H603 | Material Item Pricing | 38 | MP | HBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 |
19 | F44H604 | Vendor Assignment | 15 | VA | HBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 |
20 | F44H604W | Vendor Assignment Workfile | 17 | VW | HBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 |
21 | F44H604Z | HB Vendor Assignment Unedited Transaction File | 28 | SZ | HBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 |
22 | F44H611 | Bid Details | 74 | BD | HBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 |
23 | F44H611W | Bid Details Work File | 78 | BW | HBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 |
24 | F44H711 | Lot Start Workfile | 90 | SW | HBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 |
25 | F44H711P | After Start Purchasing | 45 | TP | HBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 |
26 | F44H711Z | HB Lot Start Unedited Transaction File | 103 | SZ | HBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 |
27 | F44H71W1 | Lot Start Generation Workfile | 90 | GW | HBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 |
28 | F44H790 | Construction Milestones | 28 | HM | HBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 |