| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP44H: Homebuilder Management |
1 | F44H0920 | Extended Homebuilder Data Template | 3 | ST | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
2 | F44H0921 | Extended Homebuilder Data Headings | 3 | EH | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
3 | F44H0929 | Extended Homebuilder Data | 1 | ED | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
4 | F44H092H | Extended Homebuilder Data Headings | 3 | EH | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
5 | F44H092T | Extended Homebuilder Data Template | 3 | ST | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
6 | F44H101 | Community Phase Master | 4 | CM | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
7 | F44H101Z | HB Community Master Unedited Transaction File | 17 | SZ | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
8 | F44H201 | Lot Master | 11 | LM | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
9 | F44H201H | Lot Master History | 12 | LM | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
10 | F44H201Z | HB Lot Master Unedited Transaction File | 24 | SZ | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
11 | F44H301 | Plan Master | 5 | PM | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
12 | F44H401 | Option Master | 1 | OC | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
13 | F44H4011 | Option by Community | 1 | OC | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
14 | F44H401W | Option Master Work File | 2 | OW | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
15 | F44H402 | Option Relationships | 1 | PK | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
16 | F44H403 | Option Preferences | 1 | OP | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
17 | F44H4031 | Option Preferences - Valid Values | 1 | OV | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
18 | F44H4101 | Item Master HomeBuilder Extension | 2 | HI | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
19 | F44H501 | Sales Master Table | 6 | SM | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
20 | F44H501H | Lot Sales History | 7 | LS | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
21 | F44H501S | Sales Statistics History | 6 | SS | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
22 | F44H501W | Sales Statistics Work Table | 3 | SS | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
23 | F44H501Z | HB Sales Master Unedited Transaction File | 19 | SZ | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
24 | F44H511 | Option Selections | 5 | OS | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
25 | F44H511H | Option Selection History | 6 | OH | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
26 | F44H592 | Closing Worksheet Extended Data Mapping | 4 | EM | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
27 | F44H601 | Bid Header | 5 | BH | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
28 | F44H602 | Takeoff Master File | 1 | TO | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
29 | F44H602H | Takeoff History File | 1 | TH | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
30 | F44H602W | Take Off Summary Workfile | 2 | TS | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
31 | F44H603 | Material Item Pricing | 1 | MP | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
32 | F44H604 | Vendor Assignment | 1 | VA | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
33 | F44H604W | Vendor Assignment Workfile | 4 | VW | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
34 | F44H604Z | HB Vendor Assignment Unedited Transaction File | 14 | SZ | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
35 | F44H611 | Bid Details | 6 | BD | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
36 | F44H611W | Bid Details Work File | 10 | BW | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
37 | F44H711 | Lot Start Workfile | 33 | SW | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
38 | F44H711P | After Start Purchasing | 7 | TP | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
39 | F44H711Z | HB Lot Start Unedited Transaction File | 46 | SZ | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
40 | F44H71W1 | Lot Start Generation Workfile | 33 | GW | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
41 | F44H73W1 | Lot Start - P.O. / Committment Generation Work File | 16 | CG | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
42 | F44H73W2 | Lot Start - Budget Generation Workfile | 12 | BG | HBAREA | HomeBuilder Area ID | String | UDC | 3 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.