| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP40: Inventory/OP Base |
1 | F4211Z1 | Sales Order Detail Unedited Transaction File | 227 | SZ | XDCK | Cross-Docking Flag | Character | Generic Edit | 1 | 0 |
TOP41: Inventory Management |
2 | F4101 | Item Master | 175 | IM | XDCK | Cross-Docking Flag | Character | Generic Edit | 1 | 0 |
3 | F4101A | Item File | 114 | IM | XDCK | Cross-Docking Flag | Character | Generic Edit | 1 | 0 |
4 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 218 | SZ | XDCK | Cross-Docking Flag | Character | Generic Edit | 1 | 0 |
5 | F4102 | Item Branch File | 147 | IB | XDCK | Cross-Docking Flag | Character | Generic Edit | 1 | 0 |
TOP42: Sales Management |
6 | F4211 | Sales Order Detail File | 214 | SD | XDCK | Cross-Docking Flag | Character | Generic Edit | 1 | 0 |
7 | F42119 | Sales Order History File | 214 | SD | XDCK | Cross-Docking Flag | Character | Generic Edit | 1 | 0 |
8 | F42199 | S.O. Detail Ledger File | 214 | SL | XDCK | Cross-Docking Flag | Character | Generic Edit | 1 | 0 |
9 | F42UI12 | Sales Order Detail Cache 2 (MBF) | 98 | ZD | XDCK | Cross-Docking Flag | Character | Generic Edit | 1 | 0 |
10 | F47027T | Tag for F47027 - EDI P.O. Acknowledgment Detail - Outbound | 40 | UZ | XDCK | Cross-Docking Flag | Character | Generic Edit | 1 | 0 |
11 | F470371T | Tag for F470371- EDI shipping Notice Detail - Outbound | 88 | UZ | XDCK | Cross-Docking Flag | Character | Generic Edit | 1 | 0 |
12 | F47047T | Tag for F47047- EDI Invoice Detail (Sales) - Outbound | 40 | UZ | XDCK | Cross-Docking Flag | Character | Generic Edit | 1 | 0 |
13 | F47107T | Tag for F47107- EDI Response to RFQ Detail - Outbound | 40 | UZ | XDCK | Cross-Docking Flag | Character | Generic Edit | 1 | 0 |
14 | F47147T | Tag F47147 - EDI P.O. Change Acknowledgment Detail-Outbound | 40 | UZ | XDCK | Cross-Docking Flag | Character | Generic Edit | 1 | 0 |
TOP42B: Sales Order Entry |
15 | F4011ZT | Batch Receiver File - Order Details Tag | 32 | UZ | XDCK | Cross-Docking Flag | Character | Generic Edit | 1 | 0 |
16 | F42420 | Audit Log Transaction | 88 | AL | XDCK | Cross-Docking Flag | Character | Generic Edit | 1 | 0 |
17 | F47012T | EDI Purchase Order Detail Tag - Inbound | 32 | UZ | XDCK | Cross-Docking Flag | Character | Generic Edit | 1 | 0 |
18 | F47092T | EDI Request for Quote Detail Tag - Inbound | 32 | UZ | XDCK | Cross-Docking Flag | Character | Generic Edit | 1 | 0 |
19 | F47132T | EDI Purchase Order Change Detail Tag - Inbound | 32 | UZ | XDCK | Cross-Docking Flag | Character | Generic Edit | 1 | 0 |
TOP43: Procurement |
20 | F4311Z | Purchase Order Generator File | 231 | PW | XDCK | Cross-Docking Flag | Character | Generic Edit | 1 | 0 |
21 | F43121 | Purchase Order Receiver File | 134 | PR | XDCK | Cross-Docking Flag | Character | Generic Edit | 1 | 0 |
22 | F43121Z | Receiver workfile | 162 | PW | XDCK | Cross-Docking Flag | Character | Generic Edit | 1 | 0 |
23 | F43121Z1 | Receipts Unedited Transaction Table | 194 | SZ | XDCK | Cross-Docking Flag | Character | Generic Edit | 1 | 0 |
TOP47: Electronic Commerce |
24 | F47072 | EDI Receiving Advice Detail - Inbound | 247 | SZ | XDCK | Cross-Docking Flag | Character | Generic Edit | 1 | 0 |
25 | F47077 | EDI Receiving Advice Detail - Outbound | 236 | SZ | XDCK | Cross-Docking Flag | Character | Generic Edit | 1 | 0 |