| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP40: Inventory/OP Base |
| 1 | F4001Z | Batch Receiver File - Order Headings | 58 | SY | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 2 | F4201Z1 | Sales Order Header Unedited Transaction File | 47 | SY | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| TOP42: Sales Management |
| 3 | F4201 | Sales Order Header File | 34 | SH | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 4 | F42019 | Sales Order Header History File | 34 | SH | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 5 | F42UI01 | SO Header Cache File (MBF) | 39 | ZH | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| TOP43: Procurement |
| 6 | F4301 | Purchase Order Header | 52 | PH | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 7 | F4301Z | PO Header Work File | 56 | PA | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 8 | F4301Z1 | Purchase Order Header Unedited Transaction Table | 65 | SY | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 9 | F4314Z | Voucher Match Selection File | 71 | PN | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| TOP44H: Homebuilder Management |
| 10 | F4459 | Material Item Pricing (World) | 29 | JL | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 11 | F44H601 | Bid Header | 38 | BH | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 12 | F44H603 | Material Item Pricing | 15 | MP | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 13 | F44H611 | Bid Details | 64 | BD | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 14 | F44H611W | Bid Details Work File | 68 | BW | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 15 | F44H711 | Lot Start Workfile | 78 | SW | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 16 | F44H711Z | HB Lot Start Unedited Transaction File | 91 | SZ | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 17 | F44H71W1 | Lot Start Generation Workfile | 78 | GW | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 18 | F44H73W1 | Lot Start - P.O. / Committment Generation Work File | 60 | CG | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| TOP47: Electronic Commerce |
| 19 | F47011 | EDI Purchase Order Header - Inbound | 53 | SY | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 20 | F47016 | EDI Purchase Order Header - Outbound | 67 | SY | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 21 | F47021 | EDI P.O. Acknowledgment Header - Inbound | 67 | SY | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 22 | F47026 | EDI P.O. Acknowledgment Header - Outbound | 49 | SY | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 23 | F47031 | EDI Shipping Notice Header - Inbound | 62 | SY | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 24 | F47046 | EDI Invoice Header (Sales) - Outbound | 49 | SY | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 25 | F47071 | EDI Receiving Advice Header - Inbound | 68 | SY | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 26 | F47076 | EDI Receiving Advice Header - Outbound | 68 | SY | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 27 | F47091 | EDI Request for Quote Header - Inbound | 53 | SY | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 28 | F47096 | EDI Request for Quote Header - Outbound | 67 | SY | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 29 | F47101 | EDI Response to RFQ Header - Inbound | 67 | SY | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 30 | F47106 | EDI Response to RFQ Header - Outbound | 49 | SY | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 31 | F47131 | EDI Purchase Order Change Header - Inbound | 50 | SY | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 32 | F47136 | EDI Purchase Order Change Header - Outbound | 67 | SY | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 33 | F47141 | EDI P.O. Change Acknowledgment Header - Inbound | 68 | SY | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 34 | F47146 | EDI P.O. Change Acknowledgment Header - Outbound | 50 | SY | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| 35 | F47156 | EDI Shipping Schedule Header - Outbound | 70 | SY | PCRT | Percent - Retainage | Numeric | Generic Edit | 7 | 3 |
| TOPH90: EnterpriseOne TOOLS |
| 36 | F98887 | Composer Industry and Geograhpic Locations Xref | 1 | PC | RT | User Defined Codes | String | Generic Edit | 2 | 0 |
