| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F4303M | Log Models | 18 | PM | USD1 | User Date 1 | Date | Generic Edit | 6 | 0 |
TOP05A: OW HR & PR Foundation |
2 | F060116W | EE Master Request File | 210 | YA | USD1 | User Date 1 | Date | Generic Edit | 6 | 0 |
TOP43: Procurement |
3 | F4303 | Log Master | 20 | PK | USD1 | User Date 1 | Date | Generic Edit | 6 | 0 |
4 | F4305 | Log Master | 28 | PL | USD1 | User Date 1 | Date | Generic Edit | 6 | 0 |
TOP44H: Homebuilder Management |
5 | F4450 | Lot Proceed Header (World) | 75 | JD | USD1 | User Date 1 | Date | Generic Edit | 6 | 0 |
6 | F4453 | Lot Master (World) | 10 | JB | USD1 | User Date 1 | Date | Generic Edit | 6 | 0 |
7 | F4456 | Lot Proceed Entry (World) | 75 | JI | USD1 | User Date 1 | Date | Generic Edit | 6 | 0 |
8 | F4461 | Option Master (World) | 26 | JN | USD1 | User Date 1 | Date | Generic Edit | 6 | 0 |
9 | F44H101 | Community Phase Master | 83 | CM | USD1 | User Date 1 | Date | Generic Edit | 6 | 0 |
10 | F44H101Z | HB Community Master Unedited Transaction File | 96 | SZ | USD1 | User Date 1 | Date | Generic Edit | 6 | 0 |
11 | F44H201 | Lot Master | 61 | LM | USD1 | User Date 1 | Date | Generic Edit | 6 | 0 |
12 | F44H201H | Lot Master History | 62 | LM | USD1 | User Date 1 | Date | Generic Edit | 6 | 0 |
13 | F44H201Z | HB Lot Master Unedited Transaction File | 74 | SZ | USD1 | User Date 1 | Date | Generic Edit | 6 | 0 |
14 | F44H301 | Plan Master | 63 | PM | USD1 | User Date 1 | Date | Generic Edit | 6 | 0 |
15 | F44H401 | Option Master | 59 | OC | USD1 | User Date 1 | Date | Generic Edit | 6 | 0 |
16 | F44H4011 | Option by Community | 54 | OC | USD1 | User Date 1 | Date | Generic Edit | 6 | 0 |
17 | F44H401W | Option Master Work File | 65 | OW | USD1 | User Date 1 | Date | Generic Edit | 6 | 0 |
18 | F44H402 | Option Relationships | 15 | PK | USD1 | User Date 1 | Date | Generic Edit | 6 | 0 |
19 | F44H501 | Sales Master Table | 115 | SM | USD1 | User Date 1 | Date | Generic Edit | 6 | 0 |
20 | F44H501H | Lot Sales History | 116 | LS | USD1 | User Date 1 | Date | Generic Edit | 6 | 0 |
21 | F44H501Z | HB Sales Master Unedited Transaction File | 128 | SZ | USD1 | User Date 1 | Date | Generic Edit | 6 | 0 |
TOP52: Contract Billing |
22 | F5201 | Contract Master | 55 | G4 | USD1 | User Date 1 | Date | Generic Edit | 6 | 0 |
TOP52G: Government Contracting |
23 | F52G01M | Project and Government Contract Modifications | 60 | CM | USD1 | User Date 1 | Date | Generic Edit | 6 | 0 |
24 | F52G05 | ACRN Detail Table | 25 | AD | USD1 | User Date 1 | Date | Generic Edit | 6 | 0 |
25 | F52G05H | ACRN History Table | 32 | AH | USD1 | User Date 1 | Date | Generic Edit | 6 | 0 |