| 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: PeopleSoft 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: Proj & Gov Contract Accounting |
| 23 | F52G01M | Advanced Contracts 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 |
