| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP34: Requirements Planning |
| 1 | F3411 | MPS/MRP/DRP Message File | 32 | MM | PNS | Production Number Short | Numeric | Generic Edit | 10 | 0 |
| 2 | F3412 | MPS/MRP/DRP Lower Level Requirements File | 18 | MW | PNS | Production Number Short | Numeric | Generic Edit | 10 | 0 |
| 3 | F3430 | Vendor Schedule Quantity File | 16 | MV | PNS | Production Number Short | Numeric | Generic Edit | 10 | 0 |
| 4 | F3435 | Vendor Schedule Commitment File | 29 | MC | PNS | Production Number Short | Numeric | Generic Edit | 10 | 0 |
| 5 | F34401 | Production Number Master File | 2 | PN | PNS | Production Number Short | Numeric | Generic Edit | 10 | 0 |
| 6 | F34401T | Production Number Master Tag File | 2 | PN | PNS | Production Number Short | Numeric | Generic Edit | 10 | 0 |
| 7 | F3450 | Adhoc Vendor Schedule File | 30 | MA | PNS | Production Number Short | Numeric | Generic Edit | 10 | 0 |
| 8 | F3460 | Forecast File | 22 | MF | PNS | Production Number Short | Numeric | Generic Edit | 10 | 0 |
| TOP36: Forecasting |
| 9 | F3460Z1 | Forecast Unedited Transactions | 40 | FT | PNS | Production Number Short | Numeric | Generic Edit | 10 | 0 |
| TOP41: Inventory Management |
| 10 | F41021T | Item Location Tag File | 7 | LT | PNS | Production Number Short | Numeric | Generic Edit | 10 | 0 |
| 11 | F4111 | Item Ledger File | 72 | IL | PNS | Production Number Short | Numeric | Generic Edit | 10 | 0 |
| 12 | F4141T | Cycle Count Transaction Tag File | 10 | PC | PNS | Production Number Short | Numeric | Generic Edit | 10 | 0 |
| TOP42: Sales Management |
| 13 | F4211 | Sales Order Detail File | 268 | SD | PNS | Production Number Short | Numeric | Generic Edit | 10 | 0 |
| 14 | F42119 | Sales Order History File | 268 | SD | PNS | Production Number Short | Numeric | Generic Edit | 10 | 0 |
| 15 | F42199 | S.O. Detail Ledger File | 268 | SL | PNS | Production Number Short | Numeric | Generic Edit | 10 | 0 |
| 16 | F42UI11 | SO Detail Cache File (MBF) | 189 | ZD | PNS | Production Number Short | Numeric | Generic Edit | 10 | 0 |
| TOP43: Procurement |
| 17 | F4311 | Purchase Order Detail File | 228 | PD | PNS | Production Number Short | Numeric | Generic Edit | 10 | 0 |
| 18 | F4311Z | Purchase Order Generator File | 254 | PW | PNS | Production Number Short | Numeric | Generic Edit | 10 | 0 |
| 19 | F4311Z1 | Purchase Order Detail Unedited Transaction Table | 237 | SZ | PNS | Production Number Short | Numeric | Generic Edit | 10 | 0 |
| 20 | F43121 | Purchase Order Receiver File | 163 | PR | PNS | Production Number Short | Numeric | Generic Edit | 10 | 0 |
| 21 | F43121Z | Receiver workfile | 212 | PW | PNS | Production Number Short | Numeric | Generic Edit | 10 | 0 |
| 22 | F43199 | P.O. Detail Ledger File - Flexible Version | 230 | OL | PNS | Production Number Short | Numeric | Generic Edit | 10 | 0 |
| TOP47: Electronic Commerce |
| 23 | F47122 | EDI Product Activity Data Detail - Inbound | 89 | MJ | PNS | Production Number Short | Numeric | Generic Edit | 10 | 0 |
| 24 | F47132 | EDI Purchase Order Change Detail - Inbound | 259 | SZ | PNS | Production Number Short | Numeric | Generic Edit | 10 | 0 |
| TOP48: Work Order Processing |
| 25 | F4801T | Work Order Master Tag File | 127 | WA | PNS | Production Number Short | Numeric | Generic Edit | 10 | 0 |
| 26 | F4801Z1 | Outbound Work Order Header | 222 | SY | PNS | Production Number Short | Numeric | Generic Edit | 10 | 0 |
