| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F0012 | Automatic Accounting Instructions Master | 15 | KG | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| 2 | F00144 | Installment Payment Terms | 2 | L6 | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| TOP04: Accounts Payable |
| 3 | F0411 | Accounts Payable Ledger | 142 | RP | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| 4 | F0411A | WF - As Of Accounts Payable Ledger | 142 | RP | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| 5 | F0411P | Purge - Accounts Payable Ledger | 142 | RP | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| 6 | F0411Z3 | F0411 Interoperability Table | 196 | SZ | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| TOP05: Time Accounting and HRM Base |
| 7 | F050612 | Media Object URL Intersection | 3 | UR | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| TOP08: Human Resources |
| 8 | F085520W | Available Plans and Plan Options by Employee Work Table | 42 | AP | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| 9 | F085530W | Employee Current/Pending Elections Work Table | 24 | CP | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| TOP15: Property Management |
| 10 | F15152 | Lease E.P. Caps | 4 | LC | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| 11 | F15701 | Legal Clause Options Audit | 7 | NK | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| 12 | F157021 | Legal Clause Space Detail Audit | 5 | NG | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| 13 | F15703 | Legal Clause Amounts | 4 | NI | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| TOP17: Customer Service Management |
| 14 | F4801TZ2 | Warranty Claim/Supplier Recovery processing | 110 | WQ | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| TOP31P: Engineer To Order |
| 15 | F31P11 | Project Quote Detail | 3 | QP | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| 16 | F31PUI01 | Scheduling Error Report | 7 | SE | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| TOP32: Configuration Management |
| 17 | F3216 | Configurator Price/Cost Table | 3 | PC | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| 18 | F32169 | Configurator Price/Cost History | 3 | KB | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| TOP40R: Demand Scheduling |
| 19 | F47UI002 | ASN Extract Packaging Work File | 29 | SP | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| TOP42: Sales Management |
| 20 | F42565 | Invoice Print File | 102 | IW | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| TOP43: Procurement |
| 21 | F4320 | Purchase Order Clauses | 2 | PC | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| 22 | F43UI50C | PO Print Clauses Table | 2 | WC | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| TOP43C: Contracts |
| 23 | F43C20 | Contract Payee | 22 | CP | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| 24 | F43C600 | Clauses Mass Update | 2 | CP | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| TOP47: Electronic Commerce |
| 25 | F47013 | EDI Purchase Order Detail (SDQ) - Inbound | 46 | SP | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| 26 | F47093 | EDI Request for Quote Detail (SDQ) - Inbound | 46 | SP | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| 27 | F47114 | EDI Lockbox/Payment Detail - Payment | 11 | Z4 | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| 28 | F47123 | EDI Product Activity Data (SDQ) - Inbound | 10 | MK | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| 29 | F47128 | EDI Product Activity Data (SDQ) - Outbound | 10 | MK | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| 30 | F47CTL | EDI Lockbox/Payment Work File | 9 | Z5 | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| 31 | F47HL | Hierarchical Configuration | 5 | HL | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| TOP48: Work Order Processing |
| 32 | F4801ST | Purge - Work Order Master Tag File | 96 | WA | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| 33 | F4801T | Work Order Master Tag File | 96 | WA | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| 34 | F4801Z1 | Outbound Work Order Header | 200 | SY | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| TOP49: Transportation Management |
| 35 | F49110 | Transportation Bill of Lading Workfile | 8 | BW | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| 36 | F49130 | Shipment Document Workfile | 10 | BW | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| 37 | F49592 | Document Print Batch Document Header | 19 | DH | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| 38 | F49594 | Document Print - Document Detail | 5 | DI | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| 39 | F49696 | Document Register Detail | 7 | DJ | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| TOP89: Conversion Programs |
| 40 | F32941 | Needed for upgrade from Xe and below | 3 | SM | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| 41 | F32944 | Needed for upgrade from Xe and below | 4 | KT | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
| 42 | F329611 | Needed for upgrade from Xe and below | 9 | KB | SEQN | Sequence Number | Numeric | Generic Edit | 7 | 0 |
