| 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 | 167 | SZ | CMGL | Commitment Method | Character | UDC | 1 | 0 |
2 | F41001 | Inventory Constants | 45 | CI | CMGL | Commitment Method | Character | UDC | 1 | 0 |
3 | F49211 | Sales Order Detail File - Tag File | 123 | UD | CMGL | Commitment Method | Character | UDC | 1 | 0 |
4 | F49211Z1 | Sales Order Detail Tag Unedited Transaction File | 142 | S1 | CMGL | Commitment Method | Character | UDC | 1 | 0 |
5 | F49219 | Sales Order Detail - Tag History File | 100 | UD | CMGL | Commitment Method | Character | UDC | 1 | 0 |
TOP41: Inventory Management |
6 | F4101 | Item Master | 119 | IM | CMGL | Commitment Method | Character | UDC | 1 | 0 |
7 | F4101A | Item File | 71 | IM | CMGL | Commitment Method | Character | UDC | 1 | 0 |
8 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 134 | SZ | CMGL | Commitment Method | Character | UDC | 1 | 0 |
9 | F4102 | Item Branch File | 119 | IB | CMGL | Commitment Method | Character | UDC | 1 | 0 |
TOP42: Sales Management |
10 | F42UI521 | Pick Slips Detail File | 108 | S9 | CMGL | Commitment Method | Character | UDC | 1 | 0 |
11 | F470371T | Tag for F470371- EDI shipping Notice Detail - Outbound | 11 | UZ | CMGL | Commitment Method | Character | UDC | 1 | 0 |
TOP42B: Sales Order Entry |
12 | F49299 | S.O. Detail Tag Ledger File | 123 | UD | CMGL | Commitment Method | Character | UDC | 1 | 0 |
TOP47: Electronic Commerce |
13 | F47012 | EDI Purchase Order Detail - Inbound | 168 | SZ | CMGL | Commitment Method | Character | UDC | 1 | 0 |
14 | F47027 | EDI P.O. Acknowledgment Detail - Outbound | 168 | SZ | CMGL | Commitment Method | Character | UDC | 1 | 0 |
15 | F47047 | EDI Invoice Detail (Sales) - Outbound | 168 | SZ | CMGL | Commitment Method | Character | UDC | 1 | 0 |
16 | F47092 | EDI Request for Quote Detail - Inbound | 168 | SZ | CMGL | Commitment Method | Character | UDC | 1 | 0 |
17 | F47107 | EDI Response to RFQ Detail - Outbound | 168 | SZ | CMGL | Commitment Method | Character | UDC | 1 | 0 |
18 | F47132 | EDI Purchase Order Change Detail - Inbound | 169 | SZ | CMGL | Commitment Method | Character | UDC | 1 | 0 |
19 | F47147 | EDI P.O. Change Acknowledgment Detail - Outbound | 170 | SZ | CMGL | Commitment Method | Character | UDC | 1 | 0 |
TOP89: Conversion Programs |
20 | F42119B | Sales Order History File - temporary for upgrade (2) | 19 | SD | CMGL | Commitment Method | Character | UDC | 1 | 0 |
21 | F4211B | Sales Order Detail File - temporary for upgrade (2) | 19 | SD | CMGL | Commitment Method | Character | UDC | 1 | 0 |
TOPH91: Design Tools |
22 | F98TC002 | Table Conversion Normalized 1 | 7 | TN | CMGL | Commitment Method | Character | UDC | 1 | 0 |
23 | F98TC01 | Table Conversion UnNormalized | 11 | TC | CMGL | Commitment Method | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.