| 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 |
| TOP41F: Apparel Management |
| 10 | FCW09 | Item Revisions Work File | 23 | WR | CMGL | Commitment Method | Character | UDC | 1 | 0 |
| 11 | FCW10 | Item Branch Work File | 11 | WB | CMGL | Commitment Method | Character | UDC | 1 | 0 |
| TOP42: Sales Management |
| 12 | F42UI521 | Pick Slips Detail File | 108 | S9 | CMGL | Commitment Method | Character | UDC | 1 | 0 |
| 13 | F470371T | Tag for F470371- EDI shipping Notice Detail - Outbound | 11 | UZ | CMGL | Commitment Method | Character | UDC | 1 | 0 |
| TOP42B: Sales Order Entry |
| 14 | F49299 | S.O. Detail Tag Ledger File | 123 | UD | CMGL | Commitment Method | Character | UDC | 1 | 0 |
| TOP47: Electronic Commerce |
| 15 | F47012 | EDI Purchase Order Detail - Inbound | 168 | SZ | CMGL | Commitment Method | Character | UDC | 1 | 0 |
| 16 | F47027 | EDI P.O. Acknowledgment Detail - Outbound | 168 | SZ | CMGL | Commitment Method | Character | UDC | 1 | 0 |
| 17 | F47047 | EDI Invoice Detail (Sales) - Outbound | 168 | SZ | CMGL | Commitment Method | Character | UDC | 1 | 0 |
| 18 | F47092 | EDI Request for Quote Detail - Inbound | 168 | SZ | CMGL | Commitment Method | Character | UDC | 1 | 0 |
| 19 | F47107 | EDI Response to RFQ Detail - Outbound | 168 | SZ | CMGL | Commitment Method | Character | UDC | 1 | 0 |
| 20 | F47132 | EDI Purchase Order Change Detail - Inbound | 169 | SZ | CMGL | Commitment Method | Character | UDC | 1 | 0 |
| 21 | F47147 | EDI P.O. Change Acknowledgment Detail - Outbound | 170 | SZ | CMGL | Commitment Method | Character | UDC | 1 | 0 |
| TOP89: Conversion Programs |
| 22 | F42119B | Sales Order History File - temporary for upgrade (2) | 19 | SD | CMGL | Commitment Method | Character | UDC | 1 | 0 |
| 23 | F4211B | Sales Order Detail File - temporary for upgrade (2) | 19 | SD | CMGL | Commitment Method | Character | UDC | 1 | 0 |
| TOPH91: Design Tools |
| 24 | F98TC002 | Table Conversion Normalized 1 | 7 | TN | CMGL | Commitment Method | Character | UDC | 1 | 0 |
| 25 | 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.
