| 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 | 121 | SY | RQSJ | Date - Requested Ship | Date | Generic Edit | 6 | 0 |
| 2 | F49211 | Sales Order Detail File - Tag File | 104 | UD | RQSJ | Date - Requested Ship | Date | Generic Edit | 6 | 0 |
| 3 | F49211Z1 | Sales Order Detail Tag Unedited Transaction File | 123 | S1 | RQSJ | Date - Requested Ship | Date | Generic Edit | 6 | 0 |
| 4 | F49219 | Sales Order Detail - Tag History File | 81 | UD | RQSJ | Date - Requested Ship | Date | Generic Edit | 6 | 0 |
| TOP40R: Demand Scheduling |
| 5 | F40R11 | Demand Detail | 14 | DD | RQSJ | Date - Requested Ship | Date | Generic Edit | 6 | 0 |
| 6 | F40R121 | CUM Required Quantities Detail Table | 3 | CR | RQSJ | Date - Requested Ship | Date | Generic Edit | 6 | 0 |
| 7 | F40R41 | Demand History | 19 | DI | RQSJ | Date - Requested Ship | Date | Generic Edit | 6 | 0 |
| 8 | F47173 | EDI Demand Scheduling Detail | 21 | ES | RQSJ | Date - Requested Ship | Date | Generic Edit | 6 | 0 |
| TOP42: Sales Management |
| 9 | F4201 | Sales Order Header File | 97 | SH | RQSJ | Date - Requested Ship | Date | Generic Edit | 6 | 0 |
| 10 | F42019 | Sales Order Header History File | 97 | SH | RQSJ | Date - Requested Ship | Date | Generic Edit | 6 | 0 |
| 11 | F42UI01 | SO Header Cache File (MBF) | 135 | ZH | RQSJ | Date - Requested Ship | Date | Generic Edit | 6 | 0 |
| TOP42B: Sales Order Entry |
| 12 | F49299 | S.O. Detail Tag Ledger File | 104 | UD | RQSJ | Date - Requested Ship | Date | Generic Edit | 6 | 0 |
| TOP47: Electronic Commerce |
| 13 | F47011 | EDI Purchase Order Header - Inbound | 109 | SY | RQSJ | Date - Requested Ship | Date | Generic Edit | 6 | 0 |
| 14 | F47026 | EDI P.O. Acknowledgment Header - Outbound | 121 | SY | RQSJ | Date - Requested Ship | Date | Generic Edit | 6 | 0 |
| 15 | F47036 | EDI Shipping Notice Header - Outbound | 77 | SY | RQSJ | Date - Requested Ship | Date | Generic Edit | 6 | 0 |
| 16 | F470371 | EDI Shipping Notice Detail - Outbound | 47 | SZ | RQSJ | Date - Requested Ship | Date | Generic Edit | 6 | 0 |
| 17 | F47046 | EDI Invoice Header (Sales) - Outbound | 142 | SY | RQSJ | Date - Requested Ship | Date | Generic Edit | 6 | 0 |
| 18 | F47091 | EDI Request for Quote Header - Inbound | 109 | SY | RQSJ | Date - Requested Ship | Date | Generic Edit | 6 | 0 |
| 19 | F47106 | EDI Response to RFQ Header - Outbound | 118 | SY | RQSJ | Date - Requested Ship | Date | Generic Edit | 6 | 0 |
| 20 | F47131 | EDI Purchase Order Change Header - Inbound | 106 | SY | RQSJ | Date - Requested Ship | Date | Generic Edit | 6 | 0 |
| 21 | F47146 | EDI P.O. Change Acknowledgment Header - Outbound | 119 | SY | RQSJ | Date - Requested Ship | Date | Generic Edit | 6 | 0 |
