| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP40: Inventory/OP Base |
| 1 | F40UI74 | Price Adjustment History Work File | 4 | AW | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
| TOP42: Sales Management |
| 2 | F42UI01 | SO Header Cache File (MBF) | 4 | ZH | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
| 3 | F42UI130 | Commitment Work File | 1 | ZC | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
| TOP42B: Sales Order Entry |
| 4 | F42216WF | Pending Blanket Release Work File - F42216WF | 6 | PB | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
| TOP43: Procurement |
| 5 | F4301Z | PO Header Work File | 101 | PA | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
| 6 | F43092Z | Receipt Routing Work File | 51 | PV | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
| 7 | F4311Z | Purchase Order Generator File | 226 | PW | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
| 8 | F43121Z | Receiver workfile | 137 | PW | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
| 9 | F4314Z | Voucher Match Selection File | 202 | PN | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
| 10 | F43632Z | Open Purchase Order by Item Work File | 2 | OI | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
| 11 | F4371 | Suggested Reorder Stock Items | 30 | PD | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
| TOP44H: Homebuilder Management |
| 12 | F44H73W1 | Lot Start - P.O. / Committment Generation Work File | 83 | CG | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
| TOP45: Advanced Pricing |
| 13 | F4072W | Price Adjustment Detail Work File | 40 | AD | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
| 14 | F4511W | Pricing Structure View | 4 | AP | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
| 15 | F45511W | Search Agent Directives Work File | 4 | SW | TCID | Transaction ID | Numeric | Generic Edit | 15 | 0 |
