| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP17: Customer Service Management |
1 | F3111Z2 | Warranty Claim/Supplier Recovery processing | 96 | WP | PSN | Pick Slip Number | Numeric | Generic Edit | 8 | 0 |
TOP31: Shop Floor Control |
2 | F3111 | Work Order Parts List | 82 | WM | PSN | Pick Slip Number | Numeric | Generic Edit | 8 | 0 |
3 | F3111S | Purge - Shop Floor Parts List | 82 | WM | PSN | Pick Slip Number | Numeric | Generic Edit | 8 | 0 |
4 | F3111Z1 | Outbound Work Order Parts List | 96 | SZ | PSN | Pick Slip Number | Numeric | Generic Edit | 8 | 0 |
TOP40: Inventory/OP Base |
5 | F4011Z | Batch Receiver File - Order Details | 121 | SZ | PSN | Pick Slip Number | Numeric | Generic Edit | 8 | 0 |
6 | F4211Z1 | Sales Order Detail Unedited Transaction File | 115 | SZ | PSN | Pick Slip Number | Numeric | Generic Edit | 8 | 0 |
TOP42: Sales Management |
7 | F4211 | Sales Order Detail File | 102 | SD | PSN | Pick Slip Number | Numeric | Generic Edit | 8 | 0 |
8 | F42119 | Sales Order History File | 102 | SD | PSN | Pick Slip Number | Numeric | Generic Edit | 8 | 0 |
9 | F42199 | S.O. Detail Ledger File | 102 | SL | PSN | Pick Slip Number | Numeric | Generic Edit | 8 | 0 |
10 | F42UI11 | SO Detail Cache File (MBF) | 80 | ZD | PSN | Pick Slip Number | Numeric | Generic Edit | 8 | 0 |
11 | F42UI521 | Pick Slips Detail File | 86 | S9 | PSN | Pick Slip Number | Numeric | Generic Edit | 8 | 0 |
TOP47: Electronic Commerce |
12 | F47012 | EDI Purchase Order Detail - Inbound | 122 | SZ | PSN | Pick Slip Number | Numeric | Generic Edit | 8 | 0 |
13 | F47027 | EDI P.O. Acknowledgment Detail - Outbound | 122 | SZ | PSN | Pick Slip Number | Numeric | Generic Edit | 8 | 0 |
14 | F47037 | EDI Shipping Notice Detail - Outbound | 112 | SZ | PSN | Pick Slip Number | Numeric | Generic Edit | 8 | 0 |
15 | F470371 | EDI Shipping Notice Detail - Outbound | 128 | SZ | PSN | Pick Slip Number | Numeric | Generic Edit | 8 | 0 |
16 | F47047 | EDI Invoice Detail (Sales) - Outbound | 122 | SZ | PSN | Pick Slip Number | Numeric | Generic Edit | 8 | 0 |
17 | F47092 | EDI Request for Quote Detail - Inbound | 122 | SZ | PSN | Pick Slip Number | Numeric | Generic Edit | 8 | 0 |
18 | F47107 | EDI Response to RFQ Detail - Outbound | 122 | SZ | PSN | Pick Slip Number | Numeric | Generic Edit | 8 | 0 |
19 | F47132 | EDI Purchase Order Change Detail - Inbound | 123 | SZ | PSN | Pick Slip Number | Numeric | Generic Edit | 8 | 0 |
20 | F47147 | EDI P.O. Change Acknowledgment Detail - Outbound | 124 | SZ | PSN | Pick Slip Number | Numeric | Generic Edit | 8 | 0 |
TOPD3N: dcLINK (data collection) - DSI |
21 | FD3N1601 | Pallet Tracking Table 1 | 12 | PH | PSN | Pick Slip Number | Numeric | Generic Edit | 8 | 0 |
22 | FD3N911 | dcLINK Interface - Cache UCC128 Numbers - Table | 9 | UC | PSN | Pick Slip Number | Numeric | Generic Edit | 8 | 0 |
TOPF31: Lean Transactions |
23 | FF31111 | Lean Transaction Parts List | 56 | PL | PSN | Pick Slip Number | Numeric | Generic Edit | 8 | 0 |
24 | FF31111S | Purge - Lean Transaction Parts List | 56 | PR | PSN | Pick Slip Number | Numeric | Generic Edit | 8 | 0 |