| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP44H: Homebuilder Management |
1 | F44H0929 | Extended Homebuilder Data | 6 | ED | HBPLAN | Plan Number | String | Generic Edit | 4 | 0 |
2 | F44H201 | Lot Master | 12 | LM | HBPLAN | Plan Number | String | Generic Edit | 4 | 0 |
3 | F44H201H | Lot Master History | 13 | LM | HBPLAN | Plan Number | String | Generic Edit | 4 | 0 |
4 | F44H201Z | HB Lot Master Unedited Transaction File | 25 | SZ | HBPLAN | Plan Number | String | Generic Edit | 4 | 0 |
5 | F44H301 | Plan Master | 3 | PM | HBPLAN | Plan Number | String | Generic Edit | 4 | 0 |
6 | F44H401 | Option Master | 4 | OC | HBPLAN | Plan Number | String | Generic Edit | 4 | 0 |
7 | F44H4011 | Option by Community | 4 | OC | HBPLAN | Plan Number | String | Generic Edit | 4 | 0 |
8 | F44H401W | Option Master Work File | 5 | OW | HBPLAN | Plan Number | String | Generic Edit | 4 | 0 |
9 | F44H402 | Option Relationships | 4 | PK | HBPLAN | Plan Number | String | Generic Edit | 4 | 0 |
10 | F44H403 | Option Preferences | 4 | OP | HBPLAN | Plan Number | String | Generic Edit | 4 | 0 |
11 | F44H4031 | Option Preferences - Valid Values | 4 | OV | HBPLAN | Plan Number | String | Generic Edit | 4 | 0 |
12 | F44H501 | Sales Master Table | 10 | SM | HBPLAN | Plan Number | String | Generic Edit | 4 | 0 |
13 | F44H501H | Lot Sales History | 11 | LS | HBPLAN | Plan Number | String | Generic Edit | 4 | 0 |
14 | F44H501Z | HB Sales Master Unedited Transaction File | 23 | SZ | HBPLAN | Plan Number | String | Generic Edit | 4 | 0 |
15 | F44H602 | Takeoff Master File | 2 | TO | HBPLAN | Plan Number | String | Generic Edit | 4 | 0 |
16 | F44H602H | Takeoff History File | 2 | TH | HBPLAN | Plan Number | String | Generic Edit | 4 | 0 |
17 | F44H602W | Take Off Summary Workfile | 3 | TS | HBPLAN | Plan Number | String | Generic Edit | 4 | 0 |
18 | F44H611 | Bid Details | 14 | BD | HBPLAN | Plan Number | String | Generic Edit | 4 | 0 |
19 | F44H611W | Bid Details Work File | 18 | BW | HBPLAN | Plan Number | String | Generic Edit | 4 | 0 |
20 | F44H711 | Lot Start Workfile | 75 | SW | HBPLAN | Plan Number | String | Generic Edit | 4 | 0 |
21 | F44H711Z | HB Lot Start Unedited Transaction File | 88 | SZ | HBPLAN | Plan Number | String | Generic Edit | 4 | 0 |
22 | F44H71W1 | Lot Start Generation Workfile | 75 | GW | HBPLAN | Plan Number | String | Generic Edit | 4 | 0 |
23 | F44H73W1 | Lot Start - P.O. / Committment Generation Work File | 20 | CG | HBPLAN | Plan Number | String | Generic Edit | 4 | 0 |