| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP40: Inventory/OP Base |
1 | F4011Z | Batch Receiver File - Order Details | 85 | SZ | SONE | Units - Future Quantity Committed | Numeric | Generic Edit | 15 | 0 |
2 | F4211Z1 | Sales Order Detail Unedited Transaction File | 82 | SZ | SONE | Units - Future Quantity Committed | Numeric | Generic Edit | 15 | 0 |
TOP42: Sales Management |
3 | F4211 | Sales Order Detail File | 69 | SD | SONE | Units - Future Quantity Committed | Numeric | Generic Edit | 15 | 0 |
4 | F42119 | Sales Order History File | 69 | SD | SONE | Units - Future Quantity Committed | Numeric | Generic Edit | 15 | 0 |
5 | F42199 | S.O. Detail Ledger File | 69 | SL | SONE | Units - Future Quantity Committed | Numeric | Generic Edit | 15 | 0 |
6 | F42UI11 | SO Detail Cache File (MBF) | 57 | ZD | SONE | Units - Future Quantity Committed | Numeric | Generic Edit | 15 | 0 |
7 | F42UI12 | Sales Order Detail Cache 2 (MBF) | 77 | ZD | SONE | Units - Future Quantity Committed | Numeric | Generic Edit | 15 | 0 |
8 | F42UI130 | Commitment Work File | 60 | ZC | SONE | Units - Future Quantity Committed | Numeric | Generic Edit | 15 | 0 |
9 | F42UI521 | Pick Slips Detail File | 65 | S9 | SONE | Units - Future Quantity Committed | Numeric | Generic Edit | 15 | 0 |
TOP42W: Fulfilment Management |
10 | F427UI01 | Release Fulfillment Work File | 8 | RF | SONE | Units - Future Quantity Committed | Numeric | Generic Edit | 15 | 0 |
TOP47: Electronic Commerce |
11 | F47012 | EDI Purchase Order Detail - Inbound | 86 | SZ | SONE | Units - Future Quantity Committed | Numeric | Generic Edit | 15 | 0 |
12 | F47027 | EDI P.O. Acknowledgment Detail - Outbound | 86 | SZ | SONE | Units - Future Quantity Committed | Numeric | Generic Edit | 15 | 0 |
13 | F47037 | EDI Shipping Notice Detail - Outbound | 83 | SZ | SONE | Units - Future Quantity Committed | Numeric | Generic Edit | 15 | 0 |
14 | F470371 | EDI Shipping Notice Detail - Outbound | 93 | SZ | SONE | Units - Future Quantity Committed | Numeric | Generic Edit | 15 | 0 |
15 | F47047 | EDI Invoice Detail (Sales) - Outbound | 86 | SZ | SONE | Units - Future Quantity Committed | Numeric | Generic Edit | 15 | 0 |
16 | F47092 | EDI Request for Quote Detail - Inbound | 86 | SZ | SONE | Units - Future Quantity Committed | Numeric | Generic Edit | 15 | 0 |
17 | F47107 | EDI Response to RFQ Detail - Outbound | 86 | SZ | SONE | Units - Future Quantity Committed | Numeric | Generic Edit | 15 | 0 |
18 | F47132 | EDI Purchase Order Change Detail - Inbound | 87 | SZ | SONE | Units - Future Quantity Committed | Numeric | Generic Edit | 15 | 0 |
19 | F47147 | EDI P.O. Change Acknowledgment Detail - Outbound | 88 | SZ | SONE | Units - Future Quantity Committed | Numeric | Generic Edit | 15 | 0 |
20 | F47UI001 | ASN Extract Work File | 50 | SZ | SONE | Units - Future Quantity Committed | Numeric | Generic Edit | 15 | 0 |